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

1. 发明授权

US07873605B2 Apparatus to selectively remove the effects of transactions in online database and enable logical recovery 有权
标题翻译：用于选择性地消除在线数据库中事务的影响并启用逻辑恢复的装置
公开(公告)号：US07873605B2
公开(公告)日：2011-01-18
申请号：US11699689
申请日：2007-01-29
申请人： Manosiz Bhattacharyya , Bipul Sinha , Amit Ganesh
发明人： Manosiz Bhattacharyya , Bipul Sinha , Amit Ganesh
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30377
摘要： A method and apparatus for selective removal of user data changes is provided. In one embodiment, the methodology is implemented by a logical recovery mechanism. Upon receiving a request to selectively remove user data changes stored in a database, the mechanism creates an empty set of transactions to be populated for selective removal, identifies one or more transactions and places them in the causal set of transactions. The mechanism further identifies other transactions that logically depend on any transaction already in the causal set of transactions. Finally, either while the causal set of transactions is being identified or after the identification is completed, the mechanism also determines user data changes made by the causal set of transactions. One or more compensating transactions may be generated by the logical recovery mechanism, which when executed, reverse the user data changes.
摘要翻译：提供了用于选择性地去除用户数据变化的方法和装置。在一个实施例中，该方法由逻辑恢复机制来实现。在接收到选择性地删除存储在数据库中的用户数据改变的请求时，该机制创建要填充的空的一组事务以进行选择性删除，识别一个或多个事务并将它们放置在因果集合中。该机制进一步识别逻辑上依赖于因果交易集合中的任何交易的其他交易。最后，既然确定了交易的因果集合，或者在识别完成之后，该机制还确定了因果集交易所做的用户数据更改。一个或多个补偿事务可以由逻辑恢复机制产生，逻辑恢复机制在执行时反转用户数据改变。

2. 发明申请

US20080183686A1 Apparatus to selectively remove the effects of transactions in online database and enable logical recovery 有权
标题翻译：用于选择性地消除在线数据库中事务的影响并启用逻辑恢复的装置
公开(公告)号：US20080183686A1
公开(公告)日：2008-07-31
申请号：US11699689
申请日：2007-01-29
申请人： Manosiz Bhattacharyya , Bipul Sinha , Amit Ganesh
发明人： Manosiz Bhattacharyya , Bipul Sinha , Amit Ganesh
IPC分类号： G06F17/30
CPC分类号： G06F17/30377
摘要： A method and apparatus for selective removal of user data changes is provided. In one embodiment, the methodology is implemented by a logical recovery mechanism. Upon receiving a request to selectively remove user data changes stored in a database, the mechanism creates an empty set of transactions to be populated for selective removal, identifies one or more transactions and places them in the causal set of transactions. The mechanism further identifies other transactions that logically depend on any transaction already in the causal set of transactions. Finally, either while the causal set of transactions is being identified or after the identification is completed, the mechanism also determines user data changes made by the causal set of transactions. One or more compensating transactions may be generated by the logical recovery mechanism, which when executed, reverse the user data changes.
摘要翻译：提供了用于选择性地去除用户数据变化的方法和装置。在一个实施例中，该方法由逻辑恢复机制来实现。在接收到选择性地删除存储在数据库中的用户数据改变的请求时，该机制创建要填充的空的一组事务以进行选择性删除，识别一个或多个事务并将它们放置在因果集合中。该机制进一步识别逻辑上依赖于因果交易集合中的任何交易的其他交易。最后，既然确定了交易的因果集合，或者在识别完成之后，该机制还确定了因果集交易所做的用户数据更改。一个或多个补偿事务可以由逻辑恢复机制产生，逻辑恢复机制在执行时反转用户数据改变。

3. 发明申请

