Abstract: Disclosed herein are system, method, and computer program product embodiments for detecting erroneous data. In an embodiment, a data monitoring system may store an initial dataset. The data monitoring system may analyze the initial dataset to generate rules associated with the initial dataset. The data monitoring system may receive a new data entry from a client device intended to be associated with the initial dataset. The data monitoring system may compare the new data entry to the previously determined rules to determine if the new data entry complies. If so, the data monitoring system may store the new data entry. If not, the data monitoring system may generate an alert, requesting a confirmation that the noncompliant data entry is correct. If the noncompliant data is confirmed as correct, the data monitoring system may store the new data entry and update the rules associated with the updated dataset.

Abstract: Embodiments perform configuration checking between data types of table fields, in order to determine mismatches therebetween. A configuration check request including a parameter identifying a system is received. A first data type is retrieved based upon the parameter. The first data type is compared with a second, different retrieved data type to determine a mismatch. In some embodiments the first data type and the second data type may be retrieved from different systems, with the mismatch revealing inter-system inconsistency. According to certain embodiments, the first data type and the second data type may be retrieved from a same system, with the mismatch revealing intra-system inconsistency. A configuration check report is generated from the mismatch and communicated to a user, for use in proactively correcting inconsistency. Embodiments may also retrieve values of the data types, as part of value help functionality.

Abstract: Universal, automatic file conversion may be provided by a universal file conversion system or application. An input file may be received by the universal file conversion system. An input file type for the input file and a recipient of the input file may be determined. Programs available to the recipient for accessing a file may be determined. A target file type accessible to the recipient may be determined for converting the input file. A sequence of file conversions to convert the input file to the target file type may be determined. The input file may be converted to the target file type based on the sequence of file conversions. The converted file may be provided to the recipient. The recipient may return the converted file, and the converted file may be automatically converted back to the original input file type and provided to the original source of the input file.

Abstract: A global dictionary is described that corresponds to a database or table stored across multiple partitions. The global dictionary can be used to identify which partitions of the database contain records that are relevant to a user's query on the database. The global dictionary is made up of variable tables. Each variable table corresponds to a column of the database. A given variable table includes value tables where each value table corresponds to a defined value that has been assigned to a record in the database. A value table can include a list of partitions that contain a record having the related defined value.

Abstract: A global dictionary is described that corresponds to a database or table stored across multiple partitions. The global dictionary can be used to identify which partitions of the database contain records that are relevant to a user's query on the database. The global dictionary is made up of variable tables. Each variable table corresponds to a column of the database. A given variable table includes value tables where each value table corresponds to a defined value that has been assigned to a record in the database. A value table can include a list of partitions that contain a record having the related defined value.

Abstract: Universal, automatic file conversion may be provided by a universal file conversion system or application. An input file may be received by the universal file conversion system. An input file type for the input file and a recipient of the input file may be determined. Programs available to the recipient for accessing a file may be determined. A target file type accessible to the recipient may be determined for converting the input file. A sequence of file conversions to convert the input file to the target file type may be determined. The input file may be converted to the target file type based on the sequence of file conversions. The converted file may be provided to the recipient. The recipient may return the converted file, and the converted file may be automatically converted back to the original input file type and provided to the original source of the input file.

Abstract: Technologies are provided for capturing information during a data migration and to use the captured information to generate data migration artefacts that can be used in subsequent data migrations. Artificial intelligence techniques can be used to analyze the captured data migration information and to generate a data migration model that can be used to create the data migration artefacts. Changes made to the data migration artefacts can be tracked and used to train the data migration model. Additionally or alternatively, during execution of the subsequent data migration, additional data migration information can be captured and used to train the data migration model. The captured data migration activity can include data access operations such as data transactions, system log activity, and/or source code for one or more data migration programs and/or scripts. Computer system version information can be detected and different migration artefacts can be created for different computer system versions.

Abstract: Provided are devices and methods for repairing corrupt data using a secure environment in a productive system. In one example, the method includes receiving a request to modify a base table stored in a productive environment, generating a child table corresponding to the base table within a secure environment of the productive system, modifying the one or more table entries from the base table and storing the modified table entries in the child table, executing one or more operations on the child table within the secure environment to determine if the one or more modified table entries repair the base table, and outputting a determined result of the one or more operations to a user interface. As a result, corrupt data can be modified locally via inheriting tables within a secured environment without any further damage being done to productive data in a productive environment.

Abstract: Provided are systems and methods for programming language independent application development via test data stored in a database. In one example, the method includes receiving a database command from an application, the database command including a location and an access request for data at the location, determining if the application is operating in a test mode, and accessing data from a database based on the database command, wherein the accessing data comprises accessing test data stored in a test data storage based on the location included in the database command if the application is operating in the test mode, and accessing real data stored in a real data storage based on the location included in the database command if the application is not operating in test mode.

Abstract: A global dictionary is described that corresponds to a database or table stored across multiple partitions. The global dictionary can be used to identify which partitions of the database contain records that are relevant to a user's query on the database. The global dictionary is made up of variable tables. Each variable table corresponds to a column of the database. A given variable table includes value tables where each value table corresponds to a defined value that has been assigned to a record in the database. A value table can include a list of partitions that contain a record having the related defined value.

