QUERYING NONSQL DATA STORES WITH A SQL-STYLE LANGUAGE
First Claim
1. A method for querying a nonSQL index with a SQL query, said nonSQL index containing data associated with a social networking network, said method comprising:
- parsing the SQL query for query parameters, said query parameters specifying requested data associated with the social networking network;
identifying a type of the nonSQL index based on the nonSQL index;
generating a first nonSQL query based on the query parameters and the type of nonSQL index;
querying the nonSQL index with the generated first nonSQL query to search for the requested data;
receiving a first nonSQL result set from the nonSQL index based on the first nonSQL query; and
transforming the first nonSQL result set into a SQL result set based on the type of nonSQL index and the received SQL query, said SQL result set containing the requested data associated with the social networking network.
2 Assignments
0 Petitions
Accused Products
Abstract
A nonSQL index containing data associated with a social networking network is queried with a nonSQL query generated from a SQL query. A query translation component parses the SQL query for query parameters specifying requested data and identifies a type of the nonSQL index based on the nonSQL index. The query translation component generates a nonSQL query based on the query parameters and the type of nonSQL index and queries the nonSQL index with the generated nonSQL query to search for the requested data. The query translation component receives a nonSQL result set from the nonSQL index based on the nonSQL query and then transforms the nonSQL result set into a SQL result set based on the type of nonSQL index and the received SQL query.
-
Citations
20 Claims
-
1. A method for querying a nonSQL index with a SQL query, said nonSQL index containing data associated with a social networking network, said method comprising:
-
parsing the SQL query for query parameters, said query parameters specifying requested data associated with the social networking network; identifying a type of the nonSQL index based on the nonSQL index; generating a first nonSQL query based on the query parameters and the type of nonSQL index; querying the nonSQL index with the generated first nonSQL query to search for the requested data; receiving a first nonSQL result set from the nonSQL index based on the first nonSQL query; and transforming the first nonSQL result set into a SQL result set based on the type of nonSQL index and the received SQL query, said SQL result set containing the requested data associated with the social networking network. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A method for querying a plurality of nonSQL indexes with a SQL query, said SQL query requesting data, said method comprising:
-
parsing the SQL query for query parameters, said query parameters specifying requested data; for each of the nonSQL indexes; identifying a type of the nonSQL index based on the nonSQL index; generating a nonSQL query based the query parameters and the type of nonSQL index; querying the nonSQL index with the generated nonSQL query; and receiving a nonSQL result set from the nonSQL index based on the nonSQL query; and merging each of the received plurality of nonSQL result sets into a SQL result set based on the parsed query parameters and the received SQL query, said SQL result set containing the requested data from the plurality of nonSQL indexes. - View Dependent Claims (10, 11, 12, 13, 14)
-
-
15. A system for querying a plurality of nonSQL indexes with a SQL query comprising:
-
an application for generating the SQL query, said application providing one or more social networking services; a plurality of nonSQL indexes associated with data related to at least one of the social networking services provided; a query translation component for; receiving the SQL query from the application; parsing the received SQL query for query parameters; for each of the nonSQL indexes; identifying a type of the nonSQL index based on the nonSQL index; generating a nonSQL query based the query parameters and the type of nonSQL index; querying the nonSQL index with the generated nonSQL query; and receiving a nonSQL result set from the nonSQL index based on the nonSQL query; merging each of the received plurality of nonSQL result sets into a SQL result set based on the parsed query parameters and the received SQL query; and returning the SQL result set to the application. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification