shadow tables

通过使用IBM的影子表技术,可以在不影响在线交易处理(OLTP)性能的情况下,大幅提升复杂分析查询的速度。影子表作为源表的列式存储副本,能够自动路由分析查询到最佳性能路径,同时保持OLTP查询效率。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

A shadow table is a column-organized copy of a row-organized table that includes all columns or a subset of columns. Shadow tables are implemented as materialized query tables (MQTs) that are maintained by replication.
Using shadow tables, you can get the performance benefits of BLU Acceleration for analytic queries in an online transaction processing (OLTP) environment. Analytical queries against row-organized tables are automatically routed to shadow tables if the replication latency falls within a user-defined limit.
BLU Acceleration enhances the performance of complex queries through a column-organized architecture. By combining this enhanced performance for complex queries with the efficiency of row-organized tables for OLTP queries, you can use shadow tables to capitalize on the best of both worlds.
Shadow tables are maintained by IBM® InfoSphere® Change Data Capture for Db2® (InfoSphere CDC), a component of the InfoSphere Data Replication product. InfoSphere CDC asynchronously replicates DML statements that are applied on the source table to the shadow table. By default, all applications access the source tables. Queries are automatically routed to the source table (row-organized) or the shadow table (column-organized copy of the source table) by using a latency-based algorithm that prevents applications from accessing the shadow table when the latency is beyond the user-defined limit.
Shadow tables improve analytic query performance in OLTP environments without having to add indexes for this purpose. Typically, OLTP environments and OLAP environments are maintained separately. A regular ETL operation moves data from the OLTP environment to the OLAP environment. Using shadow tables, you can combine these two environments into a single environment for both OLTP and OLAP query performance. You can use shadow tables in any scenario where you want to keep the source table row-organized while you take advantage of the performance enhancements that BLU Acceleration provides.

https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0061564.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值