Sap Se

Fabian Hammann

Georg Lang

Adrian Golec

Dennis Kurfiss

Artur Kaufman

In an example embodiment, a method of handling duplicate records in a computer database is provided. A record is received via an API. An item type associated with the record is identified. A duplicate check schema corresponding to the item type is obtained. A string is generated for the record by extracting values for each of a plurality of fields, defined in the duplicate check schema, located in the record and concatenating the values. Then a hash algorithm is applied to the string to create a hash for the record. The hash for the record is compared to hashes from previous records stored in the computer database to identify whether the hash is a duplicate. In response to a determination that the hash is a duplicate, one or more processing rules from the duplicate check schema are executed.

Duplicate check based on generated hash value

In some embodiments, a system for database view generation may include a view generator configured to generate a database view for one or more database tables. The view generator includes a generation module configured to determine a generation template for the database view, where the generation template is a code structure describing a manner in which the database view is created. The code structure does not reference a database name of the one or more database tables. The generation module is configured to invoke a code composer to insert code commands into the generation template to build a structured query language (SQL) statement for the database view, where the SQL statement references the database name of the one or more database tables. The view generator is configured to create the database view based on the SQL statement.

Growing community of inventors

Schifferstadt, Germany

Fabian Hammann