Service parameter processing method and device, computer equipment and readable storage medium

Abstract

The invention relates to the technical field of big data, and particularly discloses a business parameter processing method and device, computer equipment and a readable storage medium. The method comprises the steps that in response to a parameter configuration request sent by a request object, editable parameters matched with the request object are screened out from a preset parameter entity mapping table, a parameter configuration interface is pushed based on the editable parameters, parameter configuration data submitted by the request object through the parameter configuration interface are obtained, and the editable parameters are sent to the request object based on the parameter configuration data. Generating a to-be-processed parameter configuration entry, inserting the parameter configuration entry into the temporarily created parameter flow table, updating the state of the parameter configuration entry to a to-be-rechecked state, triggering a preset rechecking approval process, and when the parameter configuration entry passes rechecking, rechecking the parameter configuration entry. And writing the parameter configuration data in the parameter configuration entry into a preset service parameter table. By adopting the scheme, the parameter configuration modification efficiency can be effectively improved.

Description

Technical Field

[0001] The present application relates to the field of big data technology, and in particular to a business parameter processing method, apparatus, computer equipment, computer-readable storage medium, and computer program product. Background Art

[0002] With the development of information technology, users have more and more business requirements for software systems, and the functions of software systems are becoming more and more abundant. The flexibility and scalability of the system have become key requirements. Parameter configuration management not only affects the performance of the system, but also directly affects the user experience and service quality.

[0003] At present, if the business requirements of the software system change and the business parameters need to be modified accordingly, developers are usually required to modify the relevant code, and it is difficult for business personnel to participate in the parameter management configuration process. If the number of modification items and configuration items is large, it will be difficult to meet the requirements by developers modifying the code, and it is time-consuming and laborious for developers to modify the code. In addition, since developers do not understand the business requirements as clearly as business personnel, they are prone to mistakes, which brings higher parameter operation risks. It can be seen that the current parameter configuration management has the problem of low parameter processing efficiency. Summary of the invention

[0004] Based on this, it is necessary to provide an efficient business parameter processing method, apparatus, computer equipment, computer-readable storage medium and computer program product to address the above technical issues.

[0005] In a first aspect, the present application provides a service parameter processing method, comprising:

[0006] In response to a parameter configuration request sent by a request object, an editable parameter matching the request object is screened out from a preset parameter entity mapping table, wherein the parameter entity mapping table includes a mapping relationship between parameters and business entities;

[0007] Based on the editable parameters, a parameter configuration interface is pushed, so that the request object can configure the editable parameters on the parameter configuration interface;

[0008] Obtaining parameter configuration data submitted by the request object through the parameter configuration interface, generating a parameter configuration entry to be processed based on the parameter configuration data, and inserting the parameter configuration entry into a temporarily created parameter transfer table;

[0009] Update the status of the parameter configuration item to a pending review status, trigger a preset review and approval process, and review the parameter configuration item;

[0010] In the case where the parameter configuration entry passes the review, the status of the parameter configuration entry is updated to a review passed status, and the parameter configuration data in the parameter configuration entry is written into a preset business parameter table.

[0011] In one embodiment, the step of filtering out the editable parameters matching the request object from a preset parameter entity mapping table includes:

[0012] Extracting the identity of the request object carried in the parameter configuration request;

[0013] Based on the identity identifier, obtaining entity attribute data of the request object;

[0014] Based on the entity attribute data, editable parameters matching the request object are screened out from a preset parameter entity mapping table.

[0015] In one embodiment, the entity attribute data includes role attributes and operation authority attributes, and the step of selecting editable parameters matching the request object from a preset parameter entity mapping table based on the entity attribute data includes:

[0016] Based on the identity identifier of the request object, query the target parameter associated with the request object from the parameter entity mapping table;

[0017] According to the role attribute and the data permission attribute, the editable parameters matching the request object are screened out from the target parameters.

[0018] In one embodiment, writing the parameter configuration data in the parameter configuration entry into a preset database table includes:

[0019] Performing version comparison on the parameter configuration data to detect whether there is a conflict between the parameter configuration data of the current version and the parameters of the previous version;

[0020] In the case that there is no conflict between the parameter configuration data of the current version and the parameters of the previous version, the parameter configuration data in the parameter configuration entry is written into a preset database table.

[0021] In one embodiment, the method further comprises:

[0022] Get parameter query log data;

[0023] Based on the parameter query log, determining the query frequency and correlation strength of each parameter;

[0024] Based on the query frequency and correlation strength of each parameter, identify low-frequency query parameters and high-frequency query parameters;

[0025] The high-frequency query parameters are merged into a preset same data wide table.

[0026] In one embodiment, the method further comprises:

[0027] Responding to a parameter query request of a request object, the parameter query request carrying a parameter to be queried;

[0028] Determining whether the parameter to be queried is a high-frequency query parameter;

[0029] In the case where the to-be-queried parameter is a high-frequency query parameter, constructing a target query statement based on the to-be-queried parameter and a precompiled query statement template;

[0030] Execute the target query statement to obtain a query result.

[0031] In a second aspect, the present application also provides a service parameter processing device, including:

