会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 1. 发明授权
    • Apparatus to selectively remove the effects of transactions in online database and enable logical recovery
    • 用于选择性地消除在线数据库中事务的影响并启用逻辑恢复的装置
    • US07873605B2
    • 2011-01-18
    • US11699689
    • 2007-01-29
    • Manosiz BhattacharyyaBipul SinhaAmit Ganesh
    • Manosiz BhattacharyyaBipul SinhaAmit Ganesh
    • G06F7/00G06F17/00
    • 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. 发明申请
    • COMPRESSION ANALYZER
    • 压缩分析仪
    • US20100281079A1
    • 2010-11-04
    • US12769508
    • 2010-04-28
    • Vineet MarwahVikram KapoorAmit GaneshJesse KampSachin KulkarniRoger MacnicolKam ShergillManosiz Bhattacharyya
    • Vineet MarwahVikram KapoorAmit GaneshJesse KampSachin KulkarniRoger MacnicolKam ShergillManosiz Bhattacharyya
    • G06F17/30
    • H03M7/30G06F17/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. 发明授权
    • Compression analyzer
    • 压缩分析仪
    • US08356060B2
    • 2013-01-15
    • US12769508
    • 2010-04-28
    • Vineet MarwahVikram KapoorAmit GaneshJesse KampSachin KulkarniRoger MacnicolKam ShergillManosiz Bhattacharyya
    • Vineet MarwahVikram KapoorAmit GaneshJesse KampSachin KulkarniRoger MacnicolKam ShergillManosiz Bhattacharyya
    • G06F7/00
    • H03M7/30G06F17/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.
    • 这里描述了用于自动选择要在表格数据上使用的压缩技术的技术。 压缩分析仪为用户提供了对选择过程的高级控制,而不需要用户了解有关压缩分析器可用的特定压缩技术的细节。 用户可以为给定的数据集指定沿最大性能和最大压缩之间的平衡点。 所选择的点由压缩分析器以各种方式使用。 例如,在一个实施例中,压缩分析器使用用户指定的平衡点来确定哪些可用的压缩技术被鉴定为用于给定的一组数据的候选技术。 压缩分析仪通过对来自该组数据的样本实际测试候选压缩技术来选择对一组数据使用的压缩技术。 在针对样品测试候选压缩技术之后,比较所得到的压缩比。 然后,部分地基于在对样本数据执行的压缩测试期间实现的压缩比来选择在该组数据上使用的压缩技术。
    • 7. 发明授权
    • Techniques for compression and processing optimizations by using data transformations
    • 使用数据转换进行压缩和处理优化的技术
    • US08239421B1
    • 2012-08-07
    • US12871862
    • 2010-08-30
    • Vineet MarwahVikram KapoorJesse KampKam ShergillRoger MacNicolManosiz BhattacharyyaAmit Ganesh
    • Vineet MarwahVikram KapoorJesse KampKam ShergillRoger MacNicolManosiz BhattacharyyaAmit Ganesh
    • G06F17/20
    • H03M7/30H03M7/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值集合编码为存储在永久存储而不是原始集合的编码集中的编码。
    • 8. 发明申请
    • Framework to optimize delete all rows operations on database objects
    • 优化框架来删除数据库对象上的所有行操作
    • US20070288529A1
    • 2007-12-13
    • US11450092
    • 2006-06-09
    • Amit GaneshNiloy MukherjeeManosiz BhattacharyyaBipul Sinha
    • Amit GaneshNiloy MukherjeeManosiz BhattacharyyaBipul Sinha
    • G06F17/30
    • 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并且小于或等于所请求数据的时间戳的那些行。