I am looking into processes for Content management systems content storage that do not involve entity attribute value models or NoSQL. A few of the problems I am attempting to solve:
- No DDL for brand new types
- Indicating the datatype of the particular node's text() (DTD association?)
- Querying over JDBC with DDL (e.g. xquery + Choose, UPDATE, Place, Remove) no OO programming API therefore the client handles record sets.
- Data import/export
- Any scaling/performance concerns
As I have not found a similar question, and when this really is well accepted, I'll curate making a community wiki.
Beginning with Sql Server 2005 you be capable of store XML like a native type. In addition, but you may also create Schemas and add these to the the database to validate the XML being placed in to the aforementioned XML column type.
Additionally towards the XML type, SQL Server 2005 and 2008 add better support for coming back XML using queries when in comparison to how you made it happen with Sql Server 2000 and
FOR XML AUTO.
Following are two pages that could be of great benefit:
I have used Berkeley DB XML previously. It supports XML Schema and XQuery directly, and it is built on the top of Berkeley DB therefore it should scale pretty much, although I've not tried on the extender inside a large-scale context.
Oracle (since version 9i). Take a look here
for more information.