tpcc验证一致性的简单方法

最新推荐文章于 2025-07-03 21:22:35 发布

原创最新推荐文章于 2025-07-03 21:22:35 发布 · 2.4k 阅读

1 ·

CC 4.0 BY-SA版权

数据库专栏收录该内容

17 篇文章

订阅专栏

本文介绍了一组 SQL 查询，用于验证 TPCC (Transaction Processing Performance Council) 数据库的一致性。通过对比不同表中的数据，确保在运行过程中的数据完整性和一致性。

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

(Select w_id, w_ytd from warehouse) except(select d_w_id, sum(d_ytd) from district group by d_w_id);

(Select d_w_id, d_id, D_NEXT_O_ID - 1 from district) except (select o_w_id, o_d_id, max(o_id) from oorder group by o_w_id, o_d_id);

(Select d_w_id, d_id, D_NEXT_O_ID - 1 from district) except (select no_w_id, no_d_id, max(no_o_id) from new_order group by no_w_id, no_d_id);

select * from (select (count(no_o_id)-(max(no_o_id)-min(no_o_id)+1)) as diff from new_order group by no_w_id, no_d_id) where diff != 0;

(select o_w_id, o_d_id, sum(o_ol_cnt) from oorder group by o_w_id, o_d_id) except (select ol_w_id, ol_d_id, count
(ol_o_id) from order_line group by ol_w_id, ol_d_id);

(select d_w_id, sum(d_ytd) from district group by d_w_id) except(Select w_id, w_ytd from warehouse);

连接到数据库做以上查询，如果结果全为0行，则说明tpcc库是一致的，否则说明此库在运行过程中数据出现混乱。