Systems and methods for implementation of a structured query language interface in a distributed database environment

• US 20090049014A1
• Filed: 02/21/2008
• Published: 02/19/2009
• Est. Priority Date: 02/21/2007
• Status: Active Grant

• Current Assignee: Meta Platforms, Inc. (f/k/a Facebook, Inc.)
• Original Assignee: Meta Platforms, Inc. (f/k/a Facebook, Inc.)
• Inventors: Steinberg, Arieh
• Granted Patent: US 8,832,556 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/43 Querying
• CPC Class Codes: G06F 16/435 Filtering based on additional data, e.g. user or group profiles
• CPC Class Codes: G06F 16/90335 Query processing
• CPC Class Codes: H04L 51/52 for supporting social networking services
• CPC Class Codes: H04L 67/306 User profiles
• CPC Class Codes: Y10S 715/969 Network layout and operation interface

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.

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.