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

Abstract

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

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.