System and method for dynamically creating keys in a...

Details System and method for dynamically creating keys in a... System and method for dynamically creating keys in a...

2004-06-11

2010-06-15

Cottingham, John R. (Department: 2167)

Data processing: database and file management or data structures

Database and file access

Preparing data for information retrieval

C707S744000, C707S751000, C707S999002

Reexamination Certificate

active

07739287

ABSTRACT:
A database system capable of dynamically creating one or more keys associated with one or more pre-compiled queries includes a plurality of slave nodes that are operable to execute one or more pre-compiled queries. Each of the plurality of slave nodes operates to store one or more usage statistics that relate to the execution of the one or more pre-compiled queries. The system also includes at least one master node that is coupled to each of the plurality of slave nodes. The at least one master node is operable to receive the one or more usage statistics from each of the plurality of slave nodes. Furthermore, the at least one master node is operable to identify, based at least in part on the one or more usage statistics, one or more keys to dynamically create. Moreover, each of the plurality of slave nodes dynamically creates the one or more keys for use in executing the one or more pre-compiled queries.

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: 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: 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, filed Jun. 11, 2004.
System and Method for Processing Query Requests in a Database System, by Richard K. Chapman, et al., U.S. Appl. No. 10/866,204, Pending, 122 pages, filed 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, filed 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, filed Jun. 11, 2004.
System and Method for Enhancing Sysem Reliability using Multiple Channels and Multicast, by Richard K. Chapman, et al., U.S. Appl. No. 10/866,604, Pending, 79 pages, filed 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, filed 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, filed 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, filed Jun. 11, 2004.
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.
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.

Affiliated with

Also associated with

Rating

System and method for dynamically creating keys 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 dynamically creating keys in a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for dynamically creating keys in a... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4232407