公开(公告)号：US20090193059A1

公开(公告)日：2009-07-30

申请号：US12010414

申请日：2008-01-24

申请人： John Wall ,  John Paul Loeser ,  Khoa Tran ,  Marius Dan Stroe

发明人： John Wall ,  John Paul Loeser ,  Khoa Tran ,  Marius Dan Stroe

IPC分类号： G06F12/00

CPC分类号： G06F11/2094 ,  G06F11/2097 ,  G06F17/30575

摘要： A distributed replicated database system having a plurality of federated database systems and methods of updating and reading database records from the distributed replicated database system are disclosed. Each federated database system contains a complete copy of a database. Moreover, each federated database system comprises at least one server divided into at least one logical partition. A logical partition contains records of the database and all logical partitions in a federated database system cumulatively stores all records in the database. A data structure is maintained which indicates whether the records in a given logical partition are up-to-date. When an update or insert request is received, the data structure is modified to indicate that all logical partitions storing a copy of the record to be updated, or partitions into which the new record is to be inserted, are not up-to-date. When the record has been updated or inserted, the data structure is modified to indicate that the logical partition storing the record is up-to-date. When a read request is received, the record is read from an up-to-date logical partition storing the record.

摘要翻译： 公开了具有多个联合数据库系统的分布式复制数据库系统和从分布式复制数据库系统更新和读取数据库记录的方法。 每个联合数据库系统都包含数据库的完整副本。 此外，每个联合数据库系统包括划分为至少一个逻辑分区的至少一个服务器。 逻辑分区包含数据库的记录和联合数据库系统中的所有逻辑分区累积存储数据库中的所有记录。 维护一个数据结构，指示给定逻辑分区中的记录是否是最新的。 当接收到更新或插入请求时，修改数据结构以指示存储要更新的记录副本的所有逻辑分区，或新记录要插入的分区不是最新的。 当记录被更新或插入时，数据结构被修改以指示存储记录的逻辑分区是最新的。 当接收到读取请求时，从存储该记录的最新的逻辑分区读取该记录。

公开(公告)号：US09652346B2

公开(公告)日：2017-05-16

申请号：US12010414

申请日：2008-01-24

申请人： John Wall ,  John Paul Loeser ,  Khoa Tran ,  Marius Dan Stroe

发明人： John Wall ,  John Paul Loeser ,  Khoa Tran ,  Marius Dan Stroe

IPC分类号： G06F17/30 ,  G06F11/20

CPC分类号： G06F11/2094 ,  G06F11/2097 ,  G06F17/30575

摘要： A distributed replicated database system having a plurality of federated database systems and methods of updating and reading database records from the distributed replicated database system are disclosed. Each federated database system contains a complete copy of a database. Moreover, each federated database system comprises at least one server divided into at least one logical partition. A logical partition contains records of the database and all logical partitions in a federated database system cumulatively stores all records in the database. A data structure is maintained which indicates whether the records in a given logical partition are up-to-date. When an update or insert request is received, the data structure is modified to indicate that all logical partitions storing a copy of the record to be updated, or partitions into which the new record is to be inserted, are not up-to-date. When the record has been updated or inserted, the data structure is modified to indicate that the logical partition storing the record is up-to-date. When a read request is received, the record is read from an up-to-date logical partition storing the record.