tpc-h-標(biāo)準(zhǔn)-中文版

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

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

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

4、.........71.1商業(yè)和應(yīng)用環(huán)境........................................................71.2數(shù)據(jù)庫實(shí)體，關(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查詢確認(rèn).......................................

7、......................202.4價(jià)格摘要報(bào)告查詢（Q1）...............................................202.5最小代價(jià)供應(yīng)者查詢（Q2）.............................................212.6運(yùn)送優(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ù)測(cè)收入變化查詢（Q6）...............................................272.10貨運(yùn)量查詢（Q7）.....................

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

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

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

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

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