Data Warehouse

14,000,000 Leading Edge Experts on the ideXlab platform

Scan Science and Technology

Contact Leading Edge Experts & Companies

Scan Science and Technology

Contact Leading Edge Experts & Companies

The Experts below are selected from a list of 47247 Experts worldwide ranked by ideXlab platform

Cheng Yan - One of the best experts on this subject based on the ideXlab platform.

Himanshu Gupta - One of the best experts on this subject based on the ideXlab platform.

  • selection of views to materialize in a Data Warehouse
    International Conference on Database Theory, 1997
    Co-Authors: Himanshu Gupta
    Abstract:

    A Data Warehouse stores materialized views of Data from one or more sources, with the purpose of efficiently implementing decision-support or OLAP queries. One of the most important decisions in designing a Data Warehouse is the selection of materialized views to be maintained at the Warehouse. The goal is to select an appropriate set of views that minimizes total query response time and the cost of maintaining the selected views, given a limited amount of resource, e.g., materialization time, storage space etc.

Xiang Ye - One of the best experts on this subject based on the ideXlab platform.

  • materialized view design and maintenance in a financial Data Warehouse system
    Systems Man and Cybernetics, 1999
    Co-Authors: Xiang Ye
    Abstract:

    A Data Warehouse is a repository of integrated information from distributed, autonomous and possibly heterogeneous sources. One of the problems related with a Data Warehouse is how to keep views in the Data Warehouse up-to-date, given the various geographical and operational constraints of the underlying source Databases. Two main techniques are used to address this view maintenance problem viz., the auxiliary view technique and the summary-delta table method. We discuss an implementation which makes use of both techniques in a single system: a Financial Data Warehouse System (FDWS), as a hybrid approach to view maintenance. Such an approach applies the two techniques as complements to each other and takes into account the special characteristics of the Data Warehouse concerned.

Tang Yongchuan - One of the best experts on this subject based on the ideXlab platform.

  • a hybrid model of Data Warehouse project process
    Computer Engineering, 2005
    Co-Authors: Tang Yongchuan
    Abstract:

    This paper proposes a hybrid model of Data Warehouse process. The process model combines linear model and iteration model. Theengineering disciplines of the process model are divided into two part: technology system construction and analytical application developing. Theprocess model can cover all developing workflows and activities of most Data Warehouse project, and be prone to project management because of theresemblance between it and the software process.

Isabelle Comyn-wattiau - One of the best experts on this subject based on the ideXlab platform.

  • A UML-based Data Warehouse design method
    Decision Support Systems, 2006
    Co-Authors: Nicolas Prat, Jacky Akoka, Isabelle Comyn-wattiau
    Abstract:

    Data Warehouses are a major component of Data-driven decision support systems (DSS). They rely on multidimensional models. The latter provide decision makers with a business-oriented view to Data, thereby easing Data navigation and analysis via On-Line Analytical Processing (OLAP) tools. They also determine how the Data are stored in the Data Warehouse for subsequent use, not only by OLAP tools, but also by other decision support tools. Data Warehouse design is a complex task, which requires a systematic method. Few such methods have been proposed to date. This paper presents a UML-based Data Warehouse design method that spans the three design phases (conceptual, logical and physical). Our method comprises a set of metamodels used at each phase, as well as a set of transformations that can be semi-automated. Following our object orientation, we represent all the metamodels using UML, and illustrate the formal specification of the transformations based on OMG's Object Constraint Language (OCL). Throughout the paper, we illustrate the application of our method to a case study.