公开(公告)号：US10176235B2

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

申请号：US14542357

申请日：2014-11-14

Applicant: salesforce.com, inc.

Inventor： Jonathan Mark Bruce ,  Eli Levine ,  Simon Toens

IPC: G06F17/30

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.

公开(公告)号：US10908947B2

公开(公告)日：2021-02-02

申请号：US15374787

申请日：2016-12-09

Applicant: salesforce.com, inc.

Inventor： Brian Jaffery Tajuddin ,  Samarpan Jain ,  Reuben Cornel ,  Siddhi Mehta ,  Brian Esserlieu ,  Jan Asita Fernando ,  Jonathan Mark Bruce ,  Jay Hurst

IPC: G06F16/23 ,  G06F9/48 ,  G06F9/50 ,  H04L29/08

Abstract: Techniques and architectures for data ingestion in an environment having a distributed data storage system. A request to import data into the environment. The data to be imported from an external source through an application programming interface (API). The request is analyzed to determine if the request corresponds to a request to import a large data load. The data is staged if the request is for the large data load. Data management jobs are created to cause the data to be stored in one or more nodes of the distributed data storage system. The data management jobs are transmitted to corresponding nodes in the distributed data storage system. The jobs are executed asynchronously to cause the data to be stored in the nodes.

公开(公告)号：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: 在具有关系数据库和非关系数据库的多租户环境中管理数据。 接收一组用于与存储在关系数据库环境中的数据相对应的用于数据保留的策略。 数据保留政策是在多租户环境中按租户方式进行定义的。 这些策略在多租户环境中以租户为单位部署到关系数据库中的数据。 识别从关系数据库复制到非关系数据库的数据。 要在非关系数据库中复制的数据被存储，同时保持租户隔离，使得属于相应租户的数据在存储在非关系数据库中时不被其他租户访问。

公开(公告)号：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.

公开(公告)号：US20150142846A1

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

申请号：US14542342

申请日：2014-11-14

Applicant: salesforce.com, inc.

Inventor： Eli Levine ,  Jonathan Mark Bruce

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: 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: 用于完成数据库查询的技术和系统。 响应于接收原始数据库查询来完成同步查询的时间由一个或多个计算设备提供的数据库管理系统来估计。 如果完成同步查询的估计时间小于预先选择的阈值时间，则与数据库管理系统一起执行与原始数据库查询相对应的同步数据库查询。 如果完成同步查询的估计时间大于预选阈值时间，则与数据库管理系统一起执行与原始数据库查询相对应的一个或多个异步查询。 无论是来自同步查询还是一个或多个异步查询的结果都存储在非关系数据库系统中的对象中。

公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：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.

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