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

1. 发明授权

US07555500B2 Optimized end transaction processing 有权
公开(公告)号：US07555500B2
公开(公告)日：2009-06-30
申请号：US09784392
申请日：2001-02-15
申请人： Donald R. Pederson , James B. Chapman
发明人： Donald R. Pederson , James B. Chapman
IPC分类号： G06F17/30
CPC分类号： G06F17/30371 , Y10S707/99953
摘要： An end transaction procedure is optimized for certain database operations. Where a transaction preceding the end transaction procedure includes a step that employs all the access modules in the transaction, a flush of the transaction log is performed during execution of the last step of the transaction. The need to flush the transaction log during the subsequent end transaction procedure is obviated. The end transaction procedure further may check to determine whether the transaction log was previously flushed, rather than always flushing the transaction log. Also, where the access modules involved in a transaction are part of the same cluster, certain broadcast operations of the end transaction procedure may be avoided.

2. 发明申请

US20120166402A1 TECHNIQUES FOR EXTENDING HORIZONTAL PARTITIONING TO COLUMN PARTITIONING 审中-公开
标题翻译：用于将水平分离扩展到柱分离的技术
公开(公告)号：US20120166402A1
公开(公告)日：2012-06-28
申请号：US13300066
申请日：2011-11-18
申请人： Donald R. Pederson , Paul Sinclair , Steven B. Cohen
发明人： Donald R. Pederson , Paul Sinclair , Steven B. Cohen
IPC分类号： G06F17/30
CPC分类号： G06F16/24554 , G06F16/22
摘要： Techniques for extending horizontal partitioning to column partitioning are provided. A database table is partitioned into custom groups of rows and custom groups of columns. Each partitioned column is managed as a series of containers representing all values appearing under the partitioned column. A logical row represents a row of the table logically indicating each column value of a row. Compression, deletion, and insertion within the containers are managed via a control header maintained with each container.
摘要翻译：提供了将水平分区扩展到列分区的技术。数据库表被划分为自定义行组和自定义列组。每个分区列以一系列容器的形式进行管理，这些容器表示出现在分区列下的所有值。逻辑行表示表的一行逻辑地指示行的每个列值。容器内的压缩，删除和插入通过与每个容器维护的控制头进行管理。

3. 发明授权

US08495034B2 Numeric, decimal and date field compression 有权
标题翻译：数字，十进制和日期字段压缩
公开(公告)号：US08495034B2
公开(公告)日：2013-07-23
申请号：US13013651
申请日：2011-01-25
申请人： Mark A. Hodgens , Fred S. Kaufmann , Donald R. Pederson , Gary A. Roberts
发明人： Mark A. Hodgens , Fred S. Kaufmann , Donald R. Pederson , Gary A. Roberts
IPC分类号： G06F17/30
CPC分类号： G06F17/30501
摘要： A method, apparatus, and article of manufacture for accessing data in a computer system. Compression and decompression functions are associated with a column of the table, in order to perform compression of decimal, numeric or date data stored in the column when the data is inserted or updated in the table, and in order to perform decompression of the data stored in the column when the data is retrieved from the table. The compression function compresses and stores the data in a fixed-length compressed field in the column without a length value, and the fixed-length compressed field has a size that is determined by a range of values for the data stored in the fixed-length compressed field. The decompression function retrieves and decompresses the data from the fixed-length compressed field.
摘要翻译：一种用于访问计算机系统中的数据的方法，装置和制品。压缩和解压缩功能与表的列相关联，以便当在表中插入或更新数据时执行存储在列中的十进制，数字或日期数据的压缩，并且为了执行对存储的数据的解压缩在从表中检索数据的列中。压缩功能将数据压缩并存储在列中的固定长度压缩字段中，没有长度值，固定长度压缩字段具有由存储在固定长度中的数据的值的范围确定的大小压缩场。解压缩功能从固定长度压缩字段中检索和解压缩数据。

4. 发明授权

