Database type selection delivery processing method, device, equipment, medium and program product

Abstract

The embodiment of the invention provides a database type selection delivery processing method and device, equipment, a medium and a program product, which are applied to computer equipment and comprise the following steps: acquiring parameter information of a system before upgrading; obtaining parameter information of the system after upgrading, and obtaining difference parameters according to the parameter information of the system before upgrading and the parameter information of the system after upgrading; obtaining feature parameters of a plurality of databases to be delivered and insurance service feature parameters; generating a to-be-delivered database according to the feature parameters of the plurality of to-be-delivered databases, the insurance service feature parameters and the difference parameters through a model selection algorithm model; the to-be-delivered database is configured through the automatic tool so as to realize delivery of the database, manual model selection of the database is not needed, the process of manual model selection testing is saved, and the model selection delivery efficiency of the database is improved.

Description

Technical Field

[0001] The present application relates to the field of database technology, and in particular to a database selection and delivery processing method, device, equipment, medium and program product. Background Art

[0002] The independent control of database technology can ensure the security of data. In the financial and insurance industries, in order to ensure data security, enterprises need to replace and upgrade databases. However, there are large differences between database products, and different database products have different compatibility with data types. If the database selection does not match, the program that runs normally on the original database may not run.

[0003] In the prior art, when selecting and delivering a product, developers select multiple suitable target databases according to the original database type, test and verify the selected target databases, and select a suitable database product application from the multiple target databases for delivery.

[0004] However, in the existing technical solutions, data needs to be temporarily migrated to the selected target database during the testing process. The data migration is time-consuming for large amounts of data, and when too many target databases are selected, a high amount of test resources are required, resulting in a decrease in the efficiency of database selection and delivery. Summary of the invention

[0005] The embodiments of the present application provide a database selection and delivery processing method, device, equipment, medium and program product to solve the problem of low efficiency of database selection and delivery existing in the prior art.

[0006] In a first aspect, an embodiment of the present application provides a database selection delivery processing method, which is applied to a computer device, including:

[0007] Get the parameter information of the system before upgrading;

[0008] Acquire parameter information of the upgraded system, and obtain difference parameters according to the parameter information of the system before the upgrade and the parameter information of the upgraded system;

[0009] Obtain characteristic parameters of multiple databases to be delivered and characteristic parameters of insurance business;

[0010] Generate a database to be delivered according to the characteristic parameters of the plurality of databases to be delivered, the insurance business characteristic parameters and the difference parameters through a selection algorithm model;

[0011] The database to be delivered is configured through an automated tool to achieve delivery of the database.

[0012] In a possible implementation, the database to be delivered is generated according to the characteristic parameters of the multiple databases to be delivered, the insurance business characteristic parameters and the difference parameters through the selection algorithm model, including: generating an estimated data volume of the insurance business according to the insurance business characteristic parameters; judging the data size of the estimated data volume; if the data size of the estimated data volume is less than a preset data threshold, determining that the type of the database to be delivered is a centralized database according to the characteristic parameters of the multiple databases to be delivered; obtaining the transaction processing volume per second of the upgraded system according to the difference parameters; matching the centralized database according to the transaction processing volume per second of the upgraded system to generate the database to be delivered.

[0013] In a possible implementation, after determining the data size of the estimated data volume, it also includes: if the data size of the estimated data volume is greater than a preset data threshold, obtaining a business scenario of the upgraded system; if there is no complex business scenario in the business scenario of the upgraded system, determining that the type of database to be delivered is a distributed database based on the characteristic parameters of the multiple databases to be delivered; if there is a complex business scenario in the business scenario of the upgraded system, determining whether the data size of the estimated data volume can be divided into a preset segmentation threshold; if the data size of the estimated data volume is divided into a preset segmentation threshold, determining that the type of database to be delivered is a centralized database based on the characteristic parameters of the multiple databases to be delivered.

[0014] In a possible implementation, the selection algorithm model is:

[0015]

[0016] In the formula, Represents the database to be delivered; represents the parameter information of the upgraded system; α(a, b, c) represents the product difference value; Indicates the server difference value; Represents the actual information of the existing system database or server; It indicates the parameter information of the system before upgrading; h(z) indicates the selection function.

[0017] In a possible implementation, configuring the database to be delivered through an automated tool to achieve the delivery of the database includes: configuring the database environment of the cloud service platform through the automated tool; calling the resources of the cloud service platform and running an automated deployment script in the database environment of the cloud service platform to install the database to be delivered; testing the operating status of the database to be delivered to determine whether the database to be delivered is running normally; if the database to be delivered is running normally, the database is delivered.

[0018] In a second aspect, an embodiment of the present application provides a database selection delivery processing device, which is applied to a computer device, including:

[0019] A first acquisition module is used to acquire parameter information of the system before upgrading;

[0020] A second acquisition module is used to acquire parameter information of the upgraded system, and obtain difference parameters according to the parameter information of the system before the upgrade and the parameter information of the upgraded system;

[0021] A third acquisition module is used to acquire characteristic parameters of multiple databases to be delivered and characteristic parameters of insurance business;

[0022] A generation module, used for generating a database to be delivered according to the characteristic parameters of the plurality of databases to be delivered, the insurance business characteristic parameters and the difference parameters through a selection algorithm model;

[0023] The configuration module is used to configure the database to be delivered through an automated tool to achieve the delivery of the database.

[0024] In a possible implementation, the generation module includes: a generation unit, used to generate an estimated data volume of the insurance business according to the characteristic parameters of the insurance business; a first judgment unit, used to judge the data size of the estimated data volume; a first determination unit, used to determine that the type of database to be delivered is a centralized database according to the characteristic parameters of the multiple databases to be delivered if the data size of the estimated data volume is less than a preset data threshold; a first acquisition unit, used to acquire the transaction processing volume per second of the upgraded system according to the difference parameters; a matching unit, used to match the centralized database according to the transaction processing volume per second of the upgraded system to generate a database to be delivered.

[0025] In a third aspect, an embodiment of the present application provides a database selection delivery processing device, including:

[0026] at least one processor and memory;

[0027] The memory stores computer-executable instructions;

[0028] The at least one processor executes the computer-executable instructions stored in the memory, so that the at least one processor executes the above first aspect and / or various possible implementations of the first aspect.

[0029] In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, in which computer-executable instructions are stored. When the computer-executable instructions are executed by a processor, they are used to implement the first aspect above and / or various possible implementations of the first aspect.

[0030] In a fifth aspect, an embodiment of the present application provides a computer program product, including a computer program, which, when executed by a processor, implements the above first aspect and / or various possible implementation methods of the first aspect.

[0031] The database selection and delivery processing method, device, equipment, medium and program product provided in the embodiments of the present application obtain parameter information before and after the system upgrade, compare and obtain difference parameters, automatically select and generate the database to be delivered through the selection algorithm model according to the characteristic parameters of multiple databases to be delivered and the characteristic parameters of the insurance business, and configure the database to be delivered through an automated tool to realize the delivery of the database, without the need for manual selection of the database, saving the process of manual selection and testing, and improving the efficiency of database selection and delivery. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and, together with the description, serve to explain the principles of the present application.

[0033] Figure 1 A schematic diagram of the system structure of a computer device provided in an embodiment of the present application;

[0034] Figure 2 A flowchart of the database selection and delivery processing method provided for this application;

[0035] Figure 3 A schematic diagram of the structure of the database selection delivery processing device provided for this application;

[0036] Figure 4 A schematic diagram of the structure of the database selection delivery processing equipment provided for this application.

[0037] The above drawings have shown clear embodiments of the present application, which will be described in more detail later. These drawings and text descriptions are not intended to limit the scope of the present application in any way, but to illustrate the concept of the present application to those skilled in the art by referring to specific embodiments. DETAILED DESCRIPTION