US20070288529A1 Framework to optimize delete all rows operations on database objects 有权
标题翻译：优化框架来删除数据库对象上的所有行操作
公开(公告)号：US20070288529A1
公开(公告)日：2007-12-13
申请号：US11450092
申请日：2006-06-09
申请人： Amit Ganesh , Niloy Mukherjee , Manosiz Bhattacharyya , Bipul Sinha
发明人： Amit Ganesh , Niloy Mukherjee , Manosiz Bhattacharyya , Bipul Sinha
IPC分类号： G06F17/30
CPC分类号： G06F17/30442
摘要： A bulk delete operation with reduced latency allows for retrieval of deleted data. Each database object holds a Delete SCN indicating when a bulk delete operation was last performed. Each row in the database object holds a Row Modification SCN indicating when the row was last updated. A bulk delete is performed by writing the old value of the Delete SCN to the undo tablespace and updating the Delete SCN. No undo information is stored for the rows. A write is performed by finding a deleted row, storing undo information for the deleted row and writing over the deleted row. To read from the database object, a rollback operation is performed, if necessary. Those rows are then retrieved for which the Row Modification SCN is higher than the Delete SCN and is less than or equal to the timestamp for the requested data.
摘要翻译：减少延迟的批量删除操作允许检索已删除的数据。每个数据库对象保存一个删除SCN，指示上次执行批量删除操作的时间。数据库对象中的每一行都保存一行行修改SCN，指示行何时上次更新。通过将删除SCN的旧值写入undo表空间并更新删除SCN来执行批量删除。没有为行存储撤消信息。通过查找删除的行，存储删除的行的撤消信息并写入被删除的行来执行写入。要从数据库对象读取，必要时执行回滚操作。然后检索行修改SCN高于删除SCN并且小于或等于所请求数据的时间戳的那些行。

4. 发明授权

US08856083B2 Framework to optimize delete all row operations on database objects to improve throughput, query ability and flashback 有权
标题翻译：优化框架来删除数据库对象上的所有行操作，以提高吞吐量，查询能力和回发
公开(公告)号：US08856083B2
公开(公告)日：2014-10-07
申请号：US11450092
申请日：2006-06-09
申请人： Amit Ganesh , Niloy Mukherjee , Manosiz Bhattacharyya , Bipul Sinha
发明人： Amit Ganesh , Niloy Mukherjee , Manosiz Bhattacharyya , Bipul Sinha
IPC分类号： G06F7/00 , G06F17/30 , G06F17/00
CPC分类号： G06F17/30442
摘要： A bulk delete operation with reduced latency allows for retrieval of deleted data. Each database object holds a Delete SCN indicating when a bulk delete operation was last performed. Each row in the database object holds a Row Modification SCN indicating when the row was last updated. A bulk delete is performed by writing the old value of the Delete SCN to the undo tablespace and updating the Delete SCN. No undo information is stored for the rows. A write is performed by finding a deleted row, storing undo information for the deleted row and writing over the deleted row. To read from the database object, a rollback operation is performed, if necessary. Those rows are then retrieved for which the Row Modification SCN is higher than the Delete SCN and is less than or equal to the timestamp for the requested data.
摘要翻译：减少延迟的批量删除操作允许检索已删除的数据。每个数据库对象保存一个删除SCN，指示上次执行批量删除操作的时间。数据库对象中的每一行都保存一行行修改SCN，指示行何时上次更新。通过将删除SCN的旧值写入undo表空间并更新删除SCN来执行批量删除。没有为行存储撤消信息。通过查找删除的行，存储删除的行的撤消信息并写入被删除的行来执行写入。要从数据库对象读取，必要时执行回滚操作。然后检索行修改SCN高于删除SCN并且小于或等于所请求数据的时间戳的那些行。

5. 发明申请

