Towards A Generic Conceptual Model for Data Warehouses (original) (raw)
Related papers
Data Warehouse Conceptual Modeling Approaches
Data Warehouse (DW) Systems enable managers in corporations to acquire and integrate information from heterogeneous sources and to query huge databases efficiently. Building a Data Warehouse requires focusing on the conceptual design phase due to the specific requirements found in the conceptual model used. Various approaches were presented by researchers to support the conceptual design of data warehouses as there is no generic and well formalized approach used by data warehouse designers synonymous to the Entity-Relationship (ER) Model used in the database environment. This paper will present the data warehouse requirements that are required to be present in the conceptual model. Then, a case study will be used to illustrate how the proposed conceptual models for data warehouses could be used. Finally, a comparison will be conducted to show the most significant model that is more suitable than others in supporting the conceptual design of data warehouses.
A Conceptual Modelling Perspective for Data Warehouses
Electronic Business Engineering, 1999
The volume of information of the most various types stored electronically in a company is increasing to an ever-greater extent. While in the field of operational systems everything is aimed at achieving the quickest possible throughput, in the dispositive field, questions regarding the total overview or detailed views are of interest. OLAP servers are multidimensionally structured. They are therefore suited for the analysis of multidimensional datastores. The functionality of the OLAP server, such as, creation of forms, drill down, roll up, slice and dice, analysis technology, multidimensional consolidation, etc. demonstrate the advantages of this tool. The analysis of the relevant features of the data warehouse and OLAP is based on both the mainstream literature and on our experience in a two-year project Data Warehouse for Tupperware Inc. The second problem addressed by this paper is the discussion of recent approaches for a proposition some formal definitions of basic constructs used in so called multidimensional modelling which seems to be an important technique for data warehousing and OLAP. It is different from E-R modelling and offers a number of important advantages that the E-R modelling lacks. We show a relationship of E-R modelling to the multidimensional modelling and describe a broad class of multidimensional databases based on so called constellation schemes with explicit hierarchies.
Research in data warehouse modeling and design
Proceedings of the 9th ACM international workshop on Data warehousing and OLAP - DOLAP '06, 2006
Multidimensional modeling requires specialized design techniques. Though a lot has been written about how a data warehouse should be designed, there is no consensus on a design method yet. This paper follows from a wide discussion that took place in Dagstuhl, during the Perspectives Workshop "Data Warehousing at the Crossroads", and is aimed at outlining some open issues in modeling and design of data warehouses. More precisely, issues regarding conceptual models, logical models, methods for design, interoperability, and design for new architectures and applications are considered.
Research in data warehouse modeling and design: dead or alive
2006
Multidimensional modeling requires specialized design techniques. Though a lot has been written about how a data warehouse should be designed, there is no consensus on a design method yet. This paper follows from a wide discussion that took place in Dagstuhl, during the Perspectives Workshop "Data Warehousing at the Crossroads", and is aimed at outlining some open issues in modeling and design of data warehouses. More precisely, issues regarding conceptual models, logical models, methods for design, interoperability, and design for new architectures and applications are considered.
Comparative Study of Data Warehouse Design Approaches : A Survey
International Journal of Database Management Systems, 2012
The process of developing a data warehouse starts with identifying and gathering requirements, designing the dimensional model followed by testing and maintenance. The design phase is the most important activity in the successful building of a data warehouse. In this paper, we surveyed and evaluated the literature related to the various data warehouse design approaches on the basis of design criteria and propose a generalized object oriented conceptual design framework based on UML that meets all types of user needs.
Proceedings of the eighth international conference on Information and knowledge management - CIKM '99, 1999
This paper focuses on data warehouse modelling. The conceptual model we defined, is based on object concepts extended with specific concepts like generic classes, temporal classes and archive classes. The temporal classes are used to store the detailed evolutions and the archive classes store the summarised data evolutions. We also provide a flexible concept allowing the administrator to define historised parts and non-historised parts into the warehouse schema. Moreover, we introduce constraints which configure the data warehouse behaviour and these various parts. To validate our propositions, we describe a prototype dedicated to the data warehouse design.
Conceptual Design of Data Warehouse using Hybrid Methodology
International Journal of Advanced Trends in Computer Science and Engineering, 2020
In recent times, data warehousing achieved tremendous attention in various organizations including universities to analyze important aspects of their academic environment. In this paper, we present an automatic design system to integrate the functionality of both the requirement-driven and data-driven approaches. In addition, it is established on the basis of i* framework and Dimensional Fact Model (DFM) which is used to design the actions of actors, and the relationship existing among the agents in DW (Data Warehouse) environment. Furthermore, the proposed system introduces and illustrates an automatic design technique based on a logical programming to perform the integration of different data sources using UML multidimensional schemas that are reconciled with data sources to improvise the conceptual quality.
Conceptual Data Warehouse Design
Data Warehouse Systems, 2014
A data warehouse is an integrated and timevarying collection of data derived from operational data and primarily used in strategic decision making by means of online analytical processing (OLAP) techniques. Although it is generally agreed that warehouse design is a non-trivial problem and that multidimensional data models and star or snowflake schemata are relevant in this context, hardly any methods exist to date for deriving such a schema from an operational database. In this paper, we fill this gap by showing how to systematically derive a conceptual warehouse schema that is even in generalized multidimensional normal form.
OO Approach for Developing Conceptual Model for A Data Warehouse
The conceptual model is considered as first tier in the architecture of data warehouse. To see the performance of any system we want that no of parameter should be displayed at the same time. Here no of parameters are the dimensions according to which we want to see the business. This approach is Multidimensional and we generally abbreviated as conceptual multidimensional model. In this paper we are going to propose a object oriented approach for developing the conceptual model in which main focus will be on the properties: 1.Aggregation 2.Generalization 3 Association which are explained by UML.