CN106021301A - Comparing system and method for data having different file formats - Google Patents

Comparing system and method for data having different file formats Download PDF

Info

Publication number
CN106021301A
CN106021301A CN201610290710.1A CN201610290710A CN106021301A CN 106021301 A CN106021301 A CN 106021301A CN 201610290710 A CN201610290710 A CN 201610290710A CN 106021301 A CN106021301 A CN 106021301A
Authority
CN
China
Prior art keywords
data
value
platform
business datum
template
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.)
Granted
Application number
CN201610290710.1A
Other languages
Chinese (zh)
Other versions
CN106021301B (en
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.)
Beijing Si Tech Information Technology Co Ltd
Original Assignee
Beijing Si Tech Information 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 Beijing Si Tech Information Technology Co Ltd filed Critical Beijing Si Tech Information Technology Co Ltd
Priority to CN201610290710.1A priority Critical patent/CN106021301B/en
Publication of CN106021301A publication Critical patent/CN106021301A/en
Application granted granted Critical
Publication of CN106021301B publication Critical patent/CN106021301B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

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/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • 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
    • 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/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • G06F16/24552Database cache management

Landscapes

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

Abstract

The invention provides a comparing system and method for data having different file formats. The comparing system includes: a data acquisition module for acquiring service data templates of an A platform and a B platform; a data extraction module for extracting service data to be compared from a corresponding storage space; a data comparing module for putting the extracted service data in a cache or a database to be compared; and a data generation module for allowing different data to generate a comparing file according to a preset format. The data comparing system does not have to concern service data, data comparing and a service body cannot be separated, various service responsible person needs performing configuration according to the corresponding format of a file, and then data processing can be performed; the different data is stored in the database or generates the file according to the preset format after data processing, and later analysis and processing is facilitated; and the step of data processing is simplified to the greatest extent, the operation and maintenance cost is reduced, and the working efficiency is improved.

Description

A kind of comparing system and method for different file format
Technical field
The invention mainly relates to technical field of data processing, be specifically related to the comparing system of a kind of different file format And method.
Background technology
NGBOSS system is moved in each department at present, and there is a set of data center integration data this area that user uses, and amasss Platform is divided also to have the integration data center of a user.Due to integration platform and the independence of each department system, add business When accepting, the reason such as asynchronous process, system or database failure, causes the integration data of certain customers between two platforms Occur abnormal during synchronization.So, the data of two platforms need periodically (daily, by week or monthly etc.) to compare, and to difference Heteromerism is according to being analyzed and processing.
And the business of of this sort two cover system Liang Fen data centers has a lot, frequently refers to the ratio of data consistency Right.Due to the diversity of the service logic of these business own, the data file that Mei Lei business group's platform or platform region issue Form is different, and data base's value SQL script is the most different, so, the concordance ratio of the most newly-increased business datum Demand relatively, each department will increase a set of program newly and process, relatively costly.
Summary of the invention
The technical problem to be solved is to provide the comparing system and method for a kind of different file format, number Need not specifically be concerned about business datum according to Compare System, comparing and business separate itself, it is only necessary to each business director presses Carry out configuration according to file correspondence form and can carry out data process, after process, variance data form according to the rules warehouse-in or raw Become file, facilitate post analysis and process, compared with flow process before, simplify the step processing data, fall largely Low O&M cost, improves work efficiency.
The technical scheme is that the comparing system of a kind of different file format, Including data acquisition module, data extraction module, data comparison module and data generation module,
Described data acquisition module, is used for starting process, and obtains A platform according to business id or utilization circulation reading manner With service data template in B platform, wherein, the form of the service data template of A platform and the service data template of B platform is not With;
Described data extraction module, for judging the data form of A platform and B platform according to service data template, then divides Do not extract from corresponding memory space according to the data form judged and need the business datum of contrast;
Described data comparison module, for putting into caching or putting according to the data-quantity threshold preset by the business datum of extraction Enter in data base and compare, thus obtain variance data;
Described data generation module, for generating documents by described variance data according to the form set and preserving.
The invention has the beneficial effects as follows: comparing system need not specifically be concerned about business datum, comparing is with business originally Status from, it is only necessary to each business director carries out configuration according to file correspondence form can carry out data process, after process, Variance data form according to the rules warehouse-in or generation file, facilitate post analysis and process, compared with flow process before, and very big journey Simplify the step processing data on degree, reduce O&M cost, improve work efficiency.
On the basis of technique scheme, the present invention can also do following improvement.
Further, described data acquisition module includes detector unit, the first acquiring unit and second acquisition unit,
Described detector unit, for detecting whether configuration service id, if configuration, then sends the first acquisition instruction to first Acquiring unit, otherwise sends the second acquisition instruction to second acquisition unit;
Described first acquiring unit, after being used for receiving the first acquisition instruction, according to business id in default query configuration Table mates to should the Template Information of business id, and obtain, from A platform or B platform, the business datum that this Template Information is corresponding Template;
Described second acquisition unit, after being used for receiving the second acquisition instruction, utilizes circulation reading manner to look into default Ask in allocation list and read Template Information one by one, and from A platform or B platform, obtain the service data template of each Template Information.
Above-mentioned further scheme is used to provide the benefit that: the data obtaining different-format from different platform process, Compatible strong.
Further, in described data extraction module, in default template configuration table, judge that A puts down according to service data template The data form of platform and B platform, if data form is file format, is then connected to the business number of respective hosts extraction document form According to, if data form is serial data form, then it is connected to correspondence database and extracts the business datum of serial data form.Data form Sql serial data form, text formatting, xml serial data form etc. can be included.
Above-mentioned further scheme is used to provide the benefit that: multiple data form, compatible multiple Sybase can be supported.
Further, described data comparison module includes judging unit, caching comparing unit and data base's comparing unit,
Described judging unit, for judging according to the data-quantity threshold preset whether the size of the business datum extracted reaches Data-quantity threshold, if not up to, then sends first and compares instruction to caching comparing unit, otherwise send second and compare instruction extremely Data base's comparing unit;
Described caching comparing unit, instructs business datum for comparing according to first with the data mode of key-value Rewrite, then will the business datum loading application cache of rewriting compare, thus obtain variance data;
Described data base's comparing unit, instructs business datum for comparing according to second with the data shape of key-value Formula is rewritten, then will compare in the business datum loading interim table of data base of rewriting, thus obtains variance data.
Above-mentioned further scheme is used to provide the benefit that: to carry out in application cache or data base according to data volume size Comparison, ensure that system stability, prevents loss of data when data volume is bigger.
Further, in described caching comparing unit, the business datum of rewriting includes key value and value value, key value is protected Deposit to MAP_A application cache, value value preserved in MAP_B application cache, recirculation travel through each key value and with Value value compares, thus obtains variance data;
In described data base's comparing unit, the business datum of rewriting includes key value and value value, preserves key value to number According in the interim table of storehouse TAB_A, value value is preserved to the interim table of data base TAB_B, recirculation travel through each key value and with Value value compares, thus obtains variance data.
Above-mentioned further scheme is used to provide the benefit that: to carry out in application cache or data base according to data volume size Comparison, ensure that system stability, prevents loss of data when data volume is bigger.
Another technical scheme that the present invention solves above-mentioned technical problem is as follows: the comparing side of a kind of different file formats Method, comprises the steps:
Step S1: start process, and obtain business in A platform and B platform according to business id or utilization circulation reading manner Data template, wherein, the service data template of A platform is different with the form of the service data template of B platform;
Step S2: judge the data form of A platform and B platform according to service data template, more respectively according to judging Data form extracts from corresponding memory space needs the business datum of contrast;
Step S3: according to default data-quantity threshold, the business datum of extraction put into caching or put in data base and carry out Compare, thus obtain variance data;
Step S4: described variance data is generated documents according to the form set and preserves.
On the basis of technique scheme, the present invention can also do following improvement.
Further, it is achieved concretely comprising the following steps of step S1:
Step S101: detect whether configuration service id, if configuration, then performs step 102, otherwise performs step 103;
Step S102: according to business id mate in default query configuration table to should the Template Information of business id, and Obtain, from A platform or B platform, the service data template that this Template Information is corresponding;
Step S103: utilize circulation reading manner to read Template Information in default query configuration table one by one, and put down from A Platform or B platform obtain the service data template of each Template Information.
Further, in described step S2, in default template configuration table, judge A platform and B according to service data template The data form of platform, if data form is file format, is then connected to the business datum of respective hosts extraction document form, if Data form is serial data form, then be connected to correspondence database and extract the business datum of serial data form.
Further, it is achieved concretely comprising the following steps of step S3:
Step S301: judge according to default data-quantity threshold whether the size of the business datum extracted reaches data volume threshold Value, if not up to, then performs step S302, otherwise step S303;
Step S302: compare instruction according to first and business datum is rewritten with the data mode of key-value, then will The business datum rewritten is loaded in application cache and compares, thus obtains variance data;
Step S303: compare instruction according to second and business datum is rewritten with the data mode of key-value, then will The business datum rewritten is loaded in the interim table of data base and compares, thus obtains variance data.
Further, in described step S302, the business datum of rewriting includes key value and value value, key value is preserved extremely In MAP_A application cache, value value is preserved in MAP_B application cache, recirculation travel through each key value and with value value Compare, thus obtain variance data;
In described step S303, the business datum of rewriting includes key value and value value, preserves key value to data base In the interim table of TAB_A, value value being preserved to the interim table of data base TAB_B, recirculation travels through each key value and value Value compares, thus obtains variance data.
Accompanying drawing explanation
Fig. 1 is the module frame chart of present system;
Fig. 2 is the method flow diagram of the inventive method;
Fig. 3 is the method flow diagram of the inventive method embodiment.
Detailed description of the invention
Being described principle and the feature of the present invention below in conjunction with accompanying drawing, example is served only for explaining the present invention, and Non-for limiting the scope of the present invention.
As it is shown in figure 1, the comparing system of a kind of different file format, extract mould including data acquisition module, data Block, data comparison module and data generation module,
Described data acquisition module, is used for starting process, and obtains A platform according to business id or utilization circulation reading manner With service data template in B platform, wherein, the form of the service data template of A platform and the service data template of B platform is not With;
Described data extraction module, for judging the data form of A platform and B platform according to service data template, then divides Do not extract from corresponding memory space according to the data form judged and need the business datum of contrast;
Described data comparison module, for putting into caching or putting according to the data-quantity threshold preset by the business datum of extraction Enter in data base and compare, thus obtain variance data;
Described data generation module, for generating documents by described variance data according to the form set and preserving.
Described data acquisition module includes detector unit, the first acquiring unit and second acquisition unit,
Described detector unit, for detecting whether configuration service id, if configuration, then sends the first acquisition instruction to first Acquiring unit, otherwise sends the second acquisition instruction to second acquisition unit;
Described first acquiring unit, after being used for receiving the first acquisition instruction, according to business id in default query configuration Table mates to should the Template Information of business id, and obtain, from A platform or B platform, the business datum that this Template Information is corresponding Template;
Described second acquisition unit, after being used for receiving the second acquisition instruction, utilizes circulation reading manner to look into default Ask in allocation list and read Template Information one by one, and from A platform or B platform, obtain the service data template of each Template Information.
In described data extraction module, in default template configuration table, judge that A platform and B put down according to service data template The data form of platform, if data form is file format, is then connected to the business datum of respective hosts extraction document form, if number It is serial data form according to form, is then connected to correspondence database and extracts the business datum of serial data form.Data form can include Sql serial data form, text formatting, xml serial data form etc..
Described data comparison module includes judging unit, caching comparing unit and data base's comparing unit,
Described judging unit, for judging according to the data-quantity threshold preset whether the size of the business datum extracted reaches Data-quantity threshold, if not up to, then sends first and compares instruction to caching comparing unit, otherwise send second and compare instruction extremely Data base's comparing unit;
Described caching comparing unit, instructs business datum for comparing according to first with the data mode of key-value Rewrite, then will the business datum loading application cache of rewriting compare, thus obtain variance data;
Described data base's comparing unit, instructs business datum for comparing according to second with the data shape of key-value Formula is rewritten, then will compare in the business datum loading interim table of data base of rewriting, thus obtains variance data.
In described caching comparing unit, the business datum of rewriting includes key value and value value, preserves key value to MAP_ In A application cache, value value being preserved to MAP_B application cache, recirculation travels through each key value and carries out with value value Compare, thus obtain variance data;
In described data base's comparing unit, the business datum of rewriting includes key value and value value, preserves key value to number According in the interim table of storehouse TAB_A, value value is preserved to the interim table of data base TAB_B, recirculation travel through each key value and with Value value compares, thus obtains variance data.
As in figure 2 it is shown, the data comparison method of a kind of different file format, comprise the steps:
Step S1: start process, and obtain business in A platform and B platform according to business id or utilization circulation reading manner Data template, wherein, the service data template of A platform is different with the form of the service data template of B platform;
Step S2: judge the data form of A platform and B platform according to service data template, more respectively according to judging Data form extracts from corresponding memory space needs the business datum of contrast;
Step S3: according to default data-quantity threshold, the business datum of extraction put into caching or put in data base and carry out Compare, thus obtain variance data;
Step S4: described variance data is generated documents according to the form set and preserves.
Realize concretely comprising the following steps of step S1:
Step S101: detect whether configuration service id, if configuration, then performs step 102, otherwise performs step 103;
Step S102: according to business id mate in default query configuration table to should the Template Information of business id, and Obtain, from A platform or B platform, the service data template that this Template Information is corresponding;
Step S103: utilize circulation reading manner to read Template Information in default query configuration table one by one, and put down from A Platform or B platform obtain the service data template that each Template Information is corresponding.
In described step S2, in default template configuration table, judge A platform and the number of B platform according to service data template According to form, if data form is file format, then it is connected to the business datum of respective hosts extraction document form, if data form For serial data form, then it is connected to correspondence database and extracts the business datum of serial data form.
Realize concretely comprising the following steps of step S3:
Step S301: judge according to default data-quantity threshold whether the size of the business datum extracted reaches data volume threshold Value, if not up to, then performs step S302, otherwise step S303;
Step S302: compare instruction according to first and business datum is rewritten with the data mode of key-value, then will The business datum rewritten is loaded in application cache and compares, thus obtains variance data;
Step S303: compare instruction according to second and business datum is rewritten with the data mode of key-value, then will The business datum rewritten is loaded in the interim table of data base and compares, thus obtains variance data.
In described step S302, the business datum of rewriting includes key value and value value, should to MAP_A by the preservation of key value With in caching, value value being preserved to MAP_B application cache, recirculation travels through each key value and compares with value value Relatively, thus obtain variance data;
In described step S303, the business datum of rewriting includes key value and value value, preserves key value to data base In the interim table of TAB_A, value value being preserved to the interim table of data base TAB_B, recirculation travels through each key value and value Value compares, thus obtains variance data.
As it is shown on figure 3, data comparison method concrete operation step is:
Step 001: start;
Step 002: start process doBalanceBusi, according to configuration file Cfg, connects corresponding data acquisition basic Comparative arrangement information;
Step 003: detect whether configuration service id, if configuration, then performs step 004, otherwise performs step 005;
Step 004: mate should industry in default query configuration table Cs_BalanceRela_Dict according to business id The Template Information of business id, and obtain, from A platform or B platform, the service data template that this Template Information is corresponding;
Step 005: utilize circulation reading manner to read one by one in default query configuration table Cs_BalanceRela_Dict Take Template Information, and obtain, from A platform or B platform, the service data template that this Template Information is corresponding;
Step 006: sentence in default template configuration table Cs_BalanceTemplate_Dict according to service data template Disconnected A platform and the data form of B platform, perform step 007;
Step 007: if data form is file format, be then connected to the business datum of respective hosts extraction document form, If data form is serial data form, then it is connected to correspondence database and extracts the business datum of serial data form;
Step 008: judge according to default data-quantity threshold whether the size of the business datum extracted reaches data volume threshold Value, if not up to, then performs step 009, otherwise step 010;
Step 009: business datum rewritten with the data mode of key-value, the business datum of rewriting includes key Value and value value, preserve key value to MAP_A application cache, value value preserved to MAP_B application cache, then follow Ring travels through each key value and compares with value value, thus obtains variance data;
Step 010: business datum rewritten with the data mode of key-value, the business datum of rewriting includes key Value and value value, preserve key value to the interim table of data base TAB_A, preserve value value to the interim table of data base TAB_B In, recirculation travels through each key value and compares with value value, thus obtains variance data;
Step 011: variance data is generated documents according to the form set and preserves.
Step 012: terminate.
In step 011, variance data is write in flowing water table Cs_BalanceResult_YYYYMM or file table Cs_ In BalanceFileFix_Dict.
Concrete, query configuration table Cs_BalanceRela_Dict may be configured as:
Template configuration table Cs_BalanceTemplate_Dict may be configured as:
File table Cs_BalanceFileFix_Dict is set to:
Flowing water table Cs_BalanceResult_YYYYMM is set to:
The frequency that native system is safeguarded is low, newly-increased comparing demand, configures according to configuration above rule, and business is joined Put personnel depaly good, periodically difference results is analyzed.
The foregoing is only presently preferred embodiments of the present invention, not in order to limit the present invention, all spirit in the present invention and Within principle, any modification, equivalent substitution and improvement etc. made, should be included within the scope of the present invention.

