Systems and methods for implementation of a structured query language interface in a distributed database environment
First Claim
1. A system for implementation of a structured query language interface in a distributed database environment comprising:
- a distributed database configured with items of data;
a volatile cache memory in communication with the distributed database, the volatile cache memory configured with a subset of the items of data;
a scripting language in communication with the volatile cache memory, the scripting language configured to extract data from the volatile cache memory; and
the structured query language interface in communication with the scripting language, the structured query language interface configured to receive a query over a network, to send the query to the scripting language, and to receive extracted data from the scripting language in response to the query.
2 Assignments
0 Petitions
Accused Products
Abstract
Systems and methods for implementation of a structured query language interface in a distributed database environment are provided. Exemplary systems include a distributed database configured with items of data, a volatile cache memory configured with a subset of the items of data, a scripting language configured to extract data from the volatile cache memory, and a structured query language interface configured to receive a query over a network, to send the query to the scripting language, and to receive extracted data from the scripting language in response to the query. Further systems and methods include the scripting language configured to apply business logic rules to the extracted data before the extracted data is sent to the structured query language interface. The structured query language interface may also be configured to send some or all of the extracted data in a format to accommodate a database maintained by a third-party developer.
-
Citations
20 Claims
-
1. A system for implementation of a structured query language interface in a distributed database environment comprising:
-
a distributed database configured with items of data; a volatile cache memory in communication with the distributed database, the volatile cache memory configured with a subset of the items of data; a scripting language in communication with the volatile cache memory, the scripting language configured to extract data from the volatile cache memory; and the structured query language interface in communication with the scripting language, the structured query language interface configured to receive a query over a network, to send the query to the scripting language, and to receive extracted data from the scripting language in response to the query.
-
-
2. The system of claim 1, wherein the scripting language is further configured to apply business logic rules to the extracted data before the extracted data is sent to the structured query language interface.
-
3. The system of claim 1, wherein the structured query language interface is further configured to send some or all of the extracted data over the network.
-
4. The system of claim 1, wherein the structured query language interface is further configured to send some or all of the extracted data over the network to an application or a web site maintained by a third-party developer.
-
5. The system of claim 1, wherein the query is received by the structured query language interface from an application or a web site maintained by a third-party developer.
-
6. The system of claim 1, wherein the scripting language is further configured to extract data from the distributed database.
-
7. The system of claim 1, wherein the distributed database comprises a plurality of databases.
-
8. The system of claim 5, wherein the third-party developer is a commercial entity.
-
9. The system of claim 5, wherein the third-party developer is a non-commercial entity.
-
10. The system of claim 5, wherein the application is accessible from a web-based social network.
-
11. The system of claim 5, wherein the application is accessible from a web-based social network when a user of the web-based social network is operating within an environment of the social network.
-
12. The system of claim 11, wherein the environment comprises at least in part a personal profile page.
-
13. The system of claim 1, wherein the distributed database is associated with a web-based social network.
-
14. The system of claim 1, wherein the structured query language interface is further configured to send some or all of the extracted data in a format to accommodate a database maintained by a third-party developer.
-
15. A method for implementation of a structured query language interface in a distributed database environment, the method comprising:
-
configuring a distributed database with items of data; configuring a volatile cache memory in communication with the distributed database with a subset of the items of data; configuring a scripting language in communication with the volatile cache memory to extract data from the volatile cache memory; and configuring the structured query language interface to receive a query over a network, to send the query to the scripting language, and to receive extracted data from the scripting language in response to the query.
-
-
16. The method of claim 15, the method further comprising:
configuring the scripting language to apply business logic rules to extracted data before the extracted data is sent to the structured query language interface.
-
17. The method of claim 15, the method further comprising:
configuring the structured query language interface to send some or all of the extracted data over the network.
-
18. The method of claim 15, the method further comprising:
configuring the structured query language interface to send some or all of the extracted data over the network to an application or a web site maintained by a third-party developer.
-
19. The method of claim 15, the method further comprising:
configuring the structured query language interface to send some or all of the extracted data in a format to accommodate a database maintained by a third-party developer.
-
20. A method for performing a query of a distributed database, the method comprising:
-
receiving the query over a network from an application or web site maintained by a third-party developer; extracting with a structured query language data responsive to the query; applying business logic rules to the extracted data; formatting the extracted data to accommodate a database maintained by the third-party developer; and sending the formatted extracted data over the network to the third-party developer.
-
Specification