A method for extending system with customizable information

Abstract

The present invention provides a method for extending a system capable of customizing information, comprising the following steps: defining a business table as extensible, adding an extended field, dynamically rendering a data editing page, dynamically rendering data, and displaying data. By adopting the method of the present invention, the system can add, modify, or delete extended information required or not required by the business without shutting down. Moreover, the process does not require the participation of developers. When the system maintenance personnel complete the configuration, all business personnel can operate it. Considering that there are few single-table businesses in the actual production process, the rigorous multi-table logical process is improved to handle the extended information required by complex business needs. In view of the huge storage requirements and performance requirements of the extended information, technologies such as read-write separation, table and library division, and cache are adopted to reduce the pressure on the database, increase storage capacity, and improve the system operation speed. Finally, the configuration of the global system is implemented to achieve the uniformity and sharing of data.

Description

Technical Field

[0001] The present invention relates to the technical field of software systems, and in particular to an expansion system method capable of customizing information. Background Art

[0002] In the production process of enterprises, various software systems are often used for different business processing, which is convenient for enterprise operation and management, such as ERP system, warehouse management platform, etc. However, there are some problems in the application of many software systems: in the current software system, the system information is developed based on the specific data business model. When the demand changes, the developers need to develop the system again. The database table structure needs to be modified, and the front-end and back-end codes need to be changed accordingly. After verification by testers, the project can be deployed to finally realize the expansion of system information. Moreover, the system expansion information is fixed and immutable, and it is difficult for business personnel to customize the expansion according to actual needs. Summary of the invention

[0003] The purpose of the present invention is to solve the shortcomings of the prior art and to propose an expansion system method capable of customizing information.

[0004] To achieve the above object, the present invention adopts the following technical solutions:

[0005] A method for extending a system capable of customizing information includes the following steps:

[0006] S1: Define the business table as extensible: The system provides extensible function modules during development, adds business function extension tables, and defines the relationship between the extensible business function modules and the business function extension tables;

[0007] S2: Add extended fields: System maintenance personnel add extended information to different business modules according to business needs, and edit the information to be extended in the business function extension table accordingly;

[0008] S3: Dynamically render the data editing page: render the primary key value, field name value, and specific content value of the data row recorded in the business function extension table to the data editing page;

[0009] S4: Dynamically render data: The system queries the business function extension table, splices the added extension information data with the specific business data, performs dynamic rendering, and finally displays it in the business table;

[0010] S5: Display data: Based on dynamically rendered data and combined with the records in the actual field configuration table, the extended data is finally displayed in the basic business table.

[0011] Preferably, in step S1, the expandable functional module is associated with a checkable function option of whether to expand.

[0012] Preferably, the business function extension table involved in step S1 specifically includes three sub-tables, namely a display field configuration table, an extension field table and an extension field explanation row table.

[0013] Preferably, the display field configuration table records the field records to be displayed, and adds records when adding extended fields; the extended field table records the field display value, field name, field type, field sort, field rank and rank-related fields; the extended field interpretation row table records the data row primary key value, field name value and specific content value.

[0014] Preferably, it also includes an expandable external interface for information exchange between systems.

[0015] Preferably, the extensibility of the external interface includes the following steps:

[0016] (a): Define the external interface as extensible and associate it with the business function extension table;

[0017] (b): Add an extended information field in the business function extension table. The extended information field in the interface is composed of the data of the extended field interpretation row table entity;

[0018] (c): Interact with the external system according to the extended information fields in the business function extension table, read the business data in the external system, and pass in the response field name and specific value set in addition to the basic business data;

[0019] (d): Extended information is realized by concatenating the incoming field name and specific value set into the basic business table.

[0020] Preferably, it also includes the extensibility of complex businesses. The specific expansion method is: define multiple business tables as extensible, and add corresponding extension fields respectively, and then dynamically render data in the basic business table. First, query the basic business data in the basic business table, and then query the extended data of multiple single business tables based on the basic business data, and dynamically render the extended information in multiple business tables into the basic business table in turn, so as to handle the situation where complex business data involves multiple tables.

[0021] Preferably, the method uses read-write separation, table and library division, and cache technology to store the records generated by the extended information.