Claims (10)

1. the comparing system of different file formats, it is characterised in that include that data acquisition module, data extract mould Block, data comparison module and data generation module,
Described data acquisition module, is used for starting process, and obtains A platform and B according to business id or utilization circulation reading manner Service data template in platform, wherein, the service data template of A platform is different with the form of the service data template of B platform;
Described data extraction module, for judging the data form of A platform and B platform according to service data template, then root respectively It is judged that the data form gone out extracts from corresponding memory space needs the business datum of contrast;
Described data comparison module, for putting into caching or putting into number according to the data-quantity threshold preset by the business datum of extraction Compare according in storehouse, thus obtain variance data;
Described data generation module, for generating documents by described variance data according to the form set and preserving.
The comparing system of a kind of different file formats the most according to claim 1, it is characterised in that described data obtain Delivery block includes detector unit, the first acquiring unit and second acquisition unit,
Described detector unit, for detecting whether configuration service id, if configuration, then sends the first acquisition instruction and obtains to first Unit, otherwise sends the second acquisition instruction to second acquisition unit;
Described first acquiring unit, after being used for receiving the first acquisition instruction, according to business id in default query configuration table Mate to should the Template Information of business id, and from A platform or B platform, obtain the business datum mould that this Template Information is corresponding Plate;
Described second acquisition unit, after being used for receiving the second acquisition instruction, utilizes circulation reading manner to join in default inquiry Put and table reads Template Information one by one, and from A platform or B platform, obtain the service data template of each Template Information.
The comparing system of a kind of different file formats the most according to claim 1, it is characterised in that described data carry In delivery block, in default template configuration table, judge the data form of A platform and B platform according to service data template, if number It is file format according to form, is then connected to the business datum of respective hosts extraction document form, if data form is serial data lattice Formula, then be connected to correspondence database and extract the business datum of serial data form.
The comparing system of a kind of different file formats the most according to claim 1, it is characterised in that described data ratio Relatively module includes judging unit, caching comparing unit and data base's comparing unit,
Described judging unit, for judging according to the data-quantity threshold preset whether the size of the business datum extracted reaches data Amount threshold value, if not up to, then sends first and compares instruction to caching comparing unit, otherwise send second and compare instruction to data Storehouse comparing unit;
Described caching comparing unit, is carried out business datum with the data mode of key-value for comparing instruction according to first Rewrite, then will the business datum loading application cache of rewriting compare, thus obtain variance data;
Described data base's comparing unit, enters business datum with the data mode of key-value for comparing instruction according to second Row is rewritten, then will compare in the business datum loading interim table of data base of rewriting, thus obtains variance data.
The comparing system of a kind of different file formats the most according to claim 4, it is characterised in that described caching ratio In relatively unit, the business datum of rewriting includes key value and value value, key value is preserved to MAP_A application cache, will Value value preserves to MAP_B application cache, and recirculation travels through each key value and compares with value value, thus obtains Variance data;
In described data base's comparing unit, the business datum of rewriting includes key value and value value, preserves key value to data base In the interim table of TAB_A, value value being preserved to the interim table of data base TAB_B, recirculation travels through each key value and value Value compares, thus obtains variance data.
6. the data comparison method of different file formats, it is characterised in that comprise the steps:
Step S1: start process, and obtain business datum in A platform and B platform according to business id or utilization circulation reading manner Template, wherein, the service data template of A platform is different with the form of the service data template of B platform;
Step S2: judge the data form of A platform and B platform according to service data template, more respectively according to the data judged Form extracts from corresponding memory space needs the business datum of contrast;
Step S3: according to default data-quantity threshold, the business datum of extraction put into caching or put in data base and compare Relatively, thus obtain variance data;
Step S4: described variance data is generated documents according to the form set and preserves.
The data comparison method of a kind of different file formats the most according to claim 6, it is characterised in that realize step S1 Concretely comprise the following steps:
Step S101: detect whether configuration service id, if configuration, then performs step 102, otherwise performs step 103;
Step S102: according to business id mate in default query configuration table to should the Template Information of business id, and put down from A Platform or B platform obtain the service data template that this Template Information is corresponding;
Step S103: utilize circulation reading manner to read Template Information in default query configuration table one by one, and from A platform or B platform obtains the service data template of each Template Information.
The data comparison method of a kind of different file formats the most according to claim 6, it is characterised in that described step S2 In, in default template configuration table, the data form of A platform and B platform is judged according to service data template, if data form For file format, then it is connected to the business datum of respective hosts extraction document form, if data form is serial data form, then connects Receive correspondence database and extract the business datum of serial data form.
The data comparison method of a kind of different file formats the most according to claim 6, it is characterised in that realize step S3 Concretely comprise the following steps:
Step S301: judge according to default data-quantity threshold whether the size of the business datum extracted reaches data-quantity threshold, If not up to, then performing step S302, otherwise step S303;
Step S302: compare instruction according to first and business datum is rewritten with the data mode of key-value, then will rewrite Business datum be loaded in application cache and compare, thus obtain variance data;
Step S303: compare instruction according to second and business datum is rewritten with the data mode of key-value, then will rewrite Business datum be loaded in the interim table of data base and compare, thus obtain variance data.
The data comparison method of a kind of different file formats the most according to claim 6, it is characterised in that described step In S302, the business datum of rewriting includes key value and value value, key value is preserved to MAP_A application cache, by value Value preserves to MAP_B application cache, and recirculation travels through each key value and compares with value value, thus obtains difference number According to;
In described step S303, the business datum of rewriting includes key value and value value, preserves key value to data base TAB_A In interim table, value value being preserved to the interim table of data base TAB_B, recirculation travels through each key value and enters with value value Row compares, thus obtains variance data.
CN201610290710.1A 2016-05-05 2016-05-05 Data comparison system and method for different file formats Active CN106021301B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610290710.1A CN106021301B (en) 2016-05-05 2016-05-05 Data comparison system and method for different file formats

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610290710.1A CN106021301B (en) 2016-05-05 2016-05-05 Data comparison system and method for different file formats

