skip to main content
10.1145/1167350.1167424acmconferencesArticle/Chapter ViewAbstractPublication Pagesacm-seConference Proceedingsconference-collections
Article

A methodological framework for conceptual data warehouse design

Published: 18 March 2005 Publication History

Abstract

A Data Warehouse (DW) has been an approach adopted for giving support to the process of taking decisions in an organization. This paper is concerned with the data warehouse conceptual schema design starting from the conceptual operational schemas and user requirements. We propose and illustrate an algorithm for automatic conceptual schema development. Our algorithm uses an enterprise schema represented with UML as a starting point for source driven data warehouse schema design and produces a set of multidimensional candidates schemas. The candidates schemas are created using an UML profile for data warehouse. Next the automatic generation of multidimensional schemas we use user requirements to guide the selection of the candidates schemas most likely to meet users needs.

References

[1]
Kimball, R, "The Data Warehouse Toolkit: Practical Techniques for building Dimensional Data Warehouses", John Wiley and Sons, Inc., New York, NY, 1998.
[2]
Vicky Nassisl, R. Rajugan2, Tharam S. Dillon2, and Wenny Rahayul. Discovering Data Warehousing and Knowledge Discovery: 6th International. Conference, DaWaK 2004, Zaragoza, Spain, September 1--3, 2004. Proceedings ISBN: 3-540-22937-X.
[3]
Cabibbo, L. and Torlone. A logical approach to multidimensional databases. In Proceedings of the International Conference on Extending Data Base Technology (EDBT '98, Valencia, Spain, Mar.). 183--197.
[4]
Golfarelli, M, and Rizzi, S. 1998. Conceptual design of data warehouses from E/R schemas. In Proceedings of the 31st Hawaii International Conference on System Sciences (HICSS '98, Kona, Hawai).
[5]
Zepeda. L. Matilde C. An UML Profile for Data warehouse Design. In proceedings of CIC 2004., México.ISBN:970-36-0194-4
[6]
Beate List, Josef Schiefer, A Min Tjoa. Process-Oriented Requirement Analysis Supporting the Data Warehouse Design Process Use Case Driven Approach.

Cited By

View all
  • (2016)Key Performance Indicators in Data WarehousesBusiness Intelligence10.1007/978-3-319-39243-1_5(111-129)Online publication date: 10-May-2016
  • (2008)Data warehouse architecture for GIS applicationsProceedings of the 10th International Conference on Information Integration and Web-based Applications & Services10.1145/1497308.1497344(178-185)Online publication date: 24-Nov-2008
  • (2008)Data warehouse architecture and design2008 IEEE International Conference on Information Reuse and Integration10.1109/IRI.2008.4583005(58-63)Online publication date: Jul-2008

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
ACMSE '05 vol 1: Proceedings of the 43rd annual ACM Southeast Conference - Volume 1
March 2005
408 pages
ISBN:1595930590
DOI:10.1145/1167350
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 18 March 2005

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. UML
  2. multidimensional design

Qualifiers

  • Article

Conference

ACM SE05
Sponsor:
ACM SE05: ACM Southeast Regional Conference 2005
March 18 - 20, 2005
Georgia, Kennesaw

Acceptance Rates

Overall Acceptance Rate 502 of 1,023 submissions, 49%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)1
  • Downloads (Last 6 weeks)0
Reflects downloads up to 18 Feb 2025

Other Metrics

Citations

Cited By

View all
  • (2016)Key Performance Indicators in Data WarehousesBusiness Intelligence10.1007/978-3-319-39243-1_5(111-129)Online publication date: 10-May-2016
  • (2008)Data warehouse architecture for GIS applicationsProceedings of the 10th International Conference on Information Integration and Web-based Applications & Services10.1145/1497308.1497344(178-185)Online publication date: 24-Nov-2008
  • (2008)Data warehouse architecture and design2008 IEEE International Conference on Information Reuse and Integration10.1109/IRI.2008.4583005(58-63)Online publication date: Jul-2008

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media