DEVELOPMENT OF AN XML-BASED PARSING SYSTEM FOR INTEGRATING HETEROGENEOUS DATABASES

Abstract

Research in the area of data integration has resulted in approaches such as federated and multi-databases, mediation, data warehousing, global information systems, and the model management/schema matching approach. This thesis describes an approach for mediation of heterogeneous databases and follows this approach for data integration. Syntactic structure is an important feature of natural language utterances, for both form and content. Therefore, applications of this thesis benefit from the integration of syntax into their schema integration models of database. The idea of this thesis is to develop a new model for integrating heterogeneous databases using the XML features and parsing algorithms which use database commands instead of literal strings A new XML-based model is presented in the thesis, along with a parsing algorithm: recursive descent parser of sentence structure, that is modify to acceptable relational database statement to use XML as the internal data model for schema integration. To build this model, thesis uses recursive descent parser algorithm which uses the method Top-Down to analyze statement databases and modify the Extended and Augmented Backus–Naur Forms (EBNF) grammar to become suitable to relational databases statements.