【正文】
。 關(guān)鍵詞 : 數(shù)據(jù)庫(kù), 元數(shù)據(jù), WEB, III METADATA MANAGEMENT SYSTEM OF DATABASE ABSTRACT There is a big problem in the current data warehouse project that has been built, we have dispute on data, because of the inconsistent definitions which led an inconsistent indicator on data, and this makes the credibility of database system decreases. In order to clarify these issues, we need to reverse lookup the definition of these tables in database and the relationship between these tables. To avoid similar problems like this, we build a metadata management platform. After the pletion of metadata management platform, we can extract the metadata. We clearly see the relationship between tables and fields in this platform. Users can easily modify the data in database through the platform after data extraction, so that to adjust the statistical indicators of business and so on. Integration and visibility of metadata, which help departments see the definition and storage location of data, and minimize the plexity of information. Based on the knowledge of metadata, the author has developed a metadata management system bined with actual demand, and the system is put into operation now. The design of this system is based on , and ultimately, we can manage database and metadata in WEB interface. In the procedure of development, we followed the rule of Software Engineering, the system platform and scalability has unique design, with practical and advanced. Key words: Database, metadata, WEB, IV 目 錄 1. 緒論 .............................................................................................................................................. 1 . 開(kāi)發(fā)背景及意義 ................................................................................................................... 1 . 系統(tǒng)開(kāi)發(fā)的目標(biāo) ................................................................................................................... 2 . 全文概要 ............................................................................................................................. 2 2. 系統(tǒng)需求分析 ................................................................................................................................ 3 . 用戶需求 ............................................................................................................................. 3 . 功能性需求 .................................................................................................................. 3 . 技術(shù)需求 ..................................................................................................................... 3 . 功能分析 ............................................................................................................................. 4 . 數(shù)據(jù)流圖 ............................................................................................................................. 5 . 頂層圖 ......................................................................................................................... 5 . 零層圖 ......................................................................................................................... 5 . 一層圖 ......................................................................................................................... 6 . 可行性研究 .......................................................................................................................... 6 3. 系統(tǒng)總體設(shè)計(jì) ................................................................................................................................ 7 . 架構(gòu)設(shè)計(jì) ............................................................................................................................. 7 . 系統(tǒng)運(yùn)行環(huán)境 .............................................................................................................. 7 . B/S 構(gòu)架 ...................................................................................................................... 7 . SQL Server 數(shù)據(jù)庫(kù) ........................................................................................................ 8 . ASP 編程語(yǔ)言 .............................................................................................................. 9 . 數(shù)據(jù)庫(kù) ER模型 ................................................................................................................. 10 . 系統(tǒng)模塊結(jié)構(gòu)圖 ................................................................................................................. 10 4. 系統(tǒng)程序設(shè)計(jì)及實(shí)現(xiàn) ................................................................................................................... 11 . 數(shù)據(jù)庫(kù)設(shè)計(jì) ........................................................................................................................ 11 . 數(shù)據(jù)流條目 ................................................................................................................ 11 . 數(shù)據(jù)項(xiàng)條目 ................................................................................................................ 12 . 數(shù)據(jù)結(jié)構(gòu)說(shuō)明 ............................................................................................................ 17 V . 元數(shù)據(jù)庫(kù)設(shè)計(jì)說(shuō)明 ..................................................................................................... 19 . 系統(tǒng)模塊設(shè)計(jì) .................................................................................................................... 22 . 模塊功能介紹 ............................................................................................................ 22 . 功能需求與程序塊的關(guān)系 ........................................................................................... 23 . 人工處 理過(guò)程 ............................................................................................................ 24 . 接口設(shè)計(jì) ................................................................................................................... 24 . 庫(kù)信息瀏覽模塊 ...................................................................