专利快速检索-快速检索全球专利，免费商用专利数据库-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. 发明授权

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.

7. 发明授权

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.
摘要翻译：数据库或其一部分被划分为所有权组。每个所有权组被分配一个或多个数据库服务器作为所有权组的所有者。分配为所有者组的所有者的数据库服务器将被视为属于所有权组的所有数据项的所有者。也就是说，它们被允许直接访问所有权组内的数据项，而其他数据库服务器不允许直接访问这些数据项。提供了一种转换数据项所有权的机制。通过禁用对数据项的访问，等待对数据项进行更改的所有事务进行提交或中止，将数据项的所有权从第一个所有者更改为第二个所有者，并启用访问权限到数据项。

8. 发明授权

US07627614B2 Lost write detection and repair 有权
标题翻译：丢失写检测和修复
公开(公告)号：US07627614B2
公开(公告)日：2009-12-01
申请号：US11072111
申请日：2005-03-03
申请人： Wei Ming Hu , Mark Dilman , J. William Lee , Juan R. Loaiza , Vinay Srihari
发明人： Wei Ming Hu , Mark Dilman , J. William Lee , Juan R. Loaiza , Vinay Srihari
IPC分类号： G06F17/30
CPC分类号： G06F11/1471 , G06F11/2094 , G06F2201/80 , G06F2211/1007 , Y10S707/99954
摘要： Techniques are provided for detecting lost writes so that data corruption can be avoided. According to one technique, lost writes are detected by comparing version numbers that are indicated in redo log entries with version numbers that are indicated in corresponding blocks in a standby database. According to one technique, which may be used in conjunction with the above technique, lost writes are detected by logging read operations that occur relative to a primary database, and comparing version numbers that are indicated in read log entries with version numbers that are indicated in corresponding blocks in a standby database. According to one technique, lost writes are detected by comparing, in response to read operations, (a) version numbers that are stored in a persistent in-memory cache with (b) version numbers that are indicated in corresponding blocks that are read from a primary database.
摘要翻译：提供了用于检测丢失写入的技术，从而可以避免数据损坏。根据一种技术，通过将重做日志条目中指示的版本号与在备用数据库中的相应块中指示的版本号进行比较来检测丢失的写入。根据可以与上述技术结合使用的一种技术，通过记录相对于主数据库发生的读取操作来检测丢失的写入，并且将读取日志条目中指示的版本号与在备用数据库中的相应块。根据一种技术，通过比较读取操作来检测丢失的写入，（a）存储在持久性内存高速缓存中的版本号，（b）版本号，其在从主数据库。

9. 发明授权

US07031987B2 Integrating tablespaces with different block sizes 有权
公开(公告)号：US07031987B2
公开(公告)日：2006-04-18
申请号：US09871476
申请日：2001-05-30
申请人： Sreedhar Mukkamalla , Arvind Nithrakashyap , Tirthankar Lahiri , Alok Pareek , Juan R. Loaiza , J. William Lee , Gary C. Ngai
发明人： Sreedhar Mukkamalla , Arvind Nithrakashyap , Tirthankar Lahiri , Alok Pareek , Juan R. Loaiza , J. William Lee , Gary C. Ngai
IPC分类号： G06F7/00
CPC分类号： G06F17/30592 , G06F17/30 , G06F17/30952 , Y10S707/99938 , Y10S707/99942 , Y10S707/99955
摘要： Provided herein is a mechanism that allows a given database system to access data blocks from another database system, where data blocks from the given database system and data blocks from the other database system have different sizes. According to an aspect of the present invention, a tablespace in the other database system contained the data blocks. The tablespace is detached from the other database system and integrated into the given database, which is capable of processing data stored in data blocks of a different sizes.

10. 发明授权

US6125368A Fault-tolerant timestamp generation for multi-node parallel databases 失效
标题翻译：多节点并行数据库的容错时间戳生成
公开(公告)号：US6125368A
公开(公告)日：2000-09-26
申请号：US808582
申请日：1997-02-28
申请人： William Bridge , Madhusudan Krishnapuram , J. William Lee , Juan R. Loaiza
发明人： William Bridge , Madhusudan Krishnapuram , J. William Lee , Juan R. Loaiza
IPC分类号： G06F11/14 , G06F17/30
CPC分类号： G06F11/1415 , G06F2201/835 , Y10S707/99952 , Y10S707/99953
摘要： Every node in a multi-node parallel database system maintains a logical clock for generating timestamps. The logical clocks are synchronized by attaching a current timestamp to every message that is sent by a node. When a node receives an incoming timestamp that is greater than the value indicated by the associated logical clock, it sets the associated logical clock forward to at least the value of the timestamp. Each node continually sends and receives a message including a timestamp at least once in a prescribed period of time. Moreover, each node maintains a high watermark that represents a time greater or equal to the highest time of any logical clock in the multi-node parallel database system.
摘要翻译：多节点并行数据库系统中的每个节点维护用于生成时间戳的逻辑时钟。通过将当前时间戳附加到由节点发送的每个消息来同步逻辑时钟。当节点接收到大于由相关逻辑时钟指示的值的输入时间戳时，它将关联的逻辑时钟向前设置为至少时间戳的值。每个节点在规定的时间段内连续发送和接收包含时间戳的消息至少一次。此外，每个节点保持高水印，其表示大于或等于多节点并行数据库系统中的任何逻辑时钟的最高时间的时间。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式