XML Storage: Oracle Should be Hearing Footsteps
Computerworld -
Twenty-four years ago, I raised a furor in the database management systems industry. As a rookie analyst -- a stock analyst, no less -- I argued that the then-dominant hierarchical/network data architectures should and would be replaced by "index-based" systems. Over the next few years, I was proved right, as inverted-list and relational products took over the DBMS market.
Recently, I've argued a contrasting position: XML-based data architectures should and will get an important IT role in applications where tabular data-bases don't do a great job. Thus, I think that IBM's and Microsoft's more- or-less native XML storage systems will be more than niche curiosities, and Oracle will soon have to offer a worthy competitor.
There are three basic parts to the argument:
1. There are applications for which XML offers a superior logical architecture to SQL. These fall into two groups. First, there are apps in traditional categories -- CRM, SCM and so on -- that don't have naturally concise relational schemas. We can say that the natural schema is highly variable, or we can say that the overarching schema that takes this variability into account is horrifically complex. Either way, stuffing these apps into a relational straitjacket causes a lot of unnecessary grief.
Second, there are apps that deal with new kinds of complex, dynamic documents. Before XML, either these documents didn't exist at all or their processing couldn't be fully automated.
2. For many of these applications, native XML storage is more efficient than traditional relational storage. Before Microsoft's and IBM's recent announcements, there were two ways to store XML in a relational database. First, since an XML document is a string of characters, you could stick it in a Clob, or Character Large Object. But updating or retrieving specific data values inside the Clob is very inefficient; you basically have to process the whole document.
Alternatively, the XML can be "shredded" into a series of relational tables. But that can make for some very complex updates and joins. So for documents that have complex structures, neither approach is appealing. Native storage is a superior alternative.
3. XML storage won't have the same drawbacks that hierarchical/network products did. Hierarchical systems failed because reusing data in multiple apps was too difficult. Today, however, RDBMS vendors integrate XML and relational storage. You can access XML documents through SQL and your tables through XQuery. "Native" storage really is just a performance issue.
Admittedly, some technical problems are still unresolved. The industry hasn't even agreed upon, let alone implemented, a reasonably
Additional Resources



Learn the important issues you must consider before starting your next mobility initiative. Get your mobility white paper from IDC now, compliments of Sybase.
White Papers & Webcasts
Tapping the Full Potential of Sales and Marketing Data for Pharmaceuticals
As pharmaceutical manufacturers face an era of sharply reduced sales and marketing budgets, increasingly complex and restrictive regulations, and rapidly changing demand patterns...
Improving Quality of Service for Oracle Database with My Oracle Support
(Source: Oracle) Oracle's Willie Hardie and Oracle Support Expert Sean Bingham discuss how My Oracle Support optimizes the quality of support provided to...
Bloor Research: Netezza and the HP Oracle Database Machine
HP and Oracle have recently announced the HP Oracle Database Machine. This has been positioned by Oracle as a competitor to Netezza and...
Usability Is Everything
Learn what sets Workday's HR and Payroll solutions apart from the competition....
Risk Readiness and Redundancy: PCI Compliance Automation
(Source: Symantec) This paper examines compliance regulations surrounding the Payment Card Industry Data Security Standards, the challenges it puts on IT Security and...
The Value of Real SaaS at Workday
Cost savings, speed to value, and innovation brought to the enterprise by Workday's software-as-a-service solutions for HR and Payroll....
How to Populate Your CMDB in Four Steps
Generally, CMDBs populated by discovery tools alone simply aren't usable. They fail because they contain massive amounts of irrelevant information. You avoid this...
SaaS at Flextronics, Inc.
Dave Smoley, CIO of Flextronics, discusses the real value of software-as-a-service and why he chose Workday for his HR solution....
The Metrics Driven Organization: Your Business in Challenging Times
This white paper discusses how metrics increase visibility and sharpen decision making to ensure excellent customer service, rising revenue and growth....
Why Compliance Pays
This OnDemand webcast explores the relationship that firms with best compliance records have higher revenue, greater customer retention, lower financial losses from data...
Subscribe to Computerworld

