This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4828 IT projects that we have successfully completed with our customers.How can we support you?
Auditing acceptability
Project duration: 5 months
Brief description
Implementation of a software module that guarantees auditing acceptability in the event of write accesses to the database. Each data change and creation of new data, including information about the author and the time of the change, is to be saved as a log. This also makes it possible to place the data in a history and to restore it at the data record level.
Supplement
The necessary software module is implemented as a trigger-based solution. The trigger is implemented in the C programming language. The data to be logged is stored in the database in XML format. It is written to the log files at regular intervals. Added to this, a prototype is developed in C# that can be used to read or search the data from the log file and, if necessary, to generate SQL statements from the data in order to restore a desired state,
Subject description
Changes to data connected to insurance contracts that cannot be checked can entail a variety of serious problems for all the parties involved (e.g. policy holder, insurer, insurance broker). This includes, among other areas, business aspects (e.g. faulty balance sheets) or legal issues (e.g. preclusion of insurance risks). This could result in drawn-out legal disputes, although these can be reduced if a suitable set of instruments is used for a change history. Accidental input errors or changes to data that occur due to technical problems can be reset to a defined status with the help of change logs. These measures therefore not only ensure auditing acceptability but reinforce the robustness of the software and significantly improve its quality.
IT project data
- Industries insurance
- Specialist tasks insurance, Revision
- DP tasks database administration
- System environments Client/Server
- Procedure model customer standard
- Programming languages C, C-Sharp, SQL
- Databases PostgreSQL
- Development and test tool Emacs, MS Visual Studio .NET
- Operating systems Linux
- Middleware and frameworks XML
Project period01.08.2006 - 31.12.2006
Customers who trust us
Have we sparked your interest ?