[0032] A data screening module, configured to respond to a parameter configuration request sent by a request object and screen out editable parameters matching the request object from a preset parameter entity mapping table, wherein the parameter entity mapping table includes a mapping relationship between parameters and business entities;

[0033] A data push module, used for pushing a parameter configuration interface based on the editable parameters, so that the request object can configure the editable parameters on the parameter configuration interface;

[0034] A data processing module, used for obtaining parameter configuration data submitted by the request object through the parameter configuration interface, generating parameter configuration entries to be processed based on the parameter configuration data, and inserting the parameter configuration entries into a temporarily created parameter transfer table;

[0035] A data review module, used to update the status of the parameter configuration item to a pending review status, trigger a preset review and approval process, and review the parameter configuration item;

[0036] The data updating module is used to update the status of the parameter configuration entry to a review passed status when the parameter configuration entry passes the review, and write the parameter configuration data in the parameter configuration entry into a preset business parameter table.

[0037] In a third aspect, the present application further provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and the processor implements the steps in any one of the above-mentioned business parameter processing method embodiments when executing the computer program.

[0038] In a fourth aspect, the present application further provides a computer-readable storage medium having a computer program stored thereon, and when the computer program is executed by a processor, the steps in any one of the above-mentioned business parameter processing method embodiments are implemented.

[0039] In a fifth aspect, the present application further provides a computer program product, including a computer program, which, when executed by a processor, implements the steps in any one of the above-mentioned business parameter processing method embodiments.

[0040] The above-mentioned business parameter processing method, device, computer equipment, computer-readable storage medium and computer program product, when receiving a parameter configuration request, screens out editable parameters that match the request object through the parameter entity mapping table, can achieve fine-grained permission control, ensure that only authorized developers or business personnel can modify specific parameters, and reduce the possibility of parameter configuration errors. Subsequently, the parameter configuration interface is pushed to allow business personnel or developers to dynamically adjust parameters through the parameter configuration interface, making parameter configuration more flexible without the need to recompile and deploy code. After the developer or business personnel submits the parameter configuration data, a parameter configuration entry to be processed is generated, the parameter configuration entry is inserted into a temporarily created parameter transfer table, the status of the parameter configuration entry is updated to a pending review status, and the update triggers a review and approval process. The parameter configuration entry needs to pass the review and approval process to take effect. In this way, all states of the parameter configuration entry are clearly recorded, which is convenient for tracking the progress and status of the configuration, and an additional security layer is added to reduce the possibility of unauthorized or unreviewed changes being applied to the production environment. The entire solution, through a systematic process and interface, achieves efficient, safe and flexible configuration of business parameters. Compared with the traditional manual code modification, this solution not only improves work efficiency, standardizes the parameter configuration process, reduces operational errors, but also enhances the maintainability and security of the system. At the same time, through the approval process and status management, it ensures the standardization and consistency of configuration and improves the user experience. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] In order to more clearly illustrate the technical solutions in the embodiments of the present application or related technologies, the drawings required for use in the embodiments of the present application or related technical descriptions will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without paying creative work.

[0042] FIG1 is an application environment diagram of a service parameter processing method in one embodiment;

[0043] Figure 2 A schematic diagram of a process flow of a service parameter processing method in an embodiment;

[0044] Figure 3 A schematic diagram of a process for screening editable parameters in one embodiment;

[0045] Figure 4 A schematic diagram of a flow chart of a step of screening editable parameters in another embodiment;

[0046] Figure 5 A schematic diagram of a process flow of a service parameter processing method in an embodiment;

[0047] Figure 6 A schematic diagram of a flow chart of a data query step in an embodiment;

[0048] Figure 7 is a structural block diagram of a service parameter processing device in an embodiment;

[0049] Figure 8 is a structural block diagram of a service parameter processing device in another embodiment;

[0050] FIG. 9 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION

[0051] In order to make the purpose, technical solutions and advantages of the present application clearer, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application. It should be noted that in the embodiments of the present application, certain software, groups, models and other existing solutions in the industry may be mentioned, which should be considered as exemplary, and their purpose is only to illustrate the feasibility of the implementation of the technical solution of the present application, but it does not mean that the applicant has or will necessarily use the solution.

[0052] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant regulations. The acquisition, storage, use, and processing of data in the technical solution of this application are in compliance with relevant provisions of national laws and regulations.

[0053] The service parameter processing method provided in the embodiment of the present application can be applied in the application environment shown in FIG1. ​​The terminal 102 communicates with the server 104 through a network. The data storage system can store data that the server 104 needs to process. The data storage system can be integrated on the server 104, or it can be placed on the cloud or other network servers.

[0054] The request object, such as a business person or a developer, may send a parameter configuration request to the server 104 through the terminal 102. The server 104 responds to the parameter configuration request sent by the business person or the developer, and selects the editable parameters that match the request object from the preset parameter entity mapping table. The parameter entity mapping table includes the mapping relationship between the parameters and the business entity. Then, based on the editable parameters, the parameter configuration interface is pushed so that the request object can configure the editable parameters in the parameter configuration interface, and the parameter configuration data submitted by the request object through the parameter configuration interface is obtained. Based on the parameter configuration data, a parameter configuration entry to be processed is generated, and the parameter configuration entry is inserted into a temporarily created parameter transfer table; then, the status of the parameter configuration entry is updated to a pending review status, triggering a preset review and approval process, and the parameter configuration entry is reviewed. If the parameter configuration entry passes the review, the status of the parameter configuration entry is updated to a review passed status, and the parameter configuration data in the parameter configuration entry is written into the preset business parameter table.

