以預存程序為基礎的主動式資料庫應用系統
之設計與建置

在知識經濟時代的來臨時企業都想到做好知識管理，然而要做好知識管理的第一步就是要做好資料庫管理。大部份的企業都已完成架構許多的管理系統，如企業資源規劃系統(Enterprise Resource Planning)、供應鏈管理系統(Supply Chain Management)、客戶關係管理系統(Customer Relationship Management)及高階主管資訊系統(Executive Information System)等，這些系統的需要效能極佳的資料庫支持，故如何架構一個適合的資料庫系統，就成為當今重要之議題。其中在提供企業快速反應及複雜的企業邏輯運算中，最常使用的就是主動式資料庫應用系統。本論文主要研究主題乃是以SQL-3的預存程序技術，建立以法則為基礎的主動式資料庫應用系統，使企業的管理系統可以即時計算多層次複雜公式運算。這樣不但使得系統可以有更有效率的運算架構，也讓資料能夠更快速的反應現況。本研究具體的貢獻包括： 1. 以預存程序建立主動式資料庫應用系統 2. 運用主動式資料庫系統的優點，建置含有排放量複雜公式空氣污染管理系統 3. 運用XML技術來整合動態網頁、企業元件與主動式資料庫。 4. 提供以預存程序為基礎之主動式資料庫的效能測試此種使用預存程序來建立主動式資料庫的方式，將有效降少系統開發的時間，也改進了傳統被動式資料庫的設計方法。

關鍵字

預存程序；主動法則；主動式資料庫

並列摘要

Graduating into the Knowledge-Based Economy, the individual companies will notices the new rules for management. Enterprises are now an information society in a knowledge economy where knowledge management is essential. In order to make good point of knowledge management, first of all, the enterprises must have a perfect database management system. As result as the most of all individual companies have built a lot of management systems which include ERP (Enterprise Resource Planning), SCM(Supply Chain Management), CRM(Customer Relationship Management) and EIS(Executive Information Systems), etc. All above management systems are supported by efficient database systems. For the reason, building the suitable database systems is important point of view. Active database application systems are the most often used and severed to solve complicated and logical operations. The content of the concrete study is to build the active database application systems which are based on a active rule with store procedure technology of SQL-3. The systems will make the enterprise’s management systems could calculate gradational and complicated operations. The systems would enable the efficiency of operation and show the result as soon as possible. The contributions of the research as follows: 1. Using the store procedure build active database application systems. 2. Using the advantages of active database system build the air pollution management systems. 3. Using the XML technology integrates dynamic web page, enterprise component and active database. 4. Providing performance testing of store procedure which is based on active database application systems. The active database application systems built by store procedure will not only reduce the time of development but also improve the design methodology of the traditional passive database.

並列關鍵字

Active Database ； Active Rule ； Store Procedure

參考文獻

[1] Codd, “A Relational Model of Data for Large Shared Data Banks”, Communication of ACM, 1970

[4] Catriel Beeri、Tova Milo，”A Model for Active Object Oriented Databases”，VLDB，1991

[5] Stefano Ceri，”A Declarative Approach to Active Databases”，ICDE，1992

[6] Dinn, A.、Paton N.、Williams M、Fernandes，”An active rule language for ROCK & ROLL. In Proceedings of the Fourteenth British National Conference on Databases”, Springer-Verlag

[7] . Dayal, A. Buchmann, D. McCarthy. “Rules are Objects too: a Knowledge Model for an Active, Object-oriented Database System”. In Proceedings of the Intl. Workshop on Object-Oriented Database Systems, Lecture Notes in Computer Science 334, Springer, 1988

國際替代計量

以預存程序為基礎的主動式資料庫應用系統之設計與建置

未授權

主題瀏覽