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

121. 发明授权

US07664799B2 In-memory space management for database systems 有权
标题翻译：数据库系统的内存空间管理
公开(公告)号：US07664799B2
公开(公告)日：2010-02-16
申请号：US11830568
申请日：2007-07-30
申请人： Niloy Mukherjee , Amit Ganesh , Sujatha Muthulingam , Wei Zhang
发明人： Niloy Mukherjee , Amit Ganesh , Sujatha Muthulingam , Wei Zhang
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , G06F9/5005 , G06F9/5016 , G06F9/526 , Y10S707/99956
摘要： A framework for in-memory space management for content management database systems is provided. A per-instance in-memory dispenser is partitioned. An incoming transaction takes a latch on a partition and obtains sufficient block usage to perform and complete the transaction. Generating redo information is decoupled from transaction level processing and, instead, is performed when block requests are loaded into the in-memory dispenser or synced therefrom to a per-instance on-disk structure.
摘要翻译：提供了内容管理数据库系统的内存空间管理框架。每个实例的内存分配器被分区。传入的事务在分区上占用一个锁存器，并获得足够的块使用来执行和完成事务。生成重做信息与事务级别处理分离，而是将块请求加载到内存分配器中或从其同步到每个实例磁盘结构时执行。

122. 发明申请

US20090106281A1 ON-LINE TRANSACTION PROCESSING (OLTP) COMPRESSION AND RE-COMPRESSION OF DATABASE DATA 有权
标题翻译：在线交易处理（OLTP）数据库数据的压缩和重新压缩
公开(公告)号：US20090106281A1
公开(公告)日：2009-04-23
申请号：US11875642
申请日：2007-10-19
申请人： Vineet Marwah , Valentin G. Stredie , Dheeraj Pandey , Amit Ganesh
发明人： Vineet Marwah , Valentin G. Stredie , Dheeraj Pandey , Amit Ganesh
IPC分类号： G06F7/00 , 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.
摘要翻译：计算机被编程为响应于由在线事务处理（OLTP）系统生成的数据库修改语言（DML）语句来压缩数据库的数据。在几个实施例中，最初添加到数据库块的数据保持未压缩，直到满足预定条件，这不常发生（相对于块上的OLTP事务）。当满足时，计算机自动压缩块中的所有未压缩数据，这增加了块中未使用的空间量。之后将新的数据未压缩地添加到部分压缩的块中，直到满足预定条件，从而再次压缩部分压缩的块，即重新压缩。重新添加新的数据到部分压缩的块并且其压缩被重复，除非满足另外的预定条件，响应于该块不被进一步重新压缩，从而识别对压缩获益的限制。

123. 发明授权

US07480662B2 Fact table storage in a decision support system environment 有权
标题翻译：事实表存储在决策支持系统环境中
公开(公告)号：US07480662B2
公开(公告)日：2009-01-20
申请号：US10719819
申请日：2003-11-20
申请人： Dmitry Potapov , Vishwanath Karra , Amit Ganesh , Jonathan Klein
发明人： Dmitry Potapov , Vishwanath Karra , Amit Ganesh , Jonathan Klein
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30595 , Y10S707/99932 , Y10S707/99943
摘要： A fact table is set up without any dimension columns. The data in the table is ordered according to an order corresponding to the ordering of the dimensions. The table is divided into segments corresponding to contiguous portions of data. The portions of the table containing non-null values for the measures are placed into the segments. The size of the segments and the location segments may be determined according to the density of discontinuities in the data. An indexed organized table is used to determine the beginning and end of each segment of the table, the locations of the discontinuities in the data, and to facilitate accessing the measures of the table.
摘要翻译：事实表设置没有任何维度列。表中的数据按照与尺寸顺序对应的顺序进行排序。该表被分成对应于数据的连续部分的段。包含度量值的非空值的表的部分被放入段中。可以根据数据中的不连续密度来确定段和位置段的大小。索引的有组织的表用于确定表的每个段的开始和结束，数据中的不连续性的位置，以及便于访问表的度量。

124. 发明申请

