公开(公告)号：US09230002B2

公开(公告)日：2016-01-05

申请号：US12363557

申请日：2009-01-30

申请人： Lik Wong ,  Nimar Arora ,  Lei Gao ,  Thuvan Hoang ,  Haobo Xu

发明人： Lik Wong ,  Nimar Arora ,  Lei Gao ,  Thuvan Hoang ,  Haobo Xu

IPC分类号： G06F17/00 ,  G06F7/00 ,  G06F17/30 ,  G06F9/54

CPC分类号： G06F17/30578 ,  G06F9/544 ,  G06F9/546

摘要： A method for sharing information between a publisher and multiple subscribers is provided. The publisher uses a latch-free, single publisher, multiple subscriber shared queue to share information. Logical change records representing changes made to a database are enqueued in the shared queue as messages in a stream of messages, and subscribers read the logical change records. Subscribers may filter logical change records before sending to apply processes for processing. An identifying property of the source instance of a change encapsulated in a logical change record may be included with each message enqueued.

摘要翻译： 提供了一种在发布者和多个订户之间共享信息的方法。 发行商使用无闩锁的单个发布者，多用户共享队列来共享信息。 表示对数据库所做更改的逻辑更改记录作为消息流中的消息排入队列中，订阅者读取逻辑更改记录。 订阅者可以在发送之前过滤逻辑更改记录以应用进程进行处理。 封装在逻辑更改记录中的更改的源实例的标识属性可以包含在每个排队的消息中。

公开(公告)号：US08838615B2

公开(公告)日：2014-09-16

申请号：US11347081

申请日：2006-02-02

申请人： Neeraj Shodhan ,  Qinqin Wang ,  Lik Wong ,  Joydip Kundu

发明人： Neeraj Shodhan ,  Qinqin Wang ,  Lik Wong ,  Joydip Kundu

IPC分类号： G06F17/30

CPC分类号： G06F17/30368

摘要： Computer-implemented methods and computer systems for automatically managing stored checkpoint data are described. The method includes accessing a first user defined time period. The first user defined time period is related to a plurality of stored checkpoint data, and each checkpoint data of the plurality of stored checkpoint data has an associated storage time. Further, the method includes identifying a first set of checkpoint data having storage times that are within the first user defined time period. Moreover, the method includes identifying a second set of checkpoint data having storage times that are older than the first user defined time period. In addition, the method includes pruning the second set of checkpoint data according to a user specified process in proportion to storage time of each checkpoint data of the second set of checkpoint data. The older stored checkpoint data is more heavily pruned over recent stored checkpoint data.

摘要翻译： 描述了用于自动管理存储的检查点数据的计算机实现的方法和计算机系统。 该方法包括访问第一用户定义的时间段。 第一用户定义的时间段与多个存储的检查点数据相关，并且多个存储的检查点数据的每个检查点数据具有相关联的存储时间。 此外，该方法包括识别具有在第一用户定义的时间段内的存储时间的第一组检查点数据。 此外，该方法包括识别具有比第一用户定义的时间段更早的存储时间的第二组检查点数据。 此外，该方法包括根据用户指定的处理与第二组检查点数据的每个检查点数据的存储时间成比例地修剪第二组检查点数据。 较旧的存储检查点数据比最近存储的检查点数据更严格地修剪。

公开(公告)号：US07925674B2

公开(公告)日：2011-04-12

申请号：US11604529

申请日：2006-11-27

申请人： Byron Wang ,  Nimar Arora ,  Lik Wong ,  Jingwei Wu ,  Jun Yuan

发明人： Byron Wang ,  Nimar Arora ,  Lik Wong ,  Jingwei Wu ,  Jun Yuan

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

CPC分类号： G06F17/30575 ,  G06F11/3409 ,  G06F11/3452 ,  G06F11/3495 ,  G06F2201/80 ,  Y10S707/966

摘要： Systems, methodologies, media, and other embodiments associated with managing of a distributed database are described. One exemplary system embodiment includes an input logic configured to obtain information associated with a distributed database where the distributed database comprises a plurality of databases. An analysis logic analyzes the information obtained from the distributed database to determine performance information associated with the distributed database and, an output logic can provide information regarding the performance information associated with the distributed database.

摘要翻译： 描述了与分布式数据库的管理相关联的系统，方法，介质和其他实施例。 一个示例性系统实施例包括被配置为获得与分布式数据库相关联的信息的输入逻辑，其中分布式数据库包括多个数据库。 分析逻辑分析从分布式数据库获得的信息以确定与分布式数据库相关联的性能信息，并且输出逻辑可以提供关于与分布式数据库相关联的性能信息的信息。

公开(公告)号：US07783601B2

公开(公告)日：2010-08-24

申请号：US11937414

申请日：2007-11-08

申请人： Lik Wong ,  Thuvan Hoang ,  Nimar Singh Arora ,  Jun Yuan

发明人： Lik Wong ,  Thuvan Hoang ,  Nimar Singh Arora ,  Jun Yuan

IPC分类号： G06F17/30

CPC分类号： G06F17/30566

摘要： In accordance with an embodiment of the present invention, a heterogeneous data sharing mechanism comprising a capture process and an apply process may be provided in a database system. The capture process mines or receives, at the source entity, a plurality of records that belong to a plurality of transactions. Here, first records from a first transaction in the plurality of transactions are interleaved with one or more records from one or more different transactions in the plurality of transactions. The capture process orders the plurality of records into a stream of ordered records such that all records that belong to a transaction are stored contiguously in a single block of records in the stream. Subsequently, the capture process sends the stream of ordered records from the source entity to the sink entity. Alternatively, the apply process retrieves the stream of ordered records from the capture process.

摘要翻译： 根据本发明的实施例，可以在数据库系统中提供包括捕获处理和应用处理的异构数据共享机制。 捕获过程在源实体上挖掘或接收属于多个事务的多个记录。 这里，来自多个事务中的第一事务的第一记录与来自多个事务中的一个或多个不同事务的一个或多个记录进行交织。 捕获过程将多个记录命令为有序记录流，使得属于事务的所有记录连续存储在流中的单个记录块中。 随后，捕获进程将有序记录流从源实体发送到汇点实体。 或者，应用进程从捕获进程检索有序记录流。

公开(公告)号：US20100198920A1

公开(公告)日：2010-08-05

申请号：US12363557

申请日：2009-01-30

申请人： Lik Wong ,  Nimar Arora ,  Lei Gao ,  Thuvan Hoang ,  Haobo Xu

发明人： Lik Wong ,  Nimar Arora ,  Lei Gao ,  Thuvan Hoang ,  Haobo Xu

IPC分类号： G06F17/30 ,  G06F15/16

CPC分类号： G06F17/30578 ,  G06F9/544 ,  G06F9/546

摘要： A method for sharing information between a publisher and multiple subscribers is provided. The publisher uses a latch-free, single publisher, multiple subscriber shared queue to share information. Logical change records representing changes made to a database are enqueued in the shared queue as messages in a stream of messages, and subscribers read the logical change records. Subscribers may filter logical change records before sending to apply processes for processing. An identifying property of the source instance of a change encapsulated in a logical change record may be included with each message enqueued.

摘要翻译： 提供了一种在发布者和多个订户之间共享信息的方法。 发行商使用无闩锁的单个发布者，多用户共享队列来共享信息。 表示对数据库所做更改的逻辑更改记录作为消息流中的消息排入队列中，订阅者读取逻辑更改记录。 订阅者可以在发送之前过滤逻辑更改记录以应用进程进行处理。 封装在逻辑更改记录中的更改的源实例的标识属性可以包含在每个排队的消息中。

公开(公告)号：US20090125563A1

公开(公告)日：2009-05-14

申请号：US11937414

申请日：2007-11-08

申请人： Lik Wong ,  Thuvan Hoang ,  Nimar Singh Arora ,  Jun Yuan

发明人： Lik Wong ,  Thuvan Hoang ,  Nimar Singh Arora ,  Jun Yuan

IPC分类号： G06F17/30

CPC分类号： G06F17/30566

摘要： In accordance with an embodiment of the present invention, a heterogeneous data sharing mechanism comprising a capture process and an apply process may be provided in a database system. The capture process mines or receives, at the source entity, a plurality of records that belong to a plurality of transactions. Here, first records from a first transaction in the plurality of transactions are interleaved with one or more records from one or more different transactions in the plurality of transactions. The capture process orders the plurality of records into a stream of ordered records such that all records that belong to a transaction are stored contiguously in a single block of records in the stream. Subsequently, the capture process sends the stream of ordered records from the source entity to the sink entity. Alternatively, the apply process retrieves the stream of ordered records from the capture process.

摘要翻译： 根据本发明的实施例，可以在数据库系统中提供包括捕获处理和应用处理的异构数据共享机制。 捕获过程在源实体上挖掘或接收属于多个事务的多个记录。 这里，来自多个事务中的第一事务的第一记录与来自多个事务中的一个或多个不同事务的一个或多个记录进行交织。 捕获过程将多个记录命令为有序记录流，使得属于事务的所有记录连续存储在流中的单个记录块中。 随后，捕获进程将有序记录流从源实体发送到汇点实体。 或者，应用进程从捕获进程检索有序记录流。

公开(公告)号：US06889229B1

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

申请号：US09968617

申请日：2001-09-28

申请人： Lik Wong ,  James W. Stamos ,  Subramanian Muralidhar

发明人： Lik Wong ,  James W. Stamos ,  Subramanian Muralidhar

IPC分类号： G06F17/30

CPC分类号： G06F17/30581 ,  Y10S707/954 ,  Y10S707/955 ,  Y10S707/99943

