Oracle is pushing Exadata 2 as being a great system for OLTP (OnLine Transaction Processing), data warehousing or, presumably, the integration of same. This claim rests on a few premises, namely:
The integration-versus-separation argument for OLTP and analytic databases is an old one. In the early 1980s, IBM pushed both the "Information Center" (precursor to the data warehouse) and relational DBMS (portrayed as good for query and maybe for OLTP as well). In the early 1990s, Ted Codd opined that relational DBMS were good for OLTP but not analytics, instead favoring "OLAP" systems like Arbor Software's Essbase (which, ironically, is now owned by Oracle). As the 1990s progressed, a consensus emerged that most large* enterprises should have at least one relational data warehouse separate from the core OLTP DBMS, a view that has persisted to this day. Until the announcement of Exadata 2, Oracle hadn't seriously disputed this consensus, although of course it always has wanted its DBMS software to run your OLTP and analytic databases alike.
*At a sufficiently small enterprise, one DBMS suffices. If a single commodity server has enough power to do all your processing, without even requiring you to have the expertise to tune very seriously, that's probably the right way to go.
Assuming one DBMS has plenty of functionality for OLTP and analytics alike -- as Oracle certainly does -- the main arguments for separating OLTP and data warehousing revolve around performance. Reasons to split out a separate analytic database include:
*If this weren't a terribly difficult problem, Oracle, IBM, and/or Teradata -- all of which can do a reasonably decent job of mixing long and short queries in the same workload -- would probably have solved it years ago.
Bottom line: Some day, Oracle Exadata may be a great system for integrated OLTP and data warehousing -- but probably not in the current release.Oracle is pushing Exadata 2 as a great system for OLTP (OnLine Transaction Processing), data warehousing or both. This claim rests on a few premises, the first being that Exadata is great for data warehousing. At this time, that's a claim much better supported by marketing and theory than by practice...