Journal ArticleDOI
The dimensional fact model: a conceptual model for data warehouses
Reads0
Chats0
TLDR
This paper formalizes a graphical conceptual model for data warehouses, called Dimensional Fact model, and proposes a semi-automated methodology to build it from the pre-existing schemes describing the enterprise relational database.Abstract:
Data warehousing systems enable enterprise managers to acquire and integrate information from heterogeneous sources and to query very large databases efficiently. Building a data warehouse requires adopting design and implementation techniques completely different from those underlying operational information systems. Though most scientific literature on the design of data warehouses concerns their logical and physical models, an accurate conceptual design is the necessary foundations for building a DW which is well-documented and fully satisfies requirements. In this paper we formalize a graphical conceptual model for data warehouses, called Dimensional Fact model, and propose a semi-automated methodology to build it from the pre-existing (conceptual or logical) schemes describing the enterprise relational database. The representation of reality built using our conceptual model consists of a set of fact schemes whose basic elements are facts, measures, attributes, dimensions and hierarchies; other featur...read more
Citations
More filters
Proceedings ArticleDOI
Conceptual modeling for ETL processes
TL;DR: The proposed conceptual model is customized for the tracing of inter-attribute relationships and the respective ETL activities in the early stages of a data warehouse project and constructed in a customizable and extensible manner, so that the designer can enrich it with his own re-occurring patterns forETL activities.
Journal ArticleDOI
Digital government security infrastructure design challenges
TL;DR: An approach that provides a theoretical foundation for the use of object-oriented databases and object-relational databases in data warehouse, multidimensional database, and online analytical processing applications and introduces a set of minimal constraints and extensions to the Unified Modeling Language for representing multiddimensional modeling properties for these applications.
A UML profile for multidimensional modeling in data warehouses
TL;DR: In this paper, an extension of the Unified Modeling Language (UML) using a UML profile is defined by a set of stereotypes, constraints and tagged values to elegantly represent main MD properties at the conceptual level.
Journal ArticleDOI
A UML profile for multidimensional modeling in data warehouses
TL;DR: This paper presents an extension of the Unified Modeling Language (UML) using a UML profile defined by a set of stereotypes, constraints and tagged values to elegantly represent main MD properties at the conceptual level and uses the Object Constraint Language (OCL) to specify the constraints attached to the defined stereotypes.
Journal ArticleDOI
GRAnD: A goal-oriented approach to requirement analysis in data warehouses
TL;DR: This paper proposes GRAnD, a goal-oriented approach to requirement analysis for data warehouses based on the Tropos methodology, which can be employed within both a demand-driven and a mixed supply/demand-driven design framework.
References
More filters
Journal ArticleDOI
An overview of data warehousing and OLAP technology
Surajit Chaudhuri,Umeshwar Dayal +1 more
TL;DR: An overview of data warehousing and OLAP technologies, with an emphasis on their new requirements, is provided, based on a tutorial presented at the VLDB Conference, 1996.
Proceedings ArticleDOI
Implementing data cubes efficiently
TL;DR: In this article, a lattice framework is used to express dependencies among views and greedy algorithms are presented to determine a good set of views to materialize, with a small constant factor of optimal.
Proceedings ArticleDOI
Modeling multidimensional databases
TL;DR: A data model and a few algebraic operations that provide semantic foundation to multidimensional databases and provide an algebraic application programming interface (API) that allows the separation of the front end from the back end are proposed.
Proceedings ArticleDOI
Index selection for OLAP
TL;DR: The authors give algorithms that automate the selection of summary tables and indexes, and present a family of algorithms of increasing time complexities, and prove strong performance bounds for them.
Proceedings Article
Materialized Views Selection in a Multidimensional Database
TL;DR: The technique is proposed reduces the soluticn space by considering only the relevant elements of the multidimensional lattice whose elements represent the solution space of the problem.