database where you can store XML data?

Forum Moderators: open

Message Too Old, No Replies

database where you can store XML data?

in actual XML format?

Darkelve

9:20 am on Nov 23, 2006 (gmt 0)

I'm looking for some kind of database-program
that runs on the server and can treat XML data
similar to 'regular' relational database.

E.g. it can do one or more of the following:

- Faster access to data than flat files
- Easy to query (also with XSLT/XPATH-like constructs)
- Access control
- Random Access to data
- Has a built-in privilige sytem

Basically some software (preferrably open source) in
which I can 'import' (manual entry is okay too)
the XML 'data islands' which I have now and treat
it -more or less- like a relational database.

shri

5:41 am on Nov 24, 2006 (gmt 0)

Something like this?

[dev.mysql.com...]

I'm intrigued as to why you'd want to merge what I call (and I might be way off-track on this) a presentation layer (XML) with the data.

I view anything that has tags as presentation.

Any good references on what the benefits of doing this are?

jtara

11:10 pm on Nov 25, 2006 (gmt 0)

I think the Database forum would probably be a better place for this.

You might want to clarify what you mean by "XML data islands". I'm not sure what you mean by that. Can you gives some examples of what you are talking about?

You are asking for a pretty tall order. XML is simply a data representation - a way of representing data as it moves from point A to point B. It implies nothing about underlying database structure (only data structure). As well, XML permits the description of data structures that would be difficult if not impossible to represent directly in an RDBMS. It would not be easy to analyze XML data and determine the optimum structure of a database to hold the data.

Darkelve

11:06 am on Nov 28, 2006 (gmt 0)

Hi,

I found what I was looking for in the form of an Open Source product called "eXist". The only problem is that it seems hard to install, but then again, that's my problem...

They've got a demo/sandbox of why this can be useful. My purpose if for content management without having a full-blown Content Management System.

[edited by: Darkelve at 11:15 am (utc) on Nov. 28, 2006]

aspdaddy

10:28 pm on Nov 28, 2006 (gmt 0)

XML Data Isalands

They are the neat little documents that be bound into regular html tables and let you search/sort without any code. They are very cool.

[w3schools.com...]

Darkelve

1:50 pm on Dec 12, 2006 (gmt 0)

yes exactly. Except I prefer to do it on the server side so I don't have to worry about browser support.

[edited by: Darkelve at 1:50 pm (utc) on Dec. 12, 2006]

aspdaddy

5:23 pm on Dec 13, 2006 (gmt 0)

I dont know if this helps at all but if you store it relationally you can save it as xml quite easily, you could maybe re-publish xml periodically from the db or whenever it changes.


Set objRS = objConn.Execute("SELECT * FROM vwSales" )
Set oDOM = Server.CreateObject("MSXML2.DOMDocument")
oDOM.async = False
objRS.Save oDOM, 1 
oDOM.save("c:/test.xml")