Supercharge Your Innovation With Domain-Expert AI Agents!

Database comparison method based on ODBC access

A database and data technology, applied in database indexing, database design/maintenance, structured data retrieval, etc., can solve problems such as inability to directly compare data, cannot directly communicate data, and does not provide database comparison functions, so as to save software development cost, the effect of solving cost

Pending Publication Date: 2020-11-20
PLA NO 63686 CORPS
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In general, database providers will provide functions such as data migration, data import and export, and data backup. If the databases to be compared are databases of the same manufacturer and type, the two databases can communicate with each other, but most of them do not provide database comparison functions; For databases from different vendors, it is basically impossible to directly communicate data, so it is impossible to directly compare data

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
  • Database comparison method based on ODBC access
  • Database comparison method based on ODBC access
  • Database comparison method based on ODBC access

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] The present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments.

[0033] This embodiment provides a method for comparing databases based on ODBC access. The method acquires database content through ODBC access technology, and provides a comparison result of relational databases. The input data of this method is two sets of ODBC connection information, and the output information is the comparison result of two sets of database tables.

[0034] The basic steps of the method are as follows:

[0035] Step 1. If the ODBC connection has not been established in the environment, create a database connection handle through SQLSetEnvAttr, and return an error directly if the connection fails. Then create a database connection handle through SQLConnect.

[0036] Step 2. Call SQLTables to obtain all table information in the database, and call SQLColumns to obtain the field information content of each table.

[0037] S...

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 relates to a database comparison method based on ODBC access. The method is based on an ODBC access technology, and is mainly used for comparing structures and contents of two relationaldatabases. The method is composed of four parts, and a database comparison method based on ODBC access is jointly formed. The four parts are respectively an extended text similarity calculation method, a formatted text comparison method based on weighted optimization, a database content comparison method based on ODBC access and a database comparison method based on ODBC access. The database comparison method irrelevant to a database manufacturer can be achieved, the comparison result is an optimal scheme, and the database comparison method can be applied to the fields related to relational databases.

Description

technical field [0001] The invention belongs to the application field of computer software, relates to the application of relational databases, can be used for relational database content comparison, and specifically relates to a database comparison method based on ODBC access. Background technique [0002] In the background of database applications, in order to understand the data changes or data consistency in different businesses or different periods, it is often necessary to compare two databases. The two databases to be compared can be of the same type or heterogeneous different types of databases. [0003] In general, database providers will provide functions such as data migration, data import and export, and data backup. If the databases to be compared are databases of the same manufacturer and type, the two databases can communicate with each other, but most of them do not provide database comparison functions; For databases from different vendors, basically no dir...

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/21G06F16/22G06K9/62
CPCG06F16/21G06F16/2282G06F18/22
Inventor 李永刚侯亚威胡上成郭力兵汪毅毛文吴云杨海民伊瑞海邓育民黄为
Owner PLA NO 63686 CORPS
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com