US20100281079A1 COMPRESSION ANALYZER 有权
标题翻译：压缩分析仪
公开(公告)号：US20100281079A1
公开(公告)日：2010-11-04
申请号：US12769508
申请日：2010-04-28
申请人： Vineet Marwah , Vikram Kapoor , Amit Ganesh , Jesse Kamp , Sachin Kulkarni , Roger Macnicol , Kam Shergill , Manosiz Bhattacharyya
发明人： Vineet Marwah , Vikram Kapoor , Amit Ganesh , Jesse Kamp , Sachin Kulkarni , Roger Macnicol , Kam Shergill , Manosiz Bhattacharyya
IPC分类号： G06F17/30
CPC分类号： H03M7/30 , G06F17/30595
摘要： Techniques are described herein for automatically selecting the compression techniques to be used on tabular data. A compression analyzer gives users high-level control over the selection process without requiring the user to know details about the specific compression techniques that are available to the compression analyzer. Users are able to specify, for a given set of data, a “balance point” along the spectrum between “maximum performance” and “maximum compression”. The point thus selected is used by the compression analyzer in a variety of ways. For example, in one embodiment, the compression analyzer uses the user-specified balance point to determine which of the available compression techniques qualify as “candidate techniques” for the given set of data. The compression analyzer selects the compression technique to use on a set of data by actually testing the candidate compression techniques against samples from the set of data. After testing the candidate compression techniques against the samples, the resulting compression ratios are compared. The compression technique to use on the set of data is then selected based, in part, on the compression ratios achieved during the compression tests performed on the sample data.
摘要翻译：这里描述了用于自动选择要在表格数据上使用的压缩技术的技术。压缩分析仪为用户提供了对选择过程的高级控制，而不需要用户了解有关压缩分析器可用的特定压缩技术的细节。用户可以为给定的数据集指定沿“最大性能”和“最大压缩”之间的“平衡点”。所选择的点由压缩分析器以各种方式使用。例如，在一个实施例中，压缩分析器使用用户指定的平衡点来确定哪个可用的压缩技术符合给定的数据集合的“候选技术”。压缩分析仪通过对来自该组数据的样本实际测试候选压缩技术来选择对一组数据使用的压缩技术。在针对样品测试候选压缩技术之后，比较所得到的压缩比。然后，部分地基于在对样本数据执行的压缩测试期间实现的压缩比来选择在该组数据上使用的压缩技术。

6. 发明授权

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.
摘要翻译：数据库服务器将压缩单位存储在数据库的数据块中。使用各种各样的压缩技术中的任一种，首先将表（或其多行的数据）压缩为“压缩单位”。然后，压缩单元被存储在跨越一个或多个数据块的一个或多个数据块行。结果，单个数据块行可以包括在压缩单元内编码的多个表行的压缩数据。数据块中的压缩单元的存储与现有的基于数据块的数据库保持兼容，从而允许在预先存在的数据库中使用压缩单元，而无需修改数据库的底层格式。压缩单元可以例如与未压缩的表共存。各种技术允许数据库服务器优化对压缩单元中的数据的访问，使得压缩对于用户实际上是透明的。

7. 发明申请

US20100281004A1 STORING COMPRESSION UNITS IN RELATIONAL TABLES 有权
标题翻译：在关系表中存储压缩单位
公开(公告)号：US20100281004A1
公开(公告)日：2010-11-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分类号： 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.
摘要翻译：数据库服务器将压缩单位存储在数据库的数据块中。使用各种各样的压缩技术中的任一种，首先将表（或其多行的数据）压缩为“压缩单元”。然后，压缩单元被存储在跨越一个或多个数据块的一个或多个数据块行。结果，单个数据块行可以包括在压缩单元内编码的多个表行的压缩数据。数据块中的压缩单元的存储与现有的基于数据块的数据库保持兼容，从而允许在预先存在的数据库中使用压缩单元，而无需修改数据库的底层格式。压缩单元可以例如与未压缩的表共存。各种技术允许数据库服务器优化对压缩单元中的数据的访问，使得压缩对于用户实际上是透明的。

8. 发明授权

US08356060B2 Compression analyzer 有权
标题翻译：压缩分析仪
公开(公告)号：US08356060B2
公开(公告)日：2013-01-15
申请号：US12769508
申请日：2010-04-28
申请人： Vineet Marwah , Vikram Kapoor , Amit Ganesh , Jesse Kamp , Sachin Kulkarni , Roger Macnicol , Kam Shergill , Manosiz Bhattacharyya
发明人： Vineet Marwah , Vikram Kapoor , Amit Ganesh , Jesse Kamp , Sachin Kulkarni , Roger Macnicol , Kam Shergill , Manosiz Bhattacharyya
IPC分类号： G06F7/00
CPC分类号： H03M7/30 , G06F17/30595
摘要： Techniques are described herein for automatically selecting the compression techniques to be used on tabular data. A compression analyzer gives users high-level control over the selection process without requiring the user to know details about the specific compression techniques that are available to the compression analyzer. Users are able to specify, for a given set of data, a “balance point” along the spectrum between “maximum performance” and “maximum compression”. The point thus selected is used by the compression analyzer in a variety of ways. For example, in one embodiment, the compression analyzer uses the user-specified balance point to determine which of the available compression techniques qualify as “candidate techniques” for the given set of data. The compression analyzer selects the compression technique to use on a set of data by actually testing the candidate compression techniques against samples from the set of data. After testing the candidate compression techniques against the samples, the resulting compression ratios are compared. The compression technique to use on the set of data is then selected based, in part, on the compression ratios achieved during the compression tests performed on the sample data.
摘要翻译：这里描述了用于自动选择要在表格数据上使用的压缩技术的技术。压缩分析仪为用户提供了对选择过程的高级控制，而不需要用户了解有关压缩分析器可用的特定压缩技术的细节。用户可以为给定的数据集指定沿最大性能和最大压缩之间的平衡点。所选择的点由压缩分析器以各种方式使用。例如，在一个实施例中，压缩分析器使用用户指定的平衡点来确定哪些可用的压缩技术被鉴定为用于给定的一组数据的候选技术。压缩分析仪通过对来自该组数据的样本实际测试候选压缩技术来选择对一组数据使用的压缩技术。在针对样品测试候选压缩技术之后，比较所得到的压缩比。然后，部分地基于在对样本数据执行的压缩测试期间实现的压缩比来选择在该组数据上使用的压缩技术。

