Telecom Location Management Using MapViewer

As a result of the Telecom shared services split and the need to manage their data more effectively, Terralink was contracted to design, and build:
- a new database to automate the supply of geo-spatial data.
- a centralised repository for address information.
- tools for Telecom users to automatically verify and update new addresses.
Telecom’s Location Management project was responsible for providing this service and required Telecom to migrate existing location information and applications to a new database hosted on a shared Oracle Locator server architecture.
This database and application provides address updates and verification as well as replicating nightly the geo-spatial location data from Terralink International Limited.
The introduction of the new Oracle Locator server as a single master Location environment within Telecom:
- supports the separated application environments among Retail, Wholesale and Chorus.
- reduce the number of sources of address data throughout Telecom, as a single master to share common data among the business groups.
- provides a rules-based data update entry point for the creation of new and changed addresses within the current 2.73 million service address database.
The implementation of the Location Management project in two phases is presented describing Phase One which established the Location Management Server, with a fully populated and functional system running at Telecom and Phase Two which established the interfaces, including the Address GUI for address searching and maintenance.
This presentation describes the architecture using the Oracle Fusion Middleware MapViewer and the connection with the database PL/SQL procedure and triggers.
The MapViewer GUI is displayed showing how addresses are searched, created and maintained for all of New Zealand and how existing systems are integrated.
Some insights into the creation of a new database, application and software for a large corporation are also discussed.