Feeds

MySQL moves forward

But what about XML?

  • alert
  • submit to reddit

Internet Security Threat Report 2014

In case you missed it, MySQL held its first user conference just before Easter, writes Phil Howard, of Bloor Research. MySQL is, of course, the developer of the eponymous Open Source relational database.

How significant is MySQL? Well, it depends how you read the figures. According to the company, 29,000 copies of the database are downloaded every day and there are 4 million installations worldwide. However, most of these will be just "suck it and see" users.

More useful would be a figure for the number of users paying support fees. Not that MySQL is limited to the traditional Open Source model of free downloads and support charging: it also sells the software directly to other software vendors. Hyperion, for example, uses the product as an embedded database.

So, the jury is still out on the significance of MySQL. One reasons for this was made apparent at the user conference, where the company announced that a "pre-alpha" (whatever that is) version of its next release (5.0) ia now available for download. However, it was the features of the new release that stood out: the product will now support foreign keys, stored procedures and database alerts.

The fact that these features will be in the next release explains why I have not previously taken more than a passing interest in the product: with the omission of these capabilities it simply was not suitable for use at the enterprise level, though their inclusion does not prove its suitability either. In any case I will be taking a more detailed look at the product in the next couple of months.

One thing that MySQL will not be including is XML support. In an interview with InfoWorld, Marten Mickos, the company's CEO, is reported as saying that "if XML in the database becomes mainstream, we will do it. My personal view is that the relational model is about as complicated as it can get before it gets too complicated".

I agree. In fact I would go further: I think the relational model has been extended beyond its natural limits. The corollary to this is that from a technical perspective it makes much more sense to use, say, Software AG's Tamino as an XML database that sits side by side with your relational database, than it does to try and cram this quart into a relational pint pot.

However, the market doesn't work that way. The market works on the basis of perception and it listens to the stories that the 800lb gorillas tell. And the stories these vendors are telling is that you can implement XML in the database, that the overhead of mapping between XML structures and relational tables can be minimised if not totally reduced, and we have even got relational database vendors implementing hierarchical structures for XML indexing.

My God, hierarchies! This has been anathema in the rdbms market since it finally overcame the forces of darkness (that is, hierarchical and navigational databases) more than a decade ago. That is a measure of just how important XML is to the relational vendors.

The bottom line is that I think Marten has got this one wrong, even if he is right.

© IT-Analysis.com

Beginner's guide to SSL certificates

More from The Register

next story
Docker's app containers are coming to Windows Server, says Microsoft
MS chases app deployment speeds already enjoyed by Linux devs
'Hmm, why CAN'T I run a water pipe through that rack of media servers?'
Leaving Las Vegas for Armenia kludging and Dubai dune bashing
'Urika': Cray unveils new 1,500-core big data crunching monster
6TB of DRAM, 38TB of SSD flash and 120TB of disk storage
Facebook slurps 'paste sites' for STOLEN passwords, sprinkles on hash and salt
Zuck's ad empire DOESN'T see details in plain text. Phew!
SDI wars: WTF is software defined infrastructure?
This time we play for ALL the marbles
Windows 10: Forget Cloudobile, put Security and Privacy First
But - dammit - It would be insane to say 'don't collect, because NSA'
Oracle hires former SAP exec for cloudy push
'We know Larry said cloud was gibberish, and insane, and idiotic, but...'
Symantec backs out of Backup Exec: Plans to can appliance in Jan
Will still provide support to existing customers
prev story

Whitepapers

Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
Why cloud backup?
Combining the latest advancements in disk-based backup with secure, integrated, cloud technologies offer organizations fast and assured recovery of their critical enterprise data.
Win a year’s supply of chocolate
There is no techie angle to this competition so we're not going to pretend there is, but everyone loves chocolate so who cares.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?
Intelligent flash storage arrays
Tegile Intelligent Storage Arrays with IntelliFlash helps IT boost storage utilization and effciency while delivering unmatched storage savings and performance.