Publications (2)

Publication Number Publication Date
CN106021301A true CN106021301A (en) 2016-10-12
CN106021301B CN106021301B (en) 2020-02-04

Family

ID=57082134

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610290710.1A Active CN106021301B (en) 2016-05-05 2016-05-05 Data comparison system and method for different file formats

Country Status (1)

Country Link
CN (1) CN106021301B (en)

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107291827A (en) * 2017-05-27 2017-10-24 北京思特奇信息技术股份有限公司 A kind of data comparison method and system
CN107291500A (en) * 2017-06-21 2017-10-24 北京奇虎科技有限公司 The data distributing method and device of launching process
CN109783780A (en) * 2019-01-16 2019-05-21 平安普惠企业管理有限公司 A kind of document handling method and relevant apparatus
CN109788052A (en) * 2019-01-02 2019-05-21 郑州云海信息技术有限公司 A kind of server configuration remote inquiry method, apparatus, terminal and storage medium
CN111339039A (en) * 2020-02-21 2020-06-26 京东数字科技控股有限公司 File comparison method and device, storage medium and electronic device
CN111831755A (en) * 2020-07-23 2020-10-27 北京思特奇信息技术股份有限公司 Cross-database data synchronization method, system, medium and equipment

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2011049873A1 (en) * 2009-10-19 2011-04-28 Vexigo, Ltd. System and method for use of semantic understanding in storage, searching and providing of data or other content information
CN102184190A (en) * 2011-04-19 2011-09-14 北京神州数码思特奇信息技术股份有限公司 Data comparison method
CN102591864A (en) * 2011-01-06 2012-07-18 上海银晨智能识别科技有限公司 Data updating method and device in comparison system
CN103473643A (en) * 2013-09-10 2013-12-25 北京思特奇信息技术股份有限公司 Product management data auditing method and system for BOSS system

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2011049873A1 (en) * 2009-10-19 2011-04-28 Vexigo, Ltd. System and method for use of semantic understanding in storage, searching and providing of data or other content information
CN102591864A (en) * 2011-01-06 2012-07-18 上海银晨智能识别科技有限公司 Data updating method and device in comparison system
CN102184190A (en) * 2011-04-19 2011-09-14 北京神州数码思特奇信息技术股份有限公司 Data comparison method
CN103473643A (en) * 2013-09-10 2013-12-25 北京思特奇信息技术股份有限公司 Product management data auditing method and system for BOSS system

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
张彦君: "用户数据一致性稽核模型的建立与应用", 《中国优秀硕士学位论文全文数据库 信息科技辑》 *

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107291827A (en) * 2017-05-27 2017-10-24 北京思特奇信息技术股份有限公司 A kind of data comparison method and system
CN107291500A (en) * 2017-06-21 2017-10-24 北京奇虎科技有限公司 The data distributing method and device of launching process
CN109788052A (en) * 2019-01-02 2019-05-21 郑州云海信息技术有限公司 A kind of server configuration remote inquiry method, apparatus, terminal and storage medium
CN109788052B (en) * 2019-01-02 2021-11-26 郑州云海信息技术有限公司 Server configuration remote query method, device, terminal and storage medium
CN109783780A (en) * 2019-01-16 2019-05-21 平安普惠企业管理有限公司 A kind of document handling method and relevant apparatus
CN111339039A (en) * 2020-02-21 2020-06-26 京东数字科技控股有限公司 File comparison method and device, storage medium and electronic device
CN111831755A (en) * 2020-07-23 2020-10-27 北京思特奇信息技术股份有限公司 Cross-database data synchronization method, system, medium and equipment
CN111831755B (en) * 2020-07-23 2024-01-16 北京思特奇信息技术股份有限公司 Cross-database data synchronization method, system, medium and device

