Abstract: A system and method for multiple parameter based composite rule data validation includes receiving a request to validate target data of a target object based on constituent parameters, identifying the data type of the target data, suggesting validation rules based on the data type of the target object, generating a set of composite validation queries, identifying at least one composite validation query in the set of composite validation queries corresponding to the constituent parameters and values, validating the target data of the target object against the at least one composite validation query, and returning a validation result for the target data.

Abstract: A method for validating data in a hybrid cloud model that includes providing a validation layer in the brokerage module of the hybrid architecture. The validation layer is separate from an applications layer of the hybrid architecture. The method includes sending target object values to a centralized brokerage layer composite query generator (BLCQG) component of the validation layer from an application needing validation of target data time. The method continues with generating a composite validation rule set with the brokerage layer composite query generator (BLCQG) component based on the parameters of the target object values. The method further includes validating the target data item of the target object values with the composite validation rule in the validation rules validator (VRV) component; and sending the target data item that has been validated to the application.

Abstract: A method, a system and a computer program product for automated ASCII-based object-oriented database schema (OODBS) generation. A parser runs through text sentences of a textual document from a requirements gathering team that includes object-oriented application requirements, and identifies nouns corresponding to an object, and each noun's attributes. An Object-oriented dictionary based ASCII interpreter analyzes the ASCII of the captured requirements. For each identified noun, the system creates first key-value structures mapping each identified object to one or more associated attributes. There is further identified, from the created first key-value structures, any attributes that reference to an identified object, and for each of these identified objects, the system creates second key-value structures mapping, for each attribute identified as a reference, associating a corresponding key where the reference is found as an attribute.

Abstract: Relational database schema generation includes obtaining an input requirements specification for a relational database to be generated, interpreting text characters of the requirements specification as values of a predefined character encoding, parsing the interpreted text characters and identifying complete sentences of the requirements specification, identifying, using an input dictionary that specifies combinations of character values of the predefined character encoding, proper nouns in the identified complete sentences and common nouns in the identified complete sentences, and generating a relational database schema script for the relational database, the generating including indicating the identified proper nouns of the complete sentences as entities of the relational database and indicating the identified common nouns of the complete sentences as attributes of those entities.

Abstract: An approach is provided for delivering a configuration based workflow in an IT system. A set of parameters and pre-configured conditions associated with a command initiated for execution are determined. Validation action(s) that validate the command and are included in the configuration based workflow are determined. The validation action(s) are specified by respective interaction(s) with external system(s). Validation action(s) included in the configuration based workflow are performed by completing the interaction(s) with the external system(s) using the set of parameters. It is determined whether the validation action(s) are successfully completed. If the validation action(s) are successfully completed, the execution of the command is continued. If at least one of the validation action(s) is not successfully completed, the execution of the command is discontinued.

Abstract: Disclosed embodiments provide techniques for load balancing of computer jobs in a distributed computer network. A health score is determined for each node of the pool of nodes, which can include native applications, virtual machines, and/or containers. A future resource availability score is determined for each node of the pool of nodes corresponding with a predetermined future time. A schedule eligibility score is computed for each node based on the health score and future resource availability score. A new job is assigned to the node with the optimal schedule eligibility score. In this way, rather than only considering the current workload conditions of the node, a future resource availability score is computed for each node, and this score is used as a factor in the assigning of jobs to the node. This provides an opportunity for improved resource utilization and improved overall system reliability.

Abstract: Systems and methods for dynamic incremental updating of online analytical processing (OLAP) data cubes are disclosed. In embodiments, a computer-implemented method, comprises: receiving real-time transactional event data including a plurality of data fields; identifying aggregate computing functions for each of a plurality of standard query language (SQL) queries of a target data cube to be updated, wherein the target data cube is in a multidimensional form for storing OLAP data in the form of numeric values organized in fields; incrementally calculating the aggregate computing functions based on a current aggregated value obtained from an updated aggregated field database, and a value of one of the plurality of data fields; repeating the incremental calculation for each of the plurality of SQL queries to obtain updated field data for the target data cube; and updating the updated aggregated field database with the updated field data.

