The Race Is On

 
 
By Timothy Dyck  |  Posted 2001-12-03 Email Print this article Print
 
 
 
 
 
 
 


The Race Is On

Its safe to say that, within the next few years, all database products will need to be able to quickly verify, store and retrieve data in XML format. More open to question is whether traditional relational databases can gain XML features faster than new XML databases can gain the scalability, programmability, reliability and manageability of the relational players.

Based on history and our experience, traditional relational databases will beat XML databases to the punch.

In 1996 and 1997, we saw relational players Oracle Corp., IBM and Informix Software Inc. (now part of IBM) add object database and Java language features to their relational databases to compete with pure object databases. In 1998 and 1999, these same vendors added a variety of extensibility features to store geospatial, text, image, HTML and time series data in their databases, basically killing the market for custom databases that were designed just to store one of these types of data.

Now, the relational database players are taking advantage of the past work that added object support, extensibility, Java and text manipulation to their products and are combining these strengths with their extensive research efforts into XML parsers and query languages. Long term, we think relational engines will be the right place for both XML and non-XML data.

Oracle, IBM and Sybase Inc. have all added an XML data type to their databases to store XML in native format. These vendors database products, in addition to Microsoft Corp.s Microsoft SQL Server, allow database administrators to parse XML data at import time and store that information in a set of relational tables. They also allow retrieval of data in XML format.

The main advantage of XML databases is their free-form, document- oriented storage engines. Theres no need to specify the structure of XML documents before storing them.

As a result, messy, semistructured data is handled well by native XML databases. Organizations with applications oriented around the storage of entire documents, such as manuals, brochures or Web pages, will find native XML databases the right tool for the Web.

In the short term, those with text-oriented applications will find native XML databases a good fit; for others, we recommend investigating what the relational players are doing, as this technology is changing almost week to week.



 
 
 
 
Timothy Dyck is a Senior Analyst with eWEEK Labs. He has been testing and reviewing application server, database and middleware products and technologies for eWEEK since 1996. Prior to joining eWEEK, he worked at the LAN and WAN network operations center for a large telecommunications firm, in operating systems and development tools technical marketing for a large software company and in the IT department at a government agency. He has an honors bachelors degree of mathematics in computer science from the University of Waterloo in Waterloo, Ontario, Canada, and a masters of arts degree in journalism from the University of Western Ontario in London, Ontario, Canada.
 
 
 
 
 
 
 

Submit a Comment

Loading Comments...
 
Manage your Newsletters: Login   Register My Newsletters























 
 
 
 
 
 
 
 
 
 
 
Close
Thanks for your registration, follow us on our social networks to keep up-to-date
Rocket Fuel