9. 发明授权

US08239421B1 Techniques for compression and processing optimizations by using data transformations 有权
标题翻译：使用数据转换进行压缩和处理优化的技术
公开(公告)号：US08239421B1
公开(公告)日：2012-08-07
申请号：US12871862
申请日：2010-08-30
申请人： Vineet Marwah , Vikram Kapoor , Jesse Kamp , Kam Shergill , Roger MacNicol , Manosiz Bhattacharyya , Amit Ganesh
发明人： Vineet Marwah , Vikram Kapoor , Jesse Kamp , Kam Shergill , Roger MacNicol , Manosiz Bhattacharyya , Amit Ganesh
IPC分类号： G06F17/20
CPC分类号： H03M7/30 , H03M7/3084
摘要： Described herein are compression and processing optimizations by using data transformation techniques. In example embodiments, a byte-wise differential transformation is applied to columnar data represented as a list of length-value pairs to determine a list of delta pairs that is subsequently compressed and stored on persistent storage. A length separation transformation is applied to separate a list of length-value pairs into a length array and a corresponding data value array, where these two arrays are subsequently compressed and stored separately on persistent storage. A native number transformation is applied to a set of number values to remove the lengths stored in the number values, where the transformed set is stored on persistent storage instead of the original set of number values. A native datetime-type transformation is applied to a set of datetime values to generate an encoding that is used to encode the set of datetime values into an encoded set that is stored on persistent storage instead of the original set.
摘要翻译：这里描述的是使用数据变换技术的压缩和处理优化。在示例实施例中，将逐字节差分变换应用于表示为长度值对列表的列数据，以确定随后压缩并存储在持久存储器上的增量对列表。应用长度分离变换将长度值对列表分隔成长度数组和对应的数据值数组，其中这两个数组随后被压缩并分别存储在持久存储器上。原始数字变换被应用于一组数字值以去除存储在数字值中的长度，其中变换的集合存储在永久存储器上而不是原始的数字集合。本机datetime类型转换应用于一组datetime值，以生成用于将datetime值集合编码为存储在永久存储而不是原始集合的编码集中的编码。

10. 发明授权

US09400812B2 Method and mechanism for determining life intervals for a key in an index 有权
标题翻译：确定索引中键的生命周期的方法和机制
公开(公告)号：US09400812B2
公开(公告)日：2016-07-26
申请号：US13209224
申请日：2011-08-12
申请人： Bipul Sinha , Vivekanandhan Raja , Amit Ganesh
发明人： Bipul Sinha , Vivekanandhan Raja , Amit Ganesh
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30309
摘要： Disclosed is a mechanism, system, interface, and process to determine one or more life intervals when given a key. In addition, one or more life intervals can be determined for each key within a range of keys. This type of process is useful for auditing purposes or if it is desire to implement a query upon past versions when a key or range of keys is specified for the data for which past versions is desired. This facilitates algorithms, mechanisms, and processes to implement a query upon past versions.
摘要翻译：公开了一种在给予键时确定一个或多个生命周期的机制，系统，界面和过程。另外，可以在一系列键内为每个键确定一个或多个生命周期。这种类型的过程对于审计目的是有用的，或者如果希望在为期望的过去版本的数据指定密钥或密钥范围时希望在过去的版本上实现查询。这有助于算法，机制和过程来实现过去版本的查询。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式