会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 1. 发明授权
    • Method and system for using materialized views to evaluate queries
involving aggregation
    • 使用物化视图评估涉及聚合的查询的方法和系统
    • US5897632A
    • 1999-04-27
    • US895024
    • 1997-07-16
    • Shaul DarHosagrahar Visvesvaraya JagadishAlon Yitzchak LevyDivesh Srivastava
    • Shaul DarHosagrahar Visvesvaraya JagadishAlon Yitzchak LevyDivesh Srivastava
    • G06F17/30
    • G06F17/30457G06F17/30489Y10S707/99931Y10S707/99932Y10S707/99933
    • The present invention is a method and system for using materialized views to compute answers to SQL queries with grouping and aggregation. A query is evaluated a using a materialized view. The materialized view is semantically analyzed to determine whether the materialized view is usable in evaluating an input query. The semantic analysis includes determining that the materialized view does not project out any columns needed to evaluate the input query and determining that the view does not discard any tuple that satisfies a condition enforced in the input query. If the view is usable, the input query is rewritten to produce an output query that is multi-set equivalent to the input query and that specifies one or more occurrences of the materialized view as a source of information to be returned by the output query. The output query is then evaluated. The semantic analysis and rewriting may be iterated, with the output query of each iteration being the input query of the next iteration. The output query is evaluated after the last iteration.
    • 本发明是一种使用物化视图来计算具有分组和聚合的SQL查询的答案的方法和系统。 使用实例化视图评估查询。 物化视图被语义分析,以确定物化视图是否可用于评估输入查询。 语义分析包括确定物化视图不会计算出评估输入查询所需的任何列,并确定视图不丢弃满足输入查询中强制执行的条件的任何元组。 如果视图可用,则重写输入查询以产生与输入查询相当的多集合的输出查询,并将物理视图的一个或多个出现指定为输出查询返回的信息源。 然后评估输出查询。 可以重复语义分析和重写,每次迭代的输出查询是下一次迭代的输入查询。 输出查询在上次迭代后进行评估。
    • 2. 发明授权
    • Method for making data objects having hidden pointers persistent
    • 使具有隐藏指针的数据对象持久化的方法
    • US5590327A
    • 1996-12-31
    • US343735
    • 1994-11-22
    • Alexandros BilirisShaul DarNarain H. Gehani
    • Alexandros BilirisShaul DarNarain H. Gehani
    • G06F9/44G06F9/00
    • G06F9/4435
    • A method for making data objects having hidden pointers persistent is disclosed. A pre-existing process for creating data objects is modified so as to selectively inhibit both the allocation of memory space for the data object and the initialization of data within the data object. A data object with hidden pointers created by a previous program invocation is retrieved into memory by a subsequent program invocation. The modified object creation process is then advantageously applied to the data object. As a result, the hidden pointers within the data object are initialized without allocating new memory or disturbing the data within the data object. Where the object creation process includes the execution of a user supplied initialization function, the initialization function is modified so as to inhibit the initialization of data within the data object. A global flag is set by the object creation process and tested within the initialization function. If the initialization function finds the flag to be set, execution of the data initialization code is avoided.
    • 公开了一种使具有隐藏指针持久的数据对象的方法。 修改用于创建数据对象的预先存在的过程,以便选择性地抑制数据对象的存储器空间的分配和数据对象内的数据的初始化。 具有由先前程序调用创建的隐藏指针的数据对象通过后续程序调用被检索到存储器中。 修改后的对象创建过程有利地应用于数据对象。 因此,数据对象内的隐藏指针被初始化,而不会分配新的内存或干扰数据对象内的数据。 在对象创建处理包括执行用户提供的初始化功能的情况下,初始化功能被修改以便禁止数据对象内的数据的初始化。 全局标志由对象创建过程设置,并在初始化函数内进行测试。 如果初始化函数找到要设置的标志,则避免执行数据初始化代码。