International Business Machines Corporation

Konrad K Skibski

Artur M Gruszecki

Tomasz Kazalski

Lukasz Gaza

Tomasz Stradomski

Michal Bodziony

Piotr Kania

Bartlomiej Tomasz Malecki

Grzegorz S Milka

Tomasz Hanusiak

Pawel Tadeusz Januszek

Michal Klak

Umit Bektas

Konrad Wojciech Komnata

Andreas Brodt

Michal S Paluch

Marek Grochowski

Tomasz Zaras

Arkadiusz W Biegun

Tomasz D Chmielecki

Natalya A Yanayt

A method, system and computer program product for providing early diagnosis of hardware, software or configuration problems in a data warehouse system. A received query is parsed to determine the properties of the query. The query may then be joined to existing groups of queries if those groups have shared properties of the query. After executing the query according to an execution plan, results from the execution of the query is received, which may include problem(s) that occurred during execution of the query. For those problems that reach a pre-defined threshold of becoming a 'group problem' in those groups joined by the query, the problem is reported to the end user concerning those groups where the problem exceeds the pre-defined threshold. In this manner, an early diagnosis of the problems in the data warehouse system that can cause delay and failure of the processing of queries is able to occur.

Early diagnosis of hardware, software or configuration problems in data warehouse system utilizing grouping of queries based on query parameters

A computer-implemented method for joining two data tables on a join attribute, where the data tables have at least a first and a second attribute and the second attribute is the join attribute. The method provides a function for associating a computing node to a given record. The function may be used to determine the associated computing node. The records of the two data tables may be distributed to the respective determined computing nodes. The relationship between the values of the first and second attributes may be modelled using a predefined dataset. For each record of the two data tables the values of the first attribute may be re-determined using the corresponding values of the second attribute. The function may be used to re-determine the associated computing node.

Joining two data tables on a join attribute

The invention relates to an NFC device configured for receiving a request to perform a transaction. In response to receiving the request, sensor data from one or more sensors of the NFC device is fed into a first classifier. The sensor data comprises environment parameters of the NFC device. The first classifier determines if sensor data provided as input to the first classifier were sensed in a transaction-typical environment or in a transaction-atypical environment. In case the first classifier determines that the sensor data is indicative of a transaction-atypical environment, the first classifier blocks the transaction or requests a user to confirm the transaction and blocks the transaction until the confirmation is received.

Blocking fraudulent transactions in an NFC device

An approach for optimizing single-row operations in a data warehouse. Single-row operations are determined based on receiving database operations. Extends identifiers are received based on the single-row operations. Single-row usage statistics are maintained for extends identifiers based on single-row operations. A logical sequence of the extends identifiers in extends lists stores are sorted based on single-row usage statistics and the logical sequence is maintained based on determining further single-row operations.

Data warehouse single-row operation optimization

The present disclosure relates to a computer-implemented method, computer program product, and computer system, for optimization of query processing a set of data extents on which a table is stored. Attribute value information may be maintained for each data extent. The attribute value information indicate as ranges the minimum and maximum values of an attribute of the entries stored in the respective extent. A first metric of a first data extent of the set may determine splitting the first data extent into sub-extents increases query processing efficiency. A second metric of a second data extent and a third data extent may determine merging the second data extent and the third data extent increases query processing efficiency.

Efficient processing of data extents

The invention relates to a method, computer program product and computer system for providing attribute value information for a data extent having a set of data entries. The method includes: determining a reference string value of a data-extent-specific reference point based on symbol frequencies at each sequence position of attribute string values in a subset of the set of data entries; calculating a distance between each of the attribute string values in the subset and the reference string value of the data-extent-specific reference point resulting in a set of distances; determining for each of the attribute string values an attribute-string-value-specific minimum distance for any reference string value of the data-extent-specific reference point resulting in a set of attribute-string-value-specific minimum distances for the set of data entries; storing for the data extent the minimum distance and the maximum distance of the set of attribute-string-value-specific minimum distances as attribute value information.

