会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 10. 发明申请
    • Method, system, and program for collecting statistics of data stored in a database
    • 用于收集数据库中存储的数据的统计信息的方法,系统和程序
    • US20060112093A1
    • 2006-05-25
    • US10996197
    • 2004-11-22
    • Sam LightstoneIvan PopivanovKevin Rose
    • Sam LightstoneIvan PopivanovKevin Rose
    • G06F17/30
    • G06F17/30315
    • The present invention relates to collecting statistics automatically for data in a database. There is provided a method for automated statistics collection comprising determining a likelihood that statistics for data have changed; and collecting statistics for data in response to the likelihood. Indicators of the likelihood that statistics have changed may be useful to trigger automated statistics collection. Tables having statistics that change significantly may be collected more often than statistics of tables that are stable. A preferred model is provided to facilitate the collection of statistics that are more relevant: a table is scheduled for collection in accordance with observed patterns of table activity; a table is considered for collection if it meets a threshold level of activity; and a table is sampled to predict whether the statistics to be collected have changed. When collecting statistics, throttling and lock contention can minimize impact on a database user's response experience.
    • 本发明涉及为数据库中的数据自动采集统计信息。 提供了一种用于自动统计收集的方法,包括确定数据的统计数据已经改变的可能性; 并根据可能性收集数据的统计数据。 统计变更可能性的指标可能有助于触发自动统计收集。 具有显着变化的统计数据的表可能比稳定表的统计数据更频繁地收集。 提供了一个优选模型,以便于收集更相关的统计数据:按照观察到的表格模式计划收集表格; 如果满足阈值水平的活动,则考虑表的收集; 并对表进行采样,以预测要收集的统计信息是否发生变化。 收集统计信息时,限制和锁定争用可以最小化对数据库用户的响应体验的影响。