专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US07680793B2 Commit-time ordered message queue supporting arbitrary read and dequeue patterns from multiple subscribers 有权
标题翻译：提交时间有序消息队列支持来自多个订户的任意读取和出列模式
公开(公告)号：US07680793B2
公开(公告)日：2010-03-16
申请号：US11245863
申请日：2005-10-07
申请人： Lik Wong , Hung Tran , James W. Stamos
发明人： Lik Wong , Hung Tran , James W. Stamos
IPC分类号： G06F17/30
CPC分类号： G06F17/30371 , Y10S707/99938
摘要： Data consistency in the context of information sharing requires maintenance of dependencies among information being shared. Transactional dependency ordering is implemented in a database system message queue, by associating a unique system commit time with each transactional message group. Read consistency is implemented in such a queue by allowing only messages with a fully determined order to be visible. A fully determined order is implemented through use of a high watermark, which guarantees that future transactions, for which messages are entering the queue, have commit times that are greater than the current high watermark. Therefore, only messages below the current high watermark are visible and can be dequeued, with no chance of other new messages enqueuing below the current high watermark.
摘要翻译：信息共享上下文中的数据一致性需要维护正在共享的信息之间的依赖关系。通过将唯一的系统提交时间与每个事务消息组相关联，在数据库系统消息队列中实现事务依赖性排序。通过仅允许具有完全确定的顺序的消息可见，在这样的队列中实现读取一致性。通过使用高水印实现完全确定的顺序，这保证了消息进入队列的未来事务具有大于当前高水印的提交时间。因此，只有低于当前高水印的消息才可见，并且可以出队，没有其他新消息排入低于当前高水印的机会。

2. 发明授权

US07523143B2 Mapping source logical clock into destination logical clock in a distributed system 有权
标题翻译：将源逻辑时钟映射到分布式系统中的目标逻辑时钟
公开(公告)号：US07523143B2
公开(公告)日：2009-04-21
申请号：US10909985
申请日：2004-08-02
申请人： Lik Wong , Edwina Lu , James W. Stamos
发明人： Lik Wong , Edwina Lu , James W. Stamos
IPC分类号： G07F17/30 , G06F15/16
CPC分类号： G06F17/30575 , Y10S707/99953
摘要： A source database system sends information to a destination database system, and each database system generates a separate set of sequence information. A mapping is maintained between the two sets of sequence information. Using the mapping, the destination database system may be used to restore changes lost at the source database system without reinstating the source database. Additionally, queries associated with a particular point in a sequence associated with the sequence information of the source database may be redirected to the destination database, and the destination database system may serve as a logical standby for the source database system. A variety of methods of maintaining and/or extracting the mapping information are disclosed.
摘要翻译：源数据库系统向目标数据库系统发送信息，每个数据库系统生成一组单独的序列信息。在两组序列信息之间保持映射。使用映射，目标数据库系统可用于恢复源数据库系统丢失的更改，而不会恢复源数据库。此外，与源数据库的序列信息相关联的序列中的特定点相关联的查询可以被重定向到目的地数据库，并且目的地数据库系统可以用作源数据库系统的逻辑备用。公开了维护和/或提取映射信息的各种方法。

3. 发明授权

US06889229B1 Techniques for peer-to-peer replication of objects in a relational database 有权
标题翻译：用于关系数据库中对象的对等复制的技术
公开(公告)号：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.
摘要翻译：将由数据库系统管理的关系数据库的数据库对象从网络上的第一节点复制到网络上的第二节点的技术包括确定第一节点上的数据库对象包括用户定义的对象。调用数据库系统的第一个例程。第一个例程执行将数据库对象复制到网络的第二个节点的步骤。第一个例程将用户定义的用户定义的类型的名称从第一个节点复制到第二个节点。第一例程还将用户定义类型的第一定义从第一节点复制到第二节点。然后，第一个例程将数据库对象的第二个定义从第一个节点复制到第二个节点。第二个定义包括用户定义类型的名称。这些技术为包括用户定义的对象的对象关系数据库的用户提供了分布式数据库中对等复制的好处。

4. 发明授权

US07801861B2 Techniques for replicating groups of database objects 有权
标题翻译：复制数据库对象组的技术
公开(公告)号：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.
摘要翻译：用于制作特定节点上数据库的特定数据库对象的副本的技术，该数据库对象最初不具有特定的数据库对象组，包括确定是否满足从第一个节点复制完整数据库的条件。如果不满足从第一个节点复制完整数据库的条件，则对数据库对象的特定组中的每个数据库对象采用数据库对象复制例程。如果满足从第一个节点复制完整数据库的条件，则采用用于执行整个数据库副本的全数据库复制例程。

