Dunnes stores datawarehouse
- This is a preview of the essay.
To view the full text you must login!
DATAWAREHOUSING IN DUNNES STORES
First would be to define the scope of the datawarehouse. Defining a clear and tangible mission for the project is crucial, an example for a division of Dunnes stores would be an ability to review, analyse and track historical data across all stores and all departments so that it would be possible to see trends and help decision making. The goal of the Datawarehouse is to enable the end users to access a comprehensive view of all the information within the organisation as well as external information.
Cost:
Most operational data is stored in a relational database, these databases have a lot of tables with as little attributes as possible. This allows for quick updates but are not query friendly (SQL querys must have multiple joins). Datawarehouses pull in information from the whole company and have few tables with many attributes, these tables can contain a lot of redundant information which greatly increases the size of the database. The storage for a datawarehouse can therefore run into gigabytes and terabytes. The DBMS that is selected to run the datawarehouse will have to support very large databases (VLDBS). The database needs to be exapandable as large pieces of information will be batch uploaded on defined time schedules.
Data:
Lets look at the information that would be extracted from the operational database from within the company as well as external sources...