[0038] Exemplary embodiments will be described in detail herein, examples of which are shown in the accompanying drawings. When the following description refers to the drawings, unless otherwise indicated, the same numbers in different drawings represent the same or similar elements. The implementations described in the following exemplary embodiments do not represent all implementations consistent with the present application. Instead, they are merely examples of devices and methods consistent with some aspects of the present application as detailed in the appended claims.

[0039] 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 laws, regulations and standards, and provide corresponding operation entrances for users to choose to authorize or refuse.

[0040] The autonomy and controllability of database technology can ensure the security of data. In the financial and insurance industries, in order to ensure data security, enterprises need to replace and upgrade databases. However, there are large differences between database products, and different database products have different compatibility with data types. If the database selection does not match, the program that runs normally on the original database may not be able to run. In the prior art, when selecting and delivering, developers select multiple suitable target databases according to the original database type, test and verify the selected target database, and select a suitable database product application from multiple target databases for delivery. However, in the existing technical solutions, the data needs to be temporarily migrated to the selected target database during the testing process. For large amounts of data, data migration is time-consuming and when too many target databases are selected, the test resources required are high, resulting in a reduction in the efficiency of database selection and delivery.

[0041] In order to solve the above technical problems, the embodiments of the present application propose the following technical ideas: the inventor considers designing a selection algorithm model, obtaining parameter information before and after the system upgrade, comparing the system parameter information before and after the upgrade, obtaining difference parameters, considering obtaining characteristic parameters of insurance business and characteristic parameters of multiple databases to be delivered, inputting the difference parameters, insurance business characteristic parameters and characteristic parameters of the databases to be delivered into the selection algorithm model, automatically screening and determining the databases to be delivered through the selection algorithm model, and configuring the databases to be delivered through automated tools, without manual selection, testing and delivery. The following is a detailed description using a detailed embodiment.

[0042] Figure 1 A schematic diagram of the system structure of a computer device provided in an embodiment of the present application. Figure 1 As shown, the computer device includes: a receiving device 101, a processor 102 and a display device 103.

[0043] It is understandable that the structure illustrated in the embodiment of the present application does not constitute a specific limitation on the object identification method. In other feasible implementations of the present application, the above architecture may include more or fewer components than shown in the figure, or combine certain components, or split certain components, or arrange the components differently, which can be determined according to the actual application scenario and is not limited here. Figure 1The components shown may be implemented in hardware, software, or a combination of software and hardware.

[0044] In a specific implementation process, the receiving device 101 may be an input / output interface or a communication interface, and may obtain parameter information of the system before and after the upgrade.

[0045] The processor 102 may determine the database to be delivered through a selection algorithm.

[0046] The display device 103 can be used to display the above-mentioned database to be delivered.

[0047] The display device may also be a touch display screen, which is used to receive user instructions while displaying the above-mentioned content, so as to realize operational interaction with the user.

[0048] It should be understood that the above-mentioned processor can be implemented by the processor reading instructions in the memory and executing the instructions, or it can be implemented by a chip circuit.

[0049] In addition, the network architecture and business scenarios described in the embodiments of the present application are intended to more clearly illustrate the technical solutions of the embodiments of the present application, and do not constitute a limitation on the technical solutions provided in the embodiments of the present application. Ordinary technicians in this field can know that with the evolution of network architecture and the emergence of new business scenarios, the technical solutions provided in the embodiments of the present application are also applicable to similar technical problems.

[0050] Figure 2 This is a flowchart of the database selection and delivery processing method provided by this application. The execution subject of this embodiment can be a computer device, and this embodiment is not particularly limited here. Figure 2 As shown, the method includes:

[0051] S201: Obtain parameter information of the system before upgrading.

[0052] In this embodiment, the parameter information of the system before the upgrade includes application parameter information and database parameter information.

[0053] The application parameter information includes but is not limited to application development language, concurrency and business logic.

[0054] The database parameter information includes but is not limited to data volume, hardware configuration, number of connections, and key information of database tables.

