Effective knowledge management (KM) enhances products, improves operational efficiency, speeds deployment, increases sales and profits, and creates customer satisfaction. Data warehousing provides an infrastructure that enables business to extract, and store vast amounts of corporate data. The purpose of data warehouse is to empower the knowledge workers with information that allows them to mak...

The distributed data warehouse supports the decision makers by providing a single view of data even though that data is physically distributed across multiple data warehouses in multiple systems at different branches. This environment has changed the face of computing and offered quick and precise solutions for a variety of complex problems for different fields. This paper reviews distributed d...

Data Warehouse is frequently organized as collection of multidimensional data cubes, which represent data in the form of data values, called measures, associated with multiple dimensions and their multiple levels. However, some application areas need more expressive model for description its data. This paper presents the extension of classical multidimensional model to make Data Warehouse more ...

This paper analyzed the model design process of data warehouse project and the various factors which affected the performance in data warehouse model design. Then the author introduced the multistage fuzzy comprehensive evaluation method, and studied its application to the data warehouse’s model performance evaluation, and gave the performance measure model of data warehouse based on multistage...

Der vorliegende Beitrag beschreibt das Vorgehen zur Realisierung eines integrierten Metadatenmanagements im Data-Warehouse-Projekt einer Schweizer Universalbank. Untersucht wurde insbesondere, inwieweit das Common Warehouse Metamodell der Object Management Group geeignet ist, als Referenzmodell für die Metadatenbasis herangezogen zu werden. Nach einem Überblick über das Referenzmodell werden da...

Data warehouses have become an instant phenomenon in many large organizations that deal with a massive amount of information. Drawing on the experiences from the systems development field, we surmise that an effective CASE tool will enhance the success of warehouse implementations. Thus, we present a CASE tool designed to generate the SQL queries necessary to build a warehouse from a set of ope...

Typical Intelligent Decision Support System is 4-based, its design composes of Data Warehouse, Online Analytical Processing, Data Mining and Decision Supporting based on models, which is called Decision Support System Based on Data Warehouse (DSSBDW). This way takes ETL,OLAP and DM as its implementing means, and integrates traditional model-driving DSS and data-driving DSS into a whole. For thi...

How to provide construction managers with information about and insight into the existing data so as to make decision more efficiently without interrupting the daily work of an On-Line Transaction Processing (OLTP) system is a problem during the construction management process. To solve this problem, the integration of a Data Warehouse and a Decision Support System (DSS) seems to be efficient. ...

Data warehouse systems are used for decision-making purposes. The Online Analytical Processing (OLAP) tools are commonly used to query and analysis of results on such systems. It is complex task for non-technical users (executives, managers etc.,) to query the data warehouse using OLAP tool keeping in view the schema knowledge. For such data warehouse users, a natural language interface is a vi...

The integration of a Data Warehouse and a Decision Support System (DSS) can provide construction managers with sufficient information for decision making without interrupting daily work of an On-Line Transaction Processing system. In this paper, the concepts of the data warehouse, On-Line Analysis Processing and DSS are first reviewed. The method of creating a data warehouse is then shown, chan...