Database modification method, system, device and storage medium based on service change

Abstract

The application discloses a database modification method, system, device and storage medium based on business change. It can be applied to the field of cloud computing or the field of finance. The method comprises the following steps: obtaining a plurality of field documents of original code of a to-be-changed business; the original code comprises a plurality of sub-codes, and each field document comprises field information of a sub-code; obtaining a business change document, wherein the business change document comprises field meaning of the to-be-changed business and new processing logic content; determining a target field document matched with the business change document from the plurality of field documents; generating a modification report according to the target field document and the business change document and sending the modification report to a first terminal; the modification report comprises target field information and the new processing logic content; and modifying the original code in a database of the to-be-changed business according to a modification operation instruction sent by the first terminal. The method can accurately locate the field to be changed, assist a user in modifying the original code of the to-be-changed business, and improve the database change efficiency.

Description

TECHNICAL FIELD

[0001] The present application relates to the field of cloud computing or the field of finance, in particular to a database modification method, system, device and storage medium based on business change. BACKGROUND

[0002] With the development of science and technology, more and more businesses of enterprises are realized based on digital systems. Business needs to be converted into database bottom data processing logic to realize basic operation, and efficient database change is an important guarantee for the rapid operation of all digital systems. However, the developers in the field of computers are not familiar with the business logic of some industries, for example, the financial industry. Most of the changes in bank business need to change the data processing logic of the database in time, which makes the operation task of the database more heavy. However, due to the lack of cross personnel between finance and computer field, most computer personnel have low operation efficiency and many operation mistakes in the case of not understanding the bank business logic, which makes the risk cost of database change large. SUMMARY

[0003] In view of the above problems, the present application provides a database modification method, system, device and storage medium based on business change, which can match the field of the original code and the business change demand, locate the detailed information of the field to be modified, and improve the database change efficiency.

[0004] The present application discloses the following technical solutions:

[0005] The first aspect of the embodiment of the present application provides a database modification method based on business change, comprising:

[0006] Obtaining a plurality of field documents of the original code of the business to be changed; the original code comprises a plurality of sub-codes, and each field document comprises field information of the corresponding sub-code;

[0007] Obtaining a business change document, the business change document comprising: field meaning and new processing logic content of the business to be changed;

[0008] Determining a target field document matched with the business change document from the plurality of field documents;

[0009] Generating a modification report according to the target field document and the business change document and sending the modification report to a first terminal; the modification report containing target field information and new processing logic content; the modification report is used to assist a first user to modify the original code in the database of the business to be changed; the target field information is the field information of the sub-code corresponding to the target field document;

[0010] Modifying the original code in the database of the business to be changed according to a modification operation instruction, the modification operation instruction being sent by the first terminal in response to the modification operation of the first user.

[0011] In a possible implementation, the obtaining a plurality of field documents of the original code of the to-be-changed service comprises:

[0012] obtaining the original code of the to-be-changed service from a database;

[0013] splitting the original code of the to-be-changed service to obtain a plurality of split sub-code contents;

[0014] extracting field information from each sub-code content; the field information comprises a service attribute field, field meaning, position information of the field, and processing logic marker information; the processing logic marker information is used to indicate whether the corresponding field is a processing logic field;

[0015] generating a field document according to the field information.

[0016] In a possible implementation, the extracting the field information from each sub-code content comprises:

[0017] obtaining a service attribute field from each sub-code;

[0018] generating field meaning according to the service attribute field;

[0019] marking the service attribute field associated with the processing logic as a processing logic field;

[0020] recording the corresponding code position of the processing logic field.

[0021] In a possible implementation, the generating field meaning according to the service attribute field comprises:

[0022] generating Chinese field meaning according to the English service attribute field.

[0023] In a possible implementation, the determining a target field document matched with the service change document from the plurality of field documents comprises:

[0024] determining, from the plurality of field documents, a target field document in which the field meaning in the field information matches the field meaning of the to-be-changed service.

