Data Warehousing for Abu Dhabi Food Control Authority

Data Warehousing
Student Name:
Course name:
Student Id:
Abu Dhabi Food
Control Authority

Selected Project
 Extensive data available in Abu Dhabi
Food Control Authority, and how these
data can be used to classify these data
into smart reports that help in decision-
making, prioritizing and shaping the
future emirates of Abu Dhabi in food
safety and food security.

Project business case
 The purpose of the project is to implement
smart business system software as well as
data warehouse in terms of Information
System to protect confidential information.
 The system help Abu Dhabi food control
Authority to build a data warehouse which
include all information and needful data. It
can integrate, enhance and preserve the key
accurate information across the business
organization.

Project business case (contd.)
 It also helps to provide a common data model for all
types of data which count regardless of the data
sources and can add on values for business operation
and all other applications.
 In order to store the information Oracle database
connectivity will be used to fetch, insert and update
key data in the database table.
 Oracle ERP system will be used to access information
stored in the database by running needful queries.