US06671687B1 Method and apparatus for protecting data retrieved from a database 有权
标题翻译：用于保护从数据库检索的数据的方法和装置
公开(公告)号：US06671687B1
公开(公告)日：2003-12-30
申请号：US09675275
申请日：2000-09-29
申请人： Donald R. Pederson , Fred S. Kaufmann , Gregory H. Milby
发明人： Donald R. Pederson , Fred S. Kaufmann , Gregory H. Milby
IPC分类号： G06F1730
CPC分类号： G06F12/1408 , G06F21/6227 , Y10S707/99939
摘要： A method and apparatus enables remote access of data of a database system. Such access may be performed by a remote device, such as a client computer system. A custom defined data type is assigned to data stored in the database system, the custom data type associates an access restriction to the data. A request for the data may be received over a communication network, such as the Internet or a local area network (LAN). In response to the request, the database system prepares the data for transmission and provides the requested information back over the communication network. The data is accessed using a security restriction defined by the custom data type.
摘要翻译：一种方法和装置能够远程访问数据库系统的数据。这样的访问可以由诸如客户端计算机系统的远程设备执行。自定义数据类型被分配给存储在数据库系统中的数据，自定义数据类型将访问限制与数据相关联。可以通过诸如因特网或局域网（LAN）的通信网络来接收对数据的请求。响应于该请求，数据库系统准备数据进行传输，并通过通信网络提供所请求的信息。使用自定义数据类型定义的安全限制来访问数据。

5. 发明授权

US06351749B1 Multi-threading, multi-tasking architecture for a relational database management system 有权
标题翻译：关系数据库管理系统的多线程，多任务架构
公开(公告)号：US06351749B1
公开(公告)日：2002-02-26
申请号：US09410389
申请日：1999-09-30
申请人： Douglas P. Brown , Allen N. Diaz , Donald R. Pederson
发明人： Douglas P. Brown , Allen N. Diaz , Donald R. Pederson
IPC分类号： G06F1730
CPC分类号： G06F17/30595 , Y10S707/99938 , Y10S707/99942 , Y10S707/99945
摘要： A parallel processing architecture for a relational database management system (RDBMS) that supports both a process model operating system and a thread model operating system. The RDBMS is implemented as a shared nothing, single database image utilizing Parallel Database Extensions (PDEs) that insulate the RDBMS from the specifics of the operating system and that provide the necessary techniques for accessing common memory segments.
摘要翻译：用于支持过程模型操作系统和线程模型操作系统的关系数据库管理系统（RDBMS）的并行处理架构。 RDBMS实现为无共享，单个数据库映像利用并行数据库扩展（PDE），使RDBMS与操作系统的细节保持一致，并提供访问公共内存段的必要技术。

6. 发明申请

US20140188820A1 TECHNIQUES FOR FINDING A COLUMN WITH COLUMN PARTITIONING 有权
标题翻译：用柱子分割找出柱的技术
公开(公告)号：US20140188820A1
公开(公告)日：2014-07-03
申请号：US13728361
申请日：2012-12-27
申请人： Donald R. Pederson , Paul Sinclair
发明人： Donald R. Pederson , Paul Sinclair
IPC分类号： G06F17/30
CPC分类号： G06F17/30584 , G06F17/30483
摘要： Techniques for finding a column with column partitioning are provided. Metadata for a container row is expanded to include information for searching ranges of partitioned column values. The metadata identifies offsets to specific ranges and specific columns within a specific range. The offsets also identify where compressed data for a desired column resides. Thereby, permitting partitioned columns having compressed data to be located without being decompressed and decompressed on demand as needed.
摘要翻译：提供了用于查找具有列分区的列的技术。扩展容器行的元数据以包含搜索分区列值的范围的信息。元数据标识特定范围内的偏移量和特定范围内的特定列。偏移量还会识别所需列的压缩数据所在的位置。从而，允许具有压缩数据的分区列被定位，而不需要根据需要进行解压缩和解压缩。

7. 发明申请

US20120166400A1 TECHNIQUES FOR PROCESSING OPERATIONS ON COLUMN PARTITIONS IN A DATABASE 审中-公开
标题翻译：用于处理数据库中的分区的操作的技术
公开(公告)号：US20120166400A1
公开(公告)日：2012-06-28
申请号：US12979526
申请日：2010-12-28
申请人： Paul Sinclair , Donald R. Pederson
发明人： Paul Sinclair , Donald R. Pederson
IPC分类号： G06F17/30
CPC分类号： G06F16/23 , G06F16/221
摘要： Techniques for processing operations on column partitions of a table in a database are provided. A table includes a control column partition. Each delete container of the control column partition representing multiple rows in the table (or a row partition, if any), and each row represented by a bit flag within a bit string. Rows of the table set for deletion have their corresponding bits within a particular delete container set to indicate those rows are deleted.
摘要翻译：提供了用于处理数据库中表的列分区的操作的技术。一个表包含一个控制列分区。控制列分区的每个删除容器表示表中的多个行（或行分区（如果有）），每行由位串中的位标志表示。设置为删除的表的行在其特定的删除容器内具有相应的位，以指示这些行被删除。

