QUERYING A NOT ONLY STRUCTURED QUERY LANGUAGE (NOSQL) DATABASE USING STRUCTURED QUERY LANGUAGE (SQL) COMMANDS
First Claim
Patent Images
1. A method comprising:
- receiving a Structure Query Language (SQL) query;
transforming the SQL query into one or more non-relational database scans having associated row key ranges;
executing the one or more non-relational database scans in parallel for each row key range;
combining results from the parallel scans of the non-relational database; and
providing the combined results as results of the SQL query.
1 Assignment
0 Petitions
Accused Products
Abstract
Techniques for querying a Not-Only/Non Structured Query Language (NoSQL) database using Structure Query Language (SQL) commands. A SQL query is received. The SQL query is transformed into one or more non-relational database scans having associated row key ranges. The one or more non-relational database scans are executed in parallel for each row key range. The results from the parallel scans of the non-relational database are combined. The combined results are presented as results of the SQL query.
-
Citations
22 Claims
-
1. A method comprising:
-
receiving a Structure Query Language (SQL) query; transforming the SQL query into one or more non-relational database scans having associated row key ranges; executing the one or more non-relational database scans in parallel for each row key range; combining results from the parallel scans of the non-relational database; and providing the combined results as results of the SQL query. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A non-transitory computer-readable medium having stored thereon instructions that, when executed, cause one or more processors to:
-
receive a Structure Query Language (SQL) query; transform the SQL query into one or more non-relational database scans having associated row key ranges; execute the one or more non-relational database scans in parallel for each row key range; combine results from the parallel scans of the non-relational database; and provide the combined results as results of the SQL query. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
13. An apparatus comprising:
-
means for receiving a Structure Query Language (SQL) query; means for transforming the SQL query into one or more non-relational database scans having associated row key ranges; means for executing the one or more non-relational database scans in parallel for each row key range; means for combining results from the parallel scans of the non-relational database; and means for providing the combined results as results of the SQL query. - View Dependent Claims (14, 15, 16)
-
-
17. A system comprising:
-
one or more interfaces to communicate with one or more user systems; a server system communicatively coupled with the one or more user systems via a network, the server system to provide a multitenant environment, wherein the multitenant environment includes data for multiple client entities, each identified by a tenant identifier (ID) having one of one or more users associated with the tenant ID, users of each of multiple client identities can only access data identified by a tenant ID associated with the respective client entity, and the multitenant environment is at least a hosted database provided by an entity separate from the client entities, and provides on-demand database service to the client entities, the server system further to receive a Structure Query Language (SQL) query, to transform the SQL query into one or more non-relational database scans having associated row key ranges, to execute the one or more non-relational database scans in parallel for each row key range, to combine results from the parallel scans of the non-relational database, and to provide the combined results as results of the SQL query. - View Dependent Claims (18, 19, 20, 21, 22)
-
Specification