Multi-tenancy for structured query language (SQL) and non structured query language (NoSQL) databases

• US 10,664,487 B2
• Filed: 08/24/2018
• Issued: 05/26/2020
• Est. Priority Date: 11/15/2013
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Bruce, Jonathan, Levine, Eli, Toens, Simon, Taylor, James
• Primary Examiner(s): McQuitery, Diedra
• Application Number:
  US16/112,538
• Publication Number:
  US 20180365299A1
• Time in Patent Office: 641 Days
• CPC Class Codes: G06F 16/18 File system types
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/219 Managing data history or versioning querying versioned data G06F16/2474; querying temporal data G06F16/2477
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/289 Object oriented databases

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.

Claims

1. A system comprising:

a group of one or more server computing devices configured to provide a computing environment that provides on-demand service to client entities;

at least one relational database system coupled with the one or more server computing devices, the at least one relational database system to provide data management services to tenants of the computing environment;

at least one non-relational database system coupled with the one or more server computing devices, the at least one non-relational database system to provide data management services to client entities of the computing environment, the non-relational database system to manage scan ranges for the non-relational database to limit access for each client entity to data in the non-relational database corresponding to that client entity, wherein a primary key constraint of a base table cannot be changed and indexes in separate shared tables can be added;

a database search agent coupled with the at least one relational database system and with the at least one non-relational database system, the database search agent to receive a database query in a format corresponding to the relational database system, to parse the query to find one or more components of the query directed to data stored in the non-relational database system, to convert one or more components of the query directed to data stored in the non-relational database system to one or more scans of the non-relational database system wherein table metadata is utilized to provide use of correct schema in responding to the one or more scans, to collect results from the query of the relational database system and results from the one or more scans of the non-relational database system, to combine the results from the query and the results of the one or more scans to a combined result, and to provide the combined result to a client entity.

2. The system of claim 1 wherein the multitenant environment comprises a multitenant on-demand services environment.

3. The system of claim 2 wherein the multitenant on-demand service environment comprises at least a multitenant database environment.

4. The system of claim 1 wherein data stored in the non-relational database is immutable.

5. The system of claim 1 wherein the at least one non-relational database system to provide the ability to run one or more client entity-specific tables that use a single common physical non-relational database table.

6. A method comprising:

receiving a database query with at least one server computing device providing a computing environment having a relational database system and a non-relational database system, the database query in a format corresponding to the relational database system;

parsing the query 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;

converting with the at least one server computing device, one or more components of the query directed to data stored in the non-relational database system to one or more scans of the non-relational database system wherein table metadata is utilized to provide use of correct schema in responding to the one or more scans;

managing scan ranges for the non-relational database to limit access for each entity to data in the non-relational database corresponding to that entity, wherein a primary key constraint of a base table cannot be changed and indexes in separate shared tables can be added;

collecting results from the query of the relational database system and results from the one or more scans of the non-relational database system;

combining the results from the query and the results of the one or more scans to a combined result; and

providing the combined result to a client entity.

7. The method of claim 6 wherein the multitenant environment comprises a multitenant on-demand services environment.

8. The method of claim 7 wherein the multitenant on-demand service environment comprises at least a multitenant database environment.

9. The method of claim 6 wherein data stored in the non-relational database is immutable.

10. The method of claim 6 wherein the at least one non-relational database system to provide the ability to run one or more client entity-specific tables that use a single common physical non-relational database table.

11. A non-transitory computer-readable medium having stored thereon instructions that, when executed by one or more processors, cause the one or more processors to:

receive a database query with at least one server computing device providing a computing environment having a relational database system and a non-relational database system, the database query in a format corresponding to the relational database system;

parse the query 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;

convert with the at least one server computing device, one or more components of the query directed to data stored in the non-relational database system to one or more scans of the non-relational database system wherein table metadata is utilized to provide use of correct schema in responding to the one or more scans;

manage scan ranges for the non-relational database to limit access for each entity to data in the non-relational database corresponding to that entity, wherein a primary key constraint of a base table cannot be changed and indexes in separate shared tables can be added;

collect results from the query of the relational database system and results from the one or more scans of the non-relational database system;

combine the results from the query and the results of the one or more scans to a combined result; and

provide the combined result to a client entity.

12. The non-transitory computer-readable medium of claim 11 wherein the multitenant environment comprises a multitenant on-demand services environment.

13. The non-transitory computer-readable medium of claim 12 wherein the multitenant on-demand service environment comprises at least a multitenant database environment.

14. The non-transitory computer-readable medium of claim 11 wherein data stored in the non-relational database is immutable.

15. The non-transitory computer-readable medium of claim 11 wherein the at least one non-relational database system to provide the ability to run one or more client entity-specific tables that use a single common physical non-relational database table.