Cardiff University | Prifysgol Caerdydd ORCA
Online Research @ Cardiff 
WelshClear Cookie - decide language by browser settings

Establishing an XML metadata knowledge base to assist integration of structured and semi-structured databases

Al-Wasil, Fahad M., Gray, William Alexander and Fiddian, Nicholas John 2006. Establishing an XML metadata knowledge base to assist integration of structured and semi-structured databases. Presented at: 17th Australasian Database Conference, Hobart, Australia, 16-19 January 2006. Published in: Dobbie, Gill and Bailey, James eds. Database technologies 2006 : proceedings of the 17th Australasian Database Conference (ADC2006). Conferences in Research and Practice in Information Technology (49) Sydney: Australian Computer Society, pp. 69-78.

Full text not available from this repository.

Abstract

This paper describes the establishment of an XML Metadata Knowledge Base (XMKB) to assist integration of distributed heterogeneous structured data residing in relational databases and semi-structured data held in well-formed XML documents (XML documents that conform to the XML syntax rules but have no referenced DTD or XML schema) produced by internet applications. We propose an approach to combine and query the data sources through a mediation layer. Such a layer is intended to establish and evolve an XMKB incrementally to assist the Query Processor to mediate between user queries posed over the master view and the distributed heterogeneous data sources. The XMKB is built in bottom-up fashion by extracting and merging incrementally the metadata of the data sources. The XMKB is introduced to maintain the data source information (names, types and locations), meta-information about relationships of paths among data sources, and function names for handling semantic and structural discrepancies. A System to Integrate Structured and Semi-structured Databases (SISSD) has been built that generates a tool for a meta-user (who does the metadata integration) to describe mappings between the master view and local data sources by assigning index numbers and specifying conversion function names. This system is flexible: users can get any master view from the same set of data sources depending on their interest. It also preserves local autonomy of the local data sources. The SISSD uses the local-as-view approach to map between the master view and the local schema structures. This approach is well-suited to supporting a dynamic environment, where data sources can be added to or removed from the system without the need to restructure the master view and to regenerate the XMKB from scratch.

Item Type: Conference or Workshop Item (Paper)
Date Type: Publication
Status: Published
Schools: Computer Science & Informatics
Subjects: Q Science > QA Mathematics > QA75 Electronic computers. Computer science
Publisher: Australian Computer Society
ISBN: 1920682317
ISSN: 1445-1336
Related URLs:
Last Modified: 04 Jun 2017 04:49
URI: https://orca.cardiff.ac.uk/id/eprint/45336

Citation Data

Cited 3 times in Scopus. View in Scopus. Powered By Scopus® Data

Actions (repository staff only)

Edit Item Edit Item