US20080281846A1 High performant row-level data manipulation using a data layer interface 有权
标题翻译：使用数据层接口执行高性能行级数据操作
公开(公告)号：US20080281846A1
公开(公告)日：2008-11-13
申请号：US11801930
申请日：2007-05-11
申请人： Thuvan Hoang , Anthony Giardullo , Amit Ganesh , Nimar S. Arora , Dheeraj Pandey , Lik Wong
发明人： Thuvan Hoang , Anthony Giardullo , Amit Ganesh , Nimar S. Arora , Dheeraj Pandey , Lik Wong
IPC分类号： G06F17/30
CPC分类号： G06F17/30377
摘要： Performing an operation directly on data stored in a database table provides for avoiding generation and processing of SQL statements. A Data Layer interface, comprising a set of APIs, allows internal database server components to call directly to the Data Layer for making fast row changes to a table. According to an embodiment, before making any row change to a table through this Data Layer interface, a shared state data structure is created to hold the metadata about the table. A single shared state can be used for all DML changes to a particular table regardless of what columns are updated or inserted during each DML operation. When a process needs to change a row, the process uses a mutable state based on the shared state of the table.
摘要翻译：直接对存储在数据库表中的数据执行操作可避免SQL语句的生成和处理。包含一组API的数据层接口允许内部数据库服务器组件直接调用数据层，以便对表进行快速行更改。根据实施例，在通过该数据层接口对表进行任何行更改之前，创建共享状态数据结构以保存关于表的元数据。无论在每个DML操作期间更新或插入哪些列，单个共享状态可用于对特定表的所有DML更改。当进程需要更改一行时，进程将使用基于表的共享状态的可变状态。

125. 发明授权

US07418544B2 Method and system for log structured relational database objects 有权
标题翻译：日志结构关系数据库对象的方法和系统
公开(公告)号：US07418544B2
公开(公告)日：2008-08-26
申请号：US11245359
申请日：2005-10-05
申请人： Niloy Mukherjee , Amit Ganesh
发明人： Niloy Mukherjee , Amit Ganesh
IPC分类号： G06F12/16 , G06F17/30
CPC分类号： G06F3/0659 , G06F3/061 , G06F3/0644 , G06F3/0656 , G06F3/0676 , Y10S707/99952 , Y10S707/99953
摘要： A system, method, computer program and article of manufacture for updating a disk that moves updates for a specific database object into available contiguous free data blocks, and writes the multiple updates to disk using a single disk access, maintaining database transactional and durability semantics.
摘要翻译：用于更新将特定数据库对象的更新移动到可用的连续空闲数据块的系统，方法，计算机程序和制造品，以及使用单个磁盘访问将多个更新写入磁盘，维护数据库事务和持久性语义。

126. 发明申请

US20080098083A1 System and method for data de-duplication 有权
标题翻译：用于重复数据删除的系统和方法
公开(公告)号：US20080098083A1
公开(公告)日：2008-04-24
申请号：US11584782
申请日：2006-10-19
申请人： Kam Shergill , Bharath Aleti , Dheerai Pandey , Sajatha Muthulingam , Amit Ganesh
发明人： Kam Shergill , Bharath Aleti , Dheerai Pandey , Sajatha Muthulingam , Amit Ganesh
IPC分类号： G06F15/16
CPC分类号： G06F17/30303 , G06F11/1453 , G06F17/30156
摘要： A method of processing a file includes receiving a request to store the file, receiving the file, determining whether a database already contains the file, and storing the file in the database if the database does not already contain the file. A method of processing a file includes receiving a request to store the file, receiving the file, determining whether a database already contains the file, and satisfying the request to store the file without storing the received file if the database already contains the file. A method of processing data from a file includes receiving a request to store the file in a database, receiving the file, separating the file into a plurality of portions, and storing the plurality of portions such that each of the plurality of portions can be individually accessed.
摘要翻译：处理文件的方法包括：如果数据库尚未包含文件，则接收存储文件的请求，接收文件，确定数据库是否已经包含该文件，以及将该文件存储在数据库中。处理文件的方法包括接收文件的存储请求，接收文件，确定数据库是否已经包含文件，如果数据库已经包含该文件，则满足存储文件的请求而不存储所接收的文件。一种从文件处理数据的方法包括：接收将文件存储在数据库中的请求，接收文件，将文件分离成多个部分，并存储多个部分，使得多个部分中的每一个可以单独地访问。

127. 发明授权

US07277900B1 Method and mechanism for rolling back a transaction on a row of data 有权
标题翻译：在一行数据上回滚事务的方法和机制
公开(公告)号：US07277900B1
公开(公告)日：2007-10-02
申请号：US10364065
申请日：2003-02-10
申请人： Amit Ganesh , Kenneth R. Jacobs , Jonathan Klein , Archna Kalra Johnson , Vivekanandhan Raja
发明人： Amit Ganesh , Kenneth R. Jacobs , Jonathan Klein , Archna Kalra Johnson , Vivekanandhan Raja
IPC分类号： G06F17/30
CPC分类号： G06F17/30551 , Y10S707/99938 , Y10S707/99952 , Y10S707/99953
摘要： A method and mechanism to compensate for the effects of a transaction in a database system is disclosed. Also disclosed is a method and mechanism for identifying one or more transactions that have modified or created an object in a database system. The disclosed approach can be applied to perform auditing for queries in a database system and for identifying the scope of changes and data accesses made by a transaction in the system.
摘要翻译：公开了一种补偿数据库系统中事务的影响的方法和机制。还公开了一种用于识别在数据库系统中修改或创建对象的一个或多个事务的方法和机制。所公开的方法可以应用于对数据库系统中的查询执行审计，并且用于识别由系统中的事务进行的更改和数据访问的范围。

