公开(公告)号：US20190286832A1

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

申请号：US15924840

申请日：2018-03-19

Applicant: salesforce.com, inc.

Inventor： Kit Pang Szeto ,  Christopher James Wu ,  Ming-Yang Chen ,  Karl Ryszard Skucha ,  Eli Levine ,  Ka Chun Au ,  Bilong Chen ,  Johnson Liu

IPC: G06F21/62 ,  H04L29/06

Abstract: Methods, systems, and devices for data access and processing are described. To set up secure environments for data processing (e.g., including machine learning), an access control system may first receive approval from an authorized user (e.g., an approver) granting access to data objects in a multi-tenant data store. The system may determine tenant-specific paths for retrieving the data objects from the data store, and may initialize a number of virtual computing engines for accessing the data. Each computing engine may be tenant-specific based on the path(s) used by that computing engine, and each may include an access role defining the data objects or data object types accessible by that computing engine. By accessing the requested data objects according to the tenant-specific path prefixes and access roles, the virtual computing engines may securely maintain separate environments for different tenants and may only allow user access to approved tenant data.

公开(公告)号：US10366056B2

公开(公告)日：2019-07-30

申请号：US14542342

申请日：2014-11-14

Applicant: salesforce.com, inc.

Inventor： Eli Levine ,  Jonathan Mark Bruce

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

Abstract: Techniques and systems for completing a database query. A time to complete a synchronous query in response to receiving an original database query is estimated by a database management system provided by one or more computing devices. A synchronous database query corresponding to the original database query is performed with the database management system if the estimated time to complete the synchronous query is less than a pre-selected threshold time. One or more asynchronous queries corresponding to the original database query are performed with the database management system if the estimated time to complete the synchronous query is greater than the pre-selected threshold time. A result, whether from a synchronous query or one or more asynchronous queries, is stored in an object within a non-relational database system.

公开(公告)号：US20190095533A1

公开(公告)日：2019-03-28

申请号：US15717780

申请日：2017-09-27

Applicant: salesforce.com, inc.

Inventor： Eli Levine ,  Samarpan Jain ,  James Ferguson ,  Jan Asita Fernando

IPC: G06F17/30

CPC classification number: G06F16/9535 ,  G06F16/24549 ,  G06F16/901 ,  G06F16/9038

Abstract: Disclosed are examples of systems, apparatus, methods and computer program products for providing application programming interface representation for multi-tenant non-relational database objects. A database system maintains a multi-tenant non-relational database associated with a number of enterprises, a number of records, and a number of data objects for each of the enterprises. A request is received from a user to retrieve a description of a data object from the number of data objects, and in response, the system determines that the data object is defined to be used in associated with a non-relational database, then retrieves a metadata model representing the data object. The system determines that at least one field of the data object is part of a composite key for the data object, then provides data object information to the user, including information about the composite key.

公开(公告)号：US20180096165A1

公开(公告)日：2018-04-05

申请号：US15283145

申请日：2016-09-30

Applicant: salesforce.com, inc.

Inventor： Alex Warshavsky ,  Adam Torman ,  Eli Levine ,  Jan Asita Fernando ,  Samarpan Jain

IPC: G06F21/62 ,  G06F17/30

CPC classification number: G06F21/6245 ,  G06F16/2282 ,  G06F21/6218

Abstract: Disclosed are examples of systems, apparatus, methods and computer program products for dynamically provisioning a subset of a shared table or schema via access controls. A database system maintains a multi-tenant non-relational database associated with multiple enterprises, each with a number of records. The system also maintains a shared table in the multi-tenant non-relational database with a number of records. Permissions are identified for one or more of the enterprises with respect to columns of the shared table. A request is received to provision one or more columns of the shared table to an enterprise, with the request identifying a unique enterprise ID associated with the enterprise. The request is then processed, and the system modifies the permissions for the one or more provisioned columns of the shared table with respect to the unique enterprise ID associated with the enterprise. Rows of the shared table are updated to include the one or more provisioned columns, with the rows corresponding to the unique enterprise ID.

公开(公告)号：US20150142844A1

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

申请号：US14542338

申请日：2014-11-14

Applicant: salesforce.com, inc.

Inventor： Jonathan Mark Bruce ,  Eli Levine ,  Simon Toens

IPC: G06F17/30 ,  H04L29/06

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 mechanisms to manage data. A relational database environment having at least a relational database storage device is coupled with a server entity. Data stored in the relational database is stored in a custom object, which is one or more custom database tables that allow a customer/tenant/organization to store information unique to the customer/tenant/organization. A non-relational database environment having at least a non-relational database storage device is also coupled with the server entity. Data stored in the non-relational database is immutable. A single user interface and search language is utilized by the server entity to provide access to both the relational database environment and the non-relational database environment.

Abstract translation: 管理数据的技术和机制。 具有至少关系数据库存储设备的关系数据库环境与服务器实体相连。 存储在关系数据库中的数据存储在自定义对象中，自定义对象是一个或多个自定义数据库表，允许客户/租户/组织存储客户/租户/组织唯一的信息。 具有至少非关系数据库存储设备的非关系数据库环境也与服务器实体耦合。 存储在非关系数据库中的数据是不可变的。 服务器实体利用单一用户界面和搜索语言来提供对关系数据库环境和非关系数据库环境的访问。

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

公开(公告)号：US20150142736A1

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

申请号：US14542353

申请日：2014-11-14

Applicant: salesforce.com, inc.

Inventor： Jonathan Mark Bruce ,  Eli Levine ,  Simon Toens ,  Ian Varley

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

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: Systems and techniques for managing data in a relational database environment and a non-relational database environment. Data in the relational database environment that is static and to be maintained beyond a preselected threshold length of time is identified. The data is copied from the relational database and stored in the data the non-relational database. Access to the data is provided from the non-relational database via a user interface that accesses both the relational database and the non-relational database.

Abstract translation: 在关系数据库环境和非关系数据库环境中管理数据的系统和技术。 识别关系数据库环境中静态且要保持超过预选阈值时间长度的数据。 数据从关系数据库复制并存储在非关系数据库的数据中。 通过访问关系数据库和非关系数据库的用户界面，从非关系数据库提供对数据的访问。