Problem solve Get help with specific problems with your technologies, process and projects.


Does normalization apply to XML-based database systems? What's the difference between the RDBMS and XDBMS?
A relational database management system (RDBMS) is one that stores data in such a manner that shows the relation between the data. For instance, your database can have EMPLOYEES and DEPARTMENTS. Those can be two tables in your database. There is a relation at play here as well. An employee can work in a department. A department can have many employees.

An XML-based DBMS is one that doesn't worry about relations. It stores the data in the database in XML format....

I'm not sure why anyone would really want to do this. The XML format, by its very nature is hierarchical. The industry has long-since moved away from hierarchical database systems for many reasons (this is one reason why you don't see ADABAS being used too much any more). To me, the move to XML-based DBMS platforms is a step backwords.

The rules of normalization are written specifically for a RDBMS. As such, they do not apply to non-RDBMS systems. While you can try to extend these rules to XML-based systems, they won't be a perfect fit for these systems.

This was last published in December 2003

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.