{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,9,7]],"date-time":"2024-09-07T06:42:50Z","timestamp":1725691370085},"reference-count":28,"publisher":"Association for Computing Machinery (ACM)","issue":"2","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2009,8]]},"abstract":"<jats:p>Oracle RDBMS has supported XML data management for more than six years since version 9i. Prior to 11g, text-centric XML documents can be stored as-is in a CLOB column and schema-based data-centric documents can be shredded and stored in object-relational (OR) tables mapped from their XML Schema. However, both storage formats have intrinsic limitations---XML\/CLOB has unacceptable query and update performance, and XML\/OR requires XML schema. To tackle this problem, Oracle 11g introduces a native Binary XML storage format and a complete stack of data management operations. Binary XML was designed to address a wide range of real application problems encountered in XML data management---schema flexibility, amenability to XML indexes, update performance, schema evolution, just to name a few.<\/jats:p>\n          <jats:p>In this paper, we introduce the Binary XML storage format based on Oracle SecureFiles System[21]. We propose a lightweight navigational index on top of the storage and an NFA-based navigational algorithm to provide efficient streaming processing. We further optimize query processing by exploiting XML structural and schema information that are collected in database dictionary. We conducted extensive experiments to demonstrate high performance of the native Binary XML in query processing, update, and space consumption.<\/jats:p>","DOI":"10.14778\/1687553.1687561","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"1354-1365","source":"Crossref","is-referenced-by-count":4,"title":["Binary XML storage and query processing in Oracle 11g"],"prefix":"10.14778","volume":"2","author":[{"given":"Ning","family":"Zhang","sequence":"first","affiliation":[{"name":"Oracle Corporation"}]},{"given":"Nipun","family":"Agarwal","sequence":"additional","affiliation":[{"name":"Oracle Corporation"}]},{"given":"Sivasankaran","family":"Chandrasekar","sequence":"additional","affiliation":[{"name":"Oracle Corporation"}]},{"given":"Sam","family":"Idicula","sequence":"additional","affiliation":[{"name":"Oracle Corporation"}]},{"given":"Vijay","family":"Medi","sequence":"additional","affiliation":[{"name":"Oracle Corporation"}]},{"given":"Sabina","family":"Petride","sequence":"additional","affiliation":[{"name":"Oracle Corporation"}]},{"given":"Balasubramanyam","family":"Sthanikam","sequence":"additional","affiliation":[{"name":"Oracle Corporation"}]}],"member":"320","published-online":{"date-parts":[[2009,8]]},"reference":[{"key":"e_1_2_1_1_1","volume-title":"May","author":"Schema XML","year":"2001","unstructured":"XML Schema . Available at http:\/\/www.w3.org\/XML\/Schema , May 2001 . XML Schema. Available at http:\/\/www.w3.org\/XML\/Schema, May 2001."},{"key":"e_1_2_1_2_1","unstructured":"AgileDelta. Theory Benefits and Requirements for Efficient Encoding of XML Documents. http:\/\/www.agiledelta.com\/w3c_binary_xml_proposal.html.  AgileDelta. Theory Benefits and Requirements for Efficient Encoding of XML Documents. http:\/\/www.agiledelta.com\/w3c_binary_xml_proposal.html."},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066197"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/1142473.1142527"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2005.69"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/191839.191915"},{"key":"e_1_2_1_7_1","unstructured":"S. Chandrasekar S. Idicula T. Yu and N. Agarwal. Oracle Binary XML Format. Available at http:\/\/www.oracle.com\/technology\/tech\/xml\/xmldb\/Current\/oracle_binaryxml_rfc.pdf.  S. Chandrasekar S. Idicula T. Yu and N. Agarwal. Oracle Binary XML Format. Available at http:\/\/www.oracle.com\/technology\/tech\/xml\/xmldb\/Current\/oracle_binaryxml_rfc.pdf."},{"key":"e_1_2_1_8_1","unstructured":"J. Cowan and R. Tobin. XML Information Set. Available at http:\/\/www.w3.org\/TR\/xml-infoset\/.  J. Cowan and R. Tobin. XML Information Set. Available at http:\/\/www.w3.org\/TR\/xml-infoset\/."},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/958942.958947"},{"key":"e_1_2_1_10_1","unstructured":"P. Fankhauser M. Fernandez A. Malhotra M. Rys J. Simeon and P. Wadler. XQuery 1.0 Formal Semantics. Available at http:\/\/www.w3.org\/TR\/query-semantics\/.  P. Fankhauser M. Fernandez A. Malhotra M. Rys J. Simeon and P. Wadler. XQuery 1.0 Formal Semantics. Available at http:\/\/www.w3.org\/TR\/query-semantics\/."},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-002-0080-y"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-004-0137-1"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1147\/sj.414.0616"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-004-0123-7"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.5555\/846219.847347"},{"key":"e_1_2_1_16_1","first-page":"249","volume-title":"Proc. 29th Int. Conf. on Very Large Data Bases","author":"Koch C.","year":"2003","unstructured":"C. Koch . Efficient Processing of Expressive Node-Selecting Queries on XML Data in Secondary Storage : A Tree Automata - based Approach . In Proc. 29th Int. Conf. on Very Large Data Bases , pages 249 -- 260 , 2003 . C. Koch. Efficient Processing of Expressive Node-Selecting Queries on XML Data in Secondary Storage: A Tree Automata - based Approach. In Proc. 29th Int. Conf. on Very Large Data Bases, pages 249--260, 2003."},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2005.144"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.14778\/1454159.1454177"},{"key":"e_1_2_1_19_1","unstructured":"D. Megginson. The Simple API for XML. Available at http:\/\/www.saxproject.org\/.  D. Megginson. The Simple API for XML. Available at http:\/\/www.saxproject.org\/."},{"key":"e_1_2_1_20_1","volume-title":"White Paper: What's New for XML in SQL Server","year":"2008","unstructured":"Microsoft. White Paper: What's New for XML in SQL Server 2008 . White Paper . Microsoft. White Paper: What's New for XML in SQL Server 2008. White Paper."},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.14778\/1454159.1454170"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.5555\/1083592.1083727"},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.5555\/1083592.1083728"},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.5555\/1316689.1316787"},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066301"},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1145\/1242572.1242717"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/375663.375722"},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.5555\/977401.978103"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/1687553.1687561","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:57:09Z","timestamp":1672225029000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/1687553.1687561"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2009,8]]},"references-count":28,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2009,8]]}},"alternative-id":["10.14778\/1687553.1687561"],"URL":"https:\/\/doi.org\/10.14778\/1687553.1687561","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2009,8]]}}}