Counterpunching in the DBMS2 Debate
Computerworld -
Recently, I've been writing a great deal about data architectures for the future, often under the rubric of "DBMS2." This has ruffled some feathers, including those of database textbook author C.J. Date. Summarizing the whole debate in this limited space is hopeless, but here is a quick tour through some issues that traditional database experts seem to be overlooking.
1. Logical and physical modeling will never be completely separable. A DBMS is, first and foremost, an execution engine for Data Description Language/Data Manipulation Language. To say that logical modeling need not take performance into account is to say that DDL/DML programming need not take performance into account. Wrong. No matter how great your optimizing compiler is, you still can write a slow program; the same principle applies to DBMSs. Indeed, it's even more valid for data modeling than for some other kinds of programming. The higher the level your mistakes are, the harder it is for the optimizer to fix them - and little is higher level than database design.
2. "True relational" DBMSs are very unlikely ever to be practically useful, except perhaps in narrow niches. The gurus claim that a true relational DBMS would allow the complete separation of logical and physical modeling. But as noted above, that will never be practical, at least not in a broad-spectrum, industrial-strength product. Date's beloved "TransRelational" architecture doesn't magically invalidate this point. As for claims of "orders of magnitude" of performance improvement, even if they are true, benchmarks and prototypes are a far cry from versatile, industrial-strength reality.
3. Enterprises don't fully control their data models. A coherent, enterprisewide data model may be a wonderful idea, but it's not something you can implement with any precision - unless you get your whole company to run a single-vendor suite of applications, and perhaps not even then. Purchased apps -- and acquired companies -- mean that your data model is largely defined by other folks.
4. Duplicated data is not inherently bad. Some database gurus abhor duplicated data, based on the presumption that it is hard to keep this data consistent. Taken to the extreme, this would proscribe all of data warehousing. Most of the gurus know better than that, of course, and would quickly concede that read-only duplication is OK, if deployment economics demand it. Rather, what they deplore is duplicated data that is updated in two or more places. But haven't they ever heard of an index? Also, every DBMS maintains duplicate copies of data as part of its essential workings. Perhaps
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
MarketVibe: Communications and Collaboration Needs at Business Organizations
In April 2009, IT and business leaders were invited to participate in a survey on business communications and collaboration solutions. The goal of...
How to Reduce Eclipse BIRT Development Effort for Data Visualizations
Web applications can come with a long list of visualization requirements for structured data. By delivering your output through the BIRT Interactive Viewer,...
The Value of Network and Application Visibility by Aberdeen
This survey-based paper analyzes best practices for improving application visibility and analysis. This paper can help serve as a guideline for organizations looking...
Legacy IT Modernization - Practical Reality
(Source: BluePhoenix) Corporate budgets continue to tighten. Organizations are looking at ways to reduce operating costs and eliminate unnecessary expenses while at the...
The CIO's New Guide to Design of Global IT Infrastructure
Is it possible to eliminate the impact of distance? This paper explores the 5 key principles successful CIOs are using to redesign IT...
Interactive Guide: Getting Started with Data Governance
In this online interactive guide, Andrew White, Research VP with lead analyst firm Gartner, answers these questions to help get you on the...
2007 Gartner Magic Quadrant Report
Riverbed positioned in Leaders Quadrant of Gartner Magic Quadrant for WAN Optimization Controllers. Analyzing strengths vs. cautions, Gartner helps organizations looking to acquire...
Why Now is the Right Time for the Linux Desktop
(Source: Novell) Faced with tighter budgets, enterprises are rethinking their desktop strategies to deliver the same - if not better - services and...
Five Steps to Successful IT Consolidation
Has your Enterprise made the strategic decision to consolidate remote site IT infrastructure into central data centers? Then you have probably discovered that...
Agile Enterprise Content Management (ECM) for Rapid ROI
(Source: IBM) Content rich business processes are a core feature of daily operations at just about any organization today. Very often these essential...
Subscribe to Computerworld

