会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 91. 发明授权
    • Reusing database statistics for user aggregate queries
    • 对用户聚合查询重用数据库统计信息
    • US09430530B1
    • 2016-08-30
    • US14950636
    • 2015-11-24
    • International Business Machines Corporation
    • Samar T. DesaiDattatreya Govindappanavar
    • G06F17/30
    • G06F17/30489G06F17/30412G06F17/30424G06F17/30442G06F17/30463G06F17/30477G06F17/30516
    • A method for determining and providing aggregate functions is provided. The method may include scanning database tables. The method may further include determining the aggregate functions. Additionally, the method may include storing the determined aggregate functions on system catalog tables. The method may also include providing indications that the stored determined aggregate functions are valid. The method may further include receiving database queries. The method may also include, determining whether the stored determined aggregate functions are valid. The method may further include, in response to the stored determined aggregate functions being valid, retrieving the stored determined aggregate functions from the system catalog tables. The method may also include, in response to the stored determined aggregate functions being invalid, re-scanning the database tables. The method may further include determining the aggregate functions based on the re-scanned database tables. The method may further include presenting the aggregate functions to clients.
    • 提供了一种用于确定和提供聚合函数的方法。 该方法可能包括扫描数据库表。 该方法还可以包括确定聚合函数。 另外,该方法可以包括将所确定的聚合函数存储在系统目录表上。 该方法还可以包括提供所存储的确定的聚合函数有效的指示。 该方法还可以包括接收数据库查询。 该方法还可以包括:确定所存储的确定的聚合函数是否有效。 该方法还可以包括响应于所存储的所确定的聚合函数是有效的,从系统目录表中检索所存储的确定的聚合函数。 该方法还可以包括响应于存储的确定的聚合函数无效,重新扫描数据库表。 该方法还可以包括基于重新扫描的数据库表来确定聚合函数。 该方法还可以包括向客户端呈现聚合函数。