CN112015413A - Programming-free data visualization Web display system and implementation method thereof - Google Patents
Programming-free data visualization Web display system and implementation method thereof Download PDFInfo
- Publication number
- CN112015413A CN112015413A CN202010860741.2A CN202010860741A CN112015413A CN 112015413 A CN112015413 A CN 112015413A CN 202010860741 A CN202010860741 A CN 202010860741A CN 112015413 A CN112015413 A CN 112015413A
- Authority
- CN
- China
- Prior art keywords
- module
- service
- query
- data
- page
- 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
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/38—Creation or generation of source code for implementing user interfaces
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/957—Browsing optimisation, e.g. caching or content distillation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/958—Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
Abstract
A programming-free data visualization Web display system and an implementation method thereof relate to the field of computer software development. The display system consists of a system front end and a system rear end and comprises an application information input module, a service inquiry library module, a UI component library module, a system page design module, a rear end processing module, a WebSocket agent module, a service execution engine module, a service database, a Web display system page module and a support database module. Compared with the prior art, the data visualization display system is built by using the Echarts and other visualization component libraries in the mainstream Web page form, and has the characteristics of no programming, easy development and high efficiency.
Description
Technical Field
The invention relates to the field of computer software development, in particular to a programming-free application software automatic generation system based on picture configuration, which is used for generating an application program for carrying out webpage-form visual display on data.
Background
With the rapid development of information technology, a big data platform gradually becomes the core of a business information system, various data output by the big data platform are fully utilized, a data analysis system is developed to mine the commercial value of the big data platform and is displayed in a friendly visual form, and a service is provided for the decision of a management layer, so that the big data platform becomes a strong demand. With the rapid development of enterprises, the data analysis requirements are also rapidly changing, how to adapt to the changes, reduce the development difficulty, improve the development efficiency, and realize rapid development of mainstream Web page-based data visualization display systems, which is becoming a technical problem to be solved urgently.
In the prior art, the following two display systems are generally adopted:
(1) the CS framework application development platform cannot utilize a Web-based visual component library such as Echarts and the like, and cannot be used for rapidly developing a Web application program of a BS framework.
(2) The BS framework front-end picture development system is only used for organizing basic controls and generating front-end pictures of Web visual application, a back-end program needs to write programs manually, and a complete Web application program penetrating through a front end, a back end and a database cannot be generated without programming. The goal of reducing the development difficulty and improving the development efficiency is not really realized.
Disclosure of Invention
In order to overcome the defects in the prior art, the invention aims to provide a programming-free data visualization Web display system and an implementation method thereof. The data visualization display system is built in a mainstream Web page form by utilizing visual component libraries such as Echarts and the like, and has the characteristics of no programming, easiness in development and high efficiency.
In order to achieve the above object, the technical solution of the present invention is implemented as follows:
a programming-free data visualization Web display system is structurally characterized by comprising a system front end and a system back end, and the system front end and the system back end are divided into a design mode and an operation mode according to different stages. In the design mode, the front end of the system consists of an application information input module, a service query library module, a UI component library module and a system page design module; the system back end is composed of a back end processing module.
1) And the application information input module is used for inputting or maintaining basic information and menu composition for the development object application system.
2) And the service query library module is used for maintaining the service query library and preparing service logic for the UI component to obtain data.
3) And the UI component library module is used for maintaining a predefined UI component library and providing available UI components for the system page design module.
4) And the system page design module is used for designing the front-end page of the application system by using the UI components in the UI component library.
5) And the back-end processing module is used for receiving the data submitted by the modules and storing the data in a support database.
In the operation mode, the system back end comprises a WebSocket agent module, a service execution engine module and a service database module.
1) And the WebSocket agent module is based on a WebSocket protocol and provides topic subscription service based on conversation for the UI component.
2) And the business execution engine module comprises a general SQL execution engine and is used for executing business query and returning a retrieval result.
3) And the service database stores service data as a data source for the query of the service execution engine module.
The Web display system also comprises a Web display system page module and a support database module which are used for outputting in a design mode and inputting in a running mode.
1) The Web display system comprises a Web display system page module and an application program generated by a page design module.
2) And the support database module is used for storing various information input by the user in the design stage.
In the above programming-free data visualization Web display system, the basic information and menu in the application information entry module includes:
(1) basic information for registering an application system includes a system ID, a system name, a system abbreviation, a system description, an application server and port, and a database server.
(2) Registering a menu tree of an application system, wherein each menu item respectively designates a page ID, a page name and an English name and is used for generating a file directory structure and an initial interface file.
In the above-mentioned programming-free data visualization Web display system, the maintenance service query library and the service logic in the service query library module include:
(1) service query names and IDs are defined, and each service query corresponds to one record set.
(2) Defining a service query type, wherein the service query type determines a data format of query return; when the system runs, the query result returns data in the JSON format, and the data are mainly divided into three basic types according to the difference of JSON data organization modes:
In addition, a variety of extension types are supported, including: result set union, virtual field and formula calculation, select return field, template and reference, bunching, and sampling.
(3) Defining SQL query sentences for the business queries; the data type service does not need to define SQL sentences; the single-node type service needs to define an SQL statement; a group of SQL statements needs to be defined by the multi-node type service; the system supports online editing and execution of SQL statements and checks SQL execution results or error information so as to carry out SQL debugging.
In the programming-free data visualization Web display system, the UI component adopts a single UI control, such as a table, a pie chart, a bar chart or a line chart, or adopts a group of controls, even the whole Web page. The UI components are classified into two categories, a simple component and a standard component, according to whether a service query is bound:
(1) simple components, no service attributes, no service query binding, and no service data presentation.
(2) And the standard component has a service attribute and can bind the service query ID and the type, and the service query ID and the type are combined to form the subscription theme ID.
In the programming-free data visualization Web display system, the system page design module is used for designing the user interface of the application system by using a predefined or customized UI component.
In the programming-free data visualization Web display system, the WebSocket agent module provides topic subscription service for the client, and each subscribed client is independent of other clients. The same subscription theme, the content shown by different clients depends on the parameters set by the user.
In the programming-free data visualization Web display system, the business execution engine module receives the business query ID and the query parameter from the WebSocket agent module, loads the corresponding SQL query statement from the support database, executes the SQL query statement and returns the query result to the WebSocket agent.
The method for implementing the programming-free data visualization Web display system comprises the following steps from a design mode to an operation mode:
(1) starting from the application information input module, the system enters a design mode, basic information and menu composition of the input application is submitted to the back-end processing module for storage, and meanwhile, the back-end processing module can read and modify the previously stored information.
(2) In the back-end processing module, various definition information submitted by each front-end module is stored in a support database, or various definition information stored before is read from the support database for corresponding front-end picture modification.
(3) And in the application information input module, automatically generating a menu, a file directory structure and an initial interface file according to the input menu information.
(4) If the predefined service query does not meet the use requirement, the service query library module is used for self-defining, and one or a group of service query SQL sentences are defined according to the database specified by the application information entry module.
(5) The business query library module submits the business query SQL sentences defined in the last step to the background processing module for storing in a support database, or reads and modifies the previously stored SQL sentences through the back-end processing module.
(6) The UI component library module sets attributes and binds service inquiry for the predefined UI components, or if the predefined UI components do not meet the use requirement, the UI component library module is used for self-defining.
(7) The UI component library module submits the relevant information of the UI component to the back-end processing module for storage, or reads the relevant information of the UI component stored before through the back-end processing module and modifies the information.
(8) The system page design module uses predefined or custom UI components for the design of the presentation system pages.
(9) And storing the result of the system page design to generate a Web display system page file.
(10) And then entering an operation mode, when a Web display system page is started, pushing a subscription theme to the WebSocket agent module so as to acquire required data, and when parameters of the page are changed, sending a parameter change notice to the WebSocket agent module so as to acquire the latest data meeting the parameter requirements.
(11) The WebSocket agent module converts the subscription theme into a service query ID and parameters and provides the service query ID and parameters to the service execution engine.
(12) And the business execution engine module reads the corresponding SQL query statement from the support database according to the business query ID and the parameters.
(13) And the business execution engine module executes the SQL query statement obtained in the last step on the business database to retrieve the business data.
(14) And the business execution engine module returns the retrieval result record set to the WebSocket agent module.
(15) And the WebSocket agent module returns the retrieval result serving as display data to the Web display system page module to complete the display work.
Compared with the prior art, the invention has the following advantages:
(1) the invention greatly reduces the difficulty of software development. The most common UI component library and the service query library are predefined, developers only need to directly bind the predefined UI components and the predefined service query through interface operation, other work is automatically completed by the system, programming is not needed, and the service personnel (not program developers) can take the competence. To increase flexibility, the present invention also supports custom UI components and business queries. The invention supports direct modification of the source code of the UI component to generate a brand new UI component and also supports modification of a database query statement (SELECT statement) to generate a brand new business query.
(2) The invention greatly improves the development efficiency. Firstly, the multiplexing of UI components and service query reduces the repeated workload; secondly, the development work is integrated into the binding of picture design and service inquiry, and other work is automatically completed by the system, so that the necessary workload is reduced, and the development efficiency is further improved. In actual use, the development time can be saved by about 50-80%.
The invention is further described with reference to the following figures and detailed description.
Drawings
FIG. 1 is a business flow diagram of the system of the present invention;
FIG. 2 is a system generation flow diagram of the present invention;
FIG. 3 is a flow chart of system deployment of the present invention.
Detailed Description
Referring to fig. 1, the programming-free data visualization Web presentation system of the present invention is composed of a system front end and a system back end. The front end is based on a VUE framework and is written by HTML, JavaScript and CSS languages; the rear end is based on a Springboot framework and is written in Java language. The method is divided into a design mode and an operation mode according to different stages. In the design mode, the front end of the system consists of an application information input module, a service query library module, a UI component library module and a system page design module; the system back end is composed of a back end processing module.
1) And the application information input module is used for inputting or maintaining basic information and menu composition for the development object application system. The method comprises the following specific steps:
(1) and registering basic information of the application system, such as system ID, system name, system abbreviation, system description, application server and port, database server and the like.
(2) Registering a menu tree of an application system, wherein each menu item respectively designates a page ID, a page name, an English name and the like and is used for generating a file directory structure and an initial interface file.
2) And the service query library module is used for maintaining the service query library and preparing service logic for the UI component to obtain data. The method comprises the following specific steps:
(1) service query names and IDs are defined, and each service query corresponds to one record set.
(2) And defining a service query type, wherein the service query type determines a data format returned by the query. When the system runs, the query result returns data in the JSON format, and the data are mainly divided into three basic types according to the difference of JSON data organization modes:
In addition, a variety of extension types are also supported, such as: result set union, virtual field and formula calculation, return field selection, template and reference, bunching, sample, etc.
(3) SQL query statements are defined for business queries. The data type service does not need to define SQL sentences; the single-node type service needs to define an SQL statement; a multi-node type service requires a set of SQL statements to be defined. The system supports online editing and execution of SQL statements and checks SQL execution results or error information so as to carry out SQL debugging.
3) And the UI component library module is used for maintaining a predefined UI component library and providing available UI components for the system page design module. Such as a table, pie chart, bar chart, line chart, etc., may also be a set of controls, or even the entire Web page. In the application development process, if the predefined UI component can meet the system design requirement, the UI component definition is not needed. If not, the UI component can be customized. The invention supports direct editing of the source code of the UI component and provides possibility for flexible extension of the UI component. The invention supports setting the attribute of the UI component, binding the service inquiry ID and the data field, and performing operations such as preview and the like. The UI components are classified into two categories, a simple component and a standard component, according to whether a service query is bound:
(1) simple components, no service attributes, no service query binding, and no service data presentation.
(2) The standard component has a service attribute, can bind a service query ID and a type, and together form a subscription theme ID, and the subscription theme ID determines an SQL statement of database query and a returned result type.
4) And the system page design module is used for designing the user interface of the application system, and the result is the front-end page of the application system. The menu defined by the application information entry module is displayed on the left side of the interface of the module, and the menu can be edited by selecting one page. After the UI component is added, the component attribute is configured, and the service query type and the ID are bound, the page data display effect can be previewed.
5) A back-end processing module as a back-end module for receiving the application information input module and the service inquiry
And the database module and the UI component database module submit requests, and various data such as application system information, service query library information (containing SQL sentences), UI component library information and the like input by a user are stored in the support database, or various data stored before are read from the support database to be modified by the corresponding front-end module.
In the operation mode, the system back end comprises a WebSocket agent module, a service execution engine module and a service database module.
1) And the WebSocket agent module provides topic subscription service based on the session for the client by utilizing a WebSocket protocol. Each subscribed client is independent of the other clients. The content displayed by different clients may be different for the same subscription theme, depending on the parameters set by the user during operation. If the parameters are different, the contents pushed to the client are also different. When a user opens a certain page of an application program, each page firstly subscribes a topic concerned by the user, generally one UI component corresponds to one subscription topic, and a related topic ID is pushed to a WebSocket agency. After receiving the subscription theme ID, the WebSocket agent calls the service execution engine module to inquire, and pushes the result to the client to perform initialization display. When the user modifies the page retrieval condition to change the service query parameter, the WebSocket agent is also informed, and the WebSocket agent calls the service execution engine module again according to the theme influenced by the parameter, and pushes the query result to the client for display.
2) And the business execution engine module comprises a general SQL execution engine, receives the business query ID and the query parameters from the WebSocket agent, loads the corresponding SQL query statement from the support database, executes the SQL query statement and returns the query result to the WebSocket agent. The module loads class libraries of various databases and supports access to common relational databases and MPP data. The module also supports simultaneous access of multiple data sources, and stores a plurality of record sets obtained by query into a service query object according to the service query type.
3) And the service database stores service data as a data source for the query of the service execution engine module. The database belongs to a relational database, can be a supporting database of a production system, can also be an independent database for storing business data backup, and can also be a data mart for storing analysis results in a big data system.
The Web display system also comprises a Web display system page module and a support database module which are used for outputting in a design mode and inputting in a running mode.
1) The Web display system comprises a Web display system page module and an application program generated by a page design module. Embedding the program into a development environment to execute in a design stage so as to support real-time preview effect; in the run-time phase, the compilation is packaged into separate application files for independent deployment.
2) And the support database module is responsible for storing various information input by the user in the design stage, including various data such as application system information, UI component library information, service library information (including SQL sentences) and the like. The data may be a relational database, such as MySQL, a file storage database, such as MongoDB, or even a text file.
The method for realizing the programming-free data visualization Web display system comprises the following steps from a design mode to an operation mode:
(1) starting from an application information input module, the system enters a design mode, and basic information and menu composition of the application are input. And then submitted to the back-end processing module for storage, and meanwhile, the back-end processing module can read and modify the previously stored information.
(2) In the back-end processing module, various definition information submitted by each front-end module is stored in a support database, or various definition information stored before is read from the support database for corresponding front-end picture modification.
(3) And in the application information input module, automatically generating a menu, a file directory structure and an initial interface file according to the input menu information.
(4) If the predefined service query does not meet the use requirement, the service query library module is used for self-defining, and one or a group of service query SQL sentences are defined according to the database specified by the application information entry module.
(5) The business query library module submits the business query SQL sentences defined in the last step to the background processing module for storing in a support database, or reads and modifies the previously stored SQL sentences through the back-end processing module.
(6) The UI component library module sets attributes and binds service inquiry for the predefined UI components, or if the predefined UI components do not meet the use requirement, the UI component library module is used for self-defining.
(7) The UI component library module submits the relevant information of the UI component to the back-end processing module for storage, or reads the relevant information of the UI component stored before through the back-end processing module and modifies the information.
(8) The system page design module uses predefined or custom UI components for the design of the presentation system pages.
(9) And storing the result of the system page design to generate a Web display system page file.
(10) And then entering an operation mode, when a Web display system page is started, pushing a subscription theme to the WebSocket agent module so as to acquire required data, and when parameters of the page are changed, sending a parameter change notice to the WebSocket agent module so as to acquire the latest data meeting the parameter requirements.
(11) The WebSocket agent module converts the subscription theme into a service query ID and parameters and provides the service query ID and parameters to the service execution engine.
(12) And the business execution engine module reads the corresponding SQL query statement from the support database according to the business query ID and the parameters.
(13) And the business execution engine module executes the SQL query statement obtained in the last step on the business database to retrieve the business data.
(14) And the business execution engine module returns the retrieval result record set to the WebSocket agent module.
(15) And the WebSocket agent module returns the retrieval result serving as display data to the Web display system page module to complete the display work.
Referring to fig. 2, the implementation steps of the present invention are as follows:
developers can quickly complete the development of visual display software only through graphical interface operation and the following operations, and other work is automatically completed by the system, which is detailed in figure 1.
(1) S101, inputting application information, and automatically generating a menu and a blank interface corresponding to the menu by filling in relevant information of an application system and configuring menu items.
(2) S102, calling a service query library, and finding out the required service query in a predefined service query library according to the requirement of the display data. If none of the predefined queries in the library can meet the data retrieval requirements, the business query can be customized, and an array, an SQL query statement or a group of SQL query statements is set for the new business query.
(3) S103, calling the UI component library, and finding out the required UI component in the predefined UI component library according to the display mode requirement. If the predefined UI components in the library can not meet the requirements of screen design, the UI components can be defined by users, the attributes are set for the new UI components, the service query is bound, and then the data is loaded for the new UI components.
(4) S104, designing a system page, adding the configured UI component into the screen, and generating a front-end screen of the Web application.
Through the above operations, the system generates a Web application front-end screen, and at the same time, the menu configuration information, the service query definition information, and the UI component definition information are stored in the support database, and these page files and definition information constitute a main body of the Web presentation system, which can be operated not only in a development environment, but also deployed together with a back-end support module, and operated independently apart from the development environment, as shown in fig. 3.
(1) S201 supports database installation and data import, the support database is installed in the operating environment, and data such as menu configuration information, service query information and UI component information stored in the support database in the system design stage are imported into the database.
(2) S202, deploying the service execution engine, namely deploying the service execution engine serving as a system back-end module to a running environment, and providing an engine for the system to execute the SQL query statement.
(3) S203, the service database is connected, the service execution engine points to the service database, and an object is explicitly inquired for the service database.
(4) And S204, deploying the WebSocket agent module to the running environment as a system back-end module so as to receive the theme subscribed by the front-end page and return the retrieval result of the service execution engine.
(5) S205, Web display system page deployment, wherein the Web display system pages are deployed to an operating environment as a system front-end module, and the pages can subscribe topics to the WebSocket agent to obtain display data.
The above embodiments of the present invention are only for illustrating the technical solutions of the present application, and the similar substitutes made by those skilled in the art on the basis of the present application shall all belong to the protection scope of the present application:
(1) the Web page control used in the invention can be an HTML standard control, an Echarts control, and other shared or self-defined components.
(2) Interface information and SQL database query statements input by developers can be stored in a database and can also be stored in a text file;
(3) the database as a data source may be a relational database, or may be a data storage system supporting SQL statements such as an MPP database and a data warehouse.
Claims (8)
1. A programming-free data visualization Web display system is characterized by comprising a system front end and a system back end, and the system front end and the system back end are divided into a design mode and an operation mode according to different stages; in the design mode, the front end of the system consists of an application information input module, a service query library module, a UI component library module and a system page design module; the system back end is composed of a back end processing module;
1) the application information input module is used for inputting or maintaining basic information and menu composition for the development object application system;
2) the service query library module is used for maintaining a service query library and preparing service logic for the UI component to obtain data;
3) the UI component library module is used for maintaining a predefined UI component library and providing available UI components for the system page design module;
4) the system page design module is used for designing a front-end page of the application system by using the UI components in the UI component library;
5) the back-end processing module is used for receiving the data submitted by the modules and storing the data in a support database;
in the operation mode, the system back end comprises a WebSocket agent module, a service execution engine module and a service database module;
1) the WebSocket agent module is used for providing session-based theme subscription service for the UI component based on a WebSocket protocol;
2) the business execution engine module comprises a general SQL execution engine and is used for executing business query and returning a retrieval result;
3) the business database stores business data as a data source for querying the business execution engine module;
the Web display system also comprises a Web display system page module and a support database module which are used for outputting in a design mode and inputting in a running mode;
1) the Web display system comprises a Web display system page module and an application program generated by a page design module;
2) and the support database module is used for storing various information input by the user in the design stage.
2. The programming-free data visualization Web display system according to claim 1, wherein the basic information and menu composition in the application information entry module comprises:
(1) the basic information of the registered application system comprises a system ID, a system name, a system abbreviation, a system description, an application server, a port and a database server;
(2) registering a menu tree of an application system, wherein each menu item respectively designates a page ID, a page name and an English name and is used for generating a file directory structure and an initial interface file.
3. The programming-free data visualization Web presentation system according to claim 1 or 2, wherein said service query library module maintains a service query library and service logic including:
(1) defining service query names and IDs, wherein each service query corresponds to a record set;
(2) defining a service query type, wherein the service query type determines a data format of query return; when the system runs, the query result returns data in the JSON format, and the data are mainly divided into three basic types according to the difference of JSON data organization modes:
1) data type (data): directly returning a predefined service data multidimensional array without querying a database;
2) single node type (node): returning a single node object, wherein the data attribute of the node object corresponds to the service data;
3) multi-node type (multi): returning a plurality of node objects, namely aggregating a plurality of query results to return at one time;
in addition, a variety of extension types are supported, including: result set association, virtual field and formula calculation, return field selection, template and reference, bunching and sampling;
(3) defining SQL query sentences for the business queries; the data type service does not need to define SQL sentences; the single-node type service needs to define an SQL statement; a group of SQL statements needs to be defined by the multi-node type service; the system supports online editing and execution of SQL statements and checks SQL execution results or error information so as to carry out SQL debugging.
4. The programming-free data visualization Web presentation system according to claim 3, wherein said UI component employs a single UI control, such as a table, a pie chart, a bar chart or a line chart, or employs a group of controls, even an entire Web page; the UI components are classified into two categories, a simple component and a standard component, according to whether a service query is bound:
(1) simple components, without service attributes, cannot bind service queries and are not used for displaying service data;
(2) and the standard component has a service attribute and can bind the service query ID and the type, and the service query ID and the type are combined to form the subscription theme ID.
5. The programming-free data visualization Web presentation system of claim 4, wherein the system page design module is configured to use predefined or custom UI components for user interface design of an application system.
6. The programming-free data visualization Web display system of claim 5, wherein the WebSocket agent module provides topic subscription services for the clients, each subscribed client is independent of other clients and subscribes to the same topic, and the content displayed by different clients depends on the parameters set by the user during operation.
7. The programming-free data visualization Web display system of claim 6, wherein the business execution engine module receives the business query ID and the query parameters from the WebSocket agent module, then loads the corresponding SQL query statement from the support database, executes the SQL query statement, and returns the query result to the WebSocket agent.
8. The method for implementing the programming-free data visualization Web display system as claimed in claim 1, wherein the method from the design mode to the operation mode comprises the steps of:
(1) starting from an application information input module, the system enters a design mode, basic information and menu composition of the input application is submitted to a back-end processing module for storage, and meanwhile, the back-end processing module can read and modify the previously stored information;
(2) in the back-end processing module, various definition information submitted by each front-end module is stored in a support database, or various definition information stored before is read from the support database for corresponding front-end picture modification;
(3) in the application information input module, automatically generating a menu, a file directory structure and an initial interface file according to input menu information;
(4) if the predefined service query does not meet the use requirement, self-defining through a service query library module, and defining one or a group of service query SQL sentences according to a database specified by an application information input module;
(5) the business query library module submits the business query SQL sentences defined in the last step to a background processing module for storing into a support database, or reads and modifies the previously stored SQL sentences through a back-end processing module;
(6) the UI component library module sets attributes and binds service query for the predefined UI components, or if the predefined UI components do not meet the use requirements, the UI component library module is used for self-defining;
(7) the UI component library module submits the relevant information of the UI component to the back-end processing module for storage, or reads the relevant information of the UI component stored before through the back-end processing module and modifies the information;
(8) the system page design module uses a predefined or self-defined UI component to design a display system page;
(9) saving the result of the system page design to generate a Web display system page file;
(10) then entering an operation mode, when a Web display system page is started, pushing a subscription theme to the WebSocket agent module so as to acquire required data, and when parameters of the page are changed, sending a parameter change notice to the WebSocket agent module so as to acquire latest data meeting parameter requirements;
(11) the WebSocket agent module converts the subscription theme into a service query ID and parameters and provides the service query ID and parameters to a service execution engine;
(12) the business execution engine module reads a corresponding SQL query statement from a support database according to the business query ID and the parameters;
(13) the business execution engine module executes the SQL query statement obtained in the last step on the business database to retrieve the business data;
(14) the business execution engine module returns a retrieval result record set to the WebSocket agent module;
(15) and the WebSocket agent module returns the retrieval result serving as display data to the Web display system page module to complete the display work.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010860741.2A CN112015413A (en) | 2020-08-25 | 2020-08-25 | Programming-free data visualization Web display system and implementation method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010860741.2A CN112015413A (en) | 2020-08-25 | 2020-08-25 | Programming-free data visualization Web display system and implementation method thereof |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112015413A true CN112015413A (en) | 2020-12-01 |
Family
ID=73505823
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010860741.2A Pending CN112015413A (en) | 2020-08-25 | 2020-08-25 | Programming-free data visualization Web display system and implementation method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112015413A (en) |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111966738A (en) * | 2020-08-20 | 2020-11-20 | 广东优触感科技有限公司 | System for automatically realizing back-end programming by selecting front-end configuration |
| CN112671795A (en) * | 2020-12-30 | 2021-04-16 | 南方电网深圳数字电网研究院有限公司 | Security protection method, device, system and storage medium based on instant messaging |
| CN112685015A (en) * | 2020-12-31 | 2021-04-20 | 魔元术(苏州)信息科技有限公司 | Low-code quick digital development system for new retail |
| CN112711677A (en) * | 2021-01-08 | 2021-04-27 | 北京仿真中心 | Visual management device and method for Neo4j graph database |
| CN113032708A (en) * | 2021-04-02 | 2021-06-25 | 广州博恒信息科技有限责任公司 | Code-free Web development system |
| CN113126979A (en) * | 2021-04-16 | 2021-07-16 | 多点(深圳)数字科技有限公司 | Visual business building system capable of achieving secondary programming by separating from server |
| CN113220278A (en) * | 2021-06-04 | 2021-08-06 | 上海天旦网络科技发展有限公司 | Page construction method, system, medium and device suitable for multiple scenes |
| CN113486047A (en) * | 2021-07-12 | 2021-10-08 | 上海天旦网络科技发展有限公司 | System for investigating and analyzing target passenger group |
| CN113590110A (en) * | 2021-07-16 | 2021-11-02 | 山东派盟网络科技有限公司 | Frame construction method, device and equipment |
| CN113641346A (en) * | 2021-07-08 | 2021-11-12 | 福建通慧教育科技有限公司 | Intelligent auxiliary tool for standardized programming and working method thereof |
| CN113687850A (en) * | 2021-08-31 | 2021-11-23 | 南京数字跳动网络技术有限公司 | Client unified configuration center system based on component library |
| CN113703749A (en) * | 2021-09-06 | 2021-11-26 | 河北雄安新区公安局 | Information system based on visual programming technology and construction method thereof |
| CN117435678A (en) * | 2023-12-18 | 2024-01-23 | 山东山大华天软件有限公司 | System integration method and system based on intermediate data pool and visual customization |
| CN113687850B (en) * | 2021-08-31 | 2024-05-14 | 南京数字跳动网络技术有限公司 | Unified configuration center system of client based on component library |
-
2020
- 2020-08-25 CN CN202010860741.2A patent/CN112015413A/en active Pending
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111966738A (en) * | 2020-08-20 | 2020-11-20 | 广东优触感科技有限公司 | System for automatically realizing back-end programming by selecting front-end configuration |
| CN111966738B (en) * | 2020-08-20 | 2023-10-27 | 广东优触感科技有限公司 | System for automatically realizing back-end programming by selecting front-end configuration |
| CN112671795A (en) * | 2020-12-30 | 2021-04-16 | 南方电网深圳数字电网研究院有限公司 | Security protection method, device, system and storage medium based on instant messaging |
| CN112685015A (en) * | 2020-12-31 | 2021-04-20 | 魔元术(苏州)信息科技有限公司 | Low-code quick digital development system for new retail |
| CN112711677A (en) * | 2021-01-08 | 2021-04-27 | 北京仿真中心 | Visual management device and method for Neo4j graph database |
| CN113032708A (en) * | 2021-04-02 | 2021-06-25 | 广州博恒信息科技有限责任公司 | Code-free Web development system |
| CN113126979B (en) * | 2021-04-16 | 2022-03-25 | 多点(深圳)数字科技有限公司 | Visual business building system capable of achieving secondary programming by separating from server |
| CN113126979A (en) * | 2021-04-16 | 2021-07-16 | 多点(深圳)数字科技有限公司 | Visual business building system capable of achieving secondary programming by separating from server |
| CN113220278A (en) * | 2021-06-04 | 2021-08-06 | 上海天旦网络科技发展有限公司 | Page construction method, system, medium and device suitable for multiple scenes |
| CN113641346A (en) * | 2021-07-08 | 2021-11-12 | 福建通慧教育科技有限公司 | Intelligent auxiliary tool for standardized programming and working method thereof |
| CN113486047A (en) * | 2021-07-12 | 2021-10-08 | 上海天旦网络科技发展有限公司 | System for investigating and analyzing target passenger group |
| CN113590110A (en) * | 2021-07-16 | 2021-11-02 | 山东派盟网络科技有限公司 | Frame construction method, device and equipment |
| CN113687850A (en) * | 2021-08-31 | 2021-11-23 | 南京数字跳动网络技术有限公司 | Client unified configuration center system based on component library |
| CN113687850B (en) * | 2021-08-31 | 2024-05-14 | 南京数字跳动网络技术有限公司 | Unified configuration center system of client based on component library |
| CN113703749A (en) * | 2021-09-06 | 2021-11-26 | 河北雄安新区公安局 | Information system based on visual programming technology and construction method thereof |
| CN117435678A (en) * | 2023-12-18 | 2024-01-23 | 山东山大华天软件有限公司 | System integration method and system based on intermediate data pool and visual customization |
| CN117435678B (en) * | 2023-12-18 | 2024-04-23 | 山东山大华天软件有限公司 | System integration method and system based on intermediate data pool and visual customization |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112015413A (en) | Programming-free data visualization Web display system and implementation method thereof | |
| US9483257B2 (en) | Universal and adaptive software development platform for data-driven applications | |
| US7624114B2 (en) | Automatically generating web forms from database schema | |
| CN110032604B (en) | Data storage device, translation device and database access method | |
| US9804837B2 (en) | System and method for creating, managing, and reusing schema type definitions in services oriented architecture services, grouped in the form of libraries | |
| US20160299745A1 (en) | Development method for web development system, and web development system | |
| CN109582647B (en) | Unstructured evidence file oriented analysis method and system | |
| CN110825388B (en) | Method for directly converting SQL statement into corresponding REST interface | |
| US10120886B2 (en) | Database integration of originally decoupled components | |
| US20040167896A1 (en) | Content management portal and method for communicating information | |
| CN104102710A (en) | Massive data query method | |
| Kongdenfha et al. | Rapid development of spreadsheet-based web mashups | |
| US20080263142A1 (en) | Meta Data Driven User Interface System and Method | |
| US20090144314A1 (en) | System and method for dynamically configuring a multi-model node table | |
| CN110764820A (en) | Method and system for automatically generating development document based on code annotation | |
| WO2024001493A1 (en) | Visual data analysis method and device | |
| US20040167905A1 (en) | Content management portal and method for managing digital assets | |
| CN115576974A (en) | Data processing method, device, equipment and medium | |
| CN113821565B (en) | Method for synchronizing data by multiple data sources | |
| US20200364220A1 (en) | Object-based query language conversion and enrichment for database queries | |
| CN113448562B (en) | Automatic logic code generation method and device and electronic equipment | |
| US20080263018A1 (en) | Method and System for Mapping Business Objects to Relational Database Tables | |
| US7712088B2 (en) | Method and system for a batch parser | |
| CN109948133B (en) | Data form realization method based on Layu | |
| CN116400914A (en) | Method for quickly constructing web application based on data model |
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 |