Realization method of report multi-data source import mode

By creating a dataset management center in the report analysis tool, it supports the rapid import and dynamic integration of multiple data sources, and solves the problems of complexity and operation difficulty of multi-data source data import in the existing technology, realizing cross-platform data integration and efficient Data analysis improves user experience and system performance.

CN118916358AInactive Publication Date: 2024-11-08河钢数字技术股份有限公司
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411059391.4
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-08-03
Publication Date
2024-11-08
Estimated Expiration
Not applicable · inactive patent

AI Technical Summary

Technical Problem

Existing report analysis tools have shortcomings in importing data from multiple data sources, especially in cross-platform and cross-system data integration. The operation is complex and inconvenient, which can easily lead to data loss and modification. Traditional methods cannot effectively support multiple different forms. import data source data.

Method used

Provide a report multi-data source import method. By creating a data set management center, it supports the rapid import and integration of multiple data sources (including static files and databases), and uses data set information and field information to perform dynamic data fusion to generate dynamic reports. Users can freely organize fields and perform aggregation operations.

Benefits of technology

It realizes rapid import and efficient integration of multi-data source data, reduces operational difficulty and workload, improves user experience and system availability, supports cross-platform and cross-system data integration, and reduces maintenance costs and data source management complexity .

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118916358A_ABST
    Figure CN118916358A_ABST
Patent Text Reader

Abstract

The invention discloses an implementation method of a report multi-data-source import mode, and relates to the technical field of data import application in data analysis, the implementation method of the report multi-data-source import mode comprises the following steps: 1, creating a demonstration data folder: adopting a mode capable of switching data sources, utilizing the capability of field information cached at the front end, and creating a demonstration data folder; after a user establishes an analysis report, switches data sources according to own requirements and selects field information to be analyzed from a plurality of data sources, the field information to be analyzed is transmitted to a back end, the back end obtains all data from the plurality of data sources according to different data source information and field information, the obtained data is fused according to the selected field information, and the fused data is sent to the back end. And forming a copy of data for subsequent data analysis, and finally generating a dynamic report analysis result. According to the method and the device, the report is quickly created, the data is quickly read, the data importing efficiency of the multiple data sources is improved, and the user experience is enhanced.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of data import application in data analysis, and in particular to a method for implementing a report multi-data source import mode. Background Art

[0002] With the development of big data technology, report analysis is gradually transforming to big data. Big data analysis technology can help enterprises process massive amounts of data, discover the rules and trends hidden behind the data, and provide strong support for enterprise decision-making. In order to meet different data import requirements, a variety of data import technologies and tools have appeared on the market. At present, mainstream report analysis tools basically use the following two methods to import data. One is to directly open, import or copy static files in Excel, Csv, XML and other formats. This method requires the original data to comply with platform rules, has strong restrictions, and has complex operation forms, which is time-consuming and labor-intensive. At the same time, in actual use, it is often encountered that multiple copies of data are combined and deduplicated. At this time, importing static files is extremely inconvenient to operate, and it is easy to cause data loss and modification. The other is to obtain data by connecting to an API interface or a database. In this method, it is very good to support filtering the data that users want by fields, and it can also perform some simple aggregation operations based on SQL statements. In the same database, data can be obtained by querying a joint table, but there is still a big lack of data import for multiple different forms of data sources. With the diversification of enterprise data sources, the above data import method is no longer sufficient to support cross-platform and cross-system data integration.

[0003] In view of the above problems, a method for implementing the import of multiple data sources for reports is proposed. Summary of the invention

[0004] The purpose of the present invention is to solve at least one of the technical problems existing in the prior art and to provide a method for implementing a report multi-data source import method, which can solve the problems of the background technology.

[0005] To achieve the above object, the present invention provides the following technical solution: a method for implementing a report multi-data source import mode, comprising the following steps:

[0006] Step 1: Create a demo data folder: Create a demo data folder to manage the data sources used. Import the Excel student information table in this folder, connect to the course table in the MySQL database, and connect to the student score table in the Oracle database.

[0007] The second step is data import: support fast import of multiple data sources (support static data import in the form of static files such as Excel, Csv, XML, and also support import of database data table information such as MySQL and Oracle). At the same time, the same data source data can be reused by multiple reports. In this method, for the import of static files in formats such as Excel, Csv, JSON, etc., an import interface is provided in the data set management interface;

