Abstract: Systems and methods thereof, of generating a unique identification code for an industrial commodity. The method includes receiving a user query indicative of at least one constructional and operational characteristic of the commodity, inspecting the user query to determine whether the user query is complete for identification of the commodity, updating the user query based on the inspection, identifying at least one attribute of the commodity from the updated user query, based on a list of predefined attributes of the commodity, mapping the at least one attribute to at least one of predefined attribute types, predefined regional standards, predefined commodity rules, and predefined commodity types, and generating the unique identification code for the commodity, based on the mapping. The predefined attribute types may be a predefined commodity group and a predefined commodity part.

Abstract: Embodiments of the present invention allow a Source database and a Target database to be compared, with source-only, target-only, and difference objects presented on a graphical user interface in a manner that visually shows the characterization of each displayed object and each displayed object is user-selectable via the graphical user interface to obtain information about the object and differences between the source database and the target database with respect to the object. Some exemplary embodiments are discussed herein with reference to databases such as the Standard Database (SDB) for Intergraph Smart™ Reference Data product from Intergraph Corporation and are referred to generally as the “SDB Merge Tool,” although the disclosed concepts can be applied more generally to other types of databases.

Abstract: Embodiments of the present invention allow a Source database and a Target database to be compared and merged in such a way that logically relevant data is considered and merged while ignoring irrelevant differences (e.g., object identifiers) and that all dependencies across relational database tables are considered and merged. Some exemplary embodiments are discussed herein with reference to databases such as the Standard Database (SDB) for Intergraph Smart™ Reference Data product from Intergraph Corporation and are referred to generally as the “SDB Merge Tool,” although the disclosed concepts can be applied more generally to other types of databases.

Abstract: Embodiments of the present invention allow a Source database and a Target database to be compared and merged in such a way that logically relevant data is considered and merged while ignoring irrelevant differences (e.g., object identifiers) and that all dependencies across relational database tables are considered and merged. Some exemplary embodiments are discussed herein with reference to databases such as the Standard Database (SDB) for Intergraph Smart™ Reference Data product from Intergraph Corporation and are referred to generally as the “SDB Merge Tool,” although the disclosed concepts can be applied more generally to other types of databases.