Fact-checked by Grok 2 weeks ago

XML database

An XML database is a specialized database management system designed to store, retrieve, manage, and query data in XML format, preserving its hierarchical structure and enabling efficient processing without conversion to other models like relational tables. These systems support standards such as for querying, for navigation, and for validation and constraints, facilitating the handling of structured, semi-structured, and unstructured content. XML databases are categorized into two primary types: native XML databases, which use XML as the fundamental data model and store documents in their native form with dedicated indexing and retrieval mechanisms, and XML-enabled relational databases, which extend traditional relational database management systems (RDBMS) to incorporate XML storage and operations alongside SQL capabilities. Native systems, such as eXist-db, offer scalability for millions of documents, ACID transaction support, and high-performance queries, making them suitable for applications like document management and web content repositories. In contrast, XML-enabled RDBMS like Oracle XML DB provide interoperability between XML and relational data, supporting features such as B-tree indexing, full-text search, and protocol access via HTTP, FTP, or WebDAV. The development of XML databases arose in the late 1990s with the rise of XML as a standard for data exchange, initially through extensions in RDBMS like Oracle8i in 1999, which introduced basic XML support, evolving to full native integration in Oracle9i Release 2 in 2002. These databases address challenges in handling , reducing the complexity and errors associated with "shredding" XML into relational schemas, and enabling faster development cycles for applications in sectors like and . By supporting W3C standards including XML 1.0, 1.0, and 2.0, XML databases ensure portability and integration with modern web technologies.

Fundamentals

Definition and History

An XML database is a data persistence system designed to store, manage, and retrieve in XML format, where XML documents serve as the primary unit of rather than fixed-schema tables or simple key-value pairs. This approach enables the handling of hierarchical, semi-structured, and document-oriented , preserving the native tree structure of XML while supporting operations like validation against schemas and transformation. The emergence of XML databases traces back to the late 1990s, coinciding with the World Wide Web Consortium's (W3C) release of XML 1.0 as a recommendation on February 10, 1998, which established XML as a standardized format for structured data exchange on the web. Early prototypes and specifications followed, including the XML:DB API, a collaborative effort initiated in 2000 by the XML:DB Initiative to define a vendor-neutral interface for accessing XML database functionality. The technology gained momentum in the early 2000s, fueled by the proliferation of web services—such as SOAP—and the demand for efficient management of document-centric applications in publishing, configuration files, and content syndication. W3C standardization efforts intensified around 2001, with the chartering of working groups to address XML querying and data models, building on earlier proposals like XML-QL from 1998. A pivotal milestone came in 2007 with the publication of 1.0 as a W3C recommendation, introducing a Turing-complete capable of expressing complex operations over XML data sources, including joins, , and constructs. By the mid-2000s, XML databases saw widespread adoption in enterprise systems for integrating heterogeneous data in sectors like and healthcare, where XML's extensibility and support proved advantageous. Despite the ascendancy of as a lighter alternative for web APIs and stores in the , XML databases have persisted in niche applications through the , particularly where rigorous validation, with legacy standards, and complex hierarchical querying remain essential, as evidenced by ongoing support in major database systems like 26ai (as of 2025), though the XML DB Repository was deprecated in that release.

Rationale and Benefits

XML's hierarchical and self-describing structure makes it particularly well-suited for managing , such as documents, configuration files, and reports, where rigid tabular schemas would impose unnecessary constraints. This flexibility allows XML databases to handle varying data structures without predefined schemas, accommodating evolving information needs in applications like and . Unlike flat files or early semi-structured stores, XML databases offer persistent storage, efficient querying, and transactional support, enabling scalable management of complex, nested data hierarchies. Key benefits include native support for namespaces, which prevent name conflicts and enable modular reuse of vocabularies across documents, enhancing interoperability in diverse systems. Validation through XML Schema Definition (XSD) ensures by enforcing structural and type constraints, facilitating reliable data exchange in protocols like web services. Additionally, XML's text-based format is human-readable, aiding debugging and maintenance, while preserving document order and whitespace critical for formats like reports. Despite these advantages, XML's verbosity results in larger storage requirements compared to binary or relational formats, increasing overhead for large datasets. Parsing XML introduces computational costs, particularly for deep hierarchies, making it less efficient for numerical or highly tabular data where relational models excel. Nonetheless, the XML database market demonstrates niche viability, driven by ongoing needs in document-centric applications.

Types of XML Databases

XML-Enabled Databases

XML-enabled databases refer to relational database management systems (RDBMS) that have been extended to support XML data storage and processing alongside traditional tabular data. These systems typically store XML documents in dedicated columns, such as those using a native XML data type or as character large objects (CLOB), while relying on the underlying relational engine for management without providing fully native, schema-agnostic XML handling. Key features of XML-enabled databases include the ability to shred XML documents—extracting and mapping elements or attributes into relational tables for efficient querying—and support for importing and exporting XML data via standard SQL extensions. Shredding allows XML content to be decomposed into normalized relational structures, enabling the use of SQL joins and indexes on extracted data. Prominent examples include , which introduced XML columns with the pureXML feature in DB2 9 released in , allowing storage of well-formed XML in native format within relational tables. Oracle XML DB, integrated into the since release 9i in 2002, provides high-performance XML storage in XMLType columns and supports shredding through SQL functions. added the xml data type in version 2005, enabling native storage and methods like nodes() for shredding XML into rowsets. These databases offer advantages such as leveraging established SQL infrastructure for querying mixed relational and XML workloads, enabling hybrid storage models where XML complements structured data, and providing scalability through relational indexing techniques applied to shredded XML components. By integrating XML support into mature RDBMS platforms, organizations can handle without migrating to entirely new systems, thus maintaining performance for large-scale operations. For instance, in IBM DB2, a basic SQL query can extract elements from an XML column using XPath predicates, such as checking for the existence of a node:
sql
SELECT x.y
FROM table_name
WHERE XMLColumn EXISTS NODE '/root/y';
This query retrieves the value of element 'y' under 'root' only for rows where such a node exists in the XMLColumn, demonstrating seamless integration of XML path expressions within SQL.

