×

Querying a not only structured query language (NoSQL) database using structured query language (SQL) commands

  • US 10,496,640 B2
  • Filed: 12/18/2013
  • Issued: 12/03/2019
  • Est. Priority Date: 12/19/2012
  • Status: Active Grant
First Claim
Patent Images

1. A method comprising:

  • receiving, with a Structured Query Language (SQL)-to-Non-Structured Query Language (NoSQL) agent, a SQL query, wherein the SQL query is received through a first application programming interface (API) at a first architectural level;

    transforming, with a server-side JAVA®

    Database Connectivity (JDBC) driver associated with the SQL-to-NoSQL agent, the SQL query into a set of one or more non-relational database scans having associated row key ranges and having no joins in the set bybuilding a map of feature values, andreturning one aggregated row per distinct group;

    sending, with the SQL-to-NoSQL agent, the set of one or more non-relational database scans having no joins with instructions for execution in parallel for each row key range, wherein the non-relational database scans are sent to the non-relational database through a second API at a second architectural level that is lower than the first architectural level and the SQL query language is to be used to manage schemas at a lower level;

    causing results from the set of one or more non-relational database scans to be joined;

    receiving, with the SQL-to-NoSQL agent, results from the set of one or more non-relational database scans through the second API;

    performing, with the server-side JDBC driver, merge sorting on the results to generate combined results to provide an aggregate result to the SQL; and

    transmitting, with the SQL-to-NoSQL agent, the aggregated result as results of the SQL query through the first API.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×