System for executing a database query

Details System for executing a database query System for executing a database query

2011-08-30

2011-08-30

Trujillo, James (Department: 2159)

Data processing: database and file management or data structures

Database and file access

Preparing data for information retrieval

C707S812000

Reexamination Certificate

active

08010533

ABSTRACT:
For a database management system installed in a data processing system, the database management system for managing a database having partitions for storing table data based on a partitioning schema, in which each partition has an associated partition identifier, and in which the database has database catalog information associated therewith, a method for executing a query against the database is disclosed. The method includes identifying a partition identifier in accordance with the partitioning schema, selecting the partition identifier based on the contents of the query and the database catalog information, and executing the query against the identified partition. The method improves the execution of queries while minimizing the consumption of network resources.

REFERENCES:
patent: 5546557 (1996-08-01), Allen et al.
patent: 5625815 (1997-04-01), Maier et al.
patent: 5659701 (1997-08-01), Amit et al.
patent: 5678042 (1997-10-01), Pisello et al.
patent: 5692129 (1997-11-01), Sonderegger et al.
patent: 5717919 (1998-02-01), Kodavalla et al.
patent: 5835755 (1998-11-01), Stellwagen, Jr.
patent: 5860070 (1999-01-01), Tow et al.
patent: 5870746 (1999-02-01), Knutson et al.
patent: 6012067 (2000-01-01), Sarkar
patent: 6078924 (2000-06-01), Ainsbury et al.
patent: 6105026 (2000-08-01), Kruglikov et al.
patent: 6157925 (2000-12-01), Jenkins et al.
patent: 6289334 (2001-09-01), Reiner et al.
patent: 6401098 (2002-06-01), Moulin
patent: 6732100 (2004-05-01), Brodersen et al.
patent: 6816853 (2004-11-01), Agarwal et al.
patent: 6931390 (2005-08-01), Zait et al.
patent: 6957225 (2005-10-01), Zait et al.
patent: 7103605 (2006-09-01), Hazi et al.
patent: 7475055 (2009-01-01), Hutchison et al.
patent: 2001/0032245 (2001-10-01), Fodor
patent: 2002/0029163 (2002-03-01), Joao
patent: 2002/0035559 (2002-03-01), Crowe et al.
patent: 2002/0048369 (2002-04-01), Ginter et al.
patent: 2002/0078058 (2002-06-01), Bird et al.
patent: 2002/0087510 (2002-07-01), Weinberg et al.
patent: 2002/0099818 (2002-07-01), Russell et al.
patent: 2002/0123978 (2002-09-01), Bird et al.
patent: 2003/0061330 (2003-03-01), Frisco et al.
patent: 2003/0115206 (2003-06-01), Gilbert
patent: 2003/0220901 (2003-11-01), Carr et al.
patent: 2003/0229529 (2003-12-01), Mui et al.
patent: 2003/0233347 (2003-12-01), Weinberg et al.
patent: 2004/0133640 (2004-07-01), Yeager et al.
patent: 2004/0205057 (2004-10-01), Hutchison et al.
patent: 2006/0122876 (2006-06-01), Von Schweber et al.
patent: 2008/0319967 (2008-12-01), Hutchison et al.
patent: 0163521 (2001-08-01), None

Affiliated with

Also associated with

Rating

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2698948