Database management systems developed by researchers at Northumbria University have helped the Government of Gibraltar consolidate 36 different address lists into one, intelligent database of commercial and domestic addresses in the country.
Until recently, Gibraltar’s public services such as the post office, telecoms, utilities and ambulance service, kept separate address lists each with their own personalised formats. This created difficulties and barriers to inter-service communication, a duplication of effort, and inefficient data update. While many departments had pursued automation, this was done in a fragmented manner without standards or consistency.
UK company Atlantic Geomatics (AGUK), working together with researchers from Northumbria University, has now produced a database of all addresses in Gibraltar which, when adopted by the Government through legislation, will trigger the process of a major practice change in Gibraltar. It replaces the 36 lists with a single, spatial official address register that contains geographic data and postcodes for all addresses in Gibraltar for the first time.
“We developed a way of migrating rich object-based and semi-structured databases into newer databases without any loss of data,” explains Akhtar Ali from Northumbria’s Computer and Electronic Security Systems Department. “The database migration and conversion method ensures that both source and target databases are equivalent and that no data is lost during the process.”
The work not only enabled AGUK to secure the Gibraltar contract, safeguarding jobs at the company, but it will also have a major impact on the people of Gibraltar. This new database will improve the delivery of various services including mail delivery, emergency services, utilities and telecoms.
Case studies
- Data mining technique developed at Northumbria helps call centre improve efficiency
- Record-keeping strategies for the digital age
- Northumbria University researchers help people with Parkinson’s to walk
- Making it work: involving older people in their own care
- Conserving modern art
- Northumbria researchers help large corporates improve their products
- Digitising the construction industry
- Virtual city provides an interactive platform for architects, planners, heritage and the arts
- Institutional capacity building for cultural built heritage in south east Europe
- Innovation method creates commercial value for business
- 20th Century Design from Shipley to New York
- Creating immersive audio-visual experiences
- KTP improves efficiency and reduces waste at iNPIPE Products
- Books and pop music: challenging conventions that define high and low culture
- Before Depression - a literary perspective on mental health
- Re-assessing own language use in English language teaching
- Improving survival and wellbeing in times of disaster
- Social justice for migrant workers
- Understanding the Scottish Diaspora
- Critical thinking in the digital era
- Northumbria University researcher inspires physics students
- Northumbria researchers advise government on breakfast clubs
- Paving the way for peer-to-peer health advice
- Brief chat with GP helps heavy drinkers cut down
- North East maintains its ‘voice’ in Central Government
- Reducing homelessness among young adults
- Athletes benefit from the therapeutic qualities of cherry juice
- Recognising the needs and interests of women and children in disasters
- Student Law Office Benefits Students and the Community
- Bringing 18th century literature to a modern audience
- Northumbria researchers help tool manufacturer cut costs and increase product lifetime
- Supporting the Solar Energy Market
- Northumbria researchers help give Gibraltar its first official address register
- A warm welcome for female comic book fans
- A KTP with North Tyneside Council transforms sheltered housing
More events
Upcoming events
Broken Bonds: New Perspectives on Marital Breakdown
The Great Hall
-
Supporting Survivors of Sexual Violence and Abuse Conference 2026
CCE1 - City Campus East 1
-
