On October 29th, 2007, Sun Microsystems announced three new TPC-H performance results that are dramatically better than any previous result. These benchmarks are based on Red Hat Enterprise Linux 4.4 running the ParAccel Analytic Database on a cluster of fifteen SunFire x4100 systems (each configured with two dual-core AMD Opteron processors). The chart above provides a high-level summary of the results, extracted from the TPC-H website. It shows the quantum leap in performance that these results represent.
There are three separate benchmark results, each for a different database size, 100GB, 300GB and 1,000GB. Measured in QphH (Queries/Hour), they all show that the new #1 ranked result is at least four times faster than the #2 result – the previous world-record holder. And the price/performance figures, measured in $/QphH (dollars per Query/Hour) are less than a quarter of the price. Clearly, these results represent a whole new order of performance for TPC-H, which is the industry’s leading decision support benchmark. It is described on the TPC web site as follows:
“It 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 this is a real-world benchmark, and these results demonstrate that customers do not need to use a high-priced, heavyweight, legacy database to run their business. So how were these incredible numbers achieved?
Clearly it was necessary to take a new approach to the problem of high-performance decision support and analytics. A primary feature of the ParAccel Analytic Database is that it is a column-based database, not row-based like Oracle, DB2 and many others. Thus its query optimizers don’t have to read in a full row of data to perform a query. Only relevant columns are retrieved (meanwhile, a row-wise DBMS would pull all columns and typically discard 80-95 percent of them). To further increase performance all operations are done in parallel (a non-parallel DBMS must scan all of the data sequentially). Additionally, adaptive compression reduces disk overhead, while the memory-centric design maximizes in-memory processing.
To minimize costs, Sun decided to use a locally attached 2-disk configuration rather than using a more expensive array-attached storage, such as Fiber Channel or iSCSI. This further improved the price/performance result.
And, as the highest performance platform on which to run these benchmarks, Red Hat Enterprise Linux was, once again, the winner’s choice.
To view TPC benchmark results, visit www.tpc.org.
À propos de l'auteur
Parcourir par canal
Automatisation
Les dernières actualités en matière de plateforme d'automatisation qui couvre la technologie, les équipes et les environnements
Intelligence artificielle
Actualité sur les plateformes qui permettent aux clients d'exécuter des charges de travail d'IA sur tout type d'environnement
Services cloud
En savoir plus sur notre gamme de services cloud gérés
Sécurité
Les dernières actualités sur la façon dont nous réduisons les risques dans tous les environnements et technologies
Edge computing
Actualité sur les plateformes qui simplifient les opérations en périphérie
Infrastructure
Les dernières nouveautés sur la plateforme Linux d'entreprise leader au monde
Applications
À l’intérieur de nos solutions aux défis d’application les plus difficiles
Programmes originaux
Histoires passionnantes de créateurs et de leaders de technologies d'entreprise
Produits
- Red Hat Enterprise Linux
- Red Hat OpenShift
- Red Hat Ansible Automation Platform
- Services cloud
- Voir tous les produits
Outils
- Formation et certification
- Mon compte
- Ressources développeurs
- Assistance client
- Calculateur de valeur Red Hat
- Red Hat Ecosystem Catalog
- Rechercher un partenaire
Essayer, acheter et vendre
Communication
- Contacter le service commercial
- Contactez notre service clientèle
- Contacter le service de formation
- Réseaux sociaux
À propos de Red Hat
Premier éditeur mondial de solutions Open Source pour les entreprises, nous fournissons des technologies Linux, cloud, de conteneurs et Kubernetes. Nous proposons des solutions stables qui aident les entreprises à jongler avec les divers environnements et plateformes, du cœur du datacenter à la périphérie du réseau.
Sélectionner une langue
Red Hat legal and privacy links
- À propos de Red Hat
- Carrières
- Événements
- Bureaux
- Contacter Red Hat
- Lire le blog Red Hat
- Diversité, équité et inclusion
- Cool Stuff Store
- Red Hat Summit