公开(公告)号：US11698917B1

公开(公告)日：2023-07-11

申请号：US17942646

申请日：2022-09-12

申请人： Gravic, Inc.

发明人： Paul J. Holenstein ,  Bruce D. Holenstein ,  John R. Hoffmann ,  Wilbur H. Highleyman

IPC分类号： G06F16/27 ,  G06F16/23

CPC分类号： G06F16/273 ,  G06F16/2365 ,  G06F16/2379

摘要： An automated method is provided for use when replacing a currently operating data replication engine in a first system with a new data replication engine in the first system in a bidirectional data replication environment. The currently operating data replication engine in the first system and the new data replication engine in the first system replicates first database transactions from an audit trail of a first database in the first system to a second database in a second system. The new data replication engine in the first system generating a list of active database transactions in the first system, and sends the list of active database transactions to the new data replication engine in the second system as a first token. The new data replication engine in the second system receives the first token, fetches a transaction event from an audit trail of second database, and replicates the fetched transaction event to the new data replication engine of the first system when the fetched transaction event does not match a transaction on the list in the first token. These steps are repeated during operation of the new data replication engine of the second system. The currently operating data replication engine in the first system is stopped from replicating first database transactions when all of the transactions on the list of active database transactions that were generated have been replicated to the second system.

公开(公告)号：US10025946B1

公开(公告)日：2018-07-17

申请号：US14962480

申请日：2015-12-08

申请人： Gravic, Inc.

发明人： Paul J. Holenstein ,  John R. Hoffmann ,  Bruce D. Holenstein ,  Wilbur H. Highleyman

IPC分类号： G06F17/30 ,  G06F21/62 ,  G06F9/46

摘要： A method is provided for controlling whether transactions applied against a database go forward or are aborted on a transaction processing system. A tracking engine identifies an uncompleted transaction to be joined, joins the uncompleted transaction, and collects one or more attributes of the joined uncompleted transaction. The collected one or more attributes become available as a result of the joining of the uncompleted transaction. The collected one or more attributes of the joined uncompleted transaction are compared against rules in a rules engine to determine whether the joined uncompleted transaction goes forward or is aborted. Alternatively, the joined uncompleted transaction is automatically modified so that the collected attributes are in compliance with the rules in the rules engine, thereby allowing the joined uncompleted transaction to go forward and be applied against the database of the transaction processing system.

公开(公告)号：US10025845B1

公开(公告)日：2018-07-17

申请号：US14962475

申请日：2015-12-08

申请人： Gravic, Inc.

发明人： Paul J. Holenstein ,  John R. Hoffmann ,  Bruce D. Holenstein ,  Wilbur H. Highleyman

IPC分类号： G06F17/30

摘要： A method is provided for logging non-durable attributes of an uncompleted transaction to a persistent storage medium. A tracking engine identifies an uncompleted transaction to be joined, joins the uncompleted transaction, and collects non-durable attributes of the joined uncompleted transaction. The non-durable attributes of the joined uncompleted transaction are made durable by logging them to the persistent storage medium.

公开(公告)号：US09922074B1

公开(公告)日：2018-03-20

申请号：US15701065

申请日：2017-09-11

申请人： Gravic, Inc.

发明人： John R. Hoffmann ,  Bruce D. Holenstein ,  Paul J. Holenstein ,  Wilbur H. Highleyman ,  Dylan Holenstein

IPC分类号： G06F17/30 ,  G06F9/46

CPC分类号： G06F17/30371 ,  G06F9/466 ,  G06F17/30377 ,  G06F17/30581 ,  H04L67/14

摘要： A method is provided to verify the computational results of a transaction processing system utilizing cloud resources in a high-availability and scalable fashion. A transaction is allowed to modify an application's state only if the validity of the result of the processing of the transaction is verified across the majority of the participating child nodes in the cloud. Otherwise, the transaction is aborted.

公开(公告)号：US09760598B1

公开(公告)日：2017-09-12

申请号：US15628354

申请日：2017-06-20

申请人： Gravic, Inc.

发明人： Bruce D. Holenstein ,  John R. Hoffmann ,  Paul J. Holenstein ,  Wilbur H. Highleyman ,  Dylan Holenstein

IPC分类号： G06F17/30

CPC分类号： G06F17/30368 ,  G06F17/30227 ,  G06F17/30371 ,  G06F17/30377 ,  G06F17/3051 ,  G06F17/30575 ,  G06F17/30581 ,  H04L67/14

摘要： A method is provided to verify the computational results of a transaction processing system utilizing cloud resources. A transaction is allowed to modify an application's state only if the validity of the result of the processing of the transaction is verified across the majority of the participating child nodes in the cloud. Otherwise, the transaction is aborted.

公开(公告)号：US09734190B1

公开(公告)日：2017-08-15

申请号：US14961357

申请日：2015-12-07

申请人： Gravic, Inc.

发明人： Bruce D. Holenstein ,  John R. Hoffmann ,  Paul J. Holenstein ,  Wilbur H. Highleyman ,  Dylan Holenstein

IPC分类号： G06F17/30

CPC分类号： G06F17/30377 ,  G06F11/36 ,  G06F17/30371 ,  G06F17/30581

摘要： A method is provided to verify the computational results of a transaction processing system. A transaction is allowed to modify an application's state only if the validity of the result of the processing of the transaction is verified. Otherwise, the transaction is aborted.

公开(公告)号：US12072872B1

公开(公告)日：2024-08-27

申请号：US18480193

申请日：2023-10-03

申请人： Gravic, Inc.

发明人： Paul J. Holenstein ,  Bruce D. Holenstein ,  John R. Hoffmann

IPC分类号： G06F16/23 ,  G06F16/27 ,  G06F16/28

CPC分类号： G06F16/2379 ,  G06F16/27 ,  G06F16/283

摘要： Hung transactions which are completed within a transaction processing system are resolved. The transactions are replicated from a source database to a target database by a replication engine. The hung transaction is incomplete in either the source or the target database. A transaction pattern table is provided that includes a plurality of records, each record being defined by a transaction pattern identifier. Each record includes a transaction pattern and a metric of occurrence of the transaction pattern. A comparison is made of the series of one or more transaction steps or operations of a hung transaction to the transaction patterns in the transaction pattern table, and a subset of transaction patterns in the transaction pattern table are identified that are potential candidates for matching the hung transaction. The hung transaction is categorized using the metric of occurrence of the transaction pattern for each transaction pattern in the subset of transaction patterns. The categorizing predicts when all of the series of one or more transaction steps or operations which have completed in the source database have been replicated. The metric of occurrence of the transaction pattern for each record of the transaction pattern table is (i) a count that is continuously updated based on completed transactions that match the transaction pattern, or (ii) a prepopulated probability of occurrence of the transaction pattern, or (iii) derived from historical data of the transaction pattern. The hung transaction is then processed using the categorization of the hung transaction.

公开(公告)号：US11934424B1

公开(公告)日：2024-03-19

申请号：US18103856

申请日：2023-01-31

申请人： Gravic, Inc.

发明人： Paul J. Holenstein ,  John R. Hoffmann ,  Bruce D. Holenstein ,  Wilbur H. Highleyman

IPC分类号： G06F7/00 ,  G06F3/06 ,  G06F11/20 ,  G06F16/18 ,  G06F16/23 ,  G06F16/27

CPC分类号： G06F16/27 ,  G06F3/0605 ,  G06F3/065 ,  G06F11/2023 ,  G06F11/2097 ,  G06F16/1865 ,  G06F16/2358 ,  G06F16/2365 ,  G06F16/2379

摘要： A method and apparatus are provided for avoiding target database constraint violations in a database replication system. The database replication system includes a source database and a target database, wherein target database transactions automatically abort due to constraint violations. Each database has one or more tables and at least one of the target database tables has one or more constraints. The database replication system replicates source database transactions. For each target database transaction corresponding to a replicated source database transaction, changes made at the source database are replicated to the target database. When it is detected that a replicated change causes a constraint violation as a result of one or more of the target database tables having one or more constraints, the applying of the database change to the target database of the database change is deferred and the database change is posted to an electronic list. Replicated changes that do not cause a constraint violation are immediately applied to the target database. This process is repeated for all of the changes within the replicated source database transaction. The database changes on the electronic list are iterated through by applying the database changes on the electronic list that no longer cause a constraint violation to the target database and removing the applied database changes from the electronic list, and by deferring again the applying of the database changes on the electronic list that still cause a constraint violation and maintaining the deferred database changes on the electronic list. A commit is performed for the target database transaction corresponding to the replicated source database transaction when a commit operation is detected in the replicated source database transaction, and when no database changes remain on the electronic list for the replicated source database transaction. The deferring process avoids the target database transactions automatically aborting due to constraint violations.

公开(公告)号：US11921748B1

公开(公告)日：2024-03-05

申请号：US18529824

申请日：2023-12-05

申请人： Gravic, Inc.

发明人： John R. Hoffmann ,  Paul J. Holenstein ,  Bruce D. Holenstein ,  Dylan R. Holenstein

IPC分类号： G06F16/27 ,  G06F16/23

CPC分类号： G06F16/273 ,  G06F16/2358 ,  G06F16/2379

摘要： An automated method and apparatus are provided for comparing a source database and a target database that are intended to be kept in synchronization with each other. An application processes database changes that are posted to the source database and replicated to the target database. The source database and the target database are made up of blocks of data. Blocks of data from the source database having database changes are collected. These blocks of data are replicated to the target database. Blocks of data from the target database that correspond to the blocks of data from the source database having database changes are read. Representations of the blocks of data from the source database having database changes are compared to representations of blocks of data from the target database that correspond to the blocks of data from the source database having database changes. A corrective action is performed when the comparison indicates that the representations of the blocks of data from the source database having database changes do not match the representations of blocks of data from the target database that correspond to the blocks of data from the source database having database changes. A similar process is performed using “before images” of blocks of data from the source database having database changes and then comparing representations of these “before images” to representations of “current images” of blocks of data from the target database that correspond to the before images of blocks of data from the source database having database changes.

公开(公告)号：US11775509B1

公开(公告)日：2023-10-03

申请号：US18316906

申请日：2023-05-12

申请人： Gravic, Inc.

发明人： John R. Hoffmann ,  Bruce D. Holenstein ,  Paul J. Holenstein

IPC分类号： G06F16/23 ,  G06F16/27 ,  G06F16/28

CPC分类号： G06F16/2379 ,  G06F16/27 ,  G06F16/283

摘要： Methods and apparatus are provided to fully process an incomplete transaction which is incomplete in either a source database or a target database. Transactions are completed within a transaction processing system that includes a non-static application. The non-static application has a transaction mix that varies over its life cycle. The transactions are replicated from the source database to the target database by a replication engine. Each transaction is a series of one or more transaction steps or operations. A plurality of transaction pattern tables are provided, and one of the transaction pattern tables are selected for use in the process depending upon a time of day or a transaction mix.