Abstract: A method for executing a computational task in a data management system is provided. The method includes storing a first stored procedure in a first database management system (DBMS) including first data containers. The first stored procedure receives names of one or more of the first data containers to act as input or output data containers and includes first statements for triggering resolution of features of a respective first input or output data container. The method also includes storing a second stored procedure in a second DBMS including second data containers. The second stored procedure implements the computational task and operates on one or more of the second data containers. The method also includes receiving, by the first DBMS, a request from a client application to perform the computational task.

Abstract: Securing invocation of stored procedures is provided herein. A first database management system (DBMS) can include a first database with first tables, a first user management module configured to manage privileges of database users (DB-users) of the first DBMS, and at least one first stored procedure. A second DBMS can include a second database with second tables, a second user management module configured to manage privileges of DB-users of the second DBMS, and at least one second stored procedure, the at least one second stored procedure configured to perform a computational task in the second DBMS. A synchronization mapping can map at least a portion of the first tables to respective ones of the second tables. Thus, a transfer of data of at least some of the first tables to the respective ones of the second tables in accordance with the synchronization-mapping can be performed.

Abstract: A method includes storing a first stored procedure in a first database management module and a second stored procedure in a second database management module, receiving by the first database management module a request to run a computational task with the first stored procedure, receiving a request to perform the computational task and in response thereto causing a first query optimizer in the first database management module to automatically compute a query execution plan for the first stored procedure, using the query execution plan to identify all first data containers on the first database management module that provide input data for the requested computational task, identifying a list of names of all second data containers mapped to the identified first data containers, and performing the second stored procedure using the list of names. A corresponding computer program product and data management system are also disclosed herein.

Abstract: A method includes storing a first stored procedure in a first database management module and a second stored procedure in a second database management module, receiving by the first database management module a request to run a computational task with the first stored procedure, receiving a request to perform the computational task and in response thereto causing a first query optimizer in the first database management module to automatically compute a query execution plan for the first stored procedure, using the query execution plan to identify all first data containers on the first database management module that provide input data for the requested computational task, identifying a list of names of all second data containers mapped to the identified first data containers, and performing the second stored procedure using the list of names. A corresponding computer program product and data management system are also disclosed herein.

Abstract: A distributed database system (or federated database system) where a catalogue is used to store metadata descriptive of data containers for the constituent database system(s) and/or accelerator system(s) of the federated database. In response to the generation of the trigger signal corresponding to a database definition language (DDL) statement, the accelerator system updates metadata in the catalogue.

Abstract: A distributed database system (or federated database system) comprises a constituent database management system (DMBS), an accelerator system and a single interface. The accelerator system creates a data container in accordance with structural features identified by the accelerator system and stores data in the data container. The constituent database system supplements incomplete metadata associated with the data container to create complete metadata descriptive of the namespace and structure of the data container created by the accelerator system.

Abstract: A method for merging transactions for execution by a database management system. The method includes a computer processor receiving a database query that is comprised of a plurality of transactions. The method further includes a computer processor placing each of the plurality of transactions, of the database query, in respective chronological order, in a scheduling queue. The method further includes a computer processor determining that at least a first transaction and a second transaction within the plurality of transactions each contains one or more transaction delineation descriptions. The method further includes computer processor responding to the determination that the first transaction and the second transaction, within the plurality of transactions, each contains one or more transaction delineation descriptions, and merging the first transaction and the second transaction to create a merged transaction combination and merging also includes combining two or more table-scan operations.

Abstract: A method for merging transactions for execution by a database management system. The method includes a computer processor receiving a database query that is comprised of a plurality of transactions. The method further includes a computer processor placing each of the plurality of transactions, of the database query, in respective chronological order, in a scheduling queue. The method further includes a computer processor determining that at least a first transaction and a second transaction within the plurality of transactions each contains one or more transaction delineation descriptions. The method further includes computer processor responding to the determination that the first transaction and the second transaction, within the plurality of transactions, each contains one or more transaction delineation descriptions, and merging the first transaction and the second transaction to create a merged transaction combination and merging also includes combining two or more table-scan operations.

Abstract: A computer implemented method is provided for processing data representing a data entity having sub entities. The method includes analyzing queries to the data entity for deriving information about sets of the sub entities frequently queried together, and grouping the sub entities to a number of banks, each bank having a maximum width, based on the information about sets of sub entities frequently queried together, in order to reduce an average number of banks to be accessed for data retrieval.

