Thursday, February 28, 2013

Site Update



1.
The Quote of the Week was posted on the QUOTES page.

2.
A 'To Laugh or Cry item was posted on the LAUGH/CRY page. I usually prefer recent items, but once in a while I come across old ones that I just cannot resist.This is one is from 2003 and thingd have gotten worse.

3.
The link to my latest All Analytics column was posted on the FP ONLINE page.

4.
Links to online exchanges I participated in were posted on the FP ONLINE page.Here's a comment from one:
From my experience, that traditional model has changed as data warehouses are being driven to near real time business intelligence and used as a common repository for disparate systems. The separation between front line systems and data warehouses was due to software and hardware demands could not handle a mixed work load, minimizing costs, plus application products requiring different data stores. The world has moved on. There are DBMS's that can handle mixed work loads with enormous scalability. Application products are becoming broader in business features. Pricing models have changed.
So the whole idea of a distinction between operational databases and data warehouses significant enough to require distinct database technologies, let alone deviations from the relational model, has not exactly held water, has it? Which was pretty predictable.

5.
Roy Hann has posted a comment on my article on SQL redundancy: Fabian Pascal on Ingres

6.
An  old blog post that links to a page on my old site no longer available, so I don't know what the subject was, but something that makes sense, for a change:  How do we tell truths that might hurt

7.
An interesting read on renting software: You Will Subscribe To, Not Buy Software. Worth reading for some of the negatives of the Cloud which, as is usually the case, are disregarded when a fad is being pushed to extremes.



Sunday, February 24, 2013

Language Redundancy and DBMS Performance: A SQL Story



Recently I came across SQL: The way you write your query matters by Iggy Fernandez that refers to an old article of mine in which I compared the performance of five PC DBMSs executing seven different syntactic SQL formulations of the same query. I got wildly different timings, ranging from 15 seconds to 2500 seconds!

Wednesday, February 20, 2013

Site Update



1.
The Quote of the Week was posted on the QUOTES page.

2.
I guess referring this guy to temporal databases and 6NF will not help much, wouldn't you say?

3.
A 'To Laugh or Cry item was posted on the LAUGH/CRY page. Check out my last comment in the thread.

4.
A link to an exchange I participated in was posted on the FP ONLINE page.


Sunday, February 17, 2013

Forward to the Past: Application-Managed Data Not a Distributed DBMS Make



Sima Ilic: This may be a little unusual ask, but I'd be interested to hear you opinion on Google's evolution of distributed databases use/development: from Megastore to Bigtable to Spanner.

I know that there may be only a handful of companies that need (or have resources to use/develop) such things: Google, Amazon, Facebook? Unfortunately, people talk about it like it's the end of relational DBMS (which is plain nonsense) or the next thing that everybody should be looking at or using (the only word that comes to mind is false, but it's not strong enough for marketing/sales people).

Let me tell you what prompted the question.

Thursday, February 14, 2013

New Normalization Paper Available



Pls see the PAPERS page for the new version, when it becomes available.

Site Update



1.
I will give the keynote address at the Northern California Oracle UG spring conference on Wednesday, May 22 at the CarrAmerica conference center in Pleasanton. I will also present one of my "To Laugh or Cry?" sessions. Full details forthcoming on the SCHEDULE page.

2.
The decision whether to link to a debunked article or not is a difficult one. On my old site I did not. On this site I've reversed the policy, but I have not been comfortable with it. Given that currently googling a title is a very simple and efficient way to find the item, I decided to list the title, but opt for selective linking based on the following criteria:
  • the overall substance must be over a certain threshold
  • not all the content is quoted in my debunking
The new policy was applied first to the last post.

3.
The Quote of the Week was posted on the QUOTES page.

4.
I came across Much Ado About Nothing that does a good job of demonstrating why I consider Hugh Darwen' proposed solution less practical than mine in The Final NULL in the Coffin. In particular, my solution relies entirely on the DBMS, not on users.

5.
A link to a To Laugh or Cry? item was posted on LAUGH/CRY? page.

6.
Links to several exchanges I participated in were posted on the FP ONLINE page.

7.
I am extremely wary of the so very liberal use of the term Data Architect, the inflation of positions so titled and of the professionals who present themselves as such. Do you know of any architect who designs the building, does the engineering blueprints and serves as building contractor?


Sunday, February 10, 2013

Those Who Don't Know the Past ...



It's been long my contention that a core problem of the database management field is poor foundation knowledge, in which I include familiarity with its history. Consider The Rise and Fall of the Third Normal Form. The title signals a rich debunking target. John D. Cook writes:
The ideas for relational databases were worked out in the 1970’s and the first commercial implementations appeared around 1980. By the 1990’s relational databases were the dominant way to store data. There were some non-relational databases in use, but these were not popular. Hierarchical databases seemed quaint, clinging to pre-relational approaches that had been deemed inferior by the march of progress. Object databases just seemed weird.

View My Stats