-
公开(公告)号：US10423498B2
公开(公告)日：2019-09-24
申请号：US14446172
申请日：2014-07-29
申请人： Heping Shang , Ming-Chen Lo , Elena Lora-Gallardo , Xia-ge Dai
发明人： Heping Shang , Ming-Chen Lo , Elena Lora-Gallardo , Xia-ge Dai
摘要： A method for reliable data synchronization within a network is disclosed. The producer system stories data in a persistent data store and produces one or more data updates. The producer system simultaneously transmits the data updates to a consumer system and initiating storage of the data updates at the producer system. When storage of the data updates at the producer system is complete, the producer system transmits a first acknowledgment to the consumer system. The producer system determines whether a second acknowledgment has been received from the consumer system, wherein the second acknowledgment indicates that the consumer system has successfully stored the data updates at the consumer system. In accordance with a determination that the second acknowledgment has been received from the consumer system, the producer system changes the temporary status of the data updates stored at the producer system to a permanent status.
-
公开(公告)号：US20150378845A1
公开(公告)日：2015-12-31
申请号：US14446172
申请日：2014-07-29
申请人： Heping Shang , Ming-Chen Lo , Elena Lora-Gallardo , Xia-ge Dai
发明人： Heping Shang , Ming-Chen Lo , Elena Lora-Gallardo , Xia-ge Dai
摘要： A method for reliable data synchronization within a network is disclosed. The producer system stories data in a persistent data store and produces one or more data updates. The producer system simultaneously transmits the data updates to a consumer system and initiating storage of the data updates at the producer system. When storage of the data updates at the producer system is complete, the producer system transmits a first acknowledgment to the consumer system. The producer system determines whether a second acknowledgment has been received from the consumer system, wherein the second acknowledgment indicates that the consumer system has successfully stored the data updates at the consumer system. In accordance with a determination that the second acknowledgment has been received from the consumer system, the producer system changes the temporary status of the data updates stored at the producer system to a permanent status.
摘要翻译： 公开了一种在网络内可靠数据同步的方法。 生产者系统将持久性数据存储中的数据进行故事并产生一个或多个数据更新。 生产者系统同时将数据更新传送到消费者系统，并在生产者系统上启动数据更新的存储。 当生产者系统的数据更新的存储完成时，生产者系统向消费者系统发送第一确认。 生产者系统确定是否已经从消费者系统接收到第二确认，其中第二确认指示消费者系统已经在消费者系统上成功存储数据更新。 根据从消费者系统接收到第二确认的确定，生产者系统将存储在生产者系统中的数据更新的临时状态改变为永久状态。
-
3.发明授权System, method, and computer program product for determining SQL replication process 有权用于确定SQL复制过程的系统，方法和计算机程序产品公开(公告)号：US08751441B2
公开(公告)日：2014-06-10
申请号：US12183505
申请日：2008-07-31
IPC分类号： G06F17/30
CPC分类号： G06F17/30575
摘要： A system, method, and computer program product are provided for replicating a table in a source database to a target database. In accordance with an embodiment of the present invention, a subscription to the table is defined and a query is executed on the source database. The query is then normalized, and it is determined whether the query would cause semantically appropriate changes to the target database. If so, the normalized query is sent to the target database for execution, in accordance with an additional embodiment of the present invention.
摘要翻译： 提供了一种系统，方法和计算机程序产品，用于将源数据库中的表复制到目标数据库。 根据本发明的实施例，定义对表的订阅，并且在源数据库上执行查询。 然后将查询归一化，并确定查询是否会对目标数据库进行语义上适当的更改。 如果是，则根据本发明的另外的实施例，将归一化查询发送到目标数据库以供执行。
-
4.发明申请System, Method, and Computer Program Product for Determining SQL Replication Process 有权用于确定SQL复制过程的系统，方法和计算机程序产品公开(公告)号：US20100030730A1
公开(公告)日：2010-02-04
申请号：US12183505
申请日：2008-07-31
IPC分类号： G06F17/30
CPC分类号： G06F17/30575
摘要： A system, method, and computer program product are provided for replicating a table in a source database to a target database. In accordance with an embodiment of the present invention, a subscription to the table is defined and a query is executed on the source database. The query is then normalized, and it is determined whether the query would cause semantically appropriate changes to the target database. If so, the normalized query is sent to the target database for execution, in accordance with an additional embodiment of the present invention.
摘要翻译： 提供了一种系统，方法和计算机程序产品，用于将源数据库中的表复制到目标数据库。 根据本发明的实施例，定义对表的订阅，并且在源数据库上执行查询。 然后将查询归一化，并确定查询是否会对目标数据库进行语义上适当的更改。 如果是，则根据本发明的另外的实施例，将归一化查询发送到目标数据库以供执行。
-
公开(公告)号：US09792346B2
公开(公告)日：2017-10-17
申请号：US14462870
申请日：2014-08-19
IPC分类号： G06F17/30
CPC分类号： G06F17/30581 , G06F17/30575
摘要： Disclosed in some examples is a method of database replication, the method including at a Relational Database Management System (RDMS), determining a first replication mode; identifying a triggering event; determining that the triggering event indicates a change in the first replication mode; responsive to determining that the triggering event indicates a change in the first replication mode, determining a second replication mode, the second replication mode being a different replication mode than the first replication mode; identifying a database change made by one or more database tasks; and replicating the database change to an external replication component according to the second replication mode.
-
公开(公告)号：US20150379107A1
公开(公告)日：2015-12-31
申请号：US14462870
申请日：2014-08-19
IPC分类号： G06F17/30
CPC分类号： G06F17/30581 , G06F17/30575
摘要： Disclosed in some examples is a method of database replication, the method including at a Relational Database Management System (RDMS), determining a first replication mode; identifying a triggering event; determining that the triggering event indicates a change in the first replication mode; responsive to determining that the triggering event indicates a change in the first replication mode, determining a second replication mode, the second replication mode being a different replication mode than the first replication mode; identifying a database change made by one or more database tasks; and replicating the database change to an external replication component according to the second replication mode.
摘要翻译： 在一些示例中公开了一种数据库复制的方法，该方法包括在关系数据库管理系统（RDMS），确定第一复制模式; 识别触发事件; 确定所述触发事件指示所述第一复制模式的改变; 响应于确定所述触发事件指示所述第一复制模式中的改变，确定第二复制模式，所述第二复制模式是与所述第一复制模式不同的复制模式; 识别一个或多个数据库任务所做的数据库更改; 并根据第二复制模式将数据库更改复制到外部复制组件。
-
公开(公告)号：US09910733B2
公开(公告)日：2018-03-06
申请号：US14444904
申请日：2014-07-28
CPC分类号： G06F11/1402 , G06F11/006 , G06F11/2038 , G06F11/2097 , G06F17/30581 , G06F2201/80
摘要： Systems and methods are presented for completing transactions in a synchronous replication environment. In some embodiments, a computer-implemented method can include generating in a database server, an identifier to identify a database transaction. The method can also include transmitting the identifier to a replication server; receiving acknowledgement that the identifier is acknowledged by the replication server; storing the transaction in the database server; and executing the transaction after receiving acknowledgement from the replication server and after determining the transaction is stored in the database server; wherein transmitting the identifier to the replication server occurs in parallel with storing the transaction in the database server.
-
8.发明申请公开(公告)号：US20070162421A1
公开(公告)日：2007-07-12
申请号：US11306852
申请日：2006-01-12
IPC分类号： G06F17/30
CPC分类号： G06F16/252 , G06F16/24568
摘要： A SQL language interface for a messaging system, such as IBM MQ, is described. In one embodiment, for example, in a database system, a method is described for providing real-time message support for improved database connectivity, the method comprises steps of: defining Structured Query Language (SQL) extensions having commands that provide message-based connectivity for databases; receiving an SQL statement including a command specifying that a message be sent for communicating particular database data; upon execution of the SQL statement by the database system, creating an outbound message for communicating the particular database data to a destination; and posting the outbound database to a message bus, whereupon the particular database data is communicated asynchronously to the destination.
摘要翻译： 描述了消息传递系统（如IBM MQ）的SQL语言界面。 在一个实施例中，例如，在数据库系统中，描述了一种用于为改进的数据库连接提供实时消息支持的方法，所述方法包括以下步骤：定义具有提供基于消息的连接的命令的结构化查询语言（SQL）扩展 数据库; 接收包含指定发送消息以传送特定数据库数据的命令的SQL语句; 在由数据库系统执行SQL语句时，创建用于将特定数据库数据传送到目的地的出站消息; 并将出站数据库发布到消息总线，由此将特定的数据库数据异步传送到目的地。
-
-
-
-
-
-
-
搜索结果
8 条记录 (耗时 0.025 秒)
