- 专利标题: Database table comparison
-
申请号: US13156629申请日: 2011-06-09
-
公开(公告)号: US09600513B2公开(公告)日: 2017-03-21
- 发明人: Serge Bourbonnais , Marcel Kutsch , Xiao Li , Jonathan Wierenga
- 申请人: Serge Bourbonnais , Marcel Kutsch , Xiao Li , Jonathan Wierenga
- 申请人地址: US NY Armonk
- 专利权人: INTERNATIONAL BUSINESS MACHINES CORPORATION
- 当前专利权人: INTERNATIONAL BUSINESS MACHINES CORPORATION
- 当前专利权人地址: US NY Armonk
- 代理机构: Patterson + Sheridan, LLP
- 主分类号: G06F7/00
- IPC分类号: G06F7/00 ; G06F17/30
摘要:
Techniques are disclosed for comparing database tables. In one embodiment, the database tables are partitioned. Queries are generated for retrieving each partition. For each generated query, a stored procedure is invoked, using the respective generated query as an input parameter to the stored procedure. The stored procedure is configured to generate a checksum based on the partition retrieved from executing the respective query. The application compares the generated checksums to determine if the partitions and/or tables are consistent.
公开/授权文献
- US20120317134A1 DATABASE TABLE COMPARISON 公开/授权日:2012-12-13
信息查询