首页> 外国专利> Method for accelerating range queries using periodic monotonic properties of non-monotonic functions

Method for accelerating range queries using periodic monotonic properties of non-monotonic functions

机译:利用非单调函数的周期性单调性质来加速范围查询的方法

摘要

A method for accelerating range queries using periodic monotonic properties of non-monotonic functions including mapping a base column x to an existing index on a column y that is correlated with column x through a periodic piecewise monotonic function F(x), rewriting an index construction statement to force the existing index on column y to track a periodic piecewise monotonic property by assigning identical values of F(x) to different periods to different ranges to create an annotated index, and rewriting range queries over the annotated index on F(x) by modifying a derived predicate.
机译:一种使用非单调函数的周期性单调特性来加速范围查询的方法,该方法包括通过周期性的分段单调函数F(x)将基本列x映射到与列x相关的列y上的现有索引,将其重写语句,通过将F(x)的相同值分配给不同时段到不同范围以创建带注释的索引,并在F(x)上的带注释的索引上重写范围查询,来强制y列上的现有索引跟踪周期性的分段单调性质通过修改派生谓词。

著录项

相似文献

  • 专利
  • 外文文献
  • 中文文献
获取专利

客服邮箱:kefu@zhangqiaokeyan.com

京公网安备:11010802029741号 ICP备案号:京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有
  • 客服微信

  • 服务号