Feeds

The myths and legends of the holy land of the database

The first myth explored and exploded

Security for virtualized datacentres

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.

Intelligent flash storage arrays

Next page: First Myth

More from The Register

next story
PEAK APPLE: iOS 8 is least popular Cupertino mobile OS in all of HUMAN HISTORY
'Nerd release' finally staggers past 50 per cent adoption
Microsoft to bake Skype into IE, without plugins
Redmond thinks the Object Real-Time Communications API for WebRTC is ready to roll
Microsoft promises Windows 10 will mean two-factor auth for all
Sneak peek at security features Redmond's baking into new OS
Mozilla: Spidermonkey ATE Apple's JavaScriptCore, THRASHED Google V8
Moz man claims the win on rivals' own benchmarks
FTDI yanks chip-bricking driver from Windows Update, vows to fight on
Next driver to battle fake chips with 'non-invasive' methods
DEATH by PowerPoint: Microsoft warns of 0-day attack hidden in slides
Might put out patch in update, might chuck it out sooner
Ubuntu 14.10 tries pulling a Steve Ballmer on cloudy offerings
Oi, Windows, centOS and openSUSE – behave, we're all friends here
Was ist das? Eine neue Suse Linux Enterprise? Ausgezeichnet!
Version 12 first major-number Suse release since 2009
prev story

Whitepapers

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.
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.
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?
New hybrid storage solutions
Tackling data challenges through emerging hybrid storage solutions that enable optimum database performance whilst managing costs and increasingly large data stores.
Getting ahead of the compliance curve
Learn about new services that make it easy to discover and manage certificates across the enterprise and how to get ahead of the compliance curve.