MySQL/IBM — will everybody please calm down?
Reuters wrote a really stupid article on the MySQL/IBM deal, and some bloggers have gotten over-excited as well. Even the not-ignorant among these seem to be overlooking one or more of the following points:
- The IBM/MySQL deal is just for the iSeries.
- The iSeries is the successor to the AS/400 and System 38, and thus is in a decades-old family of machines that have some weirdnesses in their DBMS support.
- In particular, DB2 on the iSeries isn’t the same thing as DB2 on other boxes, although multiple DB2s do at least nominally run there.
So while it’s interesting and nice, this deal isn’t that relevant to IBM’s mainstream software business at all.
By the way, if you’ve forgotten the history, the story went like this. The AS/400 had a very interesting operating system, remarkably easy to administer, with pretty good file/database management capabilities integrated in. On the other hand, it took a long time for the machine to get a C compiler, and hence a long time for state-of-the-art RDBMS to be ported over.
Bottom line: Unless you’re involved with the iSeries, the IBM/MySQL partnership is no big deal.
Want to continue getting great research about DBMS, analytics, and other technologies related to data management? Then subscribe to our feed, by RSS/Atom or e-mail! We recommend taking the integrated feed for all our blogs, but blog-specific ones are also easily available.
May 5th, 2007 at 12:54 am
[…] just going ahead and skipping that step. The note is about IBM’s mid-range flavor of DB2, targeted directly at MySQL. Today, IBM announced that its popular DB2 9 Express-C software is now available with an optional […]
May 19th, 2007 at 12:22 pm
The IBM System/38 was the first commercially available system with a fully relational database built in.
Your comment about having to wait for a C compiler to port an RDBMS to the AS/400 is equally absurd; OS/400 had DB2 integrated and built-in since DAY ONE.
And your suggestion that the AS/400 database has some “wierdness” is also misleading. While it may not have always stayed in “lock step” with DB2 on other supported platforms, it has usually been the first DB2 to support many important features. Admittedly the System/38 and early AS/400 used a non-standard Data Definition Specifications (DDS) to define database tables, but support for SQL DDL has been available since the early ’90s (OS/400 V2 timeframe). In 1994 when V3R1 became available, IBM added support for referential integrity constraints and triggers.
DB2/400 UDB now supports more ANSI SQL DML and DDL standards than Oracle or Microsoft SQL Server (or any other commercially available DBMS), > 99% of the SQL standards, while Microsoft and Oracle support
May 19th, 2007 at 11:47 pm
I’ll confess to conflating a couple of issues in error. One is the properties of IBM’s built-in data management systems; the other is the lack of third-party RDBMS support.
The AS/400 is a pretty successful platform, but still very little third party system software runs on it, or sells well if it does.
The lack of Oracle et al. on the AS/400 had a HUGE amount to do with the lack of a C compiler.
As for your claims about a “fully relational” database management system from Day 1 — which definition of “fully relational” are you using? While I’m aware of a number of such definitions (some of them with partisans who believe they have the One True Definitions, others favored by more tolerant people), off the top of my head I can’t think of any that makes your claim true.