XML databases

XML databases are relatively new, but many of the concepts and techniques applicable for designing XML databases have been around for several years. XML databases are relatively new in the logical sense of a database but are not new as far as how the logical view is applied. If you want to use a type of XML database, you may either use XEDB, NXD, or a combination of the two. These databases are increasingly becoming both quick and powerful as time goes on. There are numerous useful extensions offered (and incorporated into open source tasks like eXist and the Sleepy Cat Database) which deals with the update portion of the data queries in an easy way.

XML databases are widely used in Internet applications. They call for all of the elements that one would expect with a database system which are a query and transaction language, a way to build indices and structure data, and an interface for other applications. Additionally, many XML databases can provide a logical model of grouping documents, called “collections “. Several XML databases are integrating support for faceted queries, however they call for unique indices to produce the most effective performance. XML databases sit at the conjunction of two different styles which address different issues relating to XML Databases.

Native XML Databases

Databases that store XML in “native” form, generally as a variation of what is known as the DOM map to the main data store. These databases normally offer a much more granular means of searching, querying, storing and adjusting XML content. Native databases are most commonly used to store document-centric data. They are quick and easy to install and they support text searches of documents without the need for the entire document to be loaded in memory.

Native databases are also helpful for storing documents in the XML format, regardless of the content within those documents. They can store XML files without being aware of their scheme, assuming there is one that exists. This database will preserve the physical structure (entity usage, CDATA sections, etc. ) as well as PIs, DTDs, comments etc. Native XML Stores work best when you can express your data sub-collection as one or more path expressions to the data. Native databases are also commonly used to integrate data.

Relational Database Systems

Relational database systems store information in a table row. Relational DBMSs hold the advantage in which indexes may be created or deleted without changing the existing applications that make use of them. Relational databases and XML documents are both potent methods to represent connections between data, but they’re powerful in their unique ways.

Relational db vendors are also adding better support for XML. For example, Microsoft is developing the Yukon release of SQL Server. Relational DBMSs utilize many different algorithms to compute the result of an SQL statement. These systems cannot fulfill all of the demands of e-business since they process information separately from its context. More specifically, it relates each relational database and set of queries as a distinct graph, which we refer to as the database graph.