文章詳目資料

國立高雄海洋科技大學學報

  • 加入收藏
  • 下載文章
篇名 以原生型XML資料庫建構資訊設備管理之資訊系統
卷期 27
並列篇名 Using Native XML Database for Information System on Equipments Management
作者 劉俞志蘇中信朱遠達
頁次 093-111
關鍵字 原生型XML 資料庫XML 文件資訊系統半結構化資料Native XML DatabaseXML DocumentInformation SystemSemi-Structured Data
出刊日期 201303

中文摘要

資訊軟硬體設備的電子化管理多採關聯式資料庫軟體架構,但關聯式資料庫之優勢只侷限於結構化資料,對於半結構性質之各類軟硬體資料,大多採文件的格式來儲存,無法提供有效之文件內容修改與查詢。而原生型XML 資料庫可將非結構資料以整份XML 格式直接儲存,提供XML 文件的有效查詢。本研究將其用在機房內各類資訊軟硬體設備之管理系統建置,透過Oracle 9i 的原生型XML 資料庫的伺服程式,可同時查詢或修改多筆XML 文件,並藉由整合XML Schema 驗證方式以有效規範XML 文件,大幅度提昇實務上程式開發及執行的效率。本研究主要貢獻在提供一個半結構化資料的儲存與管理機制,供相關類型資料管理之資訊系統建置參考。

英文摘要

Most current information systems for managing software and hardware equipments adopt traditional relational database software as framework. However, advantages of using the relational database are limited to structured data. For the data of semi-structured property,such as the documents of software and hardware equipment, traditional relational databases have performance concern on data query. Native XML database stores the semi-structured material by the entire XML form directly, and which provide the effective query for the XML document. This study proposes a method to construct an information system for efficiently managing semi-structured documents, and uses the management of software and hardware equipments as an example. This work demonstrates the steps of using XML database server provided by Oracle 9i to store and access the documents. The system provides query and update multiple XML documents with efficient performance. The resulting systemstandardizes the XML document to promote the efficiency on system development by integrating the XML schema confirmation, and which is outperform to using traditional relational database. The contribution of this study is to provide the information system construction for semi-structured data as a reference for the data of similar structure in otherfields.

相關文獻