Vertica ships with a sample multi-schema database called the VMart Example Database, which represents a database that might be used by a large supermarket (VMart) to access information about its products, customers, employees, and online and physical stores. Using this example, you can create, run, optimize, and test a multi-schema database.
The VMart database contains the following schema:
public(automatically created in any newly created Vertica database)
VMart Database Location and Scripts
If you installed Vertica from the RPM package, the VMart schema is installed in the
/opt/vertica/examples/VMart_Schema directory. This folder contains the following script files that you can use to get started quickly. Use the scripts as templates for your own applications.
||SQL script that counts rows of all example database tables, which you can use to verify load.|
||SQL script that defines the logical schema for each table and referential integrity constraints.|
||Data generator source code (C++).|
||Data generator executable file.|
||SQL script that loads the generated sample data to the corresponding tables using COPY DIRECT.|
||SQL script that contains concatenated sample queries for use as a training set for the Database Designer.|
||SQL scripts that contain individual queries; for example,
||SQL script that drops all example database tables.|
For more information about the schema, tables, and queries included with the VMart example database, see the Appendix.