Abstract: A method of incorporating the influence of diffusion into the CPMG-based T2 measurement for one or more of the following: water cut measurement; performing inline measurements of flow rate; density; and rheology of a flowing fluid. The method includes conducting a “standard T1/T2 experiment” at least twice by providing one scan without a field gradient during the CMPG echo train. Then, providing a second scan with the application of a gradient, where in the second experiment the measured T2 (T2app) is affected solely by water diffusion, thus shifting cross peaks which represent water on the first T1/T2 spectrum to lower T2 values on the second spectrum.

Abstract: A computer implemented method is provided for processing data representing a data entity having sub entities. The method includes analyzing queries to the data entity for deriving information about sets of the sub entities frequently queried together, and grouping the sub entities to a number of banks, each bank having a maximum width, based on the information about sets of sub entities frequently queried together, in order to reduce an average number of banks to be accessed for data retrieval.

Abstract: A method for processing data contained in tables in a relational database includes joining a first table and a second table into a joined table determining metadata for at least one column of a table of the following tables: the first table, the second table, and the joined table. The metadata is used for processing data in the at least one column of the table, and for processing data in at least one column of at least one other table of the following tables: the first table, the second table, and the joined table.

Abstract: A method for generating occurrence data of data values for enabling encoding of a data set includes determining occurrences of data values in a first data batch and determining occurrence count information for a first number of most frequent data values in the first data batch, the occurrence count information identifying the most frequent data values and their occurrence counts. The method also includes generating for rest of the data values in the first data batch at least a first histogram having a second number of buckets and merging the occurrence count information of the first data batch with occurrence count information of a second data batch. The method further includes merging the first histogram of the first data batch to a merged histogram corresponding to the second data batch and processing a next data batch as a first data batch until the data set to be encoded is processed.

Abstract: According to one embodiment of the present invention, a method for dictionary encoding data without using three-valued logic is provided. According to one embodiment of the invention, a method includes encoding data in a database table using a dictionary, wherein the data includes values representing NULLs. A query having a predicate is received and the predicate is evaluated on the encoded data, whereby the predicate is evaluated on both the encoded data and on the encoded NULLs.

Abstract: A method for generating occurrence data of data values for enabling encoding of a data set includes determining occurrences of data values in a first data batch and determining occurrence count information for a first number of most frequent data values in the first data batch, the occurrence count information identifying the most frequent data values and their occurrence counts. The method also includes generating for rest of the data values in the first data batch at least a first histogram having a second number of buckets and merging the occurrence count information of the first data batch with occurrence count information of a second data batch. The method further includes merging the first histogram of the first data batch to a merged histogram corresponding to the second data batch and processing a next data batch as a first data batch until the data set to be encoded is processed.

Abstract: According to one embodiment of the present invention, a method for the parallel computation of frequency histograms in joined tables is provided. The method includes reading data in a table row-by-row from a database system using a coordinator unit and distributing each read row to separate worker units. Each worker unit computes a partial frequency histogram for each column in the table in parallel. The partial histograms from the worker units are then merged and the coordinator unit sends the merged frequency histograms to the worker units.

Abstract: According to one embodiment of the present invention, a method for dictionary encoding data without using three-valued logic is provided. According to one embodiment of the invention, a method includes encoding data in a database table using a dictionary, wherein the data includes values representing NULLs. A query having a predicate is received and the predicate is evaluated on the encoded data, whereby the predicate is evaluated on both the encoded data and on the encoded NULLs.

Abstract: According to one embodiment of the present invention, a method for dictionary encoding data without using three-valued logic is provided. According to one embodiment of the invention, a method includes encoding data in a database table using a dictionary, wherein the data includes values representing NULLs. A query having a predicate is received and the predicate is evaluated on the encoded data, whereby the predicate is evaluated on both the encoded data and on the encoded NULLs.

Abstract: A medium and system for managing an external routine in a computer implemented database management system includes creating a first table for storing external routines in a data store coupled to the database management system. An external routine is stored in the first table so that the database management system is allowed to automatically manage any modification related to the external routine and to control access to the external routine such that administrative support is minimized.

Abstract: A method for managing an external routine in a computer implemented database management system includes creating a first table for storing external routines in a data store coupled to the database management system. An external routine is stored in the first table so that the database management system is allowed to automatically manage any modification related to the external routine and to control access to the external routine such that administrative support is minimized.