[0025] In a possible implementation, the obtaining the service change document comprises:

[0026] receiving service change information sent by a second terminal in response to an input operation of a second user, and generating a service change document according to the service change information and a preset service change document template.

[0027] In a possible implementation, the generating a field document according to the field information comprises:

[0028] The field document is generated according to the field information and a preset field document template.

[0029] The second aspect of the present application provides a database modification system based on business change, comprising:

[0030] A field document acquisition module is configured to acquire a plurality of field documents of the original code of the business to be changed; the original code comprises a plurality of sub-codes, and each field document comprises field information of a corresponding sub-code.

[0031] A business change document acquisition module is configured to acquire a business change document, wherein the business change document comprises field meaning of the business to be changed and new processing logic content.

[0032] A determination module is configured to determine a target field document matched with the business change document from the plurality of field documents.

[0033] A modification report generation module is configured to generate a modification report according to the target field document and the business change document and send the modification report to the first terminal; the modification report comprises target field information and the new processing logic content; the modification report is used to assist the first user to modify the original code in the database of the business to be changed; the target field information is field information of the sub-code corresponding to the target field document.

[0034] A modification module is configured to modify the original code in the database of the business to be changed according to a modification operation instruction, wherein the modification operation instruction is sent by the first terminal in response to a modification operation of the first user.

[0035] The third aspect of the present application provides a database modification device based on business change, comprising a processor, a memory and a system bus.

[0036] The processor and the memory are connected through the system bus.

[0037] The memory is configured to store one or more programs, wherein the one or more programs comprise instructions, and the instructions, when executed by the processor, cause the processor to execute the database modification method based on business change provided in the first aspect of the present application.

[0038] The fourth aspect of the present application provides a computer readable storage medium, wherein the computer readable storage medium stores instructions, and when the instructions run on a terminal device, the terminal device executes the database modification method based on business change provided in the first aspect of the present application.

[0039] Compared with the prior art, the present application has the following beneficial effects:

[0040] The application provides a database modification method based on business change, acquires a plurality of field documents of original code of a to-be-changed business; each field document comprises field information of part of the original code; acquires a business change document, wherein the business change document comprises field meaning of the to-be-changed business and new processing logic content; determines a target field document matched with the business change document from the plurality of field documents; generates a modification report according to the target field document and the business change document and sends the modification report to a first terminal; the modification report comprises field information to be changed and the new processing logic content; the modification report is used for assisting a first user to modify the original code in a database of the to-be-changed business; and the original code in the database of the to-be-changed business is modified according to a modification operation instruction sent by the first terminal in response to a modification operation of the first user. The method can match the field of the original code with the business change requirement, accurately locate detailed information of the field to be changed, assist a developer to modify the corresponding original code, and improve database change efficiency. BRIEF DESCRIPTION OF DRAWINGS

[0041] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, the drawings needed to be used in the embodiments or prior art description will be briefly introduced. Obviously, the drawings in the following description are only some embodiments of the present application, and other drawings can be obtained by those skilled in the art without creative labor under the premise of the drawings.

[0042] Figure 1 An application scenario schematic diagram provided by the embodiments of the present application;

[0043] Figure 2 A database modification method flow chart based on business change provided by the embodiments of the present application;

[0044] Figure 3 A database modification method flow chart based on business change provided by the embodiments of the present application;

[0045] Figure 4 Another database modification system structure diagram based on business change provided by the embodiments of the present application;

[0046] Figure 5 A computer structure diagram provided by the embodiments of the present application. DETAILED DESCRIPTION

[0047] As mentioned earlier, more and more enterprises are implementing their businesses based on digital systems. These businesses need to be transformed into the underlying data processing logic of the database to perform basic operations. Efficient database changes are crucial for the rapid operation of any digital system. However, computer science developers are not familiar with the business logic of certain industries, such as the financial industry. Most changes to banking operations require timely modifications to the database's data processing logic, making database operations more demanding. However, due to a shortage of interdisciplinary talent in finance and computer science, most computer personnel, lacking understanding of banking business logic, perform database change operations inefficiently and prone to errors, resulting in significant risks and costs associated with database changes.