Native XML Databases

Native XML databases are database management systems that store and query XML documents using XML itself as the core data model, treating collections of documents as the primary storage unit rather than decomposing them into relational tables or other structures. This approach allows for schema-optional storage, where documents can vary in structure without requiring predefined schemas, and preserves the inherent hierarchical, ordered, and semi-structured nature of XML data. These systems are document-centric, focusing on maintaining the full fidelity of XML documents to support complex navigation and retrieval over large corpora, often with built-in optimizations for tree-based structures and . They enable direct processing of XML queries without intermediate transformations, making them suitable for applications involving irregular or evolving data formats. Notable examples include , an enterprise that handles XML alongside and RDF for scalable ; , a supporting native XML DBMS among other paradigms for versatile data processing; , which provides native XML storage through its Berkeley DB XML component with key-value and XML capabilities; eXist-db, an open-source Java-based system offering schema-less storage, , and browser-based development tools; and BaseX, a lightweight engine emphasizing high-performance execution and support for large datasets. Native XML databases emerged in the late 1990s and early 2000s as XML gained prominence for data interchange, with significant development during that decade driven by the need for specialized handling of semi-structured data. By 2025, they occupy a niche in legacy systems, archiving, and specialized , maintaining but modest popularity; DB-Engines tracks seven such systems, with leading at a score of 4.10, followed by (2.91), Oracle Berkeley DB (1.64), BaseX (1.47), and eXist-db (0.66) (as of November 2025). Unlike relational databases, which require shredding XML into normalized tables and may lose document order or hierarchy, native XML databases store data in its original form to support efficient, structure-aware operations without such preprocessing. In contrast to XML-enabled databases, native systems avoid mapping XML to relational schemas, prioritizing direct XML fidelity over integration with SQL environments.

Querying and Standards

XML Query Languages

XML query languages provide specialized mechanisms for navigating, selecting, and transforming hierarchical XML data structures, enabling precise traversal of document trees and construction of new outputs. These languages emphasize path-based expressions and functional constructs to handle XML's nested nature efficiently, distinct from relational query paradigms. XPath serves as a foundational W3C standard for addressing parts of XML documents through concise path expressions that select nodes, attributes, or values based on their position, type, or content. XPath 2.0 became a W3C Recommendation on January 23, 2007, introducing support for sequences, functions, and XML Schema types to enhance expressiveness over earlier versions. XPath 3.1, published as a W3C Recommendation on March 21, 2017, further extends the language with features like maps, arrays, and higher-order functions for more flexible data manipulation. For instance, an expression such as /root/child[@attr='value'] navigates from the document root to child elements matching the specified attribute condition. XQuery builds upon as a full-featured, Turing-complete functional designed for querying and updating XML collections, supporting complex operations like joining, sorting, and constructing results. 1.0 achieved W3C Recommendation status on January 23, 2007, establishing its core syntax and semantics for declarative querying. The language's 3.1 version, released as a W3C Recommendation on March 21, 2017, added capabilities such as support, private functions, and annotations to broaden applicability. Central to are FLWOR expressions, which enable iterative processing with clauses for iteration, binding, filtering, ordering, and returning results; a representative example is:
xquery
for $doc in collection('docs')
let $title := $doc/title
where $title = 'Example'
return <result>{$title}</result>
This query iterates over a collection of documents, binds the title element, filters by content, and constructs a new XML result element. also incorporates modular design for reusable components, strong static typing based on , and update functionality through the XQuery Update Facility 1.0, a W3C Recommendation from March 17, 2011, which adds non-destructive update expressions like insertion, deletion, and replacement while preserving immutability principles. XSLT complements querying with transformation capabilities, defining a stylesheet-based for converting XML source trees into alternative formats, such as other XML documents or . XSLT 2.0, a W3C Recommendation from January 23, 2007, introduced grouping, user-defined functions, and multiple result documents to support advanced restructuring. Version 3.0, published as a W3C Recommendation on June 8, 2017, enhanced streaming for large inputs, higher-order functions, and packaging for modular stylesheets. Transformations rely on template rules matched via patterns and processing modes; for example, templates can apply selectively to elements, enabling recursive tree-walking to generate outputs like formatted reports from raw XML. XPath, XQuery, and XSLT form a cohesive family of W3C Recommendations, with their 2.0 and 3.x versions stabilizing core features by 2017 to ensure interoperability across tools and systems. As of 2025, ongoing discussions within the XQuery and XSLT Extensions Community Group (QT4CG) have produced editor's drafts for XQuery 4.0, incorporating extensions like enhanced JSONiq integration and improved concurrency, though it remains in development without full W3C endorsement.

