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

1. 发明授权

US09910893B2 Failover and resume when using ordered sequences in a multi-instance database environment 有权
公开(公告)号：US09910893B2
公开(公告)日：2018-03-06
申请号：US13309300
申请日：2011-12-01
申请人： Fulu Li , Atsushi Morimura , Michael Zoll , Vineet Marwah , Amit Ganesh
发明人： Fulu Li , Atsushi Morimura , Michael Zoll , Vineet Marwah , Amit Ganesh
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/3048
摘要： An approach is disclosed for implementing failover and resume when using ordered sequences in a multi-instance database environment. The approach commences by instantiating a first database instance initially to serve as an active instance, then instantiating a second database instance to serve as an instance of one or more passive instances. The active database establishes mastership over a sequence and then processes requests for the ‘next’ symbol by accessing a shared sequence cache only after accessing a first instance semaphore. The active instance and the passive instance perform a protocol such that upon passive database detection of a failure of the active database, one of the passive database instances takes over mastership of the sequence cache, and then proceeds to satisfy sequence value requests. The particular order is observed in spite of the failure.

2. 发明申请

US20130145103A1 REDUCING SEQUENCE CACHE LATCH CONTENTION IN A DATABASE SYSTEM 有权
标题翻译：减少数据库系统中的序列缓存锁定
公开(公告)号：US20130145103A1
公开(公告)日：2013-06-06
申请号：US13309394
申请日：2011-12-01
申请人： Fulu LI , Vineet MARWAH , Amit GANESH
发明人： Fulu LI , Vineet MARWAH , Amit GANESH
IPC分类号： G06F12/08
CPC分类号： G06F17/30 , G06F17/30348
摘要： In a database system having a plurality of concurrently executing session processes, the method commences by establishing a master list of sequences, the master list comprising a plurality of sequence objects which in turn define a sequence of values used for numbering and other identification within the database system. To reduce sequence cache latch access contention, multiple tiers of latches are provided. Methods of the system provide a first tier having a first tier “global” latch to serialize access to the master list such that at any point in time, only one of the concurrently executing session processes is granted access to the master list, from which master list are allocated sequences on demand. A second tier of latches is provided, the second tier having multiple second tier latches to serialize access to corresponding allocated sequences of values such that at any point in time, only one of the concurrently executing session processes is granted access to the allocated sequence. The multiple tiers serve to reduce the likelihood of contention to the first tier latch.
摘要翻译：在具有多个同时执行的会话处理的数据库系统中，该方法通过建立序列的主列表开始，主列表包括多个序列对象，这些序列对象又定义用于数据库中的编号和其他识别的值序列系统。为了减少序列高速缓存锁存器访问争用，提供多层锁存器。系统的方法提供具有第一层“全局”锁存器的第一层以序列化对主列表的访问，使得在任何时间点，只有一个并发执行的会话进程被授予访问主列表，主从哪个主列表按需分配序列。提供了第二层锁存器，第二层具有多个第二层锁存器，以串行化对相应分配的值序列的访问，使得在任何时间点，只允许一个并发执行的会话进程访问所分配的序列。多层用于减少与第一层锁存器争用的可能性。

3. 发明申请

