CN105045918A - Mutual comparison device for any tables of two databases and mutual comparison method of for any tables of two databases - Google Patents

Mutual comparison device for any tables of two databases and mutual comparison method of for any tables of two databases Download PDF

Info

Publication number
CN105045918A
CN105045918A CN201510521890.5A CN201510521890A CN105045918A CN 105045918 A CN105045918 A CN 105045918A CN 201510521890 A CN201510521890 A CN 201510521890A CN 105045918 A CN105045918 A CN 105045918A
Authority
CN
China
Prior art keywords
contrast
configuration
source
object table
major key
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
Application number
CN201510521890.5A
Other languages
Chinese (zh)
Inventor
王龙强
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Yonyou Network Technology Co Ltd
Original Assignee
Yonyou Network Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Yonyou Network Technology Co Ltd filed Critical Yonyou Network Technology Co Ltd
Priority to CN201510521890.5A priority Critical patent/CN105045918A/en
Publication of CN105045918A publication Critical patent/CN105045918A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Software Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention provides a mutual comparison device for any tables of two databases. The mutual comparison device comprises a table selecting unit, an information configuration unit, a table comparison unit and a result output unit, wherein the table selecting unit is used for selecting a source table and a target table to be compared; the information configuration unit is used for performing information configuration on the basis of the selected source table and the selected target table, wherein the configuration information includes output paths, field mapping and main key mapping; the table comparison unit is used for performing comparison processing on the source table and the target table on the basis of the configuration information; and the result output unit is used for outputting the comparison processing result of the source table and the target table. The invention also provides a mutual comparison method for any tables of the two databases. Through the technical scheme provided by the invention, the single object type can be fully used for completing the table comparison of multiple object types on the basis of the existing table comparison mode; and a general and unified comparison thought of the multiple object type participation and complex-type-oriented table comparison is built.

Description

