公开(公告)号：US11200232B2

公开(公告)日：2021-12-14

申请号：US16553067

申请日：2019-08-27

Applicant: salesforce.com, inc.

Inventor： James Taylor

IPC: G06F16/2453

Abstract: Techniques for querying a Not-Only/Non Structured Query Language (NoSQL) database using Structure Query Language (SQL) commands. A SQL query is received. The SQL query is transformed into one or more non-relational database scans having associated row key ranges. The one or more non-relational database scans are executed in parallel for each row key range. The results from the parallel scans of the non-relational database are combined. The combined results are presented as results of the SQL query.

公开(公告)号：US10664487B2

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

申请号：US16112538

申请日：2018-08-24

Applicant: salesforce.com, inc.

Inventor： Jonathan Bruce ,  Eli Levine ,  Simon Toens ,  James Taylor

IPC: G06F16/00 ,  G06F16/2458 ,  G06F16/25 ,  G06F16/27 ,  G06F16/245 ,  G06F16/28 ,  G06F16/20 ,  G06F16/21 ,  G06F16/18

Abstract: Techniques and structures for providing a multitenant environment having both a relational database and a non-relational database. A database query is received with at least one server computing device providing a multitenant environment having a relational database system and a non-relational database system, the database query in a format corresponding to the relational database system. The query is parsed with the at least one server computing device to find one or more components of the query directed to data stored in the non-relational database system. One or more components of the query directed to data stored in the non-relational database system are converted to one or more scans of the non-relational database system. Results from the query of the relational database system and results from the one or more scans of the non-relational database system are collected. The results from the query and the results of the one or more scans to a combined result are combined. The combined results are provided to a client entity.

公开(公告)号：US10649995B2

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

申请号：US15344340

申请日：2016-11-04

Applicant: Salesforce.com, Inc.

Inventor： Craig Weissman ,  James Taylor

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/24 ,  G06F16/242 ,  G06F16/25 ,  G06F16/2455 ,  G06F16/2457

Abstract: Methods and systems for optimizing queries in a multi-tenant store are described. In one embodiment, such a method includes retrieving data from a multi-tenant database system having a relational data store and a non-relational data store, receiving a request specifying data to be retrieved, retrieving one or more locations of the data to be retrieved, generating a database query based on the request, in which the database query specifies a plurality of data elements to be retrieved, the plurality of data elements including one or more data elements residing within the non-relational data store and one or more other data elements residing within the relational data store, generating an optimized database query having an optimized query syntax that is distinct from a query syntax of the database query, and executing the optimized database query against the multi-tenant database system to retrieve the data.

公开(公告)号：US10061823B2

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

申请号：US14542348

申请日：2014-11-14

Applicant: salesforce.com, inc.

Inventor： Jonathan Mark Bruce ,  Eli Levine ,  Simon Toens ,  James Taylor

IPC: G06F17/30

CPC classification number: G06F16/18 ,  G06F16/20 ,  G06F16/21 ,  G06F16/211 ,  G06F16/214 ,  G06F16/217 ,  G06F16/219 ,  G06F16/245 ,  G06F16/2471 ,  G06F16/25 ,  G06F16/256 ,  G06F16/258 ,  G06F16/27 ,  G06F16/284 ,  G06F16/289

Abstract: Techniques and structures for providing a multitenant environment having both a relational database and a non-relational database. A database query is received with at least one server computing device providing a multitenant environment having a relational database system and a non-relational database system, the database query in a format corresponding to the relational database system. The query is parsed with the at least one server computing device to find one or more components of the query directed to data stored in the non-relational database system. One or more components of the query directed to data stored in the non-relational database system are converted to one or more scans of the non-relational database system. Results from the query of the relational database system and results from the one or more scans of the non-relational database system are collected. The results from the query and the results of the one or more scans to a combined result are combined. The combined results are provided to a client entity.

公开(公告)号：US11567919B2

公开(公告)日：2023-01-31

申请号：US17330614

申请日：2021-05-26

Applicant: salesforce.com, inc.

Inventor： James Taylor ,  Bill C. Eidson ,  Kevin Oliver

IPC: G06F16/22

Abstract: In accordance with embodiments, there are provided mechanisms and methods for performing transparent object migration across storage tiers. In an embodiment and by way of example, a method for appending data to large data volumes is provided. The method embodiment includes a) setting a CustomEntityOption bit that determines (at object creation time) where the object is stored, either in the relational or the non-relational data store portion, b) loading the CustomEntityOption bit in a cached CustomEntityDefinition, c) showing the CustomEntityOption bit as EntityInfo, and d) allowing custom object definition and Metadata API functionality when the bit is shown.

公开(公告)号：US20180032562A1

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

申请号：US15727299

申请日：2017-10-06

Applicant: salesforce.com, inc.

Inventor： James Taylor ,  Bill C. Eidson ,  Kevin Oliver

IPC: G06F17/30

CPC classification number: G06F16/2272

