Query optimization via a partitioned environment

Details Query optimization via a partitioned environment Query optimization via a partitioned environment

2006-10-31

2006-10-31

Mizrahi, Diane D. (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

07130838

ABSTRACT:
Systems, methods, and articles of manufacture for improving the efficiency of executing a query are provided. Queries frequently issued in a primary processing environment (e.g., a primary logical partition) may be run in a background processing environment (e.g., a background logical partition) with different access plans to determine the access plan that results in the least execution time. For some embodiments, in an effort to avoid executing queries that may have an adverse system-wide impact, selected queries may be analyzed in the background processing environment prior to being executed. This analysis may be performed to ensure the execution time of the query will not exceed a specified threshold, and/or will not result in excessive contention when executed in the primary processing environment.

REFERENCES:
patent: 2003/0093442 (2003-05-01), Mogi et al.
patent: 2005/0187917 (2005-08-01), Lawande et al.

Affiliated with

Also associated with

Rating

Query optimization via a partitioned environment does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Query optimization via a partitioned environment, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Query optimization via a partitioned environment will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3638235