(Cringely had another post about Sun/Oracle, which needed reply. Since I don't expect that readers there are readers here, I am providing.)
If you read Gartner, and I only see the PR condensed version, DB2 off-mainframe is falling behind every year since 2000. I, and others, speculated that the reason IBM wanted MySql in the first place was to spruce it up, and call it DB2. What those who’ve never been in a DB2 shop don’t understand is that most DB2 installs on are z/OS, and most of those are running 1970 era COBOL code. In such cases, very little of Relational is ever utilized. MySql as simple sql parser in front of the file system is just all that a COBOL (or java) coder needs. MySql == DB2. That was the plan. Now IBM needs Plan B.
I suspect a bit of whistling past the graveyard in that leaked (horrors, how did that get out!!!!!!!!!!!) email. 750 Power customers? This is a big deal? Those are mainframe numbers. Oracle needed, and now has, a weapon to finally kill DB2 off-mainframe. Like it or not, the Intel multi-core/processor machine is ascendant. The off-mainframe database is where the future lies. IBM cannot possibly want a future of being just another Intel OEM, with customers running Open Source software on same. There is no future there. Oracle has built up a portfolio of software for which there is no easy Open Source alternative.
Remember: Oracle is a MVCC architecture database. DB2 is a locker. SQLServer was a pure locker, and has added MVCC (sorta, kinda) in 2008. Postgres is MVCC and Open Source. This architecture difference is not trivial. Why IBM chose to port IMS to DB2, calling it pureXML, is impossible to fathom. It was not a value add for customers in a web environment. The MVCC architecture is widely agreed to be superior there. IBM has to believe, why I cannot fathom again, that its mainframe machine will dominate the future. Its database off-mainframe is not going to.
Finally, IBM had a compliant bitch in Sun vis-a-vis java. That won’t be the case with Larry.
IFF AI, as currently implemented, can intuit Special Relativity from just a clock tower and a moving tram will I take AI seriously.
Infinite granularity yields infinite complexity.
The Kleptocracy of Trumpistan Welcomes You
The world is not linear.
-- Dr. McElhone/1974
Well, I'm going to do it, whether the women like it or not. I'm going to protect them.
-- The Orange Shitgibbon©anon./2024 [y'all get burkhas]
Scientists aren't vocal enough about science. There are large groups of people who think scientists are all frauds and who don't
believe in science, and they're being cultured by some of our far right-wing politicians, religious leaders and community leaders. -- Dr. McElhone/1974
Well, I'm going to do it, whether the women like it or not. I'm going to protect them.
-- The Orange Shitgibbon©anon./2024 [y'all get burkhas]
-- Drew Weissman/2022
To date, Microsoft is stating that organizations testing In-Memory OLTP have
seen transaction speeds improve by up to 30 times compared to past
performance, with the best performance gains achieved when the business
logic resides in the database and not in the applications.
-- Jonathan Watts/2015 [my emphasis]
-- Jonathan Watts/2015 [my emphasis]
I have had to explain and re-explain and re-explain and re-explain, you know, how relational databases work, what is an eigenvector,
what is dimensionality reduction.
-- Christopher Wylie/2018
... but Flash-based storage has such a different performance profile from rotating media, that I suspect that it will end up having
a large impact on filesystem design. Right now, most filesystems tend to be designed with the latencies of rotating media in mind.
-- Linus Torvalds/2007
-- Chris Date/2009
This Week's thought
Counties with the biggest Democratic victories in 2020 delivered 1.9 million fewer votes for Ms. Harris than they had for Mr. Biden. The nation's most Republican-heavy counties turned out an additional 1.2 million votes for Mr. Trump this year -- Michael C. Bender/2024 [pussies; but what I suspected]
See you next week in a brand new show©Heckle and Jeckle
In a time of SSD, multi-core/processor, two terabyte memory and Optane App Direct Mode machines, there is no reason not to
build from BCNF data. Time to do what Dr. Codd demonstrated. Technology has finally caught up with the maths.
About
- Robert Young
- Been doing databases, both relational and others, as well as operations research since Hector was a Pup.
Shameless Plug
I know a little something about SQL, DB2 (preferably LUW, z/OS if the money's right), Oracle, SQL Server, Postgres, and database design in general. Mentoring/teaching/consulting on a short term basis, too. And a bit of stat analysis if it's R.
gnuoytr at rcn dot com.
gnuoytr at rcn dot com.
4 comments:
You are so wrong on so many levels. This post is a speculation of IBM intent or supposedly reasoning that went on at various times and they are ALL off the mark. Take it from someone who is in the know and does not need to speculate.
There are many points in my posts. Now, a year later, I've seen no data to contradict. Which ones do you have data to refute? Or do you simply have an opinion?
DB2 continues to "grow" on z machines, but not so much on servers. Gartner has stopped posting a PR version of the survey, but I've read nothing from other sources to demonstrate that UDB has reversed trend and growing market. Can you cite a public source that is similar to Gartner for the years 2008 - 2010? IDC, maybe, although I couldn't find it. If you're just going to say that IBM says the server business is growing by leaps and bounds, Nah.
It's been a year or so, but it is a fact that IBM's claims for share growth were based on mainframe "ports" of Olde COBOL/VSAM dumped (rather than normalized) into DB2. Gartner, and others, saw that in the data, and said so. It was the case where I worked, and the IBM folks I talked to admitted it. They frequently laughed at the "schemas" these Fortune X00 knuckleheads used.
The Oracle/Sun merger is working out as I predicted. The software folk from Sun are being jettisoned, and the database is being pushed into mainframe class machines. Sun is pushing SSD storage, while IBM is not. SSD storage, as you will understand if you read here and elsewhere, will re-invigorate the Relational Model and BCNF schemas. You can take that to the bank. Getting rid of those hidebound VSAM folk will aid the cause.
The MVCC issue is as I predicted. After squandering years and dollars on xml (read: IMS revenge) in DB2, there is now "Oracle" compatibility being promoted. The MVCC approaches (including logging file systems) are gaining momentum elsewhere. SSD is one factor in this.
Is the Power machine still anything more than a niche product? No, it is still a niche product. Better question: how long will the z machine be an architecture? My bet, in a couple of years it'll be emulated on commodity microprocessors. May be Power, may be Intel. BCD instructions are moving into said processors. Once they're reasonably optimized, the z architecture no longer has any distinct value. COBOL doesn't care, so long as BCD is in hardware.
And the really meaningful point, which I forgot in all the hubbub, is that in the last 2 years (about as far back as my short term memory) I've not seen a DB2 position listing that didn't say:
DB2 with COBOL, JCL, and DCLGEN
and the like. Not once have I seen a listing that said DB2 LUW/UDB. You'll find others saying the same on comp.databases.ibm-db2. IF LUW/UDB were a growing platform, clients would be fighting to find people as I. They aren't. The last place I worked for almost a decade, used LUW/UDB only when I (or the client) refused to put up with Green Screen silliness. At that place, SQL Server was the preferred alternative; but then, as most Fortune X00 companies, they still bought into Windoze.
Be careful what you wish for, you just might get it.
http://www.oracle.com/us/products/database/number-one-database-069037.html
IBM still hasn't, that I can find, shown its results from Gartner since they stopped PR-ing the report. No news is bad news.
So, the game continues; DB2 "grows" by displacing VSAM. There is money in doing so, I suppose. How much comes down to the difference in license fees, which I'm not privy to.
Post a Comment