8. 发明授权

US07263536B1 System and method for updating an index in a database 有权
标题翻译：用于更新数据库中的索引的系统和方法
公开(公告)号：US07263536B1
公开(公告)日：2007-08-28
申请号：US10252264
申请日：2002-09-23
申请人： Donald R. Pederson
发明人： Donald R. Pederson
IPC分类号： G06F17/30
CPC分类号： G06F17/30321 , Y10S707/99954
摘要： A method for updating an index in a database includes storing a plurality of changes to be made to a database index in a change table. Each of the changes is associated with an identifier. The method also includes sorting the changes in the change table based on the identifier associated with each of the changes. The method further includes updating the database index using the sorted changes. The database index includes a data block, and updating the database index includes applying at least two of the changes from the change table to the data block during a single operation.
摘要翻译：一种用于更新数据库中的索引的方法，包括：在更改表中存储要对数据库索引进行的多个更改。每个更改与标识符相关联。该方法还包括基于与每个变化相关联的标识符对改变表中的改变进行排序。该方法还包括使用排序的改变来更新数据库索引。数据库索引包括数据块，并且更新数据库索引包括在单个操作期间将来自改变表的至少两个改变应用于数据块。

9. 发明授权

US08938644B2 Query execution plan revision for error recovery 有权
标题翻译：用于错误恢复的查询执行计划修订
公开(公告)号：US08938644B2
公开(公告)日：2015-01-20
申请号：US12960307
申请日：2010-12-03
申请人： Arthur Clark , Douglas P. Brown , Anita Richards , Donald R. Pederson
发明人： Arthur Clark , Douglas P. Brown , Anita Richards , Donald R. Pederson
IPC分类号： G06F11/00 , G06F11/07 , G06F11/14 , G06F11/34
CPC分类号： G06F11/0727 , G06F11/0793 , G06F11/142 , G06F11/143 , G06F11/3409 , G06F11/3419 , G06F11/3466 , G06F2201/80 , G06F2201/81 , G06F2201/815
摘要： A computer-implemented method, apparatus and article of manufacture for performing an automatic error recovery in a database system. Automatic error recovery is performed for a query execution plan, following errors, problems or failures that occur during execution, by automatically or manually deactivating and/or activating components, features or code paths, and then re-submitting the query execution plan for execution in the computer system.
摘要翻译：一种用于在数据库系统中执行自动错误恢复的计算机实现的方法，装置和制品。通过自动或手动去激活和/或激活组件，特征或代码路径，然后重新提交查询执行计划以执行查询执行计划，执行自动错误恢复，查询执行计划，执行后发生的错误，问题或故障计算机系统。

10. 发明申请

US20120173496A1 NUMERIC, DECIMAL AND DATE FIELD COMPRESSION 有权
标题翻译： NUMERIC，DECIMAL AND DATE FIELD COMPRESSION
公开(公告)号：US20120173496A1
公开(公告)日：2012-07-05
申请号：US13013651
申请日：2011-01-25
申请人： Mark A. Hodgens , Fred S. Kaufmann , Donald R. Pederson , Gary A. Roberts
发明人： Mark A. Hodgens , Fred S. Kaufmann , Donald R. Pederson , Gary A. Roberts
IPC分类号： G06F17/30
CPC分类号： G06F17/30501
摘要： A method, apparatus, and article of manufacture for accessing data in a computer system. Compression and decompression functions are associated with a column of the table, in order to perform compression of decimal, numeric or date data stored in the column when the data is inserted or updated in the table, and in order to perform decompression of the data stored in the column when the data is retrieved from the table. The compression function compresses and stores the data in a fixed-length compressed field in the column without a length value, and the fixed-length compressed field has a size that is determined by a range of values for the data stored in the fixed-length compressed field. The decompression function retrieves and decompresses the data from the fixed-length compressed field.
摘要翻译：一种用于访问计算机系统中的数据的方法，装置和制品。压缩和解压缩功能与表的列相关联，以便当在表中插入或更新数据时执行存储在列中的十进制，数字或日期数据的压缩，并且为了执行对存储的数据的解压缩在从表中检索数据的列中。压缩功能将数据压缩并存储在列中的固定长度压缩字段中，没有长度值，固定长度压缩字段具有由存储在固定长度中的数据的值的范围确定的大小压缩场。解压缩功能从固定长度压缩字段中检索和解压缩数据。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式