This content has been marked as final. Show 8 replies
Oracle XML DB is the name for a set of Oracle Database technologies related to high-performance XML storage and retrieval. It provides native XML support by encompassing both SQL and XML data models in an interoperable manner.
i misunderstood your found thing
But I am looking for an XML-enabled database, Oracle XML DB is a native database.
PS. For RDBMS handling XML data, we find two categories: XML-enabled systems (they store XML data using a special data type like BLOB, CLOB,...), or the native XML systems (which stor XML data in its hierarchical structure, so the fundamental unit of storage is XML document). So, I precise that I am looking for an XML-enabled system and NOT a native XML system.
if i understand correctly you say
XML-enabled database - store XML data using a special data type like BLOB, CLOB
native XML database - stor XML data in its hierarchical structure
in projection of oracle xml db you can store your xml in xmltype or in clob or in blob or as file in os
so looks like that oracle xml db is XML-enabled native XML database :)
i'm going crazy ;)
But I am looking for an XML-enabled database, Oracle XML DB is a native database.No, in essence, Oracle XML DB is an XML-enabled database.
It leverages Oracle's storage and memory management and SQL capabilities to handle XML content.
I am looking for a RDBMS (Relational Database Management System) that provides management of XML data in a relational fashion.Oracle provides that for you, both using the Object-Relational storage feature or Binary XML with structured index.
Explain us what would be your typical use case and we can advise on the options you have.
Thanks for your help,
To be more clear, I am looking for an XML-enabled database system (which provides only relational techniques to manage XML data).
Oracle is a Hybrid system (it means that it provides both native and relational fashions to manage XML data, e.g. you can store XML document as XMLType column (native way) or using BLOB data type (relational data type). I am collecting information about the three broad categories of XML database systems (native, XML-enabled, and Hybrid), and I would like to give example of each system. For example, there is BaseX and eXist-db for the first category (native systems), Oracle and IBM DB2 for the third category (each of theme manage XML data in both native and relational fashions). However, for the second category (XML-enabled systems), I don't find more information about the existing systems, there is for instance postgreSQL which is an XML-enabled system, but I don't find more information about its architecture, its XML data storage model, API for querying and updating, and so on.
Please don't hesitate to help me if you get some documentation about postgreSQL or about another XML-enabled database system.
Thank you again.
Oracle is a Hybrid system (it means that it provides both native and relational fashions to manage XML data, e.g. you can store XML document as XMLType column (native way) or using BLOB data type (relational data type).OK, I thought you mean "relational" as in "access the data inside the XML document XML relationally".
Now, what I don't understand is why you insist on having an XML-enabled DB if ultimately you want to store XML in unstructured datatypes such BLOB or CLOB, both of which don't care if the data is XML or not.
Maybe I'm still missing your point...
Focusing on Oracle capabilities, the XMLType datatype has actually multiple flavours, depending on your storage strategy :
- binary XML (post-parsed, compact format)
- CLOB-based (deprecated)
- Object-Relational storage (for a highly data-oriented architecture)
Storing XML in BLOB or CLOB columns is not relevant to this discussion as it doesn't enable the DB to efficiently deal with XML content.