请输入您要查询的字词:

 

单词 online analytical processing
释义
online analytical processing

Computer
  • The use of a database for data analysis. The design of databases used primarily for OLAP differs from those whose primary purpose is online transaction processing (OLTP). In particular the normal basic rule of a relational database, that data should not be duplicated, is relaxed. Every possibly useful aggregate is precomputed and stored in a data structure called a cube, a multi-dimensional array with axes for, in principle, every useful measure of the data. The advantage of such a design is the high speed at which query results are returned, which makes it useful for data mining. In practice space constraints often prevent the storage of all possible aggregates and choices must be made at design time. An important precondition for an OLAP database is that its data is relatively stable: each update will affect many aggregates and so is an expensive operation. A common practice is to update an OLAP database periodically from an OLTP database used to collect the data.


随便看

 

科学参考收录了60776条科技类词条,基本涵盖了常见科技类参考文献及英语词汇的翻译,是科学学习和研究的有利工具。

 

Copyright © 2000-2023 Sciref.net All Rights Reserved
京ICP备2021023879号 更新时间:2024/6/30 20:06:13