NCR Sets Multi-User Data Warehouse Performance Standard With First-Ever TPC-R Decision Support Benchmark At One Terabyte
NCR Corporation has announced that it published the industry's first-ever results for the TPC-R data warehouse performance benchmark, which was run at the one terabyte (TB) data volume using NCR's Teradata relational database for active data warehousing. TPC-R is the new decision support benchmark developed by the Transaction Processing Performance Council (TPC) to measure how well data warehouses perform decision support workloads with multiple, concurrent users submitting complex business queries.
The results of this benchmark reaffirm Teradata as the database of choice for high-volume data warehouse environments that require "industrial strength" multi-user query performance and scalability to one terabyte of user data and beyond. With this new benchmark, NCR continues its performance leadership of the past 6 months over both Oracle and IBM in TPC data warehousing benchmarks.
The hardware configuration used for the new one terabyte TPC-R benchmark incorporated Intel's just-released Pentium III Xeon 550 MHz processors. "Intel's new and higher performing Pentium III Xeon 550 MHz processor enables companies such as NCR to help its customers realize enterprise-level scalability and performance as well as reliability and availability - all critical elements in today's data-rich, multi-user, enterprise environments," said Jerry Budelman, General Manager of the Server Component Division for Intel's Enterprise Server Group.
The benchmark was run on a 16-node NCR WorldMark 5200 MPP (massively parallel processing) server that used 64 Pentium III Xeon 550 MHz processors running Teradata V2R3. This configuration also leveraged NCR's new WorldMark Enterprise Storage, an external disk storage product that features the new scalable quad modular disk array from NCR partner, LSI Logic.
"NCR's willingness to be the first vendor to step up to this new, more rigorous decision support benchmark at the Terabyte data volume confirms our leadership position in data warehousing," said Vickie Farrell, assistant vice president of Teradata marketing for NCR.
Continuing its focus on mirroring real-world conditions, NCR is the first vendor to run the one-terabyte, "multiple stream" TPC-R benchmark, simulating multiple users running concurrent business questions. Benchmark results were:
| TPC-R Results | # of Streams |
Composite Queries-per-Hour (QphR@@1000GB) |
Price/ Performance ($/QphR@@1000GB) |
Availability |
| NCR WorldMark/ Teradata |
7 | 17,529.6 | 737 | 2/15/00 |
"Concurrent user support is vital as the number of users accessing data warehouses through corporate Intranets and Web-based portals grows," Farrell stated. "NCR has been well aware of this trend and its importance, and has been the only data warehouse vendor to simulate concurrent users on all TPC decision support benchmarks."
Helping businesses gain new insights, NCR's Teradata provides industry-leading performance with many concurrent users for complex and ad-hoc queries, with superior scalability, availability, and manageability. Teradata provides unlimited scalability from 10 gigabytes to more than 100 terabytes, seamless mainframe connectivity and the lowest administration requirements of any database on the market.
It employs a patented, shared-nothing parallel architecture that can be deployed on both SMP (symmetric multi-processing) and MPP (massively parallel processing) hardware platforms. Teradata runs on UNIX and Windows NT.
NCR Corporation is a recognized world leader in data warehousing solutions, ATMs, point-of-sale, high performance scanners and support services for retail, financial, communications, airlines and insurance markets. NCR's business solutions are built on the foundation of the company's long-established industry knowledge and consulting expertise, value-adding software, global customer support services, a complete line of consumable and media products, and world-leading hardware technology. More information about NCR and its products may be found on the Internet at http://www.ncr.com.