Answer the question
In order to leave comments, you need to log in
Which DBMS to choose for developing an application for generating summary reports?
Good afternoon!
The analytical department in our enterprise quite often collects summary information from third-party departments. This process is the direction of the template in Excel. All incoming reports, and there are from 50 to 80 of them, are inserted into another Excel document (summary) as a separate sheet. Then the formulas are adjusted and a summary report is obtained. At the same time, quite often there is incorrect data - someone entered a value with a dot into the cell, someone with spaces, etc. as a result, individual cells are perceived as rows and are counted as “zero” during the summary, errors occur, etc. Plus, the process of arching as a result takes quite a long time and so on.
In this regard, the management asked to develop a flexible tool for a set of reports with access rights, and based on the web (Linux + Apache2). So that remote units can send reports by login and password, and, if necessary, make changes.
The bottom line is: the reports are not uniform for each period (the structure of the requested information changes). The report itself is a table with a dimension of 60-80 rows and 8-12 columns, of which 1 column is the name of the criterion, the remaining ones are digital values that drive in units (480-960 cells). Further, these reports must be consolidated into one common document (summary). In this case, individual values in the summary document are the sum of similar cells, individual values are the average value (minimum, maximum), etc.
I originally planned to implement a similar summary based on php (yii) PostgreSQL database. Those. arrange all the cells of the original report as a separate column of tables "table_reprort_2" + additional keys
(unit id, report id, date, etc.). On Yii, validate the primary data, which will avoid about 80% of errors when filling out. The final is already a specialist of the analytical department to check the overall figures.
However, there are concerns that the number of cells in the report may exceed the maximum size of a PostgreSQL table (from 250).
Question. Which DBMS are more designed for summary calculations and generating generalized reports. If anyone has experienced a similar issue please advise. Please, can there be any ready-made solutions.
Answer the question
In order to leave comments, you need to log in
Postgres is enough for you, you definitely don’t have to worry about it
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question