Database Objects

A TimesTen database has several permanent objects.

• Tables. The primary objects of a TimesTen database are the tables that contain the application data. See Understanding Tables.

• Materialized Views. Read-only tables that hold a summary of data selected from one or more "regular" TimesTen tables. See Understanding Materialized Views.

• Views. Logical tables that are based on one or more tables called detail tables. A view itself contains no data. See Understanding Views.

• Indexes. Indexes on one or more columns of a table may be created for faster access to tables. See Understanding Indexes.

• Rows. Every table consists of 0 or more rows. A row is a formatted list of values. See Understanding Rows.

• Synonyms. Aliases for a database object. Synonyms are often used for security and convenience, because they can be used to mask object name and object owner. See Understanding Synonyms.

• System tables and views. System tables and views contain TimesTen metadata, such as a table of all tables. See System Tables and Understanding System Views.

There are also many temporary objects, including prepared commands, cursors and locks.