[0055] S202: Acquire parameter information of the upgraded system, and obtain difference parameters according to the parameter information of the system before the upgrade and the parameter information of the upgraded system.

[0056] In this embodiment, the parameter information of the upgraded system includes application parameter information of the upgraded system and database parameter information of the upgraded system.

[0057] In this embodiment, the difference parameters include, but are not limited to, the difference in business support time of the system before and after the upgrade, the difference in business pressure growth, the difference in data volume growth, and the difference in performance growth.

[0058] S203: Acquire characteristic parameters of multiple databases to be delivered and characteristic parameters of insurance business.

[0059] In this embodiment, the characteristic parameters of the database to be delivered include, but are not limited to, the data capacity, database form, and database size of the database.

[0060] In this embodiment, characteristic parameters of the insurance business include, but are not limited to, business data volume, business type, and business process.

[0061] S204: Generate a database to be delivered according to characteristic parameters of multiple databases to be delivered, insurance business characteristic parameters and difference parameters through a selection algorithm model.

[0062] In this embodiment, the selection algorithm model is:

[0063]

[0064] In the formula, Represents the database to be delivered; represents the parameter information of the upgraded system; α(a, b, c) represents the product difference value; Indicates the server difference value; Represents the actual information of the existing system database or server; It indicates the parameter information of the system before upgrading; h(z) indicates the selection function.

[0065] S205: The database to be delivered is configured through an automated tool to achieve delivery of the database.

[0066] Specifically, the database environment of the cloud service platform is configured through automated tools, resources are called to run automated deployment scripts to install the database to be delivered and test the operating status of the database to achieve database delivery.

[0067] It can be seen from the above embodiments that by obtaining parameter information before and after the system upgrade, the difference parameters are obtained by comparison, and the database to be delivered is automatically selected and generated through the selection algorithm model according to the characteristic parameters of multiple databases to be delivered and the characteristic parameters of the insurance business. The database to be delivered is configured through an automated tool to realize the delivery of the database. There is no need for manual selection of the database, which saves the process of manual selection and testing and improves the efficiency of database selection and delivery.

[0068] In one embodiment of the present application, step S204 includes:

[0069] S2041: Generate an estimated data volume of the insurance business based on the insurance business characteristic parameters.

[0070] Specifically, the business term of the insurance business is set, and the estimated data volume generated by the insurance business within the set business term is calculated based on the business term.

[0071] S2042: Determine the data size of the estimated data volume.

[0072] Specifically, it is determined whether the estimated data volume exceeds a threshold value of the total amount of hotspot data.

[0073] S2043: If the data size of the estimated data volume is smaller than a preset data threshold, determining the type of the database to be delivered as a centralized database according to characteristic parameters of the multiple databases to be delivered.

[0074] Specifically, if the data size of the estimated data volume is smaller than a preset data threshold, the data expansion requirements of the insurance business meet the database characteristics of a centralized database, and the types of the multiple databases to be delivered are determined to be centralized databases.

[0075] S2044: Obtain the transaction volume per second of the upgraded system according to the difference parameter.

[0076] In this embodiment, if the transaction volume per second of the upgraded system is less than 857, the ECS 16U type database is selected.

[0077] In this embodiment, if the transaction volume per second of the upgraded system is less than 2625, an ECS 32U type database is selected.

[0078] In this embodiment, if the transaction volume per second of the upgraded system is less than 6250, the database of the BMS X86 architecture is selected.

[0079] In this embodiment, if the transaction volume per second of the upgraded system is less than 8750, the database of the BMS ARM 64U architecture is selected.

[0080] In this embodiment, if the transaction volume per second of the upgraded system is less than 18750, the database of the BMS ARM 128U architecture is selected.

[0081] S2045: Match the centralized database according to the transaction volume per second of the upgraded system to generate a database to be delivered.

[0082] Specifically, the centralized database is configured through an automated tool application to generate a database to be delivered.

[0083] It can be seen from the above embodiments that the estimated data volume of the insurance business is generated by the insurance business characteristic parameters. If the estimated data volume is less than the preset data threshold, a centralized database is used, and the centralized database is matched according to the transaction processing volume per second of the centralized database to generate a database to be delivered. When the data volume does not exceed the data threshold, the centralized database is selected, which improves the consistency of the data and facilitates the maintenance and management of the data in the database.

[0084] In one embodiment of the present application, after step S2042, the method further includes:

[0085] S2046: If the data size of the estimated data volume is greater than a preset data threshold, a business scenario of the upgraded system is obtained.

[0086] In this embodiment, complex business scenarios of the upgraded system include, but are not limited to, using ORACLE as an analytical database, using multiple tables, using a single table with more than 100 million rows of records, and complex stored procedures.

[0087] S2047: If there is no complex business scenario in the business scenario of the upgraded system, determine the type of the database to be delivered as a distributed database based on characteristic parameters of the multiple databases to be delivered.

[0088] Specifically, it is determined that the type of the database to be delivered is a distributed database, and the transaction processing volume per second of the upgraded system is determined.

[0089] In this embodiment, if the transaction volume per second of the upgraded system is less than 857, the ECS 16U type database is selected.

[0090] In this embodiment, if the transaction volume per second of the upgraded system is less than 2625, an ECS 32U type database is selected.

[0091] In this embodiment, if the transaction volume per second of the upgraded system is less than 8750, the database of the BMS X86 architecture is selected.

[0092] In this embodiment, if the transaction volume per second of the upgraded system is less than 11250, the database of the BMS ARM 64U architecture is selected.

[0093] In this embodiment, if the transaction volume per second of the upgraded system is less than 22250, the database of the BMS ARM 128U architecture is selected.

[0094] S2048: If there are complex business scenarios in the business scenarios of the upgraded system, it is determined whether the data size of the estimated data volume can be segmented to a preset segmentation threshold.

[0095] Specifically, determine whether the estimated data size can be divided into database and table sharding to reduce the data to less than 3T.

[0096] S2049: If the data size of the estimated data volume is segmented to a preset segmentation threshold, the type of the database to be delivered is determined to be a centralized database according to characteristic parameters of the multiple databases to be delivered.

[0097] Specifically, if the estimated data size can be segmented to a preset segmentation threshold, the data is segmented by using a database and table segmentation method, and a centralized database is used to store the data.

[0098] It can be seen from the above embodiments that by judging the business scenarios of the upgraded business system, if there are no complex business scenarios, a distributed database is selected, and the scalability of the distributed database is used to achieve data expansion when the estimated data volume is large, thereby improving the convenience of data expansion; if there are complex business scenarios and the data size of the estimated data can be divided into a preset segmentation threshold, a centralized database is selected, and the complex business scenarios are stored in the centralized database, thereby improving the convenience of management.

[0099] In one embodiment of the present application, step S205 includes:

[0100] S2051: Configure the database environment of the cloud service platform through automated tools.

[0101] In this embodiment, the cloud service platform includes but is not limited to IaaS (Infrastructure as a Service), PaaS (Platform as a Service) and BaaS (Backend as a Service).

[0102] In this embodiment, the database environment includes but is not limited to a hardware server, an operating system, and a database network.

[0103] S2052: Call the resources of the cloud service platform and run the automated deployment script in the database environment of the cloud service platform to install the database to be delivered.

[0104] Specifically, run the automated deployment script, configure system parameters at the server level, install supporting tools, and configure the cluster to install the database to be delivered.

[0105] S2053: Test the running status of the database to be delivered to determine whether the database to be delivered runs normally.

[0106] Specifically, a business scenario is simulated in the upgraded system to test the operating status of the database to be delivered to determine whether the database to be delivered is running normally.

[0107] S2054: If the database to be delivered runs normally, the database is delivered.

[0108] In this embodiment, the operation status of the database is determined by a set threshold value of the number of database error reports.

[0109] Specifically, if the database exceeds a preset upper limit of an error threshold during the simulation operation, it is determined that the database to be delivered does not meet the business requirements.

[0110] From the above embodiments, it can be seen that the database environment of the cloud service platform is configured using automated tools, resources are called to run automated deployment scripts, the database to be delivered is installed, and the operating status of the database is tested. There is no need to manually test the operating status of the database, which improves the efficiency of delivery.

[0111] Figure 3 The schematic diagram of the structure of the database selection delivery processing device provided for this application is as follows: Figure 3 As shown, the database selection delivery processing device 30 provided in this embodiment includes: a first acquisition module 301, a second acquisition module 302, a third acquisition module 303, a generation module 304 and a configuration module 305.

[0112] The first acquisition module 301 is used to acquire parameter information of the system before upgrading.

[0113] The second acquisition module 302 is used to acquire parameter information of the upgraded system, and obtain difference parameters according to the parameter information of the system before the upgrade and the parameter information of the system after the upgrade.

[0114] The third acquisition module 303 is used to acquire characteristic parameters of multiple databases to be delivered and characteristic parameters of insurance services.

[0115] The generation module 304 is used to generate a database to be delivered according to the characteristic parameters of multiple databases to be delivered, insurance business characteristic parameters and difference parameters through a selection algorithm model.

[0116] The configuration module 305 is used to configure the database to be delivered through an automated tool to achieve the delivery of the database.

[0117] In a possible implementation, the generating module 304 includes:

[0118] The generating unit 3041 is used to generate the estimated data volume of the insurance business according to the characteristic parameters of the insurance business.

[0119] The first determination unit 3042 is used to determine the data size of the estimated data volume.

[0120] The first determining unit 3043 is configured to determine that the type of the database to be delivered is a centralized database according to characteristic parameters of the multiple databases to be delivered if the data size of the estimated data volume is less than a preset data threshold.

[0121] The first acquisition unit 3044 is used to acquire the transaction processing volume per second of the upgraded system according to the difference parameter.

[0122] The matching unit 3045 is used to match the centralized database according to the transaction processing volume per second of the upgraded system to generate a database to be delivered.

[0123] In a possible implementation, the generating module 304 further includes:

[0124] The second acquisition unit 3046 is used to acquire the business scenario of the upgraded system if the data size of the estimated data volume is greater than a preset data threshold.

[0125] The second determining unit 3047 is configured to determine that the type of the database to be delivered is a distributed database according to characteristic parameters of the multiple databases to be delivered if there is no complex business scenario in the business scenario of the upgraded system.

[0126] The second judgment unit 3048 is used to judge whether the data size of the estimated data volume can be divided into a preset segmentation threshold if there is a complex business scenario in the business scenario of the upgraded system.

[0127] The third determining unit 3049 is configured to determine that the type of the database to be delivered is a centralized database according to characteristic parameters of the multiple databases to be delivered if the data size of the estimated data volume is segmented to a preset segmentation threshold.

[0128] In a possible implementation, the selection algorithm model in the generation module 304 is:

[0129]

[0130] In the formula, Represents the database to be delivered; represents the parameter information of the upgraded system; α(a, b, c) represents the product difference value; Indicates the server difference value; Represents the actual information of the existing system database or server; It indicates the parameter information of the system before upgrading; h(z) indicates the selection function.

[0131] In a possible implementation, the configuration module 305 includes:

[0132] The configuration unit 3051 is used to configure the database environment of the cloud service platform through an automation tool.

[0133] The calling unit 3052 is used to call the resources of the cloud service platform and run the automated deployment script in the database environment of the cloud service platform to install the database to be delivered.

[0134] The testing unit 3053 is used to test the running status of the database to be delivered to determine whether the database to be delivered runs normally.

[0135] The delivery unit 3054 is used to deliver the database if the database to be delivered runs normally.

[0136] The database selection delivery processing device provided in this embodiment can execute the method provided in the above method embodiment. Its implementation principle and technical effect are similar, and this embodiment will not be described in detail here.

[0137] Figure 4 This is a schematic diagram of the structure of the database selection delivery processing equipment provided for this application. Figure 4 As shown, the database selection delivery processing device 40 provided in this embodiment includes: at least one processor 401 and a memory 402. Optionally, the device 40 also includes a communication component 403. The processor 401, the memory 402 and the communication component 403 are connected via a bus 404.

[0138] In the specific implementation process, at least one processor 401 executes the computer execution instructions stored in the memory 402, so that at least one processor 401 executes the above-mentioned database selection and delivery processing method.

[0139] The specific implementation process of the processor 401 can be found in the above method embodiment, and its implementation principle and technical effect are similar, so this embodiment will not be repeated here.

[0140] In the above embodiments, it should be understood that the processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), etc. A general-purpose processor may be a microprocessor or any conventional processor. The steps of the method disclosed in the invention may be directly implemented as being executed by a hardware processor, or may be executed by a combination of hardware and software modules in the processor.

[0141] The memory may include a high-speed memory (Random Access Memory, RAM), and may also include a non-volatile memory (Non-volatile Memory, NVM), such as at least one disk memory.

[0142] The bus may be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, or an Extended Industry Standard Architecture (EISA) bus, etc. The bus may be divided into an address bus, a data bus, a control bus, etc. For ease of representation, the bus in the drawings of the present application is not limited to only one bus or one type of bus.

[0143] The present application also provides a computer program product, including a computer program, which implements the above-mentioned database selection and delivery processing method when executed by a processor.

[0144] The present application also provides a computer-readable storage medium, in which computer-executable instructions are stored. When a processor executes the computer-executable instructions, the above-mentioned database selection and delivery processing method is implemented.

[0145] The above-mentioned readable storage medium can be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic disk or optical disk. The readable storage medium can be any available medium that can be accessed by a general or special-purpose computer.

[0146] An exemplary readable storage medium is coupled to a processor so that the processor can read information from the readable storage medium and write information to the readable storage medium. Of course, the readable storage medium can also be a component of the processor. The processor and the readable storage medium can be located in an application specific integrated circuit (Application Specific Integrated Circuits, referred to as: ASIC). Of course, the processor and the readable storage medium can also exist in the device as discrete components.

[0147] The division of units is only a logical function division, and there may be other divisions in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some interface, device or unit, which can be electrical, mechanical or other forms.

[0148] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0149] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit.

[0150] If the function is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art, or the part of the technical solution, can be embodied in the form of a software product. The computer software product is stored in a storage medium, including several instructions for a computer device (which can be a personal computer, server, or network device, etc.) to perform all or part of the steps of the methods of each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk, etc. Various media that can store program codes.

[0151] Those skilled in the art can understand that all or part of the steps of implementing the above-mentioned method embodiments can be completed by hardware related to program instructions. The aforementioned program can be stored in a computer-readable storage medium. When the program is executed, the steps of the above-mentioned method embodiments are executed; and the aforementioned storage medium includes: ROM, RAM, disk or optical disk and other media that can store program codes.

[0152] Finally, it should be noted that those skilled in the art will readily conceive of other embodiments of the present invention after considering the specification and practicing the invention disclosed herein. The present invention is intended to cover any variations, uses or adaptations of the present invention, which follow the general principles of the present invention and include common knowledge or customary technical means in the art not disclosed by the present invention, are not limited to the precise structure described above and shown in the drawings, and may be modified and changed in various ways without departing from the scope thereof. The scope of the present invention is limited only by the appended claims.

Claims

1. A database selection and delivery processing method, characterized in that: Applicable to computer equipment, including: Get the parameter information of the system before upgrading; Acquire parameter information of the upgraded system, and obtain difference parameters according to the parameter information of the system before the upgrade and the parameter information of the upgraded system; Obtain characteristic parameters of multiple databases to be delivered and characteristic parameters of insurance business; Generate a database to be delivered according to the characteristic parameters of the plurality of databases to be delivered, the insurance business characteristic parameters and the difference parameters through a selection algorithm model; The database to be delivered is configured through an automated tool to achieve delivery of the database.

