Constructing an Object-relational Data Warehouse Using Semi-automated Methods

以半自動化方式建構物件關連式資料倉儲

10.6382/JIM.200810.0205

劉俞志(Julie Yu-Chih Liu)；賴詩雅(Shih-Ya Lai)

物件關連式資料倉儲 ； 概念模型 ； 多維度資料模型 ； 增強式實體關聯模型 ； Object-relational data warehouse ； Conceptual models ； Multidimensional data model ； Enhanced entity-relational model

資訊管理學報

15卷4期（2008 / 10 / 01）

205 - 225

英文

隨著資料庫的日漸複雜，以物件為概念的資料倉儲將成為未來的建構趨勢。而物件資料倉儲的設計通常耗費大量人力。本文針對物件關連式資料倉儲的設計提出其概念模型，並提供半自動化的方式由物件關連式資料庫的標準文件推導出此概念模型。簡單的實例將說明此半自動化的建構方式。本研究的貢獻還包括建立概念綱要到邏輯設計的映對機制，映對結果可直接以邏輯圖及程式碼呈現，此外，亦提出如何根據物件關連式資料庫的定義域特質來精煉此程式碼，以改善儲存成本與存取效能。

As databases become increasingly complicated, building data warehouse with object concepts becomes the essential trend in the future. Designing such a data warehouse usually requires much human involvement. This work proposes a conceptual model for designing an object-relational data warehouse, and provides a semi-automated methodology for deriving the model from the standard documentation of the object-relational database. The construction of the model using the semi-automated methodology is demonstrated in simple examples. Furthermore, this work contributes a mapping mechanism from the conceptual schema to the logical design, and displays the mapping result in both a logical diagram and physical code. The physical code generated based on the logical diagram is refined by using the domain properties in object-relational database to improve the storage cost as well as query performance.

1. Abello, A.,Samos, J.,Saltor, F.(2001).A Framework for the Classification and Description of Multidimensional Data Models.in Proc. of DEXA`01.
2. Abelló, A.,Samos, J.,Saltor, F.(2001).Understanding Facts in a Multidimensional Object-Oriented Model.Workshop on Data Warehousing and OLAP (DOLAP `01)
3. Agrawal, R.,Gupta, A.,Sarawagi, S.(1997).Modeling Multi-dimensional Databases.In Proc. of the 13th Int`l Conference on Data Engineering,Birmingham, UK:
4. Akoka, J.,Comyn-Wattiau, I.,Prat, N.(2001).Dimension Hierarchies Design from UML Generalizations and Aggregations.In International Conference on Conceptual Modeling (ER2001),Heidelberg:
5. Bækgaard, L.(1999).Event-Entity-Relationship Modeling in Data Warehouse Environments.Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP.
6. Batini, C.,Ceri, S.,Navathe, S.B.(1992).Conceptual Database Design: An Entity-Relationship Approach.Spanish:Addison Wesley.
7. Cabibbo, L.,Torlone, R.(1998).A Logical Approach to Multidimensional Databases.In Sixth Int. Conference on Extending Database Technology (EDBT`98)
8. Codd, E.F.(1979).Extending the Database Relational Model to Capture More Meaning.ACM Trans. Database System,4(4),397-434.
9. Elmasri, R.,Navathe, S.B.(2004).Fundamentals of Database System.Addison Wesley.
10. Feng, L.,Dillon, T.S.(2003).Using Fuzzy Linguistic Representations to Provide Explanatory Semantics for Data Warehouses.IEEE Trans. on KDE,15(1),86-102.
11. Fong, J.(1995).Mapping Extended Entity Relationship Model to Object Modeling Technique.ACM SIGMOD Record,24(3),18-22.
12. Franconi, E.,Kamble, A.(2003).The GMD Data Model for Multidimensional Information: A Brief Introduction.Proceedings Conference on Data Warehousing and Knowledge Discovery
13. Franconi, E.,Sattler, U.(1999).A Data Warehouse Conceptual. Data Model for Multidimensional Aggregation.In Proc. of the. Workshop on Design and Management of Data Warehouses.
14. Golfarelli, M.,Maio, D.,Rizzi, S.(1998).Conceptual Design of Data Warehouses from E/R Schemes.Proceedings of 31st Hawaii International Conference on System Sciences
15. Golfarelli, M.,Maio, D.,Rizzi, S.(1998).The Dimensional Fact Model: A Conceptual Model for Data Warehouses.International Journal of Cooperative Information Systems,7(23),215-247.
16. Golfarelli, M.,Rizzi, S.(1999).Designing the Data Warehouse: Key Steps and Crucial Issues.Journal of Computer Science and Information Management,2(3),1-14.
17. Gonçalves, S.P.F.C.B.Q.(2006).Easy Does It.Proceedings of Q2006 European Conference on Quality in Survey Statistics,Cardiff, UK:
18. Gopalkrishnan, V.,Li, Q.,Karlapalem, K.(1999).Star/snow-flake Schema Driven Object Relational Data Warehouse-Design and Query Processing Strategies.Proceedings of the First International Conference on Data Warehousing and Knowledge
19. Gray, P.,Watson, H. J.(1998).Decision Support in the Data Warehouse.New Jersey:Prentice-Hall.
20. Gyssens, M.,Lakshmanan, L.(1996).A Foundation for Multidimensional Database.In Proc. 22nd VLDB Conference,Mumbai Bombay, India:
21. Hacid, M.,Sattler, U.(1997).An Object-centered Multi-dimensional Data Model with Hierarchically Structured Dimensions.Proceedings of the IEEE Knowledge and Data Engineering Exchange Workshop.
22. Inmon, W.H.(1996).Building the Data Warehouse.New York:John Wiley and Sons.
23. Kimball, R.(1998).The Data Warehouse ETL toolkit: Expert Methods for Designing, Developing, and Deploying Data Warehouses.New York:Wiley Computer.
24. Kimball, R.(2002).The data warehouse ETL toolkit: The Complete Guide to Dimensional Modeling.John Wiley Sons Inc.
25. Krippendorf, M.,Song, I.Y.(1997).The Translation of Star Schema into Entity Relationship Diagrams.Proceeding of the Eighth Int`l Workshop on Database and Expert Systems Applications.
26. Li, C.,Wang, X.S.(1996).A Data Model for Supporting On-Line Analytical Processing.Proceedings of the Fifth International Conference on Information and Knowledge Management
27. Lujan-Mora, S.,Trujillo, J.,Song, I.Y.(2002).Extending the UML for Multidimensional Modeling.Fifth Int. Conf. on the Unified Modeling. Language and its applications (UML `02) Dresden, Germany, Lecture Note in Computer Science
28. Lujan-Mora, S.,Trujillo, J.,Song, I.Y.(2002).Multidimensional Modeling with UML Package Diagrams.in Proc. of the 21st Int. Conf. on. Conceptual Modeling ER `02
29. Moody, L.D.,Kortink, M.A.R.(2000).Proc. of the Int`l Workshop on Design and Management of Datawarehouses.Stockholm, Sweden:
30. Nguyen, T.,Tjoa, A.,Wagner, R.(2000).An Object Oriented Multidimensional Data Model for OLAP.in Proc. of 1st Int. Conf. on Web-Age Information Management
31. Pedersen, T.B.,Jensen, C.S.,Dyreson, C.E.(2001).A Foundation for Capturing and Querying Complex Multidimensional Data.Information Systems,26(5),383-423.
32. Poe, V.,Klauer, P.,Brobst. S.(1997).Building A Data Warehouse for Decision Support.NJ:Prentice Hall PTR.
33. Rahayu, W.,Dillon, T.S.,Mohammed, S.,Taniar, D.(2001).Object-Relational Star Schemas.13th IASTED Int. Conf. on Paraellel. Disibuted Computing and Systems,LA, USA:
34. Sapia, C.,Blaschka, M.,Hoing, G.,Dinter, B.(1998).Proceeding of the Int`l Workshop on Data Warehouse and Data Mining.Singapore:
35. Thomas, H.,Datta, A.(2001).A Conceptual Model and Algebra for On-line Analytical in Processing of Decision Support Databases.Information Systems Res,12(1),83-102.
36. Trujillo, J.,Palomar, M.,Gomez, J.(2000).Applying Object-Oriented Conceptual Modeling Techniques to the Design of Multidimensional Databases and OLAP Applications.In. Proc. of 1st Int. Conf. on Web-Age Information Management
37. Trujillo, J.,Palomar, M.,Gomez, J.,Song, I.Y.(2001).Designing Data Warehouses with OO Conceptual Models.IEEE Computer Society, special issue on Data Warehouses,34(12),66-75.
38. Tryfona, N.,Busborg, F.,Christiansen, J.G.B.(1999).StarER: A Conceptual Model for Data Warehouse Design.In ACM Second International Workshop on Data Warehousing and OLAP.
39. Tsois, A.,Karayannidis, N.,Sellis, T.(2001).MAC: Conceptual Data Modeling for OLAP.in Proc. of the International Workshop on DMDW.
40. Vassiliadis, P.(1998).Modeling Multidimensional Databases, Cubes and Cube Operations.Proceedings of the 10th International Conference on Scientific and Statistical Database Management
41. Vassiliadis, P.,Sellis, T.(1999).A Survey of Logical Models for OLAP Databases.SIGMOD,28(4),64-69.