Feeds

The myths and legends of the holy land of the database

The first myth explored and exploded

Boost IT visibility and business value

The database world has more myths and legends than the court of King Arthur. The current myths tend to be less about dragons and dungeons and more about features and performance, such as:

  • Oracle can't do MOLAP.
  • Oracle is as easy to tune as a cathedral organ.
  • DB2 only runs on mainframes.
  • SQL Server doesn't scale.
  • Oracle is eye-wateringly expensive.
  • Access isn't a relational database.
  • SQL Server cannot row lock.

Although, sometimes there is more than a hint of scandal:

  • Microsoft was caught stealing secrets from Borland.
  • Oracle was caught cheating at the TPC benchmarks.
  • Philippe Kahn once bought Hawaiian shirts for 3,000 database conference delegates just to annoy Microsoft.

These myths tend to surface whenever database people meet - either virtually, in the news groups, or socially, in their cups.

Where do these myths originate?

Well, this is a very competitive industry and the truth is that some of them are simply made up by competitors. I know, I happen to have been there at the birth of two of those listed above. Of course, I would never suggest that this fabrication can ever be laid at the door of the CEOs involved - I'm sure that the very smooth Larry Ellison has never been personally responsible for any of these urbane myths...

Once started, these myths are perpetuated because database people are notoriously proud of, and defensive about, their database engine. They are delighted to repeat stories that denigrate the opposition, and so the myths grow.

So, do these myths have any basis is reality or are they all just dragon food? Well, one definition of a myth is "a popular belief that is false or unsupported by facts", another is "a truth disguised and distorted", and those fit pretty well with our myths. Some are provably false, other have some basis in fact. Oddly, some, like the SQL Server row locking one, were at the same time both completely true and totally misleading.

In this series of articles we are going to look at these widely-held beliefs (all of those listed above and more) and try to separate the truth from the misinformation. Unlike Sir Robert Armstrong we will try to be uneconomical with the truth.

Build a business case: developing custom apps

Next page: First Myth

More from The Register

next story
KDE releases ice-cream coloured Plasma 5 just in time for summer
Melty but refreshing - popular rival to Mint's Cinnamon's still a work in progress
Leaked Windows Phone 8.1 Update specs tease details of Nokia's next mobes
New screen sizes, dual SIMs, voice over LTE, and more
Mozilla keeps its Beard, hopes anti-gay marriage troubles are now over
Plenty on new CEO's todo list – starting with Firefox's slipping grasp
Apple: We'll unleash OS X Yosemite beta on the MASSES on 24 July
Starting today, regular fanbois will be guinea pigs, it tells Reg
Another day, another Firefox: Version 31 is upon us ALREADY
Web devs, Mozilla really wants you to like this one
Secure microkernel that uses maths to be 'bug free' goes open source
Hacker-repelling, drone-protecting code will soon be yours to tweak as you see fit
Cloudy CoreOS Linux distro declares itself production-ready
Lightweight, container-happy Linux gets first Stable release
prev story

Whitepapers

Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Boost IT visibility and business value
How building a great service catalog relieves pressure points and demonstrates the value of IT service management.
Why and how to choose the right cloud vendor
The benefits of cloud-based storage in your processes. Eliminate onsite, disk-based backup and archiving in favor of cloud-based data protection.
The Essential Guide to IT Transformation
ServiceNow discusses three IT transformations that can help CIO's automate IT services to transform IT and the enterprise.
Maximize storage efficiency across the enterprise
The HP StoreOnce backup solution offers highly flexible, centrally managed, and highly efficient data protection for any enterprise.