The mutual compare device that two databases are shown arbitrarily and method
Technical field
The present invention relates to technical field of data processing, particularly, relate to mutual compare device that a kind of two databases show arbitrarily and the mutual control methods that a kind of two databases are shown arbitrarily.
Background technology
Table contrast in traditional CDC application conditions when carrying out table contrast is harsher, and application is poor:
First two tables must have identical major key, if do not have identical major key, showing contrast execution will be failed, obviously cannot meet and not have the table of major key to contrast.
Secondly entirely showing contrast due to during table contrast in CDC, must guarantee that the record count in two tables is just the same when showing contrast, otherwise table contrast execution will be failed.
Table contrast in CDC must have identical field number, if the field number of two tables is different, then table contrast execution will be failed, for example, existing two tables: student shows Student(id, name, class, gender, address), list of results Score(id, name, class, gender, address, score), because field number is inconsistent, obviously traditional CDC cannot carry out table contrast to these two tables.Visible: (1) in CDC, table contrast application conditions is harsh, application is poor; (2) in CDC, table contrast is for entirely showing contrast, and table contrast execution efficiency is low.
Finally it is to be noted that, because contrast is entirely shown in the table contrast in CDC, when carrying out table contrast, if the record number of two tables is all larger, the execution efficiency so showing to contrast will be very low.
Therefore, need a kind of table correlation technique newly, on existing table way of contrast basis, the table contrast that single object type completes multi-object type can be made full use of, set up general, the unified contrast thinking towards the contrast of complicated type table that multi-object type participates in.
Summary of the invention
The present invention is just based on the problems referred to above, propose a kind of table correlation technique newly, on existing table way of contrast basis, the table contrast that single object type completes multi-object type can be made full use of, set up general, the unified contrast thinking towards the contrast of complicated type table that multi-object type participates in.
In view of this, the present invention proposes the mutual compare device that a kind of two databases are shown arbitrarily, comprising: table selection unit, for selecting the source table and the object table that need contrast; Information configuration unit, for based on the source table selected and object table, carries out information configuration; The information of this configuration comprises outgoing route, field mappings and major key and maps; Table contrast unit, for the information based on configuration, carries out contrast process to source table and object table; Result output unit, for exporting the result of source table and object table contrast process.In this technical scheme, according to the application conditions of the various harshnesses utilized in traditional C DC in table contrast, can show comparing function basis increases new function for table in DIDesigner contrasts in compatible CDC, improve table contrast execution efficiency, raising application.
In technique scheme, preferably, described table selection unit, specifically comprises: module selected by source table, for selecting the source table needing contrast; Object table selects module, for selecting the object table needing contrast.In this technical scheme, two databases can be realized and show arbitrarily to compare.
In technique scheme, preferably, described information configuration unit, specifically comprises: outgoing route configuration module, for based on the source table selected and object table, carries out the configuration of outgoing route; Field mappings configuration module, for carrying out the configuration of field mappings further; Major key maps configuration module, for carrying out the configuration of major key mapping further.In this technical scheme, according to the application conditions of the various harshnesses utilized in traditional C DC in table contrast, can show comparing function basis increases new function for table in DIDesigner contrasts in compatible CDC, improve table contrast execution efficiency, raising application.
In technique scheme, preferably, described table contrast unit, specifically comprises: table filtering module, for the information based on configuration, needs to select field mappings according to user, and in source, object table selects the table record needed to contrast when filtering; Table major key filtering module, for based on table record comparing result, configurating filtered condition, on the basis of major key, filters source table and object table; Contrast rule runs module, and for the filter result based on source table and object table, configuration major key filtercondition, contrasts source table and object table.In this technical scheme, can need to select field mappings, carry out table record filtration according to user self, improve the table contrast application in DIDesigner and execution efficiency.
In technique scheme, preferably, described result output unit, specifically comprises: comparing result output module, for the comparing result based on source table and object table, exports comparing result; Error log output module, for the error log of output source table and the generation of object table comparison process further.In this technical scheme, comparing result can be outputted to specified path in the form of a file, intuitive display, it is convenient to export.
According to a further aspect of the invention, also proposed the mutual control methods that a kind of two databases are shown arbitrarily, comprising: step 202: source table and the object table of selecting needs contrast; Step 204: based on the source table selected and object table, carry out information configuration; The information of this configuration comprises outgoing route, field mappings and major key and maps; Step 206: based on the information of configuration, carries out contrast process to source table and object table; Step 208: the result of source table and object table contrast process is exported.In this technical scheme, according to the application conditions of the various harshnesses utilized in traditional C DC in table contrast, can show comparing function basis increases new function for table in DIDesigner contrasts in compatible CDC, improve table contrast execution efficiency, raising application.
In technique scheme, preferably, described step 202, specifically comprises: step 302: the source table selecting needs contrast; Step 304: select the object table needing contrast.In this technical scheme, two databases can be realized and show arbitrarily to compare.
In technique scheme, preferably, described step 204, specifically comprises: step 402: based on the source table selected and object table, carry out the configuration of outgoing route; Step 404: the configuration carrying out field mappings further; Step 406: the configuration carrying out major key mapping further.In this technical scheme, according to the application conditions of the various harshnesses utilized in traditional C DC in table contrast, can show comparing function basis increases new function for table in DIDesigner contrasts in compatible CDC, improve table contrast execution efficiency, raising application.
In technique scheme, preferably, described step 206, specifically comprises: step 502: based on configuration information, according to user need select field mappings, in source, object table filter time select need table record contrast; Step 504: based on table record comparing result, configurating filtered condition, on the basis of major key, filters source table and object table; Step 506: based on source table and the filter result of object table, configuration major key filtercondition, shows source and object table contrasts.In this technical scheme, can need to select field mappings, carry out table record filtration according to user self, improve the table contrast application in DIDesigner and execution efficiency.
In technique scheme, preferably, described step 208, specifically comprises: step 602: based on source table and the comparing result of object table, output comparing result; Step 604: the error log of output source table and the generation of object table comparison process further.In this technical scheme, comparing result can be outputted to specified path in the form of a file, intuitive display, it is convenient to export.
By above technical scheme, on existing table way of contrast basis, the table contrast that single object type completes multi-object type can be made full use of, set up general, the unified contrast thinking towards the contrast of complicated type table that multi-object type participates in.
Accompanying drawing explanation
Fig. 1 shows the block diagram of the mutual compare device that two databases are according to an embodiment of the invention shown arbitrarily;
Fig. 2 shows the process flow diagram of the mutual control methods that two databases are according to an embodiment of the invention shown arbitrarily;
Fig. 3 shows the process flow diagram showing selection unit according to an embodiment of the invention;
Fig. 4 shows the process flow diagram of information configuration unit according to an embodiment of the invention;
Fig. 5 shows the process flow diagram of table contrast unit according to an embodiment of the invention;
Fig. 6 shows the process flow diagram of result output unit according to an embodiment of the invention;
Fig. 7 shows in CDC of the prior art the process flow diagram showing to contrast;
Fig. 8 shows the process flow diagram showing in DIDesigner according to an embodiment of the invention to contrast.
Embodiment
In order to more clearly understand above-mentioned purpose of the present invention, feature and advantage, below in conjunction with the drawings and specific embodiments, the present invention is further described in detail.It should be noted that, when not conflicting, the feature in the embodiment of the application and embodiment can combine mutually.
Set forth a lot of detail in the following description so that fully understand the present invention; but; the present invention can also adopt other to be different from other modes described here and implement, and therefore, protection scope of the present invention is not by the restriction of following public specific embodiment.
Fig. 1 shows the block diagram of the mutual compare device that two databases are according to an embodiment of the invention shown arbitrarily.
As shown in Figure 1, the mutual compare device 100 that shows arbitrarily of two databases according to an embodiment of the invention, comprising: table selection unit 102, for selecting the source table and the object table that need contrast; Information configuration unit 104, for based on the source table selected and object table, carries out information configuration; The information of this configuration comprises outgoing route, field mappings and major key and maps; Table contrast unit 106, for the information based on configuration, carries out contrast process to source table and object table; Result output unit 108, for exporting the result of source table and object table contrast process.In this technical scheme, according to the application conditions of the various harshnesses utilized in traditional C DC in table contrast, can show comparing function basis increases new function for table in DIDesigner contrasts in compatible CDC, improve table contrast execution efficiency, raising application.
In technique scheme, preferably, table selection unit 102, specifically comprises: module 1022 selected by source table, for selecting the source table needing contrast; Object table selects module 1024, for selecting the object table needing contrast.In this technical scheme, two databases can be realized and show arbitrarily to compare.
In technique scheme, preferably, information configuration unit 104, specifically comprises: outgoing route configuration module 1042, for based on the source table selected and object table, carries out the configuration of outgoing route; Field mappings configuration module 1044, for carrying out the configuration of field mappings further; Major key maps configuration module 1046, for carrying out the configuration of major key mapping further.In this technical scheme, according to the application conditions of the various harshnesses utilized in traditional C DC in table contrast, can show comparing function basis increases new function for table in DIDesigner contrasts in compatible CDC, improve table contrast execution efficiency, raising application.
In technique scheme, preferably, table contrast unit 106, specifically comprise: table filtering module 1062, for based on configuration information, according to user need select field mappings, in source, object table filter time select need table record contrast; Table major key filtering module 1064, for based on table record comparing result, configurating filtered condition, on the basis of major key, filters source table and object table; Contrast rule runs module 1066, and for the filter result based on source table and object table, configuration major key filtercondition, contrasts source table and object table.In this technical scheme, can need to select field mappings, carry out table record filtration according to user self, improve the table contrast application in DIDesigner and execution efficiency.
In technique scheme, preferably, result output unit 108, specifically comprises: comparing result output module 1082, for the comparing result based on source table and object table, exports comparing result; Error log output module 1084, for the error log of output source table and the generation of object table comparison process further.In this technical scheme, comparing result can be outputted to specified path in the form of a file, intuitive display, it is convenient to export.
Fig. 2 shows the process flow diagram of the mutual control methods that two databases are according to an embodiment of the invention shown arbitrarily.
As shown in Figure 2, the mutual control methods shown arbitrarily of two databases according to an embodiment of the invention, comprising: step 202: select the source of needs contrast to show and object table; Step 204: based on the source table selected and object table, carry out information configuration; The information of this configuration comprises outgoing route, field mappings and major key and maps; Step 206: based on the information of configuration, carries out contrast process to source table and object table; Step 208: the result of source table and object table contrast process is exported.In this technical scheme, according to the application conditions of the various harshnesses utilized in traditional C DC in table contrast, can show comparing function basis increases new function for table in DIDesigner contrasts in compatible CDC, improve table contrast execution efficiency, raising application.
In technique scheme, preferably, see Fig. 3, step 202, specifically comprises: step 302: the source table selecting needs contrast; Step 304: select the object table needing contrast.In this technical scheme, two databases can be realized and show arbitrarily to compare.
In technique scheme, preferably, see Fig. 4, step 204, specifically comprises: step 402: based on the source table selected and object table, carry out the configuration of outgoing route; Step 404: the configuration carrying out field mappings further; Step 406: the configuration carrying out major key mapping further.In this technical scheme, according to the application conditions of the various harshnesses utilized in traditional C DC in table contrast, can show comparing function basis increases new function for table in DIDesigner contrasts in compatible CDC, improve table contrast execution efficiency, raising application.
In technique scheme, preferably, see Fig. 5, step 206, specifically comprises: step 502: based on configuration information, according to user need select field mappings, in source, object table filter time select need table record contrast; Step 504: based on table record comparing result, configurating filtered condition, on the basis of major key, filters source table and object table; Step 506: based on source table and the filter result of object table, configuration major key filtercondition, shows source and object table contrasts.In this technical scheme, can need to select field mappings, carry out table record filtration according to user self, improve the table contrast application in DIDesigner and execution efficiency.
In technique scheme, preferably, see Fig. 6, step 208, specifically comprises: step 602: based on source table and the comparing result of object table, output comparing result; Step 604: the error log of output source table and the generation of object table comparison process further.In this technical scheme, comparing result can be outputted to specified path in the form of a file, intuitive display, it is convenient to export.
Technical scheme of the present invention, can realize two databases and show arbitrarily to compare.Technical scheme of the present invention, for in DIDesigner2.1, contrast similar with the table that AE sends out in the CDC of version before, it can realize oracle(gbase) table contrast between database, as long as database supports that MD5 function can contrast, comparing result is outputted to specified path in the form of a file.With CDC unlike, when carrying out showing contrast, the contrast of table in DIDesigner2.1 does not require that two list structures selected are just the same.
The table contrast talked of technical scheme of the present invention only for support MD5 function database between comparison, table contrast in CDC is applied in DIDesigner by the present invention, according to the application conditions of the various harshnesses utilized in traditional C DC in table contrast, show in compatible CDC on comparing function basis as table contrast in DIDesigner increases new function, improve table contrast execution efficiency, improve application.
Technical scheme of the present invention, emphasis will solve the problem that traditional C DC table contrast application conditions is harsh, application is poor, and user can select field mappings, carry out table record filtration according to self needing.Improve the table contrast application in DIDesigner and execution efficiency.
For the main technical problem to be solved in the present invention, show to contrast process flow diagram as shown in Figure 7 and Figure 8 in the process flow diagram of proposition solution and CDC.
Compared with prior art, technical scheme of the present invention, for the shortcoming that in CDC, table contrast application conditions is harsh, application is poor, keeps the basis of original function increases some new functions in the contrast of DIDesigner table.Contrasted as can be seen from above-mentioned process flow diagram, be compared to the table contrast in CDC, mainly can show in DIDesigner to contrast:
Custom field maps, and being no longer confined to two table list structures to be contrasted must be identical, and two table list structures of initial selected can not be identical, and when carrying out table contrast, specific field maps, and then to give tacit consent to two list structures not identical in specific field mapping.
Self-defined major key maps, and being also no longer confined to two tables must have major key, major key necessary identical simultaneously, and user can specify major key to carry out table contrast, and backstage has inspection and specifies primary key column whether to meet uniqueness.
Source, object table are filtered, table contrast in CDC is for entirely showing contrast, when in showing, record count is many time, to be very low to specific efficiency, and often the desired contrast of user be only some information (such as user be only concerned about the sales achievement of 2015 year) useful to user, in source, object table when filtering user selectively can remove to filter the record of required contrast, only contrast user wants the record that carries out contrasting.Substantially increase the execution efficiency of table contrast, meet the demand of user, Consumer's Experience also can be better.
Source, object table major key are filtered, and filter similar with source, object table, and source, object table major key are filtered and mainly filtered source, object table on the basis of major key, object is the same, all in order to table contrast can be completed fast, improves the execution efficiency of table contrast, meets the demand of user.
Through examining then and experimental verification, technical scheme of the present invention realizes in the AEDIDesigner product of the applicant.
More than be described with reference to the accompanying drawings technical scheme of the present invention, considered in correlation technique there is no easy, the unified solution for the contrast of complicated type table.Existing table contrast cannot complete the table comparison process that complicated type participates in.Therefore, the present invention proposes mutual compare device that a kind of two databases show arbitrarily and the mutual control methods that a kind of two databases are shown arbitrarily, can on existing table way of contrast basis, make full use of the table contrast that single object type completes multi-object type, set up general, the unified contrast thinking towards the contrast of complicated type table that multi-object type participates in.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.

