Re: Just Curious
- From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
- To: david@xxxxxxxxxxxxxxxxxx, regdba@xxxxxxxxx, Oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 9 Feb 2011 09:02:46 -0800 (PST)
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@xxxxxxxxxxxxxxxxxx>
To: regdba@xxxxxxxxx; Oracle-l <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxx>
To: Oracle-l <oracle-l@xxxxxxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
