搜索
上海电力学院本科毕业设计（论文）题目：数据库元数据管理系统设计与实现院系：专业年级：2009级学生姓名：学号：指导教师：2013年6月1日II数据库元数据管理系统设计与实现摘要元数据管理平台的建设，是为了避免数据信息定义不明引起的争议。在元数据管理平台建成之后，可以实现对技术元数据的抽取。在这个平台上，就能清晰地看到这些表或字段之间的关联关系。把这些元数据抽取出来后，用户可以通过平台很方便的修改数据仓库中的数据，调整业务中的统计指标等等。元数据的集成和可见性帮助各部门了解存在哪些数据、数据存储位置及其含义，从而最大限度的降低信息复杂性。作者基于对元数据的了解和认识后，结合实际需求开发了元数据管理系统，并投入实际运行。该系统使用ASP.NET进行开发设计，最终实现以WEB界面的方式，进行对数据库的元数据管理和相应数据库管理。在项目开发过程中，遵循软件工程的开发模式，系统在平台化和扩展性方面具有独到的设计，具有实用性和先进性。关键词：数据库，元数据，WEB，ASP.NETIIIMETADATAMANAGEMENTSYSTEMOFDATABASEABSTRACTThereisabigprobleminthecurrentdatawarehouseprojectthathasbeenbuilt,wehavedisputeondata,becauseoftheinconsistentdefinitionswhichledaninconsistentindicatorondata,andthismakesthecredibilityofdatabasesystemdecreases.Inordertoclarifytheseissues,weneedtoreverselookupthedefinitionofthesetablesindatabaseandtherelationshipbetweenthesetables.Toavoidsimilarproblemslikethis,webuildametadatamanagementplatform.Afterthecompletionofmetadatamanagementplatform,wecanextractthemetadata.Weclearlyseetherelationshipbetweentablesandfieldsinthisplatform.Userscaneasilymodifythedataindatabasethroughtheplatformafterdataextraction,sothattoadjustthestatisticalindicatorsofbusinessandsoon.Integrationandvisibilityofmetadata,whichhelpdepartmentsseethedefinitionandstoragelocationofdata,andminimizethecomplexityofinformation.Basedontheknowledgeofmetadata,theauthorhasdevelopedametadatamanagementsystemcombinedwithactualdemand,andthesystemisputintooperationnow.ThedesignofthissystemisbasedonASP.NET,andultimately,wecanmanagedatabaseandmetadatainWEBinterface.Intheprocedureofdevelopment,wefollowedtheruleofSoftwareEngineering,thesystemplatformandscalabilityhasuniquedesign,withpracticalandadvanced.Keywords:Database,metadata,WEB,ASP.NETIV目录1.绪论.................................................................................................................................................................11.1.开发背景及意义...................................................................................................................................11.2.系统开发的目标...................................................................................................................................21.3.全文概要..............................................................................................................................................22.系统需求分析.................................................................................................................................................32.1.用户需求..............................................................................................................................................32.1.1.功能性需求.................................................................................................................................32.1.2.技术需求.....................................................................................................................................32.2.功能分析..............................................................................................................................................42.3.数据流图..............................................................................................................................................52.3.1.顶层图.........................................................................................................................................52.3.2.零层图.........................................................................................................................................52.3.3.一层图.........................................................................................................................................62.4.可行性研究..........................................................................................................................................63.系统总体设计.................................................................................................................................................73.1.架构设计..............................................................................................................................................73.1.1.系统运行环境.............................................................................................................................73.1.2.B/S构架......................................................................................................................................73.1.3.SQLServer数据库.......................................................................................................................83.1.4.ASP编程语言.............................................................................................................................93.2.数据库ER模型.................................................................................................................................103.3.系统模块结构图.................................................................................................................................104.系统程序设计及实现.........................................................