会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 18. 发明授权
    • Using temporary performance objects for enhanced query performance
    • 使用临时性能对象来增强查询性能
    • US08996500B2
    • 2015-03-31
    • US14219744
    • 2014-03-19
    • International Business Machines Corporation
    • David L. KaminskyRamya H. PrasadGirish Sundaram
    • G06F17/30
    • G06F17/30442
    • Methods for optimizing query performance in a relational database management system. A query is received at the relational database management system. It is determined whether the query is expected to be a long-running query. In response to determining that the query is expected to be a long-running query, a full table scan is started in order to fetch records needed to satisfy the query from the relational database management system. In parallel with conducting the full table scan, a performance object is built, which is capable of satisfying the query in the relational database management system. In response to completing the construction of the performance object prior to completing the full table scan, the full table scan is stopped and the newly built performance object is used instead to satisfy the query.
    • 在关系数据库管理系统中优化查询性能的方法。 在关系数据库管理系统中收到查询。 确定查询是否期望是长时间运行的查询。 响应于确定查询预期是长时间运行的查询,启动全表扫描以便从关系数据库管理系统获取满足查询所需的记录。 与执行全表扫描并行,构建了一个性能对象,它能够满足关系数据库管理系统中的查询。 响应于在完成全表扫描之前完成性能对象的构建,停止全表扫描,并使用新构建的性能对象来满足查询。
    • 19. 发明授权
    • System and method for partially deferred index maintenance
    • 部分延期索引维护的系统和方法
    • US08954407B2
    • 2015-02-10
    • US13085281
    • 2011-04-12
    • Namik HrleJohannes SchuetznerKnut Stolze
    • Namik HrleJohannes SchuetznerKnut Stolze
    • G06F7/00G06F17/00G06F17/30
    • G06F17/30327
    • Methods and Apparatus, including computer program products, for maintaining indexes in a database management system. The database management system includes a table having table entries and an index data structure having index data structure entries, the index data structure relating to the table. The index data structure is updated synchronously with an insertion of table entries. The index data structure is maintained unchanged when the table entries are deleted. It is verified by an index-scan on the index data structure that a valid criterion is fulfilled for index data structure entries, and those index data structure entries that pass the valid criterion from the index-scan are returned.
    • 方法和设备,包括计算机程序产品,用于维护数据库管理系统中的索引。 数据库管理系统包括具有表条目的表和具有索引数据结构条目的索引数据结构,与该表相关的索引数据结构。 索引数据结构与表条目的插入同步更新。 当表项删除时,索引数据结构保持不变。 通过对索引数据结构的索引扫描验证索引数据结构条目满足有效标准,并返回从索引扫描传递有效标准的索引数据结构条目。