Claims (10)

1. the mutual compare device that shows arbitrarily of two databases, is characterized in that, comprising:
Table selection unit, for selecting the source table and the object table that need contrast;
Information configuration unit, for based on the source table selected and object table, carries out information configuration; The information of this configuration comprises outgoing route, field mappings and major key and maps;
Table contrast unit, for the information based on configuration, carries out contrast process to source table and object table;
Result output unit, for exporting the result of source table and object table contrast process.
2. the mutual compare device that shows arbitrarily of two databases according to claim 1, it is characterized in that, described table selection unit, specifically comprises:
Module selected by source table, for selecting the source table needing contrast;
Object table selects module, for selecting the object table needing contrast.
3. the mutual compare device that shows arbitrarily of two databases according to claim 1 and 2, it is characterized in that, described information configuration unit, specifically comprises:
Outgoing route configuration module, for based on the source table selected and object table, carries out the configuration of outgoing route;
Field mappings configuration module, for carrying out the configuration of field mappings further;
Major key maps configuration module, for carrying out the configuration of major key mapping further.
4. the mutual compare device that shows arbitrarily of two databases according to claim 1 and 2, is characterized in that, described table contrast unit, specifically comprises:
Table filtering module, for based on configuration information, according to user need select field mappings, in source, object table filter time select need table record contrast;
Table major key filtering module, for based on table record comparing result, configurating filtered condition, on the basis of major key, filters source table and object table;
Contrast rule runs module, and for the filter result based on source table and object table, configuration major key filtercondition, contrasts source table and object table.
5. the mutual compare device that shows arbitrarily of two databases according to claim 1 and 2, it is characterized in that, described result output unit, specifically comprises:
Comparing result output module, for the comparing result based on source table and object table, exports comparing result;
Error log output module, for the error log of output source table and the generation of object table comparison process further.
6. the mutual control methods shown arbitrarily of two databases, is characterized in that, comprising:
Step 202: select the source table and the object table that need contrast;
Step 204: based on the source table selected and object table, carry out information configuration; The information of this configuration comprises outgoing route, field mappings and major key and maps;
Step 206: based on the information of configuration, carries out contrast process to source table and object table;
Step 208: the result of source table and object table contrast process is exported.
7. the mutual control methods shown arbitrarily of two databases according to claim 6, it is characterized in that, described step 202, specifically comprises:
Step 302: select the source table needing contrast;
Step 304: select the object table needing contrast.
8. the mutual control methods that two databases according to claim 6 or 7 are shown arbitrarily, it is characterized in that, described step 204, specifically comprises:
Step 402: based on the source table selected and object table, carry out the configuration of outgoing route;
Step 404: the configuration carrying out field mappings further;
Step 406: the configuration carrying out major key mapping further.
9. the mutual control methods that two databases according to claim 6 or 7 are shown arbitrarily, it is characterized in that, described step 206, specifically comprises:
Step 502: based on configuration information, according to user need select field mappings, in source, object table filter time select need table record contrast;
Step 504: based on table record comparing result, configurating filtered condition, on the basis of major key, filters source table and object table;
Step 506: based on source table and the filter result of object table, configuration major key filtercondition, shows source and object table contrasts.
10. the mutual control methods that two databases according to claim 6 or 7 are shown arbitrarily, it is characterized in that, described step 208, specifically comprises:
Step 602: based on source table and the comparing result of object table, output comparing result;
Step 604: the error log of output source table and the generation of object table comparison process further.
CN201510521890.5A 2015-08-24 2015-08-24 Mutual comparison device for any tables of two databases and mutual comparison method of for any tables of two databases Pending CN105045918A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201510521890.5A CN105045918A (en) 2015-08-24 2015-08-24 Mutual comparison device for any tables of two databases and mutual comparison method of for any tables of two databases

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201510521890.5A CN105045918A (en) 2015-08-24 2015-08-24 Mutual comparison device for any tables of two databases and mutual comparison method of for any tables of two databases

