美文网首页
OLAP 和 OLTP

OLAP 和 OLTP

作者: 戈壁堂 | 来源:发表于2020-08-31 18:53 被阅读0次

    oltp vs. olap

    OLAP

    Online Analytical Processing, a category of software tools which provide analysis of data for business decisions. OLAP systems allow users to analyze database information from multiple database systems at one time.

    The primary objective is data analysis and not data processing.

    OLTP

    Online Transaction Processing shortly known as OLTP supports transaction-oriented applications in a 3-tier architecture. OLTP administers day to day transaction of an organization.

    The primary objective is data processing and not data analysis


    可以认为任何一个数据仓库(Datawarehouse)都是OLAP的。数据库存储的数据用来进行“分析”(Analyze)的。关注数据生成的“事后”分析(Analytical)。

    OLTP则强调“事务”(transaction)本身,关注在“业务”进行中的逻辑。例如——在线预订火车票;银行的账单处理。

    ATM center. Assume that a couple has a joint account with a bank. One day both simultaneously reach different ATM centers at precisely the same time and want to withdraw total amount present in their bank account.

    相关文章

      网友评论

          本文标题:OLAP 和 OLTP

          本文链接:https://www.haomeiwen.com/subject/oylpsktx.html