WO2019153514A1

WO2019153514A1 - Service system dynamic generation method and apparatus, computer device, and storage medium

Info

Publication number: WO2019153514A1
Application number: PCT/CN2018/083819
Authority: WO
Inventors: 林水明
Original assignee: 平安科技（深圳）有限公司
Priority date: 2018-02-12
Filing date: 2018-04-20
Publication date: 2019-08-15
Also published as: CN108446327A

Abstract

Embodiments of the present application disclose a service system dynamic generation method and apparatus, a computer device, and a storage medium. The method comprises: if it is detected that a menu in a user interface is selected, obtaining a configuration code corresponding to the selected menu; retrieving and querying a corresponding configuration model in a graph database according to the configuration code, and loading the configuration model into a memory for storage; correspondingly generating a display page comprising a data table according to the configuration model stored in the memory; if a data operation on the data table is detected, correspondingly generating an SQL script according to an operation type of the data operation and service data selected by the data operation; and executing the SQL script and feeding back a corresponding service data processing result. According to the method, configuration data is stored in a graph database and service data is stored in a relational database, so that after configuration is completed, service data can be displayed and correlatively operated without editing a script.

Description

Business system dynamic generation method, device, computer equipment and storage medium

This application claims the priority of the Chinese patent application filed on February 12, 2018, the Chinese Patent Office, application number 201810144173.9, and the application name is "business system dynamic generation method, device, computer equipment and storage medium", the entire contents of which are The citations are incorporated herein by reference.

Technical field

The present application relates to the field of database configuration management technologies, and in particular, to a method, an apparatus, a computer device, and a storage medium for dynamically generating a service system.

Background technique

The CMDB (Configuration Management Database) stores and manages various configuration information of devices in the enterprise IT architecture. It is closely linked to all service support and service delivery processes to support the operation of these processes and the value of configuration information. At the same time, relying on relevant processes to ensure the accuracy of the data. The CMDB software focuses on the management of information (acquisition, integration, recording, maintenance, inspection, update, etc.), while the database focuses on the physical storage of information, and the two are closely related. The function of CMDB requires specialized CMDB management software, which is difficult to complete directly on traditional databases. Because the management of configuration information is the core function of CMDB, and this part of the function is difficult to implement by database software.

At present, the commonly used CMDB system generally stores business data and configuration data in a data table of a relational database, which has the following defects:

1. The configuration data is coupled with the business data dependency, which causes the enterprise to perform data conversion according to its fixed mode;

2. The database ER model does not reflect the business model. Once the application is switched, there is a major hidden danger in data migration.

3. The service configuration data exists in a table, and the data query speed is inefficient.

Summary of the invention

The present application provides a method, an apparatus, a computer device and a storage medium for dynamically generating a business system, which are intended to solve the data table in the prior art in which the configuration data of the CMDB based on the graph database is coupled with the service data and stored in the relational database. In the middle, the database ER model does not reflect the business model, and the data query speed is inefficient.

In a first aspect, the present application provides a method for dynamically generating a service system, including: if it is detected that a menu in a user interface is selected, obtaining a configuration code corresponding to a selected menu; and correspondingly searching for a query according to a configuration code in a graphic database. The configuration model is loaded into the memory for storage; the display page including the data table is generated according to the configuration model stored in the memory; if the data operation on the data table is detected, the operation type and data operation according to the data operation are selected. The specified business data is generated corresponding to the SQL script; the SQL script is executed, and the corresponding business data processing result is fed back.

In a second aspect, the application provides a service system dynamic generation apparatus, including:

Configuring a code retrieval unit, configured to: if it is detected that a menu in the user interface is selected, obtain a configuration code corresponding to the selected menu;

The code loading unit is configured to retrieve a configuration model corresponding to the query in the graphic database according to the configuration code, and load the file into the memory for storage;

a display page generating unit, configured to generate a display page including a data table according to a configuration model stored in the memory;

The SQL script generating unit is configured to generate a SQL script according to the operation type of the data operation and the service data selected by the data operation if the data operation on the data table is detected;

The data result feedback unit is configured to execute the SQL script and feed back the corresponding business data processing result.

In a third aspect, the present application further provides a computer device comprising a memory, a processor, and a computer program stored on the memory and operable on the processor, the processor implementing the computer program The business system dynamic generation method according to any one of the preceding claims.

