Search

CN-122019504-A - Method, apparatus, device, medium and program product for processing failure object

CN122019504ACN 122019504 ACN122019504 ACN 122019504ACN-122019504-A

Abstract

The application provides a failure object processing method. The method can be applied to the distributed technical field and the big data technical field. The method comprises the steps of obtaining connection information of n databases, carrying out data connection with the n databases based on the connection information of the n databases, and generating m target databases with the data connection completed. And detecting first invalidation objects of the m target databases, and determining a target invalidation objects in the m target databases. Acquiring target submission records of each target failure object in the a target failure objects, and determining a target submission interface corresponding to each target failure object in the a target failure objects based on the target submission records of each target failure object in the a target failure objects. And transmitting the a target failure objects based on the target submission interfaces corresponding to each target failure object in the a target failure objects. The application also provides a failure object processing device, equipment, a storage medium and a program product.

Inventors

  • DENG ZHIDAN

Assignees

  • 中国工商银行股份有限公司

Dates

Publication Date
20260512
Application Date
20260130

Claims (11)

  1. 1. A method of processing a failed object, the method comprising: Acquiring connection information of n databases, and performing data connection with the n databases based on the connection information of the n databases to generate m target databases for completing data connection, wherein n is an integer and n is greater than 1, m is an integer and m is greater than 0, and m is less than or equal to n; Performing first invalidation object detection on the m target databases, and determining a target invalidation objects in the m target databases, wherein a is an integer and a is greater than 1; Acquiring target commit records of each of the a target invalidation objects, determining a target commit interface corresponding to each of the a target invalidation objects based on the target commit records of each of the a target invalidation objects, and And transmitting the a target invalidation objects based on the target submitting interfaces corresponding to each target invalidation object in the a target invalidation objects.
  2. 2. The method of claim 1, wherein the generating m target databases for completing the data connection by performing the data connection with the n databases based on the connection information of the n databases comprises: Based on the connection information of the n databases, carrying out network connection with the n databases to generate n databases after network connection is completed; transmitting preset verification data to the n databases after completing network connection for confirming the availability and access rights of the databases, and And carrying out data connection on m databases returning result data to generate m target databases completing data connection, wherein the result data is corresponding to the sent preset verification data.
  3. 3. The method of claim 1, wherein performing a first invalidation object detection on the m target databases to determine a target invalidation objects in the m target databases comprises: determining a database type of each database in the m target databases, wherein the database type comprises a distributed relational database and a centralized relational database; Performing a second invalidation object detection on the m target databases based on the database type of each database in the m target databases, determining b invalidation objects in the m target databases, wherein b is an integer and b is greater than a, and And performing secondary compiling verification on b invalid objects in the m target databases, and determining a target invalid objects in the m target databases.
  4. 4. A method according to claim 3, wherein performing a second invalidation object detection on the m target databases based on the database type of each of the m target databases, determining b invalidation objects in the m target databases comprises: Determining i distributed relational databases in the m target databases, and performing joint search on the i distributed relational databases to determine c failure objects in the i distributed relational databases, wherein the joint search comprises joint search on a data packet, a function and a storage process, wherein i is an integer, i is greater than 0 and i is less than m, c is an integer, c is greater than 0 and c is less than b; Determining j centralized relational databases in the m target databases, performing invalid state identification query on the j centralized relational databases to determine d invalid objects in the j distributed relational databases, wherein j is an integer and is greater than 0, the sum of i and j is equal to m, d is an integer and is greater than 0, the sum of d and c is equal to b, and And carrying out data merging on the c invalidation objects and the d invalidation objects to generate b invalidation objects in m target databases.
  5. 5. A method according to claim 3, wherein performing a secondary compilation verification of b invalidation objects in the m target databases, determining a target invalidation objects in the m target databases comprises: performing secondary compiling on b invalidation objects in the m target databases to generate b invalidation objects in m target databases after secondary compiling, and And carrying out third invalidation object detection on b invalidation objects in the m target databases, and determining a target invalidation objects in the m target databases.
  6. 6. The method of claim 1, wherein obtaining a target commit record for each target invalidation object of the a target invalidation objects comprises: Acquiring an object name of each target failure object in a target failure objects, taking the object name of each target failure object in the a target failure objects as a keyword, and searching e data submission records corresponding to each keyword, wherein e is an integer and is more than 0; partitioning and sorting the e data submitting records corresponding to each keyword in reverse order according to time through a partition window function, and And acquiring the first data submission record in the e data submission records corresponding to each keyword as a target submission record of each target invalidation object in the a target invalidation objects.
  7. 7. The method of any one of claims 1 to 6, further comprising: And obtaining the repair objects and the repair information of the a target failure objects, and generating visual statistical data based on the repair objects and the repair information of the a target failure objects.
  8. 8. A failure object handling apparatus, characterized in that the apparatus comprises: the first generation module is used for acquiring connection information of n databases, carrying out data connection with the n databases based on the connection information of the n databases, and generating m target databases for completing data connection, wherein n is an integer and is greater than 1, m is an integer and is greater than 0, and m is less than or equal to n; The first determining module is used for detecting first invalid objects of the m target databases and determining a target invalid objects in the m target databases, wherein a is an integer and a is larger than 1; A second determining module for obtaining target commit records of each of the a target invalidation objects, determining corresponding target commit interfaces of each of the a target invalidation objects based on the target commit records of each of the a target invalidation objects, and And the first sending module is used for sending the a target invalidation objects based on the corresponding target submitting interfaces of each target invalidation object in the a target invalidation objects.
  9. 9. An electronic device, comprising: one or more processors; A memory for storing one or more computer programs, Characterized in that the one or more processors execute the one or more computer programs to implement the steps of the method according to any one of claims 1 to 7.
  10. 10. A computer-readable storage medium, on which a computer program is stored, characterized in that the computer program or instructions, when executed by a processor, implement the steps of the method according to any one of claims 1 to 7.
  11. 11. A computer program product comprising a computer program, characterized in that the computer program, when being executed by a processor, realizes the steps of the method according to any one of claims 1 to 7.

