Dream of any Data Engineer? A set Data Model. An engine ready to make some noise! And some wits!
Introduction
Transaction Processing Performance Council (TPC) has been an industry reference for a long time. Its something we all have read or referenced via all the Data and Systems Vendors. It comes across as something sacred, untouchable and usable to rare few! Alas, its called out that its all Open Source (much like almost everything else at roots of IT systems). When it comes to TPC, its not just the outcomes, how they are categorized, orchestrated and modelled is equally interesting perspective to step through.
Benchmarks
- OLTP
- TPC-C
- Represents any industry that must manage, sell, or distribute a product or service
- Mix of 5 different transactions of varied types and complexity, can be queued or deferred execution
- 9 tables with range of records and population size
- Measure: Transactions per minute (tpmC)
- TPC-E
- TPC-C
- OLAP
- TPC-H
- TPC-DS
- TPC-DI
- Others
- TPCx-IoT
- TPCx-AI