-
公开(公告)号:US10922186B1
公开(公告)日:2021-02-16
申请号:US16916815
申请日:2020-06-30
申请人: Gravic, Inc.
摘要: A system and method of backing up an online database to a storage device is provided wherein the online database is actively changed by one or more applications. The backed up online database is then subsequently restored. The online database is backed up by copying the online database to the storage device, and during the copying of the online database, writing changes that are made to the online database to a change log for the portion of the online database that has already been copied to the storage device, and not writing changes that are made to the online database to the change log for the portion of the online database that has not yet been copied to the storage device. The online database is then restored by loading the backed up online database to a target database, and applying the changes in the change log to the target database by rolling the change log backwards, and applying only the most recent change contained in the change log for each data item in the target database.
-
公开(公告)号:US10817535B1
公开(公告)日:2020-10-27
申请号:US16282691
申请日:2019-02-22
申请人: Gravic, Inc.
摘要: An extractor and an applier of a database replication system are configured to perform the functions of resolving target database constraint violations for replicated database transactions. The extractor replicates changes made at the source database to the target database. An applier immediately applies the changes to the target database that do not cause a constraint violation. The applier also performs the remaining functions, including detecting database changes that cause constraint violations, subsequent processing of these detected database changes, and performing a commit for the database transaction when the constraint violations are resolved.
-
3.
公开(公告)号:US10706041B1
公开(公告)日:2020-07-07
申请号:US14619804
申请日:2015-02-11
申请人: Gravic, Inc.
摘要: Methods and apparatus are provided to categorize and process an incomplete transaction. 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. An incomplete transaction is automatically compared to the transaction patterns in the table and a subset of transaction patterns in the table are identified that are potential candidates for matching the incomplete transaction. The incomplete transaction is categorized using the metric of occurrence of the transaction pattern for each transaction pattern in the subset. The incomplete transaction is then processed using the categorization of the incomplete transaction.
-
公开(公告)号:US10705920B1
公开(公告)日:2020-07-07
申请号:US16170762
申请日:2018-10-25
申请人: Gravic, Inc.
摘要: A system and method of backing up an online database to a storage device is provided wherein the online database is actively changed by one or more applications. The backed up online database is then subsequently restored. The online database is backed up by copying the online database to the storage device, and during the copying of the online database, writing changes that are made to the online database to a change log for the portion of the online database that has already been copied to the storage device, and not writing changes that are made to the online database to the change log for the portion of the online database that has not yet been copied to the storage device. The online database is then restored by loading the backed up online database to a restore database, and applying the changes in the change log to the restore database.
-
5.
公开(公告)号:US08903779B1
公开(公告)日:2014-12-02
申请号:US14199534
申请日:2014-03-06
申请人: Gravic, Inc.
发明人: Paul J. Holenstein , John R. Hoffmann , Jonathan M. Ziegler , Bruce D. Holenstein , Wilbur H. Highleyman
CPC分类号: G06F11/1469 , G06F11/1456 , G06F11/1471 , G06F17/30368 , G06F2201/80
摘要: A corrupted database is returned to a correct state by rolling forward or backward through a change queue and applying changes to the database in a selective manner. Changes that did not cause the corruption are applied without modification when rolling forward or are skipped when rolling backward. Changes that caused corruption are addressed when rolling forward, such as by being ignored or modified and then applied. Changes that caused corruption are corrected when rolling backward.
摘要翻译: 通过改变队列向前或向后滚动并以选择性方式对数据库应用更改,将损坏的数据库返回到正确的状态。 不会导致损坏的更改在向前滚动时被应用而不进行修改,或者在向后滚动时被跳过。 导致损坏的更改在向前滚动时得到解决,例如被忽略或修改然后应用。 导致损坏的更改会在向后滚动时更正。
-
公开(公告)号:US11775560B1
公开(公告)日:2023-10-03
申请号:US17466212
申请日:2021-09-03
申请人: Gravic, Inc.
CPC分类号: G06F16/273 , G06F16/2358 , G06F16/2379
摘要: An automated method and system 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 transactions that are posted to the source database and replicated to the target database. Before images of changes made to the source database resulting from transactions posted to the source database are collected into a first change log and then replicated to the target database. Before images of changes made to the target database resulting from replication are collected into a second change log. Representations of the before images of changes in the first change log are compared with representations of the before images of changes in the second change log that correspond to the same respective changes that were made to the source database and replicated to the target database. Corrective action is performed when the comparison indicates that the representations of the before images of changes in the first change log do not match the representations of the before images of changes in the second change log.
-
公开(公告)号:US11120047B1
公开(公告)日:2021-09-14
申请号:US16548012
申请日:2019-08-22
申请人: Gravic, Inc.
摘要: An automated method and system 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 transactions that are posted to the source database and replicated to the target database. Changes made to the source database resulting from transactions posted to the source database are collected into a first change log and then replicated to the target database. Changes made to the target database resulting from replication are collected into a second change log. The changes in the first change log are compared with representations of the changes in the second change log that correspond to the same respective changes that were made to the source database and replicated to the target database. Corrective action is performed when the comparison indicates that the representations of the changes in the first change log do not match the representations of the changes in the second change log.
-
公开(公告)号:US10452648B1
公开(公告)日:2019-10-22
申请号:US16417041
申请日:2019-05-20
申请人: Gravic, Inc.
发明人: Bruce D. Holenstein , John R. Hoffmann , Paul J. Holenstein , Wilbur H. Highleyman , Dylan R. Holenstein
摘要: A method is provided for ensuring transactional integrity of a system that includes a first subsystem and a second subsystem. Each of the subsystems receive the same request to process a transaction. An indicia engine at each subsystem computes indicia of the outcome of the processing of the same request. The computed indicia from each of the subsystems is compared. An action is completed at one of the subsystems when the computed indicia does not match. The action completed at one of the subsystems is one or more of issuing a database rollback on one of the subsystems, executing self-diagnostics on one of the subsystems, shutting down one of the subsystems, taking one of the subsystems offline, aborting the transaction executing on one of the subsystems, and generating an error indication for one of the subsystems.
-
公开(公告)号:US10176243B1
公开(公告)日:2019-01-08
申请号:US16033335
申请日:2018-07-12
申请人: Gravic, Inc.
IPC分类号: G06F17/30
摘要: Systems and methods are provided to log changes to a database on a transaction processing system. A tracking engine identifies an uncompleted transaction to be joined, joins the uncompleted transaction, and collects non-durable attributes of the joined uncompleted transaction. A logging engine makes durable the non-durable attributes by logging the non-durable attributes.
-
10.
公开(公告)号:US10095730B1
公开(公告)日:2018-10-09
申请号:US15890844
申请日:2018-02-07
申请人: Gravic, Inc.
发明人: John R. Hoffmann , Bruce D. Holenstein , Paul J. Holenstein , Wilbur H. Highleyman , Dylan Holenstein
摘要: An apparatus is provided to verify the computational results of a transaction processing system utilizing a parent node and a plurality of child nodes in a high-availability and scalable fashion. A transaction is executed in an identical manner in two or more participating child nodes, and the transaction is allowed to modify an application's state (e.g., commit) only if the validity of the result of the processing of the transaction is verified across the majority of the participating child nodes. Otherwise, the transaction is aborted. The child nodes may exist within a cloud provider or across multiple cloud providers.
-
-
-
-
-
-
-
-
-