Effective and efficient update of xml in RDBMS
| Autor: | Vikas Arora, James W. Warner, Zhen Hua Liu, Muralidhar Krishnaprasad, Rohan Angrish |
|---|---|
| Rok vydání: | 2007 |
| Předmět: |
Document Structure Description
XML Encryption SQL XQuery Update Facility computer.internet_protocol Computer science Data_MISCELLANEOUS Efficient XML Interchange XML Signature XML Base Document type definition computer.software_genre Oracle Simple API for XML Relational database management system XML Schema Editor Streaming XML RELAX NG XML schema SGML computer.programming_language XPath Database InformationSystems_DATABASEMANAGEMENT XML validation computer.file_format XML framework XQuery XML database XML Schema (W3C) XML Protocol ComputingMethodologies_DOCUMENTANDTEXTPROCESSING computer XML XML Catalog |
| Zdroj: | SIGMOD Conference |
| DOI: | 10.1145/1247480.1247589 |
| Popis: | 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. |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|