SYSTEM AND METHOD FOR INTERACTING WITH A PLURALITY OF DATA SOURCES

• US 20110246480A1
• Filed: 03/31/2011
• Published: 10/06/2011
• Est. Priority Date: 04/02/2010
• Status: Active Grant

• Current Assignee: Ignite ScaleArc Solutions, Inc.
• Original Assignee: Scalarc Inc.
• Inventors: Levari, Doron, Zelkha, Liran
• Granted Patent: US 9,116,946 B2
• Time in Patent Office: Days
• US Class Current: 707/747
• CPC Class Codes: G06F 16/2255 Hash tables
• CPC Class Codes: G06F 16/244 Grouping and aggregation
• CPC Class Codes: G06F 16/24556 Aggregation; Duplicate elimination
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: G06F 16/955 using information identifiers, e.g. uniform resource locators [URL]

Abstract

System and method for interacting with a plurality of data sources are provided. A request may be parsed and an identification parameter identifying a data set may be determined. A field included in the request may be designated as a distribution key. At least one data source may be selected based on a value associated with the distribution key. At least a portion of the request may be sent to a selected data source. Other embodiments are described and claimed.

Claims

1. A method of processing a request, the method comprising:

parsing a request received from a client to determine a data set identification parameter;

designating, based on the data set identification parameter, a field included in the request as a distribution key;

selecting, based on a value of the distribution key, at least one data source; and

sending at least a portion of the request to a selected data source;

2. The method of claim 1, comprising dynamically associating a plurality of values with the distribution key and respectively selecting a respective plurality of data sources to receive at least a portion of the request.

3. The method of claim 1, comprising associating a data source with a range of values and, if the value of the distribution key is included in the range of values, then sending the request to the associated data source.

4. The method of claim 1, comprising determining, based on the data set identification parameter, whether the associated data set is a non-distributed data set and, if the data set is a non-distributed data set then:

if the request is related to a retrieval of data then selecting a data source based on a load balancing scheme, and

if the request is related to an update of information then sending the request to all data sources associated with the data set.

5. The method of claim 1, wherein a selected data source is one of:

a master data source, a mirrored data source and a distributed data source.

6. The method of claim 1, comprising calculating an index based on the value of the distribution key and sending the request to a data source associated with the index.

7. The method of claim 1, wherein the data set identification parameter is a table name.

8. The method of claim 1, wherein designating a field as a distribution key is based on an association of the data set identification parameter with a field included in the request.

9. The method of claim 6, wherein calculating the index comprises providing the value of the distribution key as input to a hash function.

11. The method of claim 6, comprising using the value of the distribution key as an index.

12. The method of claim 1, comprising generating a request to a data source by replacing a grouping operator in the received request by a sorting operator.

10. The method of claim 10, comprising using a mapping table to associate the index with the selected data source.

13. An article comprising a non-transitory computer-readable storage medium, having stored thereon instructions, that when executed on a computer, cause the computer to:

parse a request received from a client to determine a data set identification parameter;

designate, based on the data set identification parameter, a field included in the request as a distribution key;

select, based on a value of the distribution key, at least one data source; and

send at least a portion of the request to a selected data source;

14. The article of claim 13, wherein the instructions when executed further result in dynamically associating a plurality of values with the distribution key and respectively selecting a respective plurality of data sources to receive at least a portion of the request.

15. The article of claim 13, wherein the instructions when executed further result in associating a data source with a range of values and, if the value of the distribution key is included in the range of values, then sending the request to the associated data source.

16. The article of claim 13, wherein the instructions when executed further result in determining, based on the data set identification parameter, whether the associated data set is a non-distributed data set and, if the data set is a non-distributed data set then:

if the request is related to a retrieval of data then selecting a data source based on a load balancing scheme, and

if the request is related to an update of information then sending the request to all data sources associated with the data set.

17. The article of claim 13, wherein a selected data source is one of:

a master data source, a mirrored data source and a distributed data source.

18. The article of claim 13, wherein the instructions when executed further result in calculating an index based on the value of the distribution key and sending the request to a data source associated with the index.

19. The article of claim 13, wherein the data set identification parameter is a table name.

20. The article of claim 13, wherein the instructions when executed further result in designating a field as a distribution key is based on an association of the data set identification parameter with a field included in the request.

21. The article of claim 18, wherein calculating the index comprises providing the value of the distribution key as input to a hash function.

22. The article of claim 18, comprising using a mapping table to associate the index with the selected data source.

23. The article of claim 13, comprising using the value of the distribution key as an index, the index identifying a data source.

24. The article of claim 13, comprising generating a request to a data source by replacing a grouping operator in the received request by a sorting operator.