Sunday, January 28, 2007

For Whom the Bell Tolls?

This is one of my favorite songs all time, great solo and lyrics. So after 30 years in this world I experienced that a rumour may harm you bad, especially if you don't answer it satisfactory. I am an "Oracle Minded" database developer/dba for sure, so if anyone does not, of course I will stand for what I believe in most!

I challenge anyone, on any platform Data warehousing on Oracle10g Release 2 will NOT that easily go down! In my right hand I will hold the documentation, in my left hand I will have my experts with me and be sure of that this crazy Turk will stand until the last drop of his blood :)

I will be waiting for an offer, I am ready to work for FREE in an objective benchmark project if someone is interested?

Just for the starters, lets check this decision support benchmark; TPC Benchmark™H (TPC-H). It is explained as; "TPC-H consists of a suite of business oriented ad-hoc queries and concurrent data modifications. The queries and the data populating the database have been chosen to have broad industry-wide relevance. This benchmark illustrates decision support systems that examine large volumes of data, execute queries with a high degree of complexity, and give answers to critical business questions." So I sorted the results by "$/QphH@Size" which is TPC-H Price/Performance metric and over 3TB there is NO sign of any IQ or EQ, whatever;

Complete TPC-H Results List - Sorted by QphH.doc

Some will laugh these lines, after all Oracle is NOT something designed specially for DW and mentioned competitor is NOT a traditional RDBMS, their engine is said to be dedicated for DW so as a result ad-hoc query performance goes up to X times faster than us. Hmm, step back brother, what you bet is what I already trust in most! Oracle 10gR2 has its unique performance toolbox: analytic functions, model clause, ASM, ASSM etc. but what about the high availability of a mission-critical system? Who will care about the performance of a system which is not available, your customers? Or your managers?

I hope to meet you :)

1 comment:

Tonguç said...

Reference on default dirty read behavior of IQ -
http://www.freelists.org/archives/oracle-l/10-2007/msg00434.html