公开(公告)号：US20190272335A1

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

申请号：US15910837

申请日：2018-03-02

Applicant: salesforce.com, inc.

Inventor： Shu Liu ,  Eric Shahkarami ,  Yuk Hei Chan ,  Ming-Yang Chen ,  Karl Ryszard Skucha ,  Eli Levine ,  Ka Chun Au

IPC: G06F17/30

Abstract: Methods, systems, and devices for data retention handling are described. In some data storage systems, data objects are stored in a non-relational database schema. The system may support configurable data retention policies for different tenants, users, or applications. For example, a data store may receive retention requests, where the retention requests may specify deletion or exportation actions to perform on records contained within data objects. The data store may determine retention rules based on these retention requests, and may periodically or aperiodically evaluate the rules to determine active actions to perform. To improve the efficiency of the system, the data store may aggregate the active actions (e.g., according to the dataset to perform the actions on), and may generate work items corresponding to the aggregate actions. A work processor may retrieve these work items and may efficiently perform the data retention actions on datasets stored in the data object store.

公开(公告)号：US10380094B2

公开(公告)日：2019-08-13

申请号：US15283130

申请日：2016-09-30

Applicant: salesforce.com, inc.

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

IPC: G06F17/30 ,  G06F16/22

Abstract: Disclosed are examples of systems, apparatus, methods and computer program products for creating custom platform objects for a multi-tenant non-relational database environment. A database system maintains a multi-tenant non-relational database associated with multiple enterprises and a number of records for each of the enterprises. The system also maintains a dynamic virtual table associated with a number of records. A request is received from one of the enterprises to define a custom data object within the database system, uniquely associated with an enterprise. The request is processed, and a custom object is generated based on the request. The custom object defines database columns corresponding to the data object and the enterprise. The virtual table is updated to include virtual columns corresponding to the database column definitions, and existing columns of a shared table in the non-relational database are updated to match the virtual columns. Access to the existing columns is then restricted for enterprises not uniquely associated with the custom data object.

公开(公告)号：US20190095534A1

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

申请号：US15717788

申请日：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/901 ,  G06F16/9038

Abstract: Disclosed are examples of systems, apparatus, methods and computer program products for providing a web application builder framework in a database system. 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 dynamic virtual table is maintained as well, associated with the number of records and number of data objects. A user request is received to define a composite key for a data object. A metadata model is generated representing the data object, and a data definition script is generated. The dynamic virtual table is updated to include one or more virtual columns corresponding to the data definition script, and one or more columns of a shared table in the non-relational database are updated to match the virtual columns.

公开(公告)号：US20180365299A1

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

申请号：US16112538

申请日：2018-08-24

Applicant: salesforce.com, inc.

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

IPC: G06F17/30

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.

公开(公告)号：US20180096013A1

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

申请号：US15283130

申请日：2016-09-30

Applicant: salesforce.com, inc.

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

IPC: G06F17/30

CPC classification number: G06F16/2291 ,  G06F16/221 ,  G06F16/2282

Abstract: Disclosed are examples of systems, apparatus, methods and computer program products for creating custom platform objects for a multi-tenant non-relational database environment. A database system maintains a multi-tenant non-relational database associated with multiple enterprises and a number of records for each of the enterprises. The system also maintains a dynamic virtual table associated with a number of records. A request is received from one of the enterprises to define a custom data object within the database system, uniquely associated with an enterprise. The request is processed, and a custom object is generated based on the request. The custom object defines database columns corresponding to the data object and the enterprise. The virtual table is updated to include virtual columns corresponding to the database column definitions, and existing columns of a shared table in the non-relational database are updated to match the virtual columns. Access to the existing columns is then restricted for enterprises not uniquely associated with the custom data object.

公开(公告)号：US09495403B2

公开(公告)日：2016-11-15

申请号：US13773383

申请日：2013-02-21

Applicant: salesforce.com, inc.

Inventor： Pawan Nachnani ,  Dan Milbrath ,  Susan Levine ,  Eli Levine

IPC: G06F17/00 ,  G06F17/30

CPC classification number: G06F17/30345 ,  G06F17/30303

Abstract: Systems and methods are provided for cleaning data in a customer relationship management system. A system receives a plurality of records from an on-demand system. The system identifies a record from the plurality of records that matches a stored record for a customer relationship management system. The system determines whether to update the stored record using the identified record. The system updates the stored record using the identified record in response to a determination to update the stored record using the identified record.

Abstract translation: 提供了系统和方法来清理客户关系管理系统中的数据。 系统从点播系统接收多个记录。 系统识别与客户关系管理系统的存储记录相匹配的多个记录中的记录。 系统使用识别的记录确定是否更新存储的记录。 响应于使用识别的记录来更新存储的记录的确定，系统使用所识别的记录来更新所存储的记录。

公开(公告)号：US11714811B2

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

申请号：US15717772

申请日：2017-09-27

Applicant: salesforce.com, inc.

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

IPC: G06F16/2453 ,  G06F21/62 ,  G06F16/2455 ,  G06F16/28

CPC classification number: G06F16/24549 ,  G06F16/24568 ,  G06F16/28 ,  G06F21/6218 ,  G06F21/6227

Abstract: Disclosed are examples of systems, apparatus, methods and computer program products for providing run-time querying of 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, each data object having at least one composite key field. A request is received during runtime to query data related to a data object, and the system determines that the data object is defined to be used in associated with a non-relational database. The system then retrieves a metadata model of the data object, determines that the request includes at least one composite key field for the data object, and processes the requery to query data in synchronous fashion. Finally, a query response is provided to the user.

公开(公告)号：US20200320071A1

公开(公告)日：2020-10-08

申请号：US16853572

申请日：2020-04-20

Applicant: salesforce.com, inc.

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

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

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.

公开(公告)号：US20200073987A1

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

申请号：US16121362

申请日：2018-09-04

Applicant: salesforce.com, inc.

Inventor： Saikiran Perumala ,  Eli Levine ,  Jan Asita Fernando ,  Samarpan Jain ,  Cody Marcel ,  Brian D. Esserlieu

IPC: G06F17/30

Abstract: Systems, methods, and computer-readable media for asynchronous (async) querying are described. In embodiments, an application server obtains a user-issued query comprising one or more query components; identifies data space characteristics of a data storage space associated with a user that issued the user-issued query; and analyzes the one or more query components to obtain performance data. The performance data is indicative of resource consumption for execution of the user-issued query. The application server selects a query execution engine to execute the user-issued query from among a plurality of query execution engines, and provides the user-issued query to the selected query execution engine. The selection is based on the data space characteristics and the performance data. Other embodiments may be described and/or claimed.

公开(公告)号：US20190303352A1

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

申请号：US16442409

申请日：2019-06-14

Applicant: salesforce.com, inc.

Inventor： Eli Levine ,  Jonathan Mark Bruce

IPC: G06F16/18 ,  G06F16/28 ,  G06F16/25 ,  G06F16/27 ,  G06F16/2458 ,  G06F16/21 ,  G06F16/245 ,  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.