G - Physics – 06 – F
Patent
G - Physics
06
F
G06F 17/30 (2006.01)
Patent
CA 2416368
Database Management Systems (DBMS) manage data stored in tables and process database queries against that stored data. The database queries typically specify search conditions (that is, 'predicates') for qualifying database search results to be output by the DBMS. When a database table definition or query includes a given predicate having an expression that operates on a column of a table, it is useful to know whether the expression is monotonic. If the expression is determined to be monotonic, the present invention provides operations for deriving a new predicate from the given predicate for use in a new database query. Advantageously, the use of a new or derived predicate improves operational efficiency of the DBMS. Operation is provided for detecting a type of monotonicity related to the expression, and uses the detected type of monotonicity for generating the derived predicate.
Koo Fred
Malkemus Timothy Ray
International Business Machines Corporation
Rosen Arnold
LandOfFree
Optimizing database query performance by deriving 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 Optimizing database query performance by deriving query..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Optimizing database query performance by deriving query... will most certainly appreciate the feedback.
Profile ID: LFCA-PAI-O-1919024