Abstract: A system and method for multiple parameter based composite rule data validation includes receiving a request to validate target data of a target object based on constituent parameters, identifying the data type of the target data, suggesting validation rules based on the data type of the target object, generating a set of composite validation queries, identifying at least one composite validation query in the set of composite validation queries corresponding to the constituent parameters and values, validating the target data of the target object against the at least one composite validation query, and returning a validation result for the target data.

Abstract: A method for validating data in a hybrid cloud model that includes providing a validation layer in the brokerage module of the hybrid architecture. The validation layer is separate from an applications layer of the hybrid architecture. The method includes sending target object values to a centralized brokerage layer composite query generator (BLCQG) component of the validation layer from an application needing validation of target data time. The method continues with generating a composite validation rule set with the brokerage layer composite query generator (BLCQG) component based on the parameters of the target object values. The method further includes validating the target data item of the target object values with the composite validation rule in the validation rules validator (VRV) component; and sending the target data item that has been validated to the application.

Abstract: A method, a system and a computer program product for automated ASCII-based object-oriented database schema (OODBS) generation. A parser runs through text sentences of a textual document from a requirements gathering team that includes object-oriented application requirements, and identifies nouns corresponding to an object, and each noun's attributes. An Object-oriented dictionary based ASCII interpreter analyzes the ASCII of the captured requirements. For each identified noun, the system creates first key-value structures mapping each identified object to one or more associated attributes. There is further identified, from the created first key-value structures, any attributes that reference to an identified object, and for each of these identified objects, the system creates second key-value structures mapping, for each attribute identified as a reference, associating a corresponding key where the reference is found as an attribute.

Abstract: Relational database schema generation includes obtaining an input requirements specification for a relational database to be generated, interpreting text characters of the requirements specification as values of a predefined character encoding, parsing the interpreted text characters and identifying complete sentences of the requirements specification, identifying, using an input dictionary that specifies combinations of character values of the predefined character encoding, proper nouns in the identified complete sentences and common nouns in the identified complete sentences, and generating a relational database schema script for the relational database, the generating including indicating the identified proper nouns of the complete sentences as entities of the relational database and indicating the identified common nouns of the complete sentences as attributes of those entities.

Abstract: Disclosed embodiments provide techniques for load balancing of computer jobs in a distributed computer network. A health score is determined for each node of the pool of nodes, which can include native applications, virtual machines, and/or containers. A future resource availability score is determined for each node of the pool of nodes corresponding with a predetermined future time. A schedule eligibility score is computed for each node based on the health score and future resource availability score. A new job is assigned to the node with the optimal schedule eligibility score. In this way, rather than only considering the current workload conditions of the node, a future resource availability score is computed for each node, and this score is used as a factor in the assigning of jobs to the node. This provides an opportunity for improved resource utilization and improved overall system reliability.

Abstract: Systems and methods for dynamic incremental updating of online analytical processing (OLAP) data cubes are disclosed. In embodiments, a computer-implemented method, comprises: receiving real-time transactional event data including a plurality of data fields; identifying aggregate computing functions for each of a plurality of standard query language (SQL) queries of a target data cube to be updated, wherein the target data cube is in a multidimensional form for storing OLAP data in the form of numeric values organized in fields; incrementally calculating the aggregate computing functions based on a current aggregated value obtained from an updated aggregated field database, and a value of one of the plurality of data fields; repeating the incremental calculation for each of the plurality of SQL queries to obtain updated field data for the target data cube; and updating the updated aggregated field database with the updated field data.