US20110029569A1 DDL AND DML SUPPORT FOR HYBRID COLUMNAR COMPRESSED TABLES 有权
标题翻译： DDL和DML支持混合柱压缩表
公开(公告)号：US20110029569A1
公开(公告)日：2011-02-03
申请号：US12871882
申请日：2010-08-30
申请人： Amit GANESH , Vikram KAPOOR , Vineet MARWAH , Kam SHERGILL , Roger MacNICOL , Sachin KULKARNI , Jesse KAMP
发明人： Amit GANESH , Vikram KAPOOR , Vineet MARWAH , Kam SHERGILL , Roger MacNICOL , Sachin KULKARNI , Jesse KAMP
IPC分类号： G06F17/30
CPC分类号： G06F17/30595
摘要： Techniques for storing and manipulating tabular data are provided. According to one embodiment, a user may control whether tabular data is stored in row-level or column-major format. Furthermore, the user may control the level of data compression to achieve an optimal balance between query performance and compression ratios. Tabular data from within the same table may be stored in both column-major and row-major format and compressed at different levels. In addition, tabular data can migrate between column-major format and row-major format in response to various events. For example, in response to a request to update or lock a row stored in column-major format, the row may be migrated and subsequently stored into row-major format. In one embodiment, table partitions are used to enhance data compression techniques. For example, compression tests are performed on a representative table partition, and a compression map is generated and applied to other table partitions.
摘要翻译：提供了存储和操作表格数据的技术。根据一个实施例，用户可以控制表格数据是以行主列还是列主格式存储。此外，用户可以控制数据压缩的水平，以实现查询性能和压缩比之间的最佳平衡。来自同一表格的表格数据可以以列主和行主格式存储，并在不同级别进行压缩。此外，响应于各种事件，表格数据可以在列主格式和行主格式之间迁移。例如，响应于更新或锁定以列主格式存储的行的请求，该行可以被迁移并且随后被存储为行主格式。在一个实施例中，表分区用于增强数据压缩技术。例如，压缩测试在代表性的表格分区上执行，生成压缩映射并将其应用于其他表格分区。

4. 发明授权

US07634510B2 Method and system for time-based reclamation of objects from a recycle bin in a database 有权
标题翻译：从数据库回收站中对象进行时间回收的方法和系统
公开(公告)号：US07634510B2
公开(公告)日：2009-12-15
申请号：US10959565
申请日：2004-10-05
申请人： Vineet Marwah
发明人： Vineet Marwah
IPC分类号： G06F17/30
CPC分类号： G06F17/30312 , G06F17/30309 , Y10S707/99944 , Y10S707/99953
摘要： A system for managing dropped objects of a database. The system comprises a finite amount of disk space for temporarily storing the dropped objects. The system further includes an indexer for assigning time stamps to each of the dropped objects and a reclaimer for reclaiming the dropped objects based on their time stamps. These time stamps can also be used to guarantee the amount of time the object remains in the recycle bin.
摘要翻译：用于管理数据库的丢弃对象的系统。该系统包括用于临时存储丢弃的对象的有限量的磁盘空间。该系统还包括用于为每个丢弃的对象分配时间戳的索引器和用于基于其时间戳来回收丢弃的对象的回收器。这些时间戳也可以用来保证物品保留在回收站中的时间。

5. 发明授权

US08583692B2 DDL and DML support for hybrid columnar compressed tables 有权
标题翻译： DDL和DML支持混合柱状压缩表
公开(公告)号：US08583692B2
公开(公告)日：2013-11-12
申请号：US12871882
申请日：2010-08-30
申请人： Amit Ganesh , Vikram Kapoor , Vineet Marwah , Kam Shergill , Roger MacNicol , Sachin Kulkarni , Jesse Kamp
发明人： Amit Ganesh , Vikram Kapoor , Vineet Marwah , Kam Shergill , Roger MacNicol , Sachin Kulkarni , Jesse Kamp
IPC分类号： G06F17/30
CPC分类号： G06F17/30595
摘要： Techniques for storing and manipulating tabular data are provided. According to one embodiment, a user may control whether tabular data is stored in row-level or column-major format. Furthermore, the user may control the level of data compression to achieve an optimal balance between query performance and compression ratios. Tabular data from within the same table may be stored in both column-major and row-major format and compressed at different levels. In addition, tabular data can migrate between column-major format and row-major format in response to various events. For example, in response to a request to update or lock a row stored in column-major format, the row may be migrated and subsequently stored into row-major format. In one embodiment, table partitions are used to enhance data compression techniques. For example, compression tests are performed on a representative table partition, and a compression map is generated and applied to other table partitions.
摘要翻译：提供了存储和操作表格数据的技术。根据一个实施例，用户可以控制表格数据是以行主列还是列主格式存储。此外，用户可以控制数据压缩的水平，以实现查询性能和压缩比之间的最佳平衡。来自同一表格的表格数据可以以列主和行主格式存储，并在不同级别进行压缩。此外，响应于各种事件，表格数据可以在列主格式和行主格式之间迁移。例如，响应于更新或锁定以列主格式存储的行的请求，该行可以被迁移并且随后被存储为行主格式。在一个实施例中，表分区用于增强数据压缩技术。例如，压缩测试在代表性的表格分区上执行，生成压缩映射并将其应用于其他表格分区。

