Towards an Industrial Strength SQL/XML Infrastructure

Krishnaprasad, Muralidhar; Liu, Z.H.; Manikutty, Anand; Warner, James W.; Arora, Vikas

doi:10.1109/icde.2005.144

Cited by 12 publications

(5 citation statements)

References 3 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…To build an industrial strength XML application, providing the XML update capability within the framework of an RDBMS is crucial. Oracle has introduced a set of XML update functions, such as deleteXML(), updateXML(), insertXML(), as extensions to SQL/XML functions in Oracle 10g [9] to address the need for declaratively updating XML at the node level. These functions provide transactional, snapshot semantics for updating XML similar to any other data type supported in the RDBMS.…”

Section: Introductionmentioning

confidence: 99%

“…Relational database systems have now implemented XML support based on the SQL/XML [14] standard which adds support for XML as a native data type, as well as XML query support using XQuery/XPath embedded in SQL functions and constructs such as XMLQuery(), XMLExists(), XMLCast(), XMLTABLE and other vendor specific extension functions [4,5,8,9].…”

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

Effective and efficient update of xml in RDBMS

Liu

Krishnaprasad

Warner

et al. 2007

Proceedings of the 2007 ACM SIGMOD International Conference on Management of Data

View full text Add to dashboard Cite

Querying XML effectively and efficiently using declarative languages such as XQuery and XPath has been widely studied in both academic and industrial settings. Most RDBMS vendors now support XML as a native data type with SQL/XML and XQuery support over it. However, the problem of updating XML is still the subject of ongoing effort. Several SQL/XML update extensions have been implemented and an XQuery Update Facility is in the proposal phase to add an update capability to XQuery. There are a lot of challenges involved in updating XML, particularly identifying and updating partial fragments of XML while maintaining concurrency, transactional semantics and validity of the document. In this paper, we illustrate the XML update functionality provided by Oracle XML DB within the context of SQL/XML. This functionality has been developed and optimized based on actual customer use cases of querying and updating XML. We discuss our design philosophy, optimization details for providing capability of updating XML and compare it with the current XQuery Update Facility proposal with the goal of providing insight into incorporating the XQuery Update Facility in the SQL/XML standard in the future.

show abstract

Section: Introductionmentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

Effective and efficient update of xml in RDBMS

Liu

Krishnaprasad

Warner

et al. 2007

Proceedings of the 2007 ACM SIGMOD International Conference on Management of Data

View full text Add to dashboard Cite

show abstract

“…We have enhanced the current Oracle XML type image [17] to accommodate the XQuery data model so that we can natively support an XQuery data model based XML type value inside the ORDBMS kernel. Our XML type image is flexible enough to support atomic values, node references, etc as required by the XQuery data model.…”

Section: Native Support Of Xquery Data Modelmentioning

confidence: 99%

Native Xquery processing in oracle XMLDB

Liu

Krishnaprasad

Arora

2005

Proceedings of the 2005 ACM SIGMOD International Conference on Management of Data

View full text Add to dashboard Cite

With XQuery becoming the standard language for querying XML, and the relational SQL platform being recognized as an important platform to store and process XML, the SQL/XML standard is integrating XML query capability into the SQL system by introducing new SQL functions and constructs such as XMLQuery() and XMLTable. This paper discusses the Oracle XMLDB XQuery architecture for supporting XQuery in the Oracle ORDBMS kernel which has the XQuery processing tightly integrated with the SQL/XML engine using native XQuery compilation, optimization and execution techniques.

show abstract

“…We used XML data types (Krishnaprasad et al, 2005;Murthy et al, 2005;Rys, 2005;Pal et al, 2005Pal et al, , 2006Ozcan et al, 2006;ISO/IEC, 2003Eisenberg & Melton, 2004) within our hybrid model to represent the semi-structured part because structural irregularities can cause structure mapping to generate large complex schemas, and schema inflexibility becomes problematic for structurally volatile XML data. Other problems avoided by using XML data types are the need to resolve naming and type ambiguities and contentions, and, more generally, XML structural directives, such as Or ('|'), cannot be mapped naturally into the relational model (Yoshikawa & Amagasa, 2001).…”

Section: Experimental Designmentioning

confidence: 99%

An Analysis of Relational Storage Strategies for Partially Structured XML

Kader¹,

Eaglestone²,

North³

2008

Proceedings of the Fourth International Conference on Web Information Systems and Technologies

View full text Add to dashboard Cite

Abstract:This paper presents a performance analysis of strategies for storing XML data sets in relational databases, focusing on XML datasets that are a combination of structured and semi-structured data. The analysis demonstrates advantages of a hybrid approach combining structure mapping and XML data type instances.However problems remain with current technology with regards to scaling of the approach for large data sets. Also, anomalous results are identified and a threshold at which the cost of data shredding out weighs the advantages of structure mapping.

show abstract

Towards an Industrial Strength SQL/XML Infrastructure

Cited by 12 publications

References 3 publications

Effective and efficient update of xml in RDBMS

Effective and efficient update of xml in RDBMS

Native Xquery processing in oracle XMLDB

An Analysis of Relational Storage Strategies for Partially Structured XML

Contact Info

Product

Resources

About