CN112256684A - Report generation method, terminal equipment and storage medium - Google Patents

Report generation method, terminal equipment and storage medium Download PDF

Info

Publication number
CN112256684A
CN112256684A CN202011147143.7A CN202011147143A CN112256684A CN 112256684 A CN112256684 A CN 112256684A CN 202011147143 A CN202011147143 A CN 202011147143A CN 112256684 A CN112256684 A CN 112256684A
Authority
CN
China
Prior art keywords
data
database
entity
report
query statement
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.)
Granted
Application number
CN202011147143.7A
Other languages
Chinese (zh)
Other versions
CN112256684B (en
Inventor
乐高鑫
林飞达
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Xiamen Yuexin Information Technology Co ltd
Original Assignee
Xiamen Yuexin Information Technology Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Xiamen Yuexin Information Technology Co ltd filed Critical Xiamen Yuexin Information Technology Co ltd
Priority to CN202011147143.7A priority Critical patent/CN112256684B/en
Publication of CN112256684A publication Critical patent/CN112256684A/en
Application granted granted Critical
Publication of CN112256684B publication Critical patent/CN112256684B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/215Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages
    • G06F16/244Grouping and aggregation
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/248Presentation of query results

Abstract

The invention relates to a report generation method, a terminal device and a storage medium, wherein the method comprises the following steps: s1: connecting a corresponding database according to the report content; s2: verifying data in the database through the dictionary specification, and extracting a data entity corresponding to the report content from the database; s3: extracting entity fields and entity data required by the report form from the extracted data entities, and setting association rules among the data entities; s4: generating a database query statement according to the association rule, and querying through the database query statement to obtain two-dimensional data; s5: and displaying the acquired two-dimensional data into a report according to the display form of the report. The invention can be associated with a plurality of data tables in a plurality of databases to generate database query statements, and generate reports in various display forms by using data obtained by querying the database query statements.

Description

Report generation method, terminal equipment and storage medium
Technical Field
The present invention relates to the field of database management, and in particular, to a report generation method, a terminal device, and a storage medium.
Background
The existing database Management visualization software has various kinds, but the user group for which each kind of visualization software is designed is basically a software Developer or a person with a certain software development basis, such as Navicat based on C/S, Workbench based on Mysql, SQL Server Management Studio of SQL Server, SQL Developer of Oracle, Data Admin Service based on B/S of cloud and aristo cloud, and the like, and the Service group of these software is a Developer; the report analysis can be provided directly by using database management software, such as FineReport, and the related database data sources still need the intervention of developers or persons with certain development knowledge and are completed by using report design tools. Users without knowledge of the relevant databases and software development reserves cannot use it.
Disclosure of Invention
In order to solve the above problems, the present invention provides a report generation method, a terminal device, and a storage medium.
The specific scheme is as follows:
a report generation method comprises the following steps:
s1: connecting a corresponding database according to the report content;
s2: verifying data in the database through the dictionary specification, and extracting a data entity corresponding to the report content from the database;
s3: extracting entity fields and entity data required by the report form from the extracted data entities, and setting association rules among the data entities;
s4: generating a database query statement according to the association rule, and querying through the database query statement to obtain two-dimensional data;
s5: and displaying the acquired two-dimensional data into a report according to the display form of the report.
Further, step S1 includes the following steps:
s11: selecting the type of a database corresponding to the report content;
s12: inputting related information of a database;
s13: loading JDBC driver of the database and configuring corresponding connection parameters;
s14: performing connection detection through a connection detection statement of the database, judging whether the connection detection is successful, and if so, entering S15; otherwise, returning to S12;
s15: and starting an asynchronous heartbeat connection detection thread of the database to maintain the real-time connection state of the database.
Further, the related information of the database includes a connection address, a port, a database name, a login account number, and a password of the database.
Further, the specific implementation manner of step S2 includes the following steps:
s21: setting dictionary specifications of data entities;
s22: judging whether the data of each data entity in the database accords with the dictionary specification, if so, entering S23; otherwise, modifying the non-conforming data according to the dictionary specification and then entering S23;
s23: constructing a database query statement according to the type of the database and the entity field in the data entity, and generating a paging query statement of the database;
s24: and extracting the data entity from the database through the database query statement and the paging query statement.
Further, the process of extracting the data entity from the database includes: and paging and extracting the data entities in the database into the local data warehouse, and starting an asynchronous thread to automatically extract the data entities at regular time.
Further, the specific implementation manner of step S3 includes the following steps:
s31: selecting a data entity corresponding to the display data according to the display data required by the report;
s32: selecting entity fields needing to be displayed in the report form from the data entities, and setting the display form of the entity fields;
s33: and setting the filtering condition of each data in the data entity and the association rule between each data entity.
Further, step S3 further includes: judging whether a grouping field and/or a sequencing field needs to be specified, when the grouping field needs to be specified, specifying a certain entity field as the grouping field, and adjusting the data form of other fields except the grouping field to be an aggregation function value form; when the sequencing field needs to be specified, a certain entity field is specified as the sequencing field, a sequencing mode is determined, and data corresponding to the sequencing field is sequenced according to the sequencing mode.
Further, step S4 includes generating a paging query statement of the database, and performing paging query through the database query statement and the paging query statement to obtain the two-dimensional data.
A report generating terminal device includes a processor, a memory, and a computer program stored in the memory and capable of running on the processor, and when the processor executes the computer program, the processor implements the steps of the method described above in the embodiments of the present invention.
A computer-readable storage medium, in which a computer program is stored, which, when being executed by a processor, carries out the steps of the method as described above for an embodiment of the invention.
The invention adopts the technical scheme and has the following beneficial effects:
1. the method can be used for associating a plurality of data tables in a plurality of databases to generate database query statements, and generating reports in various display forms by using data obtained by query of the database query statements;
2, enabling databases of different platforms to be used through dictionary specifications of data entities;
3. the structure of a preset data table can be directly used as an entity field, so that the difference of service system data structure definitions with similar functions is avoided, and service system data with a homogenization function can be well compatible;
4. the entity data in different types of databases can be extracted into the same local database, so that a data source can be prepared for associating a plurality of data entities with subsequent reports, and the operation of crossing different database types is realized; meanwhile, the display of the report data is still not influenced even if other data sources are in an offline state.
Drawings
FIG. 1 is a flow chart of a method according to an embodiment of the present invention.
Fig. 2 is a schematic diagram showing a two-dimensional data structure in this embodiment.
Detailed Description
To further illustrate the various embodiments, the invention provides the accompanying drawings. The accompanying drawings, which are incorporated in and constitute a part of this disclosure, illustrate embodiments of the invention and, together with the description, serve to explain the principles of the embodiments. Those skilled in the art will appreciate still other possible embodiments and advantages of the present invention with reference to these figures.
The invention will now be further described with reference to the accompanying drawings and detailed description.
The first embodiment is as follows:
the embodiment of the invention provides a report generation method, as shown in fig. 1, the method comprises the following steps:
s1: and connecting the corresponding database according to the report content.
The specific implementation manner of the step S1 includes the following steps:
s11: and selecting the type of the database corresponding to the report content.
S12: and (4) inputting related information of the database.
The related information of the database in this embodiment includes a connection address, a port, a database name, a login account number, a password, and the like of the database. Other information may be included in other embodiments and is not limited herein.
S13: loading JDBC (java database connectivity) driver of the database and configuring corresponding connection parameters.
The JDBC driver is a complete implementation of the JDBC specification and establishes a channel of communication between the JAVA program and the database system.
S14: performing connection detection through a connection detection statement of the database, judging whether the connection detection is successful, if so, indicating that the database connection is successful, and entering S15; otherwise, return to S12.
The indication of successful connection detection may be a response (e.g., receipt of signal "1") at a specified time.
S15: and starting an asynchronous heartbeat connection detection thread of the database to maintain the real-time connection state of the database.
S2: and checking the data in the database through the dictionary specification, and extracting the data entity corresponding to the report content from the database.
The specific implementation manner of the step S2 includes the following steps:
s21: the dictionary specification of the data entity is set.
The setting method of the dictionary specification in the embodiment includes three types, namely setting through a template, setting through manual selection and setting through a form.
The method for setting through the template comprises the following steps of:
s211: according to the requirement of the report, an entity template of the data table entity containing the report content is constructed, and the related information of the entity field corresponding to the entity template is set.
The related information of the entity field in this embodiment includes an entity code, an entity name, an entity field code, an entity field name, an entity field paradigm, an entity field length, an entity field remark, and the like.
S212: and setting the data table associated with each entity template and the fields in the data table associated with the entity fields in each entity template.
The setting method through manual selection is as follows: manually selecting a preset data table; and directly extracting the structural information of the data table, or filling the information of each field in the data table at one time to serve as dictionary specification, and setting the field in the data table associated with each field.
S22: judging whether the data of each data entity in the database accords with the dictionary specification, if so, entering S23; otherwise, the non-compliant data is modified according to the dictionary specification and the process proceeds to S23.
The judgment standard of whether the data of the data entity meets the dictionary specification is as follows: whether the type and length of each data in the data entity meet the dictionary specification.
S23: and constructing a database query statement according to the type of the database and the entity fields in the data entities, and generating a paging query statement of the database.
Since there are often multiple pages in a database, paging query statements are required.
The database query statement in this embodiment is a standard query statement based on PL/SQL, and examples are as follows:
SELECT column1,[column2,...]FROM table1,[table2,...]
[WHERE condition1,...]
[GROUP BY column1,...]
[ORDER BY column1,...]
the paged query statement is generated by a JPA dialect translation tool.
S24: and extracting the data entity from the database through the database query statement and the paging query statement.
The process of extracting data entities from the database in this embodiment includes: and paging and extracting the data entities in the database into the local data warehouse, and starting an asynchronous thread to automatically extract the data entities at regular time.
Further, the embodiment also includes recording the log information when the data is extracted. The log information includes extraction time, extraction number, and the like.
S3: and extracting entity fields and entity data required by the report form from the extracted data entities, and setting association rules among the data entities.
The specific implementation manner of the step S3 includes the following steps:
s31: and selecting a data entity corresponding to the display data according to the display data required by the report.
For example, if the display data required to be displayed in the report is the total number of boys, the selected data entity is the student entity table, and if the total number of class boys is further required to be displayed, the selected data entity is the class entity and the class student entity association table.
S32: and selecting entity fields to be displayed in the report form from the data entities, and setting the display form of the entity fields.
For example, if the display data is the total number of boys, the gender field in the student entity table needs to be selected.
The presentation form includes the presentation order of the fields.
S33: and setting the filtering condition of each data in the data entity and the association rule between each data entity.
The filter criteria can select fields of a data entity that specify an entity that is greater than, greater than or equal to, less than or equal to, not equal to, contains or does not contain a specified value or other data entity.
If different data entities may contain the same entity field, the same entity field is set as an association field, and the association rule is to set an association field, for example, entity fields including gender in both tables.
Further, in order to better search and display data, the embodiment further includes determining whether a grouping field and/or a sorting field needs to be specified, when the grouping field needs to be specified, specifying a certain entity field as the grouping field, and adjusting the data form of other fields except the grouping field to be the aggregation function value form; when the sequencing field needs to be specified, a certain entity field is specified as the sequencing field, a sequencing mode is determined, and data corresponding to the sequencing field is sequenced according to the sequencing mode.
The data corresponding to the same entity field can be divided into different groups, and the divided groups are set as the grouping fields, for example, the total number of the boys includes the boys of different schools, so the schools are set as the grouping fields.
The aggregation function value is the maximum value, the minimum value, the counting, the summation, the average value and the like in each group of data.
The sorting in this embodiment includes ascending and descending.
S4: and generating a database query statement according to the association rule, and querying through the database query statement to obtain the two-dimensional data.
Further, in this embodiment, a paging query statement of the database is generated, and paging query is performed through the database query statement and the paging query statement to obtain the two-dimensional data.
S5: and displaying the acquired two-dimensional data into a report according to the display form of the report.
The display form of the report can be set by a user.
The format of the two-dimensional data obtained by query in this embodiment is shown in fig. 2, and the specific method adopted is as follows:
(1) histogram display format: and selecting one row of data in each row as X-axis data and one to many rows of numerical types corresponding to the X-axis data as Y-axis data, so that each row forms a unit group column and a plurality of rows form a plurality of unit group columns.
(2) Line graph display form: similar to the histogram, data is presented as dots, and multiple columns show the trend of the data columns.
(3) The pie chart display form: only one column of data of the numerical type can be selected for display, and the percentage of the pie chart corresponding to each row of data in one column of data is the ratio of the value of the row of data to the sum of the values of all the rows of data in one column of data.
According to the embodiment I, the data of different databases can be compatible through the dictionary specification; the two-dimensional data acquired through the database query statement can be adapted to reports in various forms; the data of different databases are extracted into the unified data warehouse, so that the data query across different databases is realized.
Example two:
the invention further provides report generation terminal equipment, which comprises a memory, a processor and a computer program which is stored in the memory and can run on the processor, wherein the processor executes the computer program to realize the steps of the method embodiment of the first embodiment of the invention.
Further, as an executable scheme, the report generation terminal device may be a desktop computer, a notebook, a palm computer, or other computing devices. The report generation terminal device can include, but is not limited to, a processor and a memory. Those skilled in the art will understand that the above-mentioned structure of the report generating terminal device is only an example of the report generating terminal device, and does not constitute a limitation on the report generating terminal device, and may include more or less components than the above, or combine some components, or different components, for example, the report generating terminal device may further include an input/output device, a network access device, a bus, and the like, which is not limited in this embodiment of the present invention.
Further, as an executable solution, the Processor may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, a discrete Gate or transistor logic device, a discrete hardware component, and the like. The general processor can be a microprocessor or the processor can be any conventional processor, and the processor is a control center of the report generation terminal device and is connected with each part of the whole report generation terminal device by various interfaces and lines.
The memory can be used for storing the computer program and/or the module, and the processor realizes various functions of the report generation terminal equipment by running or executing the computer program and/or the module stored in the memory and calling data stored in the memory. The memory can mainly comprise a program storage area and a data storage area, wherein the program storage area can store an operating system and an application program required by at least one function; the storage data area may store data created according to the use of the mobile phone, and the like. In addition, the memory may include high speed random access memory, and may also include non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), at least one magnetic disk storage device, a Flash memory device, or other volatile solid state storage device.
The invention also provides a computer-readable storage medium, in which a computer program is stored, which, when being executed by a processor, carries out the steps of the above-mentioned method of an embodiment of the invention.
The report generation terminal device integrated module/unit, if implemented in the form of a software functional unit and sold or used as an independent product, may be stored in a computer readable storage medium. Based on such understanding, all or part of the flow of the method according to the embodiments of the present invention may also be implemented by a computer program, which may be stored in a computer-readable storage medium, and when the computer program is executed by a processor, the steps of the method embodiments may be implemented. Wherein the computer program comprises computer program code, which may be in the form of source code, object code, an executable file or some intermediate form, etc. The computer-readable medium may include: any entity or device capable of carrying the computer program code, recording medium, usb disk, removable hard disk, magnetic disk, optical disk, computer Memory, Read-Only Memory (ROM), Random Access Memory (RAM), software distribution medium, and the like.
While the invention has been particularly shown and described with reference to a preferred embodiment, it will be understood by those skilled in the art that various changes in form and detail may be made therein without departing from the spirit and scope of the invention as defined by the appended claims.

