当前位置:网站首页>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.
.
边栏推荐
猜你喜欢
随机推荐
Flink快速上手 完整使用 (第二章)
速卖通卖家如何抓住产品搜索权重
Rust learning: 6.5_Array of composite types
【搜索引擎】Solr:提高批量索引的性能
PTA 习题2.2 数组循环左移
Spotify expresses its architectural design using the C4 model
DeepFake换脸诈骗怎么破?让他侧个身
【Unity入门计划】制作RubyAdventure03-使用碰撞体&触发器实现世界交互
DAY26: GetShell project
npm i安装报错
m.bjhjwy.com全面教学设备 类型包括: 教学仪器, 教学设备 ,
Flink部署 完整使用 (第三章)
【数据库架构】OLTP 和 OLAP:实际比较
ShardingSphere入门
【FAQ】【Push Kit】推送服务,回执配置一直报错、回执过期修改、怎么删除配置的回执
1499. The maximum pile.then/deque
MUDA:对齐特定域的分布和分类器以实现来自多源域的跨域分类
How AliExpress sellers seize product search weight
Ask next CDC mysql to Doris. Don't show the specific number of lines, how to do?
封装和使用通用的工具栏组件