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

1. 发明授权

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.

2. 发明授权

US07571173B2 Cross-platform transportable database 有权
标题翻译：跨平台可移植数据库
公开(公告)号：US07571173B2
公开(公告)日：2009-08-04
申请号：US10966961
申请日：2004-10-15
申请人： Wanli Yang , Bipul Sinha , Amit Ganesh , Wei Hu , Alok Pareek , Alexander H. Hwang , Steven Charles Wertheimer , Francisco M. Sanchez , Dmitry Mikhailovich Potapov , Shen-Ban Meng , Juan R. Loaiza , William H. Bridge , J. William Lee
发明人： Wanli Yang , Bipul Sinha , Amit Ganesh , Wei Hu , Alok Pareek , Alexander H. Hwang , Steven Charles Wertheimer , Francisco M. Sanchez , Dmitry Mikhailovich Potapov , Shen-Ban Meng , Juan R. Loaiza , William H. Bridge , J. William Lee
IPC分类号： G06F7/00
CPC分类号： G06F17/30569 , Y10S707/99942
摘要： A method and apparatus for creating a target database on a target platform based on a source database on a source platform is provided. A target database is created on the target platform based on data, metadata (for example, data in the system tablespace and control files), and external objects (for example, password files and externally stored tables) comprised within the source database. Data and metadata stored in tablespaces of the source database are converted to the format compatible with the target platform. The conversion of the data and metadata may be performed either at the source database or the target database. Redo information and undo information of the source database are not copied from the source database to the target database. Certain files, e.g., a password files, and links to externally stored object may be recreated on the target database.
摘要翻译：提供了一种用于在源平台上基于源数据库在目标平台上创建目标数据库的方法和装置。基于源数据库中包含的数据，元数据（例如，系统表空间和控制文件中的数据）以及外部对象（例如，密码文件和外部存储的表），在目标平台上创建目标数据库。存储在源数据库的表空间中的数据和元数据将转换为与目标平台兼容的格式。可以在源数据库或目标数据库执行数据和元数据的转换。源数据库的重做信息和撤消信息不会从源数据库复制到目标数据库。可以在目标数据库上重新创建某些文件，例如密码文件和到外部存储对象的链接。

3. 发明授权

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）版本号，其在从主数据库。

4. 发明授权

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

5. 发明授权

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.
摘要翻译：包含数据文件的数据库被分成一组表空间。指向数据文件中的数据项的每个磁盘指针是指数据文件的表空间相对文件编号。通过首先检查缓存来检索由表空间相对磁盘指针指向的数据，并且在高速缓存未命中时，根据无闩锁查询技术将表空间相对文件号转换为绝对文件号。

6. 发明授权

US07734580B2 Readable physical storage replica and standby database system 有权
标题翻译：可读物理存储副本和备用数据库系统
公开(公告)号：US07734580B2
公开(公告)日：2010-06-08
申请号：US11818975
申请日：2007-01-29
申请人： Tirthankar Lahiri , Kiran Goyal , Jia Shi , Wei-Ming Hu , Neil MacNaughton , Jaebock Lee , Bharat Baddepudi , Yunrui Li , J. William Lee , Vipin Gokhale , Mark Dilman , Niloy Mukherjee , Vinay Srihari , Kumar Rajamani , Hochak Hung
发明人： Tirthankar Lahiri , Kiran Goyal , Jia Shi , Wei-Ming Hu , Neil MacNaughton , Jaebock Lee , Bharat Baddepudi , Yunrui Li , J. William Lee , Vipin Gokhale , Mark Dilman , Niloy Mukherjee , Vinay Srihari , Kumar Rajamani , Hochak Hung
IPC分类号： G06F17/30
CPC分类号： G06F11/2097 , G06F11/2035 , G06F11/2048 , G06F12/0815
摘要： A standby database system or another replica data system replicates changes, made to data blocks at a source database system or another primary data copy, to replicas of the data blocks at the standby database system or other replica. While replicating the changes to the data blocks thereof, the standby database system (or other replica) receives queries (or reads) issued thereto and computes the queries based on data read from the data blocks thereof.
摘要翻译：备用数据库系统或其他副本数据系统将对源数据库系统或其他主数据副本上的数据块进行的更改复制到备用数据库系统或其他副本上的数据块的副本。在对其数据块进行复制的同时，备用数据库系统（或其他副本）接收对其发出的查询（或读取），并根据从其数据块读取的数据来计算查询。

7. 发明申请

US20080235291A1 Readable physical storage replica and standby database system 有权
标题翻译：可读物理存储副本和备用数据库系统
公开(公告)号：US20080235291A1
公开(公告)日：2008-09-25
申请号：US11818975
申请日：2007-01-29
申请人： Tirthankar Lahiri , Kiran Goyal , Jia Shi , Wei-Ming Hu , Neil MacNaughton , Jaebock Lee , Bharat Baddepudi , Yunrui Li , J. William Lee , Vipin Gokhale , Mark Dilman , Niloy Mukherjee , Vinay Srihari , Kumar Rajamani , Hochak Hung
发明人： Tirthankar Lahiri , Kiran Goyal , Jia Shi , Wei-Ming Hu , Neil MacNaughton , Jaebock Lee , Bharat Baddepudi , Yunrui Li , J. William Lee , Vipin Gokhale , Mark Dilman , Niloy Mukherjee , Vinay Srihari , Kumar Rajamani , Hochak Hung
IPC分类号： G06F17/30
CPC分类号： G06F11/2097 , G06F11/2035 , G06F11/2048 , G06F12/0815
摘要： A standby database system or another replica data system replicates changes, made to data blocks at a source database system or another primary data copy, to replicas of the data blocks at the standby database system or other replica. While replicating the changes to the data blocks thereof, the standby database system (or other replica) receives queries (or reads) issued thereto and computes the queries based on data read from the data blocks thereof.
摘要翻译：备用数据库系统或其他副本数据系统将对源数据库系统或其他主数据副本上的数据块进行的更改复制到备用数据库系统或其他副本上的数据块的副本。在对其数据块进行复制的同时，备用数据库系统（或其他副本）接收对其发出的查询（或读取），并根据从其数据块读取的数据来计算查询。

8. 发明授权

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.
摘要翻译：多节点并行数据库系统中的每个节点维护用于生成时间戳的逻辑时钟。通过将当前时间戳附加到由节点发送的每个消息来同步逻辑时钟。当节点接收到大于由相关逻辑时钟指示的值的输入时间戳时，它将关联的逻辑时钟向前设置为至少时间戳的值。每个节点在规定的时间段内连续发送和接收包含时间戳的消息至少一次。此外，每个节点保持高水印，其表示大于或等于多节点并行数据库系统中的任何逻辑时钟的最高时间的时间。

9. 发明授权

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

10. 发明授权

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.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式