CN110688541A - Report data query method and device, storage medium and electronic equipment - Google Patents
Report data query method and device, storage medium and electronic equipment Download PDFInfo
- Publication number
- CN110688541A CN110688541A CN201910950970.0A CN201910950970A CN110688541A CN 110688541 A CN110688541 A CN 110688541A CN 201910950970 A CN201910950970 A CN 201910950970A CN 110688541 A CN110688541 A CN 110688541A
- Authority
- CN
- China
- Prior art keywords
- target
- report data
- index
- dimension
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/901—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/901—Indexing; Data structures therefor; Storage structures
- G06F16/9017—Indexing; Data structures therefor; Storage structures using directory or table look-up
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
Abstract
The embodiment of the application discloses a method and a device for inquiring report data, a storage medium and electronic equipment. The method is executed by a server side, and comprises the following steps: receiving a report data acquisition request, and determining a target index and a target dimension of report data from the report data acquisition request; wherein the target index and target dimension are determined based on a user selection; determining target data content according to the target index and the target dimension, and the corresponding relation between the index and the dimension of the pre-stored report data and the data content; and returning the target data content to a report data request end for displaying. By executing the technical scheme, the indexes and the dimensions of the report of the current page can be determined according to the selection of the user, and the aim of improving the display efficiency of the report data can be fulfilled based on the report data query mode which is calculated and stored in advance.
Description
Technical Field
The embodiment of the application relates to the technical field of electronic information processing, in particular to a report data query method and device, a storage medium and electronic equipment.
Background
With the rapid rise of economy, the information is displayed in a data report form, so that business management and control of enterprises are facilitated. Taking financial development of bank enterprises as an example, the current report forms are displayed by developing fixed pages, and each page displays a category of report forms according to a single index and a single dimension. For example, a certain page can only develop data in the time dimension under the process index. However, such display is not favorable for the query of the query staff to the information because the indexes and dimensions in the page are written down, which is not favorable for the flexible adjustment of the query staff, and the existing report data is often calculated through the indexes and dimension information of the page viewed by the query staff before being returned to the front end, which causes a slow return speed of the report data, and under the condition that a large amount of report data needs to be simultaneously acquired in a quarterly and a year, the server is difficult to bear a large amount of calculation load of the report data, which affects the stability of the data report display process.
Disclosure of Invention
The embodiment of the application provides a method and a device for querying report data, a storage medium and an electronic device, which can determine indexes and dimensions of a report of a current page according to selection of a user, and can also improve the display efficiency of the report data based on a pre-calculated and stored report data querying mode.
In a first aspect, an embodiment of the present application provides a method for querying report data, where the method is executed by a server, and the method includes:
receiving a report data acquisition request, and determining a target index and a target dimension of report data from the report data acquisition request; wherein the target index and target dimension are determined based on a user selection;
determining target data content according to the target index and the target dimension, and the corresponding relation between the index and the dimension of the pre-stored report data and the data content;
and returning the target data content to a report data request end for displaying.
Optionally, receiving a request for acquiring report data, and determining a target index and a target dimension of the report data from the request for acquiring report data includes:
responding to an index type selection request of report data, and returning selectable indexes corresponding to the selected index types;
responding to a target index selection request of report data, and determining a target index in an acquisition request of the report data;
and responding to the target dimension selection request of the report data, and determining the target dimension in the report data acquisition request.
Optionally, the index types include an application management index type and an implementation management index type;
the selectable indexes corresponding to the application management index types comprise: at least one of the total demand item number, the total business function number, the analyzed demand item number, the demand item number in development, the error code number and the total transaction line number; the selectable indexes corresponding to the implementation management index types comprise: at least one of the business function production rate, the demand item production rate, the production business function number and the production demand item number;
the target dimension includes at least one of an item dimension, a department dimension, and a time dimension.
Optionally, the pre-stored report data is stored in a key-value pair manner.
Optionally, the pre-stored report data is target index full-scale data obtained by pre-calculating and combining any optional dimension under the target index.
Optionally, after the target data content is returned to the report data requesting end for displaying, the method further includes:
responding to the acquisition request of the additional report data, and determining a target index and a target dimension of the additional report data;
determining the target data content of the additional report data according to the target index and the target dimension of the additional report data and the corresponding relation between the index and the dimension of the pre-stored report data and the data content;
and returning the target data content of the additional report data to a report data request end for displaying.
In a second aspect, an embodiment of the present application provides an apparatus for querying report data, where the apparatus is configured at a server, and the apparatus includes:
the target index and target dimension determining module is used for receiving a report data acquisition request and determining a target index and a target dimension of the report data from the report data acquisition request; wherein the target index and target dimension are determined based on a user selection;
the target data content determining module is used for determining target data content according to the target index and the target dimension, and the corresponding relation between the index and the dimension of the pre-stored report data and the data content;
and the target data content returning module is used for returning the target data content to the report data request end for displaying.
Optionally, the target index and target dimension determining module includes:
the index type determining unit is used for responding to an index type selection request of report data and returning selectable indexes corresponding to the selected index types;
the target index determining unit is used for responding to a target index selection request of the report data and determining a target index in an acquisition request of the report data;
and the target dimension determining unit is used for responding to the target dimension selection request of the report data and determining the target dimension in the report data acquisition request.
In a third aspect, an embodiment of the present application provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements a method for querying report data according to an embodiment of the present application.
In a fourth aspect, an embodiment of the present application provides an electronic device, which includes a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor implements the method for querying report data according to the embodiment of the present application when executing the computer program.
According to the technical scheme provided by the embodiment of the application, the method is executed by the server side and comprises the following steps: receiving a report data acquisition request, and determining a target index and a target dimension of report data from the report data acquisition request; wherein the target index and target dimension are determined based on a user selection; determining target data content according to the target index and the target dimension, and the corresponding relation between the index and the dimension of the pre-stored report data and the data content; and returning the target data content to a report data request end for displaying. By adopting the technical scheme provided by the application, the indexes and the dimensionality of the report of the current page can be determined according to the selection of a user, and the aim of improving the display efficiency of the report data can be fulfilled based on a report data query mode which is calculated and stored in advance.
Drawings
FIG. 1 is a flowchart illustrating a method for querying report data according to an embodiment of the present disclosure;
FIG. 2 is a schematic diagram illustrating a report data storage method according to an embodiment of the present application;
FIG. 3 is a flowchart of a report data query method according to a second embodiment of the present application;
FIG. 4 is a query architecture diagram of report data provided in the third embodiment of the present application;
fig. 5 is a schematic structural diagram of a report data query device according to a fourth embodiment of the present application;
fig. 6 is a schematic structural diagram of an electronic device according to a sixth embodiment of the present application.
Detailed Description
The present application will be described in further detail with reference to the following drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the application and are not limiting of the application. It should be further noted that, for the convenience of description, only some of the structures related to the present application are shown in the drawings, not all of the structures.
Before discussing exemplary embodiments in more detail, it should be noted that some exemplary embodiments are described as processes or methods depicted as flowcharts. Although a flowchart may describe the steps as a sequential process, many of the steps can be performed in parallel, concurrently or simultaneously. In addition, the order of the steps may be rearranged. The process may be terminated when its operations are completed, but may have additional steps not included in the figure. The processes may correspond to methods, functions, procedures, subroutines, and the like.
Example one
Fig. 1 is a flowchart of a report data query method according to an embodiment of the present application, where the present embodiment is applicable to a report query situation, and the method may be executed by a report data query apparatus according to an embodiment of the present application, where the apparatus may be implemented by software and/or hardware, and may be integrated in an electronic device such as a server.
As shown in fig. 1, the query method of report data includes:
s110, receiving a report data acquisition request, and determining a target index and a target dimension of report data from the report data acquisition request; wherein the target index and target dimension are determined based on a user selection.
The report data may be data content viewed by a user through a report query page, and may include enterprise or personal data information, for example, information of each item in an enterprise, or personal week planning information. It can be understood that if the enterprise information is the enterprise information, the report data can be queried and displayed after the identity authentication, and the data can be prevented from being acquired by users without authority, so that the security of the enterprise data is ensured.
After entering a report data query page, a user can select a drop-down box and a dimension selection drop-down box through indexes provided in the report data query page to determine a target index and a target dimension. The target index and the target dimension can be determined based on selection of a user, and if the user does not perform selection operation, a default target index and a default target dimension can be provided for the user to provide report information of basic data. The index may be index information of different projects in an enterprise, such as the number of demand items, the number of error codes, the input and output rate of business functions, the input and output rate of demand items, and the like in development. The dimensions may include an item dimension, a time dimension, and a department dimension, among others. The data which the user actually needs to view can be determined based on the selection of the index and the dimension by the user, and the data can be displayed in a page in the forms of a bar chart or a pie chart and the like under the target dimension and the target index for the user to view.
And S120, determining the target data content according to the target index and the target dimension, and the pre-stored indexes of the report data and the corresponding relation between the dimension and the data content.
In this embodiment, after the target index and the target dimension are determined, the target data content may be determined according to the target index and the target dimension, and the corresponding relationship between the index and the dimension of the report data and the data content, which are stored in advance. The indexes and the corresponding relation between the dimensionality and the data content of the pre-stored report data can be stored in a table form. For example, the first column of data is index information, the second column of data is dimension information, and the third column of data is actual data content. In addition, each index can be generated into an independent data table, in the data table of each index, the first column of data can be dimension information, and the second column of data can be actual data content. The method has the advantages that if the data of one index is updated, the information of the index can be rapidly updated, so that the accuracy of the returned report data is ensured.
The indexes of the pre-stored report data and the corresponding relation between the dimensions and the data content can be pre-stored and calculated for the data of each dimension of each index. The data content may be a total number type value or a percentage type value, and each value may be calculated in advance and stored. In the technical scheme, the data under one index can be in a single dimension or multiple dimensions. For example, the index of the total demand item number may include three types, namely, a time dimension, a project dimension, and a department dimension, and then, values of time dimensions in each time period may be calculated, values of project dimensions in each project may be calculated, values of departments in the department dimension may be calculated, the time dimension and the project dimension may be considered comprehensively, and the values may be calculated, as well as other stacking manners of the three dimensions. The method has the advantages that the storage space can be fully utilized, so that the aim of saving the calculation time in the actual report data acquisition process is fulfilled.
S130, returning the target data content to the report data request end for displaying.
After the target data is determined, the target data can be displayed at the requesting end, wherein the display form can be determined according to the selection of the user, and the display form can also be a default display mode, such as a bar chart, a pie chart, a curve formed by point connection, and the like. Through the arrangement, the data is pre-calculated, so that the report data can be rapidly displayed without calculating after receiving the request, and the time for displaying the report data is influenced. On the other hand, the target index and the target dimension can be determined according to the selection of the user, so that the content of the report data needing to be displayed can be determined according to the requirement of the user, and the complex design that one page needs to be designed to display the report data aiming at each dimension and index can be avoided.
In this embodiment, optionally, the index types include an application management index type and an implementation management index type; the selectable indexes corresponding to the application management index types comprise: at least one of the total demand item number, the total business function number, the analyzed demand item number, the demand item number in development, the error code number and the total transaction line number; the selectable indexes corresponding to the implementation management index types comprise: at least one of the business function production rate, the demand item production rate, the production business function number and the production demand item number; the target dimension includes at least one of an item dimension, a department dimension, and a time dimension. The index type may include two blocks of an application management index and an implementation management index, where the application management index type may include different index contents, such as a total number of demand items, a total number of business functions, and the like, and the implementation management index type may include index contents related to implementation projects, such as a business function yield, a demand item yield, and the like. Additionally, the target dimensions may include an item dimension, a department dimension, and a time dimension, and may include other dimensions as well. Through the division, the report data can be stored more orderly, and the search and the classified check are convenient.
In this embodiment, optionally, the pre-stored report data is stored in a key-value pair manner. The key information in the key value pair may be dimension information, and the value information may be data content information. The key value pair storage mode has the advantage that the data report can be rapidly inquired, so that the data content inquiry efficiency of the data report is improved.
In this embodiment, optionally, the pre-stored report data is target index full-scale data obtained by pre-calculating and combining any optional dimension under a target index. Fig. 2 is a schematic diagram of a report data storage method according to an embodiment of the present application. As shown in fig. 2, A, B, C and D represent four dimensions, where any two of the four dimensions may be combined to obtain a two-dimensional node, any three of the dimensions may also be combined to obtain a three-dimensional node, and finally all four dimensions may also be combined to obtain a four-dimensional node. Where each node may store data content in that dimension. Through the arrangement, all dimensions can be stored in any combination mode under each index, so that in the data query process, after the current target dimension is determined, the data of the target dimension can be rapidly obtained no matter which dimension combination is adopted by the target dimension.
According to the technical scheme provided by the embodiment of the application, the method is executed by the server side and comprises the following steps: receiving a report data acquisition request, and determining a target index and a target dimension of report data from the report data acquisition request; wherein the target index and target dimension are determined based on a user selection; determining target data content according to the target index and the target dimension, and the corresponding relation between the index and the dimension of the pre-stored report data and the data content; and returning the target data content to a report data request end for displaying. By adopting the technical scheme provided by the application, the indexes and the dimensionality of the report of the current page can be determined according to the selection of a user, and the aim of improving the display efficiency of the report data can be fulfilled based on a report data query mode which is calculated and stored in advance.
On the basis of the above technical solutions, optionally, receiving a request for acquiring report data, and determining a target index and a target dimension of the report data from the request for acquiring report data includes: responding to an index type selection request of report data, and returning selectable indexes corresponding to the selected index types; responding to a target index selection request of report data, and determining a target index in an acquisition request of the report data; and responding to the target dimension selection request of the report data, and determining the target dimension in the report data acquisition request. After the user determines the index type, the target index that the user actually needs to view may be determined according to the index type. And at the same time, the dimension which needs to be viewed actually can be determined in response to the target dimension selection operation of the user. According to the technical scheme, through the setting, two parameters of the index and the dimension which determine the report data are selected by a user, so that the display flexibility of the report data is improved.
Example two
Fig. 3 is a flowchart of a report data query method provided in the second embodiment of the present application, and this embodiment is a further optimization scheme for the foregoing embodiment. The concrete optimization is as follows: after the target data content is returned to the report data request end for displaying, the method further comprises the following steps: responding to the acquisition request of the additional report data, and determining a target index and a target dimension of the additional report data; determining the target data content of the additional report data according to the target index and the target dimension of the additional report data and the corresponding relation between the index and the dimension of the pre-stored report data and the data content; and returning the target data content of the additional report data to a report data request end for displaying.
As shown in fig. 3, the query method of report data includes:
s310, receiving a report data acquisition request, and determining a target index and a target dimension of the report data from the report data acquisition request; wherein the target index and the target dimension are determined based on a selection of a user.
S320, determining the target data content according to the target index and the target dimension, and the pre-stored indexes of the report data and the corresponding relation between the dimension and the data content.
S330, returning the target data content to the report data request end for displaying.
S340, responding to the acquisition request of the additional report data, and determining the target index and the target dimension of the additional report data.
The additional report data may be an operation triggered when the user needs to check other report data after the first report data is generated. For example, a plus sign may be displayed below the content of the first report data displayed on the page, and after the user clicks the plus sign, a selection bar for configuring the parameters of the report data may be displayed for the user, and the specific selection manner may be the same as the parameter selection manner of the first report data.
And S350, determining the target data content of the additional report data according to the target index and the target dimension of the additional report data and the corresponding relation between the index and the dimension of the pre-stored report data and the data content.
After determining the content of the additional reporting data, the target data content of the additional reporting data to be presented can be determined at the storage location.
And S360, returning the target data content of the additional report data to the report data request terminal for displaying.
After the target data content is determined, the target data content can be sent to the request end to be displayed. The display mode can be the same as the content of the first report data or different from the content of the first report data.
On the basis of the above embodiments, the present embodiment provides a method for displaying multiple report data on the same page. The method has the advantages of being beneficial to observation and comparison of the report data by the user and assisting in improving the viewing efficiency of the report data of the user.
EXAMPLE III
In order to enable a person skilled in the art to more accurately understand the technical solutions provided in the present application, the present application also provides a preferred embodiment.
Fig. 4 is a query architecture diagram of report data provided in the third embodiment of the present application.
Report structure collection module: the front-end interface module comprises report dimension and index selection, aims to display all dimension and index selections for the drop-down box, and collects the dimension and index which the user wants to specify. Hereinafter referred to as module 1.
The report data display module: and the front-end interface module is used for graphically displaying the data according to the data acquired from the back-end service, and is hereinafter referred to as a module 2.
Front end communication module: and the front-end interface module is responsible for packaging and analyzing data communicated by the modules 1 and 2 and the rear end, sending and receiving the data, and is hereinafter referred to as a module 3.
A rear-end communication module: and the back-end service module is responsible for packaging and analyzing data communicated by the report structure information processing module, the report data information processing module and the front end, and sending and receiving the data, and is hereinafter referred to as a module 4.
Report structure information processing module: and the back-end service module is used for persisting the full dimensionality and the index type through report structure information storage and providing index and dimensional drop-down frame display data for the module 1. Hereinafter referred to as module 5.
The report data information processing module: and the back-end service module is used for persisting the index data information corresponding to the full dimensionality through report data information storage (apackylin), assembling query statements according to the dimensionality and the index selected by the module 1 and applying the query statements to query of the report data information storage.
Hereinafter referred to as module 6.
And the report data information storage module is used for coping with complex query of the super large data set through pre-calculation. Because the report shows a processing result set, similar total number, percentage and the like of all data in a period of time, the calculation and processing process of the index data needs to be performed in a long time, the information storage of the report data adopts a space-to-time principle, and the analysis and query capability of a large data set is realized by calculating and storing all possible calculation results in advance.
The scheme comprises the following specific processes:
1.1, an interface click index type drop-down box;
1.2, triggering a module 3 by a pull-down frame through a module 1;
1.3, the module 3 assembles a data message and starts network communication with the module 4;
1.4, the module 4 receives the network request, analyzes the data message and triggers the module 5;
1.5, inquiring the report structure information storage by a module 5, acquiring a full index type list, and returning the full index type list to the module 1 through an original link;
1.6, the module 1 receives the full index type list, displays the data in a display adaptation mode and displays the data on an interface;
2.1, after the index type is selected, continuing to click an index drop-down box on the interface;
2.2, triggering a module 3 by a pull-down frame through a module 1;
2.3, the module 3 assembles the data message and starts network communication with the module 4;
2.4, the module 4 receives the network request, analyzes the data message and triggers the module 5;
2.5, the module 5 inquires the report structure information storage, acquires a full index list under the type according to the index type and returns the full index list to the module 1 through the original link;
2.6, the module 1 receives the full index list, displays the data in a display adaptation mode and displays the data on an interface;
3.1, after the indexes are selected, continuing to select the dimension type by the interface drop-down box;
3.2, triggering a module 3 by a pull-down frame through a module 1;
3.3, the module 3 assembles the data message and starts network communication with the module 4;
3.4, the module 4 receives the network request, analyzes the data message and triggers the module 5;
3.5, inquiring the report structure information storage by the module 5, acquiring a full-scale dimensionality type list, and returning the list to the module 1 through an original link;
3.6, the module 1 receives the full-scale dimension type list, displays the data in a display adaptation mode and displays the data on an interface;
4.1, after the dimension type is selected, continuing to click a dimension drop-down box on the interface;
4.2, triggering a module 3 by a pull-down frame through a module 1;
4.3, the module 3 assembles the data message and starts network communication with the module 4;
4.4, the module 4 receives the network request, analyzes the data message and triggers the module 5;
4.5, the module 5 inquires about the report structure information storage, acquires a full-scale dimension list under the type according to the dimension type, and returns the full-scale dimension list to the module 1 through the original link;
4.6, the module 1 receives the full dimension list, displays the data in a display adaptation mode and displays the data on an interface;
5.1, clicking an interface to generate a report;
5.2, generating a report button triggering module 2;
5.3, the module 2 collects the dimension and index data selected by the interface and transmits the dimension and index data to the module 3;
5.4, the module 3 assembles the data message and starts network communication with the module 4;
5.5, the module 4 receives the network request, analyzes the data message and triggers the module 6;
5.6, the module 6 obtains the dimension type and the index type sent by the interface, and the selected dimension and the selected index, and encapsulates the corresponding query statement through different processing logics according to different types;
5.7, inquiring the information storage of the report data according to the inquiry statement, acquiring the report data, and returning the report data to the module 2 through the original link;
and 5.8, the module 2 receives the report information, displays the data in a display adaptation mode and displays the data on an interface.
By adopting the scheme, report displays under different dimensions and indexes can be displayed through one interface, and the code development and maintenance cost can be reduced.
Example four
Fig. 5 is a schematic structural diagram of a report data query device according to a fourth embodiment of the present application. As shown in fig. 5, the query device of report data includes:
a target index and target dimension determining module 510, configured to receive a request for obtaining report data, and determine a target index and a target dimension of the report data from the request for obtaining report data; wherein the target index and target dimension are determined based on a user selection;
a target data content determining module 520, configured to determine target data content according to the target index and the target dimension, and a corresponding relationship between the index and the dimension of the pre-stored report data and the data content;
and a target data content returning module 530, configured to return the target data content to the report data requesting end for display.
According to the technical scheme provided by the embodiment of the application, the method is executed by the server side and comprises the following steps: receiving a report data acquisition request, and determining a target index and a target dimension of report data from the report data acquisition request; wherein the target index and target dimension are determined based on a user selection; determining target data content according to the target index and the target dimension, and the corresponding relation between the index and the dimension of the pre-stored report data and the data content; and returning the target data content to a report data request end for displaying. By adopting the technical scheme provided by the application, the indexes and the dimensionality of the report of the current page can be determined according to the selection of a user, and the aim of improving the display efficiency of the report data can be fulfilled based on a report data query mode which is calculated and stored in advance.
On the basis of the foregoing technical solution, optionally, the target index and target dimension determining module includes:
the index type determining unit is used for responding to an index type selection request of report data and returning selectable indexes corresponding to the selected index types;
the target index determining unit is used for responding to a target index selection request of the report data and determining a target index in an acquisition request of the report data;
and the target dimension determining unit is used for responding to the target dimension selection request of the report data and determining the target dimension in the report data acquisition request.
The product can execute the method provided by any embodiment of the application, and has the corresponding functional module and the beneficial effect of the execution method.
EXAMPLE five
Embodiments of the present application further provide a storage medium containing computer-executable instructions, which when executed by a computer processor, are configured to perform a method for querying report data, the method including:
receiving a report data acquisition request, and determining a target index and a target dimension of report data from the report data acquisition request; wherein the target index and target dimension are determined based on a user selection;
determining target data content according to the target index and the target dimension, and the corresponding relation between the index and the dimension of the pre-stored report data and the data content;
and returning the target data content to a report data request end for displaying.
Storage medium-any of various types of memory devices or storage devices. The term "storage medium" is intended to include: mounting media such as CD-ROM, floppy disk, or tape devices; computer system memory or random access memory such as DRAM, DDR RAM, SRAM, EDO RAM, Lanbas (Rambus) RAM, etc.; non-volatile memory such as flash memory, magnetic media (e.g., hard disk or optical storage); registers or other similar types of memory elements, etc. The storage medium may also include other types of memory or combinations thereof. In addition, the storage medium may be located in the computer system in which the program is executed, or may be located in a different second computer system connected to the computer system through a network (such as the internet). The second computer system may provide the program instructions to the computer for execution. The term "storage medium" may include two or more storage media that may reside in different locations, such as in different computer systems that are connected by a network. The storage medium may store program instructions (e.g., embodied as a computer program) that are executable by one or more processors.
Of course, the storage medium containing the computer-executable instructions provided in the embodiments of the present application is not limited to the query operation of the report data described above, and may also perform the relevant operations in the query method of the report data provided in any embodiments of the present application.
EXAMPLE six
The embodiment of the application provides electronic equipment, and a query device of report data provided by the embodiment of the application can be integrated in the electronic equipment. Fig. 6 is a schematic structural diagram of an electronic device according to a sixth embodiment of the present application. As shown in fig. 6, the present embodiment provides an electronic device 600, which includes: one or more processors 620; the storage device 610 is configured to store one or more programs, and when the one or more programs are executed by the one or more processors 620, the one or more processors 620 are enabled to implement the method for querying report data provided in the embodiment of the present application, the method includes:
receiving a report data acquisition request, and determining a target index and a target dimension of report data from the report data acquisition request; wherein the target index and target dimension are determined based on a user selection;
determining target data content according to the target index and the target dimension, and the corresponding relation between the index and the dimension of the pre-stored report data and the data content;
and returning the target data content to a report data request end for displaying.
Of course, those skilled in the art can understand that the processor 620 may also implement the technical solution of the report data query method provided in any embodiment of the present application.
The electronic device 600 shown in fig. 6 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present application.
As shown in fig. 6, the electronic device 600 includes a processor 620, a storage device 610, an input device 630, and an output device 640; the number of the processors 620 in the electronic device may be one or more, and one processor 620 is taken as an example in fig. 6; the processor 620, the storage device 610, the input device 630, and the output device 640 in the electronic apparatus may be connected by a bus or other means, and are exemplified by being connected by a bus 650 in fig. 6.
The storage device 610 is a computer-readable storage medium, and can be used to store software programs, computer-executable programs, and module units, such as program instructions corresponding to the report data query method in the embodiment of the present application.
The storage device 610 may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created according to the use of the terminal, and the like. In addition, the storage 610 may include high speed random access memory and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device. In some examples, the storage 610 may further include memory located remotely from the processor 620, which may be connected via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input means 630 may be used to receive input numbers, character information, or voice information, and to generate key signal inputs related to user settings and function control of the electronic device. The output device 640 may include a display screen, speakers, etc.
The electronic equipment provided by the embodiment of the application can determine the index and the dimension of the report of the current page according to the selection of the user, and can also improve the display efficiency of the report data based on a report data query mode which is calculated and stored in advance.
The report data query device, the storage medium and the electronic device provided in the above embodiments can execute the report data query method provided in any embodiment of the present application, and have corresponding functional modules and beneficial effects for executing the method. For technical details that are not described in detail in the above embodiments, reference may be made to a method for querying report data provided in any embodiment of the present application.
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present application and the technical principles employed. It will be understood by those skilled in the art that the present application is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the application. Therefore, although the present application has been described in more detail with reference to the above embodiments, the present application is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present application, and the scope of the present application is determined by the scope of the appended claims.
Claims (10)
1. A report data query method is characterized in that the method is executed by a server side, and the method comprises the following steps:
receiving a report data acquisition request, and determining a target index and a target dimension of report data from the report data acquisition request; wherein the target index and target dimension are determined based on a user selection;
determining target data content according to the target index and the target dimension, and the corresponding relation between the index and the dimension of the pre-stored report data and the data content;
and returning the target data content to a report data request end for displaying.
2. The method of claim 1, wherein receiving a request for obtaining report data, and determining a target index and a target dimension of the report data from the request for obtaining report data comprises:
responding to an index type selection request of report data, and returning selectable indexes corresponding to the selected index types;
responding to a target index selection request of report data, and determining a target index in an acquisition request of the report data;
and responding to the target dimension selection request of the report data, and determining the target dimension in the report data acquisition request.
3. The method of claim 2, wherein the metric types include an application management metric type and an implementation management metric type;
the selectable indexes corresponding to the application management index types comprise: at least one of the total demand item number, the total business function number, the analyzed demand item number, the demand item number in development, the error code number and the total transaction line number; the selectable indexes corresponding to the implementation management index types comprise: at least one of the business function production rate, the demand item production rate, the production business function number and the production demand item number;
the target dimension includes at least one of an item dimension, a department dimension, and a time dimension.
4. The method of claim 1, wherein the pre-stored reporting data is stored in key-value pairs.
5. The method according to claim 1, wherein the pre-stored report data is target index full data obtained by pre-calculating and combining any selectable dimension under a target index.
6. The method of claim 1, wherein after returning the target data content to a report data requesting end for display, the method further comprises:
responding to the acquisition request of the additional report data, and determining a target index and a target dimension of the additional report data;
determining the target data content of the additional report data according to the target index and the target dimension of the additional report data and the corresponding relation between the index and the dimension of the pre-stored report data and the data content;
and returning the target data content of the additional report data to a report data request end for displaying.
7. An apparatus for querying report data, wherein the apparatus is configured at a server, the apparatus comprising:
the target index and target dimension determining module is used for receiving a report data acquisition request and determining a target index and a target dimension of the report data from the report data acquisition request; wherein the target index and target dimension are determined based on a user selection;
the target data content determining module is used for determining target data content according to the target index and the target dimension, and the corresponding relation between the index and the dimension of the pre-stored report data and the data content;
and the target data content returning module is used for returning the target data content to the report data request end for displaying.
8. The apparatus of claim 7, wherein the target metrics and target dimensions determination module comprises:
the index type determining unit is used for responding to an index type selection request of report data and returning selectable indexes corresponding to the selected index types;
the target index determining unit is used for responding to a target index selection request of the report data and determining a target index in an acquisition request of the report data;
and the target dimension determining unit is used for responding to the target dimension selection request of the report data and determining the target dimension in the report data acquisition request.
9. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, implements a method of querying report data according to any one of claims 1 to 6.
10. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method for querying report data according to any of claims 1-6 when executing the computer program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910950970.0A CN110688541A (en) | 2019-10-08 | 2019-10-08 | Report data query method and device, storage medium and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910950970.0A CN110688541A (en) | 2019-10-08 | 2019-10-08 | Report data query method and device, storage medium and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110688541A true CN110688541A (en) | 2020-01-14 |
Family
ID=69111532
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910950970.0A Pending CN110688541A (en) | 2019-10-08 | 2019-10-08 | Report data query method and device, storage medium and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110688541A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111506613A (en) * | 2020-04-22 | 2020-08-07 | 支付宝(杭州)信息技术有限公司 | Method, system, device and equipment for querying incidence relation of data record |
| CN111597237A (en) * | 2020-05-22 | 2020-08-28 | 北京学之途网络科技有限公司 | Data query result generation method and device, electronic equipment and storage medium |
| CN111831636A (en) * | 2020-07-28 | 2020-10-27 | 平安国际融资租赁有限公司 | Data processing method, device, computer system and readable storage medium |
| CN112001617A (en) * | 2020-08-14 | 2020-11-27 | 苏州浪潮智能科技有限公司 | Report generation progress method, device, equipment and readable storage medium |
| CN112183041A (en) * | 2020-09-28 | 2021-01-05 | 建信金融科技有限责任公司 | Report form adjusting method, device, equipment and storage medium based on indexes |
| CN112464631A (en) * | 2020-12-08 | 2021-03-09 | 中国工商银行股份有限公司 | Report exporting method, device and equipment |
| CN112861494A (en) * | 2021-02-05 | 2021-05-28 | 青岛海信网络科技股份有限公司 | Road network data-based visual report generation method, equipment and storage medium |
| CN113076358A (en) * | 2021-03-25 | 2021-07-06 | 恒安嘉新（北京）科技股份公司 | Report generation method, device, equipment and storage medium |
| CN113469770A (en) * | 2020-03-31 | 2021-10-01 | 珠海优特智厨科技有限公司 | Order information processing method, device, equipment and computer readable storage medium |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6073134A (en) * | 1997-05-29 | 2000-06-06 | Oracle Corporation | Method article of manufacture, and apparatus for generating a multi-dimensional record management index |
| US20130173528A1 (en) * | 2011-12-29 | 2013-07-04 | International Business Machines Corporation | Multi-fact query processing in data processing system |
| CN103699671A (en) * | 2013-12-30 | 2014-04-02 | 成都道永网络技术有限公司 | Data report generating method and data report generating system |
| CN106528067A (en) * | 2015-09-15 | 2017-03-22 | 阿里巴巴集团控股有限公司 | Method and device for generating report form |
| CN106557498A (en) * | 2015-09-25 | 2017-04-05 | 北京国双科技有限公司 | Date storage method and device and data query method and apparatus |
| CN106933897A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | Data query method and apparatus |
| CN107729336A (en) * | 2016-08-11 | 2018-02-23 | 阿里巴巴集团控股有限公司 | Data processing method, equipment and system |
| CN108874926A (en) * | 2018-05-31 | 2018-11-23 | 康键信息技术（深圳）有限公司 | Mass data inquiry method, device, computer equipment and storage medium |
| CN109165377A (en) * | 2018-06-11 | 2019-01-08 | 玖富金科控股集团有限责任公司 | Generate the method and tabulating equipment of form data |
| CN110032567A (en) * | 2019-04-24 | 2019-07-19 | 江苏满运软件科技有限公司 | Report form inquiring method, device, server and storage medium |
-
2019
- 2019-10-08 CN CN201910950970.0A patent/CN110688541A/en active Pending
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6073134A (en) * | 1997-05-29 | 2000-06-06 | Oracle Corporation | Method article of manufacture, and apparatus for generating a multi-dimensional record management index |
| US20130173528A1 (en) * | 2011-12-29 | 2013-07-04 | International Business Machines Corporation | Multi-fact query processing in data processing system |
| CN103699671A (en) * | 2013-12-30 | 2014-04-02 | 成都道永网络技术有限公司 | Data report generating method and data report generating system |
| CN106528067A (en) * | 2015-09-15 | 2017-03-22 | 阿里巴巴集团控股有限公司 | Method and device for generating report form |
| CN106557498A (en) * | 2015-09-25 | 2017-04-05 | 北京国双科技有限公司 | Date storage method and device and data query method and apparatus |
| CN106933897A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | Data query method and apparatus |
| CN107729336A (en) * | 2016-08-11 | 2018-02-23 | 阿里巴巴集团控股有限公司 | Data processing method, equipment and system |
| CN108874926A (en) * | 2018-05-31 | 2018-11-23 | 康键信息技术（深圳）有限公司 | Mass data inquiry method, device, computer equipment and storage medium |
| CN109165377A (en) * | 2018-06-11 | 2019-01-08 | 玖富金科控股集团有限责任公司 | Generate the method and tabulating equipment of form data |
| CN110032567A (en) * | 2019-04-24 | 2019-07-19 | 江苏满运软件科技有限公司 | Report form inquiring method, device, server and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 任鹏 等: "交通统计数据多维存储模型构建", 《武汉理工大学学报（信息与管理工程版）》 * |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113469770A (en) * | 2020-03-31 | 2021-10-01 | 珠海优特智厨科技有限公司 | Order information processing method, device, equipment and computer readable storage medium |
| CN111506613A (en) * | 2020-04-22 | 2020-08-07 | 支付宝(杭州)信息技术有限公司 | Method, system, device and equipment for querying incidence relation of data record |
| CN111597237A (en) * | 2020-05-22 | 2020-08-28 | 北京学之途网络科技有限公司 | Data query result generation method and device, electronic equipment and storage medium |
| CN111597237B (en) * | 2020-05-22 | 2024-03-29 | 北京明略昭辉科技有限公司 | Method and device for generating data query result, electronic equipment and storage medium |
| CN111831636A (en) * | 2020-07-28 | 2020-10-27 | 平安国际融资租赁有限公司 | Data processing method, device, computer system and readable storage medium |
| CN112001617A (en) * | 2020-08-14 | 2020-11-27 | 苏州浪潮智能科技有限公司 | Report generation progress method, device, equipment and readable storage medium |
| CN112001617B (en) * | 2020-08-14 | 2022-06-03 | 苏州浪潮智能科技有限公司 | Report generation progress method, device, equipment and readable storage medium |
| CN112183041A (en) * | 2020-09-28 | 2021-01-05 | 建信金融科技有限责任公司 | Report form adjusting method, device, equipment and storage medium based on indexes |
| CN112464631A (en) * | 2020-12-08 | 2021-03-09 | 中国工商银行股份有限公司 | Report exporting method, device and equipment |
| CN112861494A (en) * | 2021-02-05 | 2021-05-28 | 青岛海信网络科技股份有限公司 | Road network data-based visual report generation method, equipment and storage medium |
| CN113076358A (en) * | 2021-03-25 | 2021-07-06 | 恒安嘉新（北京）科技股份公司 | Report generation method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110688541A (en) | Report data query method and device, storage medium and electronic equipment | |
| US20080162999A1 (en) | Method and system for validation of data extraction | |
| US10764163B2 (en) | Determining an event history for an event processed by a plurality of communicating servers via a central event data log | |
| CN108255897B (en) | Visualized chart data conversion processing method and device | |
| CN108647357B (en) | Data query method and device | |
| US10445343B2 (en) | Systems and methods for data exchange and conversion | |
| US10963888B2 (en) | Payment complaint method, device, server and readable storage medium | |
| US10636086B2 (en) | XBRL comparative reporting | |
| CN110347688B (en) | Method, device and equipment for fusing characteristics of multi-element information and storage medium | |
| US9633077B2 (en) | Query of multiple unjoined views | |
| JP7445785B2 (en) | Information processing methods, devices, electronic devices and storage media | |
| CN111858742A (en) | Data visualization method and device, storage medium and equipment | |
| CN102917009A (en) | Method and system for collecting and storing stock data based on cloud computing technology | |
| CN106980638B (en) | Operation record system, method and operation object change information query method | |
| US20180060890A1 (en) | Standardized custom surveys | |
| US20140095518A1 (en) | Calculated measures as attribute filters | |
| CN105808707A (en) | Data processing method, data processing device and e-commerce platform | |
| CN114168624B (en) | Data analysis method, computing device and storage medium | |
| CN110740153A (en) | monitoring data acquisition method, system and device | |
| US20110029480A1 (en) | Method of Compiling Multiple Data Sources into One Dataset | |
| US11567961B2 (en) | Using flat data input for simultaneous application of multiple separate calculations rule sets to obtain multiple output results | |
| CN112632115A (en) | BI-based data query method and system | |
| US20190188794A1 (en) | Computer processing of state using key states | |
| CN110716911A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN112199233B (en) | Method, device and equipment for verifying elastic search visual data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20220920 Address after: 25 Financial Street, Xicheng District, Beijing 100033 Applicant after: CHINA CONSTRUCTION BANK Corp. Address before: 25 Financial Street, Xicheng District, Beijing 100033 Applicant before: CHINA CONSTRUCTION BANK Corp. Applicant before: Jianxin Financial Science and Technology Co.,Ltd. |
|
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200114 |