专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

US20190163776A1 ENSURING CONSISTENT REPLICATION OF UPDATES IN DATABASES 审中-公开
公开(公告)号：US20190163776A1
公开(公告)日：2019-05-30
申请号：US15827296
申请日：2017-11-30
申请人： International Business Machines Corporation
发明人： Serge Bourbonnais , Paul Cadarette , David A. Clitherow , Michael G. Fitzpatrick , Pamela McLean , David Petersen , John G. Thompson , Gregory W. Vance
IPC分类号： G06F17/30
摘要： A method includes reading, by a capture engine, log data. The log data can be synchronously hardware-replicated. The log data reflects that an update was started for a database of a first site. The capture engine corresponds to a capture engine of a second site. The method also includes identifying, by the capture engine, the update. The method also includes determining whether the update was committed to the database of the first site. The method also includes replicating, by an apply engine, the update to a database of the second site based on the determining. The update is replicated to the database of the second site based on a determination that the update was committed to the database of the first site. The committed update corresponds to a consistent replication of updates across two or more databases that reside in multiple database management systems.

2. 发明授权

US10176216B2 Verifying data consistency 有权
公开(公告)号：US10176216B2
公开(公告)日：2019-01-08
申请号：US15012103
申请日：2016-02-01
申请人： INTERNATIONAL BUSINESS MACHINES CORPORATION
发明人： Serge Bourbonnais , Si Bin Fan , Xiao Li , Jonathan W. Wierenga , Mai Zeng
IPC分类号： G06F17/30 , G06F21/55
摘要： A method for verifying data consistency between update-in-place data structures and append-only data structures containing change histories associated with the update-in-place data structures is provided. The method includes loading data from an update-in-place data structure to a first set of hash buckets in a processing platform, loading data from append-only data structures to a second set of hash buckets in the processing platform, performing a bucket-level comparison between the data in the first set of hash buckets and the data in the second set of has buckets, and generating a report based on the bucket-level comparison.

3. 发明授权

US10169429B2 Data caching in hybrid data processing and integration environment 有权
公开(公告)号：US10169429B2
公开(公告)日：2019-01-01
申请号：US14938474
申请日：2015-11-11
申请人： International Business Machines Corporation
发明人： Serge Bourbonnais , Zhen Hua Dong , Nan Jiang , Xiao Li , Hong Min , Gong Su , En Zhong Wang , Ke Wei Wei , Xi Long Zheng
IPC分类号： G06F17/30 , G06F12/12
摘要： An integrated data processing system with two-tier data caching system and techniques for use thereof in a hybrid RDBMS and BDS computing environment are provided. In one aspect, the system is RDBMS-centric and uses two caches, one on the RDBMS side (1st tier) and the other on the BDS side (2nd tier). In another aspect, a DRDA wrapper on the BDS side enables the RDBMS to communicate with the BDS as if the BDS is another RDBMS. This is advantageous because the RDBMS already supports the DRDA protocol standard. In yet another aspect, the DRDA wrapper performs the data transformation needed when transferring cached objects between the RDBMS cache and BDS cache because RDBMS and BDS save data objects in different formats. This is advantageous because it offloads the computation from RDBMS to BDS therefore reducing the performance impact on RDBMS for its normal query and transaction processing.

4. 发明申请

US20180203913A1 PARALLEL REPLICATION OF DATA TABLE PARTITION 审中-公开
公开(公告)号：US20180203913A1
公开(公告)日：2018-07-19
申请号：US15410276
申请日：2017-01-19
申请人： International Business Machines Corporation
发明人： Serge Bourbonnais , Austin F. M. D'Costa , Xiao Li , Jonathan W. Wierenga , Xin Wu , Christian Zentgraf , Xiang W. Zhou
IPC分类号： G06F17/30
CPC分类号： G06F16/27
摘要： Several replication subscriptions are defined for a table in a database management system. The table is divided into partitions. Each replication subscription replicates transactions to a range of partitions. Subscriptions are assignable to different consistency groups. Transaction consistency is preserved at the consistency group level. A persistent delay table is created for each of several apply functions. Each apply function processes replication subscriptions for one consistency group, to replicate the table to a target table in parallel. Transactions for a given range of a partition are executed in parallel. When an apply function upon a row of the target table results in an error, the row is stored in the delay table. Application of each row in the delay table is repeatedly retried, and if successful, the row is removed from the delay table.

