利用分散式架構建立企業虛擬DBA之應用-以M公司為例

企業因應不同業務流程而建立了各種輔助作業之資訊系統，系統所使用之資料庫規模會隨業務流程擴展而成長，資料庫管理人員的負擔與挑戰也會逐漸加大，不同資料庫之間的關聯性也會因交叉參考而日漸複雜，使系統開發人員找尋正確資料來源需花費的時間變長。本論文研究利用相關技術文獻之研究，以分散式架構來建立虛擬DBA管理系統，期望利用系統管理功能來集中管理資料來源之綱要(Schema)與權限，協助資料庫管理人員及系統開發人員進行日常資料庫之維護及管理工作，透過建立資料來源關聯，以及系統與人員職掌資料的建立，能方便以應用系統為構面之管理角度來管理資料庫，也方便系統開發人員快速取得相關資料庫資訊，進而增加開發之效率，以及提高系統之穩定度，確保公司流程運作順暢。

關鍵字

分散式架構、虛擬DBA、資料庫管理、資訊安全、物件導向分析設計

並列摘要

The enterprise establishes information system to deal with different operation flow. Therefore, the scale of databases expand along with the operation flow grows. The database administrator’s burden and the challenge also enlarge. In addition, the inter connection between the different databases’ become more complex day by day. It also lengthen the system developer to pursue the correct data source. This study use relation technique to establish the Virtual DBA management system by the distributed architecture. The goal is to expect that the system administration can summarize of Schema and the jurisdiction centralized management data source. It also assists the database administrator and the system developer carries on maintenance and the supervisory work. By establishment of the data source connection, as well as the system and the personnel duties material's establishment, it can facilitate the management of the database with the system architecture. The study also facilitates the system developer to obtain the related database information fast, then increases efficiency of the development, as well as enhances stability of the system, guaranteed that the company flow operation is smooth.

並列關鍵字

Distributed Architecture、Virtual DBA、Database Management、Information Security、Object Oriented Analysis & Design

參考文獻

[5] 吳國樑，資料庫線上核發系統規劃研究-以C公司為例，碩士論文，2008。

[4] 劉明修，以夥伴關係管理概念建構一SOA之電子化採購系統，碩士論文， 2008。

[15] Jen-Her Wu; Tse-Chih Hsia; I-Chia Chang; Sun-Jen Tsai; Application generator: a framework and methodology for IS construction ,System Sciences, 2003. Proceedings of the 36th Annual Hawaii International Conference on , 6-9 Jan. 2003 Pages:263 – 272.

第六章、參考文獻