[0055] The terminal 102 may be, but is not limited to, various personal computers, laptops, smart phones, tablet computers, IoT devices, and portable wearable devices. The IoT devices may be smart speakers, smart TVs, smart air conditioners, smart car devices, projection devices, etc. Portable wearable devices may be smart watches, smart bracelets, head-mounted devices, etc. Head-mounted devices may be virtual reality (VR) devices, augmented reality (AR) devices, smart glasses, etc. The server 104 may be an independent physical server, a server cluster or distributed system consisting of multiple physical servers, or a cloud server that provides cloud computing services.

[0056] In an exemplary embodiment, Figure 2 As shown, a service parameter processing method is provided, and the method is applied to the server 104 in FIG. 1 as an example for description, including the following steps S100 to S500. Among them:

[0057] S100, in response to a parameter configuration request sent by a request object, screen out editable parameters matching the request object from a preset parameter entity mapping table, wherein the parameter entity mapping table includes a mapping relationship between parameters and business entities.

[0058] The request object refers to the object that sends the parameter configuration request, including but not limited to the account of the administrator, operator (such as developer and business personnel) or other authorized user, or the device logged in by the account of the above personnel. The parameter entity mapping table is a predefined database table, which defines the mapping relationship between all parameters and their corresponding business entities. The table structure may include the following fields, such as parameter name, parameter ID (Identity), parameter type (such as string, integer, Boolean value, etc.), list of roles or users who can edit the parameter, business entity name, business entity ID, etc. In this embodiment, the parameter entity mapping table is used to filter optional parameter types.

[0059] In specific implementation, the requesting object (such as an administrator, operator or other authorized user) logs in to the parameter configuration system account and sends a parameter configuration request through the parameter configuration interface or API (Application interface). After receiving the parameter configuration request, the system can first identify the identity and permission information of the requesting object, and implement it through an authentication mechanism (such as username / password, token, etc.). According to the identity and permission information of the requesting object, the parameter entity mapping table is queried to obtain all parameters and their related information. According to the role of the requesting object, the parameters that the requesting object can edit are filtered out from the parameter entity mapping table. For example, if the requesting object is an "administrator" role, the system will filter out all parameters whose editable_by field contains "administrator".

[0060] For example, taking the business parameter as the full-currency payment navigation parameter, at present, the modification of the payment currency, receipt currency, full-currency product type and other elements in the full-currency payment must be modified by modifying the code to take effect, which is not flexible enough. To solve this problem, a parameter flow processing table and a parameter entity mapping table can be added to the database, and a field in the full-currency payment navigation table can be added to support the modification of the full-currency payment navigation parameters, as shown in Table 1:

[0061] Table 1 Data table list

[0062]

[0063] Among them, the parameter entity mapping table is used to filter the optional parameter types of the request object according to the entity. The application scope of the full-currency payment navigation parameter is domestic rather than all entities, that is, the parameter entity mapping table can filter out overseas entities.

[0064] In the full-currency payment navigation parameter table, parameter maintenance fields such as effective time and parameter sequence number are added to make them put into use as business parameters and supplement specific maintenance information.

[0065] The parameter transfer processing table supports the maintenance and transfer of payment navigation parameters in all currencies. It is stored as temporary parameters before they are officially effective and supports business operations such as parameter rollback, modification, and review.

[0066] S200, based on the editable parameters, push a parameter configuration interface, so that the requesting object can configure the editable parameters on the parameter configuration interface.

[0067] After filtering out the editable parameters of the request object, a parameter configuration interface is generated and pushed. The parameter configuration interface may include the following contents: parameter name, parameter type, editable input box or selector, and submit button, etc. The request object configures the editable parameters on the parameter configuration interface, and the request object clicks the "Submit" button to submit the configuration data.

[0068] S300, obtaining parameter configuration data submitted by the request object through the parameter configuration interface, generating parameter configuration entries to be processed based on the parameter configuration data, and inserting the parameter configuration entries into a temporarily created parameter transfer table.

[0069] The parameter transfer table is a data table temporarily created by the system to store parameter configuration entries to be processed. Parameter configuration entries refer to the records of parameter configuration data submitted by the requesting object, usually including parameter ID, new configuration value, requesting object information, etc. The status of parameter configuration entries includes "pending review", "reviewed", "pending to take effect" and "effective".

[0070] In specific implementation, when the request object submits parameter configuration data through the parameter configuration interface, the system will obtain these data and generate parameter configuration entries to be processed based on these data. Then, these entries are inserted into a temporarily created parameter flow table for further processing. Specifically, the request object submits parameter configuration data through the parameter configuration interface, the server receives the data submitted by the form, parses and extracts the parameter configuration data, and generates parameter configuration entries to be processed based on the obtained parameter configuration data. Subsequently, the generated parameter configuration entries are inserted into the temporarily created parameter flow table.

[0071] S400, updating the status of the parameter configuration item to a pending review status, triggering a preset review and approval process, and reviewing the parameter configuration item.

[0072] The status of parameter configuration items includes "pending review", "review passed", "review returned" and "deleted". After generating a parameter configuration item, you can add information such as the person in charge, operation time and status. Then, update the status of the parameter configuration item to "pending review", triggering the preset review and approval process, such as starting the automated review process, to review the parameter configuration item.

[0073] For example, assemble the insert statement: Insert into A K1=V1 K2=V2 INX=new1 (the generation rule of the new1 parameter serial number: 10-digit fixed length: technology X+YYMMDD+3-digit serial number business Y+00 (machine number)+(YYMMDD+3-digit random number (serial number generator) 9 digits converted to 7 digits)). The system automatically notifies the designated reviewer (such as administrator, auditor, etc.) that there is a new configuration request that needs to be reviewed. The reviewer logs in to the system, checks the parameter configuration items to be reviewed, and checks the accuracy, compliance, and rationality of the configuration data. After the review, the reviewer can approve or reject the configuration request and provide corresponding remarks or reasons.

[0074] For example, taking the modification and maintenance of all-currency payment navigation parameters as an example, after the business personnel initiate maintenance on the specified parameters in the "Parameter Maintenance Query" interface, they can view all parameters to be reviewed in the "Parameter Flow Queue". Administrators with review authority can select a record to be reviewed and perform the following operations:

[0075] (1) Query the pending list

[0076] After the administrator clicks to query the pending list, the display columns include parameter maintenance number, parameter type, i.e., all-currency payment navigation parameters, maintenance type (1-new; 2-modify; 3-delete), task status (1-pending review; 2-review passed; 3-review returned; 4-deleted), agent number, agent name, operation date, and return reason.

[0077] (2) Jump to the processing page:

[0078] a. Button activation conditions: The database storage status is "Submitted by myself" or the status is "Returned for review".

[0079] b. Enter the processing page to display parameter maintenance details, and the content can be edited.

[0080] c. Click the "Resubmit" button, change the status to "Pending Review", and modify the "Submission Time" content.

[0081] (3) Jump to the review page:

[0082] a. Button activation conditions: The database status is "pending review" and it is not submitted by the user.

[0083] b. Review details page, which displays parameter maintenance details and cannot be edited.

[0084] c. Review passed: Change the status to "Review passed", update the "Time" and "Reviewer Information", and the parameter table will take effect.

[0085] d. Review and return: Change the status to "Review and return", and update "Time", "Reviewer information", and "Reason for return".

[0086] (4) Delete

[0087] a. Button activation conditions: The status is "Returned for Review" and it is submitted by the applicant.

[0088] b. Status is set to Deleted

[0089] (5) View parameter maintenance details

[0090] Jump to the parameter maintenance details interface, query the parameter processing table details, and cannot be edited. According to the jump URL, determine whether to modify, add, or query details, and control the page buttons and whether they can be edited.

[0091] S500: When the parameter configuration entry passes the review, the status of the parameter configuration entry is updated to a review passed status, and the parameter configuration data in the parameter configuration entry is written into a preset business parameter table.

[0092] The business parameter table stores the database table of the final effective parameters.

[0093] In actual application, if the reviewer approves the configuration request, the status of the parameter configuration item will be updated to "Review Passed", and the parameter configuration data in the parameter configuration item will be written into the preset business parameter table, so that the parameters configured by the request object will be officially effective, and the business parameter table will be effective accordingly. If the reviewer determines that the parameter configuration data cannot pass, he can click the "Return" button and note the reason for return and other relevant data to return the configuration request in the system, and the status of the parameter configuration item will be updated to "Review Returned". The request object will be notified by email or application message and the reason for rejection will be provided, so that the request object can check its configured parameters and make corresponding adjustments to resubmit the configured parameters.

[0094] In the above business parameter processing method, when receiving a parameter configuration request, the editable parameters matching the request object are screened out through the parameter entity mapping table, which can realize fine-grained permission control, ensure that only authorized developers or business personnel can modify specific parameters, and reduce the possibility of parameter configuration errors. Subsequently, the parameter configuration interface is pushed, allowing business personnel or developers to dynamically adjust parameters through the parameter configuration interface, making parameter configuration more flexible without recompiling and deploying code. After the developer or business personnel submits the parameter configuration data, a parameter configuration entry to be processed is generated, and the parameter configuration entry is inserted into the temporarily created parameter transfer table. The status of the parameter configuration entry is updated to the pending review status, and the update triggers the review and approval process. The parameter configuration entry needs to pass the review and approval process to take effect. In this way, all the states of the parameter configuration entries are clearly recorded, which is convenient for tracking the progress and status of the configuration, and an additional security layer is added to reduce the possibility of unauthorized or unreviewed changes being applied to the production environment. The entire solution realizes efficient, secure and flexible configuration of business parameters through systematic processes and interfaces. Compared with the traditional manual code modification, this solution not only improves work efficiency, standardizes the parameter configuration process, reduces operational errors, but also enhances the maintainability and security of the system. At the same time, through the approval process and status management, it ensures the standardization and consistency of configuration and improves the user experience.

[0095] In an exemplary embodiment, Figure 3 As shown, the editable parameters that match the request object are filtered out from the preset parameter entity mapping table, including:

[0096] S120: Extract the identity of the request object carried in the parameter configuration request.

[0097] S140, based on the identity identifier, obtaining entity attribute data of the request object.

[0098] S160, based on the entity attribute data, filter out editable parameters that match the request object from a preset parameter entity mapping table.

[0099] The identity is information that uniquely identifies the request object, usually including but not limited to user name, user ID or token, etc. Entity attribute data refers to attribute information related to the request object, which may include information such as role, department, authority, and level.

[0100] In specific implementation, after receiving the parameter configuration request sent by the request object, the server can extract the identity identifier of the request object, such as the identity ID, from the parameter configuration request, and then query the entity attribute data of the request object, such as role, department and authority information, based on the identity identifier. Then, the attribute information such as the role, department and authority information of the request object is compared with the business entity-related parameters in the parameter entity mapping table, and the editable parameters that match the request object are filtered out from the preset parameter entity mapping table.

[0101] In this embodiment, parameter filtering is performed through the parameter entity mapping table, so that fine-grained permission control can be implemented to ensure that only authorized users can edit specific parameters.

[0102] like Figure 4 As shown, in an exemplary embodiment, the entity attribute data includes role attributes and operation permission attributes, S160, including: S162, based on the identity of the request object, query the target parameters associated with the request object from the parameter entity mapping table, and according to the role attributes and data permission attributes, filter out the editable parameters that match the request object from the target parameters.

[0103] In this embodiment, entity attribute data includes role attributes and operation permission attributes. Role attributes represent the role of the request object in the system, such as administrator, manager, and ordinary employee. Operation permission attributes represent the access rights of the request object to specific operations or resources, such as read, write, delete, and other permissions. Target parameters refer to configurable parameters related to a specific request object (such as a user or role). For example, for business personnel and developers, editable parameters covered by business personnel and editable parameters covered by developers can be pre-defined regardless of permissions.

[0104] In specific implementation, after obtaining the identity of the request object, the server queries all target parameters associated with the request object from the parameter entity mapping table based on the identity of the request object. For example, if the request object is a business person, the target parameters that the business person can edit are filtered out. Subsequently, the role attributes and operation permission attributes of the business person are matched with the role or user list that can edit each parameter in the parameter entity mapping table to filter out editable parameters that match the permission information of each specific request object.

[0105] In this embodiment, optional parameters are screened out through role attributes and permission attributes, which can reduce the possibility of unauthorized users modifying key parameters and reduce potential security risks.

[0106] like Figure 5 As shown, in an exemplary embodiment, writing parameter configuration data in a parameter configuration entry into a preset database table includes:

[0107] S520: When the parameter configuration entry passes the review, the status of the parameter configuration entry is updated to a review passed status, and a version comparison is performed on the parameter configuration data to detect whether there is a conflict between the parameter configuration data of the current version and the parameters of the previous version.

[0108] S540: When there is no conflict between the parameter configuration data of the current version and the parameters of the previous version, write the parameter configuration data in the parameter configuration entry into a preset business parameter table.

[0109] Version comparison refers to comparing the parameter configuration data of the current version with the parameter configuration data of the previous version (or existing version) to detect whether there are differences or conflicts. Conflict detection refers to checking whether there are incompatibilities or contradictions between the parameter configuration data of the current version and the data of the previous version.

[0110] In actual applications, when the request object submits parameter configuration data, the server will obtain the previous version of the parameter configuration for each parameter, compare the current version of the parameter configuration data with the previous version of the parameter configuration data, and compare whether there is a conflict between the two. If there is a conflict, if two users modify the same parameter at the same time and submit different values, a conflict may occur. In this case, the corresponding conflict handling prompt message can be pushed so that the request object can check the parameters and make corresponding adjustments; if there is no conflict, the parameter configuration data in the parameter configuration entry is written into the preset business parameter table to make the parameter configuration entry effective.

[0111] In this embodiment, version comparison and conflict detection are used to ensure consistency of parameter configuration and avoid data inconsistency caused by simultaneous modification by multiple users.

[0112] like Figure 5 As shown, in an exemplary embodiment, the method also includes: S600, obtaining parameter query log data, determining the query frequency and correlation strength of each parameter based on the parameter query log, identifying low-frequency query parameters and high-frequency query parameters based on the query frequency and correlation strength of each parameter, and merging the high-frequency query parameters into a preset same data wide table.

[0113] Parameter query log data refers to logs that record all operations of querying parameters by users or systems. These logs usually include information such as query time, query parameters, and query results. Query frequency refers to the number of times a parameter is queried within a certain time range. The higher the frequency, the more frequently the parameter is used. Association strength refers to the frequency with which multiple parameters appear at the same time during a query. If certain parameters are often queried together, the association strength between them is high. Low-frequency query parameters refer to parameters with low query frequency, which may not be used often or are only queried in specific circumstances. High-frequency query parameters refer to parameters with high query frequency, which are often used and are hot data in the system. Data wide tables are a storage method that merges the data of multiple related entities into one table to reduce join operations during queries and improve query performance. Wide tables usually contain multiple fields, each of which represents a related attribute.

