Star Schema Benchmark（SSB）

最新推荐文章于 2024-02-15 23:38:55 发布

耐心是关键

最新推荐文章于 2024-02-15 23:38:55 发布

阅读量3.2k

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/guotong1988/article/details/13288791

版权

数据库专栏收录该内容

58 篇文章

订阅专栏

本文详细介绍了如何使用dbgen-s1工具下载、编译并生成SSBM基准测试的数据文件，包括维度表和事实表的创建过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SF stands for the Scale Factor of the benchmark

下载http://download.csdn.net/detail/guotong1988/6465569

linux环境

make一下

然后How to generate SSBM data files?
To generate the dimension tables:

(customer.tbl)
dbgen -s 1 -T c

(part.tbl)
dbgen -s 1 -T p

(supplier.tbl)
dbgen -s 1 -T s

(date.tbl)
dbgen -s 1 -T d

(fact table lineorder.tbl)
dbgen -s 1 -T l

(for all SSBM tables)
dbgen -s 1 -T a

CREATE TABLE LINEORDER ( LO_ORDERKEY    BIGINT,
                             LO_LINENUMBER    BIGINT,
                               LO_CUSTKEY       INTEGER NOT NULL,
                               LO_PARTKEY       INTEGER NOT NULL,
                               LO_SUPPKEY       INTEGER NOT NULL,
                           LO_ORDERDATE    INTEGER NOT NULL,
                           LO_ORDERPRIOTITY  VARCHAR(15) NOT NULL,
                               LO_SHIPPRIOTITY INTEGER,
                         LO_QUANTITY    BIGINT,
                         LO_EXTENDEDPRICE  BIGINT,
                             LO_ORDTOTALPRICE  BIGINT,
                             LO_DISCOUNT    BIGINT,
                               LO_REVENUE       BIGINT,
                               LO_SUPPLYCOST    BIGINT,
                               LO_TAX          BIGINT,
                               LO_COMMITDATE    INTEGER NOT NULL,
                               LO_SHIPMODE    VARCHAR(10) NOT NULL);

CREATE TABLE CUSTOMER ( C_CUSTKEY    INTEGER,
                               C_NAME       VARCHAR(25) NOT NULL,
                               C_ADDRESS    VARCHAR(40) NOT NULL,
                             C_CITY       VARCHAR(10) NOT NULL,
                                 C_NATION    VARCHAR(15) NOT NULL,
                               C_REGION    VARCHAR(12) NOT NULL,
                               C_PHONE    VARCHAR(15) NOT NULL,
                               C_MKTSEGMENT  VARCHAR(10) NOT NULL);

CREATE TABLE DATES ( D_DATEKEY       INTEGER,
                            D_DATE          VARCHAR(18) NOT NULL,
                            D_DAYOFWEEK       VARCHAR(8) NOT NULL,
                            D_MONTH          VARCHAR(9) NOT NULL,
                            D_YEAR          INTEGER NOT NULL,
                            D_YEARMONTHNUM    INTEGER,
                            D_YEARMONTH       VARCHAR(7) NOT NULL,
                            D_DAYNUMINWEEK    INTEGER,
                            D_DAYNUMINMONTH INTEGER,
                            D_DAYNUMINYEAR    INTEGER,
                            D_MONTHNUMINYEAR INTEGER,
                            D_WEEKNUMINYEAR INTEGER,
                            D_SELLINGSEASON VARCHAR(12) NOT NULL,
                            D_LASTDAYINWEEKFL  INTEGER,
                            D_LASTDAYINMONTHFL INTEGER,
                            D_HOLIDAYFL       INTEGER,
                            D_WEEKDAYFL       INTEGER);


CREATE TABLE PART  ( P_PARTKEY    INTEGER,
                            P_NAME       VARCHAR(22) NOT NULL,
                            P_MFGR       VARCHAR(6) NOT NULL,
                            P_CATEGORY VARCHAR(7) NOT NULL,
                            P_BRAND    VARCHAR(9) NOT NULL,
                            P_COLOR    VARCHAR(11) NOT NULL,
                            P_TYPE       VARCHAR(25) NOT NULL,
                            P_SIZE       INTEGER NOT NULL,
                            P_CONTAINER VARCHAR(10) NOT NULL);

CREATE TABLE SUPPLIER ( S_SUPPKEY    INTEGER,
                               S_NAME       VARCHAR(25) NOT NULL,
                               S_ADDRESS    VARCHAR(25) NOT NULL,
                               S_CITY       VARCHAR(10) NOT NULL,
                                S_NATION    VARCHAR(15) NOT NULL,
                               S_REGION    VARCHAR(12) NOT NULL,
                               S_PHONE    VARCHAR(15) NOT NULL);