Feeds

The myths and legends of the holy land of the database

The first myth explored and exploded

Intelligent flash storage arrays

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.

Top 5 reasons to deploy VMware with Tegile

Next page: First Myth

More from The Register

next story
Preview redux: Microsoft ships new Windows 10 build with 7,000 changes
Latest bleeding-edge bits borrow Action Center from Windows Phone
Google opens Inbox – email for people too thick to handle email
Print this article out and give it to someone tech-y if you get stuck
Microsoft promises Windows 10 will mean two-factor auth for all
Sneak peek at security features Redmond's baking into new OS
UNIX greybeards threaten Debian fork over systemd plan
'Veteran Unix Admins' fear desktop emphasis is betraying open source
Google+ goes TITSUP. But WHO knew? How long? Anyone ... Hello ...
Wobbly Gmail, Contacts, Calendar on the other hand ...
DEATH by PowerPoint: Microsoft warns of 0-day attack hidden in slides
Might put out patch in update, might chuck it out sooner
Redmond top man Satya Nadella: 'Microsoft LOVES Linux'
Open-source 'love' fairly runneth over at cloud event
prev story

Whitepapers

Choosing cloud Backup services
Demystify how you can address your data protection needs in your small- to medium-sized business and select the best online backup service to meet your needs.
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.
Security for virtualized datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.
Storage capacity and performance optimization at Mizuno USA
Mizuno USA turn to Tegile storage technology to solve both their SAN and backup issues.