CN111158795A - Report generation method, device, medium and electronic equipment - Google Patents
Report generation method, device, medium and electronic equipment Download PDFInfo
- Publication number
- CN111158795A CN111158795A CN201911348730.XA CN201911348730A CN111158795A CN 111158795 A CN111158795 A CN 111158795A CN 201911348730 A CN201911348730 A CN 201911348730A CN 111158795 A CN111158795 A CN 111158795A
- Authority
- CN
- China
- Prior art keywords
- field
- information
- meta
- report
- configuration information
- 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
- 238000000034 method Methods 0.000 title claims abstract description 46
- 238000004458 analytical method Methods 0.000 claims description 3
- 238000013507 mapping Methods 0.000 claims description 2
- 238000012545 processing Methods 0.000 description 8
- 238000010586 diagram Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 230000018109 developmental process Effects 0.000 description 2
- 239000013307 optical fiber Substances 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 230000006978 adaptation Effects 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 230000003252 repetitive effect Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000003786 synthesis reaction Methods 0.000 description 1
- 230000033772 system development Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/448—Execution paradigms, e.g. implementations of programming paradigms
- G06F9/4482—Procedural
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application relates to a report generation method, a report generation device, a report generation medium and electronic equipment, which belong to the technical field of computers, and the method comprises the following steps: when report configuration information input by a user is received, analyzing the report configuration information and generating a structured query statement; obtaining a plurality of first fields from a database by using the structured query statement; according to the associated field identification in the report configuration information, acquiring the meta information of the fact table field corresponding to the associated field identification from a meta information table stored in a database; generating the association field by using data of the special attributes in the system corresponding to the plurality of first fields mapped by the meta-information according to the meta-information, wherein the association field represents a field displayed by the business fact constructed according to the data of the plurality of first fields mapped by the meta-information; and generating a report by using the first field and the associated field according to a gathering rule in the report configuration information. The method and the device can effectively improve the reliability of the generation of the personalized report.
Description
Technical Field
The application relates to the technical field of computers, in particular to a report generation method, a report generation device, a report generation medium and electronic equipment.
Background
The report is a table for summarizing and displaying information of different dimensions. At present, report making is usually customized development according to the requirements of a client during system development, and the display information and the summarizing dimension of the report are fixed and unchangeable. And if the subsequent user has the requirements for changing the report display information and the summary dimension, the developer needs to make customized development again. In the prior art, when the report is generated, user requirements are difficult to individualize, the reliability of report generation is insufficient, and the user experience is greatly discounted.
It is to be noted that the information disclosed in the above background section is only for enhancement of understanding of the background of the present application and therefore may include information that does not constitute prior art known to a person of ordinary skill in the art.
Disclosure of Invention
The purpose of the present application is to provide a report generation scheme, so as to improve the reliability of report generation at least to a certain extent.
According to an aspect of the present application, there is provided a report generation method, including:
when report configuration information input by a user is received, analyzing the report configuration information and generating a structured query statement;
acquiring a plurality of first fields from a database by using the structured query statement, wherein the first fields are used for representing data of special attributes in a system;
according to the associated field identification in the report configuration information, acquiring the meta information of the fact table field corresponding to the associated field identification from a meta information table stored in a database;
generating the association field by utilizing data of special attributes in the system corresponding to the plurality of first fields mapped by the meta-information according to the meta-information, wherein the association field represents a field displayed by a business fact constructed according to the data of the plurality of first fields mapped by the meta-information;
and generating a report by using the first field and the associated field according to a gathering rule in the report configuration information.
In an exemplary embodiment of the present application, when report configuration information input by a user is received, parsing the report configuration information and generating a structured query statement includes:
when report configuration information input by a user is received, analyzing the report configuration information to obtain source data information of a configured report, wherein the source data information comprises a first field identifier;
and generating the structured query statement by taking the first field identification as a query condition.
In an exemplary embodiment of the present application, acquiring, from a meta information table stored in a database, meta information of a fact table field corresponding to an associated field identifier according to the associated field identifier in the report configuration information includes:
acquiring the identification of the associated field in the report configuration information;
and acquiring the meta-information with the matched identification of the associated field from a meta-information table stored in a database.
In an exemplary embodiment of the present application, obtaining meta information that identifies a match of the associated field includes:
determining a plurality of meta-information matched with the identification of each associated field, wherein the meta-information corresponds to an information display target;
and according to an information display target in the report configuration information, acquiring meta information corresponding to the information display target from the plurality of meta information, wherein the information display target is used for indicating the use purpose of the report.
In an exemplary embodiment of the present application, according to the meta information, generating the association field by using data of the special attribute in the system corresponding to the plurality of first fields mapped by the meta information, where the association field represents a field of a business fact display constructed according to the data of the plurality of first fields mapped by the meta information, includes:
acquiring a plurality of first fields of the meta-information mapping matched with the identification of the associated field;
and generating the associated field according to the field generation strategy of the meta-information based on the data of the special attributes in the system of the plurality of first fields mapped by the meta-information.
In an exemplary embodiment of the present application, generating a report by using the first field and the associated field according to a summary rule in the report configuration information includes:
generating a summary field corresponding to each summary grammar by using the first field and the associated field of each summary grammar identifier in the summary rules according to the summary rules in the report configuration information;
and generating a report by utilizing the first field, the associated field and the summary field.
In an exemplary embodiment of the present application, generating a report using the first field, the associated field, and the summary field includes:
acquiring the summary style of the first field, the associated field and the summary field from the report configuration information;
and generating a report by utilizing the first field, the associated field and the summary field according to the summary style.
According to an aspect of the present application, there is provided a report generation apparatus, including:
the analysis module is used for analyzing the report configuration information and generating a structured query statement when the report configuration information input by a user is received;
the first acquisition module is used for acquiring a plurality of first fields from a database by using the structured query statement, wherein the first fields are used for representing data of special attributes in the system;
the second acquisition module is used for acquiring the meta information of the fact table field corresponding to the associated field identifier from a meta information table stored in a database according to the associated field identifier in the report configuration information;
the generating module is used for generating the associated field by utilizing data of the special attributes in the system corresponding to the plurality of first fields mapped by the meta-information according to the meta-information, wherein the associated field represents a field displayed by the business fact constructed according to the data of the plurality of first fields mapped by the meta-information;
and the summarizing module is used for generating a report by utilizing the first field and the associated field according to a summarizing rule in the report configuration information.
According to an aspect of the application, there is provided a computer readable storage medium having stored thereon program instructions, characterized in that the program instructions, when executed by a processor, implement the method of any of the above.
According to an aspect of the present application, there is provided an electronic device, comprising:
a processor; and
a memory for storing program instructions for the processor; wherein the processor is configured to perform any of the methods described above via execution of the program instructions.
According to the report generation method and the related device, when report configuration information input by a user is received, the report configuration information is analyzed and structured query statements are generated, the report configuration information defined by the user can be received and analyzed to obtain the structured query statements for obtaining basic data for making the report; acquiring a plurality of first fields from a database by using a structured query statement, wherein the first fields indicate data of special attributes in a system, so that basic data (data of special attributes) meeting user requirements are acquired; according to the associated field identification in the report configuration information, acquiring the meta information of the fact table field corresponding to the associated field identification from a meta information table stored in a database, wherein the associated field relates to information fact display in the report, the fact which a user wants to display can be indicated through the associated field identification, then acquiring the meta information of the fact table field corresponding to the associated field identification, and the information of the associated field can be indicated based on the meta information, namely the generation strategy of the associated field; then, according to the meta-information, generating the associated fields by using data of special attributes in the system corresponding to the plurality of first fields mapped by the meta-information, wherein the associated fields represent fields displayed by business facts constructed according to the data of the plurality of first fields mapped by the meta-information; and finally, generating a report by using the first field and the associated field according to a gathering rule in the report configuration information. By the method, the user-defined report configuration can be received, the first fields meeting the requirements are obtained by analyzing the report configuration information, then the meta information of the associated fields is obtained based on the associated field identification, the generation of the report associated fields corresponding to the user-defined report configuration is realized based on the meta information, and finally the personalized reports of various dimensions meeting the user report display requirements can be generated, so that the reliability of report generation is ensured, and the user experience is effectively improved.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the application.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and together with the description, serve to explain the principles of the application. It is obvious that the drawings in the following description are only some embodiments of the application, and that for a person skilled in the art, other drawings can be derived from them without inventive effort.
FIG. 1 schematically illustrates a flow chart of a report generation method.
Fig. 2 schematically shows an application scenario example of a report generation method.
FIG. 3 schematically illustrates another report generation method flow diagram.
Fig. 4 schematically shows a block diagram of a report generating apparatus.
Fig. 5 schematically illustrates an example block diagram of an electronic device for implementing the report generation method.
Fig. 6 schematically illustrates a computer-readable storage medium for implementing the report generation method described above.
Detailed Description
Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many different forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. In the following description, numerous specific details are provided to give a thorough understanding of embodiments of the application. One skilled in the relevant art will recognize, however, that the subject matter of the present application can be practiced without one or more of the specific details, or with other methods, components, devices, steps, and so forth. In other instances, well-known technical solutions have not been shown or described in detail to avoid obscuring aspects of the present application.
Furthermore, the drawings are merely schematic illustrations of the present application and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and thus their repetitive description will be omitted. Some of the block diagrams shown in the figures are functional entities and do not necessarily correspond to physically or logically separate entities. These functional entities may be implemented in the form of software, or in one or more hardware modules or integrated circuits, or in different networks and/or processor devices and/or microcontroller devices.
In the present exemplary embodiment, a report generating method is first provided, and the report generating method may be run on a server, or may be run on a server cluster or a cloud server, and the like. Referring to fig. 1, the report generation method may include the following steps:
step S110, when report configuration information input by a user is received, analyzing the report configuration information and generating a structured query statement;
step S120, acquiring a plurality of first fields from a database by using the structured query statement, wherein the first fields are used for representing data of special attributes in the system;
step S130, according to the associated field identification in the report configuration information, obtaining the meta information of the fact table field corresponding to the associated field identification from the meta information table stored in the database;
step S140, according to the meta-information, generating the associated field by using the data of the special attributes in the system corresponding to the plurality of first fields mapped by the meta-information, wherein the associated field represents a field displayed by the business fact constructed according to the data of the plurality of first fields mapped by the meta-information;
and S150, generating a report by using the first field and the associated field according to a gathering rule in the report configuration information.
Hereinafter, each step in the above report generation method in the present exemplary embodiment will be explained and explained in detail with reference to the drawings.
In step S110, when report configuration information input by a user is received, the report configuration information is parsed and a structured query statement is generated.
In the embodiment of the present example, referring to fig. 2, the server 201 receives the report configuration information input by the user from the user terminal 202, parses the report configuration information, and generates a structured query statement. In this way, in the subsequent steps, the server 201 may obtain the relevant data by using the structured query statement to generate the report. It is understood that, among other things, the server 201 may be any device with processing capability, such as a computer, a microprocessor, etc., and is not particularly limited herein; the user terminal 202 may be any terminal having an information entry function.
The report configuration information comprises accounts to be displayed in the report, business contents, summary rules and the like. The report configuration information can be customized by the user, for example, the user selects the account, the business content and the summary rule to be shown in the report in the U I interface, so as to realize the customized report configuration information. The report configuration information comprises data needing report display information, and the structured query statement for querying and acquiring the data of the report needed by the user can be constructed by taking the identifier of the needed data as the query condition of the structured query statement. For example, the background system analyzes and generates an SQL statement corresponding to field data in the query report according to the user report configuration information stored in the system, and sends the SQL statement to the database system.
In one embodiment, when report configuration information input by a user is received, parsing the report configuration information and generating a structured query statement includes:
when report configuration information input by a user is received, analyzing the report configuration information to obtain source data information of a configured report, wherein the source data information comprises a first field identifier;
and generating the structured query statement by taking the first field identification as a query condition.
The source data information required by the configured report can be obtained by analyzing the report configuration information, that is, the report configuration information input by the user is analyzed, all basic data (the basic data corresponding to the first field, in an example, the basic position data describing the position taken by a single account for a single ticket) required by making the report of the user is obtained, for example, by analyzing the display subject (account, ticket name, etc.) and the information display target in the report configuration information configured by the user, the identifiers of all the first fields meeting the display subject and the display target are obtained. The source data is stored in a database table so that the identification of the first field of the table (e.g., table name or row number, etc.) of all the stored source data is available. So with the first field identification as a structured query statement query condition, a structured query statement can be generated that can query the first field data.
In step S120, a plurality of first fields are obtained from the database by using the structured query statement, and the first fields are used for characterizing data of special attributes in the system.
In the embodiment of the present example, the first field is data representing a special attribute in the system, for example, basic position data describing the position taken by a single account for a single note. Each column in the database table is called a "field", and each field contains information of a certain topic. In the "address book" database, "name", "single volume", and "volume" are attributes common to all rows in the table, so these columns may be referred to as "name", "single volume", and "volume" fields. The data of the thematic attribute is the smallest unit constituting all kinds of data. Thus, by acquiring the first field, the minimum infrastructure unit data forming the report required by the user can be acquired, and further, other report production data is generated based on the first field in the subsequent steps.
In step S130, according to the associated field identifier in the report configuration information, the meta information of the fact table field corresponding to the associated field identifier is obtained from the meta information table stored in the database.
In the embodiment of the present example, the associated field identification is a field identification (e.g., identification of the expression field and identification of the proportion field, etc.) configured by the user and referring to the fact table field and intended to be shown in the report. The associated field relates to information fact display in the report, and the fact which the user wants to display can be indicated through the associated field identification; and then obtaining the meta information of the fact table field corresponding to the identification of the associated field, wherein the meta information can indicate the information of the associated field, namely the generation strategy of the associated field. The association field identifies, for example, the name or identification of the plurality of association fields. The meta information table may be a meta information table added to a data table field relating to system-related business fact data in the database for holding data table field meta information, for example, a meta information table added to a fact table field relating to position information in the database for holding fact table field meta information. Meta information is information about information for describing the structure, semantics, usage, and usage of information, etc.
By adding meta-information in advance to fields having a business fact (business presentation fact data, i.e., business fact data reflected by basic data) in all fields, the structure, semantics, usage, etc. of each business fact field under a specific presentation object can be preserved, and the meta-information can be represented by specific semantic string data.
After other fields are obtained through other field identifications except the identification of the first field in the report configuration information, the meta information matched with the identifications of the other fields is searched from the meta information table through the identifications of the other fields.
By acquiring the meta information of the information display table field corresponding to the content display information from the meta information table stored in the database, it can be ensured that the fact table field (associated field) corresponding to the content display information is accurately constructed by using each first field according to the meta information in the subsequent steps.
In one embodiment, acquiring, from a meta information table stored in a database, meta information of a fact table field corresponding to an associated field identifier according to the associated field identifier in the report configuration information includes:
acquiring the identification of the associated field in the report configuration information;
and acquiring the meta-information with the matched identification of the associated field from a meta-information table stored in a database.
The identifier of the associated field in the report configuration information is obtained, and the identifier of the associated field in the report configuration information can be determined by comparing the identifier of the preset associated field with the field identifier in the report configuration information. The association field needs to be generated by the other first field. The meta-information matching the identification of the other field can be searched from the meta-information table through the identification of the other field except the identification of the first field, which is included in the report configuration information.
In one embodiment, obtaining the meta information of the associated field with matching identifier, as shown in fig. 3, includes:
step S310, determining a plurality of meta-information matched with the identification of each associated field, wherein the meta-information corresponds to an information display target;
step S320, according to an information display target in the report configuration information, obtaining meta information corresponding to the information display target from the plurality of meta information, where the information display target is used to indicate a report usage purpose.
The meta information corresponding to the identification of the associated field in the meta information table may be multiple, and may indicate that one field needs to be configured with meta information in different information display targets, that is, different report usage purposes. That is, under different information presentation objects, a field corresponding to an information presentation object may be generated according to meta information of the object. Therefore, the user can further self-define the report display target and then generate reports under different targets.
In step S140, according to the meta information, the association field is generated by using the data of the special attribute in the system corresponding to the plurality of first fields mapped by the meta information, and the association field represents a field displayed by the business fact constructed according to the data of the plurality of first fields mapped by the meta information.
In the embodiment of the present example, the associated field is a field indicating a business fact display constructed according to the data of the first field, for example, an expression field constructed by a plurality of first fields or a proportion field of a proportion of a certain first field with respect to all data, etc. And generating associated fields by utilizing the data of the first fields according to the meta-information, namely, generating a plurality of first fields mapped according to the meta-information, acquiring data of a plurality of required first fields based on information such as the use, the usage and the like of the fields described by the meta-information, and calculating to obtain the associated fields according to the field usage described by the meta-information.
Therefore, the associated fields required by the user configuration can be accurately generated according to the user requirements based on the meta information.
In step S150, a report is generated by using the first field and the associated field according to the summary rule in the report configuration information.
In the embodiment of the present example, the summarization rule is a report method for summarizing each field into a specific style that can show all fields of the user display target, for example, data sum fields of all individuals can be summarized, and then report synthesis is performed. Various reports can be generated flexibly by configuring various summarizing rules in report configuration information by a user.
In this way, the user can customize the report display information of report display requirements of various dimensions according to the needs of the user, and the target report is obtained after summary by combining the associated field generated based on the meta information in the previous step and the first field meeting the summary rule based on the summary rule. After the user configures the report form, the user can see a new report form result immediately, so that the user experience is greatly improved, and a better information guarantee is provided for combination management.
In one embodiment, generating a report by using the first field and the associated field according to a summary rule in the report configuration information includes:
generating a summary field corresponding to each summary grammar by using the first field and the associated field of each summary grammar identifier in the summary rules according to the summary rules in the report configuration information;
and generating a report by utilizing the first field, the associated field and the summary field.
A summary field is a field that summarizes the various fields into a total data case that corresponds to all acquired fields, e.g., a field that summarizes the data of all individual fields into a total. In one example, the collected position taken data is position taken conditions after the basic position taken data is collected according to a collection rule, and the like.
Each summary grammar in the summary rule identifies the first fields and associated fields required for the summary, and the summary fields corresponding to each summary grammar can be generated by the summary grammar.
Then, the report is generated by using the first field, the associated field and the summary field which are needed by all configured reports, and all the fields are summarized and configured into the report.
In one embodiment, generating a report using the first field, the associated field, and the summary field includes:
acquiring the summary style of the first field, the associated field and the summary field from the report configuration information;
and generating a report by utilizing the first field, the associated field and the summary field according to the summary style.
The summary style may be user-selected or fixed. And configuring the first field, the associated field and the summary field according to a style rule to obtain a final report.
The application also provides a report generating device. Referring to fig. 4, the report generation apparatus includes:
the analysis module 410 is used for analyzing the report configuration information and generating a structured query statement when receiving the report configuration information input by a user;
the first obtaining module 420 is configured to obtain, from the database, a plurality of first fields by using the structured query statement, where the first fields are used to represent data of special attributes in the system;
the second obtaining module 430 is configured to obtain, according to the associated field identifier in the report configuration information, meta information of a fact table field corresponding to the associated field identifier from a meta information table stored in a database;
the generating module 440 is configured to generate the associated field according to the meta-information by using data of the special attribute in the system corresponding to the multiple first fields mapped by the meta-information, where the associated field represents a field displayed by a business fact constructed according to the data of the multiple first fields mapped by the meta-information;
the summarizing module 450 is configured to generate a report by using the first field and the associated field according to a summarizing rule in the report configuration information.
The details of each module in the report generating device have been described in detail in the corresponding report generating method, and therefore are not described herein again.
It should be noted that although in the above detailed description several modules or units of the device for action execution are mentioned, such a division is not mandatory. Indeed, the features and functionality of two or more modules or units described above may be embodied in one module or unit, according to embodiments of the application. Conversely, the features and functions of one module or unit described above may be further divided into embodiments by a plurality of modules or units.
Moreover, although the steps of the methods herein are depicted in the drawings in a particular order, this does not require or imply that the steps must be performed in this particular order, or that all of the depicted steps must be performed, to achieve desirable results. Additionally or alternatively, certain steps may be omitted, multiple steps combined into one step execution, and/or one step broken down into multiple step executions, etc.
Through the above description of the embodiments, those skilled in the art will readily understand that the exemplary embodiments described herein may be implemented by software, or by software in combination with necessary hardware. Therefore, the technical solution according to the embodiments of the present application can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (which can be a CD-ROM, a usb disk, a removable hard disk, etc.) or on a network, and includes several instructions to enable a computing device (which can be a personal computer, a server, a mobile terminal, or a network device, etc.) to execute the method according to the embodiments of the present application.
In an exemplary embodiment of the present application, there is also provided an electronic device capable of implementing the above method.
As will be appreciated by one skilled in the art, aspects of the present invention may be embodied as a system, method or program product. Thus, various aspects of the invention may be embodied in the form of: an entirely hardware embodiment, an entirely software embodiment (including firmware, microcode, etc.) or an embodiment combining hardware and software aspects that may all generally be referred to herein as a "circuit," module "or" system.
An electronic device 500 according to this embodiment of the invention is described below with reference to fig. 5. The electronic device 500 shown in fig. 5 is only an example and should not bring any limitation to the functions and the scope of use of the embodiments of the present invention.
As shown in fig. 5, the electronic device 500 is embodied in the form of a general purpose computing device. The components of the electronic device 500 may include, but are not limited to: the at least one processing unit 510, the at least one memory unit 520, and a bus 530 that couples various system components including the memory unit 520 and the processing unit 510.
Wherein the storage unit stores program code that is executable by the processing unit 510 to cause the processing unit 510 to perform steps according to various exemplary embodiments of the present invention as described in the above section "exemplary methods" of the present specification. For example, the processing unit 510 may perform the steps as shown in fig. 1.
The memory unit 520 may include a readable medium in the form of a volatile memory unit, such as a random access memory unit (RAM)5201 and/or a cache memory unit 5202, and may further include a read only memory unit (ROM) 5203.
The electronic device 500 may also communicate with one or more external devices 700 (e.g., keyboard, pointing device, bluetooth device, etc.), with one or more devices that enable a client to interact with the electronic device 500, and/or with any devices (e.g., router, modem, etc.) that enable the electronic device 500 to communicate with one or more other computing devices. Such communication may occur via input/output (I/O) interfaces 550. A display unit 540 connected to an input/output (I/O) interface 550 may also be included. Also, the electronic device 500 may communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network, such as the internet) via the network adapter 560. As shown, the network adapter 560 communicates with the other modules of the electronic device 500 over the bus 530. It should be appreciated that although not shown in the figures, other hardware and/or software modules may be used in conjunction with the electronic device 500, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAI D systems, tape drives, and data backup storage systems, etc.
Through the above description of the embodiments, those skilled in the art will readily understand that the exemplary embodiments described herein may be implemented by software, or by software in combination with necessary hardware. Therefore, the technical solution according to the embodiments of the present application can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (which can be a CD-ROM, a usb disk, a removable hard disk, etc.) or on a network, and includes several instructions to make a computing device (which can be a personal computer, a server, a terminal device, or a network device, etc.) execute the method according to the embodiments of the present application.
In an exemplary embodiment of the present application, there is also provided a computer-readable storage medium having stored thereon a program product capable of implementing the above-described method of the present specification. In some possible embodiments, aspects of the invention may also be implemented in the form of a program product comprising program code means for causing a terminal device to carry out the steps according to various exemplary embodiments of the invention described in the above section "exemplary methods" of the present description, when said program product is run on the terminal device.
Referring to fig. 6, a program product 600 for implementing the above method according to an embodiment of the present invention is described, which may employ a portable compact disc read only memory (CD-ROM) and include program code, and may be run on a terminal device, such as a personal computer. However, the program product of the present invention is not limited in this regard and, in the present document, a readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
The program product may employ any combination of one or more readable media. The readable medium may be a readable signal medium or a readable storage medium. A readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the readable storage medium include: an electrical connection having one or more wires, a portable disk, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
A computer readable signal medium may include a propagated data signal with readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A readable signal medium may also be any readable medium that is not a readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.
Program code embodied on a readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the client computing device, partly on the client device, as a stand-alone software package, partly on the client computing device and partly on a remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device may be connected to the client computing device over any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., over the internet using an internet service provider).
Furthermore, the above-described figures are merely schematic illustrations of processes involved in methods according to exemplary embodiments of the invention, and are not intended to be limiting. It will be readily understood that the processes shown in the above figures are not intended to indicate or limit the chronological order of the processes. In addition, it is also readily understood that these processes may be performed synchronously or asynchronously, e.g., in multiple modules.
Other embodiments of the present application will be apparent to those skilled in the art from consideration of the specification and practice of the invention disclosed herein. This application is intended to cover any variations, uses, or adaptations of the invention following, in general, the principles of the application and including such departures from the present disclosure as come within known or customary practice within the art to which the invention pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the application being indicated by the following claims.
Claims (10)
1. A report generation method is characterized by comprising the following steps:
when report configuration information input by a user is received, analyzing the report configuration information and generating a structured query statement;
acquiring a plurality of first fields from a database by using the structured query statement, wherein the first fields are used for representing data of special attributes in a system;
according to the associated field identification in the report configuration information, acquiring the meta information of the fact table field corresponding to the associated field identification from a meta information table stored in a database;
generating the association field by utilizing data of special attributes in the system corresponding to the plurality of first fields mapped by the meta-information according to the meta-information, wherein the association field represents a field displayed by a business fact constructed according to the data of the plurality of first fields mapped by the meta-information;
and generating a report by using the first field and the associated field according to a gathering rule in the report configuration information.
2. The method of claim 1, wherein when receiving user-entered report configuration information, parsing the report configuration information and generating a structured query statement comprises:
when report configuration information input by a user is received, analyzing the report configuration information to obtain source data information of a configured report, wherein the source data information comprises a first field identifier;
and generating the structured query statement by taking the first field identification as a query condition.
3. The method according to claim 1, wherein the obtaining, from a meta information table stored in a database, meta information of a fact table field corresponding to an associated field identifier according to the associated field identifier in the report configuration information includes:
acquiring the identification of the associated field in the report configuration information;
and acquiring the meta-information with the matched identification of the associated field from a meta-information table stored in a database.
4. The method of claim 3, wherein obtaining the meta-information that identifies the matching of the associated field comprises:
determining a plurality of meta-information matched with the identification of each associated field, wherein the meta-information corresponds to an information display target;
and according to an information display target in the report configuration information, acquiring meta information corresponding to the information display target from the plurality of meta information, wherein the information display target is used for indicating the use purpose of the report.
5. The method according to claim 1, wherein the generating, according to the meta-information, the associated field by using the data of the system-specific attribute corresponding to the plurality of first fields of the meta-information map, the associated field representing a field of a business fact display constructed according to the data of the plurality of first fields of the meta-information map, comprises:
acquiring a plurality of first fields of the meta-information mapping matched with the identification of the associated field;
and generating the associated field according to the field generation strategy of the meta-information based on the data of the special attributes in the system of the plurality of first fields mapped by the meta-information.
6. The method according to claim 1, wherein generating a report using the first field and the associated field according to the summary rule in the report configuration information comprises:
generating a summary field corresponding to each summary grammar by using the first field and the associated field of each summary grammar identifier in the summary rules according to the summary rules in the report configuration information;
and generating a report by utilizing the first field, the associated field and the summary field.
7. The method of claim 1, wherein generating a report using the first field, the associated field, and the summary field comprises:
acquiring the summary style of the first field, the associated field and the summary field from the report configuration information;
and generating a report by utilizing the first field, the associated field and the summary field according to the summary style.
8. A report generation apparatus, comprising:
the analysis module is used for analyzing the report configuration information and generating a structured query statement when the report configuration information input by a user is received;
the first acquisition module is used for acquiring a plurality of first fields from a database by using the structured query statement, wherein the first fields are used for representing data of special attributes in the system;
the second acquisition module is used for acquiring the meta information of the fact table field corresponding to the associated field identifier from a meta information table stored in a database according to the associated field identifier in the report configuration information;
the generating module is used for generating the associated field by utilizing data of the special attributes in the system corresponding to the plurality of first fields mapped by the meta-information according to the meta-information, wherein the associated field represents a field displayed by the business fact constructed according to the data of the plurality of first fields mapped by the meta-information;
and the summarizing module is used for generating a report by utilizing the first field and the associated field according to a summarizing rule in the report configuration information.
9. A computer readable storage medium having stored thereon program instructions, characterized in that the program instructions, when executed by a processor, implement the method of any of claims 1-7.
10. An electronic device, comprising:
a processor; and
a memory for storing program instructions for the processor; wherein the processor is configured to perform the method of any of claims 1-7 via execution of the program instructions.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911348730.XA CN111158795A (en) | 2019-12-24 | 2019-12-24 | Report generation method, device, medium and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911348730.XA CN111158795A (en) | 2019-12-24 | 2019-12-24 | Report generation method, device, medium and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111158795A true CN111158795A (en) | 2020-05-15 |
Family
ID=70558149
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911348730.XA Pending CN111158795A (en) | 2019-12-24 | 2019-12-24 | Report generation method, device, medium and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111158795A (en) |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111881660A (en) * | 2020-06-29 | 2020-11-03 | 金蝶医疗软件科技有限公司 | Report generation method and device, computer equipment and storage medium |
| CN112084762A (en) * | 2020-09-27 | 2020-12-15 | 中国建设银行股份有限公司 | Report template generation method and system |
| CN112216347A (en) * | 2020-09-14 | 2021-01-12 | 苏州创腾软件有限公司 | Scientific data genome processing method, device and storage medium |
| CN112364090A (en) * | 2020-11-03 | 2021-02-12 | 杭州数梦工场科技有限公司 | Data attribute display method and device and electronic equipment |
| CN112835881A (en) * | 2021-01-28 | 2021-05-25 | 山东浪潮通软信息科技有限公司 | Report generation method, system, equipment and medium |
| CN113095047A (en) * | 2021-04-12 | 2021-07-09 | 苏州创腾软件有限公司 | Experiment report generation method and device, computer equipment and storage medium |
| CN113342821A (en) * | 2021-06-29 | 2021-09-03 | 深圳前海微众银行股份有限公司 | Report configuration method, device, equipment and computer storage medium |
| CN113568915A (en) * | 2021-07-29 | 2021-10-29 | 中国工商银行股份有限公司 | Report generation method and device |
| CN113641881A (en) * | 2021-08-23 | 2021-11-12 | 北京字跳网络技术有限公司 | Metadata display method, device, equipment and medium |
| CN113779133A (en) * | 2021-03-26 | 2021-12-10 | 北京京东振世信息技术有限公司 | Data processing method, data processing apparatus, electronic device, storage medium, and program product |
| CN113792138A (en) * | 2021-09-14 | 2021-12-14 | 广东电网有限责任公司 | Report generation method and device, electronic equipment and storage medium |
| CN114356957A (en) * | 2021-11-30 | 2022-04-15 | 杭州贝嘟科技有限公司 | Report forming method and device, electronic equipment and computer readable storage medium |
| CN114579573A (en) * | 2022-03-03 | 2022-06-03 | 北京百度网讯科技有限公司 | Information retrieval method, information retrieval device, electronic equipment and storage medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050154756A1 (en) * | 2004-01-08 | 2005-07-14 | International Business Machines Corporation | Method of generating database transaction statements based on existing queries |
| US20050228679A1 (en) * | 2004-04-07 | 2005-10-13 | Alana King | Automated account statement generation process |
| US20150324423A1 (en) * | 2012-11-26 | 2015-11-12 | Zte Corporation | Report creation method, device and system |
| CN105989082A (en) * | 2015-02-10 | 2016-10-05 | 腾讯科技（深圳）有限公司 | Report view generation method and apparatus |
| CN109271411A (en) * | 2018-09-28 | 2019-01-25 | 中国平安财产保险股份有限公司 | Report form generation method, device, computer equipment and storage medium |
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
| CN109657214A (en) * | 2018-09-27 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Report form generation method, device, terminal and storage medium |
| CN110008232A (en) * | 2019-04-11 | 2019-07-12 | 北京启迪区块链科技发展有限公司 | Generation method, device, server and the medium of structured query sentence |
-
2019
- 2019-12-24 CN CN201911348730.XA patent/CN111158795A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050154756A1 (en) * | 2004-01-08 | 2005-07-14 | International Business Machines Corporation | Method of generating database transaction statements based on existing queries |
| US20050228679A1 (en) * | 2004-04-07 | 2005-10-13 | Alana King | Automated account statement generation process |
| US20150324423A1 (en) * | 2012-11-26 | 2015-11-12 | Zte Corporation | Report creation method, device and system |
| CN105989082A (en) * | 2015-02-10 | 2016-10-05 | 腾讯科技（深圳）有限公司 | Report view generation method and apparatus |
| CN109657214A (en) * | 2018-09-27 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Report form generation method, device, terminal and storage medium |
| CN109271411A (en) * | 2018-09-28 | 2019-01-25 | 中国平安财产保险股份有限公司 | Report form generation method, device, computer equipment and storage medium |
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
| CN110008232A (en) * | 2019-04-11 | 2019-07-12 | 北京启迪区块链科技发展有限公司 | Generation method, device, server and the medium of structured query sentence |
Non-Patent Citations (3)
| Title |
|---|
| FRED POPOWICH: "Interactive natural language query construction for report generation", INLG \'12: PROCEEDINGS OF THE SEVENTH INTERNATIONAL NATURAL LANGUAGE GENERATION CONFERENCE, 31 May 2012 (2012-05-31) * |
| 王湘舟, 李蓓智, 毛志敏: "面向用户的报表定制工具的研究与开发", 东华大学学报(自然科学版), no. 06, 31 December 2001 (2001-12-31) * |
| 黄荔;吕卫强;: "基于数据字典的通用报表处理系统", 兵工自动化, no. 07, 28 July 2006 (2006-07-28) * |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111881660A (en) * | 2020-06-29 | 2020-11-03 | 金蝶医疗软件科技有限公司 | Report generation method and device, computer equipment and storage medium |
| CN112216347A (en) * | 2020-09-14 | 2021-01-12 | 苏州创腾软件有限公司 | Scientific data genome processing method, device and storage medium |
| CN112084762A (en) * | 2020-09-27 | 2020-12-15 | 中国建设银行股份有限公司 | Report template generation method and system |
| CN112364090A (en) * | 2020-11-03 | 2021-02-12 | 杭州数梦工场科技有限公司 | Data attribute display method and device and electronic equipment |
| CN112835881A (en) * | 2021-01-28 | 2021-05-25 | 山东浪潮通软信息科技有限公司 | Report generation method, system, equipment and medium |
| CN113779133A (en) * | 2021-03-26 | 2021-12-10 | 北京京东振世信息技术有限公司 | Data processing method, data processing apparatus, electronic device, storage medium, and program product |
| CN113779133B (en) * | 2021-03-26 | 2024-05-17 | 北京京东振世信息技术有限公司 | Data processing method, device, electronic equipment, storage medium and program product |
| CN113095047A (en) * | 2021-04-12 | 2021-07-09 | 苏州创腾软件有限公司 | Experiment report generation method and device, computer equipment and storage medium |
| WO2023273073A1 (en) * | 2021-06-29 | 2023-01-05 | 深圳前海微众银行股份有限公司 | Report configuration method, apparatus and device, and computer storage medium |
| CN113342821A (en) * | 2021-06-29 | 2021-09-03 | 深圳前海微众银行股份有限公司 | Report configuration method, device, equipment and computer storage medium |
| CN113568915A (en) * | 2021-07-29 | 2021-10-29 | 中国工商银行股份有限公司 | Report generation method and device |
| CN113641881A (en) * | 2021-08-23 | 2021-11-12 | 北京字跳网络技术有限公司 | Metadata display method, device, equipment and medium |
| CN113792138B (en) * | 2021-09-14 | 2024-04-30 | 广东电网有限责任公司 | Report generation method and device, electronic equipment and storage medium |
| CN113792138A (en) * | 2021-09-14 | 2021-12-14 | 广东电网有限责任公司 | Report generation method and device, electronic equipment and storage medium |
| CN114356957A (en) * | 2021-11-30 | 2022-04-15 | 杭州贝嘟科技有限公司 | Report forming method and device, electronic equipment and computer readable storage medium |
| CN114579573A (en) * | 2022-03-03 | 2022-06-03 | 北京百度网讯科技有限公司 | Information retrieval method, information retrieval device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111158795A (en) | Report generation method, device, medium and electronic equipment | |
| US10204151B2 (en) | Syntactic tagging in a domain-specific context | |
| US10169471B2 (en) | Generating and executing query language statements from natural language | |
| WO2018000998A1 (en) | Interface generation method, apparatus and system | |
| US9047346B2 (en) | Reporting language filtering and mapping to dimensional concepts | |
| CN108776696B (en) | Node configuration method and device, storage medium and electronic equipment | |
| US10303689B2 (en) | Answering natural language table queries through semantic table representation | |
| CN111026931B (en) | Data query method, device, equipment and medium | |
| CN109524070B (en) | Data processing method and device, electronic equipment and storage medium | |
| US20140280284A1 (en) | Pivot facets for text mining and search | |
| CN111709527A (en) | Operation and maintenance knowledge map library establishing method, device, equipment and storage medium | |
| CN112711581A (en) | Medical data verification method and device, electronic equipment and storage medium | |
| CN111125555B (en) | Enterprise information acquisition method and device | |
| CN113419740B (en) | Program data stream analysis method and device, electronic equipment and readable storage medium | |
| CN111078729A (en) | Medical data tracing method, device, system, storage medium and electronic equipment | |
| CN109885610A (en) | A kind of abstracting method of structural data, device, electronic equipment and storage medium | |
| CN114564930A (en) | Document information integration method, apparatus, device, medium, and program product | |
| CN116594683A (en) | Code annotation information generation method, device, equipment and storage medium | |
| US11487801B2 (en) | Dynamic data visualization from factual statements in text | |
| CN115599386A (en) | Code generation method, device, equipment and storage medium | |
| CN113792138B (en) | Report generation method and device, electronic equipment and storage medium | |
| CN112559914A (en) | Index data display method and device | |
| US12050634B2 (en) | Method and apparatus for distributing content across platforms, device and storage medium | |
| CN117009397A (en) | Data query method, data query device, electronic equipment and storage medium | |
| CN115982199A (en) | Data query method, server, device and storage medium |
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 |