Overview Vine Server Database

Overview Vine Server Database

The Vine Server database is an SQL relational database that runs under the Oracle DBMS. During the Vine Server installation, Vine Server Setup creates the "Vineyard" tablespace and the "VineyardDB" user. The schema of the VineyardDB user contains all Vineyard objects: tables, indexes, views, sequences and stored packages.

All Vine tables start with a two- or three-letter prefix:

Prefix	Table Description
VS_	System tables added in Vine database 4.3 or higher
VP_	System parameter tables added in Vine database 4.3 or higher
VWH_	Dataware house tables
VX_	Additional (non system and non object)
VY_	Tables in custom object sets (custom object and parameter tables)
	All tables in Vine database lower than 4.3 keep their names. The old tables which names start with the "VY_" prefix constitute the core of the database. These tables are most intensively used by Vine for Windows. The tables used by other Vine products may use other prefixes, e.g. Vine Market tables start with the "VM_" prefix and Vine Replication Server tables start with "VYREP_".

NOTE: For reference information on the fields of any database table, see the Server Database Tables section of the Appendix.

The majority of the tables have views. A view's name is formed by adding the "_VIEW" ending to the name of the table. Thus, the view name for the VY_COMPANY table is VY_COMPANY_VIEW.