公开(公告)号：US10649986B2

公开(公告)日：2020-05-12

申请号：US15421036

申请日：2017-01-31

Applicant: salesforce.com, inc.

Inventor： Simon Wong ,  Gary Baker

IPC: G06F16/00 ,  G06F16/242

Abstract: In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing a BY ORGID command term within a multi-tenant aware structured query language within a computing environment. For instance, such an exemplary system having a processor and a memory therein includes means for operating a multi-tenant database system having customer data stored therein for a plurality of distinct customer organizations; receiving a database query specifying a command term to filter all tables accessed pursuant to execution of the database query by an organization_id parameter corresponding to one of the plurality of distinct customer organizations; parsing the database query to identify the command term specified; parsing the database query to identify any part of the received database query corresponding to one or more tables within the multi-tenant database system; generating a new structured query language statement to execute against the multi-tenant database system in fulfillment of the database query received, in which the new structured query language statement filters every reference to the one or more tables by the organization_id parameter; and executing the new structured query language statement against the multi-tenant database system. Other related embodiments are disclosed.

公开(公告)号：US20180218044A1

公开(公告)日：2018-08-02

申请号：US15421063

申请日：2017-01-31

Applicant: salesforce.com, inc.

Inventor： Simon Wong ,  Gary Baker

IPC: G06F17/30

Abstract: In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing a BY PARTITION command term within a multi-tenant aware structured query language within a computing environment. For instance, such an exemplary system having a processor and a memory therein includes means for operating a multi-tenant database system having customer data stored therein for a plurality of distinct customer organizations; maintaining a plurality of tables within the multi-tenant database system to store the customer data, in which one or more of the tables is partitioned into a plurality of table partitions; receiving a database query specifying a command term to restrict a specified table accessed pursuant to execution of the database query by a partition_id parameter; parsing the database query to identify the command term specified; parsing the database query to identify any part of the received database query corresponding to the specified table within the multi-tenant database system to be restricted by the partition_id parameter; generating a new structured query language statement to execute against the multi-tenant database system in fulfillment of the database query received, in which the new structured query language statement accesses only a sub-portion of the specified table corresponding to exactly one table partition of the specified table having a partition ID matching the partition_id parameter; and executing the new structured query language statement against the multi-tenant database system. Other related embodiments are disclosed.

公开(公告)号：US20150205810A1

公开(公告)日：2015-07-23

申请号：US14672314

申请日：2015-03-30

Applicant: salesforce.com, inc.

Inventor： Gary Baker ,  Sonali Thomas Agrawal ,  James Ferguson ,  Frank Lopez ,  Jamie No

IPC: G06F17/30

CPC classification number: G06F17/30091 ,  G06F8/30 ,  G06F17/30705

Abstract: In accordance with embodiments, there are provided mechanisms and methods for facilitating evaluation of data types for dynamic lightweight objects in an on-demand services environment. In one embodiment and by way of example, a method includes uploading a data file having data at a first computing device in response to a request, and detecting data types relating to the data within the data file. The detecting includes scanning data rows and data columns of the data file. The method may further include classifying the detected data types into one or more categories, and creating one or more dynamic objects based on the one or more categories.

Abstract translation: 根据实施例，提供了用于便于在点播服务环境中评估动态轻量级对象的数据类型的机制和方法。 在一个实施例中，作为示例，一种方法包括响应于请求在第一计算设备上上传具有数据的数据文件，并且检测与数据文件内的数据相关的数据类型。 该检测包括扫描数据文件的数据行和数据列。 该方法还可以包括将检测到的数据类型分类成一个或多个类别，以及基于一个或多个类别创建一个或多个动态对象。

公开(公告)号：US20130238677A1

公开(公告)日：2013-09-12

申请号：US13866855

申请日：2013-04-19

Applicant: SALESFORCE.COM, INC.

Inventor： Kedar Doshi ,  Sonali Agrawal ,  Simon Wong ,  Chaitanya Bhatt ,  Sandip Ghosh ,  Gary Baker

IPC: G06F17/30

CPC classification number: G06F16/182 ,  G06F16/122 ,  G06F16/13 ,  G06F16/14 ,  G06F16/1748 ,  G06F16/176

Abstract: In accordance with embodiments, there are provided mechanisms and methods for using a database to access content stored outside of the database. These mechanisms and methods for using a database to access content stored outside of the database can enable embodiments to provide a database system which can be used to access content when the content is incapable of being stored in the database system, or is otherwise not stored in the database system. The ability of embodiments to provide access to such data via the database system can improve the usability of the database system.

Abstract translation: 根据实施例，提供了使用数据库访问存储在数据库外部的内容的机制和方法。 用于使用数据库访问存储在数据库外部的内容的这些机制和方法可以使得实施例能够提供数据库系统，当内容不能存储在数据库系统中时，数据库系统可被用于访问内容，否则不存储在 数据库系统。 实施例通过数据库系统提供对这些数据的访问的能力可以提高数据库系统的可用性。