|
A communications layer that allows applications to interact across hardware and network environments.
|
|
|
A communications layer that allows applications to interact across hardware and network environments.
|
|
|
the process by which frequently used items of data are moved to more readily accessible areas of storage and infrequently used items of data are moved to less readily accessible areas of storage.
|
|
|
OLAP on Multidimensional models. In MOLAP servers, Data warehouses directly store multidimensional data in special data structures(eg.,arrays) and implement the OLAP operations over these special data structures.
|
|
|
a chained file organization in which the chains are divided into fragments and each fragment is indexed. This organization of data permits faster access to the data.
|
|
|
a join in which the redundant logic components generated by the join are removed.
|
|
|
a data model that provides data relationships on the basis of records or groups of records (ie. sets) in which one record is designated as the set owner, and a single member record can belong to one or more sets.
|
|
|
syntax that directs the computer as to what to do, not how to do it. Typical nonprocedural languages include RAMIS,FOCUS, NOMAD, and SQL.
|
|
|
Normalisation is a step-by-step process of removing redundancies and dependencies of attributes in a data structure. The condition of the data at completion of each step is described as a "normal form." Thus, when normalising we talk about data as being in the first normal form, the second normal form, etc. Normalisation theory identifies normal forms up to at least the fifth normal form, plus an adjunct form known as Boyce-Codd Normal Form (BCNF). The first three forms are sufficient to meet the needs of warehousing data models.
|
|
|
OLAP (On-Line Analytical Processing) |
|
Describes the systems used not for application delivery, but for analyzing the business, e.g., sales forecasting, market trends analysis, etc. These systems are also more conducive to heuristic reporting and often involves multidimensional data analysis capabilities.
|
|
|
OLTP (OnLine Transaction Processing) |
|
Describes the activities and systems associated with a company's day-to-day operational processing and data (order entry, invoicing, general ledger, etc.).
|
|
|
Operational Data Store (ODS) |
|
the form that data warehouse takes in the operational environment. Operational data stores can be updated, do provide rapid and consistent time, and contain only a limited amount of historical data.
|
|
|
the condition in which a record or a segment cannot be stored in its home because the address is already occupied.
|
|
|
Parallel Data Orgnisation |
|
an arrangement of data in which the data is spread over independent storage devices and is managed independently.
|
|
|
a storage device in which one or more parts of all storage locations are queried simultaneously for a certain condition or under certain parameters.
|
|
|
the algorithm that translates syntax into meaningful machine instructions. Parsing determines the meaning of statements issued in the data manipulation language.
|
|
|
a segmentation technique in which data is divided into physically different units. Partioning can be done at the application or the system level.
|
|
|
the length of time from the moment a request is issued until the first of the results of the request are received.
|
|
|
a measurement or description of data taken at a regular time interval.
|
|
Portlets are small windows of functionality that are exposed to users within a Portal page.
Portlets allows a portal page to be customised by the end user or an administrator.
|
|
Glossary 