[0048] In view of this, embodiments of this application provide a database modification method, system, device, and storage medium based on business changes. To facilitate understanding of the database modification method based on business changes provided in embodiments of this application, the following will be combined with... Figure 1 The scenario example shown is used for illustration. Among them, Figure 1 This is a schematic diagram illustrating a scenario example provided in an embodiment of this application. The method can be applied to service device 101.

[0049] In practical applications, service device 101 receives a service change document sent by terminal device 102, or receives service change information sent by terminal device 102 based on the operation of a second user (business personnel) inputting service change content, and generates a service change document based on the service change information; the service change document includes: the meaning of the fields of the service to be changed and the new processing logic content;

[0050] Service device 101 acquires multiple field documents of the source code for the business to be changed; each field document includes field information of part of the source code; acquires a business change document, which includes: the meaning of the fields of the business to be changed and the new processing logic content; determines a target field document that matches the business change document from the multiple field documents; generates a modification report based on the target field document and the business change document; the modification report contains the field information to be changed and the new processing logic content; service device 101 sends the modification report to terminal device 103 used by the first user (developer) to assist the first user in modifying the source code of the database for the business to be changed, and the first user modifies the source code of the database through the terminal device 103 according to the modification report. This method can match the fields of the original code with the business change requirements, accurately locate the detailed information of the fields that need to be changed, assist developers in modifying the corresponding source code, and improve the efficiency of database changes.

[0051] Those skilled in the art will understand that Figure 1The schematic diagram shown is merely one example in which embodiments of this application can be implemented. The scope of application of the embodiments of this application is not limited by any aspect of this framework.

[0052] To enable those skilled in the art to better understand the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present application, and not all embodiments. All other embodiments obtained by those skilled in the art based on the embodiments of the present application without creative effort are within the scope of protection of the present application.

[0053] See Figure 2 The figure is a flowchart of a processing logic modification method provided in an embodiment of this application. This method can be applied to a server, such as... Figure 2 As shown, the method includes:

[0054] S201. Obtain the business change document, which includes: the meaning of the fields of the business to be changed and the new processing logic content.

[0055] In one possible implementation, S201 includes:

[0056] Receive service change information sent by the second terminal in response to the input operation of the second user, and generate a service change document based on the service change information and a preset service change document template.

[0057] In one example, the business change document content is shown in Table 1-1 below. Business personnel fill in the fields that need to be changed in the business, as well as the processing logic that needs to be changed, according to the actual business change requirements. The field meanings are information mapped to the field document. For example, if the calculation method for the 'transaction amount' business needs to be changed, then the 'field meaning' should be filled in as 'transaction amount,' and the corresponding processing method should be filled in the 'new processing logic content' section.

[0058] Table 1-1 Business Change Documents

[0059] Field Meaning Does code logic processing exist Content of new processing logic Transaction amount Exist XXXXAAAA

[0060] S202. Obtain multiple field documents of the source code of the business to be changed; the source code includes multiple sub-codes, and each field document includes the field information of the corresponding sub-code;

[0061] In one possible implementation, S202 includes:

[0062] A1: Retrieve the source code of the business logic to be changed from the database;

[0063] A2: Split the original code of the business to be changed into multiple sub-code contents;

[0064] A3: Extract field information from each sub-code content; the field information includes business attribute fields, field meanings, field location information, and processing logic marker information; the processing logic marker information is used to indicate whether the corresponding field is a processing logic field;

[0065] In one possible implementation, A3 includes:

[0066] A30: Retrieve business attribute fields from each sub-code;

[0067] A31: Generate field meanings based on business attribute fields;

[0068] In one possible implementation, A31 includes:

[0069] Generate Chinese field meanings based on the English business attribute fields.

[0070] A32: Mark the business attribute fields associated with the processing logic as processing logic fields;