SQL/XML in Relational Systems

SQL/XML is a component of the ISO/IEC 9075 SQL standard, specifically Part 14 (ISO/IEC 9075-14), which defines mechanisms for integrating XML data and operations into relational SQL queries. First published in , the standard enables relational database management systems (RDBMS) to import, store, manipulate, and export XML alongside traditional relational data. The latest edition, released in as the sixth revision, maintains and extends these capabilities while aligning with broader SQL evolutions. Key functions in SQL/XML facilitate XML processing within SQL statements. The XMLExists function evaluates an or expression against an XML value and returns a indicating whether any nodes match, commonly used in predicates for filtering rows. For instance, it can check for the presence of specific elements in an XML column to refine query results. Similarly, XMLQuery executes an or expression and returns the resulting XML fragment, allowing extraction of structured XML subsets. A representative example in is:
sql
SELECT XMLQuery('//item[productName=&#36;n]' PASSING prod_info AS "n" RETURNING CONTENT)
FROM products;
This query retrieves XML elements matching a product name from an XML column named prod_info. Additionally, XMLSerialize converts an XML value to a , , or large object type for easier handling in non-XML contexts, supporting options like document or content modes. These functions collectively enable precise XML navigation and transformation directly in SQL. SQL/XML supports hybrid querying by embedding or snippets within SQL, bridging relational and paradigms. For XML publishing—converting relational tables to XML—functions like XMLELEMENT, XMLATTRIBUTES, XMLFOREST, and XMLAGG construct XML structures from scalar or ; for example, aggregating rows into nested XML elements. Conversely, XML into relational form uses the XMLTable function, which applies an to generate a virtual table with rows and columns from XML nodes. In , an example extracts details from an XML column:
sql
SELECT x.warehouse_id, x.warehouse_name
FROM warehouses,
XMLTABLE('/Warehouse'
  PASSING warehouse_spec
  COLUMNS warehouse_id NUMBER PATH '@Id',
          warehouse_name VARCHAR2(30) PATH 'Name') x;
This produces relational output from nested XML, ideal for joining with other tables. Such integration allows XML-enabled RDBMS like Db2 and to handle incrementally, facilitating gradual adoption without migrating to native XML databases. The evolution of SQL/XML reflects ongoing adaptations in data standards. While the SQL:2016 revision (ISO/IEC 9075:2016) introduced native support through functions analogous to SQL/XML—such as JSON_QUERY and JSON_EXISTS—for handling in relational queries, XML remains a core feature for legacy systems, enterprise integrations, and domains requiring schema validation or complex hierarchies. This duality ensures SQL/XML's continued relevance in hybrid environments where XML persists alongside emerging formats.

Architecture and Features

Storage and Indexing

Native XML databases utilize diverse storage models to maintain the hierarchical and semi-structured nature of XML data while optimizing for query performance and space efficiency. Node-based storage represents XML documents as an in-memory of nodes, preserving parent-child relationships and order, as seen in systems like eXist-db, which stores documents in a persistent DOM-like tree for direct . Container-based storage, alternatively, treats XML documents as self-contained units or collections, grouping related documents without fully decomposing the hierarchy, which facilitates bulk operations but may require additional parsing for fine-grained access. These models contrast with textual storage, which retains XML in its original serialized form for simplicity and human readability, versus binary storage, which encodes data in a compact, non-human-readable format to reduce I/O overhead and improve retrieval speeds. To enhance storage efficiency, some native XML databases incorporate compressed representations such as the Efficient XML Interchange (EXI) format, a standard that uses grammar-based to achieve up to 90% size reduction compared to plain text XML while supporting schema-informed or schema-less modes. EXI integration allows for faster parsing and lower memory usage in resource-constrained environments, though it requires decompression during certain query operations. Indexing techniques in native XML databases are designed to accelerate queries over the document's structure, content, and text. Structural indexes maintain pointers for hierarchical relationships, such as parent-child and ancestor-descendant links, enabling efficient traversal without repeated tree walks; for instance, path summaries approximate document structures as compact graphs to prune irrelevant subtrees during query evaluation. Value indexes target attributes, element content, and metadata, often using or hash-based structures to support equality and range queries on textual or numeric values. Full-text indexes, frequently powered by , handle keyword searches across document corpora; BaseX's native full-text index supports fuzzy and relevance-ranked retrieval, while eXist-db employs a Lucene-based range index for ordered and full-text operations on node values. Performance considerations in XML database storage and indexing emphasize scalability for large datasets and efficient update handling. Clustering techniques partition documents based on structural similarity or query patterns, reducing search spaces and improving parallel query execution. Persistence strategies balance in-memory caching for low-latency access with disk-based storage for durability; many systems, like eXist-db (version 6.4.0 as of May 2025), use hybrid approaches where frequently accessed indexes reside in while committing changes to disk via journaling to minimize . Updates are optimized to avoid full document re-parsing by leveraging incremental indexing, where only modified subtrees are reprocessed, preserving overall system responsiveness. In native XML databases, schema-agnostic indexing allows dynamic adaptation to varying document structures without predefined s, as implemented in MarkLogic's Universal Index, which automatically builds structural, lexical, and semantic indexes across heterogeneous XML collections for unified querying. This differs from XML-enabled databases, where shredded storage decomposes XML into relational tables via schema mapping, mapping elements and attributes to columns or relations to leverage RDBMS indexes, though this can introduce join overhead for reconstructing documents.

APIs and Access Methods

XML databases provide a range of programmatic interfaces to enable developers to perform (CRUD) operations on XML data, as well as execute queries and manage collections. These are designed to abstract the underlying storage mechanisms, allowing applications to interact with both native XML databases and XML-enabled relational systems without vendor-specific code. Common interfaces emphasize portability across implementations, supporting standards from organizations like the W3C and the (JCP). The XML:DB is a foundational Java-based for native XML databases, offering methods for managing collections of XML resources and executing queries. It includes core classes for database connections, resource handling, and services such as execution, enabling portable applications that can switch between compliant databases like eXist-db or BaseX. This supports basic CRUD operations on XML documents stored in collections, treating the database as a hierarchical structure similar to a . For broader language support, the for (XQJ 1.0), developed under JSR 225, standardizes access to XQuery processors from Java applications. It allows submission of XQuery expressions to XML data sources, processing results as sequences of XDM (XQuery Data Model) items, and management of query contexts including namespaces and variables. XQJ promotes interoperability by reducing , with implementations available in systems like XML DB and Saxon. In C environments, the provides a standardized for processors, focusing on compiling and executing queries while managing static contexts. It interfaces with the XQuery Data Model for input and output handling, supporting multiple processor implementations to facilitate integration in performance-critical applications. XQC emphasizes mechanisms for error handling and module management, making it suitable for use cases. RESTful interfaces offer lightweight, HTTP-based access without requiring dedicated client libraries. For instance, eXist-db's API maps HTTP methods to database operations: GET for retrieving or querying documents, PUT for uploading XML resources to collections, POST for submitting updates, and DELETE for removal. This enables seamless integration with web applications, with features like result caching and pagination for efficient handling of large datasets. In XML-enabled relational databases, extensions to standard database connectivity protocols support XML operations. SQL Server, for example, integrates XML data types with through the SqlXml class, allowing retrieval and manipulation of XML columns via SQL queries that incorporate or . This provides client-side processing of XML streams, parameter passing for XML inputs, and compatibility with .NET applications for hybrid relational-XML workflows. Access methods extend beyond APIs to include protocols for collaborative and distributed environments. , as implemented in eXist-db, enables file-system-like management of XML collections over HTTP, supporting operations such as copying, moving, and editing documents using standard clients like Windows Explorer or . This protocol facilitates remote document versioning and locking, bridging XML databases with tools. SOAP and REST services further enhance accessibility, with many XML databases exposing endpoints for service-oriented architectures. Transaction support ensures during multi-operation sequences; , for instance, provides full compliance, allowing atomic commits across document updates and queries via its , which maintain and even in distributed clusters. Security features are integral to these , with (RBAC) enforcing granular permissions. In , RBAC operates at the document and element levels, assigning roles to users for read, write, or execute privileges, integrated directly into calls to prevent unauthorized access. This model supports secure multi-tenancy and compliance with standards like . Modern extensions in 2025-era systems include built-in support for versioning and replication. eXist-db's versioning module tracks document revisions by storing diffs between changes, accessible via extensions for rollback and trails. MarkLogic offers database replication for , synchronizing forests across clusters through configurable APIs that maintain properties during . These features enhance resilience in enterprise deployments without compromising XML-native access.

Integration and Applications

Hybrid Systems and Integration

Hybrid systems in XML databases often employ multi-model architectures that natively support XML alongside other data formats, such as and RDF, to handle diverse data requirements without extensive conversions. For instance, Server functions as a multi-model database that integrates document-oriented XML storage with semantic RDF triples and documents, enabling unified querying across these models in a scalable, distributed environment. This approach addresses the limitations of single-model systems by allowing seamless ingestion and retrieval of heterogeneous data, as seen in its use for where XML schemas coexist with graph-based RDF relationships. Middleware solutions facilitate XML-relational mapping by transforming XML structures into relational schemas or vice versa, often leveraging for declarative style-sheet-based conversions. transformations enable the mapping of hierarchical XML elements to flat relational tables, preserving during integration while supporting bidirectional flows in enterprise applications. Tools like Altova MapForce extend this by providing visual ETL capabilities for XML-to-relational imports, automating schema mapping and data loading into databases such as or . Integration techniques commonly involve ETL processes to import XML data into relational systems, exemplified by Oracle's XMLType, which stores XML natively while allowing extraction into relational tables via SQL functions like XMLTABLE for shredding complex documents. Federated queries further enhance this by enabling SQL/XML to join XML content with relational data across distributed sources, as supported in systems like , where remote XML wrappers allow transparent access without data replication. In architectures, gateways serve as intermediaries, routing requests to XML databases and performing on-the-fly transformations, such as converting XML responses to for client compatibility. In contemporary ecosystems as of 2025, XML databases integrate with -dominant systems through extensions, such as in eXist-db, where functions like xml-to-json() convert XML structures to arrays and objects for in applications. Cloud platforms like AWS DocumentDB offer partial XML support by storing XML as document fields, though it requires custom parsing for querying due to its primary MongoDB-compatible focus. For environments, Hadoop processes legacy XML via specialized input formats and parsers like Hadoop's StreamXmlRecordReader, enabling jobs to extract and aggregate XML elements at scale without full schema enforcement. Key challenges in these hybrid integrations include the object-relational impedance mismatch, where XML's hierarchical, schema-flexible nature conflicts with relational databases' rigid tabular structure, leading to inefficient mappings and potential during transformations. bottlenecks arise from repeated and overhead, particularly in high-volume ETL pipelines, necessitating optimized indexing and caching strategies to mitigate .

Use Cases and Industry Applications

XML databases are widely applied in document management, particularly within workflows, where XML structures enable efficient content repositories for and projects. Native XML databases such as eXist-db support versioning and transformation of XML documents into various formats like web pages, PDFs, and , facilitating collaborative editing and long-term preservation in content-heavy environments. In data exchange scenarios, XML databases underpin financial reporting through the standard, which uses XML-based tagging to standardize and automate the communication of business and financial information across systems and regulatory bodies. Similarly, in healthcare, HL7 (CDA) documents are stored and queried via in XML databases, enabling scalable sharing and analysis of clinical data while ensuring . Enterprise applications leverage XML databases for , as seen in frameworks like , where XML schema-based files define bean configurations and application settings for modular deployment. During legacy system migrations, hybrid relational-XML database management systems preserve existing XML schemas alongside relational data, minimizing disruptions in transitional environments. As of 2025, XML databases maintain a niche role in compliance-intensive sectors, supporting structured data handling in financial (via ) and healthcare (via HL7 ) reporting, as well as government and legal documentation requiring standardized formats. Their adoption has waned for new web applications in favor of lighter formats, yet they remain essential for processing OOXML in office suites like , which rely on zipped XML structures for documents, spreadsheets, and presentations. In research, datasets such as the XML feeds provide raw metadata from over 12,500 journals, enabling large-scale bibliometric analysis. Looking ahead, XML databases are expected to coexist with JSON-oriented systems in hybrid integrations, with the market for XML databases software estimated to reach approximately $329 million in 2025.

