System and method for processing query requests in a...

Details System and method for processing query requests in a... System and method for processing query requests in a...

2011-03-29

2011-03-29

Cottingham, John R (Department: 2167)

Data processing: database and file management or data structures

Database and file access

Query optimization

C707S718000

Reexamination Certificate

active

07917495

ABSTRACT:
In certain embodiments, a database system for processing a query request comprises at least one master node operable to store a precompiled query that is capable of resolving a query request received by the database system. The at least on master node is further operable to receive a query request comprising one or more parameters and associated with the precompiled query, and to communicate a request to perform one or more activities associated with the precompiled query. The system further comprises a plurality of slave nodes coupled to the at least one master node, each of the slave nodes operable to store one or more key parts each comprising data capable of resolving a portion of the precompiled query. At least one of the slave nodes is operable to receive the request communicated by the at least one master node and to process the request communicated by the at least one master node.

REFERENCES:
patent: 4543630 (1985-09-01), Neches
patent: 5301333 (1994-04-01), Lee
patent: 5349682 (1994-09-01), Rosenberry
patent: 5418937 (1995-05-01), Inoue
patent: 5437032 (1995-07-01), Wolf et al.
patent: 5504886 (1996-04-01), Chang et al.
patent: 5515531 (1996-05-01), Fujiwara et al.
patent: 5551027 (1996-08-01), Choy et al.
patent: 5675742 (1997-10-01), Jain et al.
patent: 5717911 (1998-02-01), Madrid et al.
patent: 5752031 (1998-05-01), Cutler et al.
patent: 5857180 (1999-01-01), Hallmark et al.
patent: 6038563 (2000-03-01), Bapat et al.
patent: 6092062 (2000-07-01), Lohman et al.
patent: 6110228 (2000-08-01), Albright et al.
patent: 6144992 (2000-11-01), Turpin et al.
patent: 6351742 (2002-02-01), Agarwal et al.
patent: 6438537 (2002-08-01), Netz et al.
patent: 6438562 (2002-08-01), Gupta et al.
patent: 6449356 (2002-09-01), Dezonno
patent: 6505205 (2003-01-01), Kothuri et al.
patent: 6546403 (2003-04-01), Carlson, Jr. et al.
patent: 6694337 (2004-02-01), King et al.
patent: 6886046 (2005-04-01), Stutz et al.
patent: 6993774 (2006-01-01), Glass
patent: 7007070 (2006-02-01), Hickman
patent: 7054910 (2006-05-01), Nordin et al.
patent: 7158975 (2007-01-01), Mazzagatti
patent: 2001/0053957 (2001-12-01), Blair et al.
patent: 2001/0055311 (2001-12-01), Trachewsky et al.
patent: 2002/0065884 (2002-05-01), Donoho et al.
patent: 2002/0138582 (2002-09-01), Chandra et al.
patent: 2002/0143755 (2002-10-01), Wynblatt et al.
patent: 2002/0152188 (2002-10-01), Crus et al.
patent: 2002/0184314 (2002-12-01), Riise
patent: 2003/0018645 (2003-01-01), Kong
patent: 2003/0069923 (2003-04-01), Peart
patent: 2003/0078858 (2003-04-01), Angelopoulos et al.
patent: 2003/0200282 (2003-10-01), Arnold et al.
patent: 2003/0220941 (2003-11-01), Arnold et al.
patent: 2004/0088294 (2004-05-01), Lerhaupt
patent: 2004/0098370 (2004-05-01), Garland et al.
patent: 2004/0098390 (2004-05-01), Bayliss et al.
patent: 2004/0143644 (2004-07-01), Berton et al.
patent: 2004/0162822 (2004-08-01), Papanyan et al.
patent: 2004/0204988 (2004-10-01), Willers et al.
patent: 2004/0260685 (2004-12-01), Pfleiger et al.
patent: 2004/0267719 (2004-12-01), Doherty et al.
patent: 2005/0187977 (2005-08-01), Frost
System and Method for Pre-Compiling a Query and Pre-Keying a Database System, by Richard K. Chapman, et al., U.S. Appl. No. 10/866,270, Pending, 79 pages, Jun. 11, 2004.
System and Method for Processing a Request to Perform an Activity Associated with a Precompiled Query, by Richard K. Chapman, et al., U.S. Appl. No. 10/866,565, Pending, 123 pages, Jun. 11, 2004.
System and Method for Returning Results of a Query from One or More Slave Nodes to One or More Master Nodes of a Database System, by Richard K. Chapman, et al., U.S. Appl. No. 10/866,456, Pending, 120 pages, Jun. 11, 2004.
System and Method for Enhancing System Reliability using Multiple Channels and Multicast, by Richard K. Chapman, et al., U.S. Appl. No. 10/866,604, Pending, 79 pages, Jun. 11, 2004.
System and Method for using Activity Identifications in a Database System, by Richard K. Chapman, et al., U.S. Appl. No. 10/865,954, Pending, 79 pages, Jun. 11, 2004.
System and Method for Dynamically Creating Keys in a Database System, by Richard K. Chapman, et al., U.S. Appl. No. 10/866,616, Pending, 67 pages, Jun. 11, 2004.
System and Method for Distributing Data in a Parallel Processing System, by Richard K. Chapman, et al., U.S. Appl. No. 10/866,620, Pending, 79 pages, Jun. 11, 2004.
System and Method for Managing Throughout in the Processing of Query Requests in a Database System, by Richard K. Chapman, et al., U.S. Appl. No. 10/866,394, Pending, 122 pages, Jun. 11, 2004.
Oracle7™ Server Distributed Systems, vol. II: Replicated Data, Release 7.3, Feb. 1996, Oracle®.
Liu, Ling, “Query Routing in Large-scale Digital Library Systems”, Data Engineering, 1999 Proceedings, 15thInternational conference on Sydney, NSW, Australia, Mar. 23-26, 1999, Los Alamitos, CA, USA, IEEE Computer Society, Mar. 23, 1999, pp. 154-163.
Bonnet et al., “Query Processing in a Device Database System”, Cornell University, Technical Report: TR99-1775, Oct. 1999, 26 pages.
Avi Kavas et al., Using Multicast to Pre-Load Jobs on the ParPar Cluster, Feb. 2001, Parallel Computing, vol. 27, Issue 3, pp. 315-327.

Affiliated with

Also associated with

Rating

System and method for processing query requests in a... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for processing query requests in a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for processing query requests in a... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2701566