Cluster processing of an aggregated dataset

• US 9,466,063 B2
• Filed: 02/15/2011
• Issued: 10/11/2016
• Est. Priority Date: 01/26/2007
• Status: Active Grant

• Current Assignee: Information Resources Incorporated
• Original Assignee: Information Resources Incorporated
• Inventors: Hunt, Herbert Dennis, West, John Randall, Gibbs, Marshall Ashby Jr., Griglione, Bradley Michael, Hudson, Gregory David Neil, Basilico, Andrea, Johnson, Arvid C., Bergeon, Cheryl G., Chapa, Craig Joseph, Agostinelli, Alberto, Yusko, Jay Alan, Mason, Trevor, Liu, Ting
• Primary Examiner(s): Hoang, Son T
• Application Number:
  US13/028,022
• Publication Number:
  US 20110137924A1
• Time in Patent Office: 2,065 Days
• Field of Search: 707/736, 707/769
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2453 Query optimisation
• CPC Class Codes: G06F 16/24556 Aggregation; Duplicate elimination
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising

Abstract

Using a computer, a database comprising a field is identified. A query relating to the field is identified. Prior to processing the query, the field is dynamically altered to conform to a desired bit size. The query is processed. The results of the query are returned.

Claims

1. A method, utilizing a computer, for cluster processing of an aggregated dataset comprising:

identifying a database comprising a field;

identifying a query relating to the field, the query including an analytical query from a master cluster node to a slave cluster node, wherein the analytical query further includes a request to summarize data in the database;

prior to processing the query, dynamically altering the field to conform to a desired bit size;

associating the query with information relating to the dynamic alteration that has been made to the field of the database, wherein the information enables the slave cluster node to accurately read the data in the field of the database;

processing the query from the slave cluster node; and

returning results of the query to the master cluster node.

2. The method of claim 1, the method further comprising:

after the dynamically altering the field, removing from the database a header indicating how data in field is to be read or processed.

3. The method of claim 1, further comprising recording the desired bit size in a record of the database.

4. The method of claim 2, wherein the processing the query includes reading data in the field in groups of a size equal to the desired bit size.