M


maintenance window

A user-defined time period for running only required automatic maintenance activities.



mass delete

The deletion of all rows in a table.



massively parallel processing (MPP)

The coordinated execution of a single request either by multiple single-processor computers in a shared-nothing environment (in which each computer has its own memory and disks) or by symmetric multiprocessor (SMP) computers (in which multiple processors in each computer share memory and disks). Both environments require that all computers are linked together in a high-speed network.



materialized query table

A table whose definition is based on the result of a query and whose data is in the form of precomputed results taken from the one or more tables that the materialized query table definition is based on.



MBCS

See [multibyte character set]
MDC table

See multidimensional clustering table.



merge

To update and insert new content into a table.



metadata

Data that describes the characteristics of stored data; descriptive data. For example, the metadata for a database table might include the name of the table, the name of the database that contains the table, the names of the columns in the table, and the column descriptions, either in technical terms or business terms. Database catalogs and information catalogs contain metadata.



migration

(1) The process of moving data from one computer system to another without converting the data.

(2) Installation of a new version or release of a program to replace an earlier version or release.



monitor switch

A database manager parameter manipulated by the user to control the type and quantity of information returned in performance snapshots.



MPP

See [massively parallel processing]
MQT

See [materialized query table]
multibyte character set (MBCS)

A set of characters in which each character is represented by 1 or more bytes. Contrast with double-byte character set and single-byte character set.

See also [ASCII]
See also [EBCDIC]
See also [Unicode]


multidimensional

In the DB2 OLAP Server, pertaining to a method of referencing data through three or more dimensions. An individual data value in a fact table is the intersection of one member from each dimension.



multidimensional clustering (MDC) table

A table whose data is physically organized into blocks along one or more dimensions, or clustering keys, specified in the ORGANIZE BY DIMENSIONS clause.



multidimensional database

In the DB2 OLAP Server, a nonrelational database into which you copy relational data for OLAP analysis.



multisite update

Distributed relational database processing in which data is updated in more than one location within a single unit of work.



multitasking

A mode of operation that provides for concurrent performance or interleaved execution of two or more tasks.





Understanding DB2(R. Learning Visually with Examples)
Understanding DB2: Learning Visually with Examples (2nd Edition)
ISBN: 0131580183
EAN: 2147483647
Year: 2004
Pages: 313

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net