CN108304522A - Comparison method, device and the terminal device of difference between a kind of database - Google Patents
Comparison method, device and the terminal device of difference between a kind of database Download PDFInfo
- Publication number
- CN108304522A CN108304522A CN201810071670.0A CN201810071670A CN108304522A CN 108304522 A CN108304522 A CN 108304522A CN 201810071670 A CN201810071670 A CN 201810071670A CN 108304522 A CN108304522 A CN 108304522A
- Authority
- CN
- China
- Prior art keywords
- database
- information
- comparison
- difference
- data
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
Abstract
The present invention is suitable for database field, provides comparison method, device and the terminal device of difference between a kind of database.This method includes：Obtain first database and the second database and comparison information；The first database and second database are compared based on the comparison information and obtain difference results information；Export the difference results information.The present invention can be compared different databases based on the demand of user, i.e. comparison information, have flexibility in the selection of comparison information, and improve comparison efficiency, have stronger practicability and ease for use.
Description
Technical field
The invention belongs to the comparison method, device of difference between database technical field more particularly to a kind of database and
Terminal device.
Background technology
Database (DataBase, DB) be one be stored for a long time in it is in computer, organized, have it is shared, uniformly
The data acquisition system of management.It is a computer software for being stored and being managed data by database structure.With data
The development of library technology, database are widely used in all trades and professions, the table of multiple and different types are typically set up in database, is passed through
Each table records different data.
The service life and iteration version number of one system increase, and the data of database can also increase therewith, database
Structure may also change, therefore the comparison between different editions database is particularly important.
At present generally using ETL (Extract-Transform-Load data warehouse technologys) extractions, conversion and load number
According to different editions database to be compared, the operation of comparison procedure is cumbersome.
Therefore, it is necessary to a kind of scheme be proposed, to solve the above problems.
Invention content
In view of this, an embodiment of the present invention provides the comparison methods, device of difference between a kind of database and terminal to set
Standby, to solve the problems, such as the comparison method of difference between database in the prior art, there are cumbersome.
The first aspect of the embodiment of the present invention provides a kind of comparison method of difference between database, including：
Obtain first database and the second database and comparison information；
Acquisition difference results are compared to the first database and second database based on the comparison information
Information；
Export the difference results information.
Optionally, before obtaining first database and the second database, further include：
Judge whether the first database and second database are inter-library；
If so, establishing the connection between the first database and second database.
Optionally, the comparison information includes comparing information and/or database structure comparison information；
When the comparison information that user selects for comparing information when, based on the comparison information to the first database
Acquisition difference results information, which is compared, with second database includes：
Comparison information carries out the first database and second database ratio of each item data based on the data
It is right, obtain data difference result information；
When the comparison information that user selects for database structure comparison information when, based on the comparison information to described first
Acquisition difference results information is compared in database and second database：
Library structure comparison information carries out database to the first database and second database based on the data
The comparison of structure obtains database structure difference results information；
When the comparison information that user selects for comparing information and database structure comparison information when, be based on the comparison
Acquisition difference results information is compared to the first database and second database in information：
Comparison information based on the data carries out the first database and second database ratio of each item data
It is right, obtain data difference result information；And it is based on database structure comparison information, data are carried out to second database
The comparison of library structure obtains database structure difference results information.
Optionally, based on the comparison information to the first database and second database be compared obtain it is poor
Different result information includes：
Obtain the tables of data of the tables of data and second database of the first database；
Call structured query language SQL statement, based on the comparison information to the tables of data of the first database and
The tables of data of second database carries out additive operation, obtains differentiation information.
Optionally, the difference results information includes difference total amount, exports the difference results information and includes：
Difference total amount, every difference results information and/or SQL statement corresponding with the items difference results information are shown
Show at interface.
The second aspect of the embodiment of the present invention provides a kind of comparison device of difference between database, including：
First acquisition module, for obtaining first database and the second database and comparison information；
Second acquisition module is compared the first database and second database based on the comparison information
Obtain difference results information；
Output module, for exporting the difference results information.
Optionally, the comparison device of difference further includes between the database：
Judgment module, for judging whether the first database and second database are inter-library；
Module is established, for if so, establishing the connection between the first database and second database.
Optionally, the second acquisition module includes：
First comparing unit, for comparison information based on the data to the first database and second database
The comparison of each item data is carried out, data difference result information is obtained；
Optionally, the second acquisition module includes：
Second comparing unit, for library structure comparison information based on the data to the first database and described second
Database carries out the comparison of database structure, obtains database structure difference results information；
Optionally, the second acquisition module includes：
Third comparing unit, for comparison information based on the data, to the first database and second data
Library carries out the comparison of each item data, obtains data difference result information；And it is based on database structure comparison information, to described
Second database carries out the comparison of database structure, obtains database structure difference results information.
Optionally, second acquisition module includes：
Acquiring unit, the tables of data of tables of data and second database for obtaining the first database；
Call unit, for calling structured query language SQL statement, based on the comparison information to first data
The tables of data in library and the tables of data of second database carry out additive operation, obtain differentiation information.
Optionally, the difference results information includes difference total amount, and the output module includes：
Display unit, for by difference total amount, every difference results information and/or with every difference results information pair
The SQL statement answered is shown in interface.
The third aspect of the embodiment of the present invention provides a kind of terminal device, including memory, processor and is stored in
In the memory and the computer program that can run on the processor, when the processor executes the computer program
The step of realizing method in first aspect.
The fourth aspect of the embodiment of the present invention provides a kind of computer readable storage medium, the computer-readable storage
Media storage has computer program, when the computer program is executed by processor in realization first aspect the step of method.
In embodiments of the present invention, by obtaining first database and the second database and comparison information；Based on described
Comparison information is compared the first database and second database and obtains difference results information, exports the difference
Result information, can be based on the demand of user, i.e. different databases is compared in comparison information, in the selection of comparison information
It is upper that there is flexibility, and comparison efficiency is improved, there is stronger practicability and ease for use.
Description of the drawings
It to describe the technical solutions in the embodiments of the present invention more clearly, below will be to embodiment or description of the prior art
Needed in attached drawing be briefly described, it should be apparent that, the accompanying drawings in the following description be only the present invention some
Embodiment for those of ordinary skill in the art without having to pay creative labor, can also be as attached such as these
Figure obtains other attached drawings.
Fig. 1 be the embodiment of the present invention one provide database between difference comparison method implementation process schematic diagram；
Fig. 2 be the preferred embodiment of the present invention provide database between difference comparison method implementation process schematic diagram；
Fig. 3 is the specific implementation flow schematic diagram of step S102 in the embodiment of the present invention one；
Fig. 4 is the structure diagram of the comparison device of difference between database provided by Embodiment 2 of the present invention.
Fig. 5 is the schematic diagram for the terminal device that the embodiment of the present invention three provides.
Specific implementation mode
In being described below, for illustration and not for limitation, it is proposed that such as tool of particular system structure, technology etc
Body details, to understand thoroughly the embodiment of the present invention.However, it will be clear to one skilled in the art that there is no these specific
The present invention can also be realized in the other embodiments of details.In other situations, it omits to well-known system, device, electricity
The detailed description of road and method, in case unnecessary details interferes description of the invention.
It should be appreciated that ought use in this specification and in the appended claims, the instruction of term " comprising " is described special
Sign, entirety, step, operation, the presence of element and/or component, but be not precluded one or more of the other feature, entirety, step,
Operation, element, component and/or its presence or addition gathered.
It is also understood that the term used in this description of the invention is merely for the sake of the mesh for describing specific embodiment
And be not intended to limit the present invention.As description of the invention and it is used in the attached claims, unless on
Other situations are hereafter clearly indicated, otherwise " one " of singulative, "one" and "the" are intended to include plural form.
It will be further appreciated that the term "and/or" used in description of the invention and the appended claims is
Refer to any combinations and all possible combinations of one or more of associated item listed, and includes these combinations.
As used in this specification and in the appended claims, term " if " can be according to context quilt
Be construed to " when ... " or " once " or " in response to determination " or " in response to detecting ".Similarly, phrase " if it is determined that "
Or " if detecting [described condition or event] " can be interpreted to mean according to context " once it is determined that " or " in response to
Determine " or " once detecting [described condition or event] " or " in response to detecting [described condition or event] ".
In order to illustrate technical solutions according to the invention, illustrated below by specific embodiment.It needs to illustrate
It is that following embodiment is applied to the system comprising filming apparatus.
Embodiment one
Fig. 1 show the embodiment of the present invention one provide database between difference comparison method implementation process signal
Figure.As shown in Figure 1, the comparison method of difference specifically may include following steps between the database：
Step S101：Obtain first database and the second database and comparison information.
Wherein, it can also be random time length that second database, which can be the upgraded version of the first database,
Two versions on two time points in period, it might even be possible to be different the database of two programs.The comparison information can
Can also be what user selected to be input by user, wherein the input mode of user can be inputted by keyboard, also may be used
Being inputted by microphone voice, other any input modes that may be implemented are can also be, then be not limited thereto；Its
In, the mode of user's selection can be that the message popped up according to dialog box selects, and can also be to be carried out according to drop-down menu
Selection, can also be other any selection modes that may be implemented, is not limited thereto.Optionally, as the embodiment of the present invention
A preferred embodiment further include as shown in Fig. 2, before obtaining first database and the second database：
Step S201：Judge whether the first database and second database are inter-library, if so, thening follow the steps
S202, if it is not, then directly acquiring first database and second database.
Illustratively, if the first database and second database belong to local data base, that is, belong to same
A terminal device, then show it is no inter-library, if in the first database and second database one belong to local data
Library, another is not belonging to local data base, it is determined that the first database and second database are inter-library.
Step S202：Then establish the connection between the first database and second database.
When being determined that the first database and second database data are inter-library in step S201, then described is established
Connection between one database and second database, such as a link (such as db_link) is established, it is linked at by this
Local library accesses remote data base, and remote data base is one in first database and second database data.
Wherein, the comparison information can be comparing information, can also be database structure comparison information, can be with
It is comparing information and database structure comparison information.Comparison information can be that user is input to interface, can also be basis
Keyword input by user, which pops up corresponding option, allows user to select, and comparison information is determined according to the clicking operation of user
Content.For example, the field name of database-name, data-base remote connection name, database table name, database table can be automatic
It matches, can choose comparison information by drop-down option in the corresponding Option Box in interface, the partial words of title can also be keyed in
Female auto-speed matches related comparison information.
It should be noted that comparison information includes but not limited to comparing information and database structure comparison information, also
It may include the comparison information of more, be not limited thereto.
Step S102：Acquisition is compared to the first database and second database based on the comparison information
Difference results information.
Optionally, based on the comparison information to the first database and second database be compared obtain it is poor
Different result information includes：
Step S301：Obtain the tables of data of the tables of data and second database of the first database.
First database and the second database are parsed respectively, obtain the tables of data and the second data of first database
The tables of data in library.
Step S302：Structured query language SQL statement is called, based on the comparison information to the first database
Tables of data and the tables of data of second database carry out additive operation, obtain differentiation information.
Wherein, structured query language SQL statement can be as follows：
The sub- SQL of #
Sql_1=" select%s from%s where%s " % (field1, tb1, cond1)
Sql_2=" select%s from%s@%s where%s " % (field2, tb2, db_link, cond2)
The total SQL of #
Sql=" select count (*) from (((%s) minus (%s)) union all ((%s) minus (%
S))) " % (sql_1, sql_2, sql_2, sql_1)
Call above-mentioned SQL statement, tables of data and second database of the comparison information to the first database
Tables of data carry out additive operation.Specifically it may include：It inquires in first database and the second database and needs the data compared
The quantity of the field of table, the attribute of title and each field, judge field quantity and field name, if all identical, judge it
Attribute, finally output are differentiated result and specific field name and its attribute, are obtained based on differentiation result and specific field name and its attribute
Obtain differentiation information.
Optionally, when the comparison information that user selects for comparing information when, based on the comparison information to described the
Acquisition difference results information is compared in one database and second database：
Comparison information carries out the first database and second database ratio of each item data based on the data
It is right, obtain data difference result information.
Wherein, the comparison of each item data may include the ratio of the comparison of database-name, the comparison of field and tables of data
It is right.
Optionally, when the comparison information that user selects for database structure comparison information when, be based on the comparison information pair
Acquisition difference results information is compared in the first database and second database：
Library structure comparison information carries out database to the first database and second database based on the data
The comparison of structure obtains database structure difference results information.
Wherein, the comparison of database structure can include but is not limited to database table, table type, table length, index, outer
The comparison of key and trigger.
Optionally, when the comparison information that user selects for comparing information and database structure comparison information when, be based on
Acquisition difference results information is compared to the first database and second database in the comparison information：
Comparison information based on the data carries out the first database and second database ratio of each item data
It is right, obtain data difference result information；And it is based on database structure comparison information, data are carried out to second database
The comparison of library structure obtains database structure difference results information.
Such case in the present embodiment, the comparing information and database structure comparison information selected according to user,
It is compared respectively, can also be to be carried out at the same time comparison, in the priority of comparison although it should be noted that be to compare respectively
Sequentially it is not construed as limiting.
Step S103：Export the difference results information.
Wherein, including the file of difference results information can be downloaded by interface.This document be include difference results information
Report is compared, can be the form of excel.
Optionally, the difference results information includes difference total amount, then exports the difference results information and include：
Difference total amount, every difference results information and/or SQL statement corresponding with the items difference results information are shown
Show at interface.
Wherein, difference total amount includes but not limited to the total amount for the field being had differences in tables of data, every difference results letter
Breath includes but not limited to the difference results information of every data difference result information and database structure.
SQL statement corresponding with the items difference results information is shown in interface and clearly corresponds to difference knot convenient for user
Fruit information and SQL statement.If in executing mistake occurs for the SQL statement, catches grab mistake from the background, the mistake of SQL syntax class is straight
It connects in the corresponding column for being illustrated in interface, in order to which user intuitively obtains wrong place and is changed accordingly.
In embodiments of the present invention, by obtaining first database and the second database and comparison information；Based on described
Comparison information is compared the first database and second database and obtains difference results information, exports the difference
Result information, can be based on the demand of user, i.e. different databases is compared in comparison information, in the selection of comparison information
It is upper that there is flexibility, and comparison efficiency is improved, there is stronger practicability and ease for use.
It should be understood that the size of the serial number of each step is not meant that the order of the execution order in above-described embodiment, each process
Execution sequence should be determined by its function and internal logic, the implementation process without coping with the embodiment of the present invention constitutes any limit
It is fixed.
Embodiment two
Referring to FIG. 4, it illustrates the structures of the comparison device of difference between database provided by Embodiment 2 of the present invention
Block diagram.The comparison device 40 of difference includes between database：First acquisition module 41, the second acquisition module 42 and output module
43.Wherein, the concrete function of each module is as follows：
First acquisition module 41, for obtaining first database and the second database and comparison information.
Second acquisition module 42 compares the first database and second database based on the comparison information
To obtaining difference results information.
Output module 43, for exporting the difference results information.
Optionally, the comparison device 40 of difference further includes between the database：
Judgment module, for judging whether the first database and second database are inter-library；
Module is established, for if so, establishing the connection between the first database and second database.
Optionally, the second acquisition module 42 includes：
First comparing unit, for comparison information based on the data to the first database and second database
The comparison of each item data is carried out, data difference result information is obtained；
Optionally, the second acquisition module 42 includes：
Second comparing unit, for library structure comparison information based on the data to the first database and described second
Database carries out the comparison of database structure, obtains database structure difference results information；
Optionally, the second acquisition module 42 includes：
Third comparing unit, for comparison information based on the data, to the first database and second data
Library carries out the comparison of each item data, obtains data difference result information；And it is based on database structure comparison information, to described
Second database carries out the comparison of database structure, obtains database structure difference results information.
Optionally, second acquisition module 42 includes：
Acquiring unit, the tables of data of tables of data and second database for obtaining the first database；
Call unit, for calling structured query language SQL statement, based on the comparison information to first data
The tables of data in library and the tables of data of second database carry out additive operation, obtain differentiation information.
Optionally, the difference results information includes difference total amount, and the output module includes：
Display unit, for by difference total amount, every difference results information and/or with every difference results information pair
The SQL statement answered is shown in interface.
In embodiments of the present invention, by obtaining first database and the second database and comparison information；Based on described
Comparison information is compared the first database and second database and obtains difference results information, exports the difference
Result information, can be based on the demand of user, i.e. different databases is compared in comparison information, in the selection of comparison information
It is upper that there is flexibility, and comparison efficiency is improved, there is stronger practicability and ease for use.
Embodiment three
Fig. 5 is the schematic diagram for the terminal device that the embodiment of the present invention three provides.As shown in figure 5, the terminal of the embodiment is set
Standby 5 include：Processor 50, memory 51 and it is stored in the meter that can be run in the memory 51 and on the processor 50
Calculation machine program 52, for example, between database difference comparison method program.The processor 50 executes the computer program 52
Step between the above-mentioned each databases of Shi Shixian in the comparison method embodiment of difference, such as step S101 shown in FIG. 1 is extremely
S103.Alternatively, the processor 50 realizes the work(of each module in above-mentioned each device embodiment when executing the computer program 52
Can, for example, module 41 to 43 shown in Fig. 4 function.
Illustratively, the computer program 52 can be divided into one or more module/units, it is one or
Multiple module/units are stored in the memory 51, and are executed by the processor 50, to complete the present invention.Described one
A or multiple module/units can be the series of computation machine program instruction section that can complete specific function, which is used for
Implementation procedure of the computer program 52 in the terminal device 5 is described.For example, the computer program 52 can be divided
It is cut into acquisition module and analysis module, the concrete function of each module is as follows：
First acquisition module, for obtaining first database and the second database and comparison information；
Second acquisition module is compared the first database and second database based on the comparison information
Obtain difference results information；
Output module, for exporting the difference results information.
The terminal device 5 can be that the calculating such as desktop PC, notebook, palm PC and cloud server are set
It is standby.The terminal device may include, but be not limited only to, processor 50, memory 51.It will be understood by those skilled in the art that Fig. 5
The only example of terminal device does not constitute the restriction to terminal device, may include components more more or fewer than diagram,
Certain components or different components are either combined, such as the terminal device can also connect including input-output equipment, network
Enter equipment, bus etc..
Alleged processor 50 can be central processing unit (Central Processing Unit, CPU), can also be
Other general processors, digital signal processor (Digital Signal Processor, DSP), application-specific integrated circuit
(Application Specific Integrated Circuit, ASIC), ready-made programmable gate array (Field-
Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic,
Discrete hardware components etc..General processor can be microprocessor or the processor can also be any conventional processor
Deng.
The memory 51 can be the internal storage unit of the terminal device 5, such as the hard disk of terminal device 5 or interior
It deposits.The memory 51 can also be to be equipped on the External memory equipment of the terminal device 5, such as the terminal device 5
Plug-in type hard disk, intelligent memory card (Smart Media Card, SMC), secure digital (Secure Digital, SD) card dodge
Deposit card (Flash Card) etc..Further, the memory 51 can also both include the storage inside list of the terminal device 5
Member also includes External memory equipment.The memory 51 is for storing needed for the computer program and the terminal device
Other programs and data.The memory 51 can be also used for temporarily storing the data that has exported or will export.
It is apparent to those skilled in the art that for convenience of description and succinctly, only with above-mentioned each work(
Can unit, module division progress for example, in practical application, can be such as needs and by above-mentioned function distribution by different work(
Energy unit, module are completed, i.e., the internal structure of described device are divided into different functional units or module, to complete above retouch
The all or part of function of stating.Each functional unit, module in embodiment can be integrated in a processing unit, can also
It is that each unit physically exists alone, can also be during two or more units be integrated in one unit, above-mentioned integrated list
The form that hardware had both may be used in member is realized, can also be realized in the form of SFU software functional unit.In addition, each functional unit,
The specific name of module is also only to facilitate mutually distinguish, the protection domain being not intended to limit this application.In above system
The specific work process of unit, module, can refer to corresponding processes in the foregoing method embodiment, and details are not described herein.
In the above-described embodiments, it all emphasizes particularly on different fields to the description of each embodiment, is not described in detail or remembers in some embodiment
The part of load may refer to the associated description of other embodiments.
Those of ordinary skill in the art may realize that lists described in conjunction with the examples disclosed in the embodiments of the present disclosure
Member and algorithm steps can be realized with the combination of electronic hardware or computer software and electronic hardware.These functions are actually
It is implemented in hardware or software, depends on the specific application and design constraint of technical solution.Professional technician
Each specific application can be used different methods to achieve the described function, but this realization is it is not considered that exceed
The scope of the present invention.
In embodiment provided by the present invention, it should be understood that disclosed device/terminal device and method, it can be with
It realizes by another way.For example, device described above/terminal device embodiment is only schematical, for example, institute
The division of module or unit is stated, only a kind of division of logic function, formula that in actual implementation, there may be another division manner, such as
Multiple units or component can be combined or can be integrated into another system, or some features can be ignored or not executed.Separately
A bit, shown or discussed mutual coupling or direct-coupling or communication connection can be by some interfaces, device
Or INDIRECT COUPLING or the communication connection of unit, can be electrical, machinery or other forms.
It is described to be converted to the unit that separating component illustrates and may or may not be physically separated, be converted to list
The component of member display may or may not be physical unit, you can be located at a place, or may be distributed over
In multiple network element.It can need to select some or all of unit therein as actual come realizing this embodiment scheme
Purpose.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, it can also
It is that each unit physically exists alone, it can also be during two or more units be integrated in one unit.Above-mentioned integrated list
The form that hardware had both may be used in member is realized, can also be realized in the form of SFU software functional unit.
If the integrated module/unit, which is realized in the form of SFU software functional unit and converts, is independent product sale
Or it in use, can be stored in a computer read/write memory medium.Based on this understanding, the present invention realizes above-mentioned reality
All or part of flow in a method is applied, relevant hardware can also be instructed to complete by computer program, it is described
Computer program can be stored in a computer readable storage medium, the computer program when being executed by processor, it can be achieved that
The step of above-mentioned each embodiment of the method.Wherein, the computer program includes computer program code, the computer program
Code can be source code form, object identification code form, executable file or certain intermediate forms etc..Computer-readable Jie
Matter may include：Can carry the computer program code any entity or device, recording medium, USB flash disk, mobile hard disk,
Magnetic disc, CD, computer storage, read-only memory (ROM, Read-Only Memory), random access memory (RAM,
Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium etc..It should be noted that described
The content that computer-readable medium includes can carry out increase and decrease appropriate such as legislation in jurisdiction and the requirement of patent practice,
Such as in certain jurisdictions, such as legislation and patent practice, computer-readable medium does not include electric carrier signal and telecommunications letter
Number.
Embodiment described above is merely illustrative of the technical solution of the present invention, rather than its limitations；Although with reference to aforementioned reality
Applying example, invention is explained in detail, it will be understood by those of ordinary skill in the art that：It still can be to aforementioned each
Technical solution recorded in embodiment is modified or equivalent replacement of some of the technical features；And these are changed
Or replace, the spirit and scope for various embodiments of the present invention technical solution that it does not separate the essence of the corresponding technical solution should all
It is included within protection scope of the present invention.
Claims (10)
1. the comparison method of difference between a kind of database, which is characterized in that including：
Obtain first database and the second database and comparison information；
The first database and second database are compared based on the comparison information and obtain difference results information；
Export the difference results information.
2. the comparison method of difference between database as described in claim 1, which is characterized in that obtain first database and the
Before two databases, further include：
Judge whether the first database and second database are inter-library；
If so, establishing the connection between the first database and second database.
3. the comparison method of difference between database as described in claim 1, which is characterized in that the comparison information includes number
According to comparison information and/or database structure comparison information；
When the comparison information that user selects for comparing information when, based on the comparison information to the first database and institute
State the second database be compared obtain difference results information include：
Comparison information carries out the first database and second database comparison of each item data based on the data, obtains
Obtain data difference results information；
When the comparison information that user selects for database structure comparison information when, based on the comparison information to first data
Acquisition difference results information is compared in library and second database：
Library structure comparison information carries out database structure to the first database and second database based on the data
Comparison, obtain database structure difference results information；
When the comparison information that user selects for comparing information and database structure comparison information when, be based on the comparison information
Acquisition difference results information, which is compared, to the first database and second database includes：
Comparison information based on the data carries out the first database and second database comparison of each item data,
Obtain data difference result information；And it is based on database structure comparison information, database knot is carried out to second database
The comparison of structure obtains database structure difference results information.
4. the comparison method of difference between database as described in claim 1, which is characterized in that be based on the comparison information pair
Acquisition difference results information is compared in the first database and second database：
Obtain the tables of data of the tables of data and second database of the first database；
Structured query language SQL statement is called, based on the comparison information to the tables of data of the first database and described
The tables of data of second database carries out additive operation, obtains differentiation information.
5. the comparison method of difference between database as claimed in claim 3, which is characterized in that the difference results packet
Difference total amount is included, exporting the difference results information includes：
By difference total amount, every difference results information and/or SQL statement corresponding with every difference results information include
Interface.
6. the comparison device of difference between a kind of database, which is characterized in that including：
First acquisition module, for obtaining first database and the second database and comparison information；
Acquisition is compared to the first database and second database based on the comparison information in second acquisition module
Difference results information；
Output module, for exporting the difference results information.
7. the comparison device of difference between database as claimed in claim 6, which is characterized in that further include：
Judgment module, for judging whether the first database and second database are inter-library；
Module is established, for if so, establishing the connection between the first database and second database.
8. the comparison device of difference between database as claimed in claim 6, which is characterized in that the second acquisition module packet
It includes：
Acquiring unit, the tables of data of tables of data and second database for obtaining the first database；
Call unit, for calling structured query language SQL statement, based on the comparison information to the first database
Tables of data and the tables of data of second database carry out additive operation, obtain differentiation information.
9. a kind of terminal device, including memory, processor and it is stored in the memory and can be on the processor
The computer program of operation, which is characterized in that the processor realizes such as claim 1 to 5 when executing the computer program
The step of any one the method.
10. a kind of computer readable storage medium, the computer-readable recording medium storage has computer program, feature to exist
In when the computer program is executed by processor the step of any one of such as claim 1 to 5 of realization the method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810071670.0A CN108304522A (en) | 2018-01-25 | 2018-01-25 | Comparison method, device and the terminal device of difference between a kind of database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810071670.0A CN108304522A (en) | 2018-01-25 | 2018-01-25 | Comparison method, device and the terminal device of difference between a kind of database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108304522A true CN108304522A (en) | 2018-07-20 |
Family
ID=62866576
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810071670.0A Pending CN108304522A (en) | 2018-01-25 | 2018-01-25 | Comparison method, device and the terminal device of difference between a kind of database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108304522A (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109634986A (en) * | 2018-10-29 | 2019-04-16 | 平安科技（深圳）有限公司 | System monitoring method, device, computer and computer readable storage medium |
| CN110069571A (en) * | 2019-03-18 | 2019-07-30 | 平安普惠企业管理有限公司 | A kind of automated data control methods and device, electronic equipment |
| CN110175180A (en) * | 2019-04-26 | 2019-08-27 | 浙江蒲惠智造科技有限公司 | A kind of list management method, device, equipment and storage medium |
| CN110287182A (en) * | 2019-05-05 | 2019-09-27 | 浙江吉利控股集团有限公司 | A kind of data comparison method, apparatus, equipment and the terminal of big data |
| CN110362574A (en) * | 2019-06-27 | 2019-10-22 | 东软集团股份有限公司 | Data comparison method, device, storage medium and electronic equipment |
| CN111177119A (en) * | 2019-12-23 | 2020-05-19 | 平安资产管理有限责任公司 | Database-based full-data comparison method, device, equipment and storage medium |
| CN111459916A (en) * | 2020-04-16 | 2020-07-28 | 中国银行股份有限公司 | GBASE and ORAC L E database table comparison method and system |
| CN112241408A (en) * | 2020-09-30 | 2021-01-19 | 航天信息股份有限公司 | Temporary table-based invoice data batch storage method |
| CN113254456A (en) * | 2021-06-29 | 2021-08-13 | 山东浪潮通软信息科技有限公司 | Database data information comparison method, system, equipment and storage medium |
| CN113360404A (en) * | 2021-06-30 | 2021-09-07 | 中国工商银行股份有限公司 | Method and device for comparing metadata of database |
| CN113672639B (en) * | 2021-08-27 | 2024-04-26 | 成都长城开发科技股份有限公司 | Multi-type database table structure comparison method, system, equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140019371A1 (en) * | 2012-06-06 | 2014-01-16 | Oversite Data Services, Llc | System and Method for Foreclosure File Assessment and Acceleration |
| CN103823815A (en) * | 2012-11-19 | 2014-05-28 | 中国联合网络通信集团有限公司 | Server and database access method |
| CN106484739A (en) * | 2015-09-01 | 2017-03-08 | 中兴通讯股份有限公司 | The structure comparative approach of data base and device |
| CN107239484A (en) * | 2017-04-17 | 2017-10-10 | 腾讯科技（深圳）有限公司 | Database operation method, device and computer equipment |
-
2018
- 2018-01-25 CN CN201810071670.0A patent/CN108304522A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140019371A1 (en) * | 2012-06-06 | 2014-01-16 | Oversite Data Services, Llc | System and Method for Foreclosure File Assessment and Acceleration |
| CN103823815A (en) * | 2012-11-19 | 2014-05-28 | 中国联合网络通信集团有限公司 | Server and database access method |
| CN106484739A (en) * | 2015-09-01 | 2017-03-08 | 中兴通讯股份有限公司 | The structure comparative approach of data base and device |
| CN107239484A (en) * | 2017-04-17 | 2017-10-10 | 腾讯科技（深圳）有限公司 | Database operation method, device and computer equipment |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109634986A (en) * | 2018-10-29 | 2019-04-16 | 平安科技（深圳）有限公司 | System monitoring method, device, computer and computer readable storage medium |
| CN109634986B (en) * | 2018-10-29 | 2024-03-29 | 平安科技（深圳）有限公司 | System monitoring method, device, computer and computer readable storage medium |
| CN110069571A (en) * | 2019-03-18 | 2019-07-30 | 平安普惠企业管理有限公司 | A kind of automated data control methods and device, electronic equipment |
| CN110175180A (en) * | 2019-04-26 | 2019-08-27 | 浙江蒲惠智造科技有限公司 | A kind of list management method, device, equipment and storage medium |
| CN110287182A (en) * | 2019-05-05 | 2019-09-27 | 浙江吉利控股集团有限公司 | A kind of data comparison method, apparatus, equipment and the terminal of big data |
| CN110362574B (en) * | 2019-06-27 | 2022-02-15 | 东软集团股份有限公司 | Data comparison method and device, storage medium and electronic equipment |
| CN110362574A (en) * | 2019-06-27 | 2019-10-22 | 东软集团股份有限公司 | Data comparison method, device, storage medium and electronic equipment |
| CN111177119A (en) * | 2019-12-23 | 2020-05-19 | 平安资产管理有限责任公司 | Database-based full-data comparison method, device, equipment and storage medium |
| CN111459916A (en) * | 2020-04-16 | 2020-07-28 | 中国银行股份有限公司 | GBASE and ORAC L E database table comparison method and system |
| CN111459916B (en) * | 2020-04-16 | 2023-05-23 | 中国银行股份有限公司 | GBASE and ORACLE database table comparison method and system |
| CN112241408A (en) * | 2020-09-30 | 2021-01-19 | 航天信息股份有限公司 | Temporary table-based invoice data batch storage method |
| CN113254456A (en) * | 2021-06-29 | 2021-08-13 | 山东浪潮通软信息科技有限公司 | Database data information comparison method, system, equipment and storage medium |
| CN113360404A (en) * | 2021-06-30 | 2021-09-07 | 中国工商银行股份有限公司 | Method and device for comparing metadata of database |
| CN113360404B (en) * | 2021-06-30 | 2024-03-22 | 中国工商银行股份有限公司 | Metadata comparison method and device for database |
| CN113672639B (en) * | 2021-08-27 | 2024-04-26 | 成都长城开发科技股份有限公司 | Multi-type database table structure comparison method, system, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108304522A (en) | Comparison method, device and the terminal device of difference between a kind of database | |
| CN101651576B (en) | Alarm information processing method and system | |
| CN109344153A (en) | The processing method and terminal device of business datum | |
| EP3418910A1 (en) | Big data-based method and device for calculating relationship between development objects | |
| US8463811B2 (en) | Automated correlation discovery for semi-structured processes | |
| US20130117319A1 (en) | Objects in a storage environment for connected applications | |
| CN109508355A (en) | A kind of data pick-up method, system and terminal device | |
| CN103455489A (en) | Method and system for rapidly constructing key performance indicators (KPIs) of enterprises | |
| CN109491857A (en) | A kind of data monitoring method, system and the terminal device of rule-based engine | |
| CN111124917A (en) | Public test case management and control method, device, equipment and storage medium | |
| CN114461644A (en) | Data acquisition method and device, electronic equipment and storage medium | |
| CN108733799A (en) | A kind of method for processing report data, device and terminal | |
| CN107977504A (en) | A kind of asymmetric in-core fuel management computational methods, device and terminal device | |
| CN107784596A (en) | Insurance kind state information statistics method, terminal device and the storage medium of declaration form | |
| CN111522840B (en) | Label configuration method, device, equipment and computer readable storage medium | |
| CN107528969A (en) | Management method, managing device and the terminal device of telephone call time | |
| CN110874365A (en) | Information query method and related equipment thereof | |
| CN109450963A (en) | Information push method and terminal device | |
| CN114741392A (en) | Data query method and device, electronic equipment and storage medium | |
| CN114860759A (en) | Data processing method, device and equipment and readable storage medium | |
| CN111159203B (en) | Data association analysis method, platform, electronic equipment and storage medium | |
| CN110309211A (en) | A kind of method and relevant device positioning ETL Process Problems | |
| CN109670980A (en) | A kind of processing method, system and the equipment of the business datum that charges | |
| CN111738763B (en) | Policy processing method, device, equipment and storage medium | |
| WO2024021581A1 (en) | Metric query method and system, and electronic device and storage medium |
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 | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: Room 201, Building A, No. 1 Qianwan Road, Qianhai Shenzhen-Hong Kong Cooperation Zone, Shenzhen, Guangdong 518000:No. 1701, 1702B, A, New Hao one town, No. 7018 Cai Tian Road, Futian, Shenzhen 518000 Room 201, No. 1 A (Qianhai business secretary, Shenzhen, Shenzhen City, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen City, Guangdong) Applicant after: Shenzhen Rongyimai Information Technology Co., Ltd. Address before: Room 201, Building A, No. 1 Qianwan Road, Qianhai Shenzhen-Hong Kong Cooperation Zone, Shenzhen, Guangdong 518000:No. 1701, 1702B, A, New Hao one town, No. 7018 Cai Tian Road, Futian, Shenzhen 518000 Room 201, No. 1 A (Qianhai business secretary, Shenzhen, Shenzhen City, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen City, Guangdong) Applicant before: Maimaiti Mdt InfoTech Ltd, Shenzhen |
|
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180720 |