In a fourth aspect, the present application also provides a storage medium, wherein the storage medium stores a computer program, the computer program comprising program instructions, the program instructions, when executed by a processor, causing the processor to execute the application The business system dynamic generation method of any of the provided.

The application provides a method, an apparatus, a computer device and a storage medium for dynamically generating a business system. The method saves the configuration data through the graphic database, and the relational database stores the business data. After the configuration is completed, the display of the business data and the related operations of the data can be completed without editing the script.

DRAWINGS

In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings used in the description of the embodiments will be briefly described below. Obviously, the drawings in the following description are some embodiments of the present application, For the ordinary technicians, other drawings can be obtained based on these drawings without any creative work.

1a is a schematic diagram of a three-layer structure of a specific graphics database in an embodiment of the present application;

FIG. 1b is a schematic flowchart of a method for dynamically generating a service system according to an embodiment of the present application;

2 is a schematic diagram of a sub-flow of a method for dynamically generating a service system according to an embodiment of the present application;

FIG. 3 is a schematic diagram of another sub-flow of a method for dynamically generating a service system according to an embodiment of the present application;

FIG. 4 is a schematic flowchart of another sub-flow of a method for dynamically generating a service system according to an embodiment of the present disclosure;

FIG. 5 is a schematic block diagram of a service system dynamic generation apparatus according to an embodiment of the present application;

FIG. 6 is a schematic block diagram of a subunit of a service system dynamic generation apparatus according to an embodiment of the present disclosure;

FIG. 7 is a schematic block diagram of another subunit of a service system dynamic generating apparatus according to an embodiment of the present disclosure;

FIG. 8 is a schematic block diagram of another subunit of a service system dynamic generating apparatus according to an embodiment of the present disclosure;

FIG. 9 is a schematic block diagram of a computer device according to an embodiment of the present application.

Detailed ways

The technical solutions in the embodiments of the present application are clearly and completely described in the following with reference to the drawings in the embodiments of the present application. It is obvious that the described embodiments are a part of the embodiments of the present application, and not all of the embodiments. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments of the present application without departing from the inventive scope are the scope of the present application.

For convenience of understanding, the graphic database, the CMDB application system and the relational database involved in the embodiments of the present application are introduced below.

In a graph database, multiple kernel configurations are stored (kernel configuration can also be called a configuration model). The configuration model is a standard graphical structure. Refer to Figure 1a for the specific graphic structure. As shown in FIG. 1a, the configuration model is divided into three layers, as follows:

The top layer is the page layer (ViewGroup), which is an abstraction of the basic information of the page, mainly including the basic information of the page, such as: page name, page encoding and other information.

The middle layer is the business view layer (View), which is an abstraction of business data. Each View can be understood as a data table in the page, which mainly contains the name, code, View type and View component type of the business view. Each business view View is composed of one or more Entities of the ER layer. Among them, the View type mainly includes: a. Topology map type, mainly used to display data association view; b. Business data type, mainly used to display page table data. The component types of View mainly include: a. data table; b. other data display components, such as tree diagrams, histograms and other data display components.

The bottom layer is the ER layer, which is mainly a representation of the relational database ER model. It is used to provide the basis for the management of the business data required by the business view layer View. The ER layer mainly contains Entity/Attribute (where Entity represents Entity, Attribute represents the attribute of the entity) and the relationship between Entity and Entity, and the relationship between Entity and its Attribute. Among them, Entity mainly contains information such as table name, table alias and other information, whether it is editable or not; Attribute mainly contains information such as attribute name, encoding, whether it is visible, and whether it can be edited.

After understanding the basics of the graphical database, the following is a brief introduction to the CMDB application system. The CMDB application system is divided into three layers. The user-oriented and directly visible to the user is the page. The next layer of the page is the CMDB application system layer, and the next layer is the background graphics database and the relational database (graphic database, And the relational database is connected with the CMDB application system layer, that is, the CMDB application system layer can obtain data from the graphical database and the relational database).

The graphics database includes multiple configuration models, and each configuration model is composed of the above three layers (ie, a page layer, a service view layer, and an ER layer), and each of the service model layers in the configuration model includes at least one service view. Layer nodes are displayed in the business view layer.

