Structure comparison method and apparatus for databases

A technology of structure comparison and database, applied in the field of database, can solve the problems such as the inability to visually present the specific difference information of the database structure, and the complicated operation of the structure comparison method, and achieve the effect of simple operation

Inactive Publication Date: 2017-03-08
ZTE CORP
View PDF0 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The main purpose of the present invention is to provide a database structure comparison method and device, aiming to solve the technical problem that the existing database structure comparison method is complicated to operate and cannot intuitively present the specific difference information of the database structure

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
  • Structure comparison method and apparatus for databases
  • Structure comparison method and apparatus for databases
  • Structure comparison method and apparatus for databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0055] It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0056] The invention provides a database structure comparison method.

[0057] refer to figure 1 , figure 1 It is a schematic flowchart of the first embodiment of the database structure comparison method of the present invention.

[0058] In this embodiment, the structure comparison method of the database includes:

[0059] Step S10, acquiring database information of the first database and the second database;

[0060] The mobile terminal acquires database information of the first database and the second data. The mobile terminal is a device for comparing the structure differences between two databases, including but not limited to computers and tablet computers. In this embodiment, the mobile terminal is a computer. The first database and the second database include but are not limited to SqlServer, oracle, sys...

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 structure comparison method for databases. The structure comparison method comprises the steps of obtaining database information of a first database and a second database; correspondingly reading data dictionary information of the first database and the second database according to the database information; and performing comparison on the data dictionary information of the first database and the data dictionary information of the second database to obtain structural difference information of the first database and the second database. The invention also discloses a structure comparison apparatus for the databases. The invention provides the structure difference comparison method, which is simple to operate, for the databases; and the specific structural difference information between two databases can be acquired through comparison.

Description

technical field [0001] The invention relates to the field of databases, in particular to a database structure comparison method and device. Background technique [0002] A database is a warehouse that organizes, stores and manages data according to its data structure. The storage of any application data is inseparable from the database. For large-scale applications, multiple databases may be created to store different information in different categories. With the development, the released version of the application will be continuously upgraded (for example, from V1.0 version Upgrade to V1.1 version), and the upgrade between versions often involves changes in the structure of the database, which is reflected by writing database upgrade scripts. What developers and testers expect is that the function and database structure of the V1.1 version upgraded from V1.0 and the newly installed V1.1 version should be completely consistent. This requires comparing whether there is a d...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/00G06F16/21
Inventor 孔艳花张丽丽
Owner ZTE CORP
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