[0008] The third step is to parse the imported file: after importing the data, the data in the static file will be parsed and stored in the MySQL database. At the same time, a table is maintained to store the information of the data set for subsequent report data to be imported into MySQL, Oracle and other databases;

[0009] Step 4: Verify information: Provide a connection interface. After entering the IP, port, user name, password, connected database and other information, as long as the test connection is passed, it will be stored in the data set information table maintained by the above static file for subsequent operations.

[0010] Step 5: Configure data sources: In the data analysis report, for the import of data from multiple data sources, based on the above-mentioned data set management center, the user first configures all the data sources he needs in the data set management center;

[0011] Step 6: Integrate data: The program queries the required data one by one based on the data set information and the corresponding field information, integrates them, and finally returns the dynamically generated data to the user.

[0012] Preferably, in the first step, in the generated report, a custom report chart is formed by switching the above three different data sets and dragging in corresponding fields.

[0013] Preferably, the multi-data source import method supports the above-mentioned multiple data sources and can integrate data from these different sources into a unified platform or tool for unified analysis.

[0014] Preferably, the required fields are dragged in from each data set, and the user can freely organize the order of the fields and add simple aggregation operations to the fields.

[0015] Compared with the prior art, the present invention has the following beneficial effects:

[0016] (1) The implementation method of the report's multi-data source import method adopts a switchable data source mode and utilizes the ability of the front-end cached field information. When the user creates an analysis report, he switches the data source according to his own needs, selects the field information to be analyzed from multiple data sources, and then transmits it to the back-end. The back-end obtains all data from multiple data sources based on different data source information and field information, and merges the obtained data based on the selected field information to form a set of data for subsequent data analysis, and finally generates dynamic report analysis results. This realizes the rapid creation of reports and the rapid reading of data, improves the efficiency of data import from multiple data sources, and enhances the user experience.

[0017] (2) The implementation method of the report's multi-data source import method uses a method of querying all data based on different data sources and fields in the data source for integration. This not only supports the import of data from multiple data sources, but also reduces the difficulty and workload of operations.

[0018] (3) The implementation method of the report's multi-data source import method is that according to the data source and field information, the program automatically queries and obtains the corresponding data and integrates it. Compared with the traditional method of converting data from different data sources into JSON or integrating and importing with JavaScript scripts, it is faster, simpler to operate, user-friendly, and can dynamically integrate data, which is more flexible.

[0019] (4) The implementation method of the report's multi-data source import method provides a data set management module. Users only need to store the data source once and can use it multiple times, which not only reduces maintenance costs but also improves the management performance of the data source. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] The present invention is further described below in conjunction with the accompanying drawings and embodiments:

[0021] Figure 1 This is a schematic diagram of the Excel static data import interface of the present invention;

[0022] Figure 2 This is a schematic diagram of the data set management interface of the present invention;

[0023] Figure 3 A schematic diagram of dragging fields from an Excel data source into a report of the present invention;

[0024] Figure 4 Creating a data source information schematic diagram for the data set of the present invention;

[0025] Figure 5 This is a schematic diagram of dynamically generating reports according to the present invention. DETAILED DESCRIPTION

[0026] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0027] In order to further understand the content of the present invention, the present invention is described in detail in conjunction with the accompanying drawings.

[0028] See also Figure 1-5 The present invention provides a technical solution: a method for implementing a report multi-data source import method, comprising the following steps:

[0029] The first step is to create a demonstration data folder: Create a demonstration data folder to manage the data sources used. Import the Excel student information table in this folder, connect to the course table in the MySQL library, and connect to the student score table in the Oracle database.

[0030] In the generated report, by switching the three different data sets mentioned above and dragging in the corresponding fields, a custom report chart is formed.

[0031] The second step is data import: support for fast import of multiple data sources (support for static data import in the form of static files such as Excel, Csv, XML, and also support for import of database data table information such as MySQL and Oracle). At the same time, the same data source data can be reused by multiple reports. In this method, for the import of static files in formats such as Excel, Csv, JSON, etc., an import interface is provided in the data set management interface.