Claims (10)

1. A report generation method is characterized by comprising the following steps:
s1: connecting a corresponding database according to the report content;
s2: verifying data in the database through the dictionary specification, and extracting a data entity corresponding to the report content from the database;
s3: extracting entity fields and entity data required by the report form from the extracted data entities, and setting association rules among the data entities;
s4: generating a database query statement according to the association rule, and querying through the database query statement to obtain two-dimensional data;
s5: and displaying the acquired two-dimensional data into a report according to the display form of the report.
2. A report generation method according to claim 1, characterized in that: step S1 includes the following steps:
s11: selecting the type of a database corresponding to the report content;
s12: inputting related information of a database;
s13: loading JDBC driver of the database and configuring corresponding connection parameters;
s14: performing connection detection through a connection detection statement of the database, judging whether the connection detection is successful, and if so, entering S15; otherwise, returning to S12;
s15: and starting an asynchronous heartbeat connection detection thread of the database to maintain the real-time connection state of the database.
3. A report generation method according to claim 2, characterized in that: the related information of the database comprises a connection address, a port, a database name, a login account number and a password of the database.
4. A report generation method according to claim 1, characterized in that: the specific implementation manner of the step S2 includes the following steps:
s21: setting dictionary specifications of data entities;
s22: judging whether the data of each data entity in the database accords with the dictionary specification, if so, entering S23; otherwise, modifying the non-conforming data according to the dictionary specification and then entering S23;
s23: constructing a database query statement according to the type of the database and the entity field in the data entity, and generating a paging query statement of the database;
s24: and extracting the data entity from the database through the database query statement and the paging query statement.
5. The report generation method according to claim 4, wherein: the process of extracting data entities from a database comprises: and paging and extracting the data entities in the database into the local data warehouse, and starting an asynchronous thread to automatically extract the data entities at regular time.
6. A report generation method according to claim 1, characterized in that: the specific implementation manner of the step S3 includes the following steps:
s31: selecting a data entity corresponding to the display data according to the display data required by the report;
s32: selecting entity fields needing to be displayed in the report form from the data entities, and setting the display form of the entity fields;
s33: and setting the filtering condition of each data in the data entity and the association rule between each data entity.
7. A report generation method according to claim 1, characterized in that: step S3 further includes: judging whether a grouping field and/or a sequencing field needs to be specified, when the grouping field needs to be specified, specifying a certain entity field as the grouping field, and adjusting the data form of other fields except the grouping field to be an aggregation function value form; when the sequencing field needs to be specified, a certain entity field is specified as the sequencing field, a sequencing mode is determined, and data corresponding to the sequencing field is sequenced according to the sequencing mode.
8. A report generation method according to claim 1, characterized in that: step S4 includes generating a paging query statement of the database, and performing paging query through the database query statement and the paging query statement to obtain the two-dimensional data.
9. A report generation terminal device is characterized in that: comprising a processor, a memory and a computer program stored in the memory and running on the processor, the processor implementing the steps of the method according to any one of claims 1 to 8 when executing the computer program.
10. A computer-readable storage medium storing a computer program, characterized in that: the computer program when executed by a processor implementing the steps of the method as claimed in any one of claims 1 to 8.
CN202011147143.7A 2020-10-23 2020-10-23 Report generation method, terminal equipment and storage medium Active CN112256684B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011147143.7A CN112256684B (en) 2020-10-23 2020-10-23 Report generation method, terminal equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011147143.7A CN112256684B (en) 2020-10-23 2020-10-23 Report generation method, terminal equipment and storage medium

