Abstract: A database-management system provides sargable evaluation for query predicates that compare an “LHS” encrypted database-column operand to an “RHS” expression operand. The system directly compares the two operands if all their attributes match. If the operands are encrypted string-type values differing only in length, the system truncates the RHS or pads it with encrypted blanks and, if a truncation loses meaningful data, evaluates the predicate as never satisfying an equality condition. In all other cases, if all attributes of a plaintext RHS don't match those of the plaintext data encoded into the LHS column, the system attempts to cast the RHS to match the plaintext LHS data. An error condition or data loss at this step allows the system to sargably evaluate the predicate without further analysis, but if the casting is successful and error-free, the system encrypts the resulting RHS and performs a sargable predicate evaluation.

Abstract: A database-management system provides sargable evaluation for query predicates that compare an “LHS” encrypted database-column operand to an “RHS” expression operand. The system directly compares the two operands if all their attributes match. If the operands are encrypted string-type values differing only in length, the system truncates the RHS or pads it with encrypted blanks and, if a truncation loses meaningful data, evaluates the predicate as never satisfying an equality condition. In all other cases, if all attributes of a plaintext RHS don't match those of the plaintext data encoded into the LHS column, the system attempts to cast the RHS to match the plaintext LHS data. An error condition or data loss at this step allows the system to sargably evaluate the predicate without further analysis, but if the casting is successful and error-free, the system encrypts the resulting RHS and performs a sargable predicate evaluation.

Abstract: A database-management system provides sargable evaluation for query predicates that compare an “LHS” encrypted database-column operand to an “RHS” expression operand. The system directly compares the two operands if all their attributes match. If the operands are encrypted string-type values differing only in length, the system truncates the RHS or pads it with encrypted blanks and, if a truncation loses meaningful data, evaluates the predicate as never satisfying an equality condition. In all other cases, if all attributes of a plaintext RHS don't match those of the plaintext data encoded into the LHS column, the system attempts to cast the RHS to match the plaintext LHS data. An error condition or data loss at this step allows the system to sargably evaluate the predicate without further analysis, but if the casting is successful and error-free, the system encrypts the resulting RHS and performs a sargable predicate evaluation.

Abstract: A business application may provide a secure ledger update while maintaining anonymity and security from unauthorized third parties. One example may include receiving a new entry transaction to save data in a database/ledger. The example may also include receiving a request to add a record stored in a database with a new entry, adding the record by inserting the new entry, and enabling the new entry to be unchangeable from subsequent modification attempts based on an immutable attribute.

Abstract: A database-management system provides sargable evaluation for query predicates that compare an “LHS” encrypted database-column operand to an “RHS” expression operand. The system directly compares the two operands if all their attributes match. If the operands are encrypted string-type values differing only in length, the system truncates the RHS or pads it with encrypted blanks and, if a truncation loses meaningful data, evaluates the predicate as never satisfying an equality condition. In all other cases, if all attributes of a plaintext RHS don't match those of the plaintext data encoded into the LHS column, the system attempts to cast the RHS to match the plaintext LHS data. An error condition or data loss at this step allows the system to sargably evaluate the predicate without further analysis, but if the casting is successful and error-free, the system encrypts the resulting RHS and performs a sargable predicate evaluation.

Abstract: A business application may provide a secure ledger update while maintaining anonymity and security from unauthorized third parties. One example may include receiving a new entry transaction to save data in a database/ledger. The example may also include receiving a request to add a record stored in a database with a new entry, adding the record by inserting the new entry, and enabling the new entry to be unchangeable from subsequent modification attempts based on an immutable attribute.

Abstract: A business application may provide a secure ledger update while maintaining anonymity and security from unauthorized third parties. One example may include receiving a new entry transaction to save data in a database/ledger. The example may also include receiving a request to add a record stored in a database with a new entry, adding the record by inserting the new entry, and enabling the new entry to be unchangeable from subsequent modification attempts based on an immutable attribute.

Abstract: As disclosed herein a method, executed by a computer, for enabling multi-tiered software stack diagnostic collection includes initiating, on a first tier of a multi-tiered software stack, a targeted diagnostics collection corresponding to a symptom of a failure, determining a symptom to a reason code mapping corresponding to the symptom in a product of a subsequent tier, and issuing a command to the product of the subsequent tier to initiate targeted diagnostics collection corresponding to the reason code. Problems or failures in a multi-tiered software stack environment may require analyses of programs or products corresponding to each tier of a multi-tiered software stack. The method described herein enables simultaneous collection of diagnostics for programs or products corresponding to each tier of a multi-tiered software stack. A computer system, and a computer program product corresponding to the method are also disclosed herein.

Abstract: As disclosed herein a method, executed by a computer, for enabling multi-tiered software stack diagnostic collection includes initiating, on a first tier of a multi-tiered software stack, a targeted diagnostics collection corresponding to a symptom of a failure, determining a symptom to a reason code mapping corresponding to the symptom in a product of a subsequent tier, and issuing a command to the product of the subsequent tier to initiate targeted diagnostics collection corresponding to the reason code. Problems or failures in a multi-tiered software stack environment may require analyses of programs or products corresponding to each tier of a multi-tiered software stack. The method described herein enables simultaneous collection of diagnostics for programs or products corresponding to each tier of a multi-tiered software stack. A computer system, and a computer program product corresponding to the method are also disclosed herein.

Abstract: A business application may provide a secure ledger update while maintaining anonymity and security from unauthorized third parties. One example may include receiving a new entry transaction to save data in a database/ledger. The example may also include receiving a request to add a record stored in a database with a new entry, adding the record by inserting the new entry, and enabling the new entry to be unchangeable from subsequent modification attempts based on an immutable attribute.

