A methodological framework for conceptual data warehouse design

Subscribe (Full Service)


	Search: The ACM Digital Library The Guide

	Feedback

A methodological framework for conceptual data warehouse design

Full text

Pdf (443 KB)

Source

ACM Southeast Regional Conference archive
Proceedings of the 43rd annual Southeast regional conference - Volume 1 table of contents

Kennesaw, Georgia

SESSION: Database table of contents

Pages: 256 - 259

Year of Publication: 2005

ISBN:1-59593-059-0

Authors

Leopoldo Zepeda	Inst. Tecnológico de Culiacán, Cln. Sin., México
Matilde Celma	Universidad Politécnica de Valencía, Val. España
Ramón Zatarain	Inst. Tecnológico de Culiacán, Cln. Sin., México

Sponsor

ACM: Association for Computing Machinery

Publisher

ACM New York, NY, USA

Bibliometrics

Downloads (6 Weeks): 9, Downloads (12 Months): 123, Citation Count: 1

Additional Information:

abstract references cited by index terms collaborative colleagues

Tools and Actions:	Request Permissions Review this Article Save this Article to a Binder Display Formats: BibTeX EndNote ACM Ref

DOI Bookmark:	Use this link to bookmark this Article: http://doi.acm.org/10.1145/1167350.1167424 What is a DOI?

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

Note: OCR errors may be found in this Reference List extracted from the full text article. ACM has opted to expose the complete List rather than only correct and linked references.

	1	Ralph Kimball, The data warehouse toolkit: practical techniques for building dimensional data warehouses, John Wiley & Sons, Inc., New York, NY, 1996
	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	Luca Cabibbo , Riccardo Torlone, A Logical Approach to Multidimensional Databases, Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology, p.183-197, March 23-27, 1998
	4	Matteo Golfarelli , Dario Maio , Stefano Rizzi, Conceptual Design of Data Warehouses from E/R Schema, Proceedings of the Thirty-First Annual Hawaii International Conference on System Sciences-Volume 7, p.334, January 06-09, 1998 [doi>10.1109/HICSS.1998.649228]
	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.