(1) In a DB2 OLAP Server, a table, or in many cases a set of tables, that contains all data values for a relational cube.
(2) A relational table that contains facts, such as units sold or cost of goods, and foreign keys that link the fact table to each dimension table.
A group of functions that provide inter-partition communication support.
In a federated system, the database that is within the federated server. Users and applications interface with the federated database. To these clients, the data sources appear as a single collective database in DB2.
The DB2 server in a federated system. Any number of DB2 instances can be configured to function as federated servers. You can use existing DB2 instances as your federated server, or you can create new ones specifically for the federated system.
A special type of distributed database management system (DBMS). A federated system lets you query and manipulate data located on other servers. The data can be in database managers such as Oracle, Sybase, Informix, and Microsoft SQL Server, or it can be in lists or stores such as a spreadsheet, Web site, or data mart. A federated system consists of a DB2 instance that operates as a server, a database that serves as the federated database, one or more data sources, and clients (users and applications) who access the database and data sources.
Pertaining to a type of user-defined function or stored procedure that is defined to protect the database manager from modifications by the function. The database manager is isolated from the function or stored procedure by a barrier.
An SQL action that positions a cursor on the next row of its result table and assigns the values of that row to host variables.
A character or graphic string whose length is specified and cannot be changed.
A column or set of columns that refers to a parent key. In a relational database, a key in one table that references the primary key in another table.
A process that rebuilds a restored database or table space to a specified point in time by applying the changes recorded in the database log.
The separation of the index into pieces as a result of inserts and deletions in the index.
The total amount of unused space in a page. The space that is not used to store records or control information is free space.
The result of an SQL join operation that includes the matched rows of both tables being joined and preserves the unmatched rows of both tables.
A subselect, a values-clause, or a number of both that are combined by set operators. Fullselect specifies a result table. If a UNION operator is not used, the result of the fullselect is the result of the specified subselect.
A mapping, embodied as a program (the function body) and invoked by means of zero or more input values (arguments). Functions can be user-defined, built-in, or created by DB2.