|
XML and Databases
This paper discusses the relationship between XML and databases and describes some of the types of software available to process XML documents with databases. Although it is not intended to be exhaustive, I hope that it describes many of the major issues in using XML with databases.
|
|
XML:DB Initiative for XML Databases
Databases tailored for the storage of XML data represent an exciting new opportunity for improvement in the storage and manipulation of data and metadata. For a large set of applications an XML database will often far surpass traditional data storage mechanisms in convenience, ease of development and performance. The following list contains a number of applications that are ideally suited for XML databases.
|
|
Professional XML Databases
The below articles are from Chapter 2 of the Wrox Press book Professional XML Databases. Professional XML Databases covers moving from a relational database to XML.
|
|
Introduction to Native XML Databases
The need to process and store XML has spawned several new types of software tool, one of which is the "native XML database." This article explains the principles behind such databases.
|
|
XML and Databases
Resources on XML Databases
|
|
XML Structures for Existing Databases
This book chapter, excerpted from the just-published Wrox Press book Professional XML Databases, offers clear, authoritative guidance for how to deal with an existing database that you need to move to XML, from modeling the tables and keys to dealing with orphaned elements. The chapter provides an overview of the issues involved and details 11 rules for creating XML data structures for data in a relational database. The article includes suggestions for creating data structures that can be processed rapidly. Used with the permission of the publisher.
|
|
XML APIs for databases
Most Web applications require the presentation of database-generated information. XML, because of its ability to separate content from presentation, is fast becoming an industry standard for data exchange. Most XML tools work with either the SAX or DOM API. This article presents a way to blend the power of a database with the features of XML. It also provides a simple, pure Java implementation of XML APIs for databases that works with any JDBC data source. With this approach, XML tools can treat a database as a virtual XML document.
|
|
A List Of XML Databases
|
|
XML Structures for Existing Databases
An excerpt from WROX Press Professional XML Databases by Kevin Williams, Michael Brundage, Patrick Dengler, Jeff Gabriel, Andy Hoskinson, Michael Kay, Thomas Maxwell, Marcelo Ochoa, Johnny Papa, Mohan Vanmane
|
|
XML, Java, databases and the Web
XML and Java can certainly be used to create some very interesting applications from app servers to better searchable websites. However, it is sometimes very difficult to understand where everything really fits. There are web servers, Servlet engines, relational databases, and object databases. Chances are that an XML solution that you have to create will use of one of these prebuilt software pieces. XML development also involves using certain APIs, such as SAX, DOM, Servlets, Swing, RMI, JDBC, and the core Java API.
|
|
XML Databases Offer Greater Search Capabilities
Extensible Markup Language is emerging not only as a Web page markup standard, but as a database technology with the potential to simplify and speed future Web operations.
|
|
Why And How To Benchmark XML Databases
|
|
XML Structures for Existing Databases
In this chapter, we will examine some approaches for taking an existing relational database and moving it to XML.
|
|
Temporal Query Operators in XML Databases
|
|
Maintain Large Databases With XML Servers
One of the more common questions asked here at "Ask the XML Pro" has to do with the dilemma of maintaining large databases of XML data. Specifically, suppose that you had an XML document that was both broad (had a large number of objects, as might be expected from a database query on a large dataset), and deep (each object contained a fair number of properties, subordinate objects, and the like).
|
|
XML representation of a relational database
A relational database consists of a set of tables, where each table is a set of records. A record in turn is a set of fields and each field is a pair field-name/field-value. All records in a particular table have the same number of fields with the same field-names.
This article describes an application of (a simple subset of) XML that can be used to represent such a database.
|