1、1TPCTPCBENCHMARKBENCHMARKH(決策支持決策支持)標準規(guī)范標準規(guī)范修訂版修訂版2.0.02.0.0事務(wù)處理性能理事會（事務(wù)處理性能理事會（TPCTPC）3目錄目錄致謝..........................................................................2TPC成員..............................................

2、........................2目錄..........................................................................3條款0：概述..................................................................50.1前言........................................

3、..........................50.2一般系統(tǒng)實現(xiàn)原則......................................................60.3一般測量原則..........................................................7條款1數(shù)據(jù)庫邏輯設(shè)計.................................................

4、.........71.1商業(yè)和應(yīng)用環(huán)境........................................................71.2數(shù)據(jù)庫實體，關(guān)系和特性................................................81.3數(shù)據(jù)類型定義..........................................................91.4表的規(guī)劃.....

5、........................................................101.5執(zhí)行的規(guī)則...........................................................131.6數(shù)據(jù)透明訪問的要求...................................................15條款2.查詢和更新函數(shù).................

6、.......................................152.1查詢的一般要求和定義.................................................152.2查詢一致性...........................................................172.3查詢確認.......................................

7、......................202.4價格摘要報告查詢（Q1）...............................................202.5最小代價供應(yīng)者查詢（Q2）.............................................212.6運送優(yōu)先權(quán)查詢（Q3）.................................................242.7訂

8、單優(yōu)先權(quán)檢查查詢（Q4）.............................................252.8當(dāng)?shù)毓?yīng)者數(shù)量查詢（Q5）.............................................262.9預(yù)測收入變化查詢（Q6）...............................................272.10貨運量查詢（Q7）.....................

9、...............................282.11國家市場份額查詢（Q8）..............................................292.12產(chǎn)品類型利潤估量查詢（Q9）..........................................312.13返回項目報告查詢（Q10）............................................

10、.322.14重要庫存標志查詢（Q11）.............................................342.15貨運模式和命令優(yōu)先查詢（Q12）.......................................352.16消費者分配查詢（Q13）...............................................362.17促進效果查詢（Q14）............

11、.....................................382.18促進效果查詢（Q15）.................................................392.19零件供應(yīng)商關(guān)系查詢（Q16）..........................................402.20小量訂單收入查詢（Q17）....................................

12、.........422.21大訂單顧客查詢（Q18）...............................................422.22折扣收入查詢(Q19)...................................................442.23潛在零件促進查詢（Q20）.............................................452.24不能按時交貨供應(yīng)

13、商查詢（Q21）.......................................472.25全球銷售機會查詢（Q22）.............................................482.26更新函數(shù)的一般要求..................................................502.27新銷售更新函數(shù)（RF1）..........................