audi
Data Warehousing - Overview
The term "Data Warehouse" was first coined by Bill Inmon in 1990. He said that Data warehouse is subject Oriented, Integrated, Time-Variant and nonvolatile collection of data.This data helps in supporting decision making process by analyst in an organization
The operational database undergoes the per day transactions which causes the frequent changes to the data on daily basis.But if in future the business executive wants to analyse the previous feedback on any data such as product,supplier,or the consumer data. In this case the analyst will be having no data available to analyse because the previous data is updated due to transactions.
The Data Warehouses provide us generalized and consolidated data in multidimensional view. Along with generalize and consolidated view of data the Data Warehouses also provide us Online Analytical Processing (OLAP) tools. These tools help us in interactive and effective analysis of data in multidimensional space. This analysis results in data generalization and data mining.
The data mining functions like association ,clustering ,classification, prediction can be integrated with OLAP operations to enhance interactive mining of knowledge at multiple level of abstraction. That's why data warehouse has now become important platform for data analysis and online analytical processing.
Understanding Data Warehouse
• The Data Warehouse is that database which is kept separate from the organization's operational database.
• There is no frequent updation done in data warehouse.
• Data warehouse possess consolidated historical data which help the organization to analyse it's business.
• Data warehouse helps the executives to organize, understand and use their data to take strategic decision.
• Data warehouse systems available which helps in integration of diversity of application systems.
• The Data warehouse system allows analysis of consolidated historical data analysis.
Definition
Data warehouse is
The term "Data Warehouse" was first coined by Bill Inmon in 1990. He said that Data warehouse is subject Oriented, Integrated, Time-Variant and nonvolatile collection of data.This data helps in supporting decision making process by analyst in an organization
The operational database undergoes the per day transactions which causes the frequent changes to the data on daily basis.But if in future the business executive wants to analyse the previous feedback on any data such as product,supplier,or the consumer data. In this case the analyst will be having no data available to analyse because the previous data is updated due to transactions.
The Data Warehouses provide us generalized and consolidated data in multidimensional view. Along with generalize and consolidated view of data the Data Warehouses also provide us Online Analytical Processing (OLAP) tools. These tools help us in interactive and effective analysis of data in multidimensional space. This analysis results in data generalization and data mining.
The data mining functions like association ,clustering ,classification, prediction can be integrated with OLAP operations to enhance interactive mining of knowledge at multiple level of abstraction. That's why data warehouse has now become important platform for data analysis and online analytical processing.
Understanding Data Warehouse
• The Data Warehouse is that database which is kept separate from the organization's operational database.
• There is no frequent updation done in data warehouse.
• Data warehouse possess consolidated historical data which help the organization to analyse it's business.
• Data warehouse helps the executives to organize, understand and use their data to take strategic decision.
• Data warehouse systems available which helps in integration of diversity of application systems.
• The Data warehouse system allows analysis of consolidated historical data analysis.
Definition
Data warehouse is