Abstract: As disclosed herein a method, executed by a computer, for enabling multi-tiered software stack diagnostic collection includes initiating, on a first tier of a multi-tiered software stack, a targeted diagnostics collection corresponding to a symptom of a failure, determining a symptom to a reason code mapping corresponding to the symptom in a product of a subsequent tier, and issuing a command to the product of the subsequent tier to initiate targeted diagnostics collection corresponding to the reason code. Problems or failures in a multi-tiered software stack environment may require analyses of programs or products corresponding to each tier of a multi-tiered software stack. The method described herein enables simultaneous collection of diagnostics for programs or products corresponding to each tier of a multi-tiered software stack. A computer system, and a computer program product corresponding to the method are also disclosed herein.

Abstract: As disclosed herein a method, executed by a computer, for enabling multi-tiered software stack diagnostic collection includes initiating, on a first tier of a multi-tiered software stack, a targeted diagnostics collection corresponding to a symptom of a failure, determining a symptom to a reason code mapping corresponding to the symptom in a product of a subsequent tier, and issuing a command to the product of the subsequent tier to initiate targeted diagnostics collection corresponding to the reason code. Problems or failures in a multi-tiered software stack environment may require analyses of programs or products corresponding to each tier of a multi-tiered software stack. The method described herein enables simultaneous collection of diagnostics for programs or products corresponding to each tier of a multi-tiered software stack. A computer system, and a computer program product corresponding to the method are also disclosed herein.

Abstract: Continuously blocking query result data for a remote query is provided. Included is: creating a first connection, using a communications network, between a database server and a client. At least one secondary connection is created, using the communications network, between the database server and the client, based on the database server supporting a continuous block fetch protocol. Using the at least one secondary connection, the database server receives at least one cursor-based fetch query. The database server generates continuous blocks of result data, based on the received at least one cursor-based fetch query and sends to the client, using the at least one secondary connection, the continuous blocks of result data.

Abstract: Continuously blocking query result data for a remote query is provided. Included is: creating a first connection, using a communications network, between a database server and a client. At least one secondary connection is created, using the communications network, between the database server and the client, based on the database server supporting a continuous block fetch protocol. Using the at least one secondary connection, the database server receives at least one cursor-based fetch query. The database server generates continuous blocks of result data, based on the received at least one cursor-based fetch query and sends to the client, using the at least one secondary connection, the continuous blocks of result data.

Abstract: As disclosed herein a method, executed by a computer, for enabling multi-tiered software stack diagnostic collection includes initiating, on a first tier of a multi-tiered software stack, a targeted diagnostics collection corresponding to a symptom of a failure, determining a symptom to a reason code mapping corresponding to the symptom in a product of a subsequent tier, and issuing a command to the product of the subsequent tier to initiate targeted diagnostics collection corresponding to the reason code. Problems or failures in a multi-tiered software stack environment may require analyses of programs or products corresponding to each tier of a multi-tiered software stack. The method described herein enables simultaneous collection of diagnostics for programs or products corresponding to each tier of a multi-tiered software stack. A computer system, and a computer program product corresponding to the method are also disclosed herein.

Abstract: As disclosed herein a method, executed by a computer, for enabling multi-tiered software stack diagnostic collection includes initiating, on a first tier of a multi-tiered software stack, a targeted diagnostics collection corresponding to a symptom of a failure, determining a symptom to a reason code mapping corresponding to the symptom in a product of a subsequent tier, and issuing a command to the product of the subsequent tier to initiate targeted diagnostics collection corresponding to the reason code. Problems or failures in a multi-tiered software stack environment may require analyses of programs or products corresponding to each tier of a multi-tiered software stack. The method described herein enables simultaneous collection of diagnostics for programs or products corresponding to each tier of a multi-tiered software stack. A computer system, and a computer program product corresponding to the method are also disclosed herein.

Abstract: Continuously blocking query result data for a remote query is provided. Included is: creating a first connection, using a communications network, between a database server and a client. At least one secondary connection is created, using the communications network, between the database server and the client, based on the database server supporting a continuous block fetch protocol. Using the at least one secondary connection, the database server receives at least one cursor-based fetch query. The database server generates continuous blocks of result data, based on the received at least one cursor-based fetch query and sends to the client, using the at least one secondary connection, the continuous blocks of result data.

Abstract: A method for temporal tracking of data changes in a database management system is provided. The method may include receiving a plurality of modified data change tracking parameters associated with the database management system, whereby the plurality of modified data change tracking parameters are received through a user interface. The method may also include applying the modified plurality of data change tracking parameters to the database management system. The method may further include tracking the data changes based on the plurality of modified change tracking parameters, whereby the tracking is performed automatically.

Abstract: Continuously blocking query result data for a remote query is provided. Included is: creating a first connection, using a communications network, between a database server and a client. At least one secondary connection is created, using the communications network, between the database server and the client, based on the database server supporting a continuous block fetch protocol. Using the at least one secondary connection, the database server receives at least one cursor-based fetch query. The database server generates continuous blocks of result data, based on the received at least one cursor-based fetch query and sends to the client, using the at least one secondary connection, the continuous blocks of result data.

Abstract: Operating a parallel database server system, where the database server system comprises at least two database servers and one data source. A client identifier is received from a client requesting services from one of said database servers. Information associated with said client is retrieved. The client is allocated to one of said database servers based on the retrieved information.