多维数据建模工具的分析与实现-计算机技术专业论文.docxVIP

华中科技大学硕士学位论 华 中 科 技 大 学 硕 士 学 位 论 文 IV IV type:dimension table and fact tabe.They are respectively transfromed from the dimension and fact.Fact table foreign key way through the dimension table is connected to the primary key. The tool also can generate SQL script,then it can change the multi-dimensional physical model into relational tables.Taking into account the XML view can be reflected from the model structure,that is its good scalability and versatility,multi-dimensional physical model and the refe rred multi-dimensional conceptual model in the last paragraph are imported and exported by it.Resulting XML document is the multi-dimensional data model metadata. In the OLAP to multi-dimensional conceptual reverse engineering,it extracts from multidimensional data model under the interface provided by DM company,convert it to the conceptual model in the tool,modifying the model ,then input the refined model into the OLAP server,so it achieve the optimal of OLAP multidimensional data model in the circle.Morover we will find that the existing multidimensional data model is the same with the multidimensional conceptual to be constructed.Similar to the above case,in entity-relationship database to multidimensional physical model reversing engineering.We extracted the relation tables in DM database through the JDBC interface provided by DM database,transforming them into multidimensional physical model in the modeling tool,it also achieved optimization of entity-relationgship model. Keywords :data warehouse,multidimensional data model,online analytical processing, online transactions processing,metadata. 独创性声明 本人声明所呈交的学位论文是我个人在导师指导下进行的研究工作及取得的研 究成果。尽我所知，除文中已经标明引用的内容外，本论文不包含任何其他个人或 集体已经发表或撰写过的研究成果。对本文的研究做出贡献的个人和集体，均已在 文中以明确方式标明。本人完全意识到，本声明的法律结果由本人承担。 学位论文作者签名： 日期：2011 年 月 日 学位论文版权使用授权书 本学位论文作者完全了解学校有关保留、使用学位论文的规定，即：学校有权 保留并向国家有关部门或机构送交论文的复印件和电子版，允许论文被查阅和借阅。 本人授权华中科技大学可以将本学位论文的全部或部分内容编入有关数据库进行检 索，可以采用影印、缩印或扫描等复制手段保存和汇编本学位论文。 保密□ ，在 年解密后适用本授权书。 本论文属于  不保密□。 （请在以上方框内