-
公开(公告)号：US10853511B2
公开(公告)日：2020-12-01
申请号：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
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.
-
公开(公告)号：US20190095532A1
公开(公告)日：2019-03-28
申请号：US15717772
申请日：2017-09-27
Applicant: salesforce.com, inc.
Inventor： Eli Levine , Samarpan Jain , James Ferguson , Jan Asita Fernando
Abstract: Disclosed are examples of systems, apparatus, methods and computer program products for providing run-time querying of muli-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.
-
公开(公告)号：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.
-
公开(公告)号：US20180096012A1
公开(公告)日：2018-04-05
申请号：US15283119
申请日：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/2282
Abstract: Disclosed are examples of systems, apparatus, methods and computer program products for updating and managing multi-tenant non-relational database schemas. A database system maintains a multi-tenant non-relational database associated with multiple enterprises. A number of records are stored for each of the enterprises. The system also maintains a dynamic virtual table storing a number of records. A request is received from a user of the database system to define a data object within the database system. The request is processed, and an object script is generated based on the request, the object script defining one or more database columns in the database system that are associated with the data object. The dynamic virtual table is updated such that one or more virtual columns match the database column definitions in the object script. Existing columns of a shared table in the multi-tenant non-relational database are then updated to match the virtual columns in the dynamic virtual table.
-
公开(公告)号：US20150142846A1
公开(公告)日：2015-05-21
申请号：US14542342
申请日：2014-11-14
Applicant: salesforce.com, inc.
Inventor： Eli Levine , Jonathan Mark Bruce
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 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.
Abstract translation: 用于完成数据库查询的技术和系统。 响应于接收原始数据库查询来完成同步查询的时间由一个或多个计算设备提供的数据库管理系统来估计。 如果完成同步查询的估计时间小于预先选择的阈值时间，则与数据库管理系统一起执行与原始数据库查询相对应的同步数据库查询。 如果完成同步查询的估计时间大于预选阈值时间，则与数据库管理系统一起执行与原始数据库查询相对应的一个或多个异步查询。 无论是来自同步查询还是一个或多个异步查询的结果都存储在非关系数据库系统中的对象中。
-
Patent Agency Ranking
公开(公告)号：US20240419676A1
公开(公告)日：2024-12-19
申请号：US18820079
申请日：2024-08-29
Applicant: salesforce.com, Inc.
Inventor： Jonathan Bruce , Eli Levine , Simon Toens , Ian Varley
IPC: G06F16/2458 , G06F16/18 , G06F16/20 , G06F16/21 , G06F16/245 , G06F16/25 , G06F16/27 , G06F16/28
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.
-
公开(公告)号：US11301419B2
公开(公告)日：2022-04-12
申请号：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
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.
-
公开(公告)号：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.
-
公开(公告)号：US10579692B2
公开(公告)日：2020-03-03
申请号：US15717788
申请日：2017-09-27
Applicant: salesforce.com, inc.
Inventor： Eli Levine , Samarpan Jain , James Ferguson , Jan Asita Fernando
IPC: 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.
-
公开(公告)号：US20150142751A1
公开(公告)日：2015-05-21
申请号：US14542357
申请日：2014-11-14
Applicant: salesforce.com, inc.
Inventor： Jonathan Mark Bruce , Eli Levine , Simon Toens
IPC: G06F17/30
CPC classification number: G06F17/30545 , G06F17/30424 , G06F17/30557 , G06F17/30566 , G06F17/30569 , G06F17/30575 , G06F17/30595 , G06F17/30607
Abstract: Managing data in a multitenant environment having a relational database and a non-relational database. A set of one or more policies for data retention corresponding to data stored in the relational database environment is received. The policies for data retention are defined on a tenant-by-tenant basis within the multitenant environment. The policies are deployed to data in the relational database on a tenant-by-tenant basis within the multitenant environment. Data to be copied from the relational database to the non-relational database is identified. The data to be copied in the non-relational database is stored while maintaining tenant isolation so that data belonging to the respective tenants is not accessible by other tenants when stored in the non-relational database.
Abstract translation: 在具有关系数据库和非关系数据库的多租户环境中管理数据。 接收一组用于与存储在关系数据库环境中的数据相对应的用于数据保留的策略。 数据保留政策是在多租户环境中按租户方式进行定义的。 这些策略在多租户环境中以租户为单位部署到关系数据库中的数据。 识别从关系数据库复制到非关系数据库的数据。 要在非关系数据库中复制的数据被存储，同时保持租户隔离，使得属于相应租户的数据在存储在非关系数据库中时不被其他租户访问。
-
-
-
-
-
-
-
-
-
Search Results
37
records
(took 0.018 seconds)
