公开(公告)号：US20140317093A1

公开(公告)日：2014-10-23

申请号：US14257570

申请日：2014-04-21

Applicant: salesforce.com, inc.

Inventor： WEI SUN ,  Chun Tak Lam ,  Jianxun Jason Ding ,  Bing Qiu

IPC: G06F17/30

CPC classification number: G06F16/2255

Abstract: In accordance with embodiments, there are provided mechanisms and methods for facilitating dynamic creation of multi-column index tables and management of customer queries in an on-demand services environment in a multi-tenant environment according to one embodiment. In one embodiment and by way of example, a method includes receiving, at a computing device, a query having one or more filters relating to one or more data type columns of database at a primary table. The primary table may include an object table. The method may further include calculating a hash number based on an index identifier corresponding to the one or more filters, and determining a first key at a secondary table based on the calculated hash number. The secondary table may include an index table, and the first key may be mapped with a second key corresponding to one or more rows at the primary table. The method may further include obtaining data from the one or more rows of the primary table, where the data includes filtered data corresponding to the one or more data type columns.

Abstract translation: 根据实施例，根据一个实施例，提供了用于促进多列索引表的动态创建和在多租户环境中的点播服务环境中管理客户查询的机制和方法。 在一个实施例中，作为示例，一种方法包括在计算设备处接收具有与主表的一个或多个数据类型列相关的一个或多个过滤器的查询。 主表可以包括对象表。 该方法还可以包括基于与一个或多个过滤器相对应的索引标识符来计算散列数，并且基于所计算的散列数确定次表上的第一密钥。 次表可以包括索引表，并且可以使用与主表的一行或多行相对应的第二键映射第一密钥。 该方法还可以包括从主表的一行或多行获取数据，其中数据包括对应于一个或多个数据类型列的经过滤数据。