Sap Se

Adrian Golec

Georg Lang

Artur Kaufmann

Fabian Hammann

Dennis Kurfiss

Artur Kaufman

A system, a computer-implemented method, and a computer readable medium having stored thereon a computer executable program code for processing data related to monitoring and controlling of a network providing resources to users is disclosed herein. The method includes: receiving a resource usage record (RUR) from the network component for a resource provided to a user, identifying a resource type of the resource by using a resource usage description comprised in the RUR, identifying a user type of the user by using an identification information comprised in the RUR, generating a record in the database, selecting records in the database, each complying with a selection criterion specifying that a record to be selected is associated with a resource type assigned to the selection criterion and a user type assigned to the selection criterion, and sending batch data to the rating system, the batch data comprising resource usage descriptions.

Telecommunication system for monitoring and controlling of a network providing resource to a user

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.

Database view generation

A mobile digital telecommunication system, a computer-implemented method, and a computer readable medium having stored thereon a computer executable program code for processing of usage detail records (UDRs) is disclosed herein. The mobile digital cellular telecommunication system comprises a network component configured to generate the UDRs, a rating system and a billing system.

Growing community of inventors

Schwetzingen, Germany

Adrian Golec