Oracle8i-the XML enabled data management system

Banerjee, Sandeepan; Krishnamurthy, Vishu; Krishnaprasad, Muralidhar; Murthy, Ravi

doi:10.1109/icde.2000.839454

Cited by 45 publications

(28 citation statements)

References 0 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…On the commercial side, database vendors are busily extending their databases to adopt XML types. Typically, they can handle XML data using BLOB/CLOB formats along with a limited keyword searching or using some object-relational features [5,1], but not many details have been revealed. On the research side, various proposals have been made recently.…”

Section: Conversion Methods Between Xml and Relational Modelsmentioning

confidence: 99%

Supporting XML Security Models Using Relational Databases: A Vision

Lee

Liu

2003

Database and XML Technologies

View full text Add to dashboard Cite

Abstract. As the secure distribution and sharing of information over the World Wide Web becomes increasingly important, the needs for flexible and efficient support of access control systems naturally arise. Since the eXtensible Markup Language (XML) is emerging as the format of the Internet era for storing and exchanging information, there have been, recently, many proposals to extend the XML model to incorporate security aspects. To the lesser or greater extent, however, such proposals neglect the fact that the data for XML documents will most likely reside in relational databases, and consequently do not utilize various security models proposed for and implemented in relational databases. In this paper, we take a rather different approach. We explore how to support security models for XML documents by leveraging on techniques developed for relational databases. More specifically, in our approach, (1) Users make XML queries against the given XML view/schema, (2) Access controls for XML data are also specified in the XML model, but (3) Data are stored in relational databases, and (4) Security check and query evaluation are also done in relational databases. Instead of re-inventing wheels, we take two representative methods in both XML security model and XML to relational conversion problems, and show how to glue them together in a seamless manner to efficiently support access controls for the XML model using relational databases.

show abstract

Section: Conversion Methods Between Xml and Relational Modelsmentioning

confidence: 99%

Supporting XML Security Models Using Relational Databases: A Vision

Lee

Liu

2003

Database and XML Technologies

View full text Add to dashboard Cite

show abstract

“…This is a native datatype introduced in Oracle 8i [4]. Built using the object relational infrastructure, the XMLType is similar to other built-in datatypes such as number and character.…”

Section: Introductionmentioning

confidence: 99%

Query Rewrite for XML in Oracle XML DB

Krishnaprasad

LIU

Manikutty

et al. 2004

Proceedings 2004 VLDB Conference

View full text Add to dashboard Cite

Oracle XML DB integrates XML storage and querying using the Oracle relational and object relational framework. It has the capability to physically store XML documents by shredding them as relational or object relational data, and creating logical XML documents using SQL/XML publishing functions. However, querying XML in a relational or object relational database poses several challenges. The biggest challenge is to efficiently process queries against XML in a database whose fundamental storage is table-based and whose fundamental query engine is tuple-oriented. In this paper, we present the 'XML Query Rewrite' technique used in Oracle XML DB. This technique integrates querying XML using XPath embedded inside SQL operators and SQL/XML publishing functions with the object relational and relational algebra. A common set of algebraic rules is used to reduce both XML and object queries into their relational equivalent. This enables a large class of XML queries over XML type tables and views to be transformed into their semantically equivalent relational or object relational queries. These queries are then amenable to classical relational optimisations yielding XML query performance comparable to relational. Furthermore, this rewrite technique lays out a foundation to enable rewrite of XQuery [1] over XML.

show abstract

“…In the latter a fixed database schema is used to store any XML documents without the assistance of XML Schema (DTD), such as [12][6] [13][14] [15]. Again, commercial database proposes particular alternatives to store XML documents, such as [16][17] [18].…”

Section: Introductionmentioning

confidence: 99%

Analysis of different approaches for storing GML documents

Córcoles

González

2002

Proceedings of the 10th ACM International Symposium on Advances in Geographic Information Systems

View full text Add to dashboard Cite

The fact that GML is an XML encoding allows it to be queried. In order to query a GML document we have designed a query language over GML/XML enriched with spatial operators. This query language has an underlying data model and algebra that supplies the semantics of the query language. In order to use this query language, it is necessary to find an implementation that allows us to exploit all its features, storing GML documents efficiently. The general aim of this paper is to study the behaviour of different alternatives over XML documents (alphanumeric data) applied to store and query GML documents (alphanumeric and spatial data). The alternatives selected use relational schemas to store GML documents because they use a complete set of data management services (including concurrency control, crash recovery, scalability, etc) and benefit from the highly optimised relational query processor. Three approaches have been used: LegoDB, a structure-mapping approach, and two simple model-mapping approaches, Monet over Relational database and XParent. We focus on the effectiveness of storage models in terms of query processing. A performance study is conducted using three data sets and the experimental results are given.

show abstract

Oracle8i-the XML enabled data management system

Cited by 45 publications

References 0 publications

Supporting XML Security Models Using Relational Databases: A Vision

Supporting XML Security Models Using Relational Databases: A Vision

Query Rewrite for XML in Oracle XML DB

Analysis of different approaches for storing GML documents

Contact Info

Product

Resources

About