[0022] Preferably, the system expansion also includes the implementation of job grade; add the job grade field to the extended field table, select the associated job grade information, and configure the job grade information at the same time.

[0023] Compared with the prior art, the beneficial effects of the present invention are as follows: the system can add, modify or delete extended information required or not required by the business without shutting down. And the process does not require the participation of developers. When the system maintenance personnel complete the configuration, all business personnel can operate it. Considering that there are rarely single-table businesses in the actual production process, the rigorous multi-table logical process is improved to handle the extended information required by complex business needs. In view of the huge extended information storage requirements and performance requirements, technologies such as read-write separation, table and library sub-division, and caching are used to reduce database pressure, increase storage capacity, and improve system operation speed. Finally, the configuration of the global system is implemented to achieve data uniformity and sharing. BRIEF DESCRIPTION OF THE DRAWINGS

[0024] Figure 1 It is an overall flow chart of a method for extending a system capable of customizing information of the present invention;

[0025] Figure 2 This is an expansion flow chart of a complex business involving simultaneous expansion of multiple business tables according to the present invention. DETAILED DESCRIPTION

[0026] In order to provide a further understanding of the purpose, structure, features, and functions of the present invention, the following detailed description is given in conjunction with the embodiments.

[0027] Please refer to Figure 1 and Figure 2 The present invention provides a method for extending a system with customizable information, comprising the following steps:

[0028] S1: Define the business table as extensible; the system provides extensible function modules during development, and the developers define the relationship between the business function modules and the business function extension table during the system development process, so that the two are interrelated.

[0029] That is, when the business table corresponding to the business function module is determined to be extensible, the developer sets the extensible business function module to be selectable whether to expand.

[0030] During the development phase, developers pre-set the option of whether to expand the function for the business function modules that may need function expansion. When the system is provided to customers, if the customer needs to expand the content of the function business table in the future, then check the expandable option. If not, then do not check it. This can greatly reduce the amount of data storage occupied by the system, and there is no need to provide expandability for all business tables corresponding to the functions, which greatly reduces the memory occupied by the system. At the same time, this setting can be flexibly configured according to customer needs, so that when the system goes online, some corresponding function business tables can be defined as expandable according to customer needs, which is convenient for use in subsequent production work.

[0031] S2: Add extended fields; system maintenance personnel add extended information to different business modules according to business needs, that is, add extended fields to the basic business table. System maintenance personnel fill in the extended field information, and the system generates a unique identification record in the database. At the same time, the extended information can be modified or disabled. This process no longer requires the participation of developers to realize changes in the business data model.

[0032] When adding an extended field to a business table, the associated business function extension table specifically includes three sub-tables, namely, a display field configuration table, an extended field table, and an extended field explanation row table.

[0033] Specifically, when adding extended fields, first define the fields to be added in the extended field table, that is, record the field display value, field name, field type, field sort, field rank, and rank-related fields; then interpret the data defined in the extended field row table in the extended field explanation row table, record the data row primary key value, field name value, and specific content value; finally, record each field record to be displayed in the display field configuration table, add records synchronously when adding extended fields, and set the display button after each added record, so as to control whether the added field is displayed.

[0034] S3: Dynamically render the data editing page; when the system user is adding, editing or querying business data, the system renders the corresponding page to the user based on the extended field table and the extended field explanation row table fields. Specifically, the extended field explanation row table records the primary key value, field name and specific content value of the data row, and then renders the data editing page so that the editing page displays the extended fields.

[0035] S4: Dynamically render data; the system automatically queries the business function extension table, then queries the associated extended fields in the extended field table, and queries the extended field explanation row table based on the primary key of the specific business data record. After splicing the extended fields with the data in the specific business table, the data is finally dynamically rendered so that the extended fields and specific values ​​are presented in the business table.

[0036] S5: Display data; based on dynamically rendered data and combined with the records in the actual field configuration table, the extended data is finally displayed in the basic business table.

[0037] In addition, the custom extension of the present invention also includes the extensibility of the external interface.

[0038] The extensibility of the external interface includes the following steps:

[0039] (a): Define the external interface as extensible and associate it with the business function extension table;