Referring to FIG. 1b, FIG. 1b is a schematic flowchart of a method for dynamically generating a service system according to an embodiment of the present application. The method is applied to terminals such as desktop computers, laptop computers, and tablet computers. As shown in FIG. 1b, the method includes steps S101 to S105.

S101. If it is detected that a menu in the user interface is selected, obtain a configuration code corresponding to the selected menu.

In this embodiment, a plurality of menus are set on the user-oriented user interface, that is, the menu is set on the interface in the CMDB application system. Each time you click on a menu, a new interface will be displayed, which is a feedback to the user's selected action. Since each menu set on the user interface corresponds to a unique configuration code, when the menu is selected, its configuration code is obtained according to the selected menu. In the present application, the configuration code is a configuration model in a mapping graph database. Each time a menu is clicked, the configuration database corresponding to the configuration code is retrieved in the graphics database, and the page including the data table is rendered according to the retrieved configuration model to visually display the business data on the page in the CMDB application system.

S102. The root retrieves a configuration model corresponding to the query in the graphics database according to the configuration code, and loads the file into the memory for storage.

In this embodiment, a plurality of configuration models are stored in the graphics database, and each configuration model includes a page layer, a service view layer, and an ER layer. The configuration models in the graph database are all pre-set, that is, the user pre-configures various configuration models in the graph database, and these configuration models are stored in the graph database to realize separation from the business data.

In an embodiment, the graphics database is a NEO4J graphics database. NEO4J is a high-performance NOSQL (NOSQL refers to non-relational database) graphical database that stores structured data on the network rather than in the table. NEO4J can also be seen as a high-performance graph engine with all the features of a mature database. A diagram of the NEO4J graph database contains two basic data types: Nodes and Relationships. Nodes and Relationships contain attributes in the form of key/value. Nodes are connected by relationships defined by Relationships to form a relational network structure.

In an embodiment, after obtaining the configuration code of the menu, the configuration model corresponding to the configuration code is queried by using a Cypher script. The query language of the Cypher script contains the following obvious parts:

1) START: At the beginning of the graph, it is obtained by the ID or index of the element. 2) MATCH: The matching mode of the graphic, bound to the starting point. 3) WHERE: Filter conditions. 4) RETURN: Returns what is needed.

For example, there is a query that finds a friend of a friend named John in the index (not his direct friend) by traversing the graph, and returns the friend of John and the friend who found it. The corresponding Cypher script is as follows:

START john=node:node_auto_index(name='John')

MATCH john-[:friend]->()-[:friend]->fof

RETURN john,fof

After the configuration model corresponding to the configuration code is queried by the Cypher script, the configuration model is stored in the memory.

S103. Generate a display page including a data table according to a configuration model stored in the memory.

In this embodiment, after the configuration model is stored in the memory in the CMDB application system, the data table needs to be rendered according to the configuration model. At this time, the configuration model needs to be parsed and the data table is created correspondingly, and the service data is filled in the data table. The area of the display page in the CMDB application system is displayed. In this way, through the data table, the business data corresponding to the selected menu is displayed, and the business data can be selected for other operations (such as adding business data, modifying business data, editing business data, querying business data, etc.) ). In the present application, the ER relationship between the business data is managed by the configuration model and stored in the graph database, which reduces the dependency coupling between the configuration data and the business data.

As shown in FIG. 2, the step S103 includes the following sub-steps:

S1031: Transfer the configuration model stored in the memory to the browser;

S1032: Obtain a data model corresponding to the configuration model by using js parsing at a front end of the browser; wherein the data model includes a service view layer and an ER layer;

S1033. Create a data table in the display page according to the data model, fill the data table corresponding to the data model into the data table, and display the data table on the display page.

In this embodiment, the configuration model stored in the memory is transmitted to the browser (the browser can be regarded as a specific example of the user interface), and parsed, acquired, and configured in the corresponding area of the display page of the browser. The data model corresponding to the model. The configuration model is transmitted to the browser in a data format of json (JavaScript Object Notation, which is a lightweight data exchange format), and is parsed at the front end of the browser to obtain and configure the business view layer included in the model. The corresponding data and the corresponding data of the ER layer (the data corresponding to the page layer in the configuration model need not be acquired), and the data model is composed of the corresponding data of the business view layer and the corresponding data of the ER layer. After the data model is acquired, the data table can be rendered in the corresponding area of the browser display page according to the data model, and the business data is filled. In the application, the table creation script is automatically generated according to the corresponding data of the business view layer, and the business data is extracted according to the corresponding data of the ER layer and correspondingly inserted into the corresponding position of the data table, thereby realizing automatic table construction in the background of the browser, and the user viewing the business data is more intuitive. . Moreover, the ER layer model corresponding to the business data can be called in real time, and the ER model of the business data can be visually reflected.

As shown in FIG. 3, in step S1033, a data table is created in the display page according to the data model, and the data rendering corresponding to the data model is filled into the data table, including the following sub-steps:

S10331. Generate a data table according to a business view layer of the data model.

S10332. Generate a column in the data table according to an attribute of each entity included in the ER layer.

S10333: Fill the corresponding data with the entity to the corresponding column in the data table.

In this embodiment, the process of creating a data table in the display page according to the data model, and filling the data rendering corresponding to the data model into the data table is an automated execution process. That is, the data table is first generated by the table name corresponding to the business view layer of the data model, such as by the create statement; then the columns in the data table are generated according to the attributes of each entity included in the ER layer, such as by the add colnew statement. Finally, the corresponding data rendering with the entity is filled into the corresponding column in the data table, that is, the automated table construction and data rendering filling process is completed.

S104. If a data operation on the data table is detected, the SQL script is generated according to the operation type of the data operation and the service data selected by the data operation.

As shown in FIG. 4, step S104 includes the following sub-steps:

S1041: If the operation type of the data operation is an increase data operation, generate a first SQL script according to the service view layer node corresponding to the data table in the display page, and the data to be added;

S1042: If the operation type of the data operation is a delete data operation, generate a second SQL script according to the service view layer node corresponding to the data table in the display page and the data to be deleted;

S1043. If the operation type of the data operation is an edit data operation, generate a third SQL script according to the service view layer node corresponding to the data table in the display page and the data to be edited;

S1044. If the operation type of the data operation is a query data operation, generate a fourth SQL script according to the service view layer node corresponding to the data table in the display page and the data to be queried.

In this embodiment, if the data operation on the data table is detected, the operation type of the data operation needs to be determined first. The operations for the database generally include adding data operations, deleting data operations, editing data operations, and querying data operations. Therefore, when the business data is selected and the data operation is performed, the SQL script is automatically generated by displaying the business view layer node corresponding to the data table in the page and the data to be operated; for example, if the operation type of the data operation is increasing data operation, Then, according to the business view layer node corresponding to the data table in the display page, and the data to be added, a first SQL script including an insert statement is generated; similarly, if the operation type of the data operation is a delete data operation, according to the data table in the display page Corresponding business view layer node and data to be deleted generate a second SQL script including a delete statement; if the operation type of the data operation is an edit data operation, according to the business view layer node corresponding to the data table in the display page, and to be edited The data generates a third SQL script including an update statement; if the operation type of the data operation is a query data operation, generating a fourth SQL including a select statement according to the business view layer node corresponding to the data table in the display page and the data to be queried script.

S105. Execute the SQL script and feed back the corresponding service data processing result.

In this embodiment, the SQL script is executed in the Mybatis framework, and the target data is operated according to the SQL script in the relational database (such as adding data operations, deleting data operations, editing data operations, and querying data operations), completing the data. After the operation, the operation succeeds or the operation fails (ie, the corresponding service data processing result is fed back) on the user page. In this way, data management can be performed by intuitively performing various operations on the background business data through the data table.

It can be seen that the method saves the configuration data through the graphic database, and the relational database saves the business data. After the configuration is completed, the display of the business data and the related operations of the data can be completed without editing the script, thereby realizing the separation from the business data and reducing the configuration. Dependency coupling between data and business data. Moreover, the configuration data and the service data configuration data and the business data are not stored in the same table, which improves the efficiency of data operation.

The embodiment of the present application further provides a service system dynamic generation device, where the service system dynamic generation device is configured to execute any of the foregoing business system dynamic generation methods. Specifically, please refer to FIG. 5. FIG. 5 is a schematic block diagram of a service system dynamic generation apparatus according to an embodiment of the present application. The business system dynamic generation device 100 can be installed in a desktop computer, a tablet computer, a laptop computer, or the like.