5. 发明授权

US07039669B1 Techniques for adding a master in a distributed database without suspending database operations at extant master sites 有权
标题翻译：在分布式数据库中添加主机的技术，而不会在现有主站点上挂起数据库操作
公开(公告)号：US07039669B1
公开(公告)日：2006-05-02
申请号：US09967856
申请日：2001-09-28
申请人： Lik Wong , Alan J. Demers , James W. Stamos
发明人： Lik Wong , Alan J. Demers , James W. Stamos
IPC分类号： G06F17/30
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 transferring description data from a first node to the particular node during a first time period. The description data describes the particular group of database objects at a first time. The first time period begins at the first time and ends at a second time. During the first time period, a request from a user of the database to perform an operation involving particular data in the particular group of database objects is processed.
摘要翻译：用于制作特定节点上数据库的特定数据库对象的副本的技术，该特定数据库对象最初不具有特定的数据库对象组包括在第一时间段内将描述数据从第一节点传送到特定节点。描述数据在第一时间描述数据库对象的特定组。第一个时间段从第一个时间开始，第二个时间结束。在第一时间段期间，处理来自数据库的用户的请求以执行涉及数据库对象的特定组中的特定数据的操作。

6. 发明授权

US07610314B2 Online tablespace recovery for export 有权
标题翻译：用于导出的在线表空间恢复
公开(公告)号：US07610314B2
公开(公告)日：2009-10-27
申请号：US11245589
申请日：2005-10-07
申请人： Benny Souder , James Stamos , Hung Tran , Francisco Sanchez , Lik Wong
发明人： Benny Souder , James Stamos , Hung Tran , Francisco Sanchez , Lik Wong
IPC分类号： G06F12/00 , G06F17/30
CPC分类号： G06F17/30575 , Y10S707/99931 , Y10S707/99953
摘要： To export source tablespaces, an auxiliary database system is created and started with a minimum configuration. Copies of versions of the source tablespaces are restored from database backups to the auxiliary database system. A copy of a version of a tablespace is referred to herein as a tablespace instance. The tablespace instances restored from database backups are recovered to a particular point-in-time. A script is then generated. The script can be executed by a database server of the destination database to import the tablespace instances.
摘要翻译：要导出源表空间，将创建一个辅助数据库系统，并以最小配置启动。源表空间的版本副本从数据库备份恢复到辅助数据库系统。表空间版本的副本在这里称为表空间实例。从数据库备份还原的表空间实例将恢复到特定的时间点。然后生成一个脚本。脚本可以由目标数据库的数据库服务器执行，以导入表空间实例。

7. 发明申请

US20070083569A1 Commit-time ordered message queue supporting arbitrary read and dequeue patterns from multiple subscribers 有权
标题翻译：提交时间有序消息队列支持来自多个订户的任意读取和出列模式
公开(公告)号：US20070083569A1
公开(公告)日：2007-04-12
申请号：US11245863
申请日：2005-10-07
申请人： Lik Wong , Hung Tran , James Stamos
发明人： Lik Wong , Hung Tran , James Stamos
IPC分类号： G06F17/30
CPC分类号： G06F17/30371 , Y10S707/99938
摘要： Data consistency in the context of information sharing requires maintenance of dependencies among information being shared. Transactional dependency ordering is implemented in a database system message queue, by associating a unique system commit time with each transactional message group. Read consistency is implemented in such a queue by allowing only messages with a fully determined order to be visible. A fully determined order is implemented through use of a high watermark, which guarantees that future transactions, for which messages are entering the queue, have commit times that are greater than the current high watermark. Therefore, only messages below the current high watermark are visible and can be dequeued, with no chance of other new messages enqueuing below the current high watermark.
摘要翻译：信息共享上下文中的数据一致性需要维护正在共享的信息之间的依赖关系。通过将唯一的系统提交时间与每个事务消息组相关联，在数据库系统消息队列中实现事务依赖性排序。通过仅允许具有完全确定的顺序的消息可见，在这样的队列中实现读取一致性。通过使用高水印实现完全确定的顺序，这保证了消息进入队列的未来事务具有大于当前高水印的提交时间。因此，只有低于当前高水位的消息才可见，并且可以出队，没有其他新消息排入低于当前高水印的机会。

8. 发明申请

