CN113420010B - Database management method, device, electronic equipment and storage medium - Google Patents
Database management method, device, electronic equipment and storage mediumDownload PDFInfo
- Publication number
- CN113420010B CN113420010BCN202110697819.8ACN202110697819ACN113420010BCN 113420010 BCN113420010 BCN 113420010BCN 202110697819 ACN202110697819 ACN 202110697819ACN 113420010 BCN113420010 BCN 113420010B
- Authority
- CN
- China
- Prior art keywords
- database
- upgrade
- test
- file
- version identifier
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/219—Managing data history or versioning
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Prevention of errors by analysis, debugging or testing of software
- G06F11/3668—Testing of software
- G06F11/3672—Test management
- G06F11/3688—Test management for test execution, e.g. scheduling of test suites
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Prevention of errors by analysis, debugging or testing of software
- G06F11/3698—Environments for analysis, debugging or testing of software
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/60—Software deployment
- G06F8/65—Updates
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/70—Software maintenance or management
- G06F8/71—Version control; Configuration management
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Software Systems (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Data Mining & Analysis (AREA)
- Computer Security & Cryptography (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Translated fromChinese技术领域technical field
本发明涉及计算机技术领域，尤其涉及一种数据库的管理方法、装置、电子设备和存储介质。The present invention relates to the field of computer technology, in particular to a database management method, device, electronic equipment and storage medium.
背景技术Background technique
目前数据处理的框架内包括了各功能的组件，各组件均会对应各自的数据库，不同组件在不同的应用环境中也对数据库的版本有不同的需求，所以在对各组件进行测试时，需要确定其对应数据库的版本与测试环境相匹配,进而才能可对组件执行准确的测试。现有技术中，在对组件测试时需要先从数据库的版本和补丁信息中找出所需的有用信息，并登录至对应的数据库服务器中执行数据库版本的更新，以便于与测试的组件相匹配。但是，各组件所对应数据库的类型和版本并不统一，各组件对应数据库的版本和补丁信息非常复杂，所以需要具有一定数据库基础的人员才能执行数据库的版本更新操作，不仅花费工作人员的操作时间，还提高了操作成本。The current data processing framework includes components of various functions, and each component will correspond to its own database. Different components also have different requirements for database versions in different application environments, so when testing each component, you need Make sure that the version of the corresponding database matches the test environment, so that the components can be accurately tested. In the prior art, when testing components, it is necessary to find out the required useful information from the version and patch information of the database, and log in to the corresponding database server to update the database version so as to match the tested components . However, the types and versions of the databases corresponding to each component are not uniform, and the version and patch information of the database corresponding to each component is very complicated. Therefore, personnel with a certain database foundation are required to perform the database version update operation, which not only costs the staff's operating time , also increased operating costs.
发明内容Contents of the invention
有鉴于此，本发明实施例提供一种数据库的管理方法、装置、电子设备和存储介质，能够解决现有技术中数据库的版本更新需要具有一定数据库基础的人员才能执行，不仅花费工作人员的操作时间，还提高了操作成本的问题。In view of this, the embodiment of the present invention provides a database management method, device, electronic equipment, and storage medium, which can solve the problem that the version update of the database in the prior art requires personnel with a certain database foundation to perform, which not only costs the staff's operation time, and also raised the issue of operating costs.
为实现上述目的，根据本发明实施例的一个方面，提供了一种数据库的管理方法。To achieve the above purpose, according to an aspect of the embodiments of the present invention, a database management method is provided.
本发明实施例的一种数据库的管理方法包括：获取测试环境和测试组件，以查询所述测试组件在所述测试环境下对应数据库的目标版本标识；获取所述测试组件对应数据库的当前版本标识，以判断是否为所述目标版本标识；若是，则不对所述测试组件对应的数据库执行操作；若否，则调用纳管平台接口，向纳管平台发送所述目标版本标识，以使所述纳管平台获取所述目标版本标识对应的数据库文件，进而对所述数据库文件执行校验，在校验通过后基于所述数据库文件升级所述测试组件对应的数据库，以基于升级后的数据库，对所述测试组件在所述测试环境下执行测试。A database management method according to an embodiment of the present invention includes: obtaining a test environment and a test component to query the target version identifier of the database corresponding to the test component in the test environment; obtaining the current version identifier of the database corresponding to the test component , to determine whether it is the target version identifier; if so, do not perform operations on the database corresponding to the test component; if not, call the management platform interface, and send the target version identifier to the management platform, so that the The management platform obtains the database file corresponding to the target version identifier, and then performs verification on the database file, and upgrades the database corresponding to the test component based on the database file after the verification is passed, so that based on the upgraded database, A test is performed on the test component under the test environment.
在一个实施例中，在对所述数据库文件执行校验之前，还包括：In one embodiment, before performing verification on the database file, it also includes:
查询所述测试组件对应数据库所在服务端的地址信息，基于所述地址信息将所述数据库文件发送至数据库服务端，以使所述数据库服务端对所述数据库文件执行校验，以及基于所述数据库文件升级所述测试组件对应的数据库。Querying the address information of the server where the database corresponding to the test component is located, sending the database file to the database server based on the address information, so that the database server performs verification on the database file, and based on the database The file upgrades the database corresponding to the test component.
在又一个实施例中，所述基于所述数据库文件升级所述测试组件对应的数据库，包括：In yet another embodiment, the upgrading the database corresponding to the test component based on the database file includes:
查询所述数据库服务端中所述测试组件对应数据库的版本标识，以判断是否为所述当前版本标识；Querying the version identifier of the database corresponding to the test component in the database server to determine whether it is the current version identifier;
若是，则基于所述数据库文件升级所述测试组件对应的数据库；若否，则返回包括所述版本标识的提示消息，并基于所述数据库文件升级所述测试组件对应的数据库。If yes, upgrade the database corresponding to the test component based on the database file; if not, return a prompt message including the version identifier, and upgrade the database corresponding to the test component based on the database file.
在又一个实施例中，所述调用纳管平台接口之后，还包括：In yet another embodiment, after calling the management platform interface, it also includes:
接收所述版本标识的提示消息，获取所述提示信息中的版本标识，以从数据库升级记录中查询是否存储了所述版本标识对应的数据库升级记录；Receive the prompt message of the version identifier, acquire the version identifier in the prompt information, and query whether the database upgrade record corresponding to the version identifier is stored from the database upgrade record;
若是，则忽略所述提示消息；若否，则生成所述版本标识对应的升级记录并存储。If yes, the prompt message is ignored; if not, an upgrade record corresponding to the version identifier is generated and stored.
在又一个实施例中，所述调用纳管平台接口之后，还包括：In yet another embodiment, after calling the management platform interface, it also includes:
接收所述数据库服务端发送的数据库升级结果，以生成对应的数据库升级记录；receiving the database upgrade result sent by the database server to generate a corresponding database upgrade record;
显示所述数据库升级记录。Display the database upgrade record.
在又一个实施例中，基于所述地址信息将所述数据库文件发送至数据库服务端，包括：In yet another embodiment, sending the database file to the database server based on the address information includes:
查询所述地址信息对应的路由表，以获取所述地址信息对应中转网关的地址，进而基于所述中转网关的地址，向所述中转网关发送所述地址信息和所述数据库文件，以使所述中转网关基于所述地址信息发送所述数据库文件。Querying the routing table corresponding to the address information to obtain the address of the transit gateway corresponding to the address information, and then based on the address of the transit gateway, sending the address information and the database file to the transit gateway, so that all The transit gateway sends the database file based on the address information.
在又一个实施例中，对所述数据库文件执行校验，包括：In yet another embodiment, performing verification on the database file includes:
从所述数据库文件中获取数据库文件标识，以生成对应的第一校验值，查询所述数据库的数据库标识，以结合所述目标版本标识生成对应的第二校验值；Obtaining a database file identifier from the database file to generate a corresponding first check value, and querying the database identifier of the database to generate a corresponding second check value in combination with the target version identifier;
判断所述第一校验值和所述第二校验值是否一致；judging whether the first check value is consistent with the second check value;
若是，则确定所述数据库文件校验成功；若否，则确定所述数据库文件校验失败。If yes, it is determined that the verification of the database file is successful; if not, it is determined that the verification of the database file fails.
在又一个实施例中，所述获取测试环境和测试组件，包括：In yet another embodiment, the acquisition of test environment and test components includes:
接收用户输入的升级请求，所述升级请求包括所述测试环境和所述测试组件；receiving an upgrade request input by a user, where the upgrade request includes the test environment and the test components;
发送所述升级请求对应的审批提示信息，以提示对所述升级请求进行审批；Sending approval prompt information corresponding to the upgrade request to prompt approval of the upgrade request;
接收所述升级请求对应审批结果，确定所述审批结果为审批通过后获取所述升级请求中所述测试环境和所述测试组件。The test environment and the test components in the upgrade request are acquired after receiving an approval result corresponding to the upgrade request, and determining that the approval result is approved.
为实现上述目的，根据本发明实施例的另一方面，提供了一种数据库的管理装置。To achieve the above purpose, according to another aspect of the embodiments of the present invention, a database management device is provided.
本发明实施例的一种数据库的管理装置包括：获取单元，用于获取测试环境和测试组件，以查询所述测试组件在所述测试环境下对应数据库的目标版本标识；升级单元，用于获取所述测试组件对应数据库的当前版本标识，以判断是否为所述目标版本标识；若是，则不对所述测试组件对应的数据库执行操作；若否，则调用纳管平台接口，向纳管平台发送所述目标版本标识，以使所述纳管平台基于所述目标版本标识获取对应的数据库文件，进而对所述数据库文件执行校验，在校验通过后基于所述数据库文件升级所述测试组件对应的数据库，以基于升级后的数据库，对所述测试组件在所述测试环境下执行测试。A management device for a database according to an embodiment of the present invention includes: an acquisition unit, configured to acquire a test environment and a test component, to query the target version identifier of the database corresponding to the test component in the test environment; an upgrade unit, configured to acquire The current version identification of the corresponding database of the test component to determine whether it is the target version identification; if so, do not perform operations on the database corresponding to the test component; if not, then call the management platform interface and send it to the management platform The target version identifier, so that the management platform obtains the corresponding database file based on the target version identifier, and then performs verification on the database file, and upgrades the test component based on the database file after the verification is passed The corresponding database is used to execute the test on the test component in the test environment based on the upgraded database.
在一个实施例中，所述升级单元，具体用于：In one embodiment, the upgrading unit is specifically used for:
查询所述测试组件对应数据库所在服务端的地址信息，基于所述地址信息将所述数据库文件发送至数据库服务端，以使所述数据库服务端对所述数据库文件执行校验，以及基于所述数据库文件升级所述测试组件对应的数据库。Querying the address information of the server where the database corresponding to the test component is located, sending the database file to the database server based on the address information, so that the database server performs verification on the database file, and based on the database The file upgrades the database corresponding to the test component.
在又一个实施例中，所述升级单元，具体用于：In yet another embodiment, the upgrading unit is specifically used for:
查询所述数据库服务端中所述测试组件对应数据库的版本标识，以判断是否为所述当前版本标识；Querying the version identifier of the database corresponding to the test component in the database server to determine whether it is the current version identifier;
若是，则基于所述数据库文件升级所述测试组件对应的数据库；若否，则返回包括所述版本标识的提示消息，并基于所述数据库文件升级所述测试组件对应的数据库。If yes, upgrade the database corresponding to the test component based on the database file; if not, return a prompt message including the version identifier, and upgrade the database corresponding to the test component based on the database file.
在又一个实施例中，所述装置还包括：In yet another embodiment, the device further includes:
接收单元，用于接收所述版本标识的提示消息，获取所述提示信息中的版本标识，以从数据库升级记录中查询是否存储了所述版本标识对应的数据库升级记录；The receiving unit is configured to receive a prompt message of the version identifier, acquire the version identifier in the prompt information, and query from the database upgrade record whether the database upgrade record corresponding to the version identifier is stored;
生成单元，用于若是，则忽略所述提示消息；若否，则生成所述版本标识对应的升级记录并存储。The generating unit is configured to ignore the prompt message if yes, and generate and store an upgrade record corresponding to the version identifier if no.
在又一个实施例中，所述升级单元，还用于：In yet another embodiment, the upgrading unit is also used for:
接收所述数据库服务端发送的数据库升级结果，以生成对应的数据库升级记录；receiving the database upgrade result sent by the database server to generate a corresponding database upgrade record;
显示所述数据库升级记录。Display the database upgrade record.
在又一个实施例中，所述升级单元，具体用于：In yet another embodiment, the upgrading unit is specifically used for:
查询所述地址信息对应的路由表，以获取所述地址信息对应中转网关的地址，进而基于所述中转网关的地址，向所述中转网关发送所述地址信息和所述数据库文件，以使所述中转网关基于所述地址信息发送所述数据库文件。Querying the routing table corresponding to the address information to obtain the address of the transit gateway corresponding to the address information, and then based on the address of the transit gateway, sending the address information and the database file to the transit gateway, so that all The transit gateway sends the database file based on the address information.
在又一个实施例中，所述升级单元，具体用于：In yet another embodiment, the upgrading unit is specifically used for:
从所述数据库文件中获取数据库文件标识，以生成对应的第一校验值，查询所述数据库的数据库标识，以结合所述目标版本标识生成对应的第二校验值；Obtaining a database file identifier from the database file to generate a corresponding first check value, and querying the database identifier of the database to generate a corresponding second check value in combination with the target version identifier;
判断所述第一校验值和所述第二校验值是否一致；judging whether the first check value is consistent with the second check value;
若是，则确定所述数据库文件校验成功；若否，则确定所述数据库文件校验失败If so, it is determined that the database file verification is successful; if not, it is determined that the database file verification fails
在又一个实施例中，所述获取单元，具体用于：In yet another embodiment, the acquisition unit is specifically configured to:
接收用户输入的升级请求，所述升级请求包括所述测试环境和所述测试组件；receiving an upgrade request input by a user, where the upgrade request includes the test environment and the test components;
发送所述升级请求对应的审批提示信息，以提示对所述升级请求进行审批；Sending approval prompt information corresponding to the upgrade request to prompt approval of the upgrade request;
接收所述升级请求对应审批结果，确定所述审批结果为审批通过后获取所述升级请求中所述测试环境和所述测试组件。The test environment and the test components in the upgrade request are acquired after receiving an approval result corresponding to the upgrade request, and determining that the approval result is approved.
为实现上述目的，根据本发明实施例的再一个方面，提供了一种电子设备。To achieve the above purpose, according to still another aspect of the embodiments of the present invention, an electronic device is provided.
本发明实施例的一种电子设备，包括：一个或多个处理器；存储装置，用于存储一个或多个程序，当所述一个或多个程序被所述一个或多个处理器执行，使得所述一个或多个处理器实现本发明实施例提供的数据库的管理方法。An electronic device according to an embodiment of the present invention includes: one or more processors; a storage device configured to store one or more programs, and when the one or more programs are executed by the one or more processors, The one or more processors are made to implement the database management method provided by the embodiment of the present invention.
为实现上述目的，根据本发明实施例的又一个方面，提供了一种计算机可读介质。To achieve the above purpose, according to still another aspect of the embodiments of the present invention, a computer-readable medium is provided.
本发明实施例的一种计算机可读介质，其上存储有计算机程序，所述程序被处理器执行时实现本发明实施例提供的数据库的管理方法。A computer-readable medium according to an embodiment of the present invention stores a computer program thereon, and when the program is executed by a processor, the database management method provided by the embodiment of the present invention is implemented.
上述发明中的一个实施例具有如下优点或有益效果：本发明实施例中，数据库的版本管控平台可以获取测试组件和测试环境，以查询出测试组件在测试环境下数据库所需要的版本，即目标版本标识；然后可以查询出测试组件对应数据库的当前版本标识，以通过判断当前版本标识是否为目标版本标识，来确定数据库的版本是否为测试组件在测试环境下所需的版本；如果是，则可以不对数据库进行处理；如果不是，则需要对数据库的版本升级，即调用纳管平台接口，向纳管平台发送目标版本标识，从而可以使纳管平台基于目标版本标识获取对应的数据库文件，进而对数据库文件执行校验，在校验通过后基于数据库文件升级测试组件对应的数据库，即实现将数据库升级为目标版本标识对应的版本。如此本发明实施例中，版本管控平台可以通过调用纳管平台来实现数据库的升级管理，而无需工作人员操作，所以不需要具有一定数据库基础的人员才能执行数据库的版本更新，从而可以降低数据库的管理和操作成本，节省工作人员的操作时间。An embodiment of the above invention has the following advantages or beneficial effects: In the embodiment of the present invention, the version management and control platform of the database can obtain the test component and the test environment, so as to query the version required by the database of the test component in the test environment, that is, the target version identification; then the current version identification of the corresponding database of the test component can be queried to determine whether the version of the database is the required version of the test component in the test environment by judging whether the current version identification is the target version identification; if yes, then The database may not be processed; if not, the version of the database needs to be upgraded, that is, the management platform interface is called to send the target version identification to the management platform, so that the management platform can obtain the corresponding database file based on the target version identification, and then Perform verification on the database file, and upgrade the database corresponding to the test component based on the database file after the verification is passed, that is, upgrade the database to the version corresponding to the target version identifier. In this embodiment of the present invention, the version management and control platform can realize the upgrade management of the database by calling the management platform without the need for staff to operate, so it is not necessary for personnel with a certain database foundation to perform the version update of the database, thereby reducing the cost of the database. Management and operating costs, saving staff operating time.
上述的非惯用的可选方式所具有的进一步效果将在下文中结合具体实施方式加以说明。The further effects of the above-mentioned non-conventional alternatives will be described below in conjunction with specific embodiments.
附图说明Description of drawings
附图用于更好地理解本发明，不构成对本发明的不当限定。其中：The accompanying drawings are used to better understand the present invention, and do not constitute improper limitations to the present invention. in:
图1是根据本发明实施例的数据库的管理方法的一种主要流程的示意图；FIG. 1 is a schematic diagram of a main flow of a database management method according to an embodiment of the present invention;
图2是根据本发明实施例的数据库的管理方法的又一种主要流程的示意图；FIG. 2 is a schematic diagram of another main flow of a database management method according to an embodiment of the present invention;
图3是根据本发明实施例的数据库的管理装置的主要单元的示意图；FIG. 3 is a schematic diagram of main units of a database management device according to an embodiment of the present invention;
图4是本发明实施例可以应用于其中的一种示例性系统架构图；FIG. 4 is an exemplary system architecture diagram to which an embodiment of the present invention can be applied;
图5是适于用来实现本发明实施例的计算机系统的结构示意图。FIG. 5 is a schematic structural diagram of a computer system suitable for implementing an embodiment of the present invention.
具体实施方式Detailed ways
以下结合附图对本发明的示范性实施例做出说明，其中包括本发明实施例的各种细节以助于理解，应当将它们认为仅仅是示范性的。因此，本领域普通技术人员应当认识到，可以对这里描述的实施例做出各种改变和修改，而不会背离本发明的范围和精神。同样，为了清楚和简明，以下的描述中省略了对公知功能和结构的描述。Exemplary embodiments of the present invention are described below in conjunction with the accompanying drawings, which include various details of the embodiments of the present invention to facilitate understanding, and they should be regarded as exemplary only. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.
需要指出的是，在不冲突的情况下，本发明中的实施例以及实施例中的特征可以互相组合。It should be noted that, in the case of no conflict, the embodiments of the present invention and the features in the embodiments can be combined with each other.
本发明实施例提供一种数据库的管理系统，该系统可以用于对数据处理框架中各组件所对应数据库管理的场景，具体的，可以对数据库版本的升级管理。The embodiment of the present invention provides a database management system, which can be used in the scene of database management corresponding to each component in the data processing framework, specifically, can upgrade and manage the database version.
本发明实施例中，可以设置数据库的版本管控平台和纳管平台。版本管控平台中可以存储各数据库的升级和版本信息，例如数据库的当前版本标识，数据库的升级记录等等。用户可以通过登录版本管控平台查询各数据库的版本信息和升级信息，进而可以向版本管控平台输入数据库升级指令、或者对数据库的版本信息和升级信息的操作指令等等。纳管平台可以存储各数据库对应不同版本的脚本，所以可以为数据库的升级提供所需的文件。纳管平台还可以执行对数据库的升级，具体的，数据库服务端为数据库所位于的服务器，一方面纳管平台可以与数据库服务端共同设置，则纳管平台在确定出数据库所需文件后可以直接对数据库执行升级操作，另一方面纳管平台可以与数据库服务端独立设置，则其在确定数据库升级的文件后，可以将文件发送至数据库服务端，进而使数据库服务端执行数据库的升级操作。本发明实施例中，版本管控平台和纳管平台可以相互通信，从而可以实现版本管控平台调用纳管平台，以确定数据库升级所需的文件，进而执行数据库升级。另外，在纳管平台与数据库服务端独立设置时，数据库服务端可以与版本管控平台进行通信，以将升级结果返回至版本管控平台，以便于版本管控平台存储数据库的升级信息。In the embodiment of the present invention, a database version control platform and a management platform can be set. The upgrade and version information of each database can be stored in the version control platform, such as the current version identifier of the database, the upgrade record of the database, and the like. Users can log in to the version management and control platform to query the version information and upgrade information of each database, and then can input database upgrade instructions, or operation instructions on the version information and upgrade information of the database, etc. to the version management and control platform. The management platform can store scripts corresponding to different versions of each database, so it can provide the required files for database upgrades. The management platform can also perform database upgrades. Specifically, the database server is the server where the database is located. On the one hand, the management platform can be set together with the database server. After the management platform determines the files required by the database, it can Perform the upgrade operation directly on the database. On the other hand, the management platform can be set independently from the database server. After determining the database upgrade file, it can send the file to the database server, and then make the database server perform the database upgrade operation. . In the embodiment of the present invention, the version management and control platform and the management platform can communicate with each other, so that the version management and control platform can call the management platform to determine the files required for database upgrade, and then execute the database upgrade. In addition, when the management platform and the database server are set independently, the database server can communicate with the version management and control platform to return the upgrade result to the version management and control platform, so that the version management and control platform can store the upgrade information of the database.
本发明实施例提供了一种数据库的管理方法，该方法可由版本管控平台执行，如图1所示，该方法包括：The embodiment of the present invention provides a database management method, the method can be executed by the version control platform, as shown in Figure 1, the method includes:
S101：获取测试环境和测试组件，以查询测试组件在测试环境下对应数据库的目标版本标识。S101: Obtain a test environment and a test component to query the target version identifier of the database corresponding to the test component in the test environment.
其中，本发明实施例中数据库的升级为了满足对应组件的测试所需，所以可以先获取测试环境和测试组件，以查询测试组件在测试环境下对应数据库的目标版本标识。Wherein, the upgrade of the database in the embodiment of the present invention satisfies the testing requirements of the corresponding components, so the test environment and the test components can be obtained first, so as to query the target version identifier of the database corresponding to the test component in the test environment.
测试组件表示需要进行测试的组件。测试环境表示组件的运行环境，例如，流水线环境、版本检验环境、开发环境等等，进一步有可能同一测试环境在不同时间所需数据库的版本也不相同，所以此时测试环境还可以表示某时间内组件的运行环境。目标版本标识为测试组件在测试环境下所需的数据库版本标识。A test component represents a component that needs to be tested. The test environment represents the operating environment of the component, such as the pipeline environment, version inspection environment, development environment, etc. It is further possible that the version of the database required by the same test environment at different times is different, so the test environment can also represent a certain time. The operating environment of the internal components. The target version identifier is the database version identifier required by the test component in the test environment.
由于各测试组件在不同测试环境所需的数据库版本不同，所以本步骤中可以预先存储各组件在不同测试环境所对应数据库版本标识，如此本步骤中可以获取测试环境和测试组件后，直接查询出测试组件在测试环境下对应数据库的目标版本标识。Since the database versions required by each test component in different test environments are different, in this step, the database version identifiers corresponding to each component in different test environments can be stored in advance, so that after obtaining the test environment and test components in this step, you can directly query The test component corresponds to the target version identification of the database in the test environment.
本发明实施例中，版本管控平台可以接收用户输入的指令，所以本步骤中获取测试组件和测试环境可以为从用户输入的升级请求中获取的。具体的，本步骤中获取测试环境和测试组件可以执行为：接收用户输入的升级请求，升级请求包括测试环境和测试组件；发送升级请求对应的审批提示信息，以提示对升级请求进行审批；接收升级请求对应审批结果，确定审批结果为审批通过后获取升级请求中测试环境和测试组件。In the embodiment of the present invention, the version management and control platform can receive instructions input by the user, so the acquisition of the test component and the test environment in this step can be obtained from the upgrade request input by the user. Specifically, obtaining the test environment and test components in this step can be performed as follows: receiving the upgrade request input by the user, the upgrade request includes the test environment and test components; sending the approval prompt information corresponding to the upgrade request to prompt the approval of the upgrade request; receiving The upgrade request corresponds to the approval result, and the approval result is determined to be the test environment and test components in the upgrade request obtained after the approval is passed.
本发明实施例中，为了提高数据库升级的准确性，对数据库升级的各操作过程可以先申请审批，即在接收升级请求后可以发送升级请求对应的审批提示信息，以提示数据库管理员(DBA)对升级请求进行审批，并在审批通过后在执行本步骤，即确定审批结果为审批通过后获取升级请求中测试环境和测试组件。In the embodiment of the present invention, in order to improve the accuracy of the database upgrade, each operation process of the database upgrade can first apply for approval, that is, after receiving the upgrade request, the approval prompt information corresponding to the upgrade request can be sent to prompt the database administrator (DBA) The upgrade request is approved, and this step is executed after the approval is passed, that is, the test environment and test components in the upgrade request are obtained after the approval result is determined to be approved.
需要说明的是，本发明实施例中，数据库管理员可以登录版本控制平台对升级申请进行审批，版本控制平台在接收升级请求后，可以向数据库管理员发送升级请求对应的审批提示信息。It should be noted that, in the embodiment of the present invention, the database administrator can log in to the version control platform to approve the upgrade application, and the version control platform can send approval prompt information corresponding to the upgrade request to the database administrator after receiving the upgrade request.
S102：获取测试组件对应数据库的当前版本标识，以判断是否为目标版本标识。S102: Obtain the current version identifier of the database corresponding to the test component to determine whether it is the target version identifier.
其中，版本控制平台中可以对各数据库的信息进行存储，例如数据库的当前版本标识，本步骤中可以获取到测试组件对应数据库的当前版本标识，进而判断其是否为目标版本标识，即判断数据库的当前版本是否为测试组件在测试环境下所需的目标版本。Among them, the information of each database can be stored in the version control platform, such as the current version identification of the database. In this step, the current version identification of the database corresponding to the test component can be obtained, and then it can be judged whether it is the target version identification, that is, the identification of the database can be judged. Whether the current version is the target version required by the test component in the test environment.
S103：若是，则不对测试组件对应的数据库执行操作；若否，则调用纳管平台接口，向纳管平台发送目标版本标识，以使纳管平台获取目标版本标识对应的数据库文件，进而对数据库文件执行校验，在校验通过后基于数据库文件升级测试组件对应的数据库，以基于升级后的数据库，对测试组件在测试环境下执行测试。S103: If yes, do not execute the operation on the database corresponding to the test component; if not, call the management platform interface, and send the target version identification to the management platform, so that the management platform can obtain the database file corresponding to the target version identification, and then perform the operation on the database The file is verified, and after the verification is passed, the database corresponding to the test component is upgraded based on the database file, so that the test component is tested in the test environment based on the upgraded database.
其中，若是，说明数据库的当前版本标识即为目标版本标识，即测试组件对应的数据库当前的版本即为测试组件在测试环境下所需数据库的版本，则此时可以不对测试组件对应的数据库执行操作。若否，说明数据库的当前版本标识不为目标版本标识，需要对其进行升级，则可以调用纳管平台接口，以通过纳管平台对测试组件对应的数据库进行升级。Wherein, if yes, it means that the current version identifier of the database is the target version identifier, that is, the current version of the database corresponding to the test component is the version of the database required by the test component in the test environment, and then the database corresponding to the test component may not be executed. operate. If not, it means that the current version identifier of the database is not the target version identifier, and it needs to be upgraded, and the management platform interface can be called to upgrade the database corresponding to the test component through the management platform.
具体的，版本管控平台通过调用纳管平台可以将目标版本标识、当前版本标识、数据库标识发送给纳管平台。版本管控平台可以基于测试组件查询出对应的数据库标识。纳管平台被调用后，可以获取目标版本标识对应的数据库文件，并对数据库文件进行校验，进而在校验通过以后基于数据库文件来升级测试组件对应的数据库，从而可以基于升级后的数据库，对测试组件在测试环境下执行测试。Specifically, the version management and control platform can send the target version identifier, the current version identifier, and the database identifier to the management platform by calling the management platform. The version control platform can query the corresponding database identifier based on the test component. After the management platform is called, it can obtain the database file corresponding to the target version identifier, and verify the database file, and then upgrade the database corresponding to the test component based on the database file after the verification is passed, so that based on the upgraded database, Execute the tests on the test components in the test environment.
本发明实施例中，纳管平台可以与数据库服务端独立设置，则在对数据库文件校验之前，纳管平台还可以执行：查询测试组件对应数据库所在服务端的地址信息，基于地址信息将数据库文件发送至数据库服务端，以使数据库服务端对数据库文件执行校验，以及基于数据库文件升级测试组件对应的数据库。In the embodiment of the present invention, the management platform can be set independently from the database server, and before checking the database file, the management platform can also perform: query the address information of the server where the test component corresponds to the database, and based on the address information, the database file Send it to the database server, so that the database server can verify the database file and upgrade the database corresponding to the test component based on the database file.
纳管平台获取数据库文件后，可以将数据库文件发送至数据库服务端，所以可以先查询测试组件对应数据库所在服务端的地址信息，然后基于地址信息将数据库文件发送至数据库服务端，以便于数据库服务端执行对数据库文件执行校验，以及基于数据库文件升级测试组件对应数据库的过程。After the management platform obtains the database file, it can send the database file to the database server, so it can first query the address information of the server where the test component corresponds to the database, and then send the database file to the database server based on the address information, so that the database server can Execute the process of verifying the database file and upgrading the corresponding database of the test component based on the database file.
需要说明的是，本发明实施例中，纳管平台可以通过中转网关与数据库服务端进行通信，纳管平台可以预先存储路由表，其中记录了与数据库服务端之间通信所需中转网关的地址信息，所以纳管平台可以查询数据库服务端的查询地址信息所对应的路由表，以获对应中转网关的地址，进而基于中转网关的地址，向中转网关发送数据库服务端的地址信息和数据库文件，以使中转网关基于数据库服务端的地址信息发送数据库文件。It should be noted that, in the embodiment of the present invention, the management platform can communicate with the database server through the transit gateway, and the management platform can pre-store the routing table, which records the address of the transit gateway required for communication with the database server information, so the management platform can query the routing table corresponding to the query address information of the database server to obtain the address of the corresponding transit gateway, and then send the address information and database files of the database server to the transit gateway based on the address of the transit gateway, so that The transit gateway sends the database file based on the address information of the database server.
本发明实施例中，数据库服务端执行完成对数据库的升级后，其可以向版本控制平台发送数据库升级结果，数据库升级结果中可以包括数据库标识、数据库升级后的版本标识、数据库升级成功或失败等等。版本控制平台接收数据库服务端发送的数据库升级结果，进而可以基于预设格式生成数据库升级记录，并存储和显示此数据库升级记录，以便于用户查看。此时如果数据库升级结果中包括数据库升级成功，则版本控制平台可以将该数据库的当前版本标识更新为数据库升级结果中数据库升级后的版本标识。In the embodiment of the present invention, after the database server completes the upgrade of the database, it can send the database upgrade result to the version control platform. The database upgrade result can include the database identifier, the version identifier after the database upgrade, the success or failure of the database upgrade, etc. wait. The version control platform receives the database upgrade result sent by the database server, and then can generate a database upgrade record based on a preset format, and store and display the database upgrade record for easy viewing by users. At this time, if the database upgrade result includes that the database upgrade is successful, the version control platform may update the current version identifier of the database to the upgraded version identifier of the database in the database upgrade result.
版本管控平台生成数据库升级记录后，还可以先查询是否存储了与此记录相同的数据库升级记录，若是，则不再对其进行存储和显示；若否，则对其进行存储和显示，以避免数据库升级记录重复存储。版本管控平台中还可对每个数据库对应数据库升级记录的存储和显示数量进行限制，例如可以设置存储最新的50个数据库升级记录,显示最新的10个数据库升级记录。After the version control platform generates the database upgrade record, it can first query whether the same database upgrade record as this record is stored, if so, it will no longer be stored and displayed; if not, it will be stored and displayed to avoid Database upgrade records are stored repeatedly. The version control platform can also limit the number of storage and display of database upgrade records corresponding to each database. For example, it can be set to store the latest 50 database upgrade records and display the latest 10 database upgrade records.
需要说明的是，由于数据库服务端有可能会自行对数据库升级，此时并不会向版本控制平台发送数据库升级结果，即版本控制平台中数据库的当前版本标识和数据库升级记录并不一定准确，所以数据库服务端在对数据库升级时还可以预先对数据库当前版本进行判断，具体可以执行为：查询数据库服务端中测试组件对应数据库的版本标识，以判断是否为当前版本标识；若是，则基于数据库文件升级测试组件对应的数据库；若否，则返回包括版本标识的提示消息，并基于数据库文件升级测试组件对应的数据库。数据库服务端中测试组件对应数据库的版本标识为当前版本标识，说明数据库服务端中未自行升级数据库，则可以基于数据库文件升级测试组件对应的数据库；数据库服务端中测试组件对应数据库的版本标识不为当前版本标识，说明数据库服务端中自行升级数据库，则需要向版本控制平台返回包括版本标识的提示消息，再基于数据库文件升级测试组件对应的数据库，版本控制平台接收数据库服务端返回的包括版本标识的提示消息后，可以生成对应的数据升级记录并存储和显示，以将此数据库版本更新为提示信息中的版本标识，以保证数据库升级信息和版本信息的准确性。It should be noted that since the database server may upgrade the database by itself, it will not send the database upgrade result to the version control platform at this time, that is, the current version identification and database upgrade records of the database in the version control platform are not necessarily accurate. Therefore, the database server can also judge the current version of the database in advance when upgrading the database. Specifically, it can be executed as follows: query the version identification of the database corresponding to the test component in the database server to determine whether it is the current version identification; if so, based on the database The file upgrades the database corresponding to the test component; if not, returns a prompt message including the version identification, and upgrades the database corresponding to the test component based on the database file. The version identifier of the database corresponding to the test component in the database server is the current version identifier, indicating that the database has not been upgraded by itself on the database server, and the database corresponding to the test component can be upgraded based on the database file; the version identifier of the database corresponding to the test component in the database server is not Identifies the current version, indicating that the database server needs to upgrade the database by itself. It needs to return a prompt message including the version identification to the version control platform, and then upgrade the database corresponding to the test component based on the database file. The version control platform receives the version returned by the database server. After the prompt message is identified, a corresponding data upgrade record can be generated and stored and displayed, so as to update the database version to the version identifier in the prompt message, so as to ensure the accuracy of the database upgrade information and version information.
本发明实施例中，为了保证数据库升级文件的准确定，可以在对数据库升级之前先对数据库文件进行校验，具体方式可以为：从数据库文件中获取数据库文件标识，以生成对应的第一校验值，查询数据库的数据库标识，以结合目标版本标识生成对应的第二校验值；判断第一校验值和第二校验值是否一致；若是，则确定数据库文件校验成功；若否，则确定数据库文件校验失败。In the embodiment of the present invention, in order to ensure the accuracy of the database upgrade file, the database file can be verified before the database upgrade, and the specific method can be: obtain the database file identifier from the database file to generate the corresponding first calibration verification value, query the database identification of the database, to generate the corresponding second verification value in combination with the target version identification; judge whether the first verification value and the second verification value are consistent; if so, then determine that the database file verification is successful; if not , it is determined that the database file verification failed.
数据库的各数据文件标识通常为数据库标识与版本标识按照预设规则结合而生成，例如将二者拼接生成。所以本步骤中可以获取数据库文件标识来生成对应的第一校验值，在将数据库标识和目标版本标识按照预设规则结合后，在生成对应的第二校验值。如此如果数据库文件无误，则第一校验值和第二校验值相同；如果数据库文件有误，则第一校验值和第二校验值不相同。因此第一校验值和第二校验值一致，则可以确定数据库文件校验成功，进而可以执行数据库升级；第一校验值和第二校验值不一致，则确定数据库文件校验失败，此时可以重新指示纳管平台获取数据库文件。Each data file identifier of the database is usually generated by combining the database identifier and the version identifier according to preset rules, such as splicing the two. Therefore, in this step, the database file identifier can be obtained to generate a corresponding first verification value, and after the database identifier and the target version identifier are combined according to preset rules, a corresponding second verification value is generated. In this way, if the database file is correct, the first check value and the second check value are the same; if the database file is wrong, the first check value and the second check value are different. Therefore, if the first verification value is consistent with the second verification value, it can be determined that the database file verification is successful, and then the database upgrade can be performed; if the first verification value is inconsistent with the second verification value, it is determined that the database file verification has failed. At this point, you can instruct the management platform to obtain the database file again.
本发明实施例中，版本管控平台可以通过调用纳管平台来实现数据库的升级管理，而无需工作人员操作，所以不需要具有一定数据库基础的人员才能执行数据库的版本更新，从而可以降低数据库的管理和操作成本，节省工作人员的操作时间。In the embodiment of the present invention, the version management and control platform can realize the upgrade management of the database by calling the management platform without the need for staff to operate, so it is not necessary for personnel with a certain database foundation to perform the version update of the database, thereby reducing the management of the database And operating costs, saving staff operating time.
需要说明的是，本发明实施例中版本控制平台还可以对用户和数据库管理员的权限进行管控，例如配置用户和只能对某个或某些组件对应的数据库进行信息查看和操作，数据库管理员可以对所有数据库进行信息查看和操作。并且，在用户第一次对某个数据库的信息操作时，可以先输入该数据库对应的连接串，版本控制平台可以基于连接串查询是否存储了该数据库的信息，如果是则允许用户的后续操作，如果否则需要先获取该数据库的信息再允许用户的操作。具体的，用户通过版本控制平台可以对数据库的信息查询、修改、增删、升级等等操作，并且每次用户盛情的操作均可以先通过DBA审核后在执行。It should be noted that the version control platform in the embodiment of the present invention can also manage and control the rights of users and database administrators, such as configuring users and only viewing and operating information on databases corresponding to one or some components, database management Administrators can view and operate information on all databases. Moreover, when the user operates on the information of a certain database for the first time, he can first input the connection string corresponding to the database, and the version control platform can query whether the information of the database is stored based on the connection string, and if so, allow the user to perform subsequent operations , if otherwise, it is necessary to obtain the information of the database before allowing the user's operation. Specifically, users can query, modify, add, delete, upgrade, etc. the information of the database through the version control platform, and each kind operation of the user can be executed after being approved by the DBA.
数据库服务端在执行数据库升级时，可以实时向版本管控平台发送升级进度，版本管控平台可以通过任务流的方式显示数据库升级的进度，以便于用户查看。When the database server is performing a database upgrade, it can send the upgrade progress to the version control platform in real time, and the version control platform can display the progress of the database upgrade through task flow, so that users can check it.
下面结合图1所示的实施例，对本发明实施例中以纳管平台和数据库服务端独立设置为例，对数据库的升级方法进行具体说明，如图2所示，该方法包括：In the following, in combination with the embodiment shown in FIG. 1 , the method for upgrading the database will be specifically described by taking the independent setting of the management platform and the database server in the embodiment of the present invention as an example. As shown in FIG. 2 , the method includes:
S201：版本管控平台接收用户输入的升级请求，获取测试环境和测试组件，以查询测试组件在测试环境下对应数据库的目标版本标识。S201: The version management and control platform receives an upgrade request input by a user, acquires a test environment and a test component, and queries the target version identifier of the test component corresponding to a database in the test environment.
S202：版本管控平台获取测试组件对应数据库的当前版本标识，确定为目标版本标识后，调用纳管平台接口，向纳管平台发送目标版本标识。S202: The version management and control platform obtains the current version identifier of the database corresponding to the test component, and after determining it as the target version identifier, invokes the management platform interface, and sends the target version identifier to the management platform.
其中，本发明实施例中以当前版本标识为目标版本标识为例进行说明。Wherein, in the embodiment of the present invention, the current version identifier is taken as the target version identifier as an example for description.
S203：纳管平台获取目标版本标识对应的数据库文件，查询测试组件对应数据库所在服务端的地址信息，基于地址信息将数据库文件发送至数据库服务端。S203: The management platform obtains the database file corresponding to the target version identifier, queries the address information of the server where the test component corresponds to the database, and sends the database file to the database server based on the address information.
数据库文件具体可以为数据库脚本。Specifically, the database file may be a database script.
S204：数据库服务端对数据库文件执行校验，在校验通过后基于数据库文件升级测试组件对应的数据库，向版本管控平台发送数据库升级结果。S204: The database server verifies the database file, upgrades the database corresponding to the test component based on the database file after the verification is passed, and sends the database upgrade result to the version control platform.
数据库服务端对数据库升级时还可以先对数据库进行预检查，如数据库是否打开等等，并可以由DBA审批后执行升级操作。When the database server upgrades the database, it can also pre-check the database first, such as whether the database is open, etc., and can perform the upgrade operation after being approved by the DBA.
S205：接收数据库服务端发送的数据库升级结果，以生成对应的数据库升级记录，并存储和显示对应的数据库升级记录。S205: Receive the database upgrade result sent by the database server to generate a corresponding database upgrade record, and store and display the corresponding database upgrade record.
本发明实施例中，满足了数据处理框架中各组件的测试需求，并可以支持多种数据库版本管理，例如可以包括oracle、mysql、goldenDB、oceanBase数据库以及后续可能新增的各种数据库；并且通过与纳管平台交互，可以使用脚本的方式调用相关数据库的处理流程，可以尽量减少用户操作。In the embodiment of the present invention, the test requirements of each component in the data processing framework are met, and multiple database version management can be supported, for example, it can include oracle, mysql, goldenDB, oceanBase database and various databases that may be added later; and through To interact with the management platform, scripts can be used to call the processing flow of the relevant database, which can minimize user operations.
为了解决现有技术存在的问题，本发明实施例提供了一种数据库的管理装置300，如图3所示，该装置300包括：In order to solve the problems existing in the prior art, the embodiment of the present invention provides a
获取单元301，用于获取测试环境和测试组件，以查询所述测试组件在所述测试环境下对应数据库的目标版本标识；An
升级单元302，用于获取所述测试组件对应数据库的当前版本标识，以判断是否为所述目标版本标识；若是，则不对所述测试组件对应的数据库执行操作；若否，则调用纳管平台接口，向纳管平台发送所述目标版本标识，以使所述纳管平台基于所述目标版本标识获取对应的数据库文件，进而对所述数据库文件执行校验，在校验通过后基于所述数据库文件升级所述测试组件对应的数据库，以基于升级后的数据库，对所述测试组件在所述测试环境下执行测试。The
应理解的是，实施本发明实施例的方式与实施图1所示实施例的方式相同，在此不再赘述。It should be understood that, the manner of implementing the embodiment of the present invention is the same as that of the embodiment shown in FIG. 1 , and details are not repeated here.
本发明实施例的一种实现方式中，所述升级单元302，具体用于：In an implementation manner of the embodiment of the present invention, the
查询所述测试组件对应数据库所在服务端的地址信息，基于所述地址信息将所述数据库文件发送至数据库服务端，以使所述数据库服务端对所述数据库文件执行校验，以及基于所述数据库文件升级所述测试组件对应的数据库。Querying the address information of the server where the database corresponding to the test component is located, sending the database file to the database server based on the address information, so that the database server performs verification on the database file, and based on the database The file upgrades the database corresponding to the test component.
本发明实施例的又一种实现方式中，所述升级单元302，具体用于：In yet another implementation manner of the embodiment of the present invention, the
查询所述数据库服务端中所述测试组件对应数据库的版本标识，以判断是否为所述当前版本标识；Querying the version identifier of the database corresponding to the test component in the database server to determine whether it is the current version identifier;
若是，则基于所述数据库文件升级所述测试组件对应的数据库；若否，则返回包括所述版本标识的提示消息，并基于所述数据库文件升级所述测试组件对应的数据库。If yes, upgrade the database corresponding to the test component based on the database file; if not, return a prompt message including the version identifier, and upgrade the database corresponding to the test component based on the database file.
本发明实施例的又一种实现方式中，所述装置300还包括：In yet another implementation manner of the embodiment of the present invention, the
接收单元，用于接收所述版本标识的提示消息，获取所述提示信息中的版本标识，以从数据库升级记录中查询是否存储了所述版本标识对应的数据库升级记录；The receiving unit is configured to receive a prompt message of the version identifier, acquire the version identifier in the prompt information, and query from the database upgrade record whether the database upgrade record corresponding to the version identifier is stored;
生成单元，用于若是，则忽略所述提示消息；若否，则生成所述版本标识对应的升级记录并存储。The generating unit is configured to ignore the prompt message if yes, and generate and store an upgrade record corresponding to the version identifier if no.
本发明实施例的又一种实现方式中，所述升级单元302，还用于：In yet another implementation manner of the embodiment of the present invention, the
接收所述数据库服务端发送的数据库升级结果，以生成对应的数据库升级记录；receiving the database upgrade result sent by the database server to generate a corresponding database upgrade record;
显示所述数据库升级记录。Display the database upgrade record.
本发明实施例的又一种实现方式中，所述升级单元302，具体用于：In yet another implementation manner of the embodiment of the present invention, the
查询所述地址信息对应的路由表，以获取所述地址信息对应中转网关的地址，进而基于所述中转网关的地址，向所述中转网关发送所述地址信息和所述数据库文件，以使所述中转网关基于所述地址信息发送所述数据库文件。Querying the routing table corresponding to the address information to obtain the address of the transit gateway corresponding to the address information, and then based on the address of the transit gateway, sending the address information and the database file to the transit gateway, so that all The transit gateway sends the database file based on the address information.
本发明实施例的又一种实现方式中，所述升级单元302，具体用于：In yet another implementation manner of the embodiment of the present invention, the
从所述数据库文件中获取数据库文件标识，以生成对应的第一校验值，查询所述数据库的数据库标识，以结合所述目标版本标识生成对应的第二校验值；Obtaining a database file identifier from the database file to generate a corresponding first check value, and querying the database identifier of the database to generate a corresponding second check value in combination with the target version identifier;
判断所述第一校验值和所述第二校验值是否一致；judging whether the first check value is consistent with the second check value;
若是，则确定所述数据库文件校验成功；若否，则确定所述数据库文件校验失败If so, it is determined that the database file verification is successful; if not, it is determined that the database file verification fails
本发明实施例的又一种实现方式中，所述获取单元301，具体用于：In yet another implementation manner of the embodiment of the present invention, the acquiring
接收用户输入的升级请求，所述升级请求包括所述测试环境和所述测试组件；receiving an upgrade request input by a user, where the upgrade request includes the test environment and the test components;
发送所述升级请求对应的审批提示信息，以提示对所述升级请求进行审批；Sending approval prompt information corresponding to the upgrade request to prompt approval of the upgrade request;
接收所述升级请求对应审批结果，确定所述审批结果为审批通过后获取所述升级请求中所述测试环境和所述测试组件。The test environment and the test components in the upgrade request are acquired after receiving an approval result corresponding to the upgrade request, and determining that the approval result is approved.
应理解的是，实施本发明实施例的方式与实施图2所示实施例的方式相同，在此不再赘述。It should be understood that, the manner of implementing the embodiment of the present invention is the same as that of the embodiment shown in FIG. 2 , and details are not repeated here.
本发明实施例中，版本管控平台可以通过调用纳管平台来实现数据库的升级管理，而无需工作人员操作，所以不需要具有一定数据库基础的人员才能执行数据库的版本更新，从而可以降低数据库的管理和操作成本，节省工作人员的操作时间。In the embodiment of the present invention, the version management and control platform can realize the upgrade management of the database by calling the management platform without the need for staff to operate, so it is not necessary for personnel with a certain database foundation to perform the version update of the database, thereby reducing the management of the database And operating costs, saving staff operating time.
根据本发明的实施例，本发明实施例还提供了一种电子设备和一种可读存储介质。According to the embodiment of the present invention, the embodiment of the present invention also provides an electronic device and a readable storage medium.
本发明实施例的电子设备包括：至少一个处理器；以及，与所述至少一个处理器通信连接的存储器；其中，所述存储器存储有可被所述一个处理器执行的指令，所述指令被所述至少一个处理器执行，以使所述至少一个处理器执行本发明实施例所提供的数据库的管理方法。The electronic device in the embodiment of the present invention includes: at least one processor; and a memory connected in communication with the at least one processor; wherein, the memory stores instructions executable by the one processor, and the instructions are executed by The at least one processor executes, so that the at least one processor executes the database management method provided by the embodiment of the present invention.
图4示出了可以应用本发明实施例的数据库的管理方法或数据库的管理装置的示例性系统架构400。Fig. 4 shows an
如图4所示，系统架构400可以包括终端设备401、402、403，网络404和服务器405。网络404用以在终端设备401、402、403和服务器405之间提供通信链路的介质。网络404可以包括各种连接类型，例如有线、无线通信链路或者光纤电缆等等。本发明实施例中，终端设备可以设置版本控制平台，服务器可以设置纳管平台。As shown in FIG. 4 , the
用户可以使用终端设备401、402、403通过网络404与服务器405交互，以接收或发送消息等。终端设备401、402、403上可以安装有各种客户端应用。Users can use
终端设备401、402、403可以是但不限于智能手机、平板电脑、膝上型便携计算机和台式计算机等等。The
服务器405可以是提供各种服务的服务器，服务器可以对接收到的产品信息查询请求等数据进行分析等处理，并将处理结果(例如产品信息--仅为示例)反馈给终端设备。The
需要说明的是，本发明实施例所提供的数据库的管理方法一般由服务器405执行，相应地，数据库的管理装置一般设置于服务器405中。It should be noted that the database management method provided by the embodiment of the present invention is generally executed by the
应该理解，图4中的终端设备、网络和服务器的数目仅仅是示意性的。根据实现需要，可以具有任意数目的终端设备、网络和服务器。It should be understood that the numbers of terminal devices, networks and servers in Fig. 4 are only illustrative. According to the implementation needs, there can be any number of terminal devices, networks and servers.
下面参考图5，其示出了适于用来实现本发明实施例的计算机系统500的结构示意图。图5示出的计算机系统仅仅是一个示例，不应对本发明实施例的功能和使用范围带来任何限制。Referring now to FIG. 5 , it shows a schematic structural diagram of a
如图5所示，计算机系统500包括中央处理单元(CPU)501，其可以根据存储在只读存储器(ROM)502中的程序或者从存储部分508加载到随机访问存储器(RAM)503中的程序而执行各种适当的动作和处理。在RAM 503中，还存储有系统500操作所需的各种程序和数据。CPU 501、ROM 502以及RAM 503通过总线504彼此相连。输入/输出(I/O)接口505也连接至总线504。As shown in FIG. 5 , a
以下部件连接至I/O接口505：包括键盘、鼠标等的输入部分506；包括诸如阴极射线管(CRT)、液晶显示器(LCD)等以及扬声器等的输出部分507；包括硬盘等的存储部分508；以及包括诸如LAN卡、调制解调器等的网络接口卡的通信部分509。通信部分509经由诸如因特网的网络执行通信处理。驱动器510也根据需要连接至I/O接口505。可拆卸介质511，诸如磁盘、光盘、磁光盘、半导体存储器等等，根据需要安装在驱动器510上，以便于从其上读出的计算机程序根据需要被安装入存储部分508。The following components are connected to the I/O interface 505: an
特别地，根据本发明公开的实施例，上文参考流程图描述的过程可以被实现为计算机软件程序。例如，本发明公开的实施例包括一种计算机程序产品，其包括承载在计算机可读介质上的计算机程序，该计算机程序包含用于执行流程图所示的方法的程序代码。在这样的实施例中，该计算机程序可以通过通信部分509从网络上被下载和安装，和/或从可拆卸介质511被安装。在该计算机程序被中央处理单元(CPU)501执行时，执行本发明的系统中限定的上述功能。In particular, according to the disclosed embodiments of the present invention, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, the disclosed embodiments of the present invention include a computer program product, which includes a computer program carried on a computer-readable medium, where the computer program includes program codes for executing the methods shown in the flowcharts. In such an embodiment, the computer program may be downloaded and installed from a network via
需要说明的是，本发明所示的计算机可读介质可以是计算机可读信号介质或者计算机可读存储介质或者是上述两者的任意组合。计算机可读存储介质例如可以是——但不限于——电、磁、光、电磁、红外线、或半导体的系统、装置或器件，或者任意以上的组合。计算机可读存储介质的更具体的例子可以包括但不限于：具有一个或多个导线的电连接、便携式计算机磁盘、硬盘、随机访问存储器(RAM)、只读存储器(ROM)、可擦式可编程只读存储器(EPROM或闪存)、光纤、便携式紧凑磁盘只读存储器(CD-ROM)、光存储器件、磁存储器件、或者上述的任意合适的组合。在本发明中，计算机可读存储介质可以是任何包含或存储程序的有形介质，该程序可以被指令执行系统、装置或者器件使用或者与其结合使用。而在本发明中，计算机可读的信号介质可以包括在基带中或者作为载波一部分传播的数据信号，其中承载了计算机可读的程序代码。这种传播的数据信号可以采用多种形式，包括但不限于电磁信号、光信号或上述的任意合适的组合。计算机可读的信号介质还可以是计算机可读存储介质以外的任何计算机可读介质，该计算机可读介质可以发送、传播或者传输用于由指令执行系统、装置或者器件使用或者与其结合使用的程序。计算机可读介质上包含的程序代码可以用任何适当的介质传输，包括但不限于：无线、电线、光缆、RF等等，或者上述的任意合适的组合。It should be noted that the computer-readable medium shown in the present invention may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. A computer readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or device, or any combination thereof. More specific examples of computer-readable storage media may include, but are not limited to, electrical connections with one or more wires, portable computer diskettes, hard disks, 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 of the above. In the present invention, a computer-readable storage medium may be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device. In the present invention, however, a computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, in which computer-readable program codes are carried. Such propagated data signals may take many forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the foregoing. A computer-readable signal medium may also be any computer-readable medium other than a computer-readable storage medium, which can send, propagate, or transmit a program for use by or in conjunction with an instruction execution system, apparatus, or device. . Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
附图中的流程图和框图，图示了按照本发明各种实施例的系统、方法和计算机程序产品的可能实现的体系架构、功能和操作。在这点上，流程图或框图中的每个方框可以代表一个单元、程序段、或代码的一部分，上述单元、程序段、或代码的一部分包含一个或多个用于实现规定的逻辑功能的可执行指令。也应当注意，在有些作为替换的实现中，方框中所标注的功能也可以以不同于附图中所标注的顺序发生。例如，两个接连地表示的方框实际上可以基本并行地执行，它们有时也可以按相反的顺序执行，这依所涉及的功能而定。也要注意的是，框图或流程图中的每个方框、以及框图或流程图中的方框的组合，可以用执行规定的功能或操作的专用的基于硬件的系统来实现，或者可以用专用硬件与计算机指令的组合来实现。The flowchart and block diagrams in the Figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in a flowchart or block diagram may represent a unit, a program segment, or a portion of code that includes one or more logical functions for implementing specified functions. executable instructions. It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or they may sometimes be executed in the reverse order, depending upon the functionality involved. It should also be noted that each block in the block diagrams or flowchart illustrations, and combinations of blocks in the block diagrams or flowchart illustrations, can be implemented by a dedicated hardware-based system that performs the specified function or operation, or can be implemented by a A combination of dedicated hardware and computer instructions.
描述于本发明实施例中所涉及到的单元可以通过软件的方式实现，也可以通过硬件的方式来实现。所描述的单元也可以设置在处理器中，例如，可以描述为：一种处理器包括获取单元和升级单元。其中，这些单元的名称在某种情况下并不构成对该单元本身的限定，例如，获取单元还可以被描述为“获取单元的功能的单元”。The units involved in the description in the embodiments of the present invention may be implemented by means of software or by means of hardware. The described units may also be set in a processor, for example, it may be described as: a processor includes an acquisition unit and an upgrade unit. Wherein, the names of these units do not constitute a limitation on the unit itself under certain circumstances, for example, the obtaining unit may also be described as "a unit that obtains the function of the unit".
作为另一方面，本发明还提供了一种计算机可读介质，该计算机可读介质可以是上述实施例中描述的设备中所包含的；也可以是单独存在，而未装配入该设备中。上述计算机可读介质承载有一个或者多个程序，当上述一个或者多个程序被一个该设备执行时，使得该设备执行本发明所提供的数据库的管理方法。As another aspect, the present invention also provides a computer-readable medium. The computer-readable medium may be contained in the device described in the above embodiments, or it may exist independently without being assembled into the device. The above-mentioned computer-readable medium carries one or more programs, and when the above-mentioned one or more programs are executed by one device, the device is made to execute the database management method provided by the present invention.
上述具体实施方式，并不构成对本发明保护范围的限制。本领域技术人员应该明白的是，取决于设计要求和其他因素，可以发生各种各样的修改、组合、子组合和替代。任何在本发明的精神和原则之内所作的修改、等同替换和改进等，均应包含在本发明保护范围之内。The above specific implementation methods do not constitute a limitation to the protection scope of the present invention. It should be apparent to those skilled in the art that various modifications, combinations, sub-combinations and substitutions may occur depending on design requirements and other factors. Any modifications, equivalent replacements and improvements made within the spirit and principles of the present invention shall be included within the protection scope of the present invention.
Claims (16)
Translated fromChinesePriority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110697819.8ACN113420010B (en) | 2021-06-23 | 2021-06-23 | Database management method, device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110697819.8ACN113420010B (en) | 2021-06-23 | 2021-06-23 | Database management method, device, electronic equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113420010A CN113420010A (en) | 2021-09-21 |
| CN113420010Btrue CN113420010B (en) | 2023-05-26 |
Family
ID=77717526
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110697819.8AActiveCN113420010B (en) | 2021-06-23 | 2021-06-23 | Database management method, device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113420010B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114020629B (en)* | 2021-11-09 | 2024-08-20 | 中国工商银行股份有限公司 | Data processing method and device, management platform of test environment and electronic equipment |
| CN114185578B (en)* | 2021-12-17 | 2024-12-20 | 建信金融科技有限责任公司 | A method, device, equipment and readable storage medium for smoothly upgrading a database |
| CN114281786B (en)* | 2021-12-24 | 2024-08-13 | 建信金融科技有限责任公司 | File processing method, device, electronic equipment and storage medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2799001A1 (en)* | 2011-12-29 | 2013-06-29 | Tata Consultancy Services Limited | Database version management system |
| CN104104527A (en)* | 2013-04-03 | 2014-10-15 | 华为终端有限公司 | Upgrade method for access terminal device and access terminal device |
| CN106502883A (en)* | 2016-10-09 | 2017-03-15 | 武汉斗鱼网络科技有限公司 | The database synchronization method and system of client and service end during automatic test |
| CN107861737A (en)* | 2017-11-06 | 2018-03-30 | 国云科技股份有限公司 | A kind of database version moving method of large scale system |
| CN110389903A (en)* | 2019-07-19 | 2019-10-29 | 中国工商银行股份有限公司 | Test environment deployment method and apparatus, electronic device and readable storage medium |
| CN111142899A (en)* | 2019-12-12 | 2020-05-12 | 东软集团股份有限公司 | Database script execution method and device, storage medium and electronic equipment |
| CN111367893A (en)* | 2020-03-31 | 2020-07-03 | 中国建设银行股份有限公司 | Method and device for database version iteration |
| CN112579568A (en)* | 2020-12-15 | 2021-03-30 | 中国建设银行股份有限公司 | Database version processing method and system |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8527460B2 (en)* | 2010-02-19 | 2013-09-03 | Jason Laurence Noble | Method for carrying out database version control |
| CN108804618B (en)* | 2018-05-31 | 2023-07-28 | 康键信息技术（深圳）有限公司 | Database configuration method, device, computer equipment and storage medium |
| CN110221967A (en)* | 2019-05-20 | 2019-09-10 | 深圳壹账通智能科技有限公司 | Test data building method, device, computer equipment and storage medium |
| CN110413522A (en)* | 2019-07-25 | 2019-11-05 | 江苏满运软件科技有限公司 | A method, device, storage medium and electronic device for determining a test database |
| CN110543469B (en)* | 2019-08-28 | 2020-09-11 | 贝壳找房(北京)科技有限公司 | Database version management method and server |
| CN111857796A (en)* | 2020-06-24 | 2020-10-30 | 苏州浪潮智能科技有限公司 | A database version control system and method |
| CN112100194A (en)* | 2020-10-10 | 2020-12-18 | 苏州浪潮智能科技有限公司 | Database version management method and system |
- 2021
- 2021-06-23CNCN202110697819.8Apatent/CN113420010B/enactiveActive
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2799001A1 (en)* | 2011-12-29 | 2013-06-29 | Tata Consultancy Services Limited | Database version management system |
| CN104104527A (en)* | 2013-04-03 | 2014-10-15 | 华为终端有限公司 | Upgrade method for access terminal device and access terminal device |
| CN106502883A (en)* | 2016-10-09 | 2017-03-15 | 武汉斗鱼网络科技有限公司 | The database synchronization method and system of client and service end during automatic test |
| CN107861737A (en)* | 2017-11-06 | 2018-03-30 | 国云科技股份有限公司 | A kind of database version moving method of large scale system |
| CN110389903A (en)* | 2019-07-19 | 2019-10-29 | 中国工商银行股份有限公司 | Test environment deployment method and apparatus, electronic device and readable storage medium |
| CN111142899A (en)* | 2019-12-12 | 2020-05-12 | 东软集团股份有限公司 | Database script execution method and device, storage medium and electronic equipment |
| CN111367893A (en)* | 2020-03-31 | 2020-07-03 | 中国建设银行股份有限公司 | Method and device for database version iteration |
| CN112579568A (en)* | 2020-12-15 | 2021-03-30 | 中国建设银行股份有限公司 | Database version processing method and system |
Non-Patent Citations (1)
| Title |
|---|
| Modular Synchronization in Distributed, Multiversion Databases: Version Control and Concurrency Control;Divyakant Agrawal;《 IEEE Transactions on Knowledge and Data Engineering》;第5卷(第1期);全文* |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113420010A (en) | 2021-09-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106598667B (en) | Method and device for repairing kernel vulnerabilities | |
| CN113420010B (en) | Database management method, device, electronic equipment and storage medium | |
| CN107896244B (en) | Version file distribution method, client and server | |
| CN111078262B (en) | Application thermal restoration method and device | |
| CN106843976B (en) | Method and apparatus for generating image file | |
| WO2017166446A1 (en) | Vulnerability-fixing method and device | |
| CN109992496A (en) | A data processing method and device for automated testing | |
| CN110262821A (en) | A kind of management method of software module, device and server | |
| CN110515855B (en) | Simulation control method, server and system for application program | |
| WO2019029451A1 (en) | Method for publishing mobile applications and electronic apparatus | |
| CN111796851A (en) | Client base library updating method and device, electronic equipment and storage medium | |
| CN109814889B (en) | Method and apparatus for updating source code base | |
| CN110221857A (en) | The problem of application program restorative procedure, device, electronic equipment and storage medium | |
| CN112559024A (en) | Method and device for generating transaction code change list | |
| CN113590483B (en) | Use case operation method and device | |
| CN108287792B (en) | Method and apparatus for outputting information | |
| CN113032004A (en) | Method, apparatus and program product for managing development jobs in a development environment | |
| CN114625458A (en) | Page data processing method and device, electronic equipment and storage medium | |
| CN114924742A (en) | Method and device for making and applying hot patch for virtual machine simulation software | |
| CN112084114B (en) | Method and apparatus for testing interfaces | |
| CN113377400A (en) | Software upgrading method and device, storage medium and electronic equipment | |
| CN107247661B (en) | Method and system for supporting automatic verification of installation package of application | |
| CN112579428A (en) | Interface testing method and device, electronic equipment and storage medium | |
| CN116737662A (en) | Method, device, electronic equipment and storage medium for processing business data | |
| CN115993981A (en) | Data processing method, device, electronic equipment and computer readable medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right | Effective date of registration:20221008 Address after:25 Financial Street, Xicheng District, Beijing 100033 Applicant after:CHINA CONSTRUCTION BANK Corp. Address before:12 / F, 15 / F, No. 99, Yincheng Road, Shanghai pilot Free Trade Zone, 200120 Applicant before:Jianxin Financial Science and Technology Co.,Ltd. | |
| GR01 | Patent grant | ||
| GR01 | Patent grant |