[0032] The multi-data source import method designed in this paper supports the above-mentioned multiple data sources and can integrate data from these different sources into a unified platform or tool for unified analysis.

[0033] The third step is to parse the imported file: After importing the data, the data in the static file will be parsed and stored in the MySQL database. At the same time, a table is maintained to store the information of the data set for subsequent report data import into MySQL, Oracle and other databases.

[0034] The fourth step is to verify the information: provide a connection interface. After entering the IP, port, user name, password, connected database and other information, as long as the test connection is passed, it will be stored in the data set information table maintained by the above static file for subsequent operations.

[0035] Step 5. Configure data sources: In data analysis reports, for the import of data from multiple data sources, based on the above-mentioned dataset management center, users first configure all the data sources they need in the dataset management center. Then, in the report, they can switch between multiple different datasets and drag the required fields from each dataset. Users can freely organize the order of fields and add simple aggregation operations to fields.

[0036] It provides a management center for multiple data sources, separates the management of multiple data sources from report analysis, and avoids the redundancy caused by repeated import of data in traditional report analysis. The same data source information can be used by multiple different reports, which not only saves server memory space, but also facilitates users to use and manage multiple data sources, improving system availability and user experience.

[0037] Step 6: Integrate data: The program queries the required data one by one based on the data set information and the corresponding field information, integrates them, and finally returns the dynamically generated data to the user.

[0038] The present invention uses the method of querying all data according to different data sources and fields in the data sources to integrate them, which not only supports the import of data from multiple data sources, but also reduces the difficulty of operation and workload.

[0039] The MySQL database is used as a data persistence tool to store various types of data source information in the data set. Based on the data source management center, when creating reports and performing data analysis, users can select the required data and drag the corresponding fields. They can also freely combine and support simple aggregation operations. This not only improves the speed and accuracy of importing information from different data sources, but also provides good support for the dynamic integration of data in data reports, reduces the complexity of user operations, and improves the availability of the overall system.

[0040] Finally, it should be noted that the above is only a preferred embodiment of the present invention and is not intended to limit the present invention. Although the present invention has been described in detail with reference to the aforementioned embodiments, it is still possible for those skilled in the art to modify the technical solutions described in the aforementioned embodiments or to make equivalent substitutions for some of the technical features therein. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the protection scope of the present invention.

Claims

1. A method for implementing a report multi-data source import method, Features: The following steps are involved: Step 1: Create a demo data folder: Create a demo data folder to manage the data sources used. Import the Excel student information table in this folder, connect to the course table in the MySQL database, and connect to the student score table in the Oracle database. The second step is data import: support fast import of multiple data sources (support static data import in the form of static files such as Excel, Csv, XML, and also support import of database data table information such as MySQL and Oracle). At the same time, the same data source data can be reused by multiple reports. In this method, for the import of static files in formats such as Excel, Csv, JSON, etc., an import interface is provided in the data set management interface; The third step is to parse the imported file: after importing the data, the data in the static file will be parsed and stored in the MySQL database. At the same time, a table is maintained to store the information of the data set for subsequent report data to be imported into MySQL, Oracle and other databases; Step 4: Verify information: Provide a connection interface. After entering the IP, port, user name, password, connected database and other information, as long as the test connection is passed, it will be stored in the data set information table maintained by the above static file for subsequent operations. Step 5: Configure data sources: In the data analysis report, for the import of data from multiple data sources, based on the above-mentioned data set management center, the user first configures all the data sources he needs in the data set management center; Step 6: Integrate data: The program queries the required data one by one based on the data set information and the corresponding field information, integrates them, and finally returns the dynamically generated data to the user.

2. According to the method for implementing a report multi-data source import method according to claim 1, Features: The first step is to form a custom report chart by switching the three different data sets and dragging in corresponding fields in the generated report.

3. According to the method for implementing a report multi-data source import method according to claim 2, Features: The multi-data source import method supports the above-mentioned multiple data sources and can integrate the data from these different sources into a unified platform or tool for unified analysis.

4. According to the method for implementing a report multi-data source import method according to claim 3, Features: By dragging the required fields from each data set, users can freely organize the order of the fields and add simple aggregation operations to the fields.