Author, Subjects, Keywords

Cited Author

 
 
   » By Author or Editor
 » Browse Author by Alphabet
 » By Journal
 » By Subjects
 » Malaysian Journals
 » By Type
 » By Year
 » By Latest Additions
 
 
   » By Author
 » Top 20 Authors
 » Top 20 Article
 » Top Journal Cited
 » Top Article Cited
 » Journal Citation Statistics
 » Usage Since Sept 2007


 
 
 

Login | Create Account

Translation of ER Model to Multidimensional Model for Data Warehouse - An Automated Approach

Opim Salim Sitompul, and Shahrul Azman Mohd Noah, (2002) Translation of ER Model to Multidimensional Model for Data Warehouse - An Automated Approach. Jurnal Antarabangsa Teknologi Maklumat, 3 . pp. 11-32.

[img]
Preview
PDF - Requires a PDF viewer such as GSview, Xpdf or Adobe Acrobat Reader
328Kb

Affiliations

Universiti Kebangsaan Malaysia. Faculty of Information Science and Technology
Universiti Kebangsaan Malaysia. Faculty of Information Science and Technology

Abstract

ABSTRACT: Multidimensional data model has been considered by the database community as a model to support the application of data warehouse. While this model has been the de-facto of successful data warehouse implementation, little has been said on how to carry out the data warehouse conceptual design. This paper, however, presents an approach and a tool for the automatic conceptual data warehouse design. The approach uses an existing ER model described by using an ER specification language, whereby the model is progressively translated and extended to include the dimensional functionality necessary in data warehousing. The output of the translation model is a basic multidimensional construct such as facts, measures, dimensions, and dimension hierarchies. Although there is no universally agreed method on the conceptual design of data warehouse, the approach and tool presented in this paper has at least demonstrated the practical exploitation of ER model as a basis for such a design. The paper concludes with a discussion of areas of future research and development.

ABSTRAK: Komuniti pangkalan data telah mengiktiraf model data multidimensi sebagai sebagai model utama dalam pembangunan aplikasi gudang data. Walaubagaimanapun perbincangan dan usulan berhubung dengan pendekatan dalam proses reka bentuk konseptual gudang data masih lagi kurang mendapat perhatian. Melalui kertas kerja ini, satu pendekatan dan perisian dalam mereka bentuk model konseptual gudang data telah diketengahkan. Pendekatan yang dicadangkan ini melibatkan penterjemahan dan pengembangan model perhubungan entiti sedia ada (ditakrifkan melalui bahasa spesifikasi perhubungan entiti) dengan mempertimbangkan fungsian dimensi yang diperlukan dalam penggudangan data. Hasil daripada proses penterjemahan ini ialah satu model asas data multidimensi yang melibatkan fakta, had.

Item Type:Journal
Keywords:Data warehouse design, multidimensional model, entity relationship model, automated design tool
Subjects:Q Science, Computer Science
ID Code:8137

Agrawal, R., Gupta, A. and Sarawagi, S. 1997. Modeling multidimensional databases. Proceedings of the 13 International Conference On Data Engineering (1CDE'97). Birmingham, U.K: 232-243.

Chaudhuri, S. and Dayal, U. 1997. An overview of data warehousing and OLAP technology. ACM S1GMOD Record 26(1): 65-74.

Elmasri, R. and Navathe, S. B. 2000. Fundamentals of Database Systems. 3"1 Edition. Addison-Wesley. Reading, MA.

Golfarelli, M., Maio, D. and Rizzi, S. 1998. Conceptual design of data warehouses from E/R schemes. Proceedings of the Hawaii International Conference on System Sciences VII. Kona, Hawaii: 334-343.

Hahn, K., Sapia, C. and Blaschka, M. 2000. Automatically generating OLAP schemata from conceptual graphical models. Proceedings of the 3rd International Workshop on Data Warehousing and OLAP (DOLAP, in connection with CIKM). Washington D.C.: 9-16.

Husemann, B., Lechtenborger, J. and Vossen G. 2000. Conceptual data warehouse design. Proceedings of the International Workshop on Design and Management of Data Warehouse (DMDW '2000). Stockholm, Sweden: 6-1-6-11.

Keene, S. E. 1989. Object-Oriented Programming in Common LISP: A Programmer's Guide to CLOS. Addison-Wesley: Reading, MA.

Kimbal, R. 1997. A dimensional modeling manifesto: Drawing the line between dimensional modeling and ER modeling techniques. DBMS Online 10(9): 59.

Moody, D. and Kortink, M.A.R. 2000. From enterprise models to dimensional models: A methodology for data warehouse and data mart design. Proceedings of the International Workshop on Design and Management of Data Warehouses 2000 (DMDW2000). Stockholm, Sweden: 5-1 - 5-12.

Noah, S. A. and Williams, M. 1998. An evaluation of two approaches to exploiting real-world knowledge by intelligent database design tools. Proceedings of the 17 International Conference on Conceptual Modelling, Singapore. Springer-Verlag, Berlin: 197-210.

Noah, S. A. and Williams, M. 2000. Exploring and validating the contributions of real-world knowledge to the diagnostic performance of automated database design tools. Proceedings of the Fifteenth IEEE International Conference on Automated Software Engineering (ASE 2000). Grenoble, France: 177-185.

Phipps, C. and Davis, K. C. 2002. Automating data warehouse conceptual schema design and evaluation. Proceedings of the 4'h International Workshop on Design and Management of Data Warehouses 2002 (DMDW'2002). Toronto, Canada:23-32.

Samtani S., Mohania, M., Kumar, V. and Kambayashi, Y. 1998. Recent advances and research problems in data warehousing. Proceedings of the International Workshop on Data Warehousing & Data Mining, Mobile Data Access, and New Database Technologies for Collaborative Work Support & Spatio -Temporal Data Management. Singapore: 81-92.

Sapia, C, Blaschka, M, Hofling, G. and Dinter, B. 1998. Extending the E/R model for the multidimensional paradigm. Proceedings of the I" International Workshop on Data Warehousing and Data Mining (DWDM 98). New York,N.Y.: 105-116.

Tryfona, N., Busborg, F. and Christiansen, J. G. B. 1999. starER: A conceptual model for data warehouse design. Proceedings of the ACM 2nd International Workshop on Data Warehousing and OLAP. New York, N.Y.: 3-8.

Widom, J., 1995. Research Problems in Data Warehousing. Proceedings of the 4 International Conference on Information and Knowledge Management (CIKM). Baltimore, Maryland: 25 - 30.

Winston, P. H. and Horn, B. K. P. 1989. LISP. 3rd Edition. Addison-Wesley: Reading, MA.

Repository Staff Only: item control page
 
 
 
 
 
 
© Copyright 2007 MyAIS Faculty of Computer Science and Information Technology, University of Malaya – All Rights Reserved. Malaysian Abstracting and Indexing System is powered by EPrints 3 which is developed by the School of Electronics and Computer Science at the University of Southampton. More information and software credits.