6. 发明授权

US08521789B2 Undrop objects and dependent objects in a database system 有权
标题翻译：在数据库系统中取消对象和依赖对象
公开(公告)号：US08521789B2
公开(公告)日：2013-08-27
申请号：US10445793
申请日：2003-05-27
申请人： Vineet Marwah
发明人： Vineet Marwah
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30377 , G06F2216/09
摘要： Techniques for undropping objects (e.g., tables) and dependent objects in a database systems are provided. When an object is dropped, the object is moved to a recycle bin where it resides until the user undrops the objects or the object is purged. Dependent objects are also moved into the recycle bin with the object to which they depend. The object can be purged from the recycle bin explicitly by a user or when more storage space is needed. Purging of dependent objects and partitions can be deferred if not required to obtain more storage space.
摘要翻译：提供了用于在数据库系统中展开对象（例如，表）和依赖对象的技术。当对象被删除时，对象被移动到它所驻留的回收站，直到用户展开对象或被清除对象为止。依赖对象也被移动到与它们所依赖的对象的回收站中。对象可以由用户明确地从回收站清除，或者需要更多的存储空间。如果不需要清除依赖对象和分区，则可以延迟获取更多的存储空间。

7. 发明授权

US08521784B2 DDL and DML support for hybrid columnar compressed tables 有权
公开(公告)号：US08521784B2
公开(公告)日：2013-08-27
申请号：US12871882
申请日：2010-08-30
申请人： Amit Ganesh , Vikram Kapoor , Vineet Marwah , Kam Shergill , Roger MacNicol , Sachin Kulkarni , Jesse Kamp
发明人： Amit Ganesh , Vikram Kapoor , Vineet Marwah , Kam Shergill , Roger MacNicol , Sachin Kulkarni , Jesse Kamp
IPC分类号： G06F17/30
摘要： Techniques for storing and manipulating tabular data are provided. According to one embodiment, a user may control whether tabular data is stored in row-level or column-major format. Furthermore, the user may control the level of data compression to achieve an optimal balance between query performance and compression ratios. Tabular data from within the same table may be stored in both column-major and row-major format and compressed at different levels. In addition, tabular data can migrate between column-major format and row-major format in response to various events. For example, in response to a request to update or lock a row stored in column-major format, the row may be migrated and subsequently stored into row-major format. In one embodiment, table partitions are used to enhance data compression techniques. For example, compression tests are performed on a representative table partition, and a compression map is generated and applied to other table partitions.

8. 发明申请

US20130159246A1 ON-LINE TRANSACTION PROCESSING (OLTP) COMPRESSION AND RE-COMPRESSION OF DATABASE DATA 有权
公开(公告)号：US20130159246A1
公开(公告)日：2013-06-20
申请号：US13763663
申请日：2013-02-09
申请人： Vineet Marwah , Valentin G. Stredie , Dheeraj Pandey , Amit Ganesh
发明人： Vineet Marwah , Valentin G. Stredie , Dheeraj Pandey , Amit Ganesh
IPC分类号： G06F17/30
CPC分类号： G06F17/30563 , G06F17/30315 , G06F17/30377 , G06F17/30592 , G06F2212/401 , H03M7/30
摘要： A computer is programmed to compress data of a database in response to database modification language (DML) statements generated by on-line transaction processing (OLTP) systems. In several embodiments, data that is initially added to a database block is left uncompressed until a predetermined condition is satisfied, which happens infrequently (relative to OLTP transactions on the block). When satisfied, the computer automatically compresses all uncompressed data in the block, which increases the amount of unused space in the block. New data is thereafter added uncompressed to the partially compressed block, until satisfaction of a predetermined condition whereby the partially compressed block is again compressed, i.e. re-compressed. Adding of new data to a partially compressed block and its compression are repeated unless another predetermined condition is met, in response to which the block is not further re-compressed, thereby to recognize a limit on the benefit from compression.

