Menu
This is one of 4546 IT projects that we have successfully completed with our customers.How can we support you?
Database redesign of the central master data application
Brief description
The project is focused on redesigning large parts of the database architecture with the aim of increasing scalability of the database. The following key aspects are implemented: porting the primary keys (PK) to another data type and converting PK generation by using sequences; new conceptual design for persistence and archiving of large data types (XML); redesign of data access by means of dedicated read transactions from the server/client context and the use of stored procedures; redesign of data persistence using stored procedures; identifying ineffective indexes and redesigning them.
Supplement
The customer's master data application is based on a three-layer, service-oriented architecture (.NET-based thin client, application server, MS SQL 2014) and it has been in operation for than 10 years. The system communicates both with other individually implemented systems of the customer and with standard software such as SAP ERP. Due to the dynamic business field, continuous growth of the data volume and increasingly complex business processes, a preliminary project was commissioned to derive measures to enable continued mapping of the constantly changing requirements.
Subject description
The system is used for recording all necessary contracts (purchasing, sales) and the data relevant for these (tariff schemes, profile, technical data) through to settlement and posting of customer documents. The customer's field of activity is not focused exclusively on the procurement of energy, but rather extends to energy consultation, metering point operation, trading energy from feed-in plants as well as representing additional sectors such as water and district heating. In addition, the user group of the system should be extended so that access can also be made possible for third parties. The multi-client capability of the application should be used for this purpose. In the framework of adapting the system, importance is given above all to the ability to react flexibly to innovations and to integrate them.
Overview
- Branchen energy
- Fachaufgaben contract management, energy trade
- DV-Aufgaben concept
- Systemumgebungen Client/Server
- Vorgehensmodell customer standard
- Datenbanken MS SQL Server
- Entwicklungs- und Testtool MS Team Foundation Server TFS, MS Visual Studio,
Project periodProjektbeginn02.05.2016
Have we sparked your interest?
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
