XML DB
Falanga Alain
I need a database tha can store XML (not really a problem for example I
can use a Longtext, clob or anyother think like this) and all course a
way to request (XQuery, XPath ?) this ?
I have try MySQL 5 that seams to do this, but from now I always
research information.
Do you know for example if Firebird, NexusDB, PostgresSQL or other
handle this and how ?
I'm looking for a free database if possible that can handle this. I
have a large amount of data to store / request (1 Tb), so performance
is important.
Thanks for all your feedback at advance.
Cheers,
A.
--
Ceci est une signature automatique de MesNews.
Site : http://www.mesnews.net
Martijn Tonies
> I need a database tha can store XML (not really a problem for example I
> can use a Longtext, clob or anyother think like this) and all course a
> way to request (XQuery, XPath ?) this ?
>
> I have try MySQL 5 that seams to do this, but from now I always
> research information.
>
> Do you know for example if Firebird, NexusDB, PostgresSQL or other
> handle this and how ?
>
> I'm looking for a free database if possible that can handle this. I
> have a large amount of data to store / request (1 Tb), so performance
> is important.
If performance is important, then don't use XML. Break it up into a
decent relational schema and do normal SQL instead.
--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
Pierre Y.
> Hi,
>
> I need a database tha can store XML (not really a problem for example I can
> use a Longtext, clob or anyother think like this) and all course a way to
> request (XQuery, XPath ?) this ?
>
> I have try MySQL 5 that seams to do this, but from now I always research
> information.
>
> Do you know for example if Firebird, NexusDB, PostgresSQL or other handle
> this and how ?
>
> I'm looking for a free database if possible that can handle this. I have a
> large amount of data to store / request (1 Tb), so performance is important.
>
> Thanks for all your feedback at advance.
> Cheers,
> A.
Did you give a look at Bekerley DB "XML" from SleepyCat (acquired by
Oracle) ?
http://www.oracle.com/database/berkeley-db/xml/index.html
--
Pierre Y.
Femi Fadayomi
>
> I'm looking for a free database if possible that can handle this. I
> have a large amount of data to store / request (1 Tb), so performance
> is important.
>
DB2 Express-C by IBM. Here is where to get additional Information:
http://www-306.ibm.com/software/data/db2/express/getstarted.html
HTH
Femi
Chris Morgan
> can use a Longtext, clob or anyother think like this) and all course a way
> to request (XQuery, XPath ?) this ?
>
> I have try MySQL 5 that seams to do this, but from now I always research
> information.
>
> Do you know for example if Firebird, NexusDB, PostgresSQL or other handle
> this and how ?
>
> I'm looking for a free database if possible that can handle this. I have a
> large amount of data to store / request (1 Tb), so performance is
> important.
>
> Thanks for all your feedback at advance.
> Cheers,
> A.
Apparently Oralce can store XML natively, with built-in support
for querying the XML via SQL.
There is a free Oracle Lite version available.
We use Oracle, but not its XML capability, and have not tried
installing/using the Lite version, so I don't know how easy (or
not) it is to configure.
Cheers,
Chris
Falanga Alain
>> I need a database tha can store XML (not really a problem for example I
>> can use a Longtext, clob or anyother think like this) and all course a
>> way to request (XQuery, XPath ?) this ?
>>
>> I have try MySQL 5 that seams to do this, but from now I always
>> research information.
>>
>> Do you know for example if Firebird, NexusDB, PostgresSQL or other
>> handle this and how ?
>>
>> I'm looking for a free database if possible that can handle this. I
>> have a large amount of data to store / request (1 Tb), so performance
>> is important.
>
> If performance is important, then don't use XML. Break it up into a
> decent relational schema and do normal SQL instead.
XML as this think that is excelent is that is not "relationalated"
define that why we used it, so putting all inside a relational schema
is not our choice ... You are right for the other part (DB Oriented
version) off course.
Martijn Tonies
> >> I need a database tha can store XML (not really a problem for example I
> >> can use a Longtext, clob or anyother think like this) and all course a
> >> way to request (XQuery, XPath ?) this ?
> >>
> >> I have try MySQL 5 that seams to do this, but from now I always
> >> research information.
> >>
> >> Do you know for example if Firebird, NexusDB, PostgresSQL or other
> >> handle this and how ?
> >>
> >> I'm looking for a free database if possible that can handle this. I
> >> have a large amount of data to store / request (1 Tb), so performance
> >> is important.
> >
> > If performance is important, then don't use XML. Break it up into a
> > decent relational schema and do normal SQL instead.
>
> XML as this think that is excelent is that is not "relationalated"
> define that why we used it, so putting all inside a relational schema
> is not our choice ... You are right for the other part (DB Oriented
> version) off course.
Disagreed. XML is good for data interchange and all, but not for
decent complex storage.
--
Martijn Tonies
Database Workbench - development tool for Firebird and more!
Brian Moelk
> I need a database tha can store XML (not really a problem for example I
> can use a Longtext, clob or anyother think like this) and all course a
> way to request (XQuery, XPath ?) this ?
SQL Server?
> I'm looking for a free database if possible that can handle this. I have
> a large amount of data to store / request (1 Tb), so performance is
> important.
One of the most interesting native XML databases to me is:
It's Java so I doubt it will be very speedy, but it's interesting
nonetheless.
--
Brian Moelk
Brain Endeavor LLC
bmo...@NObrainSPAMendeavorFOR.MEcom
William Egge
need to store the XML as text but instead parse it before storage and then
you can optimized the internal structure for querying. Only input and
output need be translated to text.
Martijn Tonies
No, the supposed problem is because XML is hierarchic, which is slow.
That's why relational database management systems were invented.
--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Piotr Szturmaj
> can use a Longtext, clob or anyother think like this) and all course a way
> to request (XQuery, XPath ?) this ?
There is a contrib module xml2 for PostgreSQL. It supports querying by
XPath.
William Egge
-Bill
Uffe Kousgaard
news:456ee98b$1...@newsgroups.borland.com...
>
> No, the supposed problem is because XML is hierarchic, which is slow.
No, the problem with xml is the lack of random access to records. And all
the parsing of text involved.
Regards
Uffe
Martijn Tonies
But hierarchic access is very different.
William Egge
I still don't see your point, relational data is normally hierarchic.
Client > Orders for example.
-Bill
William Egge
> the parsing of text involved.
The parsing of text can be gotten around on the storage level, text parsing
at most effects input and output but not nessesarily the query engine.
I agree about randomn access, but that only applies if you strictly maintain
the heiarcle structure. I am more inclined to say you should not have an
XML DB but an OODB instead and use XML as an easy format for input/output.
-Bill
Martijn Tonies
>
> I still don't see your point, relational data is normally hierarchic.
> Client > Orders for example.
Eh, sure, but to get to Orders, you don't have to "walk" all clients.
Franz-Leo Chomse
which is represented by a client reference in the orders table.
A pure hierarchic database is basically a system of nested tables.
The major difference is the fact that the contents of a "sub" table
in a hierarchic system is ordered, i.e. you access a record by its
position inside the table.
A relational database can support hierarchical data only if it gets
flattened out by adding two fields for each level of hierarchy -
key value and record number.
In a relational database you normally have only one read operation
for a specific record (if you know its primary key). In a hierarchic
database you have a read operation for each level.
Regards from Germany
Franz-Leo
William Egge
I am not an advocate of an XML DB, but this discussion is about performance
and not its structure.
The walking is only specified by the query, but execution does not have to
match the query. The final output drives the optimization.
For instance, if you wanted just orders, your query in XSL would walk the
clients but only output orders. Imagine that the XML data was stored in a
relational database - then there would be an orders table and then the
optimized execution would be a simple select on that table without any
client walking. In this case there would be no performance difference
between an XML DB and a Relational Database.
-Bill
Martijn Tonies
>
> I am not an advocate of an XML DB, but this discussion is about
performance
> and not its structure.
Yes, that is true. In the past, hierarchic databases haven proven to
be:
- inflexible
- incapable
- and slow.
The relational model was created to avoid these problems. The
performance is, indeed, an implementation problem. Nevertheless,
a relational storage system is much more flexible than XML.
> The walking is only specified by the query, but execution does not have to
> match the query. The final output drives the optimization.
>
> For instance, if you wanted just orders, your query in XSL would walk the
> clients but only output orders. Imagine that the XML data was stored in a
> relational database - then there would be an orders table and then the
> optimized execution would be a simple select on that table without any
> client walking. In this case there would be no performance difference
> between an XML DB and a Relational Database.