[0040] (b): Add an extended information field in the business function extension table. The extended information field in the interface is composed of the data of the extended field interpretation row table entity;

[0041] (c): Interact with the external system according to the extended information fields in the business function extension table, read the business data in the external system, and pass in the response field name and specific value set in addition to the basic business data;

[0042] (d): Extended information is realized by concatenating the incoming field name and specific value set into the basic business table.

[0043] When the system is in use, it is often necessary to connect and associate with other external systems, so as to obtain other data in the external system that is associated with the existing data in the business table. Since the business models of the two systems may be different, the interface needs to be changed accordingly when the interface is connected, so as to realize information interaction. At this time, the developers need to carry out additional development again to carry out information interaction between systems, which increases the cost and difficulty of development. The present invention defines the external interface as extensible, and the extended information field in the interface is composed of the data of the extended field interpretation row table entity. When interaction between systems is required, in addition to the basic business data, the set of field names and specific values ​​of the response is passed in to realize the extended information. No additional development is required by the developers.

[0044] The specific implementation method refers to the above content, that is, define the external interface as extensible during the development phase, and then select the external interface as extensible according to customer needs when the system is delivered, and display the entry port of the business function extension table at the external interface. Then, when interaction between systems is required, edit the field information that needs to be interacted in the business function extension table. In addition to the basic business data, the two systems pass in the set of response field names and specific values, and add the passed in field information to the corresponding business table to achieve information expansion.

[0045] Furthermore, in the process of system application, complex business requirements are often involved, involving data in multiple business tables. In this case, multiple expandable single tables can be defined separately during the development process. When rendering the page, the basic business data is first queried, and then the multiple single tables defined during the development process are used to query the extended data of multiple single tables based on the basic business data, thereby handling the situation where complex business data involves multiple tables. Figure 2 shown.

[0046] The specific extension method is: define multiple business tables as extensible, and add corresponding extension fields respectively, and then dynamically render data for the basic business table. First, query the basic business data in the basic business table, and then query the extended data of multiple single business tables based on the basic business data. The extended information in multiple business tables is dynamically rendered into the basic business table in turn, which can handle the situation where complex business data involves multiple tables.

[0047] Extended information will have a huge amount of data storage. N records have M extended information, and extended information will have N*M records. In actual business, if there are millions of basic business data and 10 extended information items, the database table will have tens of millions of records. In addition to the huge data storage requirements, it is bound to affect the efficiency of data query, addition and other operations. Here, technologies such as read-write separation, table and database sharding, and caching can be used to reduce database pressure, increase storage capacity, and improve system operation speed.

[0048] To realize the job level, there is a parameter configuration function in the system, and these configurations need to be stored in the extended information. If the system configuration changes, the extended information should also change. Add the job level field to the extended field table. If the current field is the job level field, the specific value of the associated parameter configuration needs to be maintained. When editing or displaying information, the current field needs to take out the specific value from the system parameter configuration.

[0049] In actual production, take the purchase order in the procurement collaboration system as an example to implement the entire process.

[0050] During the development process, if the developer finds that the purchase order needs to be associated with the purchase order table, purchase group table and supplier table, the current function name, the names of the three tables and their respective primary key names are recorded in the business function extension table.

[0051] According to business needs, system maintenance personnel have expanded the purchase order description information in the purchase order table, expanded the purchase group description information in the purchase group, and expanded the supplier description information in the supplier. The purchase order page needs to query the corresponding description information. When the maintenance personnel add extended information, the data in the display field configuration table will be regenerated, and the field names of these three fields will be added to the display field configuration table of the current function.

[0052] In the actual query process, the basic business data is queried according to the original business logic of the developer. The business data contains the primary key information of the three pre-defined tables that can be extended. The primary key information is consistent with the value defined in the business function extension table during the development process. After querying the basic business data, query the business function extension table of the function, and obtain the primary key value in the business data according to the primary key name defined in the business function extension table. At this time, query all the fields extended by the current table according to the field extension table, query the data in the extended field explanation row table according to the primary key value and field name, and splice it into the business data.

[0053] Taking the purchase order as an example, the basic business data should include the purchase order primary key, the purchase group primary key, and the supplier primary key. At this time, the business function extension table is queried according to the purchase order function, and three records are found in the table. The primary key value in the basic business data is retrieved according to the primary key recorded in the three records. The extended field table is queried according to the three records in the business function extension table, and the extended fields associated with the three tables are queried, which are reflected here as the purchase order description field, the purchase group description information, and the supplier description information. According to the extended field name and primary key value, the specific data of the extension is retrieved from the extended field explanation row table and spliced ​​after the basic business data, thereby forming all the business data. Finally, according to the configuration in the display field configuration table, the complete data is rendered and displayed to the user.

[0054] As described above, the present invention provides a method for extending a system with customizable information, and the system can add, modify or delete extended information required or not required by the business without shutting down. Moreover, the process does not require the participation of developers. When the system maintenance personnel complete the configuration, all business personnel can operate it. Considering that there are rarely single-table businesses in the actual production process, the rigorous multi-table logical process is improved to handle the extended information required by complex business needs. In view of the huge extended information storage requirements and performance requirements, technologies such as read-write separation, table and library sub-division, and caching are used to reduce database pressure, increase storage capacity, and improve system operation speed. Finally, the configuration of the global system is implemented to achieve data uniformity and sharing.

[0055] The present invention has been described by the above-mentioned relevant embodiments, however, the above-mentioned embodiments are only examples for implementing the present invention. It must be pointed out that the disclosed embodiments do not limit the scope of the present invention. On the contrary, changes and modifications made without departing from the spirit and scope of the present invention are all within the scope of patent protection of the present invention.

Claims

1. A method for extending a system with customizable information, Features: The steps include: S1: Define the business table as extensible: The system provides extensible function modules during development, adds a business function extension table, and defines the relationship between the extensible business function modules and the business function extension table; the business function extension table specifically includes three subtables, namely, a display field configuration table, an extension field table, and an extension field explanation row table; the display field configuration table records the field records to be displayed, and adds records when adding extension fields; the extension field table records the field display value, field name, field type, field sorting, field rank, and rank-related fields; the extension field explanation row table records the data row primary key value, field name value, and specific content value; S2: Add extended fields: System maintenance personnel add extended information to different business modules according to business needs, and edit the information to be extended in the business function extension table accordingly; S3: Dynamically render the data editing page: render the primary key value, field name value, and specific content value of the data row recorded in the business function extension table to the data editing page; S4: Dynamically render data: The system queries the business function extension table, splices the added extension information data with the specific business data, performs dynamic rendering, and finally displays it in the business table; S5: Display data: Based on the dynamically rendered data and combined with the records in the actual field configuration table, the extended data is finally displayed in the basic business table; The method also includes an extensible external interface for information exchange between systems. The extensible external interface includes the following steps: (a): Define the external interface as extensible and associate it with the business function extension table; (b): Add an extended information field in the business function extension table. The extended information field in the interface is composed of the data of the extended field interpretation row table entity; (c): Interact with the external system according to the extended information fields in the business function extension table, read the business data in the external system, and pass in the response field name and specific value set; (d): Extended information is realized by concatenating the incoming field name and specific value set into the basic business table.

2. The method for extending a system capable of customizing information according to claim 1, Features: In step S1, the expandable functional module is associated with a checkable function option of whether to expand.

3. The method for extending a system capable of customizing information according to claim 1, Features: It also includes the extensibility of complex businesses. The specific expansion method is: define multiple business tables as extensible, and add corresponding extension fields respectively, and then dynamically render data in the basic business table. First, query the basic business data in the basic business table, and then query the extended data of multiple single business tables based on the basic business data, and dynamically render the extended information in multiple business tables into the basic business table in turn, so as to handle the situation where complex business data involves multiple tables.

4. The method for extending a system capable of customizing information according to claim 1, Features: The method adopts read-write separation, table and database partitioning and cache technology to store the records generated by the extended information.

5. The method for extending a system capable of customizing information according to claim 1, Features: When the system is expanded, the implementation of job grades is also included; add job grade fields to the extended field table, select associated job grade information, and configure the job grade information at the same time.

Images