Data Warehouse Metadata Management Platform Based on Semantic Web

• Main Authors: Shih-Ta Cho, 卓世達
• Other Authors: Ching-Long Yeh
• Format: Others
• Language: zh-TW
• Published: 2014
• Online Access: http://ndltd.ncl.edu.tw/handle/qa8j3j

碩士 === 大同大學 === 資訊工程學系(所) === 102 === The presence of a data warehouse system is designed to provide accurate and valuable analytical information, however, to create and maintain a clean and meaningful data is a tedious maintenance operation. In addition to combine all data generated by different applications, more and more complicate extraction, transform and load operation is needed. In the processes of developments , all relevant documents of system specification and information are quickly produced for different kind of roles (such as warehousing developer, database administrators, system administrators, data analysts, etc.) needs, but it is not easy to find out the right information for all these roles. The objective of this thesis is to build up a data warehousing metadata management platform based on semantic web technology. Through analysis of the data warehouse system documents generated during system maintenance and operation, defined all terms of categories and attributes, and connect each objects via connection attribute. The main ontology model for the management platform will be built. Furthermore, through the real case of simulation tests, the result of this study validate this platform can provide the feasibility of information searching by different kind of roles. Also, the ontology model could be the core module for development of data warehouse metadata management platform, to implement the semantic query interface, the RDF store or data administration client. And how to apply this model for Big Data is one of the future research direction.