[0071] A33: Records the code location corresponding to the processing logic field.

[0072] A4: Generate field documents based on field information.

[0073] In one possible implementation, A4 includes: generating field documents based on field information and a pre-defined field document template.

[0074] In one example, the code is broken down, extracting all existing business-related content, such as product names, product accounting codes, and transaction occurrence lines, and grouping them into one category. Fields involving product processing are then tagged, and all processing logic is marked, for example, using the word "processing" as a tag to record line numbers and automatically populate the corresponding positions in the field document.

[0075] In this embodiment, technicians can also manually fill in the field document by splitting the content according to the original code.

[0076] In one example, the database operations and maintenance personnel designed the field document template, as shown in Table 1-2, which includes: "'Field', 'Field Meaning', 'Line Number of the Field', 'Whether Code Logic Processing Exists', 'Whether Processing Logic Has Been Changed'". The header information of the corresponding business logic processing document can be designed as "'Field Meaning', 'Whether Processing Logic Has Been Updated', 'New Processing Logic Content'".

[0077] Table 1-2 Field Documentation

[0078]

[0079] This application embodiment splits the content of the original code, extracts business-related field information from the split sub-code content, and generates field documents corresponding to the sub-code content based on the field information. This facilitates the matching of subsequent business change documents with field documents, thereby locating the sub-code to be modified and other information.

[0080] S203. Determine the target field document that matches the business change document from multiple field documents;

[0081] In the embodiments of this application, the matched target field document can accurately locate the source code location and other information that needs to be modified.

[0082] In one possible implementation, S203 includes:

[0083] Based on the meaning of the fields in the field information, determine the target field information that matches the meaning of the field in the business that needs to be changed from multiple field information.

[0084] This embodiment accurately matches business change information with the change information to be changed in the database, thereby saving cloud computing personnel a lot of time and reducing corresponding code operation errors.

[0085] S204. Generate a modification report based on the target field document and the business change document and send it to the first terminal; the modification report includes target field information and new processing logic content; the modification report is used to assist the first user in modifying the original code in the database of the business to be changed; the target field information is the field information of the sub-code corresponding to the target field document;

[0086] In one example, the modification report is exported as an Excel file, indicating the locations to be modified and the total number of modifications required.

[0087] The field documents generated from the split content of the original code are cross-compared with the business documents generated from the information filled in by business personnel. A modification report is generated using 'field meaning' as the join column. Table 1-3 shows an example of the modification report content.

[0088] Table 1-3 Revision Report

[0089]

[0090] S205. Modify the original code in the database of the service to be changed according to the modification operation instruction of the first terminal. The modification operation instruction of the first terminal is generated by the modification operation made by the first user based on the modification report.

[0091] This application embodiment can match the fields of the original code with the fields of the business change requirements provided by the business personnel, locate the detailed information of the fields that need to be modified, assist the developers in modifying the corresponding original code, separate the work of business personnel and technical personnel, achieve technical unification, reduce the time cost caused by mutual communication, reduce database operation errors, reduce database change costs, and improve production efficiency.

[0092] It should be noted that the execution order of S201-S202 is not limited in the embodiments of this application. For example, S202 can be executed first and then S201 can be executed, or S201 and S202 can be executed simultaneously.

[0093] Figure 3 This document provides a flowchart illustrating a database modification process based on business changes, as exemplified in this application. Figure 3 As shown, the source code obtained from the database will be split into code segments, and corresponding field documents will be generated based on the split code content. After business personnel enter the business change content, a business change document will be generated. The business change document will be matched with the corresponding field document, and a modification report will be generated based on the content of the business change document and the corresponding field document.

[0094] Figure 4 This application provides a system architecture diagram for database modification based on business changes, as illustrated in an embodiment. Figure 4 As shown, the system includes:

[0095] The field document acquisition module 410 is used to acquire multiple field documents of the source code of the business to be changed; the source code includes multiple sub-codes, and each field document includes the field information of the corresponding sub-code;