5. 发明申请

US20180113766A1 RECOVERY LOG ANALYTICS WITH A BIG DATA MANAGEMENT PLATFORM 审中-公开
公开(公告)号：US20180113766A1
公开(公告)日：2018-04-26
申请号：US15851336
申请日：2017-12-21
申请人： International Business Machines Corporation
发明人： Serge Bourbonnais , Austin F.M. D'Costa , Yat On Lau , Xiao Li , Hong Min , Gong Su , Jonathan W. Wierenga , Christian Zentgraf
IPC分类号： G06F11/14 , G06F17/30
CPC分类号： G06F11/1451 , G06F17/30303 , G06F17/30368 , G06F17/30377 , G06F17/30581 , G06F2201/80 , G06F2201/82
摘要： Provided are techniques for replicating relational transactional log data to a big data platform. Change records contained in change data tables are fetched. A relational change history with transaction snapshot consistency is rebuilt to generate consistent change records by joining the change data tables and a unit of work table based on a commit sequence identifier. The consistent change records are stored on the big data platform, and queries are answered on the big data platform using the consistent change records.

6. 发明申请

US20170351585A1 TRANSACTION CONSISTENCY QUERY SUPPORT FOR REPLICATED DATA FROM RECOVERY LOG TO EXTERNAL DATA STORES 审中-公开
公开(公告)号：US20170351585A1
公开(公告)日：2017-12-07
申请号：US15173502
申请日：2016-06-03
申请人： International Business Machines Corporation
发明人： Serge Bourbonnais , Austin F.M. D'Costa , Yat On Lau , Xiao Li , Hong Min , Gong Su , Jonathan W. Wierenga , Christian Zentgraf , Kan Zhang
IPC分类号： G06F11/14 , G06F17/30
CPC分类号： G06F11/1474 , G06F16/27
摘要： Provided are techniques for transaction consistency query support for replicated data from recovery log to external data stores. An external data store is populated with records using entries of a change data table. The change data table has entries for each transaction that has committed and is to be replicated, and each of the entries stores information for each log entry in a recovery log from a database management system. Each log entry identifies a transactional change of data and a transaction completion indicator of one of commit and abort. In response to receiving a query about a transaction of the transactions, a set of records are retrieved from the external data store for the transaction. From the set of records, records whose sequence identifier values are larger than a maximum transaction commit sequence identifier are removed. From the set of records, remaining records having transaction consistency are returned.

7. 发明申请

US20170132293A1 Data Caching in Hybrid Data Processing and Integration Environment 审中-公开
公开(公告)号：US20170132293A1
公开(公告)日：2017-05-11
申请号：US14938474
申请日：2015-11-11
申请人： International Business Machines Corporation
发明人： Serge Bourbonnais , Zhen Hua Dong , Nan Jiang , Xiao Li , Hong Min , Gong Su , En Zhong Wang , Ke Wei Wei , Zi Long Zheng
IPC分类号： G06F17/30 , G06F12/12 , G06F17/27 , G06F12/08
CPC分类号： G06F17/30545 , G06F12/12 , G06F17/30424 , G06F17/30498 , G06F17/30595 , G06F2212/60
摘要： An integrated data processing system with two-tier data caching system and techniques for use thereof in a hybrid RDBMS and BDS computing environment are provided. In one aspect, the system is RDBMS-centric and uses two caches, one on the RDBMS side (1st tier) and the other on the BDS side (2nd tier). In another aspect, a DRDA wrapper on the BDS side enables the RDBMS to communicate with the BDS as if the BDS is another RDBMS. This is advantageous because the RDBMS already supports the DRDA protocol standard. In yet another aspect, the DRDA wrapper performs the data transformation needed when transferring cached objects between the RDBMS cache and BDS cache because RDBMS and BDS save data objects in different formats. This is advantageous because it offloads the computation from RDBMS to BDS therefore reducing the performance impact on RDBMS for its normal query and transaction processing.

8. 发明申请

