【数据库】Star Schema Benchmark 标准测试集优化（一）

CREATE USER ssb100 IDENTIFIED BY ssb1; CREATE SCHEMA ssb100; GRANT ALL ON ssb100.* TO ssb100; CREATE DIMENSION TABLE CUSTOMER( C_CUSTKEY INTEGER PRIMARY KEY, C_NAME VARCHAR(25), C_ADDRESS VARCHAR(25), C_CITY VARCHAR(10), C_NATION VARCHAR(15), C_REGION VARCHAR(12), C_PHONE VARCHAR(15), C_MKTSEGMENT VARCHAR(10) ) CREATE DIMENSION TABLE DATES( D_DATEKEY INTEGER PRIMARY KEY, D_DATE VARCHAR(18), D_DAYOFWEEK VARCHAR(18), D_MONTH VARCHAR(9), D_YEAR INTEGER, D_YEARMONTHNUM INTEGER, D_YEARMONTH VARCHAR(7), D_DAYNUMINWEEK INTEGER, D_DAYNUMINMONTH INTEGER, D_DAYNUMINYEAR INTEGER, D_MONTHNUMINYEAR INTEGER, D_WEEKNUMINYEAR INTEGER, D_SELLINGSEASON VARCHAR(12), D_LASTDAYINWEEKFL INTEGER, D_LASTDAYINMONTHFL INTEGER, D_HOLIDAYFL INTEGER, D_WEEKDAYFL INTEGER ) CREATE DIMENSION TABLE PART( P_PARTKEY INTEGER PRIMARY KEY, P_NAME VARCHAR(22) , P_MFGR VARCHAR(6), P_CATEGORY VARCHAR(7), P_BRAND VARCHAR(9), P_COLOR VARCHAR(11), P_TYPE VARCHAR(25), P_SIZE TINYINT, P_CONTAINER VARCHAR(10) ) CREATE DIMENSION TABLE SUPPLIER( S_SUPPKEY INTEGER PRIMARY KEY, S_NAME VARCHAR(25), S_ADDRESS VARCHAR(25), S_CITY VARCHAR(10), S_NATION VARCHAR(15), S_REGION VARCHAR(12), S_PHONE VARCHAR(15) ) CREATE TABLE LINEORDER( LO_ORDERKEY INTEGER, LO_LINENUMBER TINYINT, LO_CUSTKEY INTEGER REFERENCES CUSTOMER, LO_PARTKEY INTEGER REFERENCES PART, LO_SUPPKEY INTEGER REFERENCES SUPPLIER, LO_ORDERDATE INTEGER REFERENCES DATES, LO_ORDERPRIOTITY VARCHAR(15), LO_SHIPPRIOTITY TINYINT, LO_QUANTITY TINYINT, LO_EXTENDEDPRICE INTEGER, LO_ORDTOTALPRICE INTEGER, LO_DISCOUNT TINYINT, LO_REVENUE INTEGER, LO_SUPPLYCOST INTEGER, LO_TAX TINYINT, LO_COMMITDATE INTEGER REFERENCES DATES, LO_SHIPMODE VARCHAR(10) )

网址：【数据库】Star Schema Benchmark 标准测试集优化（一） https://mxgxt.com/news/view/929042

相关内容

数据库中Schema（模式）概念的理解
如何使用Flink,通过CTAS语句同步MySQL数据至StarRocks
JavaScript数据可视化库
京东云StarDB恒星数据库国内首家完成中国信通院稳定性测试
数显张力测试仪 瑞士TENSION STAR
游戏加加：科学的算法+公平的引擎=最真实的BenchMark
对话清华大学章明星老师，解读MLPerf AI存储基准测试
人脸识别数据集整理
数据库
STAR面试法STAR原则企业STAR法则运用可视化图标培训课件

随便看看