Attribute value information for a data extent

The invention relates to a computer-implemented method for processing a query in a database, the query comprising a search value. The database comprises a plurality of datasets the datasets comprising entries, wherein distance statistics are assigned to the datasets. The distance statistics describe the minimum and maximum distance between the values of the entries of a dataset of the plurality of datasets and a reference value. The method comprises determining the distance between the search value and the reference value, said determination resulting in a search distance, determining a subset of datasets from the plurality of datasets for which the search distance is within the limits given by the minimum and maximum distances described by the respective distance statistics, and searching for the search value in the subset of datasets.

Method for processing a database query

The invention relates to a method, computer program product and computer system for providing attribute value information for a data extent comprising a set of data entries. For each multidimensional reference point of a set of one or more multidimensional reference points the method comprises: calculating for each multidimensional data entry a reference-point-specific distance between the respective multidimensional data entry and the multidimensional reference point resulting in a set of reference-point-specific distances for the data extent, the respective reference-point-specific distance being calculated using a combination of the attribute values of the multidimensional data entry and a combination of the reference attribute values of the respective multidimensional reference point; determining a minimum reference-point-specific distance and a maximum reference-point-specific distance of the set of reference-point-specific distances; storing for the data extent as attribute value information for further use with query processing the minimum reference-point-specific distance and maximum reference-point-specific distance.

Providing multidimensional attribute value information

The present disclosure relates to a computer-implemented method for joining two data tables on a join attribute. The data tables have at least a first and a second attribute. The second attribute is the join attribute. The method includes providing a function for associating a computing node to a given record. The function may be used to determine the associated computing node. The records of the two data tables may be distributed to the respective determined computing nodes. The relationship between the values of the first and second attributes may be modelled using a predefined dataset. For each record of the two data tables the values of the first attribute may be re-determined using the corresponding values of the second attribute. The function may be used to re-determine the associated computing node.

An advanced method for a software discovery process may be provided. The method comprises receiving a product identifier comprising at least one mandatory software item and a related product priority. The method includes further determining a scan type for each mandatory software item of all product identifiers of all received related product priorities, performing a priority-based software discovery, using a next scan type for each of the at least one mandatory software items for each of the at least one product identifiers for each of the received product priorities, starting with a highest priority, requiring the next scan type, and repeating the previous step of performing the priority-based software discovery with a next scan type until all scan types for mandatory software have been executed.

Software discovery scan optimization based on product priorities

An approach for optimizing single-row operations in a data warehouse. Single-row operations are determined based on receiving database operations. Extends identifiers are received based on the single-row operations. Single-row usage statistics are stored in extends lists stores where single-row usage statistics include at least one of a hit count and a last hit date. Single-row usage statistics are maintained for extends identifiers based on single-row operations. A logical sequence of the extends identifiers in extends lists stores are sorted based on single-row usage statistics and the logical sequence is maintained based on determining a further single-row operations.

Embodiments of the present invention provide a method, computer program product, and a computer system for storing data records in extents. According to one embodiment a data record comprising an attribute value is received. One or more data records stored in a first extent, are identified, wherein the stored one or more data records in the first extent have at least one attribute value. The attribute value of the received data record is compared to the attribute values of the identified data records stored in the first extent. It is then determined whether to store the received data record in the first extent. Responsive to determining, not to store the received data record in the first extent, the received data record is stored in a second extent. If the first received data record is stored in a second extent, determining, an attribute value information of the second extent.

Storing data records

A method for collecting monitoring data on a set of monitored computers. The method comprises providing definitions for collection methods for a set of monitoring data, wherein the monitoring data is collected from agents running at monitoring computers, wherein each item of monitoring data has at least one respective collection method. The method further comprises determining a subset of monitoring data to be updated. The method further comprises identifying collection methods corresponding to the subset of monitoring data and triggering the agents running at the monitoring computers to collect monitoring data using the identified collection methods.

Growing community of inventors

Zielonki, Poland

Konrad K Skibski