9. 发明申请

US20120054225A1 Query and Exadata Support for Hybrid Columnar Compressed Data 有权
标题翻译：查询和Exadata支持混合柱状压缩数据
公开(公告)号：US20120054225A1
公开(公告)日：2012-03-01
申请号：US12871824
申请日：2010-08-30
申请人： Vineet Marwah , Vikram Kapoor , Jesse Kamp , Kam Shergill , Roger Macnicol , Sachin Kulkami , Amit Ganesh
发明人： Vineet Marwah , Vikram Kapoor , Jesse Kamp , Kam Shergill , Roger Macnicol , Sachin Kulkami , Amit Ganesh
IPC分类号： G06F17/30
CPC分类号： G06F17/30442 , G06F17/30477 , G06F17/30522
摘要： A method and apparatus is provided for optimizing queries received by a database system that relies on an intelligent data storage server to manage storage for the database system. Storing compression units in hybrid columnar format, the storage manager evaluates simple predicates and only returns data blocks containing rows that satisfy those predicates. The returned data blocks are not necessarily stored persistently on disk. That is, the storage manager is not limited to returning disc block images. The hybrid columnar format enables optimizations that provide better performance when processing typical database workloads including both fetching rows by identifier and performing table scans.
摘要翻译：提供了一种方法和装置，用于优化由数据库系统接收的依赖于智能数据存储服务器来管理数据库系统的存储的查询。以混合列格式存储压缩单元，存储管理器将评估简单谓词，并仅返回包含满足这些谓词的行的数据块。返回的数据块不一定存储在磁盘上。也就是说，存储管理器不限于返回盘块图像。混合柱状格式可以实现在处理典型数据库工作负载时提供更好性能的优化，包括通过标识符提取行和执行表扫描。

10. 发明授权

US08645337B2 Storing compression units in relational tables 有权
标题翻译：将压缩单元存储在关系表中
公开(公告)号：US08645337B2
公开(公告)日：2014-02-04
申请号：US12769205
申请日：2010-04-28
申请人： Vikram Kapoor , Amit Ganesh , Jesse Kamp , Sachin Kulkarni , Vineet Marwah , Kam Shergill , Roger Macnicol , Manosiz Bhattacharyya
发明人： Vikram Kapoor , Amit Ganesh , Jesse Kamp , Sachin Kulkarni , Vineet Marwah , Kam Shergill , Roger Macnicol , Manosiz Bhattacharyya
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30153 , G06F17/30501 , G06F17/30955
摘要： A database server stores compressed units in data blocks of a database. A table (or data from a plurality of rows thereof) is first compressed into a “compression unit” using any of a wide variety of compression techniques. The compression unit is then stored in one or more data block rows across one or more data blocks. As a result, a single data block row may comprise compressed data for a plurality of table rows, as encoded within the compression unit. Storage of compression units in data blocks maintains compatibility with existing data block-based databases, thus allowing the use of compression units in preexisting databases without modification to the underlying format of the database. The compression units may, for example, co-exist with uncompressed tables. Various techniques allow a database server to optimize access to data in the compression unit, so that the compression is virtually transparent to the user.
摘要翻译：数据库服务器将压缩单位存储在数据库的数据块中。使用各种各样的压缩技术中的任一种，首先将表（或其多行的数据）压缩为“压缩单位”。然后，压缩单元被存储在跨越一个或多个数据块的一个或多个数据块行。结果，单个数据块行可以包括在压缩单元内编码的多个表行的压缩数据。数据块中的压缩单元的存储与现有的基于数据块的数据库保持兼容，从而允许在预先存在的数据库中使用压缩单元，而无需修改数据库的底层格式。压缩单元可以例如与未压缩的表共存。各种技术允许数据库服务器优化对压缩单元中的数据的访问，使得压缩对于用户实际上是透明的。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式