Menu

Details of the Relation between XML and RDBMS

0 Comment

Basically, the XML document is a collection of data. Though by a collection of data, the XML document is said as a database in other sense a mere collection of data doesn’t make much difference between the other files that store data. After all, all files contain data of some sort.
Still, as a database format, XML has some advantages than other forms of data collection. XML in a database format is a self-describing, portable, and can describe data in tree or graph structure. It is self-describing in the sense that the markup describes the structure and type names of the data, although not the semantics, it is portable means it uses Unicode, and it can describe data in tree or graph structures.
XML is treated as database because of its surrounding capabilities like: storage (XML documents), schemas (DTDs, XML Schemas, RELAX NG, and so on), query languages (XQuery, XPath, XQL, XML-QL, QUILT, etc.), programming interfaces (SAX, DOM, JDOM), like other databases. Hanson expresses that XML data are extremely well-suited to hierarchical storage,
But long-winded nature and the slow accessibility to data due to parsing and text conversion are the drawbacks of this technology. Also on the minus side, it lacks many of the things found in real databases: efficient storage, indexes, security, transactions, and data integrity, multi-user access, triggers, queries across multiple documents like RDBMS.
Reasons to adopt XML database:
According to John Cox, senior editor of Network World, there is a need for the XML database as the network executives begin to experiment with web services. Users will be interacting with business partners and customers through web services.
On the other hand, suppose Web site is built from a number of prose-oriented XML documents. Not only to manage the site, but also to provide a way for users to search its contents. Documents are likely to have a less regular structure and things such as entity usage are probably important because they are a fundamental part of how documents are structured.