TPC-E will replace TPC-C to become the choice factor of high-end database system (1)

Only by knowing your knowledge can you be able to do it with ease. For server vendors, how can they understand the performance of their products, and how to rationally explain to users how their own servers and even the optimized hardware and software system can achieve relatively high performance, the most intuitive consideration is Benchmark, a Benchmark for the server industry standard. Among them, the most common and most popular benchmarks in the industry are TPC and SPEC.

The SPEC test is used to comprehensively measure the performance of Java Enterprise Application Servers in Web applications. The TPC test system focuses on online processing and database query capabilities. If SPEC testing is for server hardware, TPC testing is for a whole set of systems, which reflects the solution development and optimization capabilities of server vendors in key high-end fields. Therefore, for the entire system selected by high-end users, TPC testing is undoubtedly more valuable for reference.

Say goodbye to rich games"

TPC-E testing is the latest test benchmark launched by TPC in last March, and is also the highest enthusiasm for server field manufacturers to participate in the test benchmark. Understanding TPC-E, you also need to first get familiar with the pre-generation benchmark that will gradually replace it-a 14-year-old TPC-C that targets OLTP online transaction processing) testing models.

TPC-C is one of the most popular benchmark in the industry, but it is also one of the most criticized benchmarks. The TPC-C test simulates the complex OLTP application environment, the model is the wholesaler's system order processing, its operation environment is composed of a series of warehouses, each warehouse has several terminals, representative of the sales site and query site, the TPC-C Test System to execute three types of front-end transactions and two types of back-end transaction processing, two benchmark indicators are provided: Performance Indicators tpmC and cost-effective indicators USD/tpmC.

Because the TPC-C simulates the OLTP application in a realistic manner, it is gradually recognized by the majority of users after the release. The number of users who use tpmC as the basis of their computer system performance evaluation system has increased year by year. However, the disadvantages are gradually exposed, in 14 years, B2B, B2C and other new applications have gradually emerged, the existing TPC-C Warehouse Management System test model is more and more far from the current OLTP user application model, five types of transactions are insufficient to cover your existing typical operations. The question is that in pursuit of high scores, server manufacturers have to increase a large number of disks in the tuning method. The sharp rise in hardware costs puts a lot of pressure on the manufacturers. Millions of dollars are not involved by every server provider in terms of economic strength, and the reference value for users is getting smaller and smaller. Therefore, they are rated as "rich Games ".

The advent of TPC-E has changed this situation, the enthusiasm of manufacturers to participate in the rise. According to Qiao Xin, Technical Manager of inspur server solution, the cost of TPC testing is composed of two parts, one of which is the fixed cost assigned to the TPC organization and its review institutions, the other part is the hardware cost of the test. There is no difference in fixed costs. The difference lies in the savings in hardware costs. Rough calculation: The hardware investment for TPC-E testing is about 1/3 of that for TPC-C Testing hardware. "The first few in the TPC-C rankings all need more than 6000 hard disks, and we currently submit the TPC-E test only needs a few hundred disks is enough ." Another reason is that TPC will provide software source code instead of requiring testers to write their own code.

So, how much is the value of the TPC-E test model to the actual business? Qiao Xin said, The TPC-E in the test model of great innovation and improvement, more emphasis on the high simulation model. Based on the New York Stock Exchange model, the model architecture completes the transition from the C/S architecture to the B/S architecture, which is a typical benchmark for OLTP performance testing in the Internet era. TPC-E simulates a series of back-end processing data as well as the typical behavior of the securities company's front-end customers in the stock trading market-account query, online trading and market research, the simulation of securities companies are also linked with the external financial market, execute commands based on market changes and update related account and market information. It not only contains the B2C environment, but also the B2B environment. This business model is easier to understand and closer to the application of existing users.

For the above model, the TPC-E has established a database table structure more complex than the TPC-C, the transaction type has also increased to 12, although the TPC-E uses more table structure and transactions, however, because the TPC-E updates the stored procedure and method, it reduces the disk I/O utilization and reduces the system's requirements for the number of disks. Using the same database server, the TPC-E reduces the number of hard disks by 2/3 compared to the TPC-C, which is significant to reducing the overall cost of participating in the testing system.