Data warehouse design solutions
Data warehouse design solutions
The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
A Data Warehouse Conceptual Data Model
SSDBM '04 Proceedings of the 16th International Conference on Scientific and Statistical Database Management
Designing Data Warehouses for Supply Chain Management
CEC '04 Proceedings of the IEEE International Conference on E-Commerce Technology
The Prototype Research of a Web-Based DSS Intelligent Agent Over Data Warehouse
WI '04 Proceedings of the 2004 IEEE/WIC/ACM International Conference on Web Intelligence
| Hi-index | 0.00 |
This paper provides an overall architecture to support all levels of data access and analysis against internal and external data in a variety of formats (any data, any where). This star architecture promotes interoperability between applications and databases. It promotes query optimized data warehouse. A star schema pattern language is presented to support data ware house building. The patterns are split into four main sub models: the conceptual, the logical, the physical, and the summary sub model. The model is composed of three layers: the virtual data warehouse layer (VDW), virtual data warehouse engine (VDWE), and the end user layer (EUL). The VDW layer combines all the internal and external databases as a one virtual data warehouse. The intelligent VDWE layer provides intelligent analytical processing to the decision makers. This layer also offers administrative tools for data administration. There is a dynamic metadata repository associated with the engine to support the heterogeneous joins between these different internal and external data stores. There are associated software agents to notify the engine the exception conditions occurrences. The business rules and constraints are enforced by the engine. The end user layer (EUL) encapsulates access code and allows information technology personnel to manage and optimize the model. A case study is presented to demonstrate the paper concepts.