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

1. 发明授权

US06418454B1 Method and mechanism for duration-based management of temporary LOBs 有权
标题翻译：临时LOB基于持续时间管理的方法和机制
公开(公告)号：US06418454B1
公开(公告)日：2002-07-09
申请号：US09322253
申请日：1999-05-28
申请人： Rosanne Park Toohey
发明人： Rosanne Park Toohey
IPC分类号： G06F1200
CPC分类号： G06F17/30318 , Y10S707/99945 , Y10S707/99952
摘要： Disclosed is a method and mechanism for duration-based management of temporary large objects (“LOBs”) in a database system. According to one aspect, temporary LOBs are associated with a duration having a lifespan that corresponds to the lifespan of the temporary LOBs. When the duration ends, the associated temporary LOBs, and any resources allocated to the temporary LOBs, are automatically released. According to another aspect multiple durations of varying, and possibly overlapping lifespans, can exist in the database system. According to yet another aspect, a tree of durations can be created having multiple ancestor and descendant durations.
摘要翻译：公开了一种用于数据库系统中的临时大对象（“LOB”）的基于持续时间管理的方法和机制。根据一个方面，临时LOB与具有对应于临时LOB的寿命的寿命的持续时间相关联。当持续时间结束时，相关联的临时LOB以及分配给临时LOB的任何资源被自动释放。根据另一方面，在数据库系统中可以存在多个变化的可能重叠的寿命的持续时间。根据另一方面，可以创建具有多个祖先和后代持续时间的持续时间树。

2. 发明授权

US06658433B1 Method and mechanism for duration-based management of temporary LOBs 有权
标题翻译：临时LOB基于持续时间管理的方法和机制
公开(公告)号：US06658433B1
公开(公告)日：2003-12-02
申请号：US10133612
申请日：2002-04-25
申请人： Rosanne Park Toohey
发明人： Rosanne Park Toohey
IPC分类号： G06F1200
CPC分类号： G06F17/30318 , Y10S707/99945 , Y10S707/99952
摘要： Disclosed is a method and mechanism for duration-based management of temporary large objects (“LOBs”) in a database system. According to one aspect, temporary LOBs are associated with a duration having a lifespan that corresponds to the lifespan of the temporary LOBs. When the duration ends, the associated temporary LOBs, and any resources allocated to the temporary LOBs, are automatically released. According to another aspect, multiple durations of varying, and possibly overlapping lifespans, can exist in the database system. According to yet another aspect, a tree of durations can be created having multiple ancestor and descendant durations.
摘要翻译：公开了一种用于数据库系统中的临时大对象（“LOB”）的基于持续时间管理的方法和机制。根据一个方面，临时LOB与具有对应于临时LOB的寿命的寿命的持续时间相关联。当持续时间结束时，相关联的临时LOB以及分配给临时LOB的任何资源被自动释放。根据另一方面，在数据库系统中可以存在多个可能重叠的可能重叠的寿命的持续时间。根据另一方面，可以创建具有多个祖先和后代持续时间的持续时间树。

3. 发明授权

US06961729B1 Processing in parallel units of work that perform DML operations on the same spanning rows 有权
标题翻译：在并行的工作单元中处理在相同跨度行上执行DML操作
公开(公告)号：US06961729B1
公开(公告)日：2005-11-01
申请号：US09771292
申请日：2001-01-25
申请人： Rosanne Park Toohey , Jonathan D. Klein , Amit Ganesh , Gary C. Ngai , Dmitry Mikhailovich Potapov
发明人： Rosanne Park Toohey , Jonathan D. Klein , Amit Ganesh , Gary C. Ngai , Dmitry Mikhailovich Potapov
IPC分类号： G06F17/30
CPC分类号： G06F17/30445 , Y10S707/99942 , Y10S707/99944
摘要： A mechanism is described for constructing work granules, where the work granules are constructed independently of whether two or more of the work granules are assigned to operate on a logical storage unit that contains a portion of the same row. A database system maintains transaction control data for data blocks in a manner that avoids self-deadlocks for slaves that follow a row collision protocol. A row collision protocol is a set of rules or steps that slaves follow to ensure that only one subtransaction in a distributed transaction updates a spanning row. Thus, for a particular spanning row, a single subtransaction modifies all the row pieces of the spanning row in any data block containing any row pieces of the spanning row. Consequently, a given data block may be affected by multiple subtransactions in a distributed transaction, one subtransaction affecting a row piece in the data block, another subtransaction affecting other rows in the data block.
摘要翻译：描述了用于构造工作颗粒的机构，其中工作颗粒被构造为独立于是否分配两个或更多个工作颗粒以在包含相同行的一部分的逻辑存储单元上操作。数据库系统以避免针对跟随行冲突协议的从站的自死锁的方式维护数据块的事务控制数据。行冲突协议是一组随后遵循的规则或步骤，以确保分布式事务中只有一个子事务更新跨越行。因此，对于特定的跨越行，单个子迁移修改包含跨越行的任何行的任何数据块中的跨越行的所有行。因此，给定的数据块可能受到分布式事务中的多个子事务的影响，影响数据块中的行块的一个子事务处理，影响数据块中的其他行的另一个子事务处理。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式