ACM SIGMOD Anthology ACM SIGMOD dblp.uni-trier.de

Methodological Framework for Data Warehouse Design.

Matteo Golfarelli, Stefano Rizzi: Methodological Framework for Data Warehouse Design. DOLAP 1998: 3-9
@inproceedings{DBLP:conf/dolap/GolfarelliR98,
  author    = {Matteo Golfarelli and
               Stefano Rizzi},
  title     = {Methodological Framework for Data Warehouse Design},
  booktitle = {DOLAP '98, ACM First International Workshop on Data Warehousing
               and OLAP, November 7, 1998, Bethesda, Maryland, USA, Proceedings},
  publisher = {ACM},
  year      = {1998},
  pages     = {3-9},
  ee        = {db/conf/dolap/GolfarelliR98.html, http://doi.acm.org/10.1145/294260.294261},
  crossref  = {DBLP:conf/dolap/98},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX

Abstract

Though designing a data warehouse requires techniques completely different from those adopted for operational systems, no significant effort has been made so far to develop a complete and consistent design methodology for data warehouses. In this paper we outline a general methodological framework for data warehouse design, based on our Dimensional Fact Model (DFM). After analyzing the existing information system and collecting the user requirements, conceptual design is carried out semi-automatically starting from the operational database scheme. A workload is then characterized in terms of data volumes and expected queries, to be used as the input of the logical and physical design phases whose output is the final scheme for the data warehouse.

Copyright © 1998 by the ACM, Inc., used by permission. Permission to make digital or hard copies is granted provided that copies are not made or distributed for profit or direct commercial advantage, and that copies show this notice on the first page or initial screen of a display along with the full citation.


ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 2 Issue 4, CIKM, DOLAP, GIS, SIGFIDET, ..." and ... DVD Version: Load ACM SIGMOD Anthology DVD 1" and ... BibTeX

Printed Edition

DOLAP '98, ACM First International Workshop on Data Warehousing and OLAP, November 7, 1998, Bethesda, Maryland, USA, Proceedings. ACM 1998
Contents BibTeX

Online Edition

Citation Page BibTeX

References

[1]
...
[2]
Elena Baralis, Stefano Paraboschi, Ernest Teniente: Materialized Views Selection in a Multidimensional Database. VLDB 1997: 156-165 BibTeX
[3]
Luca Cabibbo, Riccardo Torlone: Un quadro metodologico per la costruzione e l'uso di un data warehouse. SEBD 1998: 123-140 BibTeX
[4]
Alfonso F. Cardenas: Analysis and Performance of Inverted Data Base Structures. Commun. ACM 18(5): 253-263(1975) BibTeX
[5]
...
[6]
Himanshu Gupta: Selection of Views to Materialize in a Data Warehouse. ICDT 1997: 98-112 BibTeX
[7]
Himanshu Gupta, Venky Harinarayan, Anand Rajaraman, Jeffrey D. Ullman: Index Selection for OLAP. ICDE 1997: 208-219 BibTeX
[8]
Marc Gyssens, Laks V. S. Lakshmanan: A Foundation for Multi-dimensional Databases. VLDB 1997: 106-115 BibTeX
[9]
Venky Harinarayan, Anand Rajaraman, Jeffrey D. Ullman: Implementing Data Cubes Efficiently. SIGMOD Conference 1996: 205-216 BibTeX
[10]
Theodore Johnson, Dennis Shasha: Some Approaches to Index Design for Cube Forest. IEEE Data Eng. Bull. 20(1): 27-35(1997) BibTeX
[11]
Ralph Kimball: The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. John Wiley 1996, ISBN 0-471-15337-0
BibTeX
[12]
...
[13]
M. Tamer Özsu, Patrick Valduriez: Principles of Distributed Database Systems. Prentice-Hall 1991, ISBN 0-13-715681-2
BibTeX
[14]
Jennifer Widom: Research Problems in Data Warehousing. CIKM 1995: 25-30 BibTeX
[15]
...
[16]
S. Bing Yao: Approximating the Number of Accesses in Database Organizations. Commun. ACM 20(4): 260-261(1977) BibTeX

Referenced by

  1. Toby J. Teorey: Review - Methodological Framework for Data Warehouse Design. ACM SIGMOD Digital Review 2: (2000)
  2. Il-Yeol Song, Kelly LeVan-Shultz: Data Warehouse Design for E-Commerce Environments. ER (Workshops) 1999: 374-387
  3. Nectaria Tryfona, Frank Busborg, Jens G. Borch Christiansen: starER: A Conceptual Model for Data Warehouse Design. DOLAP 1999: 3-8
  4. Juan Trujillo, Manuel Palomar, Jaime Gómez: Detecting Patterns and OLAP Operations in the GOLD Model. DOLAP 1999: 48-53
  5. Lars Bækgaard: Event-Entity-Relationship Modeling in Data Warehouse Environments. DOLAP 1999: 9-14
BibTeX
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
DOLAP 1998 Proceedings, ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Sat May 16 23:07:19 2009