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. |
Overflow | the condition in which a record or a segment cannot be stored in its home because the address is already occupied. |
0 comments:
Post a Comment