Publications (1)

Publication Number Publication Date
CN105045918A true CN105045918A (en) 2015-11-11

Family

ID=54452465

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201510521890.5A Pending CN105045918A (en) 2015-08-24 2015-08-24 Mutual comparison device for any tables of two databases and mutual comparison method of for any tables of two databases

Country Status (1)

Country Link
CN (1) CN105045918A (en)

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107122368A (en) * 2016-02-25 2017-09-01 阿里巴巴集团控股有限公司 A kind of data verification method, device and electronic equipment
CN108959649A (en) * 2018-08-02 2018-12-07 杭州数梦工场科技有限公司 A kind of data sheet field mapping configuration method and system based on web page
CN111767350A (en) * 2020-06-30 2020-10-13 平安国际智慧城市科技股份有限公司 Data warehouse testing method and device, terminal equipment and storage medium
CN113177044A (en) * 2021-04-08 2021-07-27 武汉达梦数据库股份有限公司 Method and device for quickly comparing data based on database B tree

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103176989A (en) * 2011-12-21 2013-06-26 中国银联股份有限公司 Method and system used for comparing database table levels and based on data dictionary and variable rules
CN103500169A (en) * 2013-09-02 2014-01-08 用友软件股份有限公司 File comparison device and file comparison method
CN103810247A (en) * 2014-01-10 2014-05-21 国网信通亿力科技有限责任公司 Disaster recovery data comparing method based on bucket algorithm
US20150066987A1 (en) * 2013-09-03 2015-03-05 International Business Machines Corporation Method and system for accessing a set of data tables in a source database

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103176989A (en) * 2011-12-21 2013-06-26 中国银联股份有限公司 Method and system used for comparing database table levels and based on data dictionary and variable rules
CN103500169A (en) * 2013-09-02 2014-01-08 用友软件股份有限公司 File comparison device and file comparison method
US20150066987A1 (en) * 2013-09-03 2015-03-05 International Business Machines Corporation Method and system for accessing a set of data tables in a source database
CN103810247A (en) * 2014-01-10 2014-05-21 国网信通亿力科技有限责任公司 Disaster recovery data comparing method based on bucket algorithm

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107122368A (en) * 2016-02-25 2017-09-01 阿里巴巴集团控股有限公司 A kind of data verification method, device and electronic equipment
CN108959649A (en) * 2018-08-02 2018-12-07 杭州数梦工场科技有限公司 A kind of data sheet field mapping configuration method and system based on web page
CN111767350A (en) * 2020-06-30 2020-10-13 平安国际智慧城市科技股份有限公司 Data warehouse testing method and device, terminal equipment and storage medium
CN113177044A (en) * 2021-04-08 2021-07-27 武汉达梦数据库股份有限公司 Method and device for quickly comparing data based on database B tree
CN113177044B (en) * 2021-04-08 2022-05-27 武汉达梦数据库股份有限公司 Method and device for quickly comparing data based on database B tree

