Building Quick and Accurate Structure for Data Warehouse
暂无分享,去创建一个
Data Warehouse is Described as a set of subject oriented ,integration , non volatile and time variant system to support data decision system (DSS) and online response to manager analytical queries. These kind of queries are complicated and they done on the large amount of data and they used for data decision system and online analytical processing for data mining .Data warehouse and online analytical processing are necessary to support manager decision. In this research , first we describe data warehousing and consider some kind of data warehouse scheme and how should we choose on of them. Main goal of this research , is acceleration of selecting scheme in data warehouse design , for this goal first we consider all of related works and then we define an algorithm to select data warehouse scheme and finally we test accuracy of the algorithm . To implement this test , we use Microsoft c#.net and Sql server to design data warehouse and some assumed data
[1] Atish P. Sinha,et al. A comparison of data warehousing methodologies , 2005, CACM.
[2] Paul Gray,et al. Decision support in the data warehouse , 1997 .
[3] Daniel L. Moody,et al. From enterprise models to dimensional models: a methodology for data warehouse and data mart design , 2000, DMDW.
[4] Timos K. Sellis,et al. MAC: Conceptual data modeling for OLAP , 2001, DMDW.
[5] Jiawei Han,et al. Data Mining: Concepts and Techniques , 2000 .