A new world record for database performance in very large data warehousing applications was recorded on an Oracle database this week.
The record, set using the new Oracle 10g database interrogating 1 000GB (1TB) of data, ran on a Fujitsu PRIMEPOWER 2500 server with 64 SPARC64 processors and the Solaris 9 operating system.
The Oracle Database 10g system achieved a record-breaking 34 492,5 QphH@1000GB at a price performance ratio of (EUR)156/QphH@1000GB. Oracle Database 10g outperformed the best TPC-H benchmark, one terabyte results from IBM DB2 by 54% and delivered more than six times better performance than Microsoft SQL Server.
"With data volume and complexity on the rise, it has become increasingly important for customers to deploy data warehouse solutions that can accommodate growth and rapid return on investment," said Mohammed Cassoojee, Oracle South Africa`s e-advisor on database products.
"Oracle Database 10g includes new automated management features that further Oracle`s reputation for providing the best database software available at lower total costs of ownership than competing databases," he said.
Share
Oracle Database 10g is designed to be effectively deployed on everything from small servers to the biggest SMP servers and from clusters to enterprise grids. It features automated tuning and management capabilities that make it easy and cost-effective to operate. Its unique ability to natively manage all your data from traditional business information to OLAP, to XML documents, to spatial/location information make it the ideal choice to power online transaction processing, business intelligence, data warehousing and content management applications.
TPC-H
TPC-H is a decision support benchmark comprising a suite of business-oriented ad hoc queries and concurrent data modifications. The performance metric is called the TPC-H Composite Query-per-Hour Performance Metric (QphH@Size) and reflects multiple aspects of the capability of the system to process queries. More information is available at http://www.tpc.org.
Oracle
Oracle is the world`s largest enterprise software company. For more information about Oracle, visit http://www.oracle.com.