- Industry: Computer
- Number of terms: 98482
- Number of blossaries: 0
- Company Profile:
Sometimes referred to as “Big Blue” IBM is a multinational corporation headquartered in Armonk, New York. It manufactures computer hardware and software and provides information technology and services.
In a federated system, a logical table object that is used to cache data from a data source table. A cache table comprises a nickname that identifies the data source table, one or more materialized query tables, and a schedule for replicating the data in each materialized query table.
Industry:Software
In a federated system, a mapping between a data source function and an existing DB2 database function. The DB2 database management system supplies default mappings between existing built-in data source functions and built-in DB2 database functions; the default mappings are in the wrapper. The DB2 counterpart function can be either a complete function or a function template. See also function template.
Industry:Software
In a federated system, a parameter of the CREATE NICKNAME and ALTER NICKNAME statements that describes the values in certain columns of the data source object that a nickname references. This information is added to the global catalog and used by the query optimizer to develop better access plans. Column options provide a way to tell the data source wrapper to handle a column in a different way than it normally would.
Industry:Software
In a federated system, a parameter of the CREATE USER MAPPING or ALTER USER MAPPING statement to which values related to authorization are assigned. For example, suppose that a user has the same ID with different passwords for the federated database and a data source. For the user to access the data source, it is necessary to map the passwords to one another. This is accomplished with the user option REMOTE_PASSWORD. See also user mapping.
Industry:Software
In a federated system, a set of metadata about a data source object index that the query optimizer uses to expedite the processing of distributed requests. When a nickname is created for a data source object, the federated server gathers index information about that object and stores the information in the global catalog.
Industry:Software
In a federated system, an object at the data source on which operations can be performed. Examples include a database table, a database view, and a spreadsheet list. See also nickname.
Industry:Software
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 and the federated database all appear as a single database.
Industry:Software
In a federated system, the mapping of a data type at a remote data source to a comparable DB2 data type. For most data sources, the default forward data type mappings are in the wrappers. See also data type mapping.
Industry:Software
In a federated system, the processing of segments of a query at a data source instead of at the federated server. See also compensation, global optimizer.
Industry:Software