摘要： Techniques for replicating a database object of a relational database managed by a database system from a first node on a network to a second node on the network include determining that the database object on the first node includes a user-defined object. A first routine of the database system is invoked. The first routine performs the step of copying the database object to the second node of the network. The first routine copies a name of a user-defined defined type of the user-defined object from the first node to the second node. The first routine also copies a first definition of the user-defined type from the first node to the second node. The first routine then copies a second definition of the database object from the first node to the second node. The second definition includes the name of the user-defined type. These techniques provide the benefits of peer-to-peer replication in a distributed database to users of object-relational databases that including user-defined objects.

摘要翻译： 将由数据库系统管理的关系数据库的数据库对象从网络上的第一节点复制到网络上的第二节点的技术包括确定第一节点上的数据库对象包括用户定义的对象。 调用数据库系统的第一个例程。 第一个例程执行将数据库对象复制到网络的第二个节点的步骤。 第一个例程将用户定义的用户定义的类型的名称从第一个节点复制到第二个节点。 第一例程还将用户定义类型的第一定义从第一节点复制到第二节点。 然后，第一个例程将数据库对象的第二个定义从第一个节点复制到第二个节点。 第二个定义包括用户定义类型的名称。 这些技术为包括用户定义的对象的对象关系数据库的用户提供了分布式数据库中对等复制的好处。

公开(公告)号：US09009104B2

公开(公告)日：2015-04-14

申请号：US12853991

申请日：2010-08-10

申请人： Lik Wong ,  Nimar S. Arora ,  Cristina Schmidt ,  Lei Gao ,  Thuyan Hoang

发明人： Lik Wong ,  Nimar S. Arora ,  Cristina Schmidt ,  Lei Gao ,  Thuyan Hoang

IPC分类号： G06F17/30

CPC分类号： G06F17/30368

摘要： Techniques for replicating data between database systems without taking checkpoints are provided. In an embodiment, a capture process restarts. Upon restarting, the capture process reestablishes an association with an apply process. A particular logical time maintained by the apply process is then communicated to the capture process. Upon receiving the particular logical time, the capture process restarts mining from this particular logical time.

摘要翻译： 提供了在不使用检查点的情况下在数据库系统之间复制数据的技术。 在一个实施例中，捕获过程重新启动。 重新启动后，捕获进程重新建立与应用进程的关联。 然后将应用过程维护的特定逻辑时间传达给捕获进程。 在接收到特定的逻辑时间之后，捕获过程从该特定逻辑时间重新启动挖掘。

公开(公告)号：US20110010392A1

公开(公告)日：2011-01-13

申请号：US12853991

申请日：2010-08-10

申请人： Lik Wong ,  Nimar S. Arora ,  Cristina Schmidt ,  Lei Gao ,  Thuyan Hoang

发明人： Lik Wong ,  Nimar S. Arora ,  Cristina Schmidt ,  Lei Gao ,  Thuyan Hoang

IPC分类号： G06F17/30

CPC分类号： G06F17/30368

摘要： Techniques for replicating data between database systems without taking checkpoints are provided. In an embodiment, a capture process restarts. Upon restarting, the capture process reestablishes an association with an apply process. A particular logical time maintained by the apply process is then communicated to the capture process. Upon receiving the particular logical time, the capture process restarts mining from this particular logical time.

摘要翻译： 提供了在不使用检查点的情况下在数据库系统之间复制数据的技术。 在一个实施例中，捕获过程重新启动。 重新启动后，捕获进程重新建立与应用进程的关联。 然后将应用过程维护的特定逻辑时间传达给捕获进程。 在接收到特定的逻辑时间之后，捕获过程从该特定逻辑时间重新启动挖掘。

公开(公告)号：US07801861B2

公开(公告)日：2010-09-21

申请号：US11366300

申请日：2006-03-01

申请人： Lik Wong ,  Alan J. Demers ,  James W. Stamos

发明人： Lik Wong ,  Alan J. Demers ,  James W. Stamos

IPC分类号： G06F7/00 ,  G06F17/00 ,  G06F15/16

CPC分类号： G06F17/30575 ,  Y10S707/99938 ,  Y10S707/99953

摘要： Techniques for making a replica of a particular group of database objects of a database on a particular node that does not initially have the particular group of database objects include determining whether conditions for copying a full database from a first node are satisfied. If conditions for copying the full database from the first node are not satisfied, then a database-object-copy routine is employed for each database object in the particular group of database objects. If conditions for copying the full database from the first node are satisfied, then a full-database-copy routine for performing a copy of an entire database is employed.

摘要翻译： 用于制作特定节点上数据库的特定数据库对象的副本的技术，该数据库对象最初不具有特定的数据库对象组，包括确定是否满足从第一个节点复制完整数据库的条件。 如果不满足从第一个节点复制完整数据库的条件，则对数据库对象的特定组中的每个数据库对象采用数据库对象复制例程。 如果满足从第一个节点复制完整数据库的条件，则采用用于执行整个数据库副本的全数据库复制例程。