Abstract: One or more processors provide selective and piecemeal data loading and utilization. One or more processors prioritize, for loading, a data of a first data type and a data of a second data type. One or more processors generate a partially loaded data table by partially loading the data of the first data type and the data of the second data type into a table within a relational database. One or more processors utilize the partially loaded data table to execute a plurality of computing tasks.

Abstract: Upgrading a database while the database is accessible to applications. Specifically, the database upgrade is performed selectively as per demand from system catalog tables. With this on-demand technique, the upgrade of a database is run on a need basis to upgrade, over time, all the catalog objects.

Abstract: A method for updating a plurality of database statistics during a query execution is provided. The method may include receiving a compiled query. The method may also include determining if the received compiled query requires at least one table scan operation on a full table to resolve the received compiled query. The method may further include determining if a plurality of table statistics associated with the full table has not been updated within a pre-defined time-period, whereby the determining is based on the determination that the received compiled query requires at least one table scan operation on the full table to resolve the received compiled query. The method may additionally include collecting a plurality of statistics associated with the full table based on the determination that the plurality of table statistics associated with the full table has not been updated within the pre-defined time-period.

Abstract: One or more processors provide selective and piecemeal data loading and utilization. One or more processors prioritize, for loading, a data of a first data type and a data of a second data type. One or more processors generate a partially loaded data table by partially loading the data of the first data type and the data of the second data type into a table within a relational database. One or more processors utilize the partially loaded data table to execute a plurality of computing tasks.

Abstract: One or more processors determine a level of data usage for two or more types of data to be loaded in a relational database. One or more processors prioritize data of the two or more types for loading. One or more processors load data of the two or more types in an order based, at least in part, on the level of data usage for the two or more types of data. One or more processors load data of the two or more types into a table within the relational database, the data being loaded in two or more portions and at times based, at least in part, on an availability of computer resources.

Abstract: One or more processors determine a level of data usage for two or more types of data to be loaded in a relational database. One or more processors prioritize data of the two or more types for loading. One or more processors load data of the two or more types in an order based, at least in part, on the level of data usage for the two or more types of data. One or more processors load data of the two or more types into a table within the relational database, the data being loaded in two or more portions and at times based, at least in part, on an availability of computer resources.

Abstract: One or more processors determine a level of data usage for two or more types of data to be loaded in a relational database. One or more processors prioritize data of the two or more types for loading. One or more processors load data of the two or more types in an order based, at least in part, on the level of data usage for the two or more types of data. One or more processors load data of the two or more types into a table within the relational database, the data being loaded in two or more portions and at times based, at least in part, on an availability of computer resources.

Abstract: Upgrading a database while the database is accessible to applications. Specifically, the database upgrade is performed selectively as per demand from system catalog tables. With this on-demand technique, the upgrade of a database is run on a need basis to upgrade, over time, all the catalog objects.

Abstract: One or more processors determine a level of data usage for two or more types of data to be loaded in a database. One or more processors prioritize data of the two or more types for loading. Data of a first data type has a higher priority for loading than data of a second data type when the first data type has a higher level of data usage than the second data type. One or more processors load data of the two or more types in an order based, at least in part, on the level of data usage for the two or more types of data.

Abstract: A method includes receiving a database query, analyzing system and session level variables to provide one or more identified variables, wherein each of the one or more identified variables corresponds to a system level variable or session level variable, determining if an optimizer changes setting is enabled, wherein the optimizer changes setting dictates whether or not existing variable values will be adjusted, identifying a selected value corresponding to each identified variable according to a cost analysis responsive to determining the optimizer changes setting is enabled, setting each identified variable to the corresponding selected value, and executing the received database query according to the one or more identified values. A computer program product and computer system corresponding to the method are also disclosed.

