Feeds

MySQL moves forward

But what about XML?

  • alert
  • submit to reddit

Top 5 reasons to deploy VMware with Tegile

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

Top 5 reasons to deploy VMware with Tegile

More from The Register

next story
NSA SOURCE CODE LEAK: Information slurp tools to appear online
Now you can run your own intelligence agency
Azure TITSUP caused by INFINITE LOOP
Fat fingered geo-block kept Aussies in the dark
NASA launches new climate model at SC14
75 days of supercomputing later ...
Yahoo! blames! MONSTER! email! OUTAGE! on! CUT! CABLE! bungle!
Weekend woe for BT as telco struggles to restore service
Cloud unicorns are extinct so DiData cloud mess was YOUR fault
Applications need to be built to handle TITSUP incidents
BOFH: WHERE did this 'fax-enabled' printer UPGRADE come from?
Don't worry about that cable, it's part of the config
Stop the IoT revolution! We need to figure out packet sizes first
Researchers test 802.15.4 and find we know nuh-think! about large scale sensor network ops
SanDisk vows: We'll have a 16TB SSD WHOPPER by 2016
Flash WORM has a serious use for archived photos and videos
Astro-boffins start opening universe simulation data
Got a supercomputer? Want to simulate a universe? Here you go
prev story

Whitepapers

Designing and building an open ITOA architecture
Learn about a new IT data taxonomy defined by the four data sources of IT visibility: wire, machine, agent, and synthetic data sets.
5 critical considerations for enterprise cloud backup
Key considerations when evaluating cloud backup solutions to ensure adequate protection security and availability of enterprise data.
Getting started with customer-focused identity management
Learn why identity is a fundamental requirement to digital growth, and how without it there is no way to identify and engage customers in a meaningful way.
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?
Protecting against web application threats using SSL
SSL encryption can protect server‐to‐server communications, client devices, cloud resources, and other endpoints in order to help prevent the risk of data loss and losing customer trust.