Consolidating Relational Databases
August 6, 2002
In these days of constant mergers and acquisitions, it's quite common for companies to find themselves operating two or more mission-critical relational databases. Though you struggle along running these database management systems (DBMS) side by side, it ties up IT time, adds unnecessary expense and slows down standard reporting functions. But which database to chose?
This article discusses the options, taking the stance that IBM's DB2 family of products (DB2 for OS/390 and Universal Database for UNIX and Windows NT) probably offers the most advantages. It also gives an example of how data centers leverage the advantages of both manual code re-engineering and automated conversion when moving from SQL Server, Sybase or Oracle 9i to DB2 UDB without impacting the business or losing application functionality.
Last year alone, the database market grew 10% to $8.8 billion, and Gartner Group estimates it will reach $12.7 billion within two years. It appears that despite the state of the economy, the corporate world has come to realize that the pain of remaining on aging or disparate systems and databases is far greater than the cost and inconvenience of migration.
This mushrooming database marketplace means that companies are being forced to confront various options in terms of database consolidation, merger and standardization. Selection, of course, is based on a wide range of factors including size of the operation, transaction volume, importance to business survival, existing environment, costs, personal preferences as well as a host of other considerations.
The sketchy overview given here does not pretend to encompass all possible scenarios. Bear in mind that it is based on a combination of personal opinion and analyst feedback. For every analyst quoted here favoring IBM, there are probably two or three who side with Microsoft or Oracle.
So here goes:
SQL Server and Sybase tend to be best as small and mid-range DBMS', but they generally scale less well in the enterprise. They do not typically include the extended relational and object-oriented features that are now common amongst their rivals. Further, due to some Java-based driver problems they may have some limitations in a Web-based traffic intensive environment.
When it comes to high-end enterprise-class databases, the two principal contenders are Oracle 9i and DB2 UDB. Though both sides hotly contest superiority, IBM appears to have the edge, at least for the moment.
According to research firm D.H. Brown Associates Inc., Oracle 9i loses out to IBM's DB2 UDB in its installation routine, query optimization, architecture for distributed database, and query governance. On average, DB2 UDB efficiencies yield an overall reduction in work effort of 6% for OLTP systems, 15% for large OLTP systems, 20% for Internet enabled databases, and 18% for data warehousing.
"DB2 UDB provides TCO advantages, saving the customer 20%-32% compared to Oracle," said D.H. Brown.
DB2, for example, holds a strong price advantage over Oracle for scenarios where the DBMS will be accessed from an external Internet. Further, DB2 leads when configurations support 25 or more named users per CPU. According to D.H. Brown, DB2 is half the price of Oracle on systems configured with 50 named users or more per CPU.
These findings are supported by a recent study by the International Technology Group: Five-year software costs on average are 1.72 times higher for Oracle than for DB2. If differences in personnel cost are included, Oracle's costs are 2.25 times higher. For Windows servers, Oracle software costs 89.8% of DB2 while overall costs are 1.77 times higher.
Richard Yevich, principal at Yevich, Lawson & Associates, agrees. He claims that Oracle 9i demands far more tuning than DB2.
"In DB2 applications, only 7% of the medium and complex queries require further tuning as compared to 62% for Oracle," he says. "The main reason Oracle is not used for very large databases is that its shared disk architecture is not suitable for scalability in the terabyte range."