CN117171214A - Database information comparison method and device, electronic equipment and storage medium - Google Patents
Database information comparison method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN117171214A CN117171214A CN202311214129.8A CN202311214129A CN117171214A CN 117171214 A CN117171214 A CN 117171214A CN 202311214129 A CN202311214129 A CN 202311214129A CN 117171214 A CN117171214 A CN 117171214A
- Authority
- CN
- China
- Prior art keywords
- database
- comparison
- information
- configuration information
- user terminal
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 60
- 238000004590 computer program Methods 0.000 claims description 16
- 238000013507 mapping Methods 0.000 claims description 14
- 230000008569 process Effects 0.000 claims description 12
- 230000004044 response Effects 0.000 claims description 10
- 238000004422 calculation algorithm Methods 0.000 claims description 7
- 239000012634 fragment Substances 0.000 claims description 3
- 238000004891 communication Methods 0.000 description 8
- 238000010586 diagram Methods 0.000 description 5
- 238000012545 processing Methods 0.000 description 5
- 230000005856 abnormality Effects 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 230000003993 interaction Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000013473 artificial intelligence Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000011521 glass Substances 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000010801 machine learning Methods 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 230000001953 sensory effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Classifications
-
- 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
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a method, a device, equipment and a storage medium for comparing information of a database. The method is executed by a database comparison platform, and comprises the following steps: responding to a database connection information input request of a user terminal, and acquiring database connection information of at least two types of databases; the database connection information comprises basic configuration information, type configuration information and comparison task configuration information; responding to a comparison task creation request of a user terminal, and determining at least two target databases; and responding to a comparison task starting request of the user terminal, and determining a comparison result of each target database group according to the database connection information. The technical scheme solves the problem of difficult information comparison between databases of different types, and can realize the information comparison of the databases of different types through the database comparison platform, thereby improving the information comparison efficiency and accuracy.
Description
Technical Field
The present application relates to the field of database technologies, and in particular, to a method, an apparatus, an electronic device, and a storage medium for comparing information of a database.
Background
At present, the information comparison of databases is mainly based on the same type of databases, for example, the information comparison is performed on a database A and a database B which are both MySQL types. Different types of databases, such as MySQL type databases and Oracle type databases, have difficulty in achieving direct comparison of information due to attribute differences of data objects, fields, and the like.
Disclosure of Invention
The application provides a method, a device, equipment and a storage medium for comparing information of databases, which are used for solving the problem of difficult information comparison between databases of different types, and can realize the information comparison of the databases of different types through a database comparison platform, thereby improving the information comparison efficiency and the accuracy.
According to an aspect of the present application, there is provided an information comparison method of a database, the method being performed by a database comparison platform, the method comprising:
responding to a database connection information input request of a user terminal, and acquiring database connection information of at least two types of databases; the database connection information comprises basic configuration information, type configuration information and comparison task configuration information;
responding to a comparison task creation request of a user terminal, and determining at least two target databases;
and responding to a comparison task starting request of the user terminal, and determining a comparison result of each target database group according to the database connection information.
According to another aspect of the present application, there is provided an information comparison apparatus for a database, the apparatus being configured on a database comparison platform, the apparatus comprising:
the connection information acquisition module is used for responding to a database connection information input request of the user terminal and acquiring database connection information of at least two types of databases; the database connection information comprises basic configuration information, type configuration information and comparison task configuration information;
the target database determining module is used for determining at least two target databases in response to a comparison task creating request of the user terminal;
and the comparison result determining module is used for responding to the comparison task starting request of the user terminal and determining the comparison result of each target database group according to the database connection information.
According to another aspect of the present application, there is provided an electronic apparatus including:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein,
the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the method of information comparison of a database according to any of the embodiments of the present application.
According to another aspect of the present application, there is provided a computer readable storage medium storing computer instructions for causing a processor to implement the method for information comparison of a database according to any of the embodiments of the present application when executed.
According to the technical scheme, the database connection information of at least two types of databases is obtained through a database comparison platform in response to a database connection information input request of a user terminal; responding to a comparison task creation request of a user terminal, and determining at least two target databases; and responding to a comparison task starting request of the user terminal, and determining a comparison result of each target database group according to the database connection information. The technical scheme solves the problem of difficult information comparison between databases of different types, and can realize the information comparison of the databases of different types through the database comparison platform, thereby improving the information comparison efficiency and accuracy.
It should be understood that the description in this section is not intended to identify key or critical features of the embodiments of the application or to delineate the scope of the application. Other features of the present application will become apparent from the description that follows.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for the description of the embodiments will be briefly described below, and it is apparent that the drawings in the following description are only some embodiments of the present application, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flowchart of a database information comparison method according to a first embodiment of the present application;
FIG. 2 is a flowchart of a database information comparison method according to a second embodiment of the present application;
fig. 3 is a schematic structural diagram of an information comparison device of a database according to a third embodiment of the present application;
fig. 4 is a schematic structural diagram of an electronic device implementing a method for comparing information of a database according to an embodiment of the present application.
Detailed Description
In order that those skilled in the art will better understand the present application, a technical solution in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present application, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present application without making any inventive effort, shall fall within the scope of the present application.
It should be noted that the terms "first," "second," and the like in the description and the claims of the present application and the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the application described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus. The technical scheme of the application obtains, stores, uses, processes and the like the data, which all meet the relevant regulations of national laws and regulations.
Example 1
Fig. 1 is a flowchart of a method for comparing information of databases according to an embodiment of the present application, which is applicable to a scenario in which information of databases of different types is compared. The method may be performed by a database information comparison device, which may be implemented in hardware and/or software, which may be configured in an electronic device. As shown in fig. 1, the method includes:
s110, responding to a database connection information input request of the user terminal, and acquiring database connection information of at least two types of databases.
The scheme can be executed by a database comparison platform, the database comparison platform can interact with the user terminal, and the database connection information input request of the user terminal is responded. The user terminal may perform database connection configuration after passing the user authentication. The database comparison platform can acquire the database connection information input by the user terminal.
The database connection information may include basic configuration information, type configuration information, and comparison task configuration information. The basic configuration information may be configuration information for describing how to acquire the database, the type of configuration information may be configuration information for describing the type of database, and the alignment task configuration information may be configuration information for describing alignment tasks of different types of databases.
Specifically, the database connection information may include configuration items for performing information comparison on different types of databases, for example, the basic configuration information may include a server address, a server port and a database identifier, the type configuration information may include an application identifier, a database type and a database fragment identifier, and the comparison task configuration information may include a task type, a source database identifier and a destination database identifier. The task types comprise data object comparison, data detail comparison, storage process comparison, user permission comparison, view comparison and trigger comparison. The source database identifier may be information such as a name, a number, and an ID of the reference database, and the destination database identifier may be information such as a name, a number, and an ID of the database that needs to be compared with the reference database.
S120, determining at least two target databases in response to a comparison task creation request of the user terminal.
After completing the data connection configuration, the user may establish an alignment task through the user terminal. The user terminal may send an alignment task creation request to the database alignment platform. The alignment task creation request may include information such as request time, user identification, source database identification, destination database identification, alignment range, and alignment type. The data comparison platform can determine a target database according to the comparison task creation request, wherein the target database can comprise a source database and at least one target database.
S130, responding to a comparison task starting request of the user terminal, and determining a comparison result of each target database group according to the database connection information.
The user can send a comparison task starting request to the database comparison platform through the user terminal in a task triggering mode or a timing mode. The database alignment platform may divide the target databases into at least one target database group, each of which may include a source database and a destination database. According to the database connection information, the database comparison platform can compare two databases in each target database group to obtain a comparison result of each target database group.
According to the technical scheme, the database connection information of at least two types of databases is obtained through a database comparison platform in response to a database connection information input request of a user terminal; responding to a comparison task creation request of a user terminal, and determining at least two target databases; and responding to a comparison task starting request of the user terminal, and determining a comparison result of each target database group according to the database connection information. The technical scheme solves the problem of difficult information comparison between databases of different types, and can realize the information comparison of the databases of different types through the database comparison platform, thereby improving the information comparison efficiency and accuracy.
Example two
Fig. 2 is a flowchart of a database information comparison method according to a second embodiment of the present application, where the present embodiment is refined based on the foregoing embodiments. As shown in fig. 2, the method includes:
s210, responding to a database connection information input request of the user terminal, and acquiring database connection information of at least two types of databases.
In a scenario where the database is large, the database needs to be routed in batches, so the database connection information may further include routing configuration information. The routing configuration information comprises an application identifier, a routing type, a source database identifier and a destination database identifier; the route types include database routes and table routes.
If the route type is a table route, the route configuration information further comprises a table identifier, a route algorithm identifier and a route field identifier. Specifically, the routing algorithm may include algorithms such as data slicing, data routing, and the like, and the data slicing algorithm may include hash slicing, range slicing, and the like.
In different types of databases, the same data object may have different attributes, e.g., the names of the same table are different, and the field types of the same field are different. Thus, the database connection information may further include mapping configuration information; the mapping relation configuration information comprises data object mapping relation configuration and field type mapping relation configuration.
Specifically, the data object may include a table and a field, and the data object mapping relationship configuration may be used to describe a correspondence of the data object between two databases. For example, table A1 in database a corresponds to table B1 in database B. The field type mapping relationship configuration may be used to describe a correspondence of field types between two databases. For example, the field type of field a in database a is varchar2, the field type of field a in database B is varvcar, and the database alignment platform may map the varchar2 type field in database a to the varvcar type field of the same name in database B.
S220, determining at least two target databases in response to the comparison task creation request of the user terminal.
S230, responding to a comparison task starting request of the user terminal, and determining a comparison result of each target database group according to the database connection information.
The database comparison platform can compare the information of the table structure, the table data, the storage process, the function, the user authority, the view, the trigger and the like of the two target databases in each target database group according to the database connection information to obtain a comparison result.
S240, responding to the comparison result downloading request of the user terminal, obtaining the comparison result of each target database group, and generating a comparison result table.
It may be appreciated that the comparison result may include information such as a comparison task identifier, a source database object type, a source database object value, a destination database object type, a destination database object value, a consistency determination result, and a cause of inconsistency. Wherein the object types include tables, fields, indexes, stored procedures, and views.
The database comparison platform may send a task completion notification to the user terminal after the database comparison task is completed. The user can browse and download the comparison result through the user terminal. The database comparison platform can respond to the comparison result downloading request of the user terminal, and generates a comparison result table according to the comparison result so as to be used by the user.
The scheme can support flexible comparison strategies, such as full library comparison, appointed preset table comparison, appointed un-compared preset table, appointed preset storage process comparison, appointed un-compared preset storage processes and other comparison principles. The user can meet the diversified demands of the user through personalized configuration of the user.
When the database comparison task is interrupted due to server abnormality, network abnormality, database abnormality and the like, the database comparison platform can continue to compare the remaining table structures, storage processes, table data and the like which are not compared after the abnormality is repaired, so that repeated comparison is reduced, and calculation cost and time cost are saved.
For table structures with data amounts of tens of millions to hundreds of millions, the database comparison platform can split the tables according to a main key, time, field types and the like, and multithreading is adopted to process each split table in parallel, so that the rapid comparison of large-scale table structures is realized.
According to the technical scheme, the database connection information of at least two types of databases is obtained through a database comparison platform in response to a database connection information input request of a user terminal; responding to a comparison task creation request of a user terminal, and determining at least two target databases; and responding to a comparison task starting request of the user terminal, and determining a comparison result of each target database group according to the database connection information. The technical scheme solves the problem of difficult information comparison between databases of different types, and can realize the information comparison of the databases of different types through the database comparison platform, thereby improving the information comparison efficiency and accuracy.
Example III
Fig. 3 is a schematic structural diagram of an information comparison device for a database according to a third embodiment of the present application. The device is configured on a database comparison platform, as shown in fig. 3, and includes:
a connection information obtaining module 310, configured to obtain database connection information of at least two types of databases in response to a database connection information entry request of a user terminal; the database connection information comprises basic configuration information, type configuration information and comparison task configuration information;
a target database determining module 320, configured to determine at least two target databases in response to a comparison task creation request of a user terminal;
the comparison result determining module 330 is configured to determine a comparison result of each target database group according to the database connection information in response to a comparison task start request of the user terminal.
In this scheme, optionally, the basic configuration information includes a server address, a server port, and a database identifier; the type configuration information comprises an application identifier, a database type and a database fragment identifier.
In a possible scheme, the comparison task configuration information comprises a task type, a source database identifier and a destination database identifier; the task types comprise data object comparison, data detail comparison, storage process comparison, user permission comparison, view comparison and trigger comparison.
In another possible solution, the database connection information further includes routing configuration information;
the routing configuration information comprises an application identifier, a routing type, a source database identifier and a destination database identifier; the route type comprises a database route and a table route;
if the route type is a table route, the route configuration information further comprises a table identifier, a route algorithm identifier and a route field identifier.
In this embodiment, optionally, the database connection information further includes mapping relationship configuration information; the mapping relation configuration information comprises data object mapping relation configuration and field type mapping relation configuration.
In a preferred scheme, the comparison result comprises a comparison task identifier, a source database object type, a source database object value, a destination database object type, a destination database object value, a consistency judgment result and an inconsistency reason;
wherein the object types include tables, fields, indexes, stored procedures, and views.
Optionally, the apparatus further includes:
the comparison result table generation module is used for responding to the comparison result downloading request of the user terminal after determining the comparison result of each two target databases, obtaining the comparison result of each target database group and generating the comparison result table.
The database information comparison device provided by the embodiment of the application can execute the database information comparison method provided by any embodiment of the application, and has the corresponding functional modules and beneficial effects of the execution method.
Example IV
Fig. 4 shows a schematic diagram of an electronic device 410 that may be used to implement an embodiment of the application. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. Electronic equipment may also represent various forms of mobile devices, such as personal digital processing, cellular telephones, smartphones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the applications described and/or claimed herein.
As shown in fig. 4, the electronic device 410 includes at least one processor 411, and a memory, such as a Read Only Memory (ROM) 412, a Random Access Memory (RAM) 413, etc., communicatively connected to the at least one processor 411, wherein the memory stores computer programs executable by the at least one processor, and the processor 411 may perform various suitable actions and processes according to the computer programs stored in the Read Only Memory (ROM) 412 or the computer programs loaded from the storage unit 418 into the Random Access Memory (RAM) 413. In the RAM 413, various programs and data required for the operation of the electronic device 410 may also be stored. The processor 411, the ROM 412, and the RAM 413 are connected to each other through a bus 414. An input/output (I/O) interface 415 is also connected to bus 414.
Various components in the electronic device 410 are connected to the I/O interface 415, including: an input unit 416 such as a keyboard, a mouse, etc.; an output unit 417 such as various types of displays, speakers, and the like; a storage unit 418, such as a magnetic disk, optical disk, or the like; and a communication unit 419 such as a network card, modem, wireless communication transceiver, etc. The communication unit 419 allows the electronic device 410 to exchange information/data with other devices through a computer network such as the internet and/or various telecommunication networks.
The processor 411 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 411 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, digital Signal Processors (DSPs), and any suitable processor, controller, microcontroller, etc. The processor 411 performs the various methods and processes described above, such as database information alignment methods.
In some embodiments, the method of information alignment of a database may be implemented as a computer program tangibly embodied on a computer-readable storage medium, such as storage unit 418. In some embodiments, some or all of the computer program may be loaded and/or installed onto the electronic device 410 via the ROM 412 and/or the communication unit 419. When the computer program is loaded into RAM 413 and executed by processor 411, one or more steps of the database information alignment method described above may be performed. Alternatively, in other embodiments, the processor 411 may be configured to perform the information comparison method of the database in any other suitable manner (e.g., by means of firmware).
Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuitry, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), systems-on-a-chip (SOCs), complex Programmable Logic Devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs, the one or more computer programs may be executed and/or interpreted on a programmable system including at least one programmable processor, which may be a special purpose or general-purpose programmable processor, that may receive data and instructions from, and transmit data and instructions to, a storage system, at least one input device, and at least one output device.
A computer program for carrying out methods of the present application may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data base information alignment apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be implemented. The computer program may execute entirely on the machine, partly on the machine, as a stand-alone software package, partly on the machine and partly on a remote machine or entirely on the remote machine or server.
In the context of the present application, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. The computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) through which a user can provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic input, speech input, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a background component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such background, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), blockchain networks, and the internet.
The computing system may include clients and servers. The client and server are typically remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical hosts and VPS service are overcome.
It should be appreciated that various forms of the flows shown above may be used to reorder, add, or delete steps. For example, the steps described in the present application may be performed in parallel, sequentially, or in a different order, so long as the desired results of the technical solution of the present application are achieved, and the present application is not limited herein.
The above embodiments do not limit the scope of the present application. It will be apparent to those skilled in the art that various modifications, combinations, sub-combinations and alternatives are possible, depending on design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present application should be included in the scope of the present application.
Claims (10)
1. An information comparison method of a database, wherein the method is performed by a database comparison platform, the method comprising:
responding to a database connection information input request of a user terminal, and acquiring database connection information of at least two types of databases; the database connection information comprises basic configuration information, type configuration information and comparison task configuration information;
responding to a comparison task creation request of a user terminal, and determining at least two target databases;
and responding to a comparison task starting request of the user terminal, and determining a comparison result of each target database group according to the database connection information.
2. The method of claim 1, wherein the base configuration information comprises a server address, a server port, and a database identification; the type configuration information comprises an application identifier, a database type and a database fragment identifier.
3. The method of claim 1, wherein the comparison task configuration information includes a task type, a source database identification, and a destination database identification; the task types comprise data object comparison, data detail comparison, storage process comparison, user permission comparison, view comparison and trigger comparison.
4. The method of claim 1, wherein the database connection information further comprises routing configuration information;
the routing configuration information comprises an application identifier, a routing type, a source database identifier and a destination database identifier; the route type comprises a database route and a table route;
if the route type is a table route, the route configuration information further comprises a table identifier, a route algorithm identifier and a route field identifier.
5. The method of claim 1, wherein the database connection information further comprises mapping configuration information; the mapping relation configuration information comprises data object mapping relation configuration and field type mapping relation configuration.
6. The method of claim 1, wherein the comparison result comprises a comparison task identifier, a source database object type, a source database object value, a destination database object type, a destination database object value, a consistency determination result, and a cause of inconsistency;
wherein the object types include tables, fields, indexes, stored procedures, and views.
7. The method of claim 1, wherein after determining the comparison of each two target databases, the method further comprises:
and responding to the comparison result downloading request of the user terminal, obtaining the comparison result of each target database group, and generating a comparison result table.
8. An information comparison device of a database, wherein the device is configured on a database comparison platform, and comprises:
the connection information acquisition module is used for responding to a database connection information input request of the user terminal and acquiring database connection information of at least two types of databases; the database connection information comprises basic configuration information, type configuration information and comparison task configuration information;
the target database determining module is used for determining at least two target databases in response to a comparison task creating request of the user terminal;
and the comparison result determining module is used for responding to the comparison task starting request of the user terminal and determining the comparison result of each target database group according to the database connection information.
9. An electronic device, the electronic device comprising:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein,
the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the method of information comparison of the database of any one of claims 1-7.
10. A computer readable storage medium storing computer instructions for causing a processor to implement the method of information comparison of a database according to any one of claims 1-7 when executed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311214129.8A CN117171214A (en) | 2023-09-20 | 2023-09-20 | Database information comparison method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311214129.8A CN117171214A (en) | 2023-09-20 | 2023-09-20 | Database information comparison method and device, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117171214A true CN117171214A (en) | 2023-12-05 |
Family
ID=88931730
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311214129.8A Pending CN117171214A (en) | 2023-09-20 | 2023-09-20 | Database information comparison method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117171214A (en) |
-
2023
- 2023-09-20 CN CN202311214129.8A patent/CN117171214A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN116611411A (en) | Business system report generation method, device, equipment and storage medium | |
| CN116545905A (en) | Service health detection method and device, electronic equipment and storage medium | |
| CN115905322A (en) | Service processing method and device, electronic equipment and storage medium | |
| CN116028517A (en) | Fusion database system and electronic equipment | |
| CN117171214A (en) | Database information comparison method and device, electronic equipment and storage medium | |
| CN115454971A (en) | Data migration method and device, electronic equipment and storage medium | |
| CN115203158A (en) | Data comparison method, device, equipment and storage medium | |
| CN115309730A (en) | Data auditing method and device, electronic equipment and storage medium | |
| CN113609145B (en) | Database processing method, device, electronic equipment, storage medium and product | |
| CN117667897A (en) | Data migration detection method, device, equipment and medium | |
| CN115686612A (en) | Project delivery method and device, electronic equipment and storage medium | |
| CN116932033A (en) | Component packaging method and device, electronic equipment and storage medium | |
| CN117494216A (en) | Configuration method, device, equipment and medium of sensitive information | |
| CN117555581A (en) | Method, device, equipment and storage medium for generating calibration description file | |
| CN116302371A (en) | Transaction visibility judging method, device, equipment and storage medium | |
| CN116955394A (en) | Data query method, device, equipment and medium | |
| CN115576977A (en) | Data paging query method and device, electronic equipment and storage medium | |
| CN116401269A (en) | Data query method and device, electronic equipment and storage medium | |
| CN117093274A (en) | Application running stack analysis method, device, equipment and storage medium | |
| CN118132533A (en) | Data processing method, device, equipment and storage medium | |
| CN118012936A (en) | Data extraction method, device, equipment and storage medium | |
| CN117032756A (en) | Software updating method and device, electronic equipment and storage medium | |
| CN117667704A (en) | Configuration parameter detection method and device, electronic equipment and storage medium | |
| CN115455029A (en) | Battery replacement data acquisition method and device, electronic equipment and storage medium | |
| CN115766260A (en) | Method, device, equipment and storage medium for generating network access white list |
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 |