TPC-D Update Functions
Update 0.1% of data per query stream
- About as long as a medium sized TPC-D query
Implementation of updates is left to sponsor, except:
- ACID properties must be maintained
- The update functions must be a set of logically consistent transactions
New Sales Update Function (UF1)
- Insert new rows into ORDER and LINEITEM tables equal to 0.1% of table size
Old Sales Update Function (UF2)
- Delete rows from ORDER and LINEITEM tables equal to 0.1% of table size