This project analyses the current state of use of the information system in the
described company and suggests optimal solutions for its effectiveness based on the
findings. The central part of the proposed changes is devoted to the issue of data updates
in the information system. The proposed solution should eliminate the risks
associated with problematic uploads, updated data, and overall efficiency in the company's
information system.
Ā
For the expediency and completeness of the solution proposal, I have created an XSD regulation together with the file XML. The complete version of the files is attached in the attachments. The files are supposed to simulate data sentences obtained from the client. They will be used in the design of the database structure automation in SQL Server Integration Services.
On the X-axis, the period in which the data were measured is displayed in months, on the Y-axis they are displayed data with the duration of the file upload and at the same time the size of the update file. From the measured data from previous months, the curves are created for months 11 and X-axis. From 12 months, the difference in recording duration is shown, thanks to SSIS automation with file upload. So between months 11 and 12, it is possible to follow
a significant difference in the time required to upload, while the size of the update file
is still growing. From month 12, based on the available data, we continued the established trend
using the SSIS package and we made a prediction of the file upload length for the next 5
months.
Ā
