Data Warehousing and Current Trends
Data warehousing and current trends
Submitted to:
Mr. S. Ramanathan
TABLE OF CONTENTS
1. Executive Summary 2. Data warehousing basics, difference from database and its business implication 3. Data mining, businesses using it and how 4. ETL technology, businesses using it and how 5. Tools used 6. Data mart and difference in business implication 7. References
EXECUTIVE SUMMARY
This study takes an insight into the usage of data warehousing and data mining techniques to enhance the productivity of the business. The study of the processes is analysed so as to get the need of adaptation according to inherent demands of these industries in near future. The main topics we are discussing here are: a) Data warehousing b) Data Mining c) ETL d) Data Mart
An attempt has been made to analyse different ways of using these for the enhancement in the different field.
Data warehousing and current trends.
Data Warehouse
A data warehouse is a relational database that is used for reporting and data analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources.
In other words, the data in a data warehouse is made up of snapshots of a business’s multiple operational data-bases. It comprises of software and hardware optimized for executive information systems (EIS) and decision support systems and is combined to run on-line analytical processing (OLAP), rather than the on-line transaction processing which represents the operations world.
The data stored in the warehouse is uploaded from the operational systems (such as marketing, sales etc.), ERP, CRM etc. as shown in the figure below. The data may go through an operational data store for additional operations before they are used in the DW for
Submitted to:
Mr. S. Ramanathan
TABLE OF CONTENTS
1. Executive Summary 2. Data warehousing basics, difference from database and its business implication 3. Data mining, businesses using it and how 4. ETL technology, businesses using it and how 5. Tools used 6. Data mart and difference in business implication 7. References
EXECUTIVE SUMMARY
This study takes an insight into the usage of data warehousing and data mining techniques to enhance the productivity of the business. The study of the processes is analysed so as to get the need of adaptation according to inherent demands of these industries in near future. The main topics we are discussing here are: a) Data warehousing b) Data Mining c) ETL d) Data Mart
An attempt has been made to analyse different ways of using these for the enhancement in the different field.
Data warehousing and current trends.
Data Warehouse
A data warehouse is a relational database that is used for reporting and data analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources.
In other words, the data in a data warehouse is made up of snapshots of a business’s multiple operational data-bases. It comprises of software and hardware optimized for executive information systems (EIS) and decision support systems and is combined to run on-line analytical processing (OLAP), rather than the on-line transaction processing which represents the operations world.
The data stored in the warehouse is uploaded from the operational systems (such as marketing, sales etc.), ERP, CRM etc. as shown in the figure below. The data may go through an operational data store for additional operations before they are used in the DW for