Table structure comparison method and device in database, computer equipment and storage medium

A database and table structure technology, applied in database indexing, database updating, structured data retrieval, etc., can solve the problems of manual detection, waste of time and manpower, etc., and achieve the effect of improving efficiency and saving human resources

Pending Publication Date: 2019-09-20
PING AN TECH (SHENZHEN) CO LTD
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The main purpose of this application is to provide a table structure comparison method, device, computer equipment and storage medium in the database, aiming at solving the problem of manual detection by testers in the prior art, wasting time and manpower

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Table structure comparison method and device in database, computer equipment and storage medium
  • Table structure comparison method and device in database, computer equipment and storage medium
  • Table structure comparison method and device in database, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0048] In order to make the purpose, technical solution and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, and are not intended to limit the present application.

[0049] refer to figure 1 , the embodiment of the present application provides a table structure comparison method in a database, the database is a database based on the GoldenGate synchronization tool, including:

[0050] S1. Obtain a list of synchronization table names recorded with synchronization tables and database connection strings of each synchronization table name, wherein the synchronization table includes an upstream table and a downstream table in a one-to-one mapping relationship;

[0051] S2. Obtain the first upstream table name of the first upstream table an...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a table structure comparison method and device in a database, computer equipment and a storage medium. The database is a database based on a GoldenGate synchronization tool. The method comprises the following steps of: obtaining: synchronous table names recorded with synchronous tables and a list of database connection strings of the synchronous table names are obtained; and then, through the configuration information in the list and the preset upstream table information and downstream table information matching requirements, the judgment process of whether the upstream table and the downstream table are matched or not can be automatically completed, testing personnel do not need to purchase and detect, manpower resources are saved, and the detection efficiency is improved. According to the invention, the matching process of the upstream table and the downstream table is completed before data synchronization, so that the situation that data cannot be synchronized in the subsequent data synchronization process is reduced.

Description

technical field [0001] This application relates to the field of data synchronization, in particular to a method, device, computer equipment and storage medium for table structure comparison in a database. Background technique [0002] In the process of data testing, there is often an operation to synchronize the data of the upstream table to the existing table. Testers usually use the GoldenGate tool to synchronize the data of the upstream table to the downstream table. In order to test the effect and stability, before the test, it is necessary to check whether the downstream table can insert the data of the upstream table. The existing technology is manual detection by the tester, which wastes time and manpower. Contents of the invention [0003] The main purpose of this application is to provide a table structure comparison method, device, computer equipment and storage medium in the database, aiming to solve the problem of wasting time and manpower in the prior art by m...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F16/22G06F16/23
CPCG06F16/2365G06F16/2282Y02D10/00
Inventor 杜思琪
Owner PING AN TECH (SHENZHEN) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap