• Login/Register
  • Section: Online Services /Tuesday 14th October 2014

    Alphabetic Index : A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

    Search β):

    * XML database *

    Order XML database

    پایگاه داده‌های اکس‌ام‌ال

    (Wikipedia) - XML database
    This article has multiple issues. Please help improve it or discuss these issues on the talk page.
    This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed. (August 2011)
    This article has an unclear citation style. The references used may be made clearer with a different or consistent style of citation, footnoting, or external linking. (December 2011)

    An XML database is a data persistence software system that allows data to be stored in XML format. These data can then be queried, exported and serialized into the desired format. XML databases are usually associated with document-oriented databases.

    Two major classes of XML database exist:

  • XML-enabled: these may either map XML to traditional database structures (such as a relational database), accepting XML as input and rendering XML as output, or more recently support native XML types within the traditional database. This term implies that the database processes the XML itself (as opposed to relying on middleware).
  • Native XML (NXD): the internal model of such databases depends on XML and uses XML documents as the fundamental unit of storage, which are, however, not necessarily stored in the form of text files.
  • Contents

    Rationale for XML in databases

    O''Connell gives one reason for the use of XML in databases: the increasingly common use of XML for data transport, which has meant that "data is extracted from databases and put into XML documents and vice-versa". It may prove more efficient (in terms of conversion costs) and easier to store the data in XML format. In content-based applications, the ability of the native XML database also minimizes the need for extraction or entry of metadata to support searching and navigation. In a native XML environment, the entire content store becomes metadata through query languages such as XPath and XQuery, including content, attributes and relationships within the XML (find string "XABr" within element <para> containing attribute 123 having value "P" or "Q", only within parent Y and siblings F or G.) While this level of search capability is possible in external metadata, it requires more complex and difficult processing to reproduce the content tree in metadata.

    XML Enabled databases

    XML enabled databases typically offer one or more of the following approaches to storing XML within the traditional relational structure:

  • XML is stored into a CLOB (Character large object)
  • XML is `shredded` into a series of Tables based on a Schema
  • XML is stored into a native XML Type as defined by the ISO
  • RDBMS that support the ISO XML Type are:

  • IBM DB2 (pureXML)
  • Microsoft SQL Server
  • Oracle Database
  • PostgreSQL
  • Typically an XML enabled database is best suited where the majority of data are non-XML. For datasets where the majority of data are XML a Native XML Database is better suited.

    Example of XML Type Query in IBM DB2 SQLSELECT id, vol, xmlquery(''$j/name'', passing journal AS "j") AS name FROM journals WHERE xmlexists(''$j'', passing journal AS "j")Native XML databases

    The term "native XML database" (NXD) can lead to confusion. Many NXDs do not function as standalone databases at all, and do not really store the native (text) form.

    The formal definition from the XML:DB initiative (which appears to be inactive since 2003) states that a native XML database:

    Additionally, many XML databases provide a logical model of grouping documents, called "collections". Databases can set up and manage many collections at one time. In some implementations, a hierarchy of collections can exist, much in the same way that an operating system''s directory-structure works.

    All XML databases now support at least one form of querying syntax. Minimally, just about all of them support XPath for performing queries against documents or collections of documents. XPath provides a simple pathing system that allows users to identify nodes that match a particular set of criteria.

    In addition to XPath, many XML databases support XSLT as a method of transforming documents or query-results retrieved from the database. XSLT provides a declarative language written using an XML grammar. It aims to define a set of XPath filters that can transform documents (in part or in whole) into other formats including plain text, XML, or HTML.

    Many XML databases also support XQuery to perform querying. XQuery includes XPath as a node-selection method, but extends XPath to provide transformational capabilities. Users sometimes refer to its syntax as "FLWOR" (pronounced ''Flower'') because the query may include the following clauses: ''for'', ''let'', ''where'', ''order by'' and ''return''. Traditional RDBMS vendors (who traditionally had SQL-only engines), are now shipping with hybrid SQL and XQuery engines. Hybrid SQL/XQuery engines help to query XML data alongside the relational data, in the same query expression. This approach helps in combining relational and XML data.

    Most XML Databases support a common vendor neutral API called the XQuery API for Java (XQJ). The XQJ API was developed at the JCP as a standard interface to an XML/XQuery data source, enabling a Java developer to submit queries conforming to the World Wide Web Consortium (W3C) XQuery 1.0 specification and to process the results of such queries. Ultimately the XQJ API is to XML Databases and XQuery as the JDBC API is to Relational Databases and SQL.

    Language features Name License Native Language XQuery 3.0 XQuery Update XQuery Full Text EXPath Extensions EXQuery Extensions XSLT 2.0
    BaseX BSD License Java Yes Yes Yes Yes Yes Yes
    eXist LGPL License Java Partial Proprietary Proprietary Yes Yes Yes
    MarkLogic Server Commercial C++ Partial Proprietary Proprietary No No Yes
    Sedna Apache License C++ No Yes Yes No No No
    Supported APIs Name XQJ XML:DB RESTful RESTXQ WebDAV
    BaseX Yes Yes Yes Yes Yes
    eXist Yes Yes Yes Yes Yes
    MarkLogic Server Yes No Yes Yes Yes
    Sedna Yes Yes No No No

    Tags:Apache, HTML, ISO, Java, Microsoft, Wikipedia, World Wide Web, World Wide Web Consortium, XML, XML database, XPath, XQuery, XSLT

    Add definition or comments on XML database

    Your Name / Alias:
    Definition / Comments
    neutral points of view
    Source / SEO Backlink:
    Anti-Spam Check
    Enter text above
    Upon approval, your definition will be listed under: XML database

    Happy Summer Sale

    Home About us / Contact    Products    Services    Iranian History Today    Top Iran Links    Iranian B2B Web Directory    Historical Glossary
    Copyright @ 2004-2016 fouman.com All Rights Iranian