As shown in FIG. 5, the business system dynamic generation apparatus 100 includes a configuration code retrieval unit 101, a configuration code loading unit 102, a presentation page generation unit 103, an SQL script generation unit 104, and a data result feedback unit 105.

The configuration code retrieval unit 101 is configured to acquire a configuration code corresponding to the selected menu if it is detected that the menu in the user interface is selected.

In this embodiment, a plurality of menus are set on the user-oriented user interface, that is, the menu is set on the interface in the CMDB application system. Each time you click on a menu, a new interface will be displayed, which is a feedback to the user's selected action. Since each menu set on the user interface corresponds to a unique configuration code, when the menu is selected, the configuration code is obtained according to the selected menu. In the present application, the configuration code is a configuration model in a mapping graph database. Each time a menu is clicked, the configuration database corresponding to the configuration code is retrieved in the graphics database, and the page including the data table is rendered according to the retrieved configuration model to visually display the business data on the page in the CMDB application system.

The configuration code loading unit 102 is configured to retrieve a configuration model corresponding to the query in the graphics database according to the configuration code, and load it into the memory for storage.

The display page generating unit 103 is configured to generate a display page including the data table according to the configuration model stored in the memory.

The SQL script generating unit 104 is configured to generate a SQL script according to the operation type of the data operation and the service data selected by the data operation if the data operation on the data table is detected;

The data result feedback unit 105 is configured to execute the SQL script and feed back the corresponding service data processing result.

As shown in FIG. 6, the presentation page generating unit 103 includes the following subunits:

The configuration model transmission unit 1031 is configured to transmit the configuration model stored in the memory to the browser; the parsing unit 1032 is configured to obtain a data model corresponding to the configuration model by parsing the front end of the browser; wherein The data model includes a business view layer and an ER layer; a data table generating unit 1033 is configured to create a data table in the display page according to the data model, fill the data table corresponding to the data model into the data table, and display the data table in the display page. display.

As shown in FIG. 7, the data table generating unit 1033 includes the following subunits: a table producing unit 10331 for generating a data table according to the business view layer of the data model, and a column generating unit 10332 for including each of the ER layers The attribute of an entity generates a column in the data table; the data rendering unit 10333 is configured to fill the corresponding data of the entity to the corresponding column in the data table.

As shown in FIG. 8, the SQL script generating unit 104 includes the following subunits:

The first script generating unit 1041 is configured to generate a first SQL script according to the service view layer node corresponding to the data table in the display page and the data to be added if the operation type of the data operation is an increase data operation;

The second script generating unit 1042 is configured to generate a second SQL script according to the service view layer node corresponding to the data table in the display page and the data to be deleted if the operation type of the data operation is a delete data operation;

The third script generating unit 1043 is configured to generate a third SQL script according to the business view layer node corresponding to the data table in the display page and the data to be edited if the operation type of the data operation is an edit data operation;

The fourth script generating unit 1044 is configured to generate a fourth SQL script according to the service view layer node corresponding to the data table in the display page and the data to be queried if the operation type of the data operation is a query data operation.

It can be seen that the device saves the configuration data through the graphic database, and the relational database stores the business data. After the configuration is completed, the display of the business data and the related operations of the data can be completed without editing the script, thereby realizing the separation from the business data and reducing the configuration. Dependency coupling between data and business data. Moreover, the configuration data and the service data configuration data and the business data are not stored in the same table, which improves the efficiency of data operation.

The above business system dynamic generation device can be implemented in the form of a computer program that can be run on a computer device as shown in FIG.

Please refer to FIG. 9. FIG. 9 is a schematic block diagram of a computer device according to an embodiment of the present application. The computer device 500 device can be a terminal. The terminal can be an electronic device such as a tablet computer, a notebook computer, a desktop computer, or a personal digital assistant.

Referring to FIG. 9, the computer device 500 includes a processor 502, a memory, and a network interface 505 connected by a system bus 501, wherein the memory can include a non-volatile storage medium 503 and an internal memory 504. The non-volatile storage medium 503 can store an operating system 5031 and a computer program 5032. The computer program 5032 includes program instructions that, when executed, cause the processor 502 to perform a business system dynamic generation method. The processor 502 is used to provide computing and control capabilities to support the operation of the entire computer device 500. The internal memory 504 provides an environment for the operation of the computer program 5032 in the non-volatile storage medium 503, which when executed by the processor 502, may cause the processor 502 to perform a business system dynamic generation method. The network interface 505 is used for network communication, such as sending assigned tasks and the like. It will be understood by those skilled in the art that the structure shown in FIG. 9 is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation of the computer device 500 to which the solution of the present application is applied, and a specific computer device. 500 may include more or fewer components than shown, or some components may be combined, or have different component arrangements.

The processor 502 is configured to run a computer program 5032 stored in the memory to implement a function of: if it is detected that a menu in the user interface is selected, acquiring a configuration code corresponding to the selected menu; Retrieving the configuration model corresponding to the query in the database, and loading it into the memory for storage; generating a display page including the data table according to the configuration model stored in the memory; if the data operation on the data table is detected, the operation type according to the data operation And the business data selected by the data operation corresponds to generate a SQL script; execute the SQL script, and feed back the corresponding business data processing result.

The graphic database stores a plurality of configuration models, and each configuration model includes a page layer, a business view layer, and an ER layer.

In an embodiment, the processor 502 further performs the operations of: transmitting the configuration model stored in the memory to the browser; and parsing through the js at the front end of the browser to obtain a data model corresponding to the configuration model; The data model includes a business view layer and an ER layer; a data table is created in the display page according to the data model, data rendering corresponding to the data model is filled into the data table, and the data table is displayed on the display page.

In an embodiment, the processor 502 further performs: generating a data table according to the business view layer of the data model; generating a column in the data table according to an attribute of each entity included in the ER layer; and rendering the data corresponding to the entity Go to the corresponding column in the data table.

In an embodiment, the processor 502 further performs the following operations: if the operation type of the data operation is an increase data operation, generating a first SQL script according to the service view layer node corresponding to the data table in the display page and the data to be added; The operation type of the data operation is a delete data operation, and a second SQL script is generated according to the business view layer node corresponding to the data table in the display page and the data to be deleted; if the operation type of the data operation is an edit data operation, according to the data in the display page The service view layer node corresponding to the table and the data to be edited generate a third SQL script; if the operation type of the data operation is a query data operation, the business view layer node corresponding to the data table in the display page and the data to be queried are generated. Four SQL scripts.

It will be understood by those skilled in the art that the embodiment of the computer device shown in FIG. 9 does not constitute a limitation on the specific configuration of the computer device. In other embodiments, the computer device may include more or fewer components than illustrated. Or combine some parts, or different parts. For example, in some embodiments, the computer device may include only a memory and a processor. In such an embodiment, the structure and functions of the memory and the processor are the same as those of the embodiment shown in FIG. 9, and details are not described herein.

It should be understood that, in the embodiment of the present application, the processor 502 may be a central processing unit (CPU), and the processor 502 may also be another general-purpose processor, a digital signal processor (DSP), Application Specific Integrated Circuit (ASIC), Field-Programmable Gate Array (FPGA) or other programmable logic device, discrete gate or transistor logic device, discrete hardware component, etc. The general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.

In another embodiment of the present application, a storage medium is provided. The storage medium can be a non-transitory computer readable storage medium. The storage medium stores a computer program, wherein the computer program includes program instructions. When the program instruction is executed by the processor, the business system dynamic generation method of the embodiment of the present application is implemented.

The storage medium may be an internal storage unit of the aforementioned device, such as a hard disk or a memory of the device. The storage medium may also be an external storage device of the device, such as a plug-in hard disk equipped on the device, a smart memory card (SMC), a secure digital (SD) card, and a flash memory card. (Flash Card), etc. Further, the storage medium may also include both an internal storage unit of the device and an external storage device.

A person skilled in the art can clearly understand that for the convenience and brevity of the description, the specific working process of the device, the device and the unit described above can refer to the corresponding process in the foregoing method embodiment, and details are not described herein again.

The foregoing is only a specific embodiment of the present application, but the scope of protection of the present application is not limited thereto, and any equivalents can be easily conceived by those skilled in the art within the technical scope disclosed in the present application. Modifications or substitutions are intended to be included within the scope of the present application. Therefore, the scope of protection of this application should be determined by the scope of protection of the claims.

Claims

A method for dynamically generating a business system, comprising:

If it is detected that the menu in the user interface is selected, the configuration code corresponding to the selected menu is obtained;

Retrieving the configuration model corresponding to the query in the graphics database according to the configuration code, and loading it into the memory for storage;

Generating a display page including a data table according to a configuration model stored in the memory;

If the data operation on the data table is detected, the SQL script is generated according to the operation type of the data operation and the service data selected by the data operation;

Execute the SQL script and feed back the corresponding business data processing results.
The method for dynamically generating a business system according to claim 1, wherein the graphic database stores a plurality of configuration models, each of which includes a page layer, a business view layer, and an ER layer.
The method for dynamically generating a service system according to claim 1, wherein the generating a display page including the data table according to the configuration model stored in the memory comprises:

Transfer the configuration model stored in the memory to the browser;

Obtaining a data model corresponding to the configuration model by parsing the front end of the browser; wherein the data model includes a business view layer and an ER layer;

Create a data table in the display page according to the data model, fill the data table corresponding to the data model into the data table, and display the data table in the display page.
The method for dynamically generating a business system according to claim 3, wherein the data table is created in the display page according to the data model, and the data corresponding to the data model is rendered into the data table, including:

Generating a data table according to the business view layer of the data model;

Generating columns in the data table based on attributes of each entity included in the ER layer;

The data corresponding to the entity is rendered into the corresponding column in the data table.
The method for dynamically generating a business system according to claim 1, wherein the generating the SQL script according to the operation type of the data operation and the service data selected by the data operation comprises:

If the operation type of the data operation is an increase data operation, generate a first SQL script according to the service view layer node corresponding to the data table in the display page and the data to be added;

If the operation type of the data operation is a delete data operation, generate a second SQL script according to the service view layer node corresponding to the data table in the display page and the data to be deleted;

If the operation type of the data operation is an edit data operation, generate a third SQL script according to the business view layer node corresponding to the data table in the display page and the data to be edited;

If the operation type of the data operation is a query data operation, a fourth SQL script is generated according to the business view layer node corresponding to the data table in the display page and the data to be queried.
A service system dynamic generation device, comprising:

Configuring a code retrieval unit, configured to: if it is detected that a menu in the user interface is selected, obtain a configuration code corresponding to the selected menu;

The code loading unit is configured to retrieve a configuration model corresponding to the query in the graphic database according to the configuration code, and load the file into the memory for storage;

a display page generating unit, configured to generate a display page including a data table according to a configuration model stored in the memory;

The SQL script generating unit is configured to generate a SQL script according to the operation type of the data operation and the service data selected by the data operation if the data operation on the data table is detected;

The data result feedback unit is configured to execute the SQL script and feed back the corresponding business data processing result.
The business system dynamic generation device according to claim 6, wherein the graphic database stores a plurality of configuration models, each of which includes a page layer, a business view layer, and an ER layer.
The service system dynamic generating apparatus according to claim 6, wherein the display page generating unit comprises:

Configuring a model transmission unit for transmitting a configuration model stored in the memory to the browser;

a parsing unit, configured to parse a data model corresponding to the configuration model by using js parsing at a front end of the browser; wherein the data model includes a service view layer and an ER layer;

The data table generating unit is configured to create a data table in the display page according to the data model, fill the data table corresponding to the data model into the data table, and display the data table in the display page.
The service system dynamic generating apparatus according to claim 8, wherein the data table generating unit comprises:

a form production unit for generating a data table according to a business view layer of the data model;

a column generating unit, configured to generate a column in the data table according to an attribute of each entity included in the ER layer;

A data rendering unit is configured to fill the corresponding data of the entity to the corresponding column in the data table.
The business system dynamic generating apparatus according to claim 6, wherein the SQL script generating unit comprises:

a first script generating unit, configured to generate a first SQL script according to the business view layer node corresponding to the data table in the display page and the data to be added if the operation type of the data operation is an increase data operation;

a second script generating unit, configured to generate a second SQL script according to the service view layer node corresponding to the data table in the display page and the data to be deleted if the operation type of the data operation is a delete data operation;

a third script generating unit, configured to generate a third SQL script according to the business view layer node corresponding to the data table in the display page and the data to be edited if the operation type of the data operation is an edit data operation;

The fourth script generating unit is configured to generate a fourth SQL script according to the business view layer node corresponding to the data table in the display page and the data to be queried if the operation type of the data operation is a query data operation.
A computer apparatus comprising a memory, a processor, and a computer program stored on the memory and operative on the processor, wherein the processor, when executing the computer program, implements the following steps:

If it is detected that the menu in the user interface is selected, the configuration code corresponding to the selected menu is obtained;

Retrieving the configuration model corresponding to the query in the graphics database according to the configuration code, and loading it into the memory for storage;

Generating a display page including a data table according to a configuration model stored in the memory;

If the data operation on the data table is detected, the SQL script is generated according to the operation type of the data operation and the service data selected by the data operation;

Execute the SQL script and feed back the corresponding business data processing results.
The computer device according to claim 11, wherein the graphic database stores a plurality of configuration models, each of which includes a page layer, a business view layer, and an ER layer.
The computer device according to claim 11, wherein the generating a display page including the data table according to the configuration model stored in the memory comprises:

Transfer the configuration model stored in the memory to the browser;

Obtaining a data model corresponding to the configuration model by parsing the front end of the browser; wherein the data model includes a business view layer and an ER layer;

Create a data table in the display page according to the data model, fill the data table corresponding to the data model into the data table, and display the data table in the display page.
The computer device according to claim 13, wherein the data table is created in the display page according to the data model, and the data corresponding to the data model is rendered into the data table, including:

Generating a data table according to the business view layer of the data model;

Generating columns in the data table based on attributes of each entity included in the ER layer;

The data corresponding to the entity is rendered into the corresponding column in the data table.
The computer device according to claim 11, wherein the operation data selected according to the data operation type and the data operation selected by the data operation correspondingly generate a SQL script, including:

If the operation type of the data operation is an increase data operation, generate a first SQL script according to the service view layer node corresponding to the data table in the display page and the data to be added;

If the operation type of the data operation is a delete data operation, generate a second SQL script according to the service view layer node corresponding to the data table in the display page and the data to be deleted;

If the operation type of the data operation is an edit data operation, generate a third SQL script according to the business view layer node corresponding to the data table in the display page and the data to be edited;

If the operation type of the data operation is a query data operation, a fourth SQL script is generated according to the business view layer node corresponding to the data table in the display page and the data to be queried.
A storage medium, characterized in that the storage medium stores a computer program, the computer program comprising program instructions that, when executed by a processor, cause the processor to perform the following operations:

If it is detected that the menu in the user interface is selected, the configuration code corresponding to the selected menu is obtained;

Retrieving the configuration model corresponding to the query in the graphics database according to the configuration code, and loading it into the memory for storage;

Generating a display page including a data table according to a configuration model stored in the memory;

If the data operation on the data table is detected, the SQL script is generated according to the operation type of the data operation and the service data selected by the data operation;

Execute the SQL script and feed back the corresponding business data processing results.
The storage medium according to claim 16, wherein the graphic database stores a plurality of configuration models, each of which includes a page layer, a business view layer, and an ER layer.
The storage medium according to claim 16, wherein the generating a display page including the data table according to the configuration model stored in the memory comprises:

Transfer the configuration model stored in the memory to the browser;

Obtaining a data model corresponding to the configuration model by parsing the front end of the browser; wherein the data model includes a business view layer and an ER layer;

Create a data table in the display page according to the data model, fill the data table corresponding to the data model into the data table, and display the data table in the display page.
The storage medium according to claim 18, wherein the creating a data table in the display page according to the data model, and populating the data corresponding to the data model into the data table, comprising:

Generating a data table according to the business view layer of the data model;

Generating columns in the data table based on attributes of each entity included in the ER layer;

The data corresponding to the entity is rendered into the corresponding column in the data table.
The storage medium according to claim 16, wherein the operation data selected according to the data operation and the service data selected by the data operation are corresponding to generate a SQL script, including:

If the operation type of the data operation is an increase data operation, generate a first SQL script according to the service view layer node corresponding to the data table in the display page and the data to be added;

If the operation type of the data operation is a delete data operation, generate a second SQL script according to the service view layer node corresponding to the data table in the display page and the data to be deleted;

If the operation type of the data operation is an edit data operation, generate a third SQL script according to the business view layer node corresponding to the data table in the display page and the data to be edited;

If the operation type of the data operation is a query data operation, a fourth SQL script is generated according to the business view layer node corresponding to the data table in the display page and the data to be queried.