Abstract: Methods, computer program products, and systems are presented. The method computer program products, and systems can include, for instance: identifying an invoked database query for execution on a database, the invoked database query being associated to a user; generating an execution plan for executing the database query on the database; wherein the generating the execution plan for execution of the database query on the database includes establishing an ordering of first and second tables, the ordering of the first and second tables being in dependence on an access privilege attribute of the user in respect to the first table; and executing the database query according to the execution plan.

Abstract: The present disclosure relates to a method comprising incorporating a utilization level field for a set of materialized views of database system in a database catalog of the database system. A computer process may be generated to run during a defined time period on a spare host of the database system. The computer process is configured to monitor utilization of the set of materialized views and to collect data of utilized materialized views in a dedicated registry. A check if each materialized view of the set of materialized views is present in the registry may be periodically be performed. The utilization level of a materialized view may be adapted based on its collected data in the registry. A check in catalog utilization levels of the set of materialized views may periodically be performed and based on the utilization levels utilization of the set of materialized views may be adapted.

Abstract: The present disclosure relates to a method comprising incorporating a utilization level field for a set of materialized views of database system in a database catalog of the database system. A computer process may be generated to run during a defined time period on a spare host of the database system. The computer process is configured to monitor utilization of the set of materialized views and to collect data of utilized materialized views in a dedicated registry. A check if each materialized view of the set of materialized views is present in the registry may be periodically be performed. The utilization level of a materialized view may be adapted based on its collected data in the registry. A check in catalog utilization levels of the set of materialized views may periodically be performed and based on the utilization levels utilization of the set of materialized views may be adapted.

Abstract: A method and apparatus utilize idle processor time on spare host(s) in an SQL environment to select a query plan. The method comprises receiving a set of query plans for searching a database, and determining that at least one of the set of query plans was generated using heuristic techniques. One or more otherwise idle processors generate a plurality of alternative search plans. The plurality of alternative plans comprise all SQL-conforming search plans to a query with different join orders. Using the one or more otherwise idle processor(s) on one or more spare host(s) within the SQL environment, a resource cost is calculated for executing each alternative search plan within the plurality of alternate search plans. An optimal search plan is identified using the calculated resource costs, and is stored for use in a subsequent search. Such a query can reduce the resources needed to perform a search.

Abstract: The present disclosure relates to a method for extending kernel functionality of a kernel of a container-based virtualization system. The method comprises: providing in the container-based virtualization system a compiling container for compiling kernel modules against the kernel of the container-based virtualization system, and an application container for extending kernel functionality of the kernel using a kernel module. The application container may input the kernel module to the compiling container. The compiling container may compile the kernel module in the compiling container. The application container may receive from the compiling container the compiled kernel module. The application container may load the compiled kernel module to the kernel of the system for enabling the extension of the kernel functionality.

Abstract: In an approach for migrating database content with row-level security from a source database with row-level security to a target database without row-level security, a computer determines a type of the source database to be migrated, and upon determining that a source table of the source database is maintained using multi-level security attributes, creating a data structure for a source table of the source database for storing meta-data comprising the multi-level security attributes, determining all dimensions of the multi-level security attributes, adding columns to a target table of the target database relating to the source table, the added columns representing the multi-level security attributes of the source table.

Abstract: Methods, computer program products, and systems are presented. The method computer program products, and systems can include, for instance: identifying an invoked database query for execution on a database, the invoked database query being associated to a user; generating an execution plan for executing the database query on the database; wherein the generating the execution plan for execution of the database query on the database includes establishing an ordering of first and second tables, the ordering of the first and second tables being in dependence on an access privilege attribute of the user in respect to the first table; and executing the database query according to the execution plan.

Abstract: Methods, computer program products, and systems are presented. The method computer program products, and systems can include, for instance: examining an invoked database query for execution on a database; scanning zone data from at least one data node of the database in dependence on the examining, the at least one data node of the database having a storage system and storing in the storage system table data of a table, wherein security tags are associated to respective rows of the table, and wherein the zone data specifies attributes of storage of the table within respective storage system extents of the storage system; identifying, using the zone data, at least one excludible extent of the storage system extents; and excluding the at least one excludible extent from an IO data access operation in processing of the invoked database query.

Abstract: The present disclosure relates to a method for extending kernel functionality of a kernel of a container-based virtualization system. The method comprises: providing in the container-based virtualization system a compiling container for compiling kernel modules against the kernel of the container-based virtualization system, and an application container for extending kernel functionality of the kernel using a kernel module. The application container may input the kernel module to the compiling container. The compiling container may compile the kernel module in the compiling container. The application container may receive from the compiling container the compiled kernel module. The application container may load the compiled kernel module to the kernel of the system for enabling the extension of the kernel functionality.

Abstract: The present disclosure relates to a method using a database engine for migrating data records from a source database to a target database, where said data records are arranged in a sorted source table of the source database in accordance with a clustered-base-table order following the Hilbert-Filling-Curve algorithm. The method comprises configuring the database engine for storing the CBT order of each data record of the source table in a reference table to said source table or a in a column of said source table. A reading step may be performed to read said data records from said source table, wherein in said reading step said stored CBT order is used. The read data and the stored CBT order may be transferred to the target database in accordance with the stored CBT order. The transferred data may be written at the target database in accordance with the CBT order.

Abstract: A computer-implemented method for processing a query for accessing data in a database with row level security may be provided. The data is organized in rows and columns, and the rows are grouped in storage regions. The method comprises maintaining, as part of a control record for each storage region, a lower access security label, representing a minimal user access right of any of the rows in the storage region, and an upper access security label representing a maximal user access right of any of the rows in the storage region, and upon determining, for a query, whether an access right of a user initiating the query is below the lower access security label of a storage region addressed by the query, skipping the storage region during a read execution of the query.

Abstract: In an approach for migrating database content with row-level security from a source database with row-level security to a target database without row-level security, a computer determines a type of the source database to be migrated, and upon determining that a source table of the source database is maintained using multi-level security attributes, creating a data structure for a source table of the source database for storing meta-data comprising the multi-level security attributes, determining all dimensions of the multi-level security attributes, adding columns to a target table of the target database relating to the source table, the added columns representing the multi-level security attributes of the source table.

Abstract: The present disclosure relates to a method for recording user activity on a computer. The method includes creating a video file for a video sequence of a user interface of an application of the computer. Video frames may be recorded in the video file, wherein a video frame comprises data indicative of the visual representation of the user interface and corresponding timestamp, wherein the data of the video frame is parsable.

Abstract: The present disclosure relates to a method using a database engine for migrating data records from a source database to a target database, where said data records are arranged in a sorted source table of the source database in accordance with a clustered-base-table order following the Hilbert-Filling-Curve algorithm. The method comprises configuring the database engine for storing the CBT order of each data record of the source table in a reference table to said source table or a in a column of said source table. A reading step may be performed to read said data records from said source table, wherein in said reading step said stored CBT order is used. The read data and the stored CBT order may be transferred to the target database in accordance with the stored CBT order. The transferred data may be written at the target database in accordance with the CBT order.

Abstract: The present disclosure relates to a method for recording user activity on a computer. The method includes creating a video file for a video sequence of a user interface of an application of the computer. Video frames may be recorded in the video file, wherein a video frame comprises data indicative of the visual representation of the user interface and corresponding timestamp, wherein the data of the video frame is parsable.

Abstract: According to one aspect of the present disclosure, a method and technique for monitoring updates on multiple computing platforms is disclosed. The method includes: initiating an update to a plurality of computing platforms; analyzing tracking data corresponding to each of the plurality of computing platforms indicating an installation progress of the update; dynamically calculating a timeout period for an installation of the update based on the tracking data; and displaying the installation progress for each of the plurality of computing platforms relative to the timeout period.