Publications (2)

Publication Number Publication Date
CN112256684A true CN112256684A (en) 2021-01-22
CN112256684B CN112256684B (en) 2022-08-16

Family

ID=74265005

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011147143.7A Active CN112256684B (en) 2020-10-23 2020-10-23 Report generation method, terminal equipment and storage medium

Country Status (1)

Country Link
CN (1) CN112256684B (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112988817A (en) * 2021-04-12 2021-06-18 携程旅游网络技术(上海)有限公司 Data comparison method, system, electronic equipment and storage medium
CN113111088A (en) * 2021-04-13 2021-07-13 北京沃东天骏信息技术有限公司 Data extraction 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

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9507820B1 (en) * 2012-10-23 2016-11-29 Dell Software Inc. Data modeling system for runtime schema extensibility
CN109213811A (en) * 2017-06-30 2019-01-15 北京神州泰岳软件股份有限公司 A kind of report form showing method and device
CN109471890A (en) * 2018-10-16 2019-03-15 深圳壹账通智能科技有限公司 Generation method, terminal device and the medium of report file
CN110750969A (en) * 2019-09-29 2020-02-04 北京东软望海科技有限公司 Method and device for generating report
CN111563368A (en) * 2020-04-03 2020-08-21 江苏苏宁物流有限公司 Report generation method and device, computer equipment and storage medium

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9507820B1 (en) * 2012-10-23 2016-11-29 Dell Software Inc. Data modeling system for runtime schema extensibility
CN109213811A (en) * 2017-06-30 2019-01-15 北京神州泰岳软件股份有限公司 A kind of report form showing method and device
CN109471890A (en) * 2018-10-16 2019-03-15 深圳壹账通智能科技有限公司 Generation method, terminal device and the medium of report file
CN110750969A (en) * 2019-09-29 2020-02-04 北京东软望海科技有限公司 Method and device for generating report
CN111563368A (en) * 2020-04-03 2020-08-21 江苏苏宁物流有限公司 Report generation method and device, computer equipment and storage medium

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
欧微;程岚;陈圣荣: "基于C#的数据库表结构报表系统的设计与实现", 《微型机与应用》 *

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112988817A (en) * 2021-04-12 2021-06-18 携程旅游网络技术(上海)有限公司 Data comparison method, system, electronic equipment and storage medium
CN112988817B (en) * 2021-04-12 2024-03-12 携程旅游网络技术(上海)有限公司 Data comparison method, system, electronic device and storage medium
CN113111088A (en) * 2021-04-13 2021-07-13 北京沃东天骏信息技术有限公司 Data extraction 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
CN113342821B (en) * 2021-06-29 2023-04-07 深圳前海微众银行股份有限公司 Report configuration method, device, equipment and computer storage medium

Also Published As

Publication number Publication date
CN112256684B (en) 2022-08-16

Similar Documents

Publication Publication Date Title
CN112256684B (en) Report generation method, terminal equipment and storage medium
CN110633292B (en) Query method, device, medium, equipment and system for heterogeneous database
CN109918394B (en) Data query method, system, computer device and computer readable storage medium
CN115061721A (en) Report generation method and device, computer equipment and storage medium
CN110737689B (en) Data standard compliance detection method, device, system and storage medium
CN110795524A (en) Main data mapping processing method and device, computer equipment and storage medium
CN111460011A (en) Page data display method and device, server and storage medium
CN112115152A (en) Data increment updating and querying method and device, electronic equipment and storage medium
CN113761334A (en) Visual recommendation method, device, equipment and storage medium
CN114741392A (en) Data query method and device, electronic equipment and storage medium
CN114637811A (en) Data table entity relation graph generation method, device, equipment and storage medium
US10353927B2 (en) Categorizing columns in a data table
CN106909647B (en) Data retrieval method and device
CN110874366A (en) Data processing and query method and device
CN110704635B (en) Method and device for converting triplet data in knowledge graph
CN110362591B (en) Report form display method and device
CN114996268A (en) User-defined report generation method and user-defined report generation device
CN112597185A (en) Big data query method and device
CN113360517A (en) Data processing method and device, electronic equipment and storage medium
CN112069164A (en) Data query method and device, electronic equipment and computer readable storage medium
CN116931889B (en) Software modeling method and system based on object tree
CN113420785B (en) Method and device for classifying written language types, storage medium and electronic equipment
CN115098596B (en) Government affair related data carding method, government affair related data carding device, government affair related data carding equipment and readable storage medium
CN112307050B (en) Identification method and device for repeated correlation calculation and computer system
CN113821533B (en) Method, device, equipment and storage medium for data query

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
GR01 Patent grant
GR01 Patent grant
PE01 Entry into force of the registration of the contract for pledge of patent right

Denomination of invention: Report generation method, terminal device and storage medium

Effective date of registration: 20221213

Granted publication date: 20220816

Pledgee: Bank of China Limited Xiamen hi tech Park sub branch

Pledgor: Xiamen Yuexin Information Technology Co.,Ltd.

Registration number: Y2022980027437

PE01 Entry into force of the registration of the contract for pledge of patent right