[0096] The business change document acquisition module 420 is used to acquire business change documents, which include: the meaning of the fields of the business to be changed and the new processing logic content;

[0097] The determination module 430 is used to determine the target field document that matches the business change document from multiple field documents;

[0098] The modification report generation module 440 is used to generate a modification report based on the target field document and the business change document and send it to the first terminal; the modification report includes target field information and new processing logic content; the modification report is used to assist the first user in modifying the original code in the database of the business to be changed; the target field information is the field information of the sub-code corresponding to the target field document;

[0099] The modification module 450 is used to modify the original code in the database of the service to be changed according to the modification operation instruction, wherein the modification operation instruction is sent by the first terminal in response to the modification operation of the first user.

[0100] This application embodiment can match the fields of the original code with the business change requirements, accurately locate the detailed information of the fields that need to be changed, so as to assist developers in modifying the corresponding original code and improve the efficiency of database changes.

[0101] In one possible implementation, the field document retrieval module 410 includes:

[0102] The source code retrieval module is used to retrieve the source code of the business logic to be changed from the database;

[0103] The splitting module is used to split the original code of the business to be changed into multiple split sub-code contents;

[0104] The extraction module is used to extract field information from each sub-code content; the field information includes business attribute fields, field meanings, field location information, and processing logic marker information; the processing logic marker information is used to indicate whether the corresponding field is a processing logic field.

[0105] The generation module is used to generate field documents based on field information.

[0106] In one possible implementation, the extraction module includes:

[0107] The business attribute field retrieval module is used to retrieve business attribute fields from each sub-code.

[0108] The field meaning generation module is used to generate field meanings based on business attribute fields.

[0109] The tagging module is used to mark business attribute fields associated with processing logic as processing logic fields;

[0110] The recording module is used to record the code location corresponding to the processing logic fields.

[0111] In one possible implementation, the field meaning generation module is specifically used to generate Chinese field meanings based on English business attribute fields.

[0112] In one possible implementation, the determining module is used to determine, from multiple field documents, a target field document whose field meaning in the field information matches the field meaning of the business to be changed.

[0113] In one possible implementation, the business change document acquisition module is specifically used for:

[0114] Receive service change information sent by the second terminal in response to the input operation of the second user, and generate a service change document based on the service change information and a preset service change document template.

[0115] In one possible implementation, the generation module is specifically used to generate field documents based on field information and a preset field document template.

[0116] This application provides a computer-readable storage medium storing instructions that, when executed on a terminal device, cause the terminal device to perform a database modification method based on business changes as described in this application.

[0117] In practical applications, the computer-readable storage medium can be any combination of one or more computer-readable media. The computer-readable medium can be a computer-readable signal medium or a computer-readable storage medium. For example, a computer-readable storage medium can be, but is not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of computer-readable storage media (a non-exhaustive list) include: an electrical connection having one or more wires, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof. In this embodiment, the computer-readable storage medium can be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.

[0118] Computer-readable signal media may include data signals propagated in baseband or as part of a carrier wave, carrying computer-readable program code. Such propagated data signals may take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. Computer-readable signal media may also be any computer-readable medium other than computer-readable storage media, capable of sending, propagating, or transmitting programs for use by or in connection with an instruction execution system, apparatus, or device.

[0119] Program code contained on a computer-readable medium may be transmitted using any suitable medium, including but not limited to wireless, wire, optical fiber, RF, etc., or any suitable combination thereof.

[0120] Computer program code for performing the operations of this invention can be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, and C++, as well as conventional procedural programming languages ​​such as "C" or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving remote computers, the remote computer can be connected to the user's computer via any type of network—including a local area network (LAN) or a wide area network (WAN)—or can be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0121] like Figure 5 The diagram shown is a structural schematic of a computer device provided in an embodiment of this application. Figure 5 The computer device 12 shown is merely an example and should not impose any limitation on the functionality and scope of use of the embodiments of the present invention.