US20170097957A1 SYSTEM AND METHOD FOR TRANSFERRING DATA BETWEEN RDBMS AND BIG DATA PLATFORM 审中-公开
公开(公告)号：US20170097957A1
公开(公告)日：2017-04-06
申请号：US14872618
申请日：2015-10-01
申请人： International Business Machines Corporation
发明人： Serge Bourbonnais , Hong Min , Xiao Li , Gong Su , Ke Wei Wei , Xi Long Zheng
IPC分类号： G06F17/30
CPC分类号： G06F17/30445 , G06F17/30297 , G06F17/30486
摘要： A system for transferring data from a Relational Database Management System (“RDBMS”) to a big data platform and methods for making and using the same. The system can acquire a partitioning execution scheme of a selected table from the RDBMS and submitting partitioned queries from the big data platform to each mapper of partitions. The partitioned queries are generated based on the partitioning execution scheme. The partitioning execution scheme can be acquired by submitting a query explain request to an optimizer of the RDBMS to generating a parallel query plan. The partitioning execution scheme can also be acquired by querying statistics from a statistics catalog of the RDBMS or by user inputs. The system can use RDBMS capabilities and statistics for parallel data fetching. Thereby, the system can increase efficiency of the fetching and can avoid straggling when target data is not evenly distributed and can avoid table query-in-serial.

9. 发明申请

US20160246865A1 ZERO-DATA LOSS RECOVERY FOR ACTIVE-ACTIVE SITES CONFIGURATIONS 审中-公开
标题翻译：主动活动站点配置的零数据丢失恢复
公开(公告)号：US20160246865A1
公开(公告)日：2016-08-25
申请号：US14849680
申请日：2015-09-10
申请人： INTERNATIONAL BUSINESS MACHINES CORPORATION
发明人： Serge Bourbonnais , Jing Cheng , You-Chin Fuh , David B. Petersen , James Z. Teng , Hong Jing Ying , Miao Zheng
IPC分类号： G06F17/30
摘要： A system for providing continuous availability comprises a second computing site that is geographically remote from a first computing site. The second computing site comprises a storage unit configured to store units of work data and data synchronously replicated from the first computing site. The second computing site further comprises a group of workloads configured to process the units of work data asynchronously replicated from the first computing site. The second computing site further comprises a software replication module configured not to replicate any data while the first computing site is available.
摘要翻译：用于提供连续可用性的系统包括在地理上远离第一计算站点的第二计算站点。第二计算站点包括被配置为存储工作数据单元和从第一计算站点同步地复制的数据的存储单元。第二计算站点还包括被配置为处理从第一计算站点异步复制的工作数据单元的一组工作负载。第二计算站点还包括配置为在第一计算站点可用时不复制任何数据的软件复制模块。

10. 发明申请

US20160210344A1 Replicating Data Across Multiple Copies of a Table in a Database System 有权
标题翻译：在数据库系统中复制表中的多个副本的数据
公开(公告)号：US20160210344A1
公开(公告)日：2016-07-21
申请号：US14977806
申请日：2015-12-22
申请人： International Business Machines Corporation
发明人： Serge Bourbonnais , Elizabeth B. Hamel , Bruce G. Lindsay , Stephen J. Todd
IPC分类号： G06F17/30
CPC分类号： G06F17/30578 , G06F17/30345 , Y10S707/99938
摘要： A mechanism is provided for handling transaction messages in asynchronous data replication in a database system, in which the database system includes a source node and a target node, and each transaction message has information concerning a row change to a table copy at the source node. The mechanism determines whether a first transaction message has a dependency on a preceding non-completed transaction message. Responsive to the first transaction message having a dependency on the preceding non-completed transaction, the mechanism holds the first transaction message, completes the preceding non-completed transaction message including applying the row change associated with the preceding non-completed transaction message to the table copy at the target node, and responsive to completing the preceding non-completed transaction message, and releases the first transaction message and applying the row change associated with the first transaction message to the table copy at the target node.
摘要翻译：提供了一种用于在数据库系统中处理异步数据复制中的事务消息的机制，其中数据库系统包括源节点和目标节点，并且每个事务消息具有关于在源节点处的表副本的行更改的信息。该机制确定第一事务消息是否具有对先前未完成的事务消息的依赖性。响应于对先前未完成的事务具有依赖性的第一交易消息，该机制保持第一交易消息，完成前述未完成的交易消息，包括将与先前未完成的交易消息相关联的行变更应用于表在目标节点处复制，并响应于完成上述未完成的交易消息，并且释放第一交易消息并将与第一交易消息相关联的行变更应用于目标节点处的表副本。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式