References

  1. [1]
    xml_brief - CTG UAlbany
    An XML database is a data storage format that allows data to be maintained in an XML format. The data can then be queried and processed as XML without ...
  2. [2]
    Introduction to Oracle XML DB
    Oracle XML DB is a set of Oracle Database technologies related to high-performance handling of XML data: storing, generating, accessing, searching, validating, ...
  3. [3]
    [PDF] Use a Native XML Database for Your XML Data - Oracle
    A native XML database (NXD) with XQuery support. • XML document management. • storage. • modification. • and retrieval. • Scalable. • millions of documents.
  4. [4]
    [PDF] Oracle XML DB: Uniting XML Content and Data
    Oracle introduced its first support for XML with the release of Oracle8i in late 1999.
  5. [5]
    XML and Databases - rpbourret.com
    This paper gives a high-level overview of how to use XML with databases. It describes how the differences between data-centric and document-centric documents ...
  6. [6]
    Extensible Markup Language (XML) 1.0 - W3C
    Feb 10, 1998 · XML is a subset of SGML, designed for web use, describing data objects and how programs process them, and is a restricted form of SGML.
  7. [7]
    XML Database API Draft Proposal
    This document defines a draft specification for the XML Database API. This API is being developed through the mailing lists of the XML:DB organization and the ...Missing: history | Show results with:history
  8. [8]
    XML-QL: A Query Language for XML - W3C
    Aug 19, 1998 · XML is a new standard that supports data exchange on the World-Wide Web. It is likely to become as important and as widely used as HTML. The ...
  9. [9]
    XQuery 1.0: An XML Query Language - W3C
    Jan 23, 2007 · XQuery is a query language designed to express queries across diverse XML data sources, operating on the logical structure of XML documents.Missing: history DB
  10. [10]
    XQuery Scripting Extension 1.0 Requirements - W3C
    Jun 20, 2017 · XQuery 1.0 is a functional language that is Turing-complete and well suited to write code that ranges from simple queries to complete applications.
  11. [11]
    Developer's Guide
    ### Summary of Oracle XML DB Status in the 2020s
  12. [12]
    [PDF] The Impact of XML on Databases and Data Sharing
    XML provides a common format for data, increasing database output availability and extending data management to include semi-structured data.
  13. [13]
    xml data type and columns (SQL Server) - Microsoft Learn
    Feb 28, 2023 · This article discusses the advantages and the limitations of the xml data type in SQL Server, and helps you to choose how to store XML data.
  14. [14]
  15. [15]
    Namespaces in XML 1.1 (Second Edition)
    ### Summary of Benefits of XML Namespaces
  16. [16]
  17. [17]
    [PDF] XML Parsing: A Threat to Database Performance - Joe D'Alessandro
    ABSTRACT. XML parsing is generally known to have poor performance char- acteristics relative to transactional database processing. Yet, its.
  18. [18]
    XML Databases Software Market Disruption: Competitor Insights ...
    Market Size and Growth Drivers: The XML Databases Software market is estimated to reach a value of $329 million in 2025, expanding at a CAGR of 6.8% during the ...
  19. [19]
    pureXML overview -- Db2 as an XML database - IBM
    The pureXML feature allows you to store well-formed XML documents in database table columns that have the XML data type.
  20. [20]
    Manipulating XML Data in SQL Server - Simple Talk
    Oct 23, 2012 · To 'shred' means to strip the actual data away from the markup tags, and organize it into a relational format. For example, shredding is what ...
  21. [21]
    [PDF] DB2 9 pureXML Guide - IBM Redbooks
    This edition applies to DB2 9 for Linux, UNIX, and Windows. Note: Before using this information and the product it supports, read the information in. “Notices” ...
  22. [22]
    [PDF] Oracle9i XML Database Developer's Guide - Oracle XML DB
    Mar 31, 2002 · Page 1. Oracle9i. XML Database Developer's Guide - Oracle XML DB. Release 2 (9.2). March 2002. Part No. A96620-01. Page 2. Oracle9i XML Database ...
  23. [23]
    [PDF] A STUDY OF NATIVE XML DATABASES - SciTePress
    Native XML Databases are systems developed purely for storing XML documents. Their data models are flexible, so that documents do not need to be transformed to ...Missing: definition characteristics
  24. [24]
    [PDF] TIMBER: A Native XML Database
    Some characteristics of XML data are obvious even from this simple example. XML has a tree structure: ele- ments in the document can be structurally related ...
  25. [25]
    [PDF] CS764 Project - cs.wisc.edu
    Oracle 9i Release 2 claims to have a native XML database called XMLDB. XML data can be stored either in an XMLType Table or as a XMLType column in a table. e.g:.<|separator|>
  26. [26]
    [PDF] Open Source Native XML Database Architectures - icact
    Abstract— Text-based and model-based architectures are two models used by Open Source Native XML databases (NXDs) to physically store collections of XML ...
  27. [27]
    DB-Engines Ranking
    ### Top 5 Native XML DBMS (November 2025)
  28. [28]
    eXist-db - The Open Source Native XML Database
    Features & Facts · One Step Installation · One Platform · One Data Model · Schema-less Database · Rapid Prototyping · Application Packages · Open · Browser-based IDE.Missing: MarkLogic Sedna
  29. [29]
    The Forgotten Document-Oriented Database Management Systems
    Jul 15, 2021 · Sedna is an XDBMS written in C that stores documents in the XML format [28]. Sedna provides ACID transactions, indexing, and persistent storage ...
  30. [30]
    (PDF) A Comparison of Concepts between Native Xml and ...
    Jan 5, 2017 · This study is going to examine the differences between XML and Relational database systems in terms of representing data, the way both systems ...
  31. [31]
    [PDF] XML Databases - College of Arts, Technology and Environment
    ... XML-enabled and native XML databases is that the first uses schema- specific structures that must be mapped to the XML document at design time. Native XML.
  32. [32]
    XML Path Language (XPath) 3.1 - W3C
    Mar 21, 2017 · XML Path Language (XPath) 3.1. W3C Recommendation 21 March 2017. Status Update (6 April 2021): Feedback, comments, error reports on this ...
  33. [33]
    XML Path Language (XPath) 2.0 (Second Edition) - W3C
    W3C Recommendation 14 December 2010 (Link errors corrected 3 January 2011; Status updated October 2016). This version: http://www.w3.org/TR/2010/REC-xpath20 ...Static Context · Literals · Arithmetic Expressions · Cast
  34. [34]
    XQuery 1.0: An XML Query Language (Second Edition - W3C
    W3C Recommendation 14 December 2010 (Link errors corrected 3 January 2011; revised 7 September 2015). This version: http://www.w3.org/TR/2010/REC-xquery- ...
  35. [35]
    XQuery 3.1: An XML Query Language - W3C
    Mar 21, 2017 · XQuery 3.1: An XML Query Language. W3C Recommendation 21 March 2017. Status Update (6 April 2021): Feedback, comments, error reports on this ...
  36. [36]
    XQuery Update Facility 1.0 - W3C
    Mar 17, 2011 · The XQuery Update Facility provides expressions that can be used to make persistent changes to instances of the XQuery 1.0 and XPath 2.0 Data Model.
  37. [37]
  38. [38]
    XSL Transformations (XSLT) Version 3.0 - W3C
    Jun 8, 2017 · XSLT 3.0 is a revised version of the XSLT 2.0 Recommendation [XSLT 2.0] published on 23 January 2007. The primary purpose of the changes in this ...
  39. [39]
    XQuery 4.0: An XML Query Language - QT4 CG Homepage
    This specification describes a query language called XQuery, which is designed to be broadly applicable across many types of XML data sources.
  40. [40]
    Database languages — SQL - ISO/IEC 9075-14:2003
    ISO/IEC 9075-14:2003 defines ways in which Database Language SQL can be used in conjunction with XML. It defines ways of importing and storing XML data in an ...
  41. [41]
    Database languages SQL - ISO/IEC 9075-14:2023
    Database languages SQLPart 14: XML-Related Specifications (SQL/XML). Published (Edition 6, 2023) ...
  42. [42]
  43. [43]
    Documentation: 18: 9.15. XML Functions - PostgreSQL
    The xmltable expression produces a table based on an XML value, an XPath filter to extract rows, and a set of column definitions. Although it syntactically ...
  44. [44]
    XMLTABLE - Oracle Help Center
    XMLTable maps the result of an XQuery evaluation into relational rows and columns. You can query the result returned by the function as a virtual relational ...
  45. [45]
    XMLTABLE table function - IBM
    The XMLTABLE function returns a result table from the evaluation of XQuery expressions, possibly using specified input arguments as XQuery variables.
  46. [46]
    What's New in SQL:2016
    Jun 15, 2017 · The new ISO standard introduces row pattern recognition, JSON, listagg and many other features.
  47. [47]
    Work with JSON Data in SQL Server - Microsoft Learn
    Jul 23, 2025 · This article provides an overview of the textual data format JSON in SQL Server, Azure SQL Database, Azure SQL Managed Instance, Azure Synapse Analytics, and ...
  48. [48]
    Range Index - eXist-db Documentation
    eXist-db includes a super fast modularized range index based on Apache Lucene. This article describes eXist-db's range index.Overview · Index Configuration · Configuration Features · Collations
  49. [49]
    Analyzing the Impact of XML Storage Models on the Performance of ...
    This paper presents a comparative analysis of the two storage models namely text-based and model-based used by Open Source Native XML databases to manage their ...
  50. [50]
    Efficient XML Interchange (EXI) Format 1.0 (Second Edition) - W3C
    Feb 11, 2014 · EXI is a very compact representation for the Extensible Markup Language (XML) Information Set that is intended to simultaneously optimize performance and the ...
  51. [51]
    (PDF) On Indexing in Native XML Database Systems - ResearchGate
    Database indices are fundamental data structures that improve the speed of data retrieval operations. In this paper, we focus on native XML database systems ...Missing: seminal | Show results with:seminal
  52. [52]
    [PDF] FIX: Feature-based Indexing Technique for XML Documents
    Indexing techniques are crucial for efficiently answering queries in a large database consisting of collections of XML documents. Given a query specified by a ...Missing: seminal | Show results with:seminal
  53. [53]
    Effective Clustering Schemes for XML Databases - SpringerLink
    This paper provides a preliminary study on data clustering for optimizing XML databases. Different clustering schemes are compared through a set of extensive ...Missing: persistence | Show results with:persistence
  54. [54]
    Tuning the Database - eXist-db Documentation
    eXist-db automatically indexes all xml:id attributes and other attributes with type ID as declared in a DTD (if validation is enabled). This automatic index is ...
  55. [55]
    An Introduction to MarkLogic Server and XQuery
    MarkLogic Server is an Enterprise NoSQL database. It is a document-centric, transactional, search-centric, structure-aware, schema-agnostic, XQuery- and ...
  56. [56]
    [PDF] Storage and Retrieval of XML Data using Relational Databases
    To compose a shredded XML, use dxxGenXML() as in publishing phase ... - The XML Enabled Data Management System. ICDE 2000. □. Michael Rys: Bringing ...
  57. [57]
    XML:DB API Specification
    XML:DB API Specification. Packages. org.xmldb.api · org.xmldb.api.base · org.xmldb.api.modules. Overview, Package, Class, Tree · Deprecated · Index · Help ...
  58. [58]
    Writing Java Applications with the XML:DB API - eXist-db
    This article explains how to work with eXist-db from Java code using the XML:DB API. This API provides a common interface to native or XML-enabled databases.
  59. [59]
    Java Specification Requests - detail JSR# 225
    Develop a common API that allows an application to submit queries conforming to the W3C XQuery 1.0 specification and to process the results of such queries.
  60. [60]
    8 Using XQuery API for Java to Access Oracle XML DB
    The queries executed by XQJ are written in standard World Wide Web Consortium (W3C) XQuery 1.0 language, as supported by Oracle XML DB. A typical use case ...
  61. [61]
    XQuery C and C++ API
    The goal of the XQC project is to create standardized C/C++ APIs for interfacing with XQuery processors. They should provide mechanisms to compile and execute ...
  62. [62]
    REST-Style Web API - eXist-db Documentation
    eXist-db's REST API uses HTTP for quick database access. It maps GET, PUT, DELETE, and POST requests to database operations. The server treats paths as  ...Introduction · GET Requests · PUT Requests
  63. [63]
    XML Data in SQL Server - ADO.NET - Microsoft Learn
    Sep 15, 2021 · The SqlXml class in the .NET Framework provides the client-side support for working with data stored in an XML column within SQL Server. For ...Missing: docs | Show results with:docs
  64. [64]
    WebDAV - eXist-db Documentation
    eXist-db ships with a WebDAV interface. WebDAV makes it possible to manage database collections and documents just like directories and files in a file system.
  65. [65]
  66. [66]
    MarkLogic ACID Transactions - Progress Software
    MarkLogic is an operational and transactional Enterprise NoSQL database that has had ACID transactions since its first version. MarkLogic's ACID properties ...<|separator|>
  67. [67]
    MarkLogic Server Security Model - Progress Documentation
    Aug 31, 2025 · MarkLogic Server includes a powerful and flexible role-based security model to protect your data according to your application security ...The Security Database · Secure Credentials · Element Level Security
  68. [68]
    Versioning Extensions - eXist-db Documentation
    eXist-db provides a basic document versioning extension. This extension tracks all changes to a document by storing the differences between the revisions. ...
  69. [69]
    MarkLogic 12 Product Documentation Database Replication Guide
    Database replication in MarkLogic creates copies of documents in another database, keeping them in sync, and maintains copies of forests on multiple clusters.
  70. [70]
    Multi-Model NoSQL Database Features | Progress Marklogic
    Multi-model databases support multiple data models, indexes, and languages, with a unified search interface, and integrated indexes for fast data access.
  71. [71]
    Overview of MarkLogic Server (Concepts Guide)
    It uses XML and JSON documents as its data model, and stores the documents within a transactional repository. It indexes the words and values from each of the ...
  72. [72]
    20 Transforming Data with XSLT - Oracle Help Center
    This chapter provides an overview of eXtensible Stylesheet Language Transformation (XSLT) and how it is used in Service Bus services to map XML input to XML ...Missing: relational | Show results with:relational
  73. [73]
    Powerful ETL Tools (Free Trial) | Altova
    The ETL tools in Altova MapForce make it easy to transform and convert between XML, JSON, PDF, databases, flat files, EDI, Excel, Protobuf, XBRL, ...Enterprise Etl Software · Data Transformation... · Database Etl Tools<|separator|>
  74. [74]
    16 Choice of XMLType Storage and Indexing - Oracle Help Center
    For XMLType data stored object-relationally, create B-tree and bitmap indexes just as you would for relational data. Use XMLIndex indexing with XMLType data ...16.2 Xmltype Use Case... · 16.3. 5 Xmltype Use Case... · 16.4 Xmltype Storage Model...
  75. [75]
    Federation: Working with remote XML data - IBM
    Federation supports the remote XML data type that gives you the ability to access and manipulate XML data in a database.
  76. [76]
    API Gateway Defined In Microservices Architecture - Medium
    Jul 8, 2025 · An API Gateway can transform requests and responses from one format to another. It can change XML to JSON, alter headers, or alter the structure ...
  77. [77]
    A preview of XQuery 3.1's JSON support in eXist | joewiz.org
    Jan 18, 2015 · With XQuery 3.1, you can take JSON, turn it into XML, create JSON from scratch, sort and manipulate it, and post it to an external API or JSON document store ...
  78. [78]
    Storing XML data in AWS DB
    Apr 14, 2022 · What is the best DB service in AWS to store XML data? I do not want to convert to JSON. Need to retrieve XML and display on UI when needed.
  79. [79]
    Processing XML in Hadoop - pingles
    Jan 20, 2010 · Hadoop did seem to offer XML processing: the general advice was to use Hadoops's StreamXmlRecordReader which can be accessed through using the ...
  80. [80]
    [PDF] Oscillating Between Objects and Relational: The Impedance Mismatch
    Impedance mismatch arises from the inherent lack of affinity between the object and relational models. Problems associated with the impedance mismatch include ...
  81. [81]
    XML Middleware Articles
    XML middleware or XML mapping is much like object-relational mapping. It usually involves mapping between XML and relational data.
  82. [82]
    The integration of XML databases and content management ...
    Jul 30, 2019 · ... XML and NoSQL databases. In particular, eXist-db has often been used in publishing and digital edition projects in the humanities, including ...
  83. [83]
  84. [84]
    [PDF] Understanding the XML Standard for Business Reporting and Finance
    XBRL is a widely accepted data stan- dard that solves this dilemma and enables the exchange of uniform financial information between com- puter systems, ...
  85. [85]
    XBRL Financial Statements - Investor Relations | Thomson Reuters
    XBRL (eXtensible Business Reporting Language) is an XML-based language for the electronic communication of business and financial data.
  86. [86]
    A new tool for sharing and querying of clinical documents modeled ...
    We used open-source XQuery processors, namely, SAXON [51] and BaseX [9], for storing and query processing of HL7 CDA documents in CDN. Available security ...
  87. [87]
    [PDF] Scalability of an Open Source XML Database for Big Data
    For the current study, we used a sample record containing 34 clinical documents, which when stored on disk as a single XML file (HL7 CDA format) was ...
  88. [88]
    40. XML Schema-based configuration - Spring
    XML Schema-based configuration in Spring, introduced in 2.0, aims to make configuration easier and clearer, expressing the intent of bean definitions.
  89. [89]
    (PDF) Schema advisor for hybrid relational-XML DBMS
    Specifically, the re- cently released IBM DB2 9 (for Linux, Unix and Windows) is a hybrid data server with optimized management of both XML and relational data.<|separator|>
  90. [90]
    Overview - Clinical Document Architecture v2.0.1-sd
    The HL7 Clinical Document Architecture (CDA) is a document markup standard that specifies the structure and semantics of “clinical documents” for the purpose ...Missing: databases | Show results with:databases
  91. [91]
    Structure of an OOXML file - Altova XMLSpy 2025 Professional Edition
    OOXML is a file format for describing documents, spreadsheets, and presentations. It was originally developed by Microsoft for the company's Office suite of ...
  92. [92]
    Web of Science APIs & Custom Data | Clarivate
    Standard XML feeds​​ Raw underlying Web of Science metadata for several editions/databases from 1900 to today supports your large-scale projects.Better Data, Better... · Start Analyzing The Research... · Leverage Reliable...
  93. [93]
    XML Databases Software Market Size, Growth | CAGR of 6.8 %
    Oct 13, 2025 · Global xml databases software market size was projected at USD 404.44 million in 2025 and is expected to hit USD 722.55 million by 2035 with ...Missing: specialized | Show results with:specialized