computer science

Transaction Processing Performance Council

Transaction Processing Performance Council is a computer science topic covered in the lgStudy science library. This page brings together a partial reference excerpt, illustrations, worked examples, real-world applications and a short study plan, so you can understand Transaction Processing Performance Council rather than just read about it. In short: The Transaction Processing Performance Council (TPC), founded in 1988, is a non-profit organization founded to define benchmarks for transaction processing and databases, and to publish objective, verifiable TPC performance data to the industry. TPC benchmarks are used in evaluating the performance of computer systems, and TPC publishes the results.

Key takeaways

Transaction Processing Performance Council belongs to computer science; place it in that map before memorising details.
Learn the definition first, then one example that makes the definition concrete.
Connect Transaction Processing Performance Council to a quantity you can measure, compute or draw — that is where exam questions come from.
Reproduce the core statement of Transaction Processing Performance Council from memory before moving on to harder problems.

Reference excerpt

The Transaction Processing Performance Council (TPC), founded in 1988, is a non-profit organization founded to define benchmarks for transaction processing and databases, and to publish objective, verifiable TPC performance data to the industry. TPC benchmarks are used in evaluating the performance of computer systems, and TPC publishes the results. The first benchmark from the organization, known as TPC-A, was released in November 1989. It simulated a simple accounting system and was based on earlier work by Tandem Computers' Debit-Credit program. Companies would run this program on their system and submit the results along with details about the machine and the costs of buying and maintaining it for a period of five years. As computer power grew exponentially during this period, TPC-A was considered too simple to simulate real-world workflows even as it was published. A new standard, TPC-C, was released in July 1992. This was based on Digital's Order-Entry program which simulated a multi-site warehousing company performing a variety of queries against a much more complex database. TPC-C remains in widespread use to this day. The TPC has released a number of new benchmarks since then. TPC-E, released in February 2007, is intended to be a modern replacement for TPC-C, including a wider variety of transaction types and a more complex database structure. Although it sees widespread use, TPC-C also remains widely used. They have also published a series of more specialized benchmarks for decision support, virtualization and big data, among others.

Conference Series In 2009, the TPC initiated the International Technology Conference on Performance Evaluation and Benchmarking (TPCTC). Typically co-located with the VLDB conference, this forum allows industry experts and researchers to develop methodologies for characterizing modern application systems. As the database landscape has evolved, the scope of these evaluations has expanded beyond traditional relational models. Recent research presented in these venues examines the performance of distributed ledger technologies and sharded consensus protocols (such as Cerberus), challenging traditional definitions of transaction throughput and latency in globally distributed environments.

Standards TPC-C – On-line transaction processing (since 1992) TPC-H – Ad-hoc decision support system (since 1999) TPC-E – Complex on-line transaction processing (since 2006) TPC-DS – Complex decisions support system (since 2011) TPC-DI – Data integration (since 2013) TPCx-HS – Industry's first standard for benchmarking Big Data (Hadoop) systems (since 2014)

Obsolete benchmarks TPC-A – Measures performance in update-intensive database environments typical in on-line transaction processing applications. (Obsolete as of June 6, 1995) TPC-App – An application server and web services benchmark. TPC-B – Measures throughput in terms of how many transactions per second a system can perform. (Obsolete as of June 6, 1995) TPC-D – Represents a broad range of decision support applications that require complex, long running queries against large complex data structures. (Obsolete as of April 6, 1999) TPC-R – A business reporting, decision support benchmark. (Obsolete as of January 1, 2005) TPC-W – A transactional web e-Commerce benchmark. (Obsolete as of April 28, 2005)

References

Worked examples

Example 1 — a first encounter with Transaction Processing Performance Council

Start with the simplest possible case. Write down what Transaction Processing Performance Council claims or describes in one sentence, then invent the smallest concrete situation in which that sentence is true. In computer science, the smallest case is usually a single object, a single equation or a single measurement. Check that every symbol or term in your sentence has a meaning in that case.

Example 2 — changing one variable

Take the situation from Example 1 and change exactly one quantity: double it, halve it, or set it to zero. Predict what should happen to Transaction Processing Performance Council before you calculate. Comparing your prediction with the result is the fastest way to find out whether you understand the idea or only the words.

Example 3 — an exam-style question

Typical questions about Transaction Processing Performance Council ask you to (a) state it precisely, (b) apply it to given data, and (c) explain a limitation. Practise writing all three answers in under five minutes; the third part is what separates a full-mark answer from an average one.

Applications of Transaction Processing Performance Council

In research: Transaction Processing Performance Council appears in computer science research whenever the underlying quantities have to be modelled precisely. Papers usually cite it as a starting assumption and then explore where it breaks down.
In technology and industry: Engineering practice reuses Transaction Processing Performance Council in design rules, simulations and safety margins. Knowing the idea lets you read a specification sheet and understand why the numbers look the way they do.
In the classroom: Transaction Processing Performance Council is common in secondary-school and first-year university syllabi. It links to neighbouring topics 1988 establishments in California, Organizations based in San Francisco, Software engineering organizations, so understanding it makes those chapters shorter.
In everyday life: Look for Transaction Processing Performance Council outside the textbook — in sport, cooking, traffic, electronics or the sky above you. An example you found yourself is remembered far longer than one you were given.

Affiliate

Preply — study more efficiently by working with a personal tutor. 50% off.

How to study Transaction Processing Performance Council in 20 minutes

Read the reference excerpt below once, without taking notes.
Close the page and write down what Transaction Processing Performance Council means in your own words.
Compare your version with the excerpt and mark what you missed.
Work through the three examples above with pen and paper.
Explain Transaction Processing Performance Council out loud to somebody else — or to Teacher Smith in the lgStudy chat.

Frequently asked questions

What is Transaction Processing Performance Council in simple terms?

Why does Transaction Processing Performance Council matter?

Because it connects several computer science ideas at once: it gives you a definition you can apply, a quantity you can calculate, and a way to check whether a result is plausible.

How should I study Transaction Processing Performance Council?

Read the excerpt, restate it from memory, then work through the examples and applications listed on this page. The five-step study plan above takes about twenty minutes.

What does this page cover?

It gives you a compact reference excerpt plus original lgStudy explanations, examples, applications and study material on Transaction Processing Performance Council.