会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 9. 发明申请
    • Method, system and program for optimizing compression of a workload processed by a database management system
    • 用于优化由数据库管理系统处理的工作负载的压缩的方法,系统和程序
    • US20050192978A1
    • 2005-09-01
    • US10788583
    • 2004-02-27
    • Sam LightstoneGuy LohmanIvan PopivanovJun RaoAdam StormDaniele Zilio
    • Sam LightstoneGuy LohmanIvan PopivanovJun RaoAdam StormDaniele Zilio
    • G06F7/00G06F17/30
    • G06F17/3046Y10S707/99934
    • The present invention provides a method, system and program for optimizing compression of a workload processed by a database management system. In an embodiment of the present invention a method of optimizing the compression of database workloads is provided. Initially, an estimate of a cost of execution for each query according to a defined metric such as execution time or memory consumption is determined. A sub-set of queries is then selected from the workload in order of the most costly to least costly relative to the defined metric for compression according to either a predetermined compression threshold percentage or a threshold percentage derived from an allotted workload execution time. Compression is then performed on the selected sub-set of queries (i.e. those that will benefit the most from the compression) to achieve a net beneficial trade-off between the cost of workload compression and the cost of workload execution.
    • 本发明提供一种用于优化由数据库管理系统处理的工作负载的压缩的方法,系统和程序。 在本发明的实施例中,提供了优化数据库工作负载的压缩的方法。 首先,确定根据诸如执行时间或存储器消耗的定义的度量的每个查询的执行成本的估计。 然后根据预定的压缩阈值百分比或从分配的工作负载执行时间导出的阈值百分比,从工作负荷中选择相对于定义的压缩度量最贵的成本最低的成本的子集。 然后对所选择的查询子集(即将从压缩中获益最多的那些)执行压缩,以实现工作负载压缩成本与工作负载执行成本之间的净有益权衡。