Home / Dubai Municipality to embark on data warehouse project

Dubai Municipality to embark on data warehouse project

Dubai Municipality is to create a centralised data warehouse containing statistics from its different departments using technology from Cognos and IBM.

The project will involve extracting data from disparate departmental databases and placing it into a data warehouse based on Oracle’s 10g database using IBM’s Ascential and Websphere products.

This will be supported by Cognos 8 business intelligence tools which will enable analysis of and reporting from the information.

Nasser Tufail, managing director of BSG — which distributes Cognos products in the region and which will deploy the Cognos solution for the Municipality — explained the benefits of the new system.

“The biggest benefit is being able to disseminate information to different kinds of users based on their needs,” he stated.

“You will have the operations people who need one kind of information, the senior executive management who need a very high level of summarised information to make decisions and analysts who need to observe trends and build forecast models, trends and statistical indicators,” he added.

Tufail explained that having all the statistical information from the different departments held on separate databases was causing accuracy problems, duplication of data and preventing the Municipality from creating ad hoc reports containing more detailed information.

“The problems were basically because if things changed in one system they didn’t get reflected in another,” he said.

“There were accuracy problems, redundancy, basically problems with things being replicated in multiple systems. There was no way for end-users to create ad hoc reports and you couldn’t actually go down into that information and zero in at the detailed level to look for information, or things that would not be obvious to you using a static tool.”

He added that the information to be held on the system would initially be accessible to internal users such as executive management, business analysts and operations staff. The next phase of the project, which is due to begin around the end of next year, will make information available to the public.

Follow us to get the most comprehensive technology news in UAE delivered fresh from our social media accounts on Facebook, Twitter, Youtube, and listen to our Weekly Podcast. Click here to sign up for our weekly newsletter on curated technology news in the Middle East and Worldwide.

REGISTER NOW | Webinar Event | Security you can bank on – Safeguarding the Middle East’s financial sector

Presented in partnership with security and network specialist Cybereason, the second in the three part webinar series will bring together a panel of experts to discuss how banks and financial institutions are evolving their service offering while simultaneously staying one step ahead of the cyber criminals who seek to bring their operations crashing to the ground.