Integrating XML and Relational Database Systems

Kappel, Gerti; Kapsammer, Elisabeth; Retschitzegger, Werner

doi:10.1023/b:wwwj.0000040896.89535.6b

Cited by 30 publications

(20 citation statements)

References 37 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…For integrating XML and relational databases, Kappel et al [10] give a comprehensive comparison of the concepts and corresponding mapping patterns between XML and relational databases. In [10] and their X-Ray approach [9], three basic kinds of mappings ET R direct/indirect (an XML element to a relation), ET A direct/indirect (an XML element to an attribute of a relation) and A A direct/indirect (an XML attribute to an attribute of a relation) have been proposed and reasonable mappings of these three basic mapping patterns from DTD to relational schema have been discussed.…”

Section: Related Workmentioning

confidence: 99%

Constraint Preserving Transformation from Relational Schema to XML Schema

2005

View full text Add to dashboard Cite

Abstract. XML has become the standard for publishing and exchanging data on the Web. However, most business data is managed and will remain to be managed by relational database management systems. As such, there is an increasing need to efficiently and accurately publish relational data as XML documents for Internetbased applications. One way to publish relational data is to provide virtual XML documents for relational data via an XML schema which is transformed from the underlying relational database schema such that users can access the relational database through the XML schema. In this paper, we discuss issues in transforming a relational database schema into the corresponding XML schema. We aim to preserve all integrity constraints defined in a relational database schema, to achieve high level of nesting and to avoid introducing data redundancy in the transformed XML schema. In the paper, we first propose a basic transformation algorithm which introduces no data redundancy, then we improve the algorithm by exploring further nesting of the transformed XML schema.

show abstract

Section: Related Workmentioning

confidence: 99%

Constraint Preserving Transformation from Relational Schema to XML Schema

2005

View full text Add to dashboard Cite

show abstract

“…Due to a lack of interoperability, however, it is often difficult to use tools in combination, thus the potential of modeldriven software development cannot be fully exploited. In collaboration with the Austrian Ministry of Defense and based on experiences gained in various integration scenarios, e.g., [17], [27] we are currently realizing a system called ModelCVS which aims at enabling tool integration through transparent transformation of models between metamodels representing different tools' modeling languages. However, metamodels typically serve as an abstract syntax of a modeling language and often also as an object-oriented data structure in which models are stored.…”

Section: Introductionmentioning

confidence: 99%

Lifting Metamodels to Ontologies: A Step to the Semantic Integration of Modeling Languages

Kappel

Kapsammer

Kargl

et al. 2006

Lecture Notes in Computer Science

Self Cite

View full text Add to dashboard Cite

Abstract. The use of different modeling languages in software development makes their integration a must. Most existing integration approaches are metamodel-based with these metamodels representing both an abstract syntax of the corresponding modeling language and also a data structure for storing models. This implementation specific focus, however, does not make explicit certain language concepts, which can complicate integration tasks. Hence, we propose a process which semi-automatically lifts metamodels into ontologies by making implicit concepts in the metamodel explicit in the ontology. Thus, a shift of focus from the implementation of a certain modeling language towards the explicit reification of the concepts covered by this language is made. This allows matching on a solely conceptual level, which helps to achieve better results in terms of mappings that can in turn be a basis for deriving implementation specific transformation code.

show abstract

“…Therefore, this section discusses the most crucial heterogeneity aspects. For a more detailed discussion it is referred to [9].…”

Section: A Tour On Dtds Xml Schema and Rdbsmentioning

confidence: 99%

“…On the basis of a database schema and an XML schema, the user may interactively specify the required mappings, guided by proposed mapping patterns (cf. [9]). As soon as the system is initialized with the mapping knowledge which is stored within the meta schema repository, the user is able to transparently issue queries using XQuery [18] against a virtual XML view.…”

Section: Architecturementioning

confidence: 99%

See 1 more Smart Citation

XML-based EIS — A Meta Schema for Mapping XML Schema to Relational DBS

Kapsammer

IFIP International Federation for Information Processing

Self Cite

View full text Add to dashboard Cite

Abstract. Enterprise information systems (EIS) often employ relational database systems to store their content. At the same time, XML constitutes the dominant standard for data exchange as well as for the hypertext level of webenabled EIS. Thus, the integration of XML with relational database systems to allow the storage, retrieval, and update of XML documents is of paramount importance in the context of EIS. Data model heterogeneity and schema heterogeneity, however, make this a challenging task. This paper proposes XRay, a generic approach facilitating the composition of XML documents out of a relational database system as well as the decomposition of XML documents to store them within a relational database system in a fully transparent way. This is achieved by means of a generic meta schema that stores all relevant information for the composition and decomposition process. This meta schema covers both, the concepts of DTDs and XML Schema concepts.

show abstract

Integrating XML and Relational Database Systems

Cited by 30 publications

References 37 publications

Constraint Preserving Transformation from Relational Schema to XML Schema

Constraint Preserving Transformation from Relational Schema to XML Schema

Lifting Metamodels to Ontologies: A Step to the Semantic Integration of Modeling Languages

XML-based EIS — A Meta Schema for Mapping XML Schema to Relational DBS

Contact Info

Product

Resources

About