公开(公告)号：US10706034B2

公开(公告)日：2020-07-07

申请号：US16113412

申请日：2018-08-27

申请人： Sybase, Inc.

发明人： Anant Agarwal ,  Steven A. Kirk ,  Blaine French ,  Nandan Marathe ,  Shailesh Mungikar ,  Kaushal Mittal

IPC分类号： G06F16/22

摘要： Disclosed herein are methods for retrieving data from a database. An embodiment operates searching for a key in a first index. The method determines that the searching will require a storage access request and issues the storage access request. The method continues searching for the key in a second index.

公开(公告)号：US20170017673A1

公开(公告)日：2017-01-19

申请号：US14800405

申请日：2015-07-15

申请人： Sybase, Inc.

发明人： Steven A. Kirk ,  Roland F. Mckenney

IPC分类号： G06F17/30

CPC分类号： G06F16/24542

摘要： Increasing the efficiency of performing queries on databases by eliminating partitions during a database query. The database query configured to access a database table having one or more columns and one or more rows, the database query including a condition on a specified basis column. The database table being partitioned on the basis of the specified column, the specified column having one or more distinct values and the partitioning including mapping, by the at least one programmable processor, individual ones of the one or more distinct values to individual partitions causing each row in the table to be mapped to a specific partition. Candidate partitions and guaranteed partitions can be identified. The database query can be applied only to candidate partitions. All rows which satisfy the database query and all the rows of the guaranteed partition can be forward for processing.

摘要翻译： 通过在数据库查询期间消除分区，提高对数据库执行查询的效率。 数据库查询被配置为访问具有一个或多个列和一行或多行的数据库表，数据库查询包括指定基础的条件列。 数据库表根据指定的列进行分区，指定的列具有一个或多个不同的值，并且由至少一个可编程处理器将包括映射的分区包括在一个或多个不同值中的各个独立值到导致每个的各个分区 表中的行要映射到特定分区。 可以识别候选分区和保证分区。 数据库查询只能应用于候选分区。 满足数据库查询和保证分区的所有行的所有行都可以转发进行处理。

公开(公告)号：US10726008B2

公开(公告)日：2020-07-28

申请号：US14800405

申请日：2015-07-15

申请人： Sybase, Inc.

发明人： Steven A. Kirk ,  Roland F. Mckenney

IPC分类号： G06F16/2453

摘要： Increasing the efficiency of performing queries on databases by eliminating partitions during a database query. The database query configured to access a database table having one or more columns and one or more rows, the database query including a condition on a specified basis column. The database table being partitioned on the basis of the specified column, the specified column having one or more distinct values and the partitioning including mapping, by the at least one programmable processor, individual ones of the one or more distinct values to individual partitions causing each row in the table to be mapped to a specific partition. Candidate partitions and guaranteed partitions can be identified. The database query can be applied only to candidate partitions. All rows which satisfy the database query and all the rows of the guaranteed partition can be forward for processing.

公开(公告)号：US20180365277A1

公开(公告)日：2018-12-20

申请号：US16113412

申请日：2018-08-27

申请人： Sybase, Inc.

发明人： Anant Agarwal ,  Steven A. Kirk ,  Blaine French ,  Nandan Marathe ,  Shailesh Mungikar ,  Kaushal Mittal

IPC分类号： G06F17/30

CPC分类号： G06F16/2272 ,  G06F16/2246

摘要： Disclosed herein are methods for retrieving data from a database. An embodiment operates searching for a key in a first index. The method determines that the searching will require a storage access request and issues the storage access request. The method continues searching for the key in a second index.