XML Data Management in Object Relational Database Systems

Since the advent of XML, there has been significant research into integrating XML data management with Relational DBMS and Object Relational DBMS (ORDBMS). This chapter describes the XML data management capabilities in ORDBMS, various design approaches and implementation techniques to support these capabilities, as well as the pros and cons of each design and implementation approach. Key topics such as XML storage, XML Indexing, XQuery and SQL/XML processing, are discussed in depth presenting both academic and industrial research work in these areas.

Download Full-text

XML Native Storage and Query Processing

Advanced Applications and Structures in XML Processing ◽

10.4018/978-1-61520-727-5.ch001 ◽

2010 ◽

pp. 1-17

Author(s):

Ning Zhang ◽

Tamer M. Özsu

Keyword(s):

Data Management ◽

Query Processing ◽

System Performance ◽

Data Exchange ◽

Xml Data ◽

Pros And Cons ◽

The Subject ◽

Xml Indexing ◽

Processing Techniques ◽

Xml Data Management

As XML has evolved as a data model for semi-structured data and the de facto standard for data exchange (e.g., Atom, RSS, and XBRL), XML data management has been the subject of extensive research and development in both academia and industry. Among the XML data management issues, storage and query processing are the most critical ones with respect to system performance. Different storage schemes have their own pros and cons. Some storage schemes are more amenable to fast navigation, and some schemes perform better in fragment extraction and document reconstruction. Therefore, based on their own requirements, different systems adopt different storage schemes to tradeoff one set of features over the others. In this chapter, the authors review different native storage formats and query processing techniques that have been developed in both academia and industry. Various XML indexing techniques are also presented since they can be treated as specialized storage and query processing tools.

Download Full-text

XML in the World of (Object-)Relational Database Systems

Information Systems Development ◽

10.1007/0-387-28809-0_7 ◽

2006 ◽

pp. 63-76

Author(s):

Irena Mlynkova ◽

Jaroslav Pokorny

Keyword(s):

Relational Database ◽

Database Systems ◽

The World ◽

Object Relational ◽

Relational Database Systems

Download Full-text

Soft Computing in XML Data Management

10.1007/978-3-642-14010-5 ◽

2010 ◽

Cited By ~ 1

Keyword(s):

Data Management ◽

Soft Computing ◽

Xml Data ◽

Xml Data Management

Download Full-text

Approximation and Scoring for XML Data Management

Communications in Computer and Information Science - Software and Data Technologies ◽

10.1007/978-3-540-88655-6_18 ◽

2008 ◽

pp. 243-256

Author(s):

Giacomo Buratti ◽

Danilo Montesi

Keyword(s):

Data Management ◽

Xml Data ◽

Xml Data Management

Download Full-text

Object-Relational Spatial Indexing

Spatial Databases ◽

10.4018/978-1-59140-387-6.ch003 ◽

2011 ◽

pp. 49-80

Author(s):

Hans-Peter Kriegel ◽

Martin Pfeifle ◽

Marco Potke ◽

Thomas Seidl ◽

Jost Enderle

Keyword(s):

Spatial Data ◽

Concurrency Control ◽

Buffer Management ◽

Database Systems ◽

Data Types ◽

Spatial Access ◽

Access Methods ◽

Object Relational ◽

Relational Database Systems ◽

Spatial Access Methods

In order to generate efficient execution plans for queries comprising spatial data types and predicates, the database system has to be equipped with appropriate index structures, query processing methods and optimization rules. Although available extensible indexing frameworks provide a gateway for seamless integration of spatial access methods into the standard process of query optimization and execution, they do not facilitate the actual implementation of the spatial access method. An internal enhancement of the database kernel is usually not an option for database developers. The embedding of a custom, block-oriented index structure into concurrency control, recovery services and buffer management would cause extensive implementation efforts and maintenance cost, at the risk of weakening the reliability of the entire system. The server stability can be preserved by delegating index operations to an external process, but this approach induces severe performance bottlenecks due to context switches and inter-process communication. Therefore, we present the paradigm of object-relational spatial access methods that perfectly fits to the common relational data model, and is highly compatible with the extensible indexing frameworks of existing object-relational database systems, allowing the user to define application-specific access methods.

Download Full-text

A Component-Based Framework for the Integration and Exploration of XML Sources

Advances in Data Mining and Database Management - XML Data Mining ◽

10.4018/978-1-61350-356-0.ch015 ◽

2011 ◽

pp. 343-377

Author(s):

Pasquale De Meo ◽

Antonino Nocera ◽

Domenico Ursino

Keyword(s):

Data Management ◽

Xml Data ◽

Component Based Development ◽

Abstraction Levels ◽

Development Paradigm ◽

Xml Data Management

Handling the interoperability issues in multiple, heterogeneous XML sources is central in XML data management and mining. In this chapter, we present a framework for the intensional integration and exploration of XML sources. Specifically, we propose a three-layer framework aimed at extracting interschema knowledge from the available sources, constructing a hierarchy based on the extracted knowledge to represent the sources at different abstraction levels, and finally organizing and exploring the sources through the constructed hierarchy. We also describe possible implementations of each of the three layers, focusing on the extraction of intensional interschema properties, the intensional integration of XML sources, and the clustering of XML schemas. In order to better handle the complexity of its activities, the proposed framework has been designed by means of the layers architecture patterns and the component-based development paradigm.

Download Full-text

XQBE

Visual Languages for Interactive Computing ◽

10.4018/978-1-59904-534-4.ch017 ◽

2011 ◽

pp. 357-387

Author(s):

Alessandro Campi

Keyword(s):

Data Management ◽

Visual Representation ◽

Integrity Constraints ◽

Considerable Effort ◽

Xml Data ◽

Xml Documents ◽

Programming Skills ◽

The One ◽

Definition Of ◽

Xml Data Management

This Chapter describes a visual framework; called XQBE; that covers the most important aspects of XML data management; spanning the visualization of XML documents; the formulation of queries; the representation and specification of document schemata; the definition of integrity constraints; the formulation of updates; and the expression of reactive behaviors in response to data modifications. All these features are strongly unified by a common visual abstraction and a few recurrent paradigms; so as to provide a homogeneous and comprehensive environment that allows even users without advanced programming skills to deal with nontrivial XML data management and transformation tasks. The intrinsic ambiguity inherent in any visual representation of richly expressive languages required a considerable effort of formalization in the semantics of XQBE that eventually lead to a solution with major advantages in terms of intuitiveness. In other words; this means that the unique (and unambiguous) effect of a statement is the one the user would expect.

Download Full-text