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

1. 发明授权

US06341340B1 Transitioning ownership of data items between ownership groups 有权
标题翻译：在所有权组之间转换数据项目的所有权
公开(公告)号：US06341340B1
公开(公告)日：2002-01-22
申请号：US09222593
申请日：1998-12-28
申请人： Alex Tsukerman , Gary C. Ngai , Gianfranco Putzolu , J. William Lee
发明人： Alex Tsukerman , Gary C. Ngai , Gianfranco Putzolu , J. William Lee
IPC分类号： G06F1200
CPC分类号： G06F17/30575
摘要： A database or some portion thereof is partitioned into ownership groups. Each ownership group is assigned one or more database servers as owners of the ownership group. The database servers that are assigned as owners of an ownership group are treated as the owners of all data items that belong to the ownership group. That is, they are allowed to directly access the data items within the ownership group, while other database servers are not allowed to directly access those data items. A mechanism is provided for transitioning ownership of a data item. Ownership is transferred by disabling access to the data item, waiting for all transactions that have made changes to the data item to either commit or abort, changing data that indicates ownership of the data item from a first owner to a second owner, and enabling access to the data item.
摘要翻译：数据库或其一部分被划分为所有权组。每个所有权组被分配一个或多个数据库服务器作为所有权组的所有者。分配为所有者组的所有者的数据库服务器将被视为属于所有权组的所有数据项的所有者。也就是说，它们被允许直接访问所有权组内的数据项，而其他数据库服务器不允许直接访问这些数据项。提供了一种转换数据项所有权的机制。通过禁用对数据项的访问，等待对数据项进行更改的所有事务进行提交或中止，将数据项的所有权从第一个所有者更改为第二个所有者，并启用访问权限到数据项。

2. 发明授权

US07526508B2 Self-managing database architecture 有权
标题翻译：自我管理数据库架构
公开(公告)号：US07526508B2
公开(公告)日：2009-04-28
申请号：US10934076
申请日：2004-09-03
申请人： Leng Leng Tan , Gianfranco Putzolu , Richard Sarwal , Alex Tsukerman , Gary C. Ngai , Graham Stephen Wood , Karl Dias , Mark Ramacher , Benoit Dageville , Mohamed Ziauddin , Tirthankar Lahiri , Sujatha Muthulingam , Vishwanath Karra , Francisco Sanchez , Hsiao-Te Su , Wanli Yang , Vasudha Krishnaswamy , Sushil Kumar
发明人： Leng Leng Tan , Gianfranco Putzolu , Richard Sarwal , Alex Tsukerman , Gary C. Ngai , Graham Stephen Wood , Karl Dias , Mark Ramacher , Benoit Dageville , Mohamed Ziauddin , Tirthankar Lahiri , Sujatha Muthulingam , Vishwanath Karra , Francisco Sanchez , Hsiao-Te Su , Wanli Yang , Vasudha Krishnaswamy , Sushil Kumar
IPC分类号： G06F17/30
CPC分类号： G06F17/30289 , Y10S707/99932 , Y10S707/99945
摘要： An intelligent database infrastructure wherein the management of all database components is performed by and within the database itself by integrating management of various components with a central management control. Each individual database component, as well as the central management control, is self-managing. A central management control module integrates and interacts with the various database components. The database is configured to automatically tune to varying workloads and configurations, correct or alert about bad conditions, and advise on ways to improve overall system performance.
摘要翻译：智能数据库基础设施，其中所有数据库组件的管理由数据库本身和数据库本身进行管理，通过集中管理各种组件与中央管理控制。每个单独的数据库组件以及中央管理控制都是自我管理的。中央管理控制模块集成并与各种数据库组件进行交互。数据库被配置为自动调整到不同的工作负载和配置，纠正或警告恶劣条件，并提供有关如何提高整体系统性能的建议。

3. 发明授权

US06804671B1 Pluggable tablespaces for database systems 有权
标题翻译：数据库系统的可插拔表空间
公开(公告)号：US06804671B1
公开(公告)日：2004-10-12
申请号：US10353381
申请日：2003-01-28
申请人： Juan R. Loaiza , Hasan Rizvi , J. William Lee , William H. Bridge, Jr. , Jonathan D. Klein , Alex Tsukerman , Gianfranco Putzolu
发明人： Juan R. Loaiza , Hasan Rizvi , J. William Lee , William H. Bridge, Jr. , Jonathan D. Klein , Alex Tsukerman , Gianfranco Putzolu
IPC分类号： G06F1730
CPC分类号： G06F17/30952 , Y10S707/959 , Y10S707/99937 , Y10S707/99942 , Y10S707/99955
摘要： A pluggable tablespace is enabled by logically partitioning a database into a set of tablespaces and storing all of the tablespaces disk pointers in tablespace-relative format. A pluggable set of tablespaces is unplugged by generating the associated metadata, and making a binary copy of the tablespaces. The pluggable set of tablespaces is plugged into a target database by making the pluggable set accessible to the target database and incorporating the associated metadata, without patching any of the disk pointers.
摘要翻译：通过将数据库逻辑分区为一组表空间并以表空间相对格式存储所有表空间磁盘指针来启用可插入表空间。通过生成相关联的元数据并创建表空间的二进制副本，可以拔掉一组可插拔的表空间。可插入的表空间集合通过使可插入集合可访问目标数据库并结合相关联的元数据而插入到目标数据库中，而无需修补任何磁盘指针。

4. 发明授权

US06549901B1 Using transportable tablespaces for hosting data of multiple users 有权
标题翻译：使用可移动的表空间来托管多个用户的数据
公开(公告)号：US06549901B1
公开(公告)日：2003-04-15
申请号：US09675195
申请日：2000-09-29
申请人： Juan R. Loaiza , Hasan Rizvi , J. William Lee , William H. Bridge, Jr. , Jonathan D. Klein , Alex Tsukerman , Gianfranco Putzolu
发明人： Juan R. Loaiza , Hasan Rizvi , J. William Lee , William H. Bridge, Jr. , Jonathan D. Klein , Alex Tsukerman , Gianfranco Putzolu
IPC分类号： G06F1730
CPC分类号： G06F17/30952 , Y10S707/99937
摘要： Provided are mechanisms that may be used to support efficient exportation of user data stored in a database system. According to an aspect of the present invention, a database system is configured to store data for users in separate repositories referred to as tablespaces. To store data in this manner, a database system may be configured in variety of ways.
摘要翻译：提供了可用于支持存储在数据库系统中的用户数据的有效输出的机制。根据本发明的一个方面，数据库系统被配置为将数据存储在被称为表空间的分开的存储库中。为了以这种方式存储数据，可以以各种方式配置数据库系统。

5. 发明授权

US5873102A Pluggable tablespaces on a transportable medium 失效
标题翻译：可移动介质上的可插拔表空间
公开(公告)号：US5873102A
公开(公告)日：1999-02-16
申请号：US846511
申请日：1997-04-29
申请人： William H. Bridge, Jr. , Jonathan D. Klein , J. William Lee , Juan R. Loaiza , Alex Tsukerman , Gianfranco Putzolu
发明人： William H. Bridge, Jr. , Jonathan D. Klein , J. William Lee , Juan R. Loaiza , Alex Tsukerman , Gianfranco Putzolu
IPC分类号： G06F17/30
CPC分类号： G06F17/30557 , G06F17/30339 , Y10S707/99942 , Y10S707/99953 , Y10S707/99955
摘要： A pluggable tablespace is enabled by logically partitioning a database into a set of tablespaces. A pluggable set of tablespaces is stored on a transportable medium in which all the disk pointers of the pluggable set is stored in tablespace-relative format. In addition, the pluggable set includes exported associated metadata about objects contained in the pluggable set. The pluggable set is plugged into a target database by making the pluggable set accessible to the target database and importing the associated metadata, without patching any of the disk pointers.
摘要翻译：通过将数据库逻辑分区成一组表空间来启用可插入表空间。可插入的一组表空间存储在可移植介质上，其中可插入集合的所有磁盘指针以表空间相对格式存储。此外，可插拔集合包括关于可插入集合中包含的对象的导出的关联元数据。通过使可插拔设置可访问目标数据库并导入关联的元数据，插件可插入目标数据库，而不修补任何磁盘指针。

6. 发明申请

US20050086195A1 Self-managing database architecture 有权
标题翻译：自我管理数据库架构
公开(公告)号：US20050086195A1
公开(公告)日：2005-04-21
申请号：US10934076
申请日：2004-09-03
申请人： Leng Leng Tan , Gianfranco Putzolu , Richard Sarwal , Alex Tsukerman , Gary Ngai , Graham Wood , Karl Dias , Mark Ramacher , Benoit Dageville , Mohamed Ziauddin , Tirthankar Lahiri , Sujatha Muthulingam , Vishwanath Karra , Francisco Sanchez , Hsiao-Te Su , Wanli Yang , Vasudha Krishnaswamy , Sushil Kumar
发明人： Leng Leng Tan , Gianfranco Putzolu , Richard Sarwal , Alex Tsukerman , Gary Ngai , Graham Wood , Karl Dias , Mark Ramacher , Benoit Dageville , Mohamed Ziauddin , Tirthankar Lahiri , Sujatha Muthulingam , Vishwanath Karra , Francisco Sanchez , Hsiao-Te Su , Wanli Yang , Vasudha Krishnaswamy , Sushil Kumar
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30289 , Y10S707/99932 , Y10S707/99945
摘要： An intelligent database infrastructure wherein the management of all database components is performed by and within the database itself by integrating management of various components with a central management control. Each individual database component, as well as the central management control, is self-managing. A central management control module integrates and interacts with the various database components. The database is configured to automatically tune to varying workloads and configurations, correct or alert about bad conditions, and advise on ways to improve overall system performance.
摘要翻译：智能数据库基础设施，其中所有数据库组件的管理由数据库本身和数据库本身进行管理，通过集中管理各种组件与中央管理控制。每个单独的数据库组件以及中央管理控制都是自我管理的。中央管理控制模块集成并与各种数据库组件进行交互。数据库被配置为自动调整到不同的工作负载和配置，纠正或警告恶劣条件，并提供有关如何提高整体系统性能的建议。

7. 发明授权

US06321238B1 Hybrid shared nothing/shared disk database system 有权
标题翻译：混合共享/共享磁盘数据库系统
公开(公告)号：US06321238B1
公开(公告)日：2001-11-20
申请号：US09222577
申请日：1998-12-28
申请人： Gianfranco Putzolu
发明人： Gianfranco Putzolu
IPC分类号： G06F1730
CPC分类号： G06F17/30575 , G06F21/6227 , Y10S707/99938 , Y10S707/99939 , Y10S707/99952 , Y10S707/99953 , Y10S707/99956
摘要： A database or some portion thereof is partitioned into ownership groups. Each ownership group is assigned one or more database servers as owners of the ownership group. The database servers that are assigned as owners of an ownership group are treated as the owners of all data items that belong to the ownership group. That is, they are allowed to directly access the data items within the ownership group, while other database servers are not allowed to directly access those data items. Accordingly, a database system is provided which includes one or more persistent storage devices having a database stored thereon, and a plurality of database servers executing on a plurality of nodes. Each node has direct access to the persistent storage devices. At least a portion of the database is partitioned into a plurality of ownership groups. Each ownership group is assigned an owner set. Only processes that are executing on database servers that are members of the owner set of an ownership group are allowed to directly access data within the ownership group. Each ownership group is designated as either a shared nothing ownership group or a shared disk ownership group. Each shared nothing ownership group is assigned an owner from among the database servers. Only the owner of each shared nothing ownership group is allowed to directly access data within the shared nothing ownership group. Each of the database servers is allowed to directly access data within ownership groups that are designated as shared disk ownership groups.
摘要翻译：数据库或其一部分被划分为所有权组。每个所有权组被分配一个或多个数据库服务器作为所有权组的所有者。分配为所有者组的所有者的数据库服务器将被视为属于所有权组的所有数据项的所有者。也就是说，它们被允许直接访问所有权组内的数据项，而其他数据库服务器不允许直接访问这些数据项。因此，提供了一种数据库系统，其包括一个或多个具有存储在其上的数据库的持久存储设备，以及在多个节点上执行的多个数据库服务器。每个节点都可以直接访问持久存储设备。数据库的至少一部分被分割成多个所有权组。每个所有权组都被分配一个所有者集。只有在作为所有权组的所有者集的成员的数据库服务器上执行的进程才允许直接访问所有权组内的数据。每个所有权组被指定为无共享的所有权组或共享磁盘所有权组。每个共享的无所有权组从数据库服务器中分配一个所有者。只有每个共享无所有权组的所有者才能直接访问共享无所有权组内的数据。允许每个数据库服务器直接访问被指定为共享磁盘所有权组的所有权组内的数据。

8. 发明授权

US06470423B1 Managing partitioned cache 有权
标题翻译：管理分区缓存
公开(公告)号：US06470423B1
公开(公告)日：2002-10-22
申请号：US10032243
申请日：2001-12-21
申请人： Alexander C. Ho , Ashok Joshi , Gianfranco Putzolu , Juan R. Loaiza , Graham Wood , William H. Bridge, Jr.
发明人： Alexander C. Ho , Ashok Joshi , Gianfranco Putzolu , Juan R. Loaiza , Graham Wood , William H. Bridge, Jr.
IPC分类号： G06F1200
CPC分类号： G06F12/121 , G06F12/0866
摘要： Described herein are approaches for partitioning a buffer cache for dynamically selecting buffers in the buffer cache to store data items, such as data blocks in a DBMS. The selection is based on data access and/or usage patterns. A buffer cache includes multiple buffer pools. A buffer pool is selected from among the multiple buffer pools to store a data item. The selection of a buffer pool is based on various factors, including the likelihood that storing the data item will produce future cache hits, and properties of buffer pools that vary between the buffer pools. Properties of a buffer pool include not only how the buffer pools are organized, both logically and physically, but also how the buffer pool is managed. Examples of a buffer pool property include buffer pool size, size of a buffer in the buffer pool, and the replacement strategy used for a buffer pool (e.g. LRU).
摘要翻译：这里描述了用于分割缓冲器高速缓存用于动态选择缓冲器高速缓存中的缓冲器以存储数据项（诸如DBMS中的数据块）的方法。该选择是基于数据访问和/或使用模式。缓冲区缓存包括多个缓冲池。从多个缓冲池中选择缓冲池以存储数据项。缓冲池的选择基于各种因素，包括存储数据项的可能性将产生未来的缓存命中，以及在缓冲池之间变化的缓冲池的属性。缓冲池的属性不仅包括缓冲池在逻辑和物理上的组织方式，还包括缓冲池的管理方式。缓冲池属性的示例包括缓冲池大小，缓冲池中缓冲区的大小以及用于缓冲池（例如LRU）的替换策略。

