International Business Machines Corporation
DYNAMICALLY DEPLOYING EXECUTION NODES USING SYSTEM THROUGHPUT

Abstract:

A method, system, and computer program product for using logical segments to help manage database tasks and performance for SQL parallelism. The method may include identifying a database object within a database resource of a database. The method may further include determining a database access method for the database object. The method may further include dividing data within the database object into a plurality of logical segments based on the database access method. The method may further include receiving a query for the database. The method may further include identifying the database object that corresponds to the query. The method may further include analyzing the logical segments of the database object. The method may further include distributing access to the database resource based on the logical segments of the database object.