Also Published As

Publication number Publication date
CN106021301B (en) 2020-02-04

Similar Documents

Publication Publication Date Title
CN106021301A (en) Comparing system and method for data having different file formats
US10740372B2 (en) System and method for extracting data from a non-structured document
US9619512B2 (en) Memory searching system and method, real-time searching system and method, and computer storage medium
CN110990390B (en) Data cooperative processing method, device, computer equipment and storage medium
CN101464903A (en) OCR picture and text recognition and retrieval method and system through web mode
CN110705515A (en) Hospital paper archive filing method and system based on OCR character recognition
CN106547729B (en) A kind of dynamic creation method and system of data sheet
CN104537336A (en) Face identification method and system with self-learning function
CN103390163B (en) A kind of Post address automatic acquiring method
US10459804B2 (en) Database rollback using WAL
CN107291827A (en) A kind of data comparison method and system
CN115391439B (en) Document data export method, device, electronic equipment and storage medium
CN104182465A (en) Network-based big data processing method
CN103793487B (en) For concentrating the method and system of access to electronic signature account data
CN104008107A (en) Implement method of knowledge base on operation and maintenance management
CN108073705B (en) Distributed mass data aggregation acquisition method
CN102226893A (en) FAT (file allocation table) file system repairing method in embedded system
CN100514916C (en) Journal formatting unit and method in safety management center system
US10740638B1 (en) Data element profiles and overrides for dynamic optical character recognition based data extraction
CN109522528A (en) A kind of word document is converted to the method that can calculate automatically html document
CN102446206B (en) A kind of cross-platform switch and method of three-dimensional data
CN103902275A (en) Method and system for achieving conversion of language versions of applications
CN104320454A (en) Method and system for realizing user-defined output in HTTP protocol recovery
CN105353665A (en) Mobile phone deleted information recovery system based on Android system and method thereof
CN105023217A (en) IHE gateway and medical information processing method for medical information platform

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant