CODEWITHSUNDEEP
xmldatabasejdbccontent-management-system
orangepips
orangepips

Reputation: 9971

What Relational Databases can Store XML as a Native Type?

I'm investigating approaches for CMS content storage that don't involve entity attribute value models or NoSQL. Some of the problems I'm trying to solve:

  1. No DDL for new types
  2. Specifying the datatype of a particular node's text() (DTD association?)
  3. Querying over JDBC with DDL (e.g. xquery + SELECT, UPDATE, INSERT, DELETE) not an OO programming API so the client deals with record sets.
  4. Data import/export
  5. Any scaling/performance concerns

As I've not found a comparable question, and if this is well received, I will curate and make a community wiki.

Upvotes: 2

Views: 151

Answers (3)

porges
porges

Reputation: 30580

I've used Berkeley DB XML in the past. It supports XML Schema and XQuery directly, and it's built on top of Berkeley DB so it should scale pretty well, although I haven't used it in a large-scale context.

Upvotes: 1

Waleed Al-Balooshi
Waleed Al-Balooshi

Reputation: 6406

Starting with Sql Server 2005 you have the ability to store XML as a native type. Not only this, but you can also create Schemas and add them to the the database to validate the XML being inserted into the aforementioned XML column type.

In addition to the XML type, SQL Server 2005 and 2008 add better support for returning XML using queries when compared to the way you did it with Sql Server 2000 and FOR XML AUTO.

UPDATE

Following are two pages that might be of benefit:

White Paper: What's New for XML in SQL Server 2008

Implementing XML in SQL Server

Upvotes: 3

Doc Brown
Doc Brown

Reputation: 20044

Oracle (since version 9i). Look here

http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96620/xdb04cre.htm

for further information.

Upvotes: 0

Related Questions