Method and system for processing data exported from cross-tabulation, and computer-readable storage medium

Abstract

The invention provides a cross table exported data processing method and system and a computer readable storage medium. The processing method comprises the steps of obtaining an execution SQL of an original cross table model; obtaining a column dimension field set from a cross area of the original cross table model, constructing a calculation field according to the column dimension field set, andadding the calculation field to the execution SQL to obtain a first execution SQL; obtaining a cross index, and converting the first execution SQL according to the cross index to obtain an SQL statement corresponding to the cross index; obtaining SQL statements corresponding to all the cross indexes, and combining the SQL statements to obtain a target execution SQL; and performing query accordingto the target execution SQL to obtain a result set, and displaying the result set in the target cross table model. According to the method, row-to-column conversion is achieved on the level of the database, all exporting of the cross table is met, it is avoided that the number of lines of SQL data executed by the cross table is too large, and the exporting speed of the cross table is effectively increased.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a method for processing data derived from a cross table, a system for processing data derived from a cross table, and a computer-readable storage medium. Background technique [0002] The output of report data is a common operation for users to use software products containing reports. Usually, developers will provide export options on the product. However, although the crosstab used in practice does not have many rows in the display, the actual amount of data queried by SQL is very large, and the exported In the process, the form model must be filled, which puts a lot of pressure on the server and client, and the export time is also very long. figure 1 It shows the principle of exporting data from the cross table in the prior art, for example: select department, name, year, salary item, sum(money) from tablegroup by department, name, year, salary item order by departm...

AI Technical Summary

Problems solved by technology

[0009] After the number of query lines is enlarged, the memory usage of the client will be large. If multiple reports or multiple query nodes are opened at the same time, it may cause memory overflow and the system cannot respond. You must re-enter the system, resulting in very poor user experience. to experience

And when there are too many query rows, it is not convenient for users to view on the front end. If multiple users repeatedly query and display such a large amount of data on the front end at the same time, it will also put a lot of pressure on the server. Therefore, most software products There will be a certain line limit for this

[0010] 2. The export of all data in the cross table encounters a problem with a large amount of data

[0012] 3. The existing export method cannot achieve batch export, and needs to be converted into a cross-tab model in the background code, which may cause incomplete row data in batch rows

Images