Effective and efficient update of xml in RDBMS

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 capabilit...

• Type: Conference
• Year: 2007
• Where: SIGMOD
• Authors: Zhen Hua Liu, Muralidhar Krishnaprasad, James W. Warner, Rohan Angrish, Vikas Arora
• Keywords: Database, Several SQL/XML Update, SIGMOD 2007, XML Update Functionality, XQuery Update Facility