Abstract: In accordance with embodiments, there are provided mechanisms and methods for performing transparent object migration across storage tiers. In an embodiment and by way of example, a method for appending data to large data volumes is provided. The method embodiment includes a) setting a CustomEntityOption bit that determines (at object creation time) where the object is stored, either in the relational or the non-relational data store portion, b) loading the CustomEntityOption bit in a cached CustomEntityDefinition, c) showing the CustomEntityOption bit as EntityInfo, and d) allowing custom object definition and Metadata API functionality when the bit is shown.

公开(公告)号：US20150142783A1

公开(公告)日：2015-05-21

申请号：US14542348

申请日：2014-11-14

Applicant: salesforce.com, inc.

Inventor： Jonathan Mark Bruce ,  Eli Levine ,  Simon Toens ,  James Taylor

IPC: G06F17/30 ,  H04L29/08 ,  H04L29/06

CPC classification number: G06F17/30545 ,  G06F17/30424 ,  G06F17/30557 ,  G06F17/30566 ,  G06F17/30569 ,  G06F17/30575 ,  G06F17/30595 ,  G06F17/30607

Abstract: Techniques and structures for providing a multitenant environment having both a relational database and a non-relational database. A database query is received with at least one server computing device providing a multitenant environment having a relational database system and a non-relational database system, the database query in a format corresponding to the relational database system. The query is parsed with the at least one server computing device to find one or more components of the query directed to data stored in the non-relational database system. One or more components of the query directed to data stored in the non-relational database system are converted to one or more scans of the non-relational database system. Results from the query of the relational database system and results from the one or more scans of the non-relational database system are collected. The results from the query and the results of the one or more scans to a combined result are combined. The combined results are provided to a client entity.

Abstract translation: 提供具有关系数据库和非关系数据库的多租户环境的技术和结构。 接收至少一个服务器计算设备的数据库查询，该服务器计算设备提供具有关系数据库系统和非关系数据库系统的多租户环境，该数据库查询具有对应于关系数据库系统的格式。 该查询与至少一个服务器计算设备解析，以查找针对存储在非关系数据库系统中的数据的查询的一个或多个组件。 针对存储在非关系数据库系统中的数据的查询的一个或多个组件被转换为非关系数据库系统的一个或多个扫描。 收集关系数据库系统的查询结果和非关系数据库系统的一次或多次扫描的结果。 将查询的结果和对组合结果的一次或多次扫描的结果进行组合。 组合结果提供给客户实体。

公开(公告)号：US20130246356A1

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

申请号：US13874369

申请日：2013-04-30

Applicant: SALESFORCE.COM, INC.

Inventor： James Taylor ,  Andrew Smith ,  Craig Weissman

IPC: G06F17/30

CPC classification number: G06F16/2379 ,  G06F8/65

Abstract: In accordance with embodiments, there are provided mechanisms and methods for pushing an application update between tenants of a multi-tenant on-demand database service. These mechanisms and methods for pushing an application update between tenants of a multi-tenant on-demand database service can enable tenants providing the application update to force instances of the application utilized by other tenants to be updated. This may allow the tenants providing the application update to ensure that instances of the application utilized by other tenants are updated.

Abstract translation: 根据实施例，提供了用于在多租户按需数据库服务的租户之间推送应用更新的机制和方法。 用于在多租户点播数据库服务的租户之间推送应用更新的这些机制和方法可以使得提供应用更新的租户能够迫使由其他租户使用的应用的实例被更新。 这可以允许提供应用程序更新的租户确保更新其他租户使用的应用程序的实例。

公开(公告)号：US11036706B2

公开(公告)日：2021-06-15

申请号：US15727299

申请日：2017-10-06

Applicant: salesforce.com, inc.

Inventor： James Taylor ,  Bill C. Eidson ,  Kevin Oliver

IPC: G06F16/22

Abstract: In accordance with embodiments, there are provided mechanisms and methods for performing transparent object migration across storage tiers. In an embodiment and by way of example, a method for appending data to large data volumes is provided. The method embodiment includes a) setting a CustomEntityOption bit that determines (at object creation time) where the object is stored, either in the relational or the non-relational data store portion, b) loading the CustomEntityOption bit in a cached CustomEntityDefinition, c) showing the CustomEntityOption bit as EntityInfo, and d) allowing custom object definition and Metadata API functionality when the bit is shown.

公开(公告)号：US20210011911A1

公开(公告)日：2021-01-14

申请号：US16883810

申请日：2020-05-26

Applicant: salesforce.com, inc.

Inventor： Jonathan Bruce ,  Eli Levine ,  Simon Toens ,  James Taylor

IPC: G06F16/2458 ,  G06F16/25 ,  G06F16/27 ,  G06F16/245 ,  G06F16/28 ,  G06F16/20

Abstract: Techniques and structures for providing a multitenant environment having both a relational database and a non-relational database. A database query is received with at least one server computing device providing a multitenant environment having a relational database system and a non-relational database system, the database query in a format corresponding to the relational database system. The query is parsed with the at least one server computing device to find one or more components of the query directed to data stored in the non-relational database system. One or more components of the query directed to data stored in the non-relational database system are converted to one or more scans of the non-relational database system. Results from the query of the relational database system and results from the one or more scans of the non-relational database system are collected. The results from the query and the results of the one or more scans to a combined result are combined. The combined results are provided to a client entity.