2. The method according to claim 1, characterized in that The step of generating the database to be delivered according to the characteristic parameters of the plurality of databases to be delivered, the insurance business characteristic parameters and the difference parameters through the selection algorithm model includes: generating an estimated data volume of insurance business according to the insurance business characteristic parameters; Determining the data size of the estimated data volume; If the data size of the estimated data volume is less than a preset data threshold, determining the type of the database to be delivered as a centralized database according to the characteristic parameters of the multiple databases to be delivered; Obtaining the transaction volume per second of the upgraded system according to the difference parameter; The centralized database is matched according to the transaction processing volume per second of the upgraded system to generate a database to be delivered.

3. The method according to claim 2, characterized in that After determining the size of the estimated data volume, the method further includes: If the data size of the estimated data volume is greater than a preset data threshold, obtaining a business scenario of the upgraded system; If there is no complex business scenario in the business scenario of the upgraded system, determining that the type of the database to be delivered is a distributed database according to the characteristic parameters of the multiple databases to be delivered; If there are complex business scenarios in the business scenarios of the upgraded system, determining whether the data size of the estimated data volume can be segmented to a preset segmentation threshold; If the data size of the estimated data volume is segmented to a preset segmentation threshold, the type of the database to be delivered is determined to be a centralized database according to the characteristic parameters of the multiple databases to be delivered.

4. The method according to claim 1, characterized in that: The selection algorithm model is: In the formula, Represents the database to be delivered; represents the parameter information of the upgraded system; α(a, b, c) represents the product difference value; Indicates the server difference value; Represents the actual information of the existing system database or server; It indicates the parameter information of the system before upgrading; h(z) indicates the selection function.

5. The method according to any one of claims 1 to 4, characterized in that: The step of configuring the database to be delivered by using an automated tool to achieve delivery of the database includes: Configuring the database environment of the cloud service platform through the automation tool; Invoke resources of the cloud service platform and run an automated deployment script in the database environment of the cloud service platform to install the database to be delivered; Testing the running status of the database to be delivered to determine whether the database to be delivered is running normally; If the database to be delivered runs normally, the delivery of the database is realized.

6. A database selection delivery processing device, characterized in that: Applicable to computer equipment, including: A first acquisition module is used to acquire parameter information of the system before upgrading; A second acquisition module is used to acquire parameter information of the upgraded system, and obtain difference parameters according to the parameter information of the system before the upgrade and the parameter information of the upgraded system; A third acquisition module is used to acquire characteristic parameters of multiple databases to be delivered and characteristic parameters of insurance business; A generation module, used for generating a database to be delivered according to the characteristic parameters of the plurality of databases to be delivered, the insurance business characteristic parameters and the difference parameters through a selection algorithm model; The configuration module is used to configure the database to be delivered through an automated tool to achieve the delivery of the database.

7. The device according to claim 6, characterized in that The generating module comprises: A generating unit, used for generating an estimated data volume of the insurance business according to the insurance business characteristic parameters; A first determination unit, configured to determine the size of the estimated data volume; A first determining unit, configured to determine, if the data size of the estimated data volume is less than a preset data threshold, that the type of the database to be delivered is a centralized database according to characteristic parameters of the multiple databases to be delivered; A first acquisition unit, configured to acquire the transaction processing volume per second of the upgraded system according to the difference parameter; A matching unit is used to match the centralized database according to the transaction processing volume per second of the upgraded system to generate a database to be delivered.

8. A database selection delivery processing device, characterized in that: include: at least one processor and memory; The memory stores computer-executable instructions; The at least one processor executes the computer-executable instructions stored in the memory, so that the at least one processor executes the database selection and delivery processing method as described in any one of claims 1 to 5.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer-executable instructions, which, when executed by a processor, are used to implement the database selection and delivery processing method according to any one of claims 1 to 5.

10. A computer program product, characterized in that It includes a computer program, which, when executed by a processor, implements the database selection and delivery processing method described in any one of claims 1 to 5.

Images