Skip the navigation
Opinion

Counterpunching in the DBMS2 Debate

By Curt A. Monash
October 10, 2005 12:00 PM ET

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.



Additional Resources
Forrester Consulting - Optimizing Users and Applications in a Mobile World
WHITE PAPER
Solving application issues over the WAN requires careful consideration. Based on their independent research, Forrester Consulting offers recommendations on how to tackle application performance issues, insufficient bandwidth and the inability to quickly restore users in a disaster.

Read now.

Security KnowledgeVault
WHITE PAPER
Security is not an option. This KnowledgeVault Series offers professional advice how to be proactive in the fight against cybercrimes and multi-layered security threats; how to adopt a holistic approach to protecting and managing data; and how to hire a qualified security assessor. Make security your Number 1 priority.

Read now.

Cut Communications Costs Once and for All
WHITE PAPER
New IP-based communications systems are being deployed by small and midsized businesses at a rapid rate. Learn how these organizations are enabling faster responsiveness, creating better customer experiences, speeding office or mobile interactions, and dramatically reducing existing communications costs.

Read now.

BI and Analytics White Papers
X-Ray of the PCI Process-4 Proactive Steps
This white paper from Forrester Research Inc., helps break PCI into understandable components. Security and risk professionals will gain knowledge and insight into...
Forrester: Economic Impact of Switching to Google Apps
Content provided by Google

Read this Forrester report on the "total economic impact" of Google Apps, and learn how switching to Google Apps creates...
Intelligent Systems: Unlocking Hidden Business Value with Data
An intelligent system enables data to flow across an enterprise infrastructure, spanning the devices where valuable data is gathered from employees and customers,...
Concepts of NonStop SQL/MX
For DBAs and developers who are familiar with Oracle solutions and want to learn about NonStop SQL/MX, this whitepaper provides an overview of...
HP Advanced Information Services for SAP In-Memory Appliance (SAP HANA)
Organizations are eager to connect the vast amounts of data available within and outside their businesses to compete more effectively and make better...
All BI and Analytics White Papers
BI and Analytics Webcasts
Quantifying the Business Value of VMware View - Webcast
Many enterprises have discovered that the use of virtualization to support desktop workloads creates a range of significant benefits. These benefits include price...
Good to Great - How to Take Business Analytics to the Next Level
By attending this webcast you will learn how you can implement an effective BA strategy that will deliver maximum strategic value to your...
Supporting Mobile Productivity With A Limited IT Budget
Join us and hear from Kaseya mobile IT management experts as we discuss core strategies for supporting the mobile revolution on a shoestring...
User Experience Monitoring
In this webinar, you will learn hints & tips for improving end-user response times from Forrester Research analyst, Jean-Pierre Garbani.
Hints & Tips Cisco
Overwhelmed by tracking your Vblock, Flexpod or Cisco UCS performance? Spend one hour with Nimsoft to learn how you can eliminate the overhead...
All BI and Analytics Webcasts
Newsletter Sign-Up

Receive the latest news test, reviews and trends on your favorite technology topics

Choose a newsletter
  1. View all newsletters | Privacy Policy
IT Jobs