Abstract: An approach is provided for delivering a configuration based workflow in an IT system. A set of parameters and pre-configured conditions associated with a command initiated for execution are determined. Validation action(s) that validate the command and are included in the configuration based workflow are determined. The validation action(s) are specified by respective interaction(s) with external system(s). Validation action(s) included in the configuration based workflow are performed by completing the interaction(s) with the external system(s) using the set of parameters. It is determined whether the validation action(s) are successfully completed. If the validation action(s) are successfully completed, the execution of the command is continued. If at least one of the validation action(s) is not successfully completed, the execution of the command is discontinued.

Abstract: An approach is provided for delivering a configuration based workflow in an IT system. A command initiated for execution is identified as being included in a list of commands. A set of parameters and pre-configured conditions associated with the identified command are determined. Validation action(s) that validate the command and are included in the configuration based workflow are determined. The validation action(s) are specified by respective interaction(s) with external system(s). Validation action(s) included in the configuration based workflow are performed by completing the interaction(s) with the external system(s) using the set of parameters. It is determined whether the validation action(s) are successfully completed. If the validation action(s) are successfully completed, the execution of the command is continued. If at least one of the validation action(s) is not successfully completed, the execution of the command is discontinued.

Abstract: An approach is provided for delivering a configuration based workflow in an IT system. A command initiated for execution is identified as being included in a list of commands. A set of parameters and pre-configured conditions associated with the identified command are determined. Validation action(s) that validate the command and are included in the configuration based workflow are determined. The validation action(s) are specified by respective interaction(s) with external system(s). Validation action(s) included in the configuration based workflow are performed by completing the interaction(s) with the external system(s) using the set of parameters. It is determined whether the validation action(s) are successfully completed. If the validation action(s) are successfully completed, the execution of the command is continued. If at least one of the validation action(s) is not successfully completed, the execution of the command is discontinued.

Abstract: A method and associated systems for synchronizing a disaster-recovery system of a database. A processor identifies transactions that affect data blocks of a database and records each change in a vector form. For each block, the processor determines a more efficient way to communicate changes made to the block by a subset of the identified transactions. If fewer resources are needed to communicate an updated image of the entire changed block than would be needed to instead communicate a related set of change vectors that identify changes made to the block by the subset of transactions, then the processor communicates the updated image to the disaster-recovery system. Otherwise, the processor instead communicates the related change vectors to the disaster-recovery system. The processor repeats these determinations and communications for each block of the database that was changed by an identified transaction.

Abstract: A method and associated system for improving the operation of an optimizer module of a database-management system. A processor of a computer system captures and stores information about the database's recent transactions, where the captured information describes how each transaction altered the logical description of the database or revised data stored in the database. The processor uses this captured information to update stored metadata that identifies the database's logical structure, and to further update stored database statistics that describe characteristics of the data stored in the database. These updated statistics are then returned to the production database's optimizer module, which uses them to determine how to efficiently respond to database-access requests.

Abstract: A method and associated systems for synchronizing a disaster-recovery system of a database. A processor identifies transactions that affect data blocks of a database and records each change in a vector form. For each block, the processor determines a more efficient way to communicate changes made to the block by a subset of the identified transactions. If fewer resources are needed to communicate an updated image of the entire changed block than would be needed to instead communicate a related set of change vectors that identify changes made to the block by the subset of transactions, then the processor communicates the updated image to the disaster-recovery system. Otherwise, the processor instead communicates the related change vectors to the disaster-recovery system. The processor repeats these determinations and communications for each block of the database that was changed by an identified transaction.

Abstract: A method and associated systems for synchronizing a disaster-recovery system of a database. A processor identifies transactions that affect data blocks of a database and records each change in a vector form. For each block, the processor determines a more efficient way to communicate changes made to the block by a subset of the identified transactions. If fewer resources are needed to communicate an updated image of the entire changed block than would be needed to instead communicate a related set of change vectors that identify changes made to the block by the subset of transactions, then the processor communicates the updated image to the disaster-recovery system. Otherwise, the processor instead communicates the related change vectors to the disaster-recovery system. The processor repeats these determinations and communications for each block of the database that was changed by an identified transaction.