Abstract: A method includes receiving a database query, analyzing system and session level variables to provide one or more identified variables, wherein each of the one or more identified variables corresponds to a system level variable or session level variable, determining if an optimizer changes setting is enabled, wherein the optimizer changes setting dictates whether or not existing variable values will be adjusted, identifying a selected value corresponding to each identified variable according to a cost analysis responsive to determining the optimizer changes setting is enabled, setting each identified variable to the corresponding selected value, and executing the received database query according to the one or more identified values. A computer program product and computer system corresponding to the method are also disclosed.

Abstract: A method includes receiving a database query, analyzing system and session level variables to provide one or more identified variables, wherein each of the one or more identified variables corresponds to a system level variable or session level variable, determining if an optimizer changes setting is enabled, wherein the optimizer changes setting dictates whether or not existing variable values will be adjusted, identifying a selected value corresponding to each identified variable according to a cost analysis responsive to determining the optimizer changes setting is enabled, setting each identified variable to the corresponding selected value, and executing the received database query according to the one or more identified values. A computer program product and computer system corresponding to the method are also disclosed.

Abstract: Upgrading a database while the database is accessible to applications. Specifically, the database upgrade is performed selectively as per demand from system catalog tables. With this on-demand technique, the upgrade of a database is run on a need basis to upgrade, over time, all the catalog objects.

Abstract: Upgrading a database while the database is accessible to applications. Specifically, the database upgrade is performed selectively as per demand from system catalog tables. With this on-demand technique, the upgrade of a database is run on a need basis to upgrade, over time, all the catalog objects.

Abstract: A method and system for generating feedback for query execution is presented. The method and system includes receiving an instruction, using a computer, to perform a query from a user; performing the query instruction by accessing the database on a network; and determining a network traffic of the network in response to the query instruction performance timing out. The method and system also includes calculating a time and cost needed to complete the query instruction, in response to the query instruction performance timing out and presenting the calculated data to a user with an option to complete the timed out query. The method and system includes requesting and receiving a grace time to complete the query from the user in response to the user accepting the option to complete the query. The query is performed based on the grace time.

Abstract: One or more processors determine a level of data usage for two or more types of data to be loaded in a relational database. One or more processors prioritize data of the two or more types for loading. One or more processors load data of the two or more types in an order based, at least in part, on the level of data usage for the two or more types of data. One or more processors load data of the two or more types into a table within the relational database, the data being loaded in two or more portions and at times based, at least in part, on an availability of computer resources.

Abstract: One or more processors determine a level of data usage for two or more types of data to be loaded in a database. One or more processors prioritize data of the two or more types for loading. Data of a first data type has a higher priority for loading than data of a second data type when the first data type has a higher level of data usage than the second data type. One or more processors load data of the two or more types in an order based, at least in part, on the level of data usage for the two or more types of data.

Abstract: A method for updating a plurality of database statistics during a query execution is provided. The method may include receiving a compiled query. The method may also include determining if the received compiled query requires at least one table scan operation on a full table to resolve the received compiled query. The method may further include determining if a plurality of table statistics associated with the full table has not been updated within a pre-defined time-period, whereby the determining is based on the determination that the received compiled query requires at least one table scan operation on the full table to resolve the received compiled query. The method may additionally include collecting a plurality of statistics associated with the full table based on the determination that the plurality of table statistics associated with the full table has not been updated within the pre-defined time-period.

Abstract: A method for determining and providing aggregate functions is provided. The method may include scanning database tables. The method may further include determining the aggregate functions. Additionally, the method may include storing the determined aggregate functions on system catalog tables. The method may also include providing indications that the stored determined aggregate functions are valid. The method may further include receiving database queries. The method may also include, determining whether the stored determined aggregate functions are valid. The method may further include, in response to the stored determined aggregate functions being valid, retrieving the stored determined aggregate functions from the system catalog tables. The method may also include, in response to the stored determined aggregate functions being invalid, re-scanning the database tables. The method may further include determining the aggregate functions based on the re-scanned database tables.