当前位置:网站首页>OLTP and OLAP database architecture 】 【 : actual comparison
OLTP and OLAP database architecture 】 【 : actual comparison
2022-08-10 08:59:00 【51CTO】
OLTP 和 OLAP:The two terms look similar,But referring to a different type of system.在线事务处理 (OLTP) 实时捕获、Store and process data from transactions.在线分析处理 (OLAP) Use complex queries to analyze from OLTP Aggregated historical data for the system.
什么是 OLTP?
OLTP The system captures and maintains transactional data in a database.Each transaction involves a single database record consisting of multiple fields or columns.Examples include banking and credit card activity or retail checkout scans.
在 OLTP 中,The point is fast processing,因为 OLTP The database is read frequently、写入和更新.如果事务失败,Built-in system logic ensures data integrity.
什么是 OLAP?
OLAP 对从 OLTP Apply complex queries to large amounts of historical data aggregated from databases and other sources,用于数据挖掘、Analytics and business intelligence projects.在 OLAP 中,The point is the response time to these complex queries.Each query involves one or more columns of data aggregated from multiple rows.Examples include year-over-year financial performance or marketing lead generation trends.OLAP Databases and data warehouses enable analysts and decision makers to turn data into information using custom reporting tools.OLAP Query failures in , do not interrupt or delay the client's transaction processing,But it can delay or affect the accuracy of business intelligence insights.
ETL:连接OLTP和OLAP的力量
来自一个或多个 OLTP Database data is extracted through a process called extraction、转换、加载 (ETL) process was ingested OLAP 系统中.使用 ETL 工具,Users can collect data from multiple sources and send it to a destination,例如 OLAP 数据仓库,There it is queried by analytics and business intelligence tools for insights.
OLTP 与 OLAP:并排比较
OLTP 是可操作的,而 OLAP 是信息性的.A glance at the main features of the two treatments illustrates their fundamental difference,以及它们是如何协同工作的.
| OLTP | OLAP |
特征 | Process lots of small transactions | Process large amounts of data with complex queries |
查询类型 | Simple standardized queries | Complex queries |
操作 | Based on INSERT, UPDATE, DELETE commands | Based on SELECT commands to aggregate data for reporting |
响应时间 | Milliseconds | 秒、分钟或小时,具体取决于要处理的数据量 |
设计 | Industry-specific, such as retail, manufacturing, or banking | 特定主题,例如销售、Inventory or Marketing |
来源 | Transactions | Aggregated data from transactions |
目的 | 实时控制和运行基本业务运营 | 计划、解决问题、支持决策、发现隐藏的见解 |
数据更新 | 由用户发起的简短、快速的更新 | 使用计划的、长时间运行的批处理作业定期刷新数据 |
空间要求 | If archiving historical data,通常很小 | Often large due to aggregating large datasets |
备份和恢复 | Regular backups are required to ensure business continuity and to meet legal and governance requirements | 可以根据需要从 OLTP 数据库重新加载丢失的数据,in lieu of regular backups |
生产率 | 提高最终用户的生产力 | 提高业务经理、数据分析师和高管的工作效率 |
Data view | 列出日常业务交易 | 企业数据的多维视图 |
用户示例 | 面向客户的人员、文员、在线购物者 | 知识工作者,例如数据分析师、业务分析师和高管 |
数据库设计 | Standardize your database to improve efficiency | 用于分析的非规范化数据库 |
OLTP Provides an instant record of current business activity,而 OLAP Generate and validate insights from this data over time.This historical perspective enables accurate forecasting,But as with all business intelligence,OLAP The insights generated are only as good as the data pipelines they produce.
Stitch Optimize data pipelines
要从 OLTP Get actionable intelligence from your data,It must be extracted、Transform and load into the data warehouse for analysis.Although this can be done through internal programming resources,但使用 ETL Tools can handle data ingestion more efficiently.ETL Tools are eliminated due to constantly changing data sources API、The need for ongoing maintenance of the code based on reporting requirements and business needs.像 Stitch 这样的 ETL Tools can be optimized OLTP 数据摄取,thereby freeing up time and IT Employees focus on more value-added activities.
Simplify will OLTP The source data is pulled into yours OLAP 仓库的过程.Choose a solution that scales with your data,and give you the support you need,to stay ahead of change and gain insight.
.
边栏推荐
猜你喜欢
凭借这份阿里架构师的万字面试手册,逆风翻盘,斩获阿里offer
英伟达游戏显卡营收暴跌/ 谷歌数据中心爆炸致3人受伤/ iPhone电量百分比回归…今日更多新鲜事在此...
怎么使用【jmeter正则表达式提取器】解决返回值作参数的问题
初识Flink 完整使用 (第一章)
mySQL add, delete, modify and check advanced
ARM Architecture 3: Addressing and Exception Handling of ARM Instructions
浅谈DAO+DeFi+NFT模式开发代码技术方案丨链游元宇宙NFT盲盒项目技术开发逻辑(源码程序)
ARM体系结构2:处理器内核和汇编指令集
DeepFake换脸诈骗怎么破?让他侧个身
【微信小程序】一文读懂页面导航
随机推荐
FPGA中BEL Site Tile FSR SLR分别指什么?
ARM体系结构2:处理器内核和汇编指令集
The implementation of the seemingly useless component (text gradient) in NaiveUI is so simple
js读取excel时间格式转换
BUUCTF【pwn】解题记录(4-6页持续更新中)
Obtain - 65 [chances] : "soldiers, subtlety also - 7-36 meter reading - defeat
大佬们,请问一下,oraclecdc报错没有序列化,可是我看源码中的确是没有继承序列化的,是什么原因
js reduce
Rust learning: 6.4_ enumeration of composite types
关于镜像源的一些记录
TensorFlow 2.9的零零碎碎(一)
A File Online Query Display and Download Function Realized by Delphi
线程池的基本概念、结构、类
2 模块一:科研思维培养
PTA Exercise 2.2 Rotate an Array Left
编程老手如何在autojs和冰狐智能辅助之间选择?
js reads excel time format conversion
Unity—UGUI控件
刷题工具h
J9 Number Theory: Macro Analysis of DAO Characteristics