会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 3. 发明申请
    • STOP-AND-RESTART STYLE EXECUTION FOR LONG RUNNING DECISION SUPPORT QUERIES
    • 用于长时间运行的决策支持查询的停止和重新启动方式执行
    • US20090083238A1
    • 2009-03-26
    • US11859046
    • 2007-09-21
    • Surajit ChaudhuriShriraghav KaushikAbhijit PolRavishankar Ramamurthy
    • Surajit ChaudhuriShriraghav KaushikAbhijit PolRavishankar Ramamurthy
    • G06F17/30
    • G06F16/24561
    • Stop-and-restart query execution that partially leverages the work already performed during the initial execution of the query to reduce the execution time during a restart. The technique selectively saves information from a previous execution of the query so that the overhead associated with restarting the query execution can be bounded. Despite saving only limited information, the disclosed technique substantially reduces the running time of the restarted query. The stop-and-restart query execution technique is constrained to save and reuse only a bounded number of records (intermediate records or output records) thereby releasing all other resources, rather than some of the resources. The technique chooses a subset of the records to save that were found during normal execution and then skipping the corresponding records when performing a scan during restart to prevent the duplication of execution. A skip-scan operator is employed to facilitate the disclosed restart technique.
    • 停止和重新启动的查询执行,部分利用在初始执行查询期间已经执行的工作,以减少重新启动期间的执行时间。 该技术选择性地保存来自查询的先前执行的信息,使得与重新启动查询执行相关联的开销可以被界定。 尽管仅节省有限的信息,但是所公开的技术大大减少了重新启动的查询的运行时间。 停止和重启查询执行技术被限制为只保存和重用有限数量的记录(中间记录或输出记录),从而释放所有其他资源,而不是一些资源。 该技术选择在正常执行期间发现的记录的子集,然后在重新启动期间执行扫描时跳过相应的记录,以防止重复执行。 采用跳过扫描运算符来促进公开的重启技术。
    • 6. 发明申请
    • Framework for Testing Query Transformation Rules
    • 查询转换规则测试框架
    • US20110295833A1
    • 2011-12-01
    • US12789486
    • 2010-05-28
    • Vivek R. NarasayyaRavishankar RamamurthyHicham G. Elmongui
    • Vivek R. NarasayyaRavishankar RamamurthyHicham G. Elmongui
    • G06F17/30
    • G06F17/30448G06F11/3664G06F11/3676
    • Described is a test framework for testing transformation rules of query optimizers. Rule patterns obtained as tree structures from a query optimizer are used to generate queries that are used to test the rule optimizer's transformation rules. The test framework tracks which rules are exercised for each query, and also determines the correctness of the transformation rule by comparing the results of the query processing with the rule and without the rule (by turning off the rule). The test framework creates a composite pattern corresponding to two or more rules, such as to test rules in a set (e.g., as pairs). Also described is the efficient execution of a test suite for correctness testing, in which queries of the test suite are selected based upon cost information.
    • 描述了用于测试查询优化器的转换规则的测试框架。 使用从查询优化器获取的树结构的规则模式用于生成用于测试规则优化器转换规则的查询。 测试框架跟踪每个查询执行哪些规则,并且通过将查询处理的结果与规则进行比较,并且通过将规则(通过关闭规则)进行比较来确定变换规则的正确性。 测试框架创建一个对应于两个或多个规则的复合模式,例如测试集合中的规则(例如,成对)。 还描述了用于正确性测试的测试套件的有效执行,其中基于成本信息来选择测试套件的查询。
    • 8. 发明授权
    • Query progress estimation
    • 查询进度估计
    • US07493337B2
    • 2009-02-17
    • US10813963
    • 2004-03-31
    • Surajit ChaudhuriVivek NarasayyaRavishankar Ramamurthy
    • Surajit ChaudhuriVivek NarasayyaRavishankar Ramamurthy
    • G06F7/00G06F17/00G06F17/30
    • G06F17/30522G06F17/30306Y10S707/99932Y10S707/99945Y10S707/99948
    • A query progress indicator that provides an indication to a user of the progress of a query being executed on a database. The indication of the progress of the query allows the user to decide whether the query should be allowed to complete or should be aborted. One method that may be used to estimate the progress of a query that is being executed on a database defines a model of work performed during execution of a query. The total amount of work that will be performed during execution of the query is estimated according to the model. The amount of work performed at a given point during execution of the query is estimated according to the model. The progress of the query is estimated using the estimated amount of work at the given point in time and the estimated total amount of work. This estimated progress of query execution may be provided to the user.
    • 查询进度指示符,向用户提供在数据库上执行的查询的进度的指示。 查询进度的指示允许用户决定是否允许查询完成或应该被中止。 可用于估计在数据库上执行的查询的进度的一种方法定义了在查询执行过程中执行的工作模型。 根据模型估计执行查询期间执行的总工作量。 在执行查询期间在给定点执行的工作量根据模型进行估计。 查询的进度使用在给定时间点的估计工作量和估计的总工作量来估计。 可以向用户提供该估计的查询执行进度。