Re: Just Curious
Date: Wed, 9 Feb 2011 09:02:46 -0800 (PST)
Message-ID: <566513.82562.qm_at_web120216.mail.ne1.yahoo.com>
I'm newer to Exadata and the folks with more time on the system can correct me if they have experienced differently, but I'm going to disagree with the last statement.
One of the trends I've noted in my last couple years in the industry are more and more "hybrid" databases, aka very, very large OLTP's. As these companies are trying to do more and more transactions on larger and larger sets of data, we have new challenges in the DBA frontier. It's no longer about being an OLAP or an OLTPDBA but a hybrid of both.
Now that I'm working in an Exadataenvironnment, I see the huge benefits to OLAP databases- You want to perform a massive hash join? Great, be my guest, the speeds are amazing when we observe cell smart scans. You want to run that same query off that same join over and over again? Hey, have a storage index- great again!
Now, you want to update numerous different rows on that 1.2 TB table with different where clauses? There's a bigger challenge that I'm not so thrilled when I observe on an Exadata system.
As I see Oracle's Exadata being an excellent choice for the huge OLAP environments and for the smaller databases they can utilize standard Oracle or other platforms, (and I think we should all note they have MySQL now...) I don't see a benefit to putting a massive number of smaller OLTP's or a larger "hybrid" OLTP on an Exadata.
Then again, I'm newer to Exadata- anyone, anyone, Bueller?
Kellyn Pedersen
Multi-Platform Database Administrator
www.pythian.com
http://www.linkedin.com/in/kellynpedersen
www.dbakevlar.com
From: David Aldridge <david_at_david-aldridge.com> To: regdba_at_yahoo.com; Oracle-l <oracle-l_at_freelists.org> Sent: Wed, February 9, 2011 9:05:47 AM
Subject: Re: Just Curious
One of the selling points of Exadata is that you could host those hundreds of apps all on the same box as your data warehouse. Being written exclusively for SQL Server of course is a bit of a snag in that plan.
From: Peter Barnett <regdba_at_yahoo.com> To: Oracle-l <oracle-l_at_freelists.org> Sent: Wed, 9 February, 2011 15:17:14
Subject: Just Curious
Curious question. I have attended two Oracle events recently promoting Exadata. These are high performance, expensive systems.
At the same time we have purchased applications requiring small to mid-sized databases. All are written for SQL Server only.
We only have one data warehouse. We have hundreds of other applications. Is Oracle giving up on the small to mid-size database space? They sure aren't talking about it in their marketing events and I am not seeing apps come in the door written to be either database agnostic or written for Oracle.
Pete Barnett
Database Technologies Lead
Regence
Sucker-punch spam with award-winning protection.
Try the free Yahoo! Mail Beta.
http://advision.webevents.yahoo.com/mailbeta/features_spam.html
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 09 2011 - 11:02:46 CST