[0122] like Figure 5 As shown, the computer device 12 is represented in the form of a general-purpose computing device. The components of the computer device 12 may include, but are not limited to: one or more processors or processing units 16, system memory 28, and a bus 18 connecting different system components (including system memory 28 and processing unit 16).

[0123] Bus 18 represents one or more of several bus architectures, including a memory bus or memory controller, a peripheral bus, a graphics acceleration port, a processor, or a local bus using any of the various bus architectures. For example, these architectures include, but are not limited to, the Industry Standard Architecture (ISA) bus, the Micro Channel Architecture (MAC) bus, the Enhanced ISA bus, the Video Electronics Standards Association (VESA) local bus, and the Peripheral Component Interconnect (PCI) bus.

[0124] Computer device 12 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by computer device 12, including volatile and non-volatile media, removable and non-removable media.

[0125] System memory 28 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 30 and / or cache memory 32. Computer device 12 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, storage system 34 may be used to read and write non-removable, non-volatile magnetic media (…). Figure 5 Not shown; usually referred to as a "hard drive"). Although Figure 5 Not shown, a disk drive for reading and writing to a removable non-volatile disk (e.g., a "floppy disk") and an optical disk drive for reading and writing to a removable non-volatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to bus 18 via one or more data media interfaces. Memory 28 may include at least one program product having a set (e.g., at least one) of program modules configured to perform the functions of the embodiments of the present invention.

[0126] A program / utility 40 having a set (at least one) of program modules 42 may be stored, for example, in memory 28. Such program modules 42 include, but are not limited to, an operating system, one or more application programs, other program modules, and program data. Each or some combination of these examples may include an implementation of a network environment. Program modules 42 typically perform the functions and / or methods described in the embodiments of the present invention.

[0127] Computer device 12 can also communicate with one or more external devices 14 (e.g., keyboard, pointing device, display 24, etc.), and with one or more devices that enable a user to interact with the computer device 12, and / or with any device that enables the computer device 12 to communicate with one or more other computing devices (e.g., network card, modem, etc.). This communication can be performed through input / output (I / O) interface 22. Furthermore, computer device 12 can also communicate with one or more networks (e.g., local area network (LAN), wide area network (WAN), and / or public networks, such as the Internet) through network adapter 20. Figure 5 As shown, network adapter 20 communicates with other modules of computer device 12 via bus 18. It should be understood that, although... Figure 5 As not shown, it can be used in conjunction with computer device 12 with other hardware and / or software modules, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0128] The processor unit 16 executes various functional applications and data processing by running programs stored in the system memory 28, such as implementing the database modification method based on business changes provided in the embodiments of this application.

[0129] The database modification method, system, device, and storage medium based on business changes provided by this invention can be used in the financial field or the cloud computing field. The above are just examples and do not limit the application fields of the database modification method, system, device, and storage medium based on business changes provided by this invention.

[0130] It should be noted that the term "comprising" and its variations as used herein are open-ended, meaning "including but not limited to". The term "according to" means "at least in part according to". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments". Definitions of other terms will be given in the following description.

[0131] It should be noted that the concepts of "first" and "second" mentioned in this application are only used to distinguish different devices, modules or units, and are not used to limit the order of functions performed by these devices, modules or units or their interdependencies.

[0132] It should be noted that although the subject matter has been described using language specific to structural features and / or methodological logic, it should be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or actions described above. Rather, the specific features and actions described above are merely illustrative examples of implementing the claims.

[0133] While several specific implementation details are included in the foregoing discussion, these should not be construed as limiting the scope of this application. Certain features described in the context of individual embodiments may also be implemented in combination in a single embodiment. Conversely, various features described in the context of a single embodiment may also be implemented individually or in any suitable sub-combination in multiple embodiments.

[0134] The above description is merely a preferred embodiment of this application and an explanation of the technical principles employed. Those skilled in the art should understand that the scope of disclosure in this application is not limited to technical solutions formed by specific combinations of the above-described technical features, but should also cover other technical solutions formed by arbitrary combinations of the above-described technical features or their equivalents without departing from the above-described concept. For example, technical solutions formed by substituting the above features with (but not limited to) technical features with similar functions disclosed in this application.

