Abstract: 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.

Abstract: Systems and methods of independent processing streams for event data are disclosed. In some example embodiments, a computer-implemented method comprises receiving transaction data items, persisting the transaction data items in a first database, persisting a copy of the transaction data items as auxiliary data items in a second database different from the first database, detecting a manipulation of the transaction data items, updating the auxiliary data items in the second database based on the detecting of the manipulation, performing at least one online analytical processing operation using the auxiliary data items in the second database, and accessing the transaction data items in the first database and generating one or more documents using the accessed transaction data items subsequent to and independently from the performing of the at least one online analytical processing operation, with the generating of the document(s) being one of a plurality of periodic document generation operations.

Abstract: 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.

Abstract: 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.

Abstract: 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.