On XML and RDB Data Management for Digital Archives(II)

View Statistics Email Alert RSS Feed

Information

Details

Project title

Code/計畫編號

NSC94-2422-H019-001

Translated Name/計畫中文名

典藏數位化中結構化關聯式與半結構化XML資料管理之研究(II)

Project Coordinator/計畫主持人

Ya-Hui Chang

Funding Organization/主管機關

National Science and Technology Council

Co-Investigator(s)/共同執行人

梁德容

Department/Unit

Department of Computer Science and Engineering

Website

https://www.grb.gov.tw/search/planDetail?id=1078735

Year

2005

Start date/計畫起

01-03-2005

Expected Completion/計畫迄

03-03-2006

Bugetid/研究經費

645千元

ResearchField/研究領域

資訊科學--軟體

數位典藏計畫的主要目的，是將重要的文物資訊，以數位化電子型態的方式來儲存，目前各單位分別以關連式格式和XML 格式儲存大量的資料，因此兩種格式彼此之間達到資料共享，以及資料一致性的問題，就顯得格外重要。本計畫預計以3 年的時間進行，在去年第一年度的計畫裡，我們探討兩種格式的差異性，並以對應字典記錄之，如此可達到SQL 與XQuery 查詢語言的互相轉換的目的。今年度提出之計畫，主要是延續前期的研究成果，進一步解決典藏單位實際面臨的問題，主要研究方向如下： (1) Schema Migration：當描述文物的XMLMetadata 變動時，我們希望能有效的產生對應的關聯式表格。(2) Data Consistency：同時存在的關聯式資料與XML 資料，必須及時的確定其資料的一致性。(3) Advanced XML Query Processing：提供複雜的XML 格式資料，更有效率的查詢處理。以上問題涵蓋的技術相當複雜，包含不同資料格式的對應、不同查詢語言的轉換、互動式的系統維護、查詢模式與最佳化研究。我們預計以兩年的時間進行，相信本計畫的順利推行，將可發展新技術協助數位典藏資料庫系統的建置與維護，增加管理者與使用者的便利性。The purpose of the digital archive project is to store important cultural pieces in digital formats. Currently, data are mainly stored in relational databases and in XML format. Therefore, it is extremely important to provide a good mechanism to manage data in different format in a consistent way. We plan to take three years to study the related topics. During the first year, we have studied the differenences between their representational capabilities, which are recorded in a mapping dictionary. This information allows us to successfully transform the corresponding query language, SQL and Xquery to each other. The project proposed in this year, is to extend what we are doing now, and focus on the real problem which the archiving institue is facing. The main research topics are as follows: (1) Schema Migration: when the definition of the XML metadata is changed, we wish to create the corresponding relational schema in an effective way. (2) Data Consistency: we wish to make sure that the data in different format are in a consistent status. (3) Advanced XML Query Processing: we will propose a more efficient query processing plan for the complex XML data. The relevant techniques include schema mapping, query translation, query processing and query optimization, etc. We plan to carry out this project for two more years. We also believe that the research result of this project could help the archiving institute manage the important information in a more efficient way.

Keyword(s)

數位典藏
結構化資料
半結構化資料
資料對應
查詢語句轉換
綱要變動維護
digital archive
structure data
semi-structure data
data mapping
SQL language transformation
schema migration

DSpace CRIS

On XML and RDB Data Management for Digital Archives(II)

Details

Description