Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Call That a Database? This is a Database.

By Phil Factor,

If only the English language had a range of words to describe all the different types of database, there would be so much less confusion in the industry. The Eskimo, we were once told, had sixty words for the different kinds of snow. Actually, it is not the Eskimo but the similarly-arctic Sami People.  I can see how useful it is to the Sami people, especially if they want to describe the weather in the pub. I suspect that the Sami weather forecasts are, in consequence, rich in their descriptive vocabulary, whereas the English-language version is monotonous: "Snow, then Snow, becoming Snowy, followed by more snow". In the same way, IT people have no rich and descriptive way to distinguish between a database for an undergraduate project, a home database for the CD collection or a hard-working commercial OLTP system supporting an entire enterprise.

The NoSQL debate, like the ORM issue, might be much less fractious if we had imaginative words to convey the magnitude, complexity, transaction-rate, and resilience required of the underlying database. Any confusion among application developers who need a database to support over a million concurrent transactions per minute, and want to create it interactively alongside their application, would evaporate, with the hushed phrase…

"…so we’re talking about a MegaTrapmic".

I also want a word for a tiddly little database with something like the complexity of the local office-hero’s spreadsheet (tiddlybase?). I’d like another word for the cody-bopper's object hierarchy (Ormegawd?). How convenient it would be to have something to describe the trivial but enormous pile of poorly structured verbiage now euphemistically referred to as 'Big Data'.

When discussing any database solutions, these things matter, and we don’t have words like Datamoth, Ormegawd, tiddlybase or NOSqueek to aid understanding. Like the Sami People, we database professionals should get together, select those amongst us with a linguistic gift to come up with terms for every category of crime against Codd that we see in our everyday working lives.

At one time in the late eighties, a database generator called DataEase for DOS became popular. It allowed the user to build desktop-based applications with a "tiddlybase" backend. We "Datamoth" people shook our heads and dubbed the resulting atrocity "DataDisEase". The term stuck; just like that we had spawned a new descriptive database category, and one that immediately identified to everyone exactly the sort of database being discussed.

So let’s enrich our professional vocabulary by creating as many rich, descriptive words for the different types of databases as the Sami have for different kinds of snow! 

Total article views: 251 | Views in the last 30 days: 1
 
Related Articles
FORUM

sqlserver 2005 database security different between database role and application role

sqlserver 2005 database security different between database role and application role

ARTICLE

Tuning People?

Database people are used to changing the hardware of the server on which a problem database resides...

BLOG

Sales People & Commission

I saw this post by Neil Davidson about sales people being different that discusses how sales people ...

FORUM

Database Design for Blog application

Database Design for Blog application

ARTICLE

Upgrading the GIS application and database.

In this article I will mention a specific issue that I experienced during my last GIS application an...

Tags
database weekly    
editorial    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones