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

1. 发明授权

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.
摘要翻译：通过将数据库逻辑分区为一组表空间并以表空间相对格式存储所有表空间磁盘指针来启用可插入表空间。通过生成相关联的元数据并创建表空间的二进制副本，可以拔掉一组可插拔的表空间。可插入的表空间集合通过使可插入集合可访问目标数据库并结合相关联的元数据而插入到目标数据库中，而无需修补任何磁盘指针。

2. 发明授权

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.
摘要翻译：提供了可用于支持存储在数据库系统中的用户数据的有效输出的机制。根据本发明的一个方面，数据库系统被配置为将数据存储在被称为表空间的分开的存储库中。为了以这种方式存储数据，可以以各种方式配置数据库系统。

3. 发明授权

US06272503B1 Tablespace-relative database pointers 失效
标题翻译：表空间相对数据库指针
公开(公告)号：US06272503B1
公开(公告)日：2001-08-07
申请号：US08865693
申请日：1997-05-30
申请人： 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分类号： G06F1730
CPC分类号： G06F17/30952 , Y10S707/959 , Y10S707/99937 , Y10S707/99942 , Y10S707/99955
摘要： A database containing datafiles is partitioned into a set of tablespaces. Every disk pointer pointing to a data item in a datafile refers to a tablespace-relative file number for the datafile. Data pointed to by a tablespace-relative disk pointer is retrieved by first checking the cache, and upon a cache miss, the tablespace-relative file number is translated into an absolute file number according to a latch-free look up technique.
摘要翻译：包含数据文件的数据库被分成一组表空间。指向数据文件中的数据项的每个磁盘指针是指数据文件的表空间相对文件编号。通过首先检查缓存来检索由表空间相对磁盘指针指向的数据，并且在高速缓存未命中时，根据无闩锁查询技术将表空间相对文件号转换为绝对文件号。

4. 发明授权

US5890167A Pluggable tablespaces for database systems 失效
标题翻译：数据库系统的可插拔表空间
公开(公告)号：US5890167A
公开(公告)日：1999-03-30
申请号：US852968
申请日：1997-05-08
申请人： 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/30339 , Y10S707/99942 , Y10S707/99953 , 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 exporting 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 importing the associated metadata, without patching any of the disk pointers.
摘要翻译：通过将数据库逻辑分区为一组表空间并以表空间相对格式存储所有表空间磁盘指针来启用可插入表空间。通过导出相关联的元数据并创建表空间的二进制副本，可以插拔一组表空间。可插拔的表空间集合通过使可插入集合可访问目标数据库并导入相关联的元数据而插入到目标数据库中，而无需修补任何磁盘指针。

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. 发明授权

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）的替换策略。

7. 发明授权

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.
摘要翻译：本发明提供了一种用于分割缓冲器高速缓存的方法和装置，用于基于相关联的表的访问和/或使用模式，用特定替换策略动态地映射数据块。根据该方法，通过将缓冲器高速缓存分成多个缓冲池来管理计算机系统中的缓冲区高速缓存。在管理缓冲区高速缓存时，当请求数据项时，首先确定所请求的数据项是否存储在缓冲区高速缓存中的缓冲区中。如果请求的数据项没有存储在缓冲区缓冲区中的缓冲区中，则动态地选择缓冲区高速缓存中的特定缓冲池来存储所请求的数据项。一旦选择了特定的缓冲池，请求的数据项被存储在特定缓冲池中的缓冲区中。

8. 发明授权

US10592416B2 Write-back storage cache based on fast persistent memory 有权
公开(公告)号：US10592416B2
公开(公告)日：2020-03-17
申请号：US13288785
申请日：2011-11-03
申请人： Bharat Chandra Baddepudi , Juan R. Loaiza , Wei-Ming Hu , Kothanda Umamageswaran , Alex Tsukerman , Boris Erlikhman , J. William Lee , Jia Shi , Kiran B. Goyal , Selcuk Aya
发明人： Bharat Chandra Baddepudi , Juan R. Loaiza , Wei-Ming Hu , Kothanda Umamageswaran , Alex Tsukerman , Boris Erlikhman , J. William Lee , Jia Shi , Kiran B. Goyal , Selcuk Aya
IPC分类号： G06F12/08 , G06F12/0868
摘要： A storage device uses non-volatile memory devices for caching. The storage device operates in a mode referred to herein as write-back mode. In write-back mode, a storage device responds to a request to write data by persistently writing the data to a cache in a non-volatile memory device and acknowledges to the requestor that the data is written persistently in the storage device. The acknowledgement is sent without necessarily having written the data that was requested to be written to primary storage. Instead, the data is written to primary storage later.

9. 发明授权

US06253212B1 Method and system for maintaining checkpoint values 失效
标题翻译：维护检查点值的方法和系统
公开(公告)号：US06253212B1
公开(公告)日：2001-06-26
申请号：US09103627
申请日：1998-06-23
申请人： Juan R. Loaiza , William H. Bridge, Jr. , Ashok Joshi
发明人： Juan R. Loaiza , William H. Bridge, Jr. , Ashok Joshi
IPC分类号： G06F1730
CPC分类号： G06F11/1402 , Y10S707/99938 , Y10S707/99953
摘要： A method and system are provided for maintaining a checkpoint value that indicates which records of a plurality of records associated with updates made before a failure have to be processed after the failure. According to one aspect of the invention, an ordered list of buffers is maintained in volatile memory. The ordered list of buffers has a head and a tail. The ordered list of buffers is maintained by writing a record that indicates the update to nonvolatile memory and adding the buffer to the tail of the ordered list whenever an update is made to a data item within a buffer in volatile memory. When a data item contained in a buffer within the ordered list is stored in nonvolatile memory, the buffer can be removed from the ordered list. A checkpoint value that identifies a record associated with a buffer located at the head of the ordered list is written to nonvolatile memory. According to another aspect, after a failure, the record associated with the checkpoint value is identified. If a particular record was stored to nonvolatile memory before the record associated with the checkpoint value, the particular record is not processed. If the particular record was not stored to nonvolatile memory before the record associated with the checkpoint value, the particular record is processed.
摘要翻译：提供了一种方法和系统，用于维护检查点值，该检查点值指示在故障之后必须处理故障之前所做出的与更新相关联的多个记录的哪些记录。根据本发明的一个方面，缓存器的有序列表被保存在易失性存储器中。缓冲区的有序列表有一个头和尾。通过写入一个指示更新到非易失性存储器的记录来维护缓冲区的有序列表，并且每当对易失性存储器中的缓冲器内的数据项进行更新时，将该缓冲区添加到有序列表的尾部。当包含在有序列表中的缓冲器中的数据项存储在非易失性存储器中时，可以从有序列表中移除缓冲区。标识与位于有序列表头部的缓冲区关联的记录的检查点值被写入非易失性存储器。根据另一方面，在故障之后，识别与检查点值相关联的记录。如果在与检查点值相关联的记录之前将特定记录存储到非易失性存储器中，则不处理特定记录。如果在与检查点值相关联的记录之前没有将特定记录存储到非易失性存储器中，则处理特定记录。

10. 发明授权

US06351754B1 Method and system for controlling recovery downtime 失效
标题翻译：控制恢复停机时间的方法和系统
公开(公告)号：US06351754B1
公开(公告)日：2002-02-26
申请号：US09103630
申请日：1998-06-23
申请人： William H. Bridge, Jr. , Boris Klots , Juan R. Loaiza , Ashok Joshi
发明人： William H. Bridge, Jr. , Boris Klots , Juan R. Loaiza , Ashok Joshi
IPC分类号： G06F1730
CPC分类号： G06F11/1461 , G06F11/1471 , G06F2201/80 , Y10S707/99938 , Y10S707/99953
摘要： A method and system for reducing overhead associated with recovering after a failure. According to the method, a checkpoint value is maintained that indicates which records of a plurality of records have to be processed after the failure. The plurality of records contain change information that corresponds to a plurality of data blocks. A target checkpoint value is determined based on a desired number of data block reads that will be required during a redo phase of recovery. Changes contained in volatile memory are then written to nonvolatile memory to advance the checkpoint value to at least the target checkpoint value. According to another aspect of the invention, the target checkpoint value is determined using a circular queue of offset buckets. The offset buckets are used to store index values that are associated with buffers in the ordered list. The target checkpoint value is periodically set equal to an index value that is contained in an offset bucket. According to another aspect of the invention, the target checkpoint value is determined by calculating a maximum number of records that should be processed after the failure. The maximum number of records is based on the desired number of data block reads that will be required during the redo phase of the recovery. The target checkpoint value is updated based on the maximum number of records.
摘要翻译：一种降低与故障恢复相关的开销的方法和系统。根据该方法，维护检查点值，其指示在故障之后必须处理多个记录的哪些记录。多个记录包含对应于多个数据块的改变信息。基于在恢复的重做阶段将需要的数据块读取的期望数目来确定目标检查点值。随后将易失性存储器中的变更写入非易失性存储器，将检查点值提升至至少目标检查点值。根据本发明的另一方面，使用偏移桶的圆形队列来确定目标检查点值。偏移量桶用于存储与排序列表中的缓冲区相关联的索引值。目标检查点值周期性设置为等于包含在偏移量桶中的索引值。根据本发明的另一方面，通过计算在故障之后应该处理的最大记录数来确定目标检查点值。记录的最大数量是基于恢复重做阶段所需要的数据块读取所需的数量。基于记录的最大数量更新目标检查点值。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式