Description

Method, apparatus, device, medium and program product for processing failure object Technical Field The present application relates to the field of big data technologies, and in particular, to a method, an apparatus, a device, a medium, and a program product for processing a failure object. Background With the progress of computer technology, the demands of enterprises including banks on databases are gradually increased, a large number of invalid objects are generated in the databases in the process of using the databases, and the invalid objects in the databases need to be processed in order to ensure the stability of the databases. In the prior art, the processing of the database invalidation object generally relies on manual regular investigation, and an invalidation object list of the database needs to be acquired, and records are manually submitted from an invalidation object list trace script of the database. The failure object processing method is easy to cause low processing efficiency, poor accuracy and low reliability of the failure object, and the technical problem that the overall database system stability is influenced due to overlong repairing period for repairing the failure object is caused. Disclosure of Invention In view of the foregoing, the present application provides a failure object processing method, apparatus, device, medium, and program product. According to the first aspect of the application, a failure object processing method is provided, and the method comprises the steps of obtaining connection information of n databases, carrying out data connection with the n databases based on the connection information of the n databases, generating m target databases which are connected in a data mode, wherein n is an integer and is greater than 1, m is an integer and is greater than 0, m is smaller than or equal to n, carrying out first failure object detection on the m target databases, determining a target failure objects in the m target databases, wherein a is an integer and is greater than 1, obtaining target submission records of each target failure object in the a target failure objects, determining target submission interfaces corresponding to each target failure object in the a target failure objects based on the target submission records of each target failure object in the a target failure objects, and sending the a target failure objects based on the target submission interfaces corresponding to each target failure object in the a target failure objects. According to the embodiment of the application, based on the connection information of the n databases, the n databases are connected in a data way to generate m target databases which are connected in a data way, wherein the m target databases are connected in a network way to the n databases based on the connection information of the n databases to generate n databases which are connected in a network way, preset verification data are sent to the n databases which are connected in the network way to confirm the availability and the access permission of the databases, and the m databases which return result data are connected in a data way to generate m target databases which are connected in a data way, wherein the result data are corresponding to the sent preset verification data. According to the embodiment of the application, first invalidation object detection is carried out on m target databases, a target invalidation object in the m target databases is determined, the database type of each database in the m target databases is determined, the database type comprises a distributed relational database and a centralized relational database, second invalidation object detection is carried out on the m target databases based on the database type of each database in the m target databases, b invalidation objects in the m target databases are determined, b is an integer and b is larger than a, secondary compiling verification is carried out on b invalidation objects in the m target databases, and a target invalidation objects in the m target databases are determined. According to the embodiment of the application, based on the database type of each database in the m target databases, second invalid object detection is carried out on the m target databases, b invalid objects in the m target databases are determined, the method comprises the steps of determining i distributed relational databases in the m target databases, carrying out joint search on the i distributed relational databases to determine c invalid objects in the i distributed relational databases, wherein the joint search comprises carrying out joint search on a data packet, a function and a storage process, i is an integer, i is greater than 0 and i is smaller than m, c is an integer, c is greater than 0 and c is smaller than b, j centralized relational databases in the m target databases are determined, invalid state identification query is carried out on the