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

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

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

《資訊管理學報》 15卷4期 (2008/10) Pp. 205-225

https://doi.org/10.6382/JIM.200810.0205

摘要

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

關鍵字

物件關連式資料倉儲 ； 概念模型 ； 多維度資料模型 ； 增強式實體關聯模型

並列摘要

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.

並列關鍵字

Object-relational data warehouse ； Conceptual models ； Multidimensional data model ； Enhanced entity-relational model

參考文獻

Abello, A.,Samos, J.,Saltor, F.(2001).A Framework for the Classification and Description of Multidimensional Data Models.(in Proc. of DEXA`01).

Abelló, A.,Samos, J.,Saltor, F.(2001).Understanding Facts in a Multidimensional Object-Oriented Model.Workshop on Data Warehousing and OLAP (DOLAP `01).(Workshop on Data Warehousing and OLAP (DOLAP `01)).

Agrawal, R.,Gupta, A.,Sarawagi, S.(1997).Modeling Multi-dimensional Databases.In Proc. of the 13th Int`l Conference on Data Engineering.(In Proc. of the 13th Int`l Conference on Data Engineering).:

Akoka, J.,Comyn-Wattiau, I.,Prat, N.(2001).Dimension Hierarchies Design from UML Generalizations and Aggregations.In International Conference on Conceptual Modeling (ER2001).(In International Conference on Conceptual Modeling (ER2001)).:

Bækgaard, L.(1999).Event-Entity-Relationship Modeling in Data Warehouse Environments.(Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP).