公开(公告)号：US08868504B2

公开(公告)日：2014-10-21

申请号：US12030094

申请日：2008-02-12

申请人： Rohan Aranha ,  Paul Tuck ,  John Ernest Miller ,  Chih-Ping Wang ,  Marie-Anne Neimat ,  Susan Sokeng Cheung

发明人： Rohan Aranha ,  Paul Tuck ,  John Ernest Miller ,  Chih-Ping Wang ,  Marie-Anne Neimat ,  Susan Sokeng Cheung

IPC分类号： G06F17/30 ,  G06F17/00

CPC分类号： G06F17/30289

摘要： A system includes an active node and a standby node and zero or more replica nodes. Each of the nodes includes a database system, such as an in-memory database system. Client updates applied to the active node are written through to the standby node, and the standby node writes the updates through to a primary database and updates the replica nodes. Commit ticket numbers tag entries in transaction logs and are used to facilitate recovery if either of the active node or the standby node fails. Updates applied to the primary database are autorefreshed to the active node and written through by the active node to the standby node which propagates the updates to the replica nodes. Bookmarks are used to track updated records of the primary database and are used to facilitate recovery if either of the active node or the standby node fails.

摘要翻译： 系统包括主动节点和备用节点以及零个或多个副本节点。 每个节点包括数据库系统，诸如内存中数据库系统。 应用于主动节点的客户端更新被写入到备用节点，备用节点将更新写入主数据库，并更新副本节点。 提交票号在事务日志中标记条目，并且如果活动节点或备​​用节点中的任一个失败，则用于促进恢复。 应用于主数据库的更新将自动刷新到活动节点，并由主动节点写入到将更新传播到副本节点的备用节点。 书签用于跟踪主数据库的更新记录，并且如果主动节点或备​​用节点中的任一个失败，则用于促进恢复。

公开(公告)号：US20080222111A1

公开(公告)日：2008-09-11

申请号：US12030113

申请日：2008-02-12

申请人： Chi Kim Hoang ,  Chih-Ping Wang ,  John Ernest Miller ,  Marie-Anne Neimat ,  Susan Sokeng Cheung

发明人： Chi Kim Hoang ,  Chih-Ping Wang ,  John Ernest Miller ,  Marie-Anne Neimat ,  Susan Sokeng Cheung

IPC分类号： G06F7/06

CPC分类号： G06F16/21

摘要： A fully transactional mid-tier database system services database transactions. A cache manager dynamically loads database entries from a fully transactional backend-tier database system into the mid-tier database system according to the received database transactions. Time based aging or usage based aging can be assigned to selected tables in the mid-tier database system. Database entries contained in the selected tables are then automatically removed according to assigned aging constraints.

摘要翻译： 完全事务中层数据库系统服务数据库事务。 高速缓存管理器根据接收的数据库事务，将数据库条目从完全事务后端数据库系统动态加载到中间层数据库系统中。 基于时间的老化或基于使用的老化可以分配给中间层数据库系统中的选定表。 然后根据分配的老化约束自动删除选定表中包含的数据库条目。

公开(公告)号：US20080222159A1

公开(公告)日：2008-09-11

申请号：US12030094

申请日：2008-02-12

申请人： Rohan Aranha ,  Paul Tuck ,  John Ernest Miller ,  Chih-Ping Wang ,  Marie-Anne Neimat ,  Susan Sokeng Cheung

发明人： Rohan Aranha ,  Paul Tuck ,  John Ernest Miller ,  Chih-Ping Wang ,  Marie-Anne Neimat ,  Susan Sokeng Cheung

IPC分类号： G06F17/30

CPC分类号： G06F17/30289

摘要： A system includes an active node and a standby node and zero or more replica nodes. Each of the nodes includes a database system, such as an in-memory database system. Client updates applied to the active node are written through to the standby node, and the standby node writes the updates through to a primary database and updates the replica nodes. Commit ticket numbers tag entries in transaction logs and are used to facilitate recovery if either of the active node or the standby node fails. Updates applied to the primary database are autorefreshed to the active node and written through by the active node to the standby node which propagates the updates to the replica nodes. Bookmarks are used to track updated records of the primary database and are used to facilitate recovery if either of the active node or the standby node fails.

摘要翻译： 系统包括主动节点和备用节点以及零个或多个副本节点。 每个节点包括数据库系统，诸如内存中数据库系统。 应用于主动节点的客户端更新被写入备用节点，备用节点将更新写入主数据库，并更新副本节点。 提交票号在事务日志中标记条目，并且如果活动节点或备​​用节点中的任一个失败，则用于促进恢复。 应用于主数据库的更新将自动刷新到活动节点，并由主动节点写入到将更新传播到副本节点的备用节点。 书签用于跟踪主数据库的更新记录，并且如果主动节点或备​​用节点中的任一个失败，则用于促进恢复。