9. 发明授权

US06370619B1 Managing partitioned cache 失效
标题翻译：管理分区缓存
公开(公告)号：US06370619B1
公开(公告)日：2002-04-09
申请号：US09102735
申请日：1998-06-22
申请人： Alexander C. Ho , Ashok Joshi , Gianfranco Putzolu , Juan R. Loaiza , Graham Wood , William H. Bridge, Jr.
发明人： Alexander C. Ho , Ashok Joshi , Gianfranco Putzolu , Juan R. Loaiza , Graham Wood , William H. Bridge, Jr.
IPC分类号： G06F1200
CPC分类号： G06F12/121 , G06F12/0866
摘要： The present invention provides a method and apparatus for partitioning a buffer cache for dynamically mapping data blocks with a particular replacement strategy based on the associated table's access and/or usage patterns. According to the method, a buffer cache in a computer system is managed by dividing the buffer cache into multiple buffer pools. In managing the buffer cache, when a data item is requested, it is first determined whether the requested data item is stored in a buffer within the buffer cache. If the requested data item is not stored in a buffer in the buffer cache, then a particular buffer pool in the buffer cache is dynamically selected for storing the requested data item. Once the particular buffer pool is selected, the requested data item is stored into a buffer in the particular buffer pool.
摘要翻译：本发明提供了一种用于分割缓冲器高速缓存的方法和装置，用于基于相关联的表的访问和/或使用模式，用特定替换策略动态地映射数据块。根据该方法，通过将缓冲器高速缓存分成多个缓冲池来管理计算机系统中的缓冲区高速缓存。在管理缓冲区高速缓存时，当请求数据项时，首先确定所请求的数据项是否存储在缓冲区高速缓存中的缓冲区中。如果请求的数据项没有存储在缓冲区缓冲区中的缓冲区中，则动态地选择缓冲区高速缓存中的特定缓冲池来存储所请求的数据项。一旦选择了特定的缓冲池，请求的数据项被存储在特定缓冲池中的缓冲区中。

10. 发明授权

US6026406A Batch processing of updates to indexes 失效
标题翻译：批量处理索引的更新
公开(公告)号：US6026406A
公开(公告)日：2000-02-15
申请号：US855544
申请日：1997-06-04
申请人： Wei Huang , Gianfranco Putzolu , William H. Waddington , Jonathan D. Klein
发明人： Wei Huang , Gianfranco Putzolu , William H. Waddington , Jonathan D. Klein
IPC分类号： G06F11/14 , G06F17/30
CPC分类号： G06F17/30362 , G06F17/30327 , G06F17/3038 , G06F11/1471 , Y10S707/99937
摘要： A method and apparatus for batch processing of updates to indexes is provided. A plurality of index update records are generated that identify a plurality of index update operations to be made to an index. The plurality of index entry records are sorted and then applied, in an order that corresponds to the sort order, in batches to their respective indexes. As a result of performing batch processing of updates to indexes, the number of disk I/Os will be greatly reduced, freeing database system resources to perform other tasks. The overall efficiency of index maintenance is also improved, as is the recovery of the database system after a failure, resultant from an ordering of the index maintenance operations and a partial ordering of the persistent redo log file.
摘要翻译：提供了一种批量处理索引更新的方法和装置。生成多个索引更新记录，其识别要对索引进行的多个索引更新操作。将多个索引条目记录按照与排序顺序对应的顺序分批并按其各自的索引分批应用。作为对索引进行更新的批处理的结果，磁盘I / O的数量将大大减少，释放数据库系统资源以执行其他任务。索引维护的整体效率也得到提高，故障后数据库系统的恢复也是由于索引维护操作的排序和持续重做日志文件的部分排序而导致的。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式