Claims

1. A database modification method based on business changes, characterized in that, include: Obtain multiple field documents from the source code of the business logic to be changed; The source code includes multiple sub-codes, and each field document includes the field information of the corresponding sub-code; Obtain the business change document, which includes: the meaning of the fields in the business to be changed and the new processing logic content; Identify the target field document that matches the business change document from multiple field documents; A modification report is generated based on the target field document and the business change document and sent to the first terminal; the modification report contains target field information and new processing logic content; the modification report is used to assist the first user in modifying the original code in the database of the business to be changed; the target field information is the field information of the sub-code corresponding to the target field document; The original code in the database of the service to be changed is modified according to the modification operation instruction, wherein the modification operation instruction is sent by the first terminal in response to the modification operation of the first user; The document containing multiple fields of the source code for the business to be changed includes: Retrieve the source code of the business logic to be changed from the database; The original code of the business to be changed is split into multiple sub-codes; Extract field information from each sub-code; the field information includes business attribute fields, field meanings, field location information, and processing logic marker information; the processing logic marker information is used to indicate whether the corresponding field is a processing logic field. Generate field documents based on field information.

2. The method according to claim 1, characterized in that, The extraction of field information from each sub-code includes: Retrieve business attribute fields from each sub-code; Generate field meanings based on business attribute fields; Mark the business attribute fields associated with the processing logic as processing logic fields; Record the code location corresponding to the processing logic field.

3. The method according to claim 2, characterized in that, The process of generating field meanings based on business attribute fields includes: Generate Chinese field meanings based on the English business attribute fields.

4. The method according to claim 1, characterized in that, The step of determining the target field document that matches the business change document from multiple field documents includes: From multiple field documents, identify the target field document whose field meaning matches the meaning of the field in the business that needs to be changed.

5. The method according to claim 1, characterized in that, Obtain business change documents, including: Receive service change information sent by the second terminal in response to the input operation of the second user, and generate a service change document based on the service change information and a preset service change document template.

6. The method according to claim 1, characterized in that, The process of generating field documents based on field information includes: Generate field documents based on field information and preset field document templates.

7. A database modification system based on business changes, characterized in that, include: The field document retrieval module is used to retrieve multiple field documents from the source code of the business logic to be changed; The source code includes multiple sub-codes, and each field document includes the field information of the corresponding sub-code; The business change document acquisition module is used to acquire business change documents, which include: the meaning of the fields of the business to be changed and the new processing logic content; The determination module is used to identify the target field document that matches the business change document from multiple field documents; The modification report generation module is used to generate a modification report based on the target field document and the business change document and send it to the first terminal; the modification report includes target field information and new processing logic content; the modification report is used to assist the first user in modifying the original code in the database of the business to be changed; the target field information is the field information of the sub-code corresponding to the target field document; The modification module is used to modify the original code in the database of the service to be changed according to the modification operation instruction, wherein the modification operation instruction is sent by the first terminal in response to the modification operation of the first user; The field document retrieval module includes: The source code retrieval module is used to retrieve the source code of the business logic to be changed from the database; The splitting module is used to split the original code of the business to be changed into multiple split sub-code contents; The extraction module is used to extract field information from each sub-code content; the field information includes business attribute fields, field meanings, field location information, and processing logic marker information; the processing logic marker information is used to indicate whether the corresponding field is a processing logic field. The generation module is used to generate field documents based on field information.

8. A database modification device based on business changes, characterized in that, include: Processor, memory, system bus; The processor and the memory are connected via the system bus; The memory is used to store one or more programs, the one or more programs including instructions that, when executed by the processor, cause the processor to perform the database modification method based on business changes as described in any one of claims 1-6.

9. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores instructions that, when executed on a terminal device, cause the terminal device to perform the database modification method based on business changes as described in any one of claims 1-6.

Images