CN111708801A - Report generation method and device and electronic equipment - Google Patents
Report generation method and device and electronic equipment Download PDFInfo
- Publication number
- CN111708801A CN111708801A CN202010479472.5A CN202010479472A CN111708801A CN 111708801 A CN111708801 A CN 111708801A CN 202010479472 A CN202010479472 A CN 202010479472A CN 111708801 A CN111708801 A CN 111708801A
- Authority
- CN
- China
- Prior art keywords
- field
- service
- user
- service field
- data table
- 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/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/248—Presentation of query results
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/14—Tree-structured documents
Abstract
The invention relates to a report generation method and device and electronic equipment, and relates to the technical field of data processing. The method comprises the following steps: displaying at least one service field to a first user, wherein the service field is preset based on a service scene, and a first incidence relation exists between the service field and a data table field in a database; responding to the selection operation of the first user, and determining a target business field from the displayed business fields; and generating a report according to the target service field and the first association relation. The method ensures that the user does not need to care about the technical metadata, reduces the report generation threshold and improves the report generation efficiency.
Description
Technical Field
The present disclosure relates to the field of data processing technologies, and in particular, to a report generation method, a report generation apparatus, and an electronic device.
Background
The database report is a form of visually displaying results (expression forms are characters, tables, graphs and the like) by analyzing and integrating original data.
In the related art, reports are usually generated based on metadata information of a database (data used by a data warehouse designer and manager for developing and daily managing the data warehouse, which may also be referred to as technical metadata). For example, a data analyst puts forward a visual report requirement according to a service, and then a developer writes a corresponding Structured Query Language (SQL) to query data in a database, and then executes the SQL in real-time or at regular time to calculate report data for the data analyst to use. For another example, in a simple visualization platform, a data analyst writes a report SQL through an SQL editor, and performs configuration on-line or timed execution through the platform to calculate report data for the data analyst to use. For another example, in a graphical visualization platform, a data analyst customizes technical metadata used by a report in a graphical editing tool in a dragging manner, the platform automatically converts the defined report into executable SQL, and the platform can configure real-time or timed execution to calculate report data for the data analyst to use.
The above report generation methods all require data analysts to construct query statements based on technical metadata, and require the data analysts to have deep knowledge of the original metadata information, so that the report generation has a higher threshold.
Therefore, a new technical solution for generating reports is needed.
Disclosure of Invention
An object of the present disclosure is to provide a new technical solution for generating reports.
According to a first aspect of the present invention, there is provided a report generating method, including:
displaying at least one service field to a first user, wherein the service field is preset based on a service scene, and a first incidence relation exists between the service field and a data table field in a database;
responding to the selection operation of a first user, and determining a target business field from the displayed business fields;
and generating the report according to the target service field and the first association relation.
Optionally, the service field is divided into at least one hierarchy, and a second association relationship exists between the service fields of different hierarchies;
the presenting at least one service field to the first user includes:
determining a tree structure representing the hierarchical relationship among the service fields according to the second incidence relationship, wherein nodes of the tree structure correspond to the service fields, and edges of the tree structure correspond to the second incidence relationship;
and displaying the service field based on the tree structure.
Optionally, the generating the report according to the target service field and the first association relationship includes:
determining a data table field corresponding to the target service field as a target data table field according to the target service field and the first incidence relation;
and generating the report according to the target data table field.
Optionally, the generating the report according to the target data table field includes:
constructing a query statement according to the target data table field;
and acquiring a query result corresponding to the query statement to obtain the report.
Optionally, a third association relationship also exists between different data tables corresponding to different data table fields;
constructing a query statement according to the target data table field, including:
and constructing a query statement for performing association query on the plurality of data tables according to the third association relation.
Optionally, the service field is set by:
receiving a hierarchy name input by a second user;
receiving a service field input by a second user under the hierarchy name, wherein the service field is used as a service field corresponding to the hierarchy name;
receiving a corresponding relation between the service field and a data table field set by a second user to obtain the first association relation;
and receiving the corresponding relation between different hierarchical names set by a second user to obtain the second association relation.
Optionally, each of the service fields corresponds to a draggable component in the display interface;
the step of determining a target service field from the displayed service fields in response to the selection operation of the first user comprises the following steps:
and in response to the operation that the first user drags the draggable component to the specific area, taking the service field corresponding to the draggable component in the specific area as the target service field.
According to a second aspect of the present invention, there is provided a report generation apparatus, including:
the display module is used for displaying at least one service field to a first user, wherein the service field is preset based on a service scene, and a first incidence relation exists between the service field and a data table field in a database;
the determining module is used for responding to the selection operation of the first user and determining a target business field from the displayed business fields;
and the generating module is used for generating the report according to the target service field and the first incidence relation.
According to a third aspect of the present invention, there is provided an electronic device comprising a processor and a memory, the memory storing machine executable instructions executable by the processor, the processor executing the machine executable instructions to implement the report generation method according to the first aspect of the present invention.
According to a fourth aspect of the present invention, there is provided a computer-readable storage medium storing machine-executable instructions which, when executed by a processor, implement the report generation method according to the first aspect of the present invention.
The report generation method in the embodiment displays the service field to the user, acquires the target service field selected by the user, and queries data according to the first association relationship between the service field and the data table field to generate the report, so that the user does not need to care about technical metadata, the report generation threshold is reduced, and the report generation efficiency is improved.
Other features of the present disclosure and advantages thereof will become apparent from the following detailed description of exemplary embodiments thereof, which proceeds with reference to the accompanying drawings.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of the specification, illustrate embodiments of the disclosure and together with the description, serve to explain the principles of the disclosure.
FIG. 1 is a schematic diagram of an electronic device that may be used to implement embodiments of the present disclosure.
FIG. 2 is a flowchart of a report generation method according to an embodiment of the present disclosure.
Fig. 3 is a first diagram of a traffic field according to an embodiment of the present invention.
Fig. 4 is a second diagram of a traffic field according to an embodiment of the present invention.
Fig. 5 is a schematic diagram of a traffic hierarchy according to an embodiment of the present invention.
Fig. 6 is a schematic diagram of a specific example of the implementation of the report generation method in the present embodiment.
Detailed Description
Various exemplary embodiments of the present disclosure will now be described in detail with reference to the accompanying drawings. It should be noted that: the relative arrangement of the components and steps, the numerical expressions, and numerical values set forth in these embodiments do not limit the scope of the present disclosure unless specifically stated otherwise.
The following description of at least one exemplary embodiment is merely illustrative in nature and is in no way intended to limit the disclosure, its application, or uses.
Techniques, methods, and apparatus known to those of ordinary skill in the relevant art may not be discussed in detail, but are intended to be part of the specification where appropriate.
In all examples shown and discussed herein, any particular value should be construed as merely illustrative, and not limiting. Thus, other examples of the exemplary embodiments may have different values.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, further discussion thereof is not required in subsequent figures.
< hardware configuration >
Fig. 1 illustrates a hardware configuration of an electronic device that can be used to implement embodiments of the present disclosure.
Referring to fig. 1, an electronic device 1000 includes a processor 1100, a memory 1200, an interface device 1300, a communication device 1400, a display device 1500, and an input device 1600. The processor 1100 may be, for example, a central processing unit CPU, a micro control unit MCU, or the like. The memory 1200 includes, for example, a ROM (read only memory), a RAM (random access memory), a nonvolatile memory such as a hard disk, and the like. The interface device 1300 includes, for example, a USB interface, a serial interface, and the like. The communication device 1400 is, for example, a wired network card or a wireless network card. The display device 1500 is, for example, a liquid crystal display panel. The input device 1600 includes, for example, a touch screen, a keyboard, a mouse, a microphone, and the like.
In an embodiment applied to this description, the memory 1200 of the electronic device 1000 is used to store instructions for controlling the processor 1100 to operate in support of implementing a method according to any embodiment of this description. Those skilled in the art can design instructions in accordance with the teachings disclosed herein. How the instructions control the operation of the processor is well known in the art and will not be described in detail herein.
It should be understood by those skilled in the art that although a plurality of devices of the electronic apparatus 1000 are shown in fig. 1, the electronic apparatus 1000 of the embodiments of the present specification may refer to only some of the devices, for example, only the processor 1100, the memory 1200 and the communication device 1400.
The electronic device 1000 shown in fig. 1 is, for example, a terminal device for providing data inquiry.
The hardware configuration shown in fig. 1 is merely illustrative and is in no way intended to limit the present disclosure, its application, or uses.
< method examples >
The embodiment provides a report generation method, which is implemented by the electronic device 1000 shown in fig. 1, for example.
As shown in fig. 2, the method includes the following steps S1100-S1300.
In step S1100, at least one service field is presented to a first user, where the service field is preset based on a service scenario, and the service field has a first association relationship with a data table field in a database.
In this embodiment, the business field (or referred to as business metadata) is data representing various attributes and concepts in the enterprise environment by information such as business name, definition, description, and the like.
In this embodiment, the first user is, for example, a data analyst.
In one example, the traffic fields may include a "hierarchy" attribute, i.e., each traffic field corresponds to a hierarchy. There is a high-low score between different levels.
Fig. 3 is a first diagram of a traffic field according to an embodiment of the present invention. FIG. 3 illustrates a plurality of business fields of a financial industry, a bank, a security, an A bank, a B bank, a customer name, a deposit amount, a sponsor, etc. Each business field corresponds to a specific level, for example, the financial industry corresponds to a first level, banks and securities correspond to a second level, banks A and B correspond to a third level, and the customer name, the deposit amount and the sponsor correspond to a fourth level. The first level, the second level, the third level and the fourth level are arranged among the levels from high to low in sequence. Each level has a corresponding level name, e.g., the name of the first level is "level one sort", the name of the second level is "level two sort", the name of the third level is "level three sort", and the name of the fourth level is "data item".
In this embodiment, a first association relationship exists between a service field and a data table field. The data table field is a field part of a data table in the database, and can also be called technical metadata.
Fig. 4 is a second diagram of a traffic field according to an embodiment of the present invention. As shown in fig. 4, there is a first association between the service field "customer name" and the data table field "field I" (denoted as "customer name-field I"), a first association between the service field "deposit amount" and the data table field "field II" (denoted as "deposit amount-field II"), and a first association between the service field "sponsor" and the data table field "field III" (denoted as "sponsor-field III"), where "field I" is a field in data table X, "field II" is a field in data table Y, and "field III" is a field in data table Z.
In one example, the service field is divided into at least one hierarchy level, and a second association relationship exists between the service fields of different hierarchy levels. For example, in the example shown in fig. 3, a second association relationship (denoted as "financial industry-bank") exists between the "financial industry" of the first hierarchy and the "bank" of the second hierarchy, a second association relationship (denoted as "financial industry-security") also exists between the "financial industry" of the first hierarchy and the "security" of the second hierarchy, a second association relationship (denoted as "bank-a bank") also exists between the "bank" of the second hierarchy and the "a bank" of the third hierarchy, a second association relationship (denoted as "a bank-client name") also exists between the "a bank" of the third hierarchy and the "client name" of the fourth hierarchy, and so on. The second association has directivity in a direction from the business field as a start point to the business field as an end point, for example, the direction of the second association "financial industry-bank" is from "financial industry" to "bank".
In one example, step S1100 further includes: determining a tree structure representing the hierarchical relationship among the service fields according to the second incidence relationship, wherein nodes of the tree structure correspond to the service fields, and edges of the tree structure correspond to the second incidence relationship; and displaying the service field according to the tree structure.
In the above tree structure, the node corresponds to the service field, and the edge corresponds to the first association relationship. The process of obtaining the tree structure is, for example: first, a node corresponding to each business field is established, and the positions of the nodes are arranged according to the level of the business field, and then, an edge is established between the nodes according to a first association relationship, for example, in the example shown in fig. 3, an edge is established between a node corresponding to the financial industry and a node corresponding to the bank according to the first association relationship, "financial industry-bank," so as to obtain a tree structure. The tree structure in fig. 3 is an example.
In step S1200, in response to a selection operation of the first user, a target service field is determined from the presented service fields.
In one example, each of the business fields corresponds to a draggable component in the display interface. Step S1200 further includes: and in response to the operation that the first user drags the draggable component to the specific area, taking the service field corresponding to the draggable component in the specific area as the target service field. For example, in the example shown in fig. 4, assuming that the first user drags the draggable components corresponding to the "customer name" and the "deposit amount" from the candidate area to the target area, the "customer name" and the "deposit amount" are determined as the target business fields.
In the above example, the selection of the target business field is realized by dragging the component, so that the report generation operation is more intuitive, convenient and fast
In step S1300, the report is generated according to the target service field and the first association relationship.
In one example, step S1300 further includes: determining a data table field corresponding to the target service field as a target data table field according to the target service field and the first incidence relation; and generating the report according to the target data table field. For example, in the example shown in fig. 4, assuming that the target service fields selected by the user are "customer name" and "deposit amount", the corresponding target data table fields are "field I" and "field II" as known from the second association "customer name-field I" and the second association "deposit amount-field II". Since the data table fields belong to the technical metadata, reports can be further generated accordingly.
In one example, generating a report based on the target data table fields includes: constructing a query statement according to the field of the target data table; and acquiring a query result corresponding to the query statement to obtain a report. For example, substituting a target data table field into a preset query statement template to obtain a query statement based on the target data table field, and obtaining a query result through the query statement to obtain a report.
In one example, a third association relationship exists between different data tables corresponding to different data table fields. In the example shown in fig. 4, "field I" is a field in data table X, "field II" is a field in data table Y, "field III" is a field in data table Z, and the third association is, for example, an association between data table X and data table Y. The association relationship between the data table X and the data table Y is, for example, that the field Id _1 in the data table X is equal to the field Id _2 in the data table Y. It should be noted that the association relationship between the data table X and the data table Y is not limited to the case where the fields of the two data tables have an equal relationship, and may also be the case where the fields of the two data tables have a greater relationship, a smaller relationship, or the like.
In the above example, on the basis of the third association relationship, the process of constructing the query statement according to the target data table field includes: and constructing a query statement for performing association query on the plurality of data tables according to the third association relation. The association query is, for example, a JOIN query statement to associate two data tables. Therefore, the third association relation is applied to the query stage, can be defined according to the service requirement, and cannot affect the actual configuration of the physical layer of the data table.
The report generation method in the embodiment displays the service field to the user, acquires the target service field selected by the user, and queries data according to the first association relationship between the service field and the data table field to generate the report, so that the user does not need to care about technical metadata, the report generation threshold is reduced, and the report generation efficiency is improved.
In one example, the traffic field is set by: receiving a hierarchy name input by a second user; receiving a service field input by a second user under the hierarchy name, wherein the service field is used as a service field corresponding to the hierarchy name; receiving a corresponding relation between the service field and a data table field set by a second user to obtain the first association relation; and receiving the corresponding relation between different hierarchical names set by a second user to obtain the second association relation.
In this embodiment, the second user is, for example, a developer of the data query system (usually different from a data analyst).
Fig. 5 shows a schematic diagram of a traffic hierarchy according to an embodiment of the invention. As shown in fig. 5, a developer (generally distinct from a data analyst) can set business hierarchies, including setting business hierarchy names (e.g., primary, secondary, tertiary, data items, etc.) and setting business hierarchy relationships between different business hierarchy names. Wherein the service level relation has directionality, e.g. from a high level to a low level. The business hierarchy in fig. 4 includes first class-second class, second class-third class, and third class-data item, and the directionality of the business hierarchy is represented by the arrow direction in fig. 5.
After the service level setting is completed, the service field setting system may provide an entry for inputting a service field to the second user under each service level name, and use the service field input by the second user through the entry as the service field corresponding to the service level. And providing an entrance for inputting the service field and the data table field for the second user, and obtaining a first association relation according to the service field and the data table field input by the second user through the entrance. And under each hierarchical relationship, providing an input entry for inputting a relationship starting point (or called a source) and a relationship ending point (or called a destination) to the second user, and obtaining a second association relationship according to the relationship starting point and the relationship ending point input by the second user through the entry. The method accords with the logic process of business modeling, and the technical metadata is set according to the sequence from abstraction to concrete, thereby being beneficial to avoiding omission.
A specific example of the implementation of the report generation method in this embodiment is provided below. As shown in fig. 6, first, a developer defines a service hierarchy (service meta-model), a service field (service meta-data), a service hierarchy relationship, and various association relationships in sequence at a data management service metadata level. Secondly, displaying a visual component corresponding to the service metadata in a visual platform, selecting specific service metadata by a data analyst through dragging operation, determining corresponding technical metadata by a background according to the incidence relation between the service metadata and the data metadata, constructing an inquiry statement according to the incidence relation between the technical metadata to generate a report, and finishing the process of defining the report through the service metadata.
< apparatus embodiment >
The embodiment provides a report generation device, which comprises a display module, a determination module and a generation module.
The display module is used for displaying at least one service field to a first user, wherein the service field is preset based on a service scene, and a first incidence relation exists between the service field and a data table field in a database.
And the determining module is used for responding to the selection operation of the first user and determining a target service field from the displayed service fields.
And the generating module is used for generating the report according to the target service field and the first incidence relation.
In one example, the presentation module is further configured to: determining a tree structure representing the hierarchical relationship among the service fields according to the second incidence relationship, wherein nodes of the tree structure correspond to the service fields, and edges of the tree structure correspond to the second incidence relationship; and displaying the service field based on the tree structure.
In one example, the generation module includes an acquisition unit and a generation unit. The obtaining unit is used for determining a data table field corresponding to the target service field according to the target service field and the first incidence relation, and the data table field is used as a target data table field. The generating unit is used for generating the report according to the target data table field.
In one example, the generation unit is further configured to: constructing a query statement according to the target data table field; and acquiring a query result corresponding to the query statement to obtain the report.
In one example, a third association relationship exists between different data tables corresponding to different data table fields. The generation unit is further configured to: and constructing a query statement for performing association query on the plurality of data tables according to the third association relation.
In one example, the apparatus further includes a traffic field setting unit configured to: receiving a hierarchy name input by a second user; receiving a service field input by a second user under the hierarchy name, wherein the service field is used as a service field corresponding to the hierarchy name; receiving a corresponding relation between the service field and a data table field set by a second user to obtain the first association relation; and receiving the corresponding relation between different hierarchical names set by a second user to obtain the second association relation.
In one example, each of the business fields corresponds to a draggable component in the display interface. The determination module is to: and in response to the operation that the first user drags the draggable component to the specific area, taking the service field corresponding to the draggable component in the specific area as the target service field.
< electronic device embodiment >
The present embodiment provides an electronic device including a processor and a memory. The memory stores machine executable instructions capable of being executed by the processor, and the processor executes the machine executable instructions to implement the report generation method described in the embodiment of the method of the invention.
The present disclosure may be systems, methods, and/or computer program products. The computer program product may include a computer-readable storage medium having computer-readable program instructions embodied thereon for causing a processor to implement various aspects of the present disclosure.
The computer readable storage medium may be a tangible device that can hold and store the instructions for use by the instruction execution device. The computer readable storage medium may be, for example, but not limited to, an electronic memory device, a magnetic memory device, an optical memory device, an electromagnetic memory device, a semiconductor memory device, or any suitable combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a Static Random Access Memory (SRAM), a portable compact disc read-only memory (CD-ROM), a Digital Versatile Disc (DVD), a memory stick, a floppy disk, a mechanical coding device, such as punch cards or in-groove projection structures having instructions stored thereon, and any suitable combination of the foregoing. Computer-readable storage media as used herein is not to be construed as transitory signals per se, such as radio waves or other freely propagating electromagnetic waves, electromagnetic waves propagating through a waveguide or other transmission medium (e.g., optical pulses through a fiber optic cable), or electrical signals transmitted through electrical wires.
The computer-readable program instructions described herein may be downloaded from a computer-readable storage medium to a respective computing/processing device, or to an external computer or external storage device via a network, such as the internet, a local area network, a wide area network, and/or a wireless network. The network may include copper transmission cables, fiber optic transmission, wireless transmission, routers, firewalls, switches, gateway computers and/or edge servers. The network adapter card or network interface in each computing/processing device receives computer-readable program instructions from the network and forwards the computer-readable program instructions for storage in a computer-readable storage medium in the respective computing/processing device.
The computer program instructions for carrying out operations of the present disclosure may be assembler instructions, Instruction Set Architecture (ISA) instructions, machine-related instructions, microcode, firmware instructions, state setting data, or source code or object code written in any combination of one or more programming languages, including an object oriented programming language such as Smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The computer-readable program instructions may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider). In some embodiments, the electronic circuitry that can execute the computer-readable program instructions implements aspects of the present disclosure by utilizing the state information of the computer-readable program instructions to personalize the electronic circuitry, such as a programmable logic circuit, a Field Programmable Gate Array (FPGA), or a Programmable Logic Array (PLA).
Various aspects of the present disclosure are described herein with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the disclosure. It will be understood that each block of the flowchart illustrations and/or block diagrams, and combinations of blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer-readable program instructions.
These computer-readable program instructions may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions/acts specified in the flowchart and/or block diagram block or blocks. These computer-readable program instructions may also be stored in a computer-readable storage medium that can direct a computer, programmable data processing apparatus, and/or other devices to function in a particular manner, such that the computer-readable medium storing the instructions comprises an article of manufacture including instructions which implement the function/act specified in the flowchart and/or block diagram block or blocks.
The computer readable program instructions may also be loaded onto a computer, other programmable data processing apparatus, or other devices to cause a series of operational steps to be performed on the computer, other programmable apparatus or other devices to produce a computer implemented process such that the instructions which execute on the computer, other programmable apparatus or other devices implement the functions/acts specified in the flowchart and/or block diagram block or blocks.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of instructions, which comprises one or more executable instructions for implementing the specified logical function(s). In some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions. It is well known to those skilled in the art that implementation by hardware, by software, and by a combination of software and hardware are equivalent.
Having described embodiments of the present disclosure, the foregoing description is intended to be exemplary, not exhaustive, and not limited to the disclosed embodiments. Many modifications and variations will be apparent to those of ordinary skill in the art without departing from the scope and spirit of the described embodiments. The terminology used herein is chosen in order to best explain the principles of the embodiments, the practical application, or improvements made to the technology in the marketplace, or to enable others of ordinary skill in the art to understand the embodiments disclosed herein. The scope of the present disclosure is defined by the appended claims.
Claims (10)
1. A report generation method is characterized by comprising the following steps:
displaying at least one service field to a first user, wherein the service field is preset based on a service scene, and a first incidence relation exists between the service field and a data table field in a database;
responding to the selection operation of a first user, and determining a target business field from the displayed business fields;
and generating the report according to the target service field and the first association relation.
2. The method of claim 1, wherein the service field is divided into at least one hierarchy level, and a second association relationship exists between the service fields of different hierarchy levels;
the presenting at least one service field to the first user includes:
determining a tree structure representing the hierarchical relationship among the service fields according to the second incidence relationship, wherein nodes of the tree structure correspond to the service fields, and edges of the tree structure correspond to the second incidence relationship;
and displaying the service field based on the tree structure.
3. The method according to claim 1, wherein said generating the report according to the target service field and the first association relationship comprises:
determining a data table field corresponding to the target service field as a target data table field according to the target service field and the first incidence relation;
and generating the report according to the target data table field.
4. The method of claim 3, wherein generating the report according to the target data table field comprises:
constructing a query statement according to the target data table field;
and acquiring a query result corresponding to the query statement to obtain the report.
5. The method according to claim 4, wherein a third association relationship exists between different data tables corresponding to different data table fields;
constructing a query statement according to the target data table field, including:
and constructing a query statement for performing association query on the plurality of data tables according to the third association relation.
6. The method of claim 2, wherein the traffic field is set by:
receiving a hierarchy name input by a second user;
receiving a service field input by a second user under the hierarchy name, wherein the service field is used as a service field corresponding to the hierarchy name;
receiving a corresponding relation between the service field and a data table field set by a second user to obtain the first association relation;
and receiving the corresponding relation between different hierarchical names set by a second user to obtain the second association relation.
7. The method of claim 1, wherein each of the business fields corresponds to a draggable component in a display interface;
the step of determining a target service field from the displayed service fields in response to the selection operation of the first user comprises the following steps:
and in response to the operation that the first user drags the draggable component to the specific area, taking the service field corresponding to the draggable component in the specific area as the target service field.
8. A report generation apparatus, comprising:
the display module is used for displaying at least one service field to a first user, wherein the service field is preset based on a service scene, and a first incidence relation exists between the service field and a data table field in a database;
the determining module is used for responding to the selection operation of the first user and determining a target business field from the displayed business fields;
and the generating module is used for generating the report according to the target service field and the first incidence relation.
9. An electronic device comprising a processor and a memory, the memory storing machine executable instructions executable by the processor, the processor executing the machine executable instructions to implement the report generating method according to any of claims 1-7.
10. A computer-readable storage medium having stored thereon machine-executable instructions which, when executed by a processor, implement the report generation method according to any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010479472.5A CN111708801A (en) | 2020-05-29 | 2020-05-29 | Report generation method and device and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010479472.5A CN111708801A (en) | 2020-05-29 | 2020-05-29 | Report generation method and device and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111708801A true CN111708801A (en) | 2020-09-25 |
Family
ID=72537425
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010479472.5A Pending CN111708801A (en) | 2020-05-29 | 2020-05-29 | Report generation method and device and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111708801A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112416342A (en) * | 2020-11-04 | 2021-02-26 | 杭州讯酷科技有限公司 | UI (user interface) quick construction method based on associated fields |
| CN112487282A (en) * | 2020-11-04 | 2021-03-12 | 山东中创软件商用中间件股份有限公司 | Business processing condition monitoring method and device, electronic equipment and storage medium |
| CN113065920A (en) * | 2021-04-12 | 2021-07-02 | 北京京东振世信息技术有限公司 | Data processing method and system |
| CN113158635A (en) * | 2021-04-30 | 2021-07-23 | 中国工商银行股份有限公司 | Electronic report generation method and device |
| CN113157707A (en) * | 2021-05-20 | 2021-07-23 | 国网信息通信产业集团有限公司 | Irregular report generation method and system |
| CN113515332A (en) * | 2021-04-22 | 2021-10-19 | 北京京东振世信息技术有限公司 | Data generation method, device, equipment and storage medium |
| CN114610723A (en) * | 2022-03-29 | 2022-06-10 | 李锐 | Data processing method and system based on artificial intelligence and cloud platform |
| WO2023001281A1 (en) * | 2021-07-23 | 2023-01-26 | 北京字跳网络技术有限公司 | Table data processing method and apparatus, terminal, and storage medium |
| CN116781789A (en) * | 2023-05-09 | 2023-09-19 | 天云融创数据科技（北京）有限公司 | API service generation method and device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102591952A (en) * | 2011-12-28 | 2012-07-18 | 用友软件股份有限公司 | Data query device and data query method based on semanteme |
| CN107908657A (en) * | 2017-10-17 | 2018-04-13 | 平安科技（深圳）有限公司 | Querying method, device, computer equipment and the storage medium of bordereau |
| CN109766338A (en) * | 2018-11-28 | 2019-05-17 | 杭州云为科技有限公司 | Self-defined report design method, electronic equipment, storage medium and system |
| CN110750969A (en) * | 2019-09-29 | 2020-02-04 | 北京东软望海科技有限公司 | Method and device for generating report |
-
2020
- 2020-05-29 CN CN202010479472.5A patent/CN111708801A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102591952A (en) * | 2011-12-28 | 2012-07-18 | 用友软件股份有限公司 | Data query device and data query method based on semanteme |
| CN107908657A (en) * | 2017-10-17 | 2018-04-13 | 平安科技（深圳）有限公司 | Querying method, device, computer equipment and the storage medium of bordereau |
| CN109766338A (en) * | 2018-11-28 | 2019-05-17 | 杭州云为科技有限公司 | Self-defined report design method, electronic equipment, storage medium and system |
| CN110750969A (en) * | 2019-09-29 | 2020-02-04 | 北京东软望海科技有限公司 | Method and device for generating report |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112416342A (en) * | 2020-11-04 | 2021-02-26 | 杭州讯酷科技有限公司 | UI (user interface) quick construction method based on associated fields |
| CN112487282A (en) * | 2020-11-04 | 2021-03-12 | 山东中创软件商用中间件股份有限公司 | Business processing condition monitoring method and device, electronic equipment and storage medium |
| CN113065920A (en) * | 2021-04-12 | 2021-07-02 | 北京京东振世信息技术有限公司 | Data processing method and system |
| CN113515332A (en) * | 2021-04-22 | 2021-10-19 | 北京京东振世信息技术有限公司 | Data generation method, device, equipment and storage medium |
| CN113515332B (en) * | 2021-04-22 | 2023-09-05 | 北京京东振世信息技术有限公司 | Data generation method, device, equipment and storage medium |
| CN113158635A (en) * | 2021-04-30 | 2021-07-23 | 中国工商银行股份有限公司 | Electronic report generation method and device |
| CN113158635B (en) * | 2021-04-30 | 2024-01-30 | 中国工商银行股份有限公司 | Electronic report generation method and device |
| CN113157707A (en) * | 2021-05-20 | 2021-07-23 | 国网信息通信产业集团有限公司 | Irregular report generation method and system |
| WO2023001281A1 (en) * | 2021-07-23 | 2023-01-26 | 北京字跳网络技术有限公司 | Table data processing method and apparatus, terminal, and storage medium |
| CN114610723A (en) * | 2022-03-29 | 2022-06-10 | 李锐 | Data processing method and system based on artificial intelligence and cloud platform |
| CN116781789A (en) * | 2023-05-09 | 2023-09-19 | 天云融创数据科技（北京）有限公司 | API service generation method and device |
| CN116781789B (en) * | 2023-05-09 | 2024-02-23 | 天云融创数据科技（北京）有限公司 | API service generation method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111708801A (en) | Report generation method and device and electronic equipment | |
| US10936668B2 (en) | Systems and methods for querying databases | |
| US11966419B2 (en) | Systems and methods for combining data analyses | |
| CN111177231A (en) | Report generation method and report generation device | |
| US20120159359A1 (en) | System and method for generating graphical dashboards with drill down navigation | |
| US8881127B2 (en) | Systems and methods to automatically generate classes from API source code | |
| US11727325B2 (en) | User interface to analyze and navigate through decision logic | |
| US20180039657A1 (en) | Managing data across multiple systems | |
| CN103177329A (en) | Rule-based determination and validation in business object processing | |
| US20110106724A1 (en) | Entity morphing in metamodel-based tools | |
| US8555181B2 (en) | Method and system for constructing business rules in a business software system using intelligent tiles | |
| CN111427865A (en) | Method and device for managing objects of database | |
| WO2019110654A1 (en) | Systems and methods for querying databases using interactive search paths | |
| CN109033157B (en) | Complex data retrieval method and system based on user-defined search condition tree | |
| US11308131B2 (en) | Combining visualizations in a business analytic application | |
| US8533616B2 (en) | Time support for service adaptation | |
| US11275485B2 (en) | Data processing pipeline engine | |
| US10866831B2 (en) | Distributed execution of data processing pipelines | |
| US10949219B2 (en) | Containerized runtime environments | |
| CN114356962A (en) | Data query method and device, electronic equipment and storage medium | |
| CN113762702A (en) | Workflow deployment method, device, computer system and readable storage medium | |
| US11657308B2 (en) | Rule scenario framework for defining rules for operating on data objects | |
| CN111191057A (en) | User-defined retrieval method and device, electronic equipment and storage medium thereof | |
| US10387553B2 (en) | Determining and assisting with document or design code completeness | |
| US20230086037A1 (en) | Graphical diagram comparison |
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 |