会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 2. 发明申请
    • DATABASE SYSTEM THAT PROVIDES FOR HISTORY-ENABLED TABLES
    • 为历史启动表提供的数据库系统
    • US20120191682A1
    • 2012-07-26
    • US13440702
    • 2012-04-05
    • Jayanta BANERJEERobert HanckelSiva Ravada
    • Jayanta BANERJEERobert HanckelSiva Ravada
    • G06F17/30G06F7/00
    • G06F17/30306
    • Techniques for history enabling a table in a database system so that past versions of rows of the history-enabled table are available for temporal querying. The table is history enabled by adding a start time column to the table and creating a history table for the history-enabled table. The start time field's value in a row of the history-enabled table indicates when the contents of the row last changed. The rows of the history table are copies of rows of the history-enabled table that have been deleted or updated. The rows include end time fields whose values indicate when the row was updated or deleted. A history table's row thus indicates a period in which the history table's row was in the history-enabled table. Temporal queries are performed on a view which is the union of the history-enabled table and the history table.
    • 用于历史的技术,使数据库系统中的表能够使历史启用的表的行的历史版本可用于时间查询。 通过向表中添加开始时间列并为启用历史记录的表创建历史记录表来启用表。 历史使能表中的行的起始时间字段的值指示行的内容何时更改。 历史记录表的行是已经被删除或更新的启用历史记录的表的行的副本。 这些行包括结束时间字段,其值指示行何时更新或删除。 历史表格的行因此表示历史记录表的行在启用历史记录的表中的一段时间。 时间查询是在具有历史记录功能的表和历史记录表的联合的视图上执行的。
    • 3. 发明授权
    • Techniques for implementing indexes on columns in database tables whose values specify periods of time
    • 在值指定时间段的数据库表中的列上实现索引的技术
    • US07970742B2
    • 2011-06-28
    • US11292138
    • 2005-12-01
    • Robert HanckelJayanta BanerjeeSiva Ravada
    • Robert HanckelJayanta BanerjeeSiva Ravada
    • G06F17/30
    • G06F17/30551
    • Techniques for history enabling a table in a database system so that past versions of rows of the history-enabled table are available for temporal querying. The table is history enabled by adding a start time column to the table and creating a history table for the history-enabled table. The history table's rows are copies of rows of the history-enabled table that have changed and include start time and end time fields whose values indicate a period in which the history table's row was in the history-enabled table. Temporal queries are performed on a view which is the union of the history-enabled table and the history table. The temporal queries are speeded up by period of time indexes in which the leaves are grouped based on time period size, identifiers are assigned to the groups, and the keys of the index include the group identifiers.
    • 用于历史的技术,使数据库系统中的表能够使历史启用的表的行的历史版本可用于时间查询。 通过向表中添加开始时间列并为启用历史记录的表创建历史记录表,可以启用历史记录。 历史记录表的行是已更改的历史记录表的行的副本,并且包含起始时间和结束时间字段,其值表示历史记录表的行在启用历史记录的表中的一段时间。 时间查询是在具有历史记录功能的表和历史记录表的联合的视图上执行的。 时间查询通过基于时间段大小对叶片进行分组的时间段索引进行加速,标识符被分配给组,索引的密钥包括组标识符。
    • 4. 发明申请
    • FRAMEWORK FOR HANDLING BUSINESS TRANSACTIONS
    • 处理业务交易的框架
    • US20090077135A1
    • 2009-03-19
    • US12102831
    • 2008-04-14
    • Aravind YalamanchiDieter GawlickJayanta Banerjee
    • Aravind YalamanchiDieter GawlickJayanta Banerjee
    • G06F17/30
    • G06F17/30359
    • Techniques are provided for freeing up resources before operations that change the resources have successfully completed. Resources are freed up by committing database transactions that perform portions of operations before the operations themselves have successfully completed. If the operations fail to complete successfully, then “compensation information” is used to remove the effects of the committed changes that were performed as part of the operation. Techniques are also provided for allowing database transactions to update values without retaining exclusive locks on those values. Operational constraints set forth conditions that must be satisfied before an update is allowed to proceed. If an attempt is made to update a particular value that has changes that may be undone, then the database server determines a plurality of “possible result values” for the particular value. If the possible result values satisfy the operational constraint conditions, then the update is allowed to proceed.
    • 提供了在更改资源成功完成的操作之前释放资源的技术。 通过在操作本身已经成功完成之前提交执行部分操作的数据库事务来释放资源。 如果操作无法成功完成,则使用“补偿信息”来消除作为操作一部分而执行的所作出的更改的影响。 还提供了允许数据库事务更新值而不保留这些值的排他锁的技术。 操作约束规定了允许进行更新之前必须满足的条件。 如果尝试更新具有可以被撤销的变化的特定值,则数据库服务器确定特定值的多个“可能的结果值”。 如果可能的结果值满足操作约束条件,则允许进行更新。
    • 5. 发明授权
    • Database system that provides for history-enabled tables
    • 提供启用历史记录的表的数据库系统
    • US09384222B2
    • 2016-07-05
    • US13440702
    • 2012-04-05
    • Jayanta BanerjeeRobert HanckelSiva Ravada
    • Jayanta BanerjeeRobert HanckelSiva Ravada
    • G06F17/30
    • G06F17/30306
    • Techniques for history enabling a table in a database system so that past versions of rows of the history-enabled table are available for temporal querying. The table is history enabled by adding a start time column to the table and creating a history table for the history-enabled table. The start time field's value in a row of the history-enabled table indicates when the contents of the row last changed. The rows of the history table are copies of rows of the history-enabled table that have been deleted or updated. The rows include end time fields whose values indicate when the row was updated or deleted. A history table's row thus indicates a period in which the history table's row was in the history-enabled table. Temporal queries are performed on a view which is the union of the history-enabled table and the history table.
    • 用于历史的技术,使数据库系统中的表能够使历史启用的表的行的历史版本可用于时间查询。 通过向表中添加开始时间列并为启用历史记录的表创建历史记录表来启用表。 历史使能表中的行的起始时间字段的值指示行的内容何时更改。 历史记录表的行是已经被删除或更新的启用历史记录的表的行的副本。 这些行包括结束时间字段,其值指示行何时更新或删除。 历史表格的行因此表示历史记录表的行在启用历史记录的表中的一段时间。 时间查询是在具有历史记录功能的表和历史记录表的联合的视图上执行的。
    • 8. 发明申请
    • Database system that provides for history-enabled tables
    • 提供启用历史记录的表的数据库系统
    • US20070130226A1
    • 2007-06-07
    • US11291446
    • 2005-12-01
    • Jayanta BanerjeeRobert HanckelSiva Ravada
    • Jayanta BanerjeeRobert HanckelSiva Ravada
    • G06F17/30
    • G06F17/30306
    • Techniques for history enabling a table in a database system so that past versions of rows of the history-enabled table are available for temporal querying. The table is history enabled by adding a start time column to the table and creating a history table for the history-enabled table. The start time field's value in a row of the history-enabled table indicates when the contents of the row last changed. The rows of the history table are copies of rows of the history-enabled table that have been deleted or updated. The rows include end time fields whose values indicate when the row was updated or deleted. A history table's row thus indicates a period in which the history table's row was in the history-enabled table. Temporal queries are performed on a view which is the union of the history-enabled table and the history table.
    • 用于历史的技术,使数据库系统中的表能够使历史启用的表的行的历史版本可用于时间查询。 通过向表中添加开始时间列并为启用历史记录的表创建历史记录表来启用表。 历史使能表中的行的起始时间字段的值指示行的内容何时更改。 历史记录表的行是已经被删除或更新的启用历史记录的表的行的副本。 这些行包括结束时间字段,其值指示行何时更新或删除。 历史表格的行因此表示历史记录表的行在启用历史记录的表中的一段时间。 时间查询是在具有历史记录功能的表和历史记录表的联合的视图上执行的。
    • 9. 发明授权
    • Buffering a hierarchical index of multi-dimensional data
    • 缓冲多维数据的分层索引
    • US06470344B1
    • 2002-10-22
    • US09384648
    • 1999-08-27
    • Ravi KothuriSiva RavadaJayant SharmaJayanta BanerjeeAmbuj Singh
    • Ravi KothuriSiva RavadaJayant SharmaJayanta BanerjeeAmbuj Singh
    • G06F1730
    • G06F17/30327G06F17/30333G06F17/30592Y10S707/957Y10S707/99945
    • Methods are provided for buffering nodes of a hierarchical index (e.g., R-tree, bang file, hB-tree) during operations on multi-dimensional data represented by the index. The methods are particularly suited for query operations, and a different method may be more suitable for one pattern of queries than another. Where queries are distributed in a relatively uniform manner across the domain or dataspace of an index, a node-area buffering method is provided. In this method nodes are cached or buffered in order of their respective areas (e.g., their minimum bounding areas), and a node having a smaller area will be replaced in cache before a node having a larger area. When, however, queries are not uniformly distributed, then a least frequently accessed buffering technique may be applied. According to this method statistics are maintained concerning the frequency with which individual index nodes are accessed. Those accessed less frequently are replaced in cache before those accessed more frequently. Yet another, generic, buffering strategy is provided that is suitable for all patterns of query distribution. In accordance with this method, whenever a node must be removed from cache in order to make room for a newly accessed node, cached nodes are compared to each other to determine which provides the least caching benefit and may therefore be ejected. A comparison may involve three factors—the difference in the nodes' areas, the difference in the frequency with which they have been accessed and the difference between their latest access times. These factors may be weighted to give them more or less effect in relation to each other.
    • 提供了用于在由索引表示的多维数据的操作期间缓冲分层索引(例如,R-tree,bang文件,hB-树)的节点的方法。 这些方法特别适用于查询操作,并且不同的方法可能比另一种更适合于一种查询模式。 在索引的域或数据空间中以相对均匀的方式分布查询的情况下,提供了节点区域缓冲方法。 在这种方法中,节点按照它们各自的区域(例如,它们的最小边界区域)的顺序进行缓存或缓冲,并且具有较小区域的节点将在具有较大面积的节点之前在高速缓存中被替换。 然而,当查询不是均匀分布时,则可以应用最不频繁访问的缓冲技术。 根据该方法,关于访问各个索引节点的频率来维持统计。 访问次数较少的用户在更频繁访问的缓存中被替换。 提供了另一种适用于所有查询分发模式的通用缓冲策略。 根据该方法,每当节点必须从高速缓存中移除以便为新访问的节点腾出空间时,将缓存的节点彼此进行比较,以确定哪个节点提供最小的缓存优点并且因此可以被弹出。 比较可能涉及三个因素 - 节点区域的差异,访问频率的差异以及其最新访问时间之间的差异。 这些因素可能被加权,以使他们或多或少相互影响。