CN115422898A - Visual self-defined report form analysis system based on container cloud - Google Patents
Visual self-defined report form analysis system based on container cloud Download PDFInfo
- Publication number
- CN115422898A CN115422898A CN202211063105.2A CN202211063105A CN115422898A CN 115422898 A CN115422898 A CN 115422898A CN 202211063105 A CN202211063105 A CN 202211063105A CN 115422898 A CN115422898 A CN 115422898A
- Authority
- CN
- China
- Prior art keywords
- chart
- module
- data
- visual
- analysis system
- 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
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/338—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6209—Protecting access to data via a platform, e.g. using keys or access control rules to a single file or object, e.g. in a secure envelope, encrypted and accessed using a key, or with access control rules appended to the object itself
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/183—Tabulation, i.e. one-dimensional positioning
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/455—Emulation; Interpretation; Software simulation, e.g. virtualisation or emulation of application or operating system execution engines
- G06F9/45504—Abstract machines for programme code execution, e.g. Java virtual machine [JVM], interpreters, emulators
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Software Systems (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Bioethics (AREA)
- Computer Hardware Design (AREA)
- Computer Security & Cryptography (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a visual self-defined report analysis system based on a container cloud, belongs to the field of self-defined report design, and solves the problems that in the prior art, the manual cost is high when an Excel tool is used for carrying out report statistics, and partial data cannot be visualized; the traditional report tool has the technical problems of high cost, complex operation, incapability of visually editing data and self-defining editing. It includes front end and rear end, and the front end includes: the system comprises a data selection module, a visual editing module, an attribute setting module and a page layout module, wherein the front end realizes the function of dynamically dragging and configuring report attributes by componentizing common chart styles such as bar charts, pie charts, tables and line charts. The back end comprises a data processing module and a micro-service architecture module. The invention saves a large amount of secondary development cost, reduces the heavy workload of enterprise staff, improves the enterprise management efficiency, has simple operation, and can be freely combined and matched with the personalized report content by users.
Description
Technical Field
The invention relates to a report form analysis system, in particular to a visual self-defined report form analysis system, and belongs to the field of self-defined report form design.
Background
With the rise of internet technology, the digital upgrade of enterprises becomes a trend. OA software is popular in China, is considered as a good helper for enterprise process management, and helps to realize comprehensive enterprise management.
Under the background, data statistics of various items of enterprises become an important pain point for OA software office, traditional report making needs enterprise workers to export data and use an Excel tool for statistics, the complex workload consumes a great deal of manpower of the enterprises, the limitation of the Excel tool is met, and some enterprise data cannot be visualized.
Traditional OA manufacturers also develop some report tools, the high cost and the complex operation increase the burden of enterprises, and the pain of users is not solved.
The traditional report tool adopts a data warehouse + a report + SQL, statistics and display are carried out on data through screening and querying the data, and the technical route has the greatest disadvantage that the data cannot be visually edited and cannot be self-defined edited.
In addition, with the popularization of the application and development of the micro service architecture, many IT companies launch new products based on the micro service architecture, and in order to avoid the influence of different operating environments on code operation, the micro service needs to be deployed in an isolation environment. Initially, micro service providers tend to deploy micro services in virtual machines, which can also achieve isolation of the micro services, but cannot perform rapid expansion, are limited by implementation principles of the virtual machines, take some time to start the micro service providers, cannot immediately react to instantly sudden loads or flows, and from the cost consideration, each application or micro service must be operated in one virtual machine in order to achieve isolation using conventional virtual machine technology, and such repeated and wasted allocation of operating systems and resources can be avoided by container technology, thereby greatly reducing investment of the cloud service providers in hardware and saving the cost of the cloud service center.
One container contains the complete runtime environment: except the application program itself, all the dependencies, class libraries, other binary files, configuration files and the like required by the application are uniformly typed into a package called container mirror image, and the differences caused by the release version of the operating system and other basic environments are abstracted by containerizing the application program itself and the dependencies thereof, so that the mirror image is more flexibly transplanted from one environment to another environment. For example, the same image may run in a Windows or Linux, development, test, or production environment. Meanwhile, the container is deployed in the cloud host through the container cloud architecture, a user can flexibly and conveniently use the micro-service only through the SaaS (software as a service) layer without considering the problems of data storage, software maintenance, safety and the like, and the operation and maintenance cost of an enterprise is greatly saved.
The applicant has found that the prior art has at least the following technical problems:
1. in the prior art, the Excel tool is used for carrying out report statistics, the labor cost is high, and part of data cannot be visualized;
2. in the prior art, the report tool has high cost and is complex to operate;
3. in the prior art, the data of the traditional report tool cannot be visually edited and cannot be edited by self-definition.
Disclosure of Invention
The invention aims to provide a visual self-defined report analysis system based on a container cloud, which aims to solve the problems that in the prior art, the manual cost is high when an Excel tool is used for carrying out report statistics, and part of data cannot be visualized; the report tool has high cost and is complex to operate; the data of the traditional report tool cannot be visually edited, and cannot be edited by user definition.
In order to achieve the purpose, the invention provides the following technical scheme:
the invention provides a visual custom report analysis system based on a container cloud.
The front end comprises: the system comprises a data selection module, a visual editing module, an attribute setting module and a page layout module.
Further, the data selection module, the visual editing module, the attribute setting module and the page layout module are used for:
the data selection module is used for sending a request for inquiring data to be edited to the back end and importing the data to be edited to the front end;
the visual editing module comprises a plurality of chart components and is used for selecting the chart components through selection operation by a user, dragging the chart components selected through the selection operation into a design table through dragging operation by the user, and presenting the data to be edited, which is imported by the data selection module, into a chart style corresponding to the chart components selected through the selection operation in the design table;
and the attribute setting module is used for setting the presentation format of the corresponding chart style presented in the design station by the chart component selected by the selection operation by the user.
And the page layout module is used for setting the page layout when the multi-report forms are jointly presented.
Further, the page layout includes: waterfall flow type layout, grid type layout, free type layout and magnetic paste type layout.
Further, the chart components and their corresponding chart styles include:
a histogram component that is a histogram corresponding to the chart style;
the pie chart component corresponds to the chart style and is a pie chart;
the table component corresponds to the chart style and is a table;
and the line drawing component corresponds to the chart style and is a line drawing.
Further, when the chart style presented in the design stage is a histogram, the presentation format of the histogram includes horizontal and vertical axis fields, grouping fields, and the size and color of the histogram; when the chart style presented in the design table is a pie chart, the presentation format of the pie chart is the size and the color of a classification field, a numerical value field, an icon field and a pie chart graph; when the chart style presented in the design table is a table, the presentation format of the table is the combination of a user-defined table head, a user-defined title, a user-defined table name, a user-defined arrangement table column and row and a cell; when the chart style presented in the design table is a line chart, the presentation format of the line chart is horizontal and vertical axis fields, grouping fields, reference lines, the size of a display point of the customized line chart and the shape color of the customized line chart.
The back end includes:
the data processing module is used for inquiring, aggregating and summarizing data to be edited;
and the micro-service architecture module is used for distributed architecture micro-service.
Furthermore, the data processing module database is mongoDB, aggregation summarization of data in different processing stages and Aggregation summarization of multiple tables are completed through an Aggregation Pipeline of the mongoDB database, and the efficiency problem of two times of query is solved through a view function of the mongoDB.
Further, the micro-service architecture module is realized by adopting a spring-closed micro-service technology.
The visual custom report form analysis system based on the container cloud provides services for users based on the container cloud technology, and comprises the following steps:
the IaaS layer is used for providing container resources;
the PaaS layer comprises a Docker container engine system and is used for managing the life cycle of the container; the k8s cluster management system is used for container management;
and the SaaS layer is used for providing an access entrance for a user.
The visual custom report analysis system based on the container cloud also comprises a security and confidentiality system, wherein a user sends an access request to the nqinx, the nqinx receives a connection request on the internet, and then forwards the request to a routing module, an authentication module and a white list module on an internal network in a reverse proxy mode to determine the access authority of the user.
Based on the technical scheme, the embodiment of the invention can at least produce the following technical effects:
(1) The visual self-defined report analysis system based on the container cloud saves a large amount of secondary development cost, reduces heavy workload of enterprise staff, and improves enterprise management efficiency.
(2) The visual self-defined report analysis system based on the container cloud is simple to operate, and users can freely combine and match personalized report contents.
Drawings
Fig. 1 is a schematic structural diagram of an embodiment of the present invention.
Detailed Description
The invention provides a visual custom report analysis system based on a container cloud, and a preferred embodiment of the invention is described in detail with reference to fig. 1.
The preferred embodiment of the present invention provides rich functional modules such as: the data selection module, the visual editing module, the attribute setting module and the page layout module enable a user to quickly build a report form like building blocks without a code base, carry out custom editing and visual editing on a chart, and do not need to manually import data to make the chart.
The data selection module, in the preferred embodiment of the present invention, is a data source button.
The visual editing module comprises a chart component and a design table, wherein the chart component and the corresponding chart style thereof comprise:
a histogram component that is a histogram corresponding to the chart style;
the pie chart component corresponds to the chart style and is a pie chart;
the table component corresponds to the chart style and is a table;
and the line drawing component corresponds to the chart style and is a line drawing.
When a user drags a bar chart icon to the canvas, the canvas presents the bar chart, the user can visually edit the bar chart in the attribute setting column on the right side of the design table, a data source button is clicked, drawing data can be imported, the user can freely define the horizontal and vertical axis fields and the grouping fields of the bar chart in the attribute setting module on the right side of the design table, and the size and the color of the bar chart can be defined.
When a user drags a pie chart icon to the canvas, the canvas presents the pie chart graphic, the user can visually edit the pie chart in the attribute setting module on the right side of the design table, the data source button is clicked, drawing data can be imported, the user can freely define classification fields, numerical value fields and icon fields in the attribute setting module on the right side of the design table, and the size and the color of the pie chart graphic can be customized.
When a user drags a form icon to the canvas, the canvas presents the form, the user can visually edit the form in the attribute setting module on the right side of the design table, the data source button is clicked to import the form making data, the user can design the attribute setting module on the right side of the design table to define the form header, the hidden button can be clicked to hide all the hidden layers of the form header, the custom title button can be clicked to hide or display the title, and the box can be input on the right side of the design table to name the form name. The user can arrange columns and rows of the table in a user-defined mode, can combine cells of relative data, and can select the table style provided by the system to realize the user-defined and visual effect of the table.
When a user drags the line graph icon to the canvas, the canvas presents a line graph, the user can visually edit the line graph in the attribute setting module on the right side of the design table, a data source button is clicked, drawing data can be imported, the user can freely define horizontal and vertical coordinate axis fields, grouping fields and reference lines of the line graph in the attribute setting module on the right side of the design table, and the size, shape and color of a display point of the line graph can be customized.
The attribute setting module is a menu on the right side of the design table and provides setting items and data fields for user-defined visual editing of the chart.
And the page layout module is used for setting page layouts in the process of joint presentation of multiple reports, and the page layouts comprise waterfall flow type layouts, grid type layouts, free type layouts and magnetic paste type layouts.
According to the preferred embodiment of the invention, data stored in a SaaS cloud database by a user is read, the data is sorted and analyzed through AI self-service data, the user clicks a data source button to load a data field to a front-end page, the user can drag and freely match and combine the data field to perform custom editing, the user can design a page and select a style through an attribute setting module, a report is visually edited, and the personalized requirements of the user are met to the maximum extent.
In the preferred embodiment of the invention, the front end adopts a vue frame (a set of progressive frames for constructing a user interface), and the function of dynamically dragging and configuring report attributes is realized by componentizing common chart styles such as column charts, broken line charts, pie charts and tables.
In the preferred embodiment of the invention, the backend service is realized by adopting a spring-closed micro-service technology in order to meet the distributed requirements of easy capacity expansion and high concurrency. The Spring Cloud is a service governance platform, is a collection of a plurality of frameworks, and provides a complete set of distributed system solutions. Comprises the following steps: service registration and discovery, configuration centers, service gateways, intelligent routing, load balancing, circuit breakers, monitoring traces, distributed message queues, and the like. The Spring Cloud shields complex configuration and implementation principles through Spring Boot style packaging, and finally leaves a set of simple and easy-to-understand distributed system development toolkit for developers. The developer can quickly start service or construct application, and can quickly interface with cloud platform resources.
In a preferred embodiment of the present invention, the reporting system database is mongoDB, and Aggregation summarization is performed on data of different processing stages through an Aggregation Pipeline (Aggregation Pipeline) of the mongoDB database. The aggregation function can be used for screening the original data according to a certain rule as if the data are placed in a conveyor belt, then processing the data through a plurality of different data processing stages, and finally outputting a summary result. Polymerizing the original data through a plurality of pipelines, and then returning a polymerization result after polymerizing through the last pipeline; the processing flow of each "Pipeline" is called Pipeline Stage, i.e. each Pipeline Stage. mongoDB provides a series of operators for each pipeline stage to complete the aggregation processing operation. An advantage of using mongoDB Pipeline is that MongoDB provides many built-in methods (just referred to as these operators) to help efficiently aggregate data
In the preferred embodiment of the invention, the report system also supports the function of aggregating tables, supports the aggregation and summarization of multiple tables, and solves the efficiency problem of two times of query through the view function of mongoDB.
The preferred embodiment of the invention provides services for users based on container cloud, comprising:
the IaaS layer is used for providing container resources;
the PaaS layer comprises a Docker container engine system and is used for managing the life cycle of the container; the k8s cluster management system is used for container management;
and the SaaS layer is used for providing an access entrance for a user.
The visual custom report analysis system based on the container cloud also comprises a security and confidentiality system, wherein a user sends an access request to the nqinx, the nqinx receives a connection request on the internet, and then forwards the request to a routing module, an authentication module and a white list module on an internal network in a reverse proxy mode to determine the access authority of the user.
It is to be understood that the present invention has been described with respect to the preferred embodiments, and it will be understood by those skilled in the art that various changes may be made and equivalents may be substituted for elements thereof without departing from the spirit and scope of the invention. In addition, many modifications may be made to adapt a particular situation to the teachings of the present invention without departing from its spirit or scope. Therefore, it is intended that the invention not be limited to the particular embodiment disclosed, but that the invention will include all embodiments falling within the scope of the appended claims.
Claims (8)
1. The utility model provides a visual self-defined report form analytic system based on container cloud, includes front end and rear end, its characterized in that, the front end includes:
the data selection module is used for sending a request for inquiring data to be edited to the back end and importing the data to be edited to the front end;
the visual editing module comprises a plurality of chart components and a design table, and is used for selecting the chart components through selection operation by a user, dragging the chart components selected through the selection operation into the design table through dragging operation by the user, and presenting the data to be edited, which is imported by the data selection module, into a chart style corresponding to the chart components selected through the selection operation in the design table;
and the attribute setting module is used for setting the presentation format of the corresponding chart style presented in the design station by the chart component selected by the selection operation by the user.
2. The visual custom report analysis system based on the container cloud as claimed in claim 1, wherein said front end further comprises a page layout module for setting a page layout when the multiple reports are jointly presented.
3. The visual custom report analysis system based on the container cloud as claimed in claim 2, wherein the page layout comprises a waterfall flow type layout, a grid type layout, a freestyle type layout, a magnetic paste type layout.
4. The visual custom report analysis system based on container cloud according to claim 1, characterized in that said chart component and its corresponding chart style comprise:
a histogram component that is a histogram corresponding to the chart style;
the pie chart component corresponds to the chart style and is a pie chart;
the table component corresponds to the chart styles and is a table;
and the line drawing component corresponds to the chart style and is a line drawing.
5. The visual custom report analysis system based on the container cloud as claimed in claim 1 or 4, wherein when the chart style presented in the design stage is a bar chart, the presentation format of the bar chart comprises the horizontal and vertical axis fields, the grouping fields, the size and the color of the bar chart; when the chart style presented in the design table is a pie chart, the presentation format of the pie chart is the size and the color of a classification field, a numerical value field, an icon field and a pie chart graph; when the chart style presented in the design table is a table, the presentation format of the table is the combination of a custom header, a custom table name, custom arrangement table columns and rows and cells; when the chart style presented in the design table is a line chart, the presentation format of the line chart is horizontal and vertical axis fields, grouping fields, reference lines, the size of a user-defined line chart display point and the shape color of the user-defined line chart.
6. The visual custom report analysis system based on the container cloud according to claim 1, characterized in that said backend comprises:
the data processing module is used for inquiring, aggregating and summarizing the data to be edited;
and the micro-service architecture module is used for distributed architecture micro-service.
7. The visual custom report analysis system based on the container cloud as claimed in claim 6, wherein the data processing module database is mongoDB, aggregation summarization of data of different processing stages and Aggregation re-summarization of multiple tables are completed through an Aggregation Pipeline of the mongoDB database, and the efficiency problem of two queries is solved through a view function of the mongoDB.
8. The container cloud based visual custom report analysis system according to claim 6, wherein said micro service architecture module is implemented by using spring-closed micro service technology.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211063105.2A CN115422898A (en) | 2022-08-31 | 2022-08-31 | Visual self-defined report form analysis system based on container cloud |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211063105.2A CN115422898A (en) | 2022-08-31 | 2022-08-31 | Visual self-defined report form analysis system based on container cloud |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115422898A true CN115422898A (en) | 2022-12-02 |
Family
ID=84200368
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211063105.2A Pending CN115422898A (en) | 2022-08-31 | 2022-08-31 | Visual self-defined report form analysis system based on container cloud |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115422898A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116956847A (en) * | 2023-07-25 | 2023-10-27 | 陕西师范大学 | Report management method and device |
-
2022
- 2022-08-31 CN CN202211063105.2A patent/CN115422898A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116956847A (en) * | 2023-07-25 | 2023-10-27 | 陕西师范大学 | Report management method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110717319B (en) | Self-service report generation method, device, computing equipment and system | |
| JP5298117B2 (en) | Data merging in distributed computing | |
| CN109815283B (en) | Heterogeneous data source visual query method | |
| CN104778124A (en) | Automatic testing method for software application | |
| US20140330827A1 (en) | Methods and systems to operate on group-by sets with high cardinality | |
| CN110110108B (en) | Data importing method and device of graph database | |
| CN104424018A (en) | Distributed calculating transaction processing method and device | |
| CN106503274A (en) | A kind of Data Integration and searching method and server | |
| CN103077192B (en) | A kind of data processing method and system thereof | |
| WO2024011829A1 (en) | Comprehensive intelligent platform data management method and system based on spatio-temporal system | |
| CN112416991A (en) | Data processing method and device and storage medium | |
| CN113642299A (en) | One-key generation method based on power grid statistical form | |
| CN113741883A (en) | RPA lightweight data middling station system | |
| CN106558105A (en) | Using method of the product Configurable BOM in virtual reality system | |
| CN109582837A (en) | A kind of visualized data processing method based on cloud and system | |
| CN115422898A (en) | Visual self-defined report form analysis system based on container cloud | |
| CN114036183A (en) | Data ETL processing method, device, equipment and medium | |
| CN112631754A (en) | Data processing method, data processing device, storage medium and electronic device | |
| CN116431611A (en) | Automatic data processing module development method based on custom rules | |
| CN114443427A (en) | Cloud resource efficiency evaluation method based on big data analysis | |
| CN113535758B (en) | Big data system and method for converting traditional database scripts into cloud in batch | |
| CN115617919A (en) | Data center system for agricultural data analysis and processing | |
| CN109933622A (en) | A kind of data visualisation system and implementation method | |
| CN114860851A (en) | Data processing method, device, equipment and storage medium | |
| CN113886465A (en) | Big data analysis platform for automobile logistics |
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 |