RDBMS - Auxiliary Data Structure (ADS)

Data System Architecture


Auxiliary data structures are logical replications of data from one or more columns of a table.

Auxiliary data structures contain copies of, references to, or data computed from base table data, deleting data from an auxiliary data structure does not result in the loss of base table data in that it is still contained in the base table data structure.

In contrast, deleting data from a base table data structure does result in the loss of base table data.

They are therefore derived data.



There are two types of auxiliary data structures:

  • Implicit (ADS)
  • and explicit. (EADS)


An explicit auxiliary data structure (EADS) is created as a consequence of a directive (e.g. DDL, session options, global configuration parameters).

These directives are called EADS Directives.


Any ADS which is not an EADS is by definition an Implict ADS (IADS).

Documentation / Reference

Discover More
Data System Architecture
(Relation|Table) - Tabular data

This section is based on the relation data structure must well known under the term of table. The system that manages this structure are called Relational databases (or RDMS) . They are founded on Set...
Data System Architecture
Relation - Index (Indices)

An index is an auxiliary data structure of a relation database to speed up the retrieval of rows. Indexing the data can lead to either performance or degradation of queries, so understanding indexing...
Data System Architecture
Relational Table - Sequence

A sequence is a auxiliary relational data structure that maintains a sequence. Relational sequences are generally used to create a generated primary key via an incremental number. They may also be...
SQL - Materialized View

A materialized view is an auxiliary data structure that persist the result of a query in a table format managed by the cache system of the database. The refresh of the data is defined in criteria: ...
Data System Architecture
Structured Query Language (SQL)

SQL is the standard language used to operate on table and its auxiliary data Structure (such as view, aggregate,...). SQL permits application designers to manipulate sets of rows with a non-procedural...
Tpc H Schema
TPC - TPC-H Decision Support Benchmark Sample Schema

TPC-H is an ad-hoc, decision support benchmark. It consists of a suite of business oriented ad-hoc queries and concurrent data modifications. The TPC-H benchmark...
Tpc Ds Data Flow
TPC-DS - Query

A query is an ordered set of one or more valid SQL statements resulting from applying the required parameter substitutions to a given query template. The order of the SQL statements is defined in the...

Share this page:
Follow us:
Task Runner