[0114] For example, the parameter maintenance function of the full-currency payment navigation rule can be set in the cross-border easy payment system of the employee channel, so that the relevant management departments can query and modify the payment currency, receipt currency, full-currency product type and other parameter elements through the business interface, thereby improving the flexibility and convenience of business handling. If the business personnel enter the "Parameter Maintenance Query" interface, the server can display the optional parameter types according to the employee's institution number. If the "Full-currency Payment Navigation Parameter" is selected, the application scope of the parameter, i.e. "Domestic", is displayed. After clicking confirm, enter the maintenance and query interface of the corresponding parameter. For example, if you enter the "Full-currency Payment Navigation Rule Parameter Query and Maintenance" interface, you can query the element information of the relevant parameters, including parameter maintenance number, payment currency, receipt currency, receipt country, full-currency product type (STONEX / VISA) and effective date. During each query process, the server will record the relevant query log.

[0115] The server can extract parameter query log data from the log file or database, and based on the parameter query log, count the number of queries for each parameter, that is, the frequency at which two parameters appear in the same query at the same time, to determine the query frequency and association strength of each parameter. Subsequently, the query frequency is compared with the preset frequency threshold. If the frequency is higher than or equal to the preset frequency threshold, it is determined to be a high-frequency query parameter. If it is less than the preset frequency threshold, it is determined to be a low-frequency query parameter. Furthermore, high-frequency parameter combinations that are often queried together can be further screened out based on the association strength. Next, a data wide table is created or updated to merge high-frequency query parameters and their associated data into one table. In addition, low-frequency query parameters can be separated and stored in infrequently used spaces, which can optimize storage space and reduce unnecessary data redundancy.

[0116] In this embodiment, high-frequency query parameters are merged into a wide data table, which reduces the connection operations during query and improves query performance. By separating low-frequency query parameters, storage space can be optimized and unnecessary data redundancy can be reduced.

[0117] like Figure 6 As shown, in an exemplary embodiment, the method further includes:

[0118] S720: Respond to a parameter query request of the request object, where the parameter query request carries a parameter to be queried.

[0119] S740: Determine whether the parameter to be queried is a high-frequency query parameter.

[0120] S760: When the to-be-queried parameter is a high-frequency query parameter, a target query statement is constructed based on the to-be-queried parameter and a precompiled query statement template.

[0121] S780, execute the target query statement to obtain the query result.

[0122] The query parameters are the specific parameters that the request object wants to obtain from the system. These parameters can be configuration items, status information or other data in the system. Compiled query statement templates refer to pre-written and optimized SQL (Structured Query Language) query statement templates. These templates contain placeholders and can dynamically generate the final query statement based on specific parameters at runtime.

[0123] In specific implementation, the request object sends a parameter query request carrying the parameters to be queried to the server. After receiving the parameter query request, the server checks whether the parameters to be queried are high-frequency query parameters. If the parameters to be queried are high-frequency query parameters, the pre-compiled query statement template is called, and the specific values ​​of the parameters to be queried are inserted into the template to generate the final target query statement. Subsequently, the generated target query statement is executed, the corresponding query results are obtained from the database, and the results are returned to the request object.

[0124] In this embodiment, by identifying whether it is a high-frequency query parameter and using a pre-compiled query statement template, the SQL parsing time can be reduced, the query performance can be improved, and the query logic can be more easily managed and maintained.

[0125] In order to make a clearer description of the service parameter processing method provided by the present application, a specific embodiment is described below. The specific embodiment includes the following steps:

[0126] S1, in response to a parameter configuration request sent by a request object, extracting an identity identifier of the request object carried in the parameter configuration request.

[0127] S2, based on the identity identification, obtain the entity attribute data of the request object, the entity attribute data includes role attributes and operation permission attributes.

[0128] S3, based on the identity of the request object, query the target parameters associated with the request object from the parameter entity mapping table, and filter out the editable parameters that match the request object from the target parameters according to the role attributes and data permission attributes. The parameter entity mapping table includes the mapping relationship between parameters and business entities.

[0129] S4, based on the editable parameters, push a parameter configuration interface, so that the requesting object can configure the editable parameters on the parameter configuration interface.

[0130] S5, obtaining parameter configuration data submitted by the request object through the parameter configuration interface, generating parameter configuration entries to be processed based on the parameter configuration data, and inserting the parameter configuration entries into the temporarily created parameter transfer table.

[0131] S6, updating the status of the parameter configuration item to a pending review status, triggering a preset review and approval process, and reviewing the parameter configuration item.

[0132] S7, when the parameter configuration entry passes the review, the status of the parameter configuration entry is updated to the review passed status, and the parameter configuration data is compared with the versions to detect whether there is a conflict between the parameter configuration data of the current version and the parameters of the previous version.

[0133] S8, when there is no conflict between the parameter configuration data of the current version and the parameters of the previous version, write the parameter configuration data in the parameter configuration entry into the preset business parameter table.

[0134] It should be understood that, although the various steps in the flowcharts involved in the above-mentioned embodiments are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear explanation in this article, the execution of these steps does not have a strict order restriction, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-mentioned embodiments can include multiple steps or multiple stages, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily to be carried out in sequence, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.

