Bridging XML-schema and relational databases: a system for generating and manipulating relational databases using valid XML documents

Authors:
Iraklis Varlamis;Michalis Vazirgiannis
Affiliations:
Athens University of Economics & Business, Athens, Hellas;Athens University of Economics & Business, Athens, Hellas
Venue:
DocEng '01 Proceedings of the 2001 ACM Symposium on Document engineering
Year:
2001

Citing 3
Cited 10

SilkRoute: trading between relations and XML

Proceedings of the 9th international World Wide Web conference on Computer networks : the international journal of computer and telecommunications netowrking
Techniques and Systems for Image and Video Retrieval

IEEE Transactions on Knowledge and Data Engineering
WebOQL: Restructuring Documents, Databases, and Webs

ICDE '98 Proceedings of the Fourteenth International Conference on Data Engineering

Extensible metadata framework for describing virtual reality and multimedia contents

DBA'06 Proceedings of the 24th IASTED international conference on Database and applications
An X-ray on web-available XML schemas

ACM SIGMOD Record
Translating relational schema into XML schema definition with data semantic preservation and XSD graph

Information and Software Technology
Database virtualization technology in ubiquitous computing

IIT'09 Proceedings of the 6th international conference on Innovations in information technology
Mapping XML Schema to Entity Relationship and Extended Entity Relationship Models

International Journal of Intelligent Information and Database Systems
Integrating XML schema language with databases for b2b collaborations

APWeb'06 Proceedings of the 2006 international conference on Advanced Web and Network Technologies, and Applications
Indexing and mining audiovisual data

AM'03 Proceedings of the Second international conference on Active Mining
Querying XML documents from a relational database in the presence of DTDs

ICDCIT'04 Proceedings of the First international conference on Distributed Computing and Internet Technology
An Exploratory Study of Infrastructure Barriers and the Role of Semantic Data Exchange Technologies in the Provisioning of Business Intelligence Services

International Journal of Strategic Information Technology and Applications
Towards effective organization of medical data

Proceedings of the 17th Panhellenic Conference on Informatics

Quantified Score

Hi-index	0.00

Visualization

Abstract

Many organizations and enterprises establish distributed working environments, where different users need to exchange information based on a common model. XML is widely used to facilitate this information exchange. The extensibility of XML allows the creation of generic models that integrate data from different sources. For these tasks, several applications are used to import and export information in XML format from the data repositories. In order to support this process for relational repositories we developed the X-Database system. The base of this system is an XML-Schema file that describes the logical model of interchanged information. Initially, the system analyses the syntax of the XML-Schema file and generates the relational database. Then it handles the decomposition of valid XML files according to that Schema and the composition of XML documents from the information in the database. Finally the system offers a flexible mechanism for modifying and querying database contents using only valid XML documents, which are validated over the XML-Schema file's rules.