臺灣博碩士論文加值系統

Metadata之定義，最為普遍接受的解釋是『資料的資料』(data about data)。其想法及應用由來已久，從早期應用於圖書館中的檢索卡片即為一例。現今Metadata也被廣為利用於各種領域中，例如：資料交換、全文檢索等等。相對於前述之廣泛使用，Metadata應用於企業內之資料整合是相當少見的。然而，現行企業內系統開發及資料整合有其窒礙難行之處，因此本研究以Metadata管理為出發點，建立一Metadata儲存庫架構，並將其應用於企業資料之整合。
對於企業資料整合本研究以Metadata將應用程式與資料分離，由企業內高階知識工作者完成整體企業資料的定義及描述。定義完成的Metadata是以企業領域知識所構成，使用者將會很容易了解企業擁有多少資料及其意義。企業整個資料由Metadata儲存庫管理，應用程式透過適當的工具連結對資料做存取。由於所有資料已由Metadata儲存庫產生及管理，應用程式在開發的過程只需透過Metadata 儲存庫提供的存取介面完成資料的存取。系統開發者只需專注於程式或企業邏輯的開發，不再像現行大多數應用程式必須花費大量的時間在資料模型分析及測試。如此透過Metadata的整合達成企業資料共享，應用程式溝通則藉由Metadata儲存庫的介面以統一且一致的方法傳遞訊息。

Metadata is data about data. For a long time, it has been widely applied to various fields; for instance, data exchange and full-text search. However, the application of Metadata to enterprise data tends to be less in the field of business, since it has been a very arduous task to develop systems or integrate data in the field of business. In view of the lack of research on this issue, the study, based on Metadata management, intended to establish a Metadata Repository Architecture, and further apply it to enterprise data integration.
In this study, Metadata separates applications and data. At the very beginning, knowledge workers accomplish definitions and descriptions of overall enterprise data, and resulted in Metadata which has been constructed with domain knowledge. With this kind of knowledge, users can easily understand the amount and the meanings of data possessed by a company. Later, the Metadata Repository will manage Enterprise Data, and the applications will access the data by implementing appropriate tools. Since the entire data has been produced and managed by the Metadata Repository, the development of applications simply accesses data through the interface provided by Metadata. Developers only need to concentrate themselves on the development of program and business logic, rather than spend a great deal of time on data model analysis and testing. Accordingly, a company can achieve enterprise data sharing through the integration of Metadata, and carry out the communication of applications through a unified and identical integration offered by Metadata Repository.

第一章 緒論 1
第二章 Metadata於企業整合之應用 3
2.1何謂Metadata及其演進 3
2.2為何需要Metadata 5
2.3 Metadata分類及使用者 7
2.4 Metadata 及 Metadata 儲存庫 9
2.5 Metadata的資料模型 14
2.6 標準Metadata 17
2.7 XML 19
2.8 Metadata管理與企業之關係 20
第三章 企業Metadata管理系統之資料模型與系統規劃 27
3.1 EMM系統建置架構 27
3.2 EMM系統之資料模型 30
3.3資料倉儲表格命名方式 36
3.4 EMM系統中資料對應(mapping)及資料轉置 39
3.5 Metadata及資料的交換介面 41
第四章 企業Metadata管理系統的建置與實現 43
4.1 Metadata管理系統各子成員的架構及邏輯設計 43
4.1.1 EMM系統架構 43
4.1.2多層次系統模組 44
4.1.3 Metadata與Data分離 46
4.2系統展示 47
4.2.1 EMM管理工具 47
4.2.2 Metadata Server 56
第五章 結論與未來研究方向 58
參考文獻 60

[1] Stuart Weibel, Jean Godby, and Eric Miller. OCLC/NCSA Metadata Workshop Report. http://www.ifla.org/documents/libraries/cataloging/oclcmeta.htm.[2] Adrienne Tannenbaum. Metadata Solutions: Using Metamodels, Repositories, XML, and Enterprise Portals to Generate Information on Demand. Addison Wesley Professional, 2001.
[3] D. Marco. Building and Managing the Metadata Repository: A Full Lifecycle Guide. Wiley, 2000.
[4] M. Jarke, M.A. Jeusfeld, C. Quix, and P. Vassiliadis. Architecture and quality in data warehouses. In Porc. Of the 10th Conference on Advanced Information Systems Engineering (CaiSE ’98), Pisa, Italy, June 1998.
[5] R. Kimball, L. Reeves, M. Ross, and W Thornthwaite. The Data Warehouse LifeCycle Toolkit: expert Methods for Designing, Developing, and Deploying Data Warehouse. Wiley, 1998
[6] Brenda Moncla. Business Metadata Integration. September1999,DM Review. (http://www.dmreview.com/editorial/dmreview/print_action. cfm?Edid=1364).
[7] 蕭凱文、薛志達、李政輝，架構企業決策支援系統- Microsoft SQL Server7.0 OLAP Services設計與實務應用，微軟出版社，1999。
[8] XML, http://www.w3.org/XML
[9] XBRL, http://www.xbrl.org
[10] ACORD, http://www.acord.com
[11] RossetaNet, http://www.rosettanet.org/rosettanet/Rooms/DisplayPages/LayoutInitial
[12] Microsoft. Open Information Model. http://msdn.microsoft.com/repository/OIM
[13] Object Management Group(OMG). Common Warehouse Metamodel(CWM) Specification, 2000. OMG Document ad/00-01-01, ad/00-01-02, ad/00-01-03, ad/00-01-11, http://www.cwmforum.org.
[14] T.Vetterli, A. Vaduva, and M. Staudt. Metadata standards for data warehousing: Open Information Model vs. Common Warehouse Metamodel. ACM Sigmod Record, 29(3), September 2000.
[15] A. Vaduva, and K.R. Dittrich. Metadata management for data warehousing: between vision and reality. Database Engineering & Applications, 2001 International Symposium on. , 2001 Page(s): 129 -135
[16] KXEN brochure, http://www.kxen.com/products
[17] The BizTalk Framework, http://www.microsoft.com/biztalk
[18] Electronic Business XML(ebXML), http://www.ebxml.org
[19] http://www.w3.org/XML/Datamodel.html
[20] An Oracle White Paper, "ETL Processing within Oracle9i", June 2001