Example Databases

Vertica provides several example databases that you can use in this tutorial:

You can perform this tutorial using any or all of the example databases.

You can define multiple example databases within a single Vertica installation but Vertica Systems, Inc. strongly recommends that you start only one example database at a time. Otherwise, the results are unpredictable.

Example Database File Locations

The example databases are installed in:

/opt/vertica/doc/ClickStream_Schema

/opt/vertica/doc/CreditHistory_Schema

/opt/vertica/doc/Retail_Schema

/opt/vertica/doc/Stock_Schema

/opt/vertica/doc/Telecom_Schema

Example Database File Descriptions

Each example database has an identical set of files except for the file name prefix and the number of query files. In each of the names in the list below, replace example with the prefix string that corresponds to one of the example databases:

clickstream

credithistory

retail

stock

telecom

example_count_data.sql	SQL script that does COUNT(*) of each table; can be used to verify load.
example_define_schema.sql	SQL script that defines the logical schema: tables and referential integrity constraints.
example_gen.cpp	Data generator source code (C++).
example_gen	Data generator executable file.
example_load_data.sql	SQL script that loads the generated sample data.
example_queries.sql	SQL script contain concatenated queries for use as a training set for the Database Designer. The Database Designer is a tool that analyzes a logical schema definition, sample queries, and sample data and generates a set of projections in the form of an SQL script to be executed after you create the tables but before you load any data. The script creates a minimal set of superprojections to ensure K-Safety, and optionally pre-join projections. In most cases, the projections created by the Database Designer provide excellent query performance within physical constraints. You can, however, write a custom projection script should the Database Designer not meet your needs. A superprojection is a projection that contains every column of a table in the Logical Schema. A table can have multiple superprojections with different sort orders.
example_query_01.sql	SQL scripts containing individual queries.
example_schema_drop.sql	SQL script that drops the schema.
README	Text file containing instructions for using the data generator.
Time.txt	Text file containing precomputed data for date dimension tables.

In This Section

Clickstream Example Database

Credit History Example Database

Retail Sales Example Database

Stock Exchange Example Database

Telecom Example Database