US20070083563A1 Online tablespace recovery for export 有权
标题翻译：用于导出的在线表空间恢复
公开(公告)号：US20070083563A1
公开(公告)日：2007-04-12
申请号：US11245589
申请日：2005-10-07
申请人： Benny Souder , James Stamos , Hung Tran , Francisco Sanchez , Lik Wong
发明人： Benny Souder , James Stamos , Hung Tran , Francisco Sanchez , Lik Wong
IPC分类号： G06F17/30
CPC分类号： G06F17/30575 , Y10S707/99931 , Y10S707/99953
摘要： To export source tablespaces, an auxiliary database system is created and started with a minimum configuration. Copies of versions of the source tablespaces are restored from database backups to the auxiliary database system. A copy of a version of a tablespace is referred to herein as a tablespace instance. The tablespace instances restored from database backups are recovered to a particular point-in-time. A script is then generated. The script can be executed by a database server of the destination database to import the tablespace instances.
摘要翻译：要导出源表空间，将创建一个辅助数据库系统，并以最小配置启动。源表空间的版本副本从数据库备份恢复到辅助数据库系统。表空间版本的副本在这里称为表空间实例。从数据库备份还原的表空间实例将恢复到特定的时间点。然后生成一个脚本。脚本可以由目标数据库的数据库服务器执行，以导入表空间实例。

9. 发明申请

US20060224626A1 Versioned file group repository 审中-公开
标题翻译：版本化的文件组存储库
公开(公告)号：US20060224626A1
公开(公告)日：2006-10-05
申请号：US11099203
申请日：2005-04-04
申请人： Anand Lakshminath , Benny Souder , James Stamos , Lik Wong , Hung Tran
发明人： Anand Lakshminath , Benny Souder , James Stamos , Lik Wong , Hung Tran
IPC分类号： G06F17/00
CPC分类号： G06F16/1873
摘要： Techniques are provided for managing electronic items by storing, within a file group repository, metadata that identifies (a) a plurality of file groups, (b) for each file group, a set of one or more file group versions for the file group, and (c) for each file group version of each file group, a set of one or more items that belong to the version of the file group. Once the metadata has been established, queries may be executed against the metadata to request identification of items that belong to a particular version of a particular file group. This file group framework may be used in a variety of contexts, including the management of a centralized tablespace repository, and periodic purging of versions of file collections, where the files within the collections may be spread across multiple repositories.
摘要翻译：提供了通过在文件组存储库内存储标识（a）多个文件组的元数据（b）针对每个文件组的文件组的一个或多个文件组版本的集合来管理电子商品的技术，和（c）对于每个文件组的每个文件组版本，属于文件组版本的一个或多个项目的集合。一旦建立了元数据，可以针对元数据执行查询，以请求对属于特定文件组的特定版本的项目的标识。该文件组框架可以用于各种上下文中，包括管理集中式表空间存储库，以及定期清除文件集合的版本，集合中的文件可以分布在多个存储库中。

10. 发明授权

US08799213B2 Combining capture and apply in a distributed information sharing system 有权
标题翻译：结合捕获并应用于分布式信息共享系统
公开(公告)号：US08799213B2
公开(公告)日：2014-08-05
申请号：US11831478
申请日：2007-07-31
申请人： Lik Wong , Nimar S. Arora , Anand Lakshminath , Jingwei Wu , Lei Gao , Thuvan Hoang
发明人： Lik Wong , Nimar S. Arora , Anand Lakshminath , Jingwei Wu , Lei Gao , Thuvan Hoang
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30575
摘要： In accordance with an embodiment of the present invention, an information sharing mechanism comprising a memory structure may be provided in a database system. In an embodiment, mined information transferred by a capture process to an associated apply process can be written into the memory structure without taking any latch. Similarly, the mined information can be read by the apply process from the memory structure without taking any latch. The capture and apply processes may work cooperatively to establish a safe point in log mining under various circumstances such as in an initial startup state, in a steady state, in a process restart scenario in the middle of information sharing. In some embodiments, the information sharing mechanism supports both checkpoint-free and checkpoint modes of log mining by the capture process. In addition, both the capture process and the apply process may employ an eager apply approach to increase processing capacity.
摘要翻译：根据本发明的实施例，可以在数据库系统中提供包括存储器结构的信息共享机制。在一个实施例中，通过捕获处理传送到相关联的应用进程的挖掘信息可以被写入存储器结构而不采取任何锁存。类似地，可以通过应用处理从存储器结构读取挖掘的信息，而不采取任何锁存。捕获和应用过程可以协同工作，在各种情况下在日志挖掘中建立安全点，例如在初始启动状态，稳定状态下，在信息共享过程中的过程重新启动情况。在一些实施例中，信息共享机制通过捕获过程支持日志挖掘的无检点和检查点模式。此外，捕获过程和应用过程都可以采用渴望应用的方法来增加处理能力。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式