Similar Documents

Publication Publication Date Title
CN108255925B (en) Method and terminal for displaying data table structure change condition
CN108536761B (en) Report data query method and server
EP2924588B1 (en) Report creation method, device and system
CN110334009A (en) Automatic example generation method, device, terminal and storage medium
US20190324691A1 (en) Data Recovery Method and Device, and Cloud Storage System
CN104182484B (en) A kind of method and apparatus for realizing HBase data and the mapping of Java field object
CN105045918A (en) Mutual comparison device for any tables of two databases and mutual comparison method of for any tables of two databases
CN103020064A (en) Method and configuration for generating query condition in annotation way
CN107977396B (en) Method and device for updating data table of KeyValue database
CN105389184B (en) The configuration method and device of Product Interface information
CN103606037A (en) Query and configuration method of business data and device thereof
CN105488210B (en) A kind of batch data matching process and device
CN109840257A (en) Data base query method, device, computer installation and readable storage medium storing program for executing
CN102104510A (en) Data view processing method and system
CN104461384B (en) A kind of method for writing data and storage device
CN106649602A (en) Way, device and server of processing business object data
CN106909383A (en) The display methods and display device of application program
CN109408502A (en) A kind of data standard processing method, device and its storage medium
CN106407172A (en) XML (Extensible Markup Language)-based report generating method
CN112069243A (en) Method for generating index analysis model based on visual page and storage device
CN116305895A (en) Product model generation method, device, computer equipment and storage medium
CN103744952A (en) Method and system for implementing multi-table property of NoSQL database
US20110022901A1 (en) Method for testing hard disks under an extensible firmware interface
US20210216516A1 (en) Management of a secondary vertex index for a graph
CN112269785B (en) Method and system for dynamically filling field in subject state details in EDC (electronic data communication) system

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20151111