Customer request:

• Modern data model design reflecting the current requirements
• Simplicity and data consistency
• Create a separate layer of the application code in DB
• Thorough diagnostics and audit capability of user procedures
• Create a modern Win10 application
• Interconnection of the existing SW solutions (MS ReportServer) with data models (Oracle)

Pre-solution status:

• Database scheme operated for 20 years with gradual changes
• Insufficiently solved relationships between database entities, data inconsistent solutions
• Graphical interface with technology valid at the time of creation, not supported by the latest MS operating system or Oracle database
• Application logic placed both in DB and in applications, duplicate code

Implemented solution:

• Development of data model using Data Modeler tool
• Creating a new DB schema with migration of all available historical data
• Detailed audit of all DB operations
• Object-oriented design of application code over DB entities
• Development of a new Win application using the latest programming techniques (WPF, EF, MVVM, ...)
• Linking (Microsoft) SQL Server Reporting Services (SSRS) to the Oracle DB data model​Detailný audit všetkých operácií na DB

Benefit for the customer:

• Modern, supported and extensible data model transparently separated from the environment
• Diagnosis of problem states and user intervention by the system administrator
• Modern Win application with easy deployment to production environment
• Use of existing MS ReportServer SW solutions