128. 发明授权

US07133941B2 Method and mechanism of accessing segments in data storage systems 有权
标题翻译：数据存储系统中访问段的方法和机制
公开(公告)号：US07133941B2
公开(公告)日：2006-11-07
申请号：US10727775
申请日：2003-12-03
申请人： Jonathan D. Klein , Amit Ganesh
发明人： Jonathan D. Klein , Amit Ganesh
IPC分类号： G06F13/00
CPC分类号： G06F3/0659 , G06F3/0613 , G06F3/0644 , G06F3/0674 , Y10S707/99931 , Y10S707/99953
摘要： A method and mechanism of accessing segments in data storage systems is disclosed. In one embodiment, extents in a segment are coalesced into groups based on the data storage device each extent is stored on. Rather than submit an I/O operation for each extent, a single I/O operation is submitted for each group of extents.
摘要翻译：公开了一种在数据存储系统中访问段的方法和机制。在一个实施例中，段中的区段基于存储在其上的数据存储设备而合并成组。不是为每个区段提交I / O操作，而是为每个区段提交单个I / O操作。

129. 发明授权

US07010529B2 Method and mechanism for dependency tracking at low granularity levels 有权
标题翻译：低粒度级别依赖跟踪的方法和机制
公开(公告)号：US07010529B2
公开(公告)日：2006-03-07
申请号：US10961963
申请日：2004-10-08
申请人： Jonathan D. Klein , Amit Ganesh
发明人： Jonathan D. Klein , Amit Ganesh
IPC分类号： G06F17/30
CPC分类号： G06F17/30575 , G06F17/30345 , Y10S707/99938 , Y10S707/99943 , Y10S707/99944 , Y10S707/99945 , Y10S707/99952 , Y10S707/99953
摘要： A method and mechanism for tracking dependencies at low granularity levels in a database system is disclosed. An embodiment utilities commit time values at low granularity levels which are associated with structures in a database system. Those associated commit time values are used to compute dependency values.
摘要翻译：公开了一种用于在数据库系统中以低粒度级跟踪依赖性的方法和机制。实施例实用程序以低粒度级别提交与数据库系统中的结构相关联的时间值。这些相关联的提交时间值用于计算依赖关系值。

130. 发明授权

US06961729B1 Processing in parallel units of work that perform DML operations on the same spanning rows 有权
标题翻译：在并行的工作单元中处理在相同跨度行上执行DML操作
公开(公告)号：US06961729B1
公开(公告)日：2005-11-01
申请号：US09771292
申请日：2001-01-25
申请人： Rosanne Park Toohey , Jonathan D. Klein , Amit Ganesh , Gary C. Ngai , Dmitry Mikhailovich Potapov
发明人： Rosanne Park Toohey , Jonathan D. Klein , Amit Ganesh , Gary C. Ngai , Dmitry Mikhailovich Potapov
IPC分类号： G06F17/30
CPC分类号： G06F17/30445 , Y10S707/99942 , Y10S707/99944
摘要： A mechanism is described for constructing work granules, where the work granules are constructed independently of whether two or more of the work granules are assigned to operate on a logical storage unit that contains a portion of the same row. A database system maintains transaction control data for data blocks in a manner that avoids self-deadlocks for slaves that follow a row collision protocol. A row collision protocol is a set of rules or steps that slaves follow to ensure that only one subtransaction in a distributed transaction updates a spanning row. Thus, for a particular spanning row, a single subtransaction modifies all the row pieces of the spanning row in any data block containing any row pieces of the spanning row. Consequently, a given data block may be affected by multiple subtransactions in a distributed transaction, one subtransaction affecting a row piece in the data block, another subtransaction affecting other rows in the data block.
摘要翻译：描述了用于构造工作颗粒的机构，其中工作颗粒被构造为独立于是否分配两个或更多个工作颗粒以在包含相同行的一部分的逻辑存储单元上操作。数据库系统以避免针对跟随行冲突协议的从站的自死锁的方式维护数据块的事务控制数据。行冲突协议是一组随后遵循的规则或步骤，以确保分布式事务中只有一个子事务更新跨越行。因此，对于特定的跨越行，单个子迁移修改包含跨越行的任何行的任何数据块中的跨越行的所有行。因此，给定的数据块可能受到分布式事务中的多个子事务的影响，影响数据块中的行块的一个子事务处理，影响数据块中的其他行的另一个子事务处理。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式