Data Warehouse Architecture – Concept and Models
According to William Inmon, data warehouse is a subject-oriented, integrated, time-variant, and non-volatile collection of data in support of the management’s decision-making process. Data warehouse is a database containing data that usually represents the business history of an organization. This historical data is used for analysis that supports business decisions at many levels, from strategic planning to performance evaluation of a discrete organizational unit. It provides an effective integration of operational databases into an environment that enables strategic use of data. These technologies include relational and MDDB management systems, client/server architecture, meta-data modelling and repositories, graphical user interface and much more. The emergence of cross discipline domain such as knowledge management in finance, health and e-commerce have proved that vast amount of data need to be analyzed. The evolution of data in data warehouse can provide multiple dataset dimensions to solve various problems. Thus, critical decision making process of this dataset Continue reading