Abstract: A global dictionary is described that corresponds to a database or table stored across multiple partitions. The global dictionary can be used to identify which partitions of the database contain records that are relevant to a user's query on the database. The global dictionary is made up of variable tables. Each variable table corresponds to a column of the database. A given variable table includes value tables where each value table corresponds to a defined value that has been assigned to a record in the database. A value table can include a list of partitions that contain a record having the related defined value.

Abstract: A global dictionary is described that corresponds to a database or table stored across multiple partitions. The global dictionary can be used to identify which partitions of the database contain records that are relevant to a user's query on the database. The global dictionary is made up of variable tables. Each variable table corresponds to a column of the database. A given variable table includes value tables where each value table corresponds to a defined value that has been assigned to a record in the database. A value table can include a list of partitions that contain a record having the related defined value.

Abstract: Universal, automatic file conversion may be provided by a universal file conversion system or application. An input file may be received by the universal file conversion system. An input file type for the input file and a recipient of the input file may be determined. Programs available to the recipient for accessing a file may be determined. A target file type accessible to the recipient may be determined for converting the input file. A sequence of file conversions to convert the input file to the target file type may be determined. The input file may be converted to the target file type based on the sequence of file conversions. The converted file may be provided to the recipient. The recipient may return the converted file, and the converted file may be automatically converted back to the original input file type and provided to the original source of the input file.

Abstract: Provided are devices and methods for repairing corrupt data using a secure environment in a productive system. In one example, the method includes receiving a request to modify a base table stored in a productive environment, generating a child table corresponding to the base table within a secure environment of the productive system, modifying the one or more table entries from the base table and storing the modified table entries in the child table, executing one or more operations on the child table within the secure environment to determine if the one or more modified table entries repair the base table, and outputting a determined result of the one or more operations to a user interface. As a result, corrupt data can be modified locally via inheriting tables within a secured environment without any further damage being done to productive data in a productive environment.

Abstract: Provided are devices and methods for repairing corrupt data using a secure environment in a productive system. In one example, the method includes receiving a request to modify a base table stored in a productive environment, generating a child table corresponding to the base table within a secure environment of the productive system, modifying the one or more table entries from the base table and storing the modified table entries in the child table, executing one or more operations on the child table within the secure environment to determine if the one or more modified table entries repair the base table, and outputting a determined result of the one or more operations to a user interface. As a result, corrupt data can be modified locally via inheriting tables within a secured environment without any further damage being done to productive data in a productive environment.

Abstract: Disclosed herein are system, method, and computer program product embodiments for error root cause detection. An embodiment operates by a computer implemented method that includes receiving, by at least one processor, a request to determine a root cause of an error associated with a code and executing a first execution path and a second execution path, where the first and second execution paths correspond to the code. The method further includes determining whether a difference between first data generated by the execution of the first execution path and second data generated by the execution of the second execution path affects the error associated with the code. The method also includes identifying a code component that contributed to the difference between the first data and the second data, if the difference between the first data and the second data affects the error associated with the code.

Abstract: Universal, automatic file conversion may be provided by a universal file conversion system or application. An input file may be received by the universal file conversion system. An input file type for the input file and a recipient of the input file may be determined. Programs available to the recipient for accessing a file may be determined. A target file type accessible to the recipient may be determined for converting the input file. A sequence of file conversions to convert the input file to the target file type may be determined. The input file may be converted to the target file type based on the sequence of file conversions. The converted file may be provided to the recipient. The recipient may return the converted file, and the converted file may be automatically converted back to the original input file type and provided to the original source of the input file.

Abstract: A system includes determination of a match between a first table column of a plurality of table columns of database tables and a second table column of the plurality of table columns, determination, based on stored metadata, of a first data dictionary associated with the first table column and a second data dictionary associated with the second table column, merging of the first data dictionary and the second data dictionary to generate a merged data dictionary, and modification of the stored metadata to associate the first data dictionary with the merged data dictionary and to associate the second data dictionary with the merged data dictionary.

Abstract: Technologies are provided for capturing information during a data migration and to use the captured information to generate data migration artefacts that can be used in subsequent data migrations. Artificial intelligence techniques can be used to analyze the captured data migration information and to generate a data migration model that can be used to create the data migration artefacts. Changes made to the data migration artefacts can be tracked and used to train the data migration model. Additionally or alternatively, during execution of the subsequent data migration, additional data migration information can be captured and used to train the data migration model. The captured data migration activity can include data access operations such as data transactions, system log activity, and/or source code for one or more data migration programs and/or scripts. Computer system version information can be detected and different migration artefacts can be created for different computer system versions.

Abstract: Disclosed herein are system, method, and computer program product embodiments for detecting erroneous data. In an embodiment, a data monitoring system may store an initial dataset. The data monitoring system may analyze the initial dataset to generate rules associated with the initial dataset. The data monitoring system may receive a new data entry from a client device intended to be associated with the initial dataset. The data monitoring system may compare the new data entry to the previously determined rules to determine if the new data entry complies. If so, the data monitoring system may store the new data entry. If not, the data monitoring system may generate an alert, requesting a confirmation that the noncompliant data entry is correct. If the noncompliant data is confirmed as correct, the data monitoring system may store the new data entry and update the rules associated with the updated dataset.