TPC photo
The TPC defines transaction processing and database benchmarks and delivers trusted results to the industry
    Document Search         Member Login    
About the TPC
      Join the TPC
      Technical Articles

The current TPC-DI specification can be found on the TPC Documentation Webpage.

TPC Benchmark™DI (TPC-DI) Overview

The TPC-DI benchmark is a new Data Integration (also known as 'ETL') benchmark developed by the TPC.

The TPC-DI benchmark combines and transforms data extracted from a (fictitious) brokerage firm's On-Line Transaction Processing (OTLP) system along with other sources of data, and loads it into a data warehouse. The source and destination data models, data transformations and implementation rules have been designed to be broadly representative of modern data integration requirements, characterized by:
  • The manipulation and loading of large volumes of data
  • Multiple data sources, utilizing a variety of different data formats
  • Fact and dimensional table building and maintenance operations
  • A mixture of transformation types including data validation, key lookups, conditional logic, data type conversions, complex aggregation operations, etc.,
  • Initial loading and incremental updates of the Data Warehouse
  • Consistency requirements ensuring that the data integration process results in reliable and accurate data

Valid XHTML 1.0 Transitional Valid CSS!