[0135] Based on the same inventive concept, the embodiment of the present application also provides a service parameter processing device for implementing the service parameter processing method involved above. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme recorded in the above method, so the specific limitations in the one or more service parameter processing device embodiments provided below can refer to the limitations on the service parameter processing method above, and will not be repeated here.

[0136] In an exemplary embodiment, Figure 7 As shown, a service parameter processing device 700 is provided, comprising: a data screening module 710, a data pushing module 720, a data processing module 730, a data review module 740 and a data updating module 750, wherein:

[0137] The data screening module 710 is used to respond to the parameter configuration request sent by the request object and screen out editable parameters matching the request object from a preset parameter entity mapping table, where the parameter entity mapping table includes a mapping relationship between parameters and business entities.

[0138] The data push module 720 is used to push a parameter configuration interface based on the editable parameters, so that the requesting object can configure the editable parameters in the parameter configuration interface.

[0139] The data processing module 730 is used to obtain the parameter configuration data submitted by the request object through the parameter configuration interface, generate parameter configuration entries to be processed based on the parameter configuration data, and insert the parameter configuration entries into the temporarily created parameter transfer table.

[0140] The data review module 740 is used to update the status of the parameter configuration item to a pending review status, trigger a preset review and approval process, and review the parameter configuration item.

[0141] The data updating module 750 is used to update the status of the parameter configuration entry to the review passed status when the parameter configuration entry passes the review, and write the parameter configuration data in the parameter configuration entry into the preset business parameter table.

[0142] In one of the exemplary embodiments, the data screening module 710 is also used to extract the identity of the request object carried in the parameter configuration request, obtain the entity attribute data of the request object based on the identity, and screen out editable parameters that match the request object from a preset parameter entity mapping table based on the entity attribute data.

[0143] In one exemplary embodiment, the entity attribute data includes role attributes and operation permission attributes. The data screening module 710 is also used to query the target parameters associated with the request object from the parameter entity mapping table based on the identity of the request object, and screen out editable parameters that match the request object from the target parameters according to the role attributes and data permission attributes.

[0144] In one of the exemplary embodiments, the data update module 750 is also used to perform version comparison on the parameter configuration data to detect whether there is a conflict between the parameter configuration data of the current version and the parameters of the previous version. If there is no conflict between the parameter configuration data of the current version and the parameters of the previous version, the parameter configuration data in the parameter configuration entry is written into a preset database table.

[0145] like Figure 8 As shown, in one exemplary embodiment, the device also includes: a query parameter classification module 760, which is used to obtain parameter query log data, determine the query frequency and correlation strength of each parameter based on the parameter query log, identify low-frequency query parameters and high-frequency query parameters based on the query frequency and correlation strength of each parameter, and merge the high-frequency query parameters into a preset same data wide table.

[0146] like Figure 8 As shown, in one exemplary embodiment, the device also includes: a data query module 770, which is used to respond to a parameter query request of a request object, the parameter query request carries a parameter to be queried, and determines whether the parameter to be queried is a high-frequency query parameter. In the case that the parameter to be queried is a high-frequency query parameter, based on the parameter to be queried and a precompiled query statement template, a target query statement is constructed, and the target query statement is executed to obtain a query result.

[0147] Each module in the above-mentioned service parameter processing device can be implemented in whole or in part by software, hardware or a combination thereof. Each module can be embedded in or independent of a processor in a computer device in the form of hardware, or can be stored in a memory in a computer device in the form of software, so that the processor can call and execute operations corresponding to each module above.

[0148] In an exemplary embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be shown in FIG9. The computer device includes a processor, a memory, an input / output interface (Input / Output, referred to as I / O) and a communication interface. The processor, the memory and the input / output interface are connected through a system bus, and the communication interface is connected to the system bus through the input / output interface. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store data in a parameter entity mapping table, a parameter flow table, and parameter data to be queried. The input / output interface of the computer device is used to exchange information between the processor and an external device. The communication interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a service parameter processing method is implemented.

[0149] Those skilled in the art will understand that the structure shown in FIG. 9 is merely a block diagram of a partial structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than shown in the figure, or combine certain components, or have a different arrangement of components.

[0150] In an exemplary embodiment, a computer device is provided, including a memory and a processor, wherein a computer program is stored in the memory, and when the processor executes the computer program, the steps in any one of the above-mentioned business parameter method embodiments are implemented.

[0151] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the steps in any one of the above-mentioned business parameter method embodiments are implemented.

[0152] In one embodiment, a computer program product is provided, including a computer program, which implements the steps in any one of the above-mentioned business parameter method embodiments when executed by a processor.

[0153] A person of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment method can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in the present application can include at least one of non-volatile memory and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, an artificial intelligence (AI) processor, etc., but are not limited to this.

[0154] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this application.

[0155] The above-described embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the present application. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application shall be subject to the attached claims.

Claims

1. A service parameter processing method, characterized in that: The method comprises: In response to a parameter configuration request sent by a request object, an editable parameter matching the request object is screened out from a preset parameter entity mapping table, wherein the parameter entity mapping table includes a mapping relationship between parameters and business entities; Based on the editable parameters, a parameter configuration interface is pushed, so that the request object can configure the editable parameters on the parameter configuration interface; Obtaining parameter configuration data submitted by the request object through the parameter configuration interface, generating a parameter configuration entry to be processed based on the parameter configuration data, and inserting the parameter configuration entry into a temporarily created parameter transfer table; Update the status of the parameter configuration item to a pending review status, trigger a preset review and approval process, and review the parameter configuration item; In the case where the parameter configuration entry passes the review, the status of the parameter configuration entry is updated to a review passed status, and the parameter configuration data in the parameter configuration entry is written into a preset business parameter table.

2. The method according to claim 1, characterized in that The step of screening out the editable parameters matching the request object from the preset parameter entity mapping table includes: Extracting the identity of the request object carried in the parameter configuration request; Based on the identity identifier, obtaining entity attribute data of the request object; Based on the entity attribute data, editable parameters matching the request object are screened out from a preset parameter entity mapping table.

3. The method according to claim 2, characterized in that The entity attribute data includes role attributes and operation authority attributes. The step of selecting editable parameters matching the request object from a preset parameter entity mapping table based on the entity attribute data includes: Based on the identity identifier of the request object, query the target parameter associated with the request object from the parameter entity mapping table; According to the role attribute and the data permission attribute, the editable parameters matching the request object are screened out from the target parameters.

4. The method according to claim 1, characterized in that The step of writing the parameter configuration data in the parameter configuration entry into a preset database table includes: Performing version comparison on the parameter configuration data to detect whether there is a conflict between the parameter configuration data of the current version and the parameters of the previous version; In the case that there is no conflict between the parameter configuration data of the current version and the parameters of the previous version, the parameter configuration data in the parameter configuration entry is written into a preset database table.

5. The method according to any one of claims 1 to 4, characterized in that: The method further comprises: Get parameter query log data; Based on the parameter query log, determining the query frequency and correlation strength of each parameter; Based on the query frequency and correlation strength of each parameter, identify low-frequency query parameters and high-frequency query parameters; The high-frequency query parameters are merged into a preset same data wide table.

6. The method according to claim 5, characterized in that The method further comprises: Responding to a parameter query request of a request object, the parameter query request carrying a parameter to be queried; Determining whether the to-be-queried parameter is a high-frequency query parameter; In the case where the to-be-queried parameter is a high-frequency query parameter, constructing a target query statement based on the to-be-queried parameter and a precompiled query statement template; Execute the target query statement to obtain a query result.

7. A service parameter processing device, characterized in that: The device comprises: A data screening module, configured to respond to a parameter configuration request sent by a request object and screen out editable parameters matching the request object from a preset parameter entity mapping table, wherein the parameter entity mapping table includes a mapping relationship between parameters and business entities; A data push module, used for pushing a parameter configuration interface based on the editable parameters, so that the request object can configure the editable parameters on the parameter configuration interface; A data processing module, used for obtaining parameter configuration data submitted by the request object through the parameter configuration interface, generating parameter configuration entries to be processed based on the parameter configuration data, and inserting the parameter configuration entries into a temporarily created parameter transfer table; A data review module, used to update the status of the parameter configuration item to a pending review status, trigger a preset review and approval process, and review the parameter configuration item; The data updating module is used to update the status of the parameter configuration entry to a review passed status when the parameter configuration entry passes the review, and write the parameter configuration data in the parameter configuration entry into a preset business parameter table.

8. The device according to claim 7, characterized in that The data screening module is also used to extract the identity of the request object carried in the parameter configuration request, obtain the entity attribute data of the request object based on the identity, and screen out editable parameters that match the request object from a preset parameter entity mapping table based on the entity attribute data.

9. The device according to claim 8, characterized in that The entity attribute data includes role attributes and operation permission attributes. The data screening module is also used to query the target parameters associated with the request object from the parameter entity mapping table based on the identity of the request object, and screen out editable parameters that match the request object from the target parameters according to the role attributes and data permission attributes.

10. The device according to claim 7, characterized in that The data update module 750 is also used to perform version comparison on the parameter configuration data to detect whether there is a conflict between the parameter configuration data of the current version and the parameters of the previous version. If there is no conflict between the parameter configuration data of the current version and the parameters of the previous version, the parameter configuration data in the parameter configuration entry is written into a preset database table.

11. The device according to any one of claims 7 to 10, characterized in that The device also includes: a query parameter classification module, which is used to obtain parameter query log data, determine the query frequency and association strength of each parameter based on the parameter query log, identify low-frequency query parameters and high-frequency query parameters based on the query frequency and association strength of each parameter, and merge the high-frequency query parameters into a preset same data wide table.

12. The device according to claim 11, characterized in that The device also includes: a data query module, which is used to respond to a parameter query request of a request object, the parameter query request carries a parameter to be queried, determine whether the parameter to be queried is a high-frequency query parameter, and if the parameter to be queried is a high-frequency query parameter, construct a target query statement based on the parameter to be queried and a precompiled query statement template, execute the target query statement, and obtain a query result.

13. A computer device comprising a memory and a processor, wherein the memory stores a computer program, characterized in that: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 are implemented.

14. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

15. A computer program product comprising a computer program, characterized in that When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

Images