Release notes for DBGEN and QGEN


These notes are taken from the History file which is distributed with the TPC-D soft appendix.

******************
* NOTE NOTE NOTE *
******************
Below this line the file refers to TPC-D which was retired in favor of TPC-H and TPC-R. Since the new speicifications are numbered from 1.0.0 the program version was reset.
******************
* NOTE NOTE NOTE *
******************

This is the revised data generator for DSS. The rewrite tried to accomplish three things:
  1. identify and isolate all the implicit assumptions about limits, bounds, ranges, distributions, etc.;
  2. standardize the way any given table was generated/ printed to ease understanding and maintenance;
  3. bring the generator in line with the current work of the committee and the excellent spec the Indira put together;
  4. provide an easy way to adjust distributions, string contents and to facilitate experimentation to get a better idea of the impact of data population changes.

The files included are:

driver.c
main and the calling routines for the generator
dist.c
should really be named dss_util.c; misc routines
customer.c
generation and print routines for customer table
orders.c
"" "" order table
parts.c
"" "" parts/partsupp
suppliers.c
"" "" suppliers table
time.c
"" "" time table
customer.h
associate header files; contain structure definitions
dss.h
dss.h holds the large number of assumptions and
orders.h
values that have been used as IFDEFs.
parts.h
suppliers.h
time.h
dists.dss
string selections and weights; used to build distributions

Running make will create an executable (using the compiler flags in CFLAGS, the ld flags in LDFLAGS and the libraries in LIBS [-O, -s, and -lm by default]) which will create flat files suitable for dbload.