資訊管理學報
劉俞志;賴詩雅;
頁: 205-225
日期: 2008/10
摘要: 隨著資料庫的日漸複雜，以物件為概念的資料倉儲將成為未來的建構趨勢。而物件資料倉儲的設計通常耗費大量人力。本文針對物件關連式資料倉儲的設計提出其概念模型，並提供半自動化的方式由物件關連式資料庫的標準文件推導出此概念模型。簡單的實例將說明此半自動化的建構方式。本研究的貢獻還包括建立概念綱要到邏輯設計的映對機制，映對結果可直接以邏輯圖及程式碼呈現，此外，亦提出如何根據物件關連式資料庫的定義域特質來精煉此程式碼，以改善儲存成本與存取效能。
關鍵字: 物件關連式資料倉儲;概念模型;多維度資料模型;增強式實體關聯模型;
Abstract: 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.
Keywords: Object-relational data warehouse;Conceptual models;Multidimensional data model;Enhanced entity-relational model;
瀏覽次數: 14657 下載次數: 120
引用 導入Endnote
頁: 205-225
日期: 2008/10
摘要: 隨著資料庫的日漸複雜，以物件為概念的資料倉儲將成為未來的建構趨勢。而物件資料倉儲的設計通常耗費大量人力。本文針對物件關連式資料倉儲的設計提出其概念模型，並提供半自動化的方式由物件關連式資料庫的標準文件推導出此概念模型。簡單的實例將說明此半自動化的建構方式。本研究的貢獻還包括建立概念綱要到邏輯設計的映對機制，映對結果可直接以邏輯圖及程式碼呈現，此外，亦提出如何根據物件關連式資料庫的定義域特質來精煉此程式碼，以改善儲存成本與存取效能。
關鍵字: 物件關連式資料倉儲;概念模型;多維度資料模型;增強式實體關聯模型;
以半自動化方式建構物件關連式資料倉儲
Abstract: 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.
Keywords: Object-relational data warehouse;Conceptual models;Multidimensional data model;Enhanced entity-relational model;
瀏覽次數: 14657 下載次數: 120
引用 導入Endnote