CN108681559A - A kind of comparison method and system based on multisystem data application - Google Patents
A kind of comparison method and system based on multisystem data application Download PDFInfo
- Publication number
- CN108681559A CN108681559A CN201810322822.XA CN201810322822A CN108681559A CN 108681559 A CN108681559 A CN 108681559A CN 201810322822 A CN201810322822 A CN 201810322822A CN 108681559 A CN108681559 A CN 108681559A
- Authority
- CN
- China
- Prior art keywords
- data
- tables
- item
- comparison
- multisystem
- 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
Links
Landscapes
- Image Analysis (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention relates to the technical fields of data of information system comparison method, more particularly, to a kind of comparison method and system based on multisystem data application, if the first tables of data is identical as the numerical value of comparison item of the second tables of data, and characteristic value E1Meet the first preset condition, E with the difference of first threshold2Meet the second preset condition and E with the difference of second threshold3Meet third preset condition with the difference of third threshold value, then judges that the first tables of data is consistent with the comparison item of the second tables of data.The present invention is not only compared data from the numerical value for comparing item itself, also utilizes the characteristic value auxiliary ratio pair of the relevant data of item compared with；The expression formula of each characteristic value is different, can give full expression to the degree of association of the related data compared with, and the consistency of item is compared in accurately reaction；Characteristic value can real-time update, the accuracy of comparison can be improved；Preset condition is adjustable, can adjust the accuracy compared according to suitable environment, adapt to the requirement of various environment.
Description
Technical field
The present invention relates to the technical fields of data of information system comparison method, and multisystem is based on more particularly, to one kind
The comparison method and system of data application.
Background technology
Power supply enterprise has multiple application systems, such as production system, marketing system, goods and materials system, toll collection system, each
A application system has the running environment and data storage method of oneself, to generate a variety of different databases.Each application
Development scheme, development environment and the development technique of system and to development specifications to defer to degree all different, each system it
Between close each other, data cannot be exchanged and be shared, to form big and small information island, by each system integration become development
Inexorable trend.However, there are the data of overlapping in each system of power supply enterprise, if integrating all systems, need to select it
In one group of data used as standard.
Invention content
It is an object of the invention to overcome the deficiencies of the prior art and provide a kind of ratio other side based on multisystem data application
Method and system, are not only compared data from the numerical value for comparing item itself, also utilize the relevant data of item compared with
Characteristic value auxiliary ratio pair can improve the accuracy of comparison.
In order to solve the above technical problems, the technical solution adopted by the present invention is：
A kind of comparison method based on multisystem data application is provided, the multisystem includes production system, marketing system, goods and materials
System and toll collection system, the described method comprises the following steps：
S1. it is respectively that each system establishes tables of data, each tables of data interval setting time scans the data that each system obtains each system
, the variable of each tables of data corresponds to the data item of each system；
S2. the first tables of data and the second tables of data to be compared are determined, between first tables of data and the second tables of data at least
Including a comparison item；
S3. the data item of the first tables of data and the second tables of data is divided into n groups, and calculates the characteristic value of n group data item, respectively
It is expressed as E1、 E2、E3、……、En；
S4. the numerical value for comparing the comparison item described in two groups of step S2 goes to step S5 if numerical value is identical；If numerical value is different,
Two groups of tables of data are then reacquired to be compared；
S5. the characteristic value for comparing the n group data item in step S3 goes to step S6 if the numerical value of characteristic value is equal；If feature
The numerical value of value is unequal, then goes to step S3；
S6. whether judging characteristic value meets corresponding preset condition with the difference of corresponding threshold value；If satisfied, then judging the first number
It is consistent with the comparison item of the second tables of data according to table；If not satisfied, then judging the comparison item of the first tables of data and the second tables of data not
Unanimously.
The comparison method of the multisystem data application of the present invention, in addition to comparing the ratio between the first tables of data and the second tables of data
Compared with item, also compare the characteristic value of n group data item, the expression formula of each group of data item is optional and different, can give full expression to and
Compare the degree of association of a related data, can accurately react the consistency for comparing item.
Preferably, in step S3, the method to data item grouping includes：By the data of the first tables of data and the second tables of data
Be arranged together, and wait number be divided into n section, according to data put in order successively from n sections selection data be put into the 1st group, the 2nd
Group ..., n-th group.It is as a result also more accurate in this way so that the characteristic value of data item calculates the data used evenly.
Preferably, the first tables of data and the second tables of data are divided into three groups, the corresponding threshold value includes numerical value adjustable
One threshold value, second threshold and third threshold value, corresponding preset condition include adjustable first preset condition of numerical value, second
Preset condition and third preset condition.If the first tables of data is identical as the numerical value of comparison item of the second tables of data, and E1With
The difference of one threshold value meets the first preset condition, E2Meet the second preset condition and E with the difference of second threshold3With third threshold
The difference of value meets third preset condition, then judges that the first tables of data is consistent with the comparison item of the second tables of data.Pass through ratio
To comparing item number value and three characteristic values can accurately react and compare the consistency of item, and it is the first preset condition, second pre-
If condition and third preset condition are adjustable, thus can adjust the accuracy of comparison, the requirement of various environment is adapted to.
Preferably, the characteristic value E of three groups of data item1、E2And E3Expression formula it is different, in following formula
It is a kind of：A0+Ai∑Xi、B0+Bi∑Xi iAnd C0+Ci∑lnXi；Wherein, XiFor the data of corresponding grouping, A0、Ai、B0、Bi、C0And Ci
It is fitted to obtain by multi-group data.E1、E2And E3Expression formula according to actual conditions select it is most suitable, can give full expression to
Compare the degree of association of a related data.
Preferably, it in step S1, in each tables of data after each system obtains data item, is beaten for the corresponding data of each data item
Upper time mark；In step S2, the time mark of the first tables of data item compared with the second tables of data is identical.Time mark is stamped for data,
Convenient for determining tables of data that needs compare according to the time；Choose the before the first tables of data and second tables of data compare
Data in one preset time fit A0, Ai, B0, Bi, C0 and Ci, can select the first preset time according to actual conditions,
If data variation is fast, the first preset time is also corresponding short；Be spaced the second preset time period fit again A0, Ai, B0,
Bi, C0 and Ci, the second preset time of interval are updated each term coefficient so that the E of calculating1、E2And E3It can more accurately use
In comparison.
Preferably, after step s 5：
If judging, the first tables of data is consistent with the comparison item of the second tables of data, and sending comparison one to corresponding system writes
Breath；
If judging, the comparison item of the first tables of data and second tables of data is inconsistent, stores comparison result, and be to corresponding
System sends a warning message.
A kind of scheme fed back to the system for generating data is provided, if comparison result is inconsistent, just sends and accuses
Alert information, facilitates correspondence system to be modified.
The present invention also provides a kind of Compare Systems based on multisystem data application, which is characterized in that is filled including obtaining
It sets, computing device and comparison device：
The acquisition device, for obtaining the first tables of data and the second tables of data to be compared；
The computing device is connect with acquisition device, for the data item of the first tables of data and the second tables of data to be divided into three groups,
And calculate the characteristic value of three groups of data item；
The comparison device is connect with computing device, the comparison item for comparing the first tables of data and the second tables of data；If numerical value
It is identical, and E1Meet the first preset condition, E with the difference of first threshold2With the difference of second threshold meet the second preset condition with
And E3Meet third preset condition with the difference of third threshold value, then judges the comparison item of the first tables of data and second tables of data
Unanimously.
Preferably, a comparison item is included at least between first tables of data and the second tables of data.
Compared with prior art, the beneficial effects of the invention are as follows：
（1）The comparison method and system based on multisystem data application of the present invention is also compared in addition to comparing corresponding relatively item
The corresponding characteristic value of each data item, the expression formula of each characteristic value is optional, and different, and it is related can to give full expression to the item compared with
The degree of association of data can accurately react the consistency for comparing item.
（2）The present invention the corresponding characteristic value of each data item can real-time update, the accurate of comparison can be further increased
Property.
（3）The present invention can send a warning message according to comparison result to corresponding system.
（4）The characteristic value of present invention preset condition corresponding with the corresponding difference of threshold value is adjustable, can be according to suitable environment
The accuracy compared is adjusted, the requirement of various environment is adapted to.
Description of the drawings
Fig. 1 is the flow chart of the comparison method based on multisystem data application of the present invention.
Specific implementation mode
The present invention is further illustrated With reference to embodiment.Wherein, attached drawing only for illustration,
What is indicated is only schematic diagram rather than pictorial diagram, should not be understood as the limitation to this patent；Reality in order to better illustrate the present invention
Example is applied, the certain components of attached drawing have omission, zoom in or out, and do not represent the size of actual product；To those skilled in the art
For, the omitting of some known structures and their instructions in the attached drawings are understandable.
The same or similar label correspond to the same or similar components in the attached drawing of the embodiment of the present invention；In retouching for the present invention
In stating, it is to be understood that if it is based on attached drawing to have the orientation or positional relationship of the instructions such as term "upper", "lower", "left", "right"
Shown in orientation or positional relationship, be merely for convenience of description of the present invention and simplification of the description, do not indicate or imply the indicated
Device or element must have a particular orientation, with specific azimuth configuration and operation, therefore position relationship described in attached drawing
Term only for illustration, should not be understood as the limitation to this patent, for the ordinary skill in the art, can
To understand the concrete meaning of above-mentioned term as the case may be.
Embodiment one
It is the flow chart that the first embodiment of the present invention is the comparison method based on multisystem data application, polyphyly as shown in Figure 1
System includes that production system, marketing system, goods and materials system and toll collection system, method include the following steps：
S1. it is respectively that each system establishes tables of data, each tables of data interval setting time scans the data that each system obtains each system
, the variable of each tables of data corresponds to the data item of each system；
S2. the first tables of data and the second tables of data to be compared are determined, is included at least between the first tables of data and the second tables of data
One comparison item；
S3. the data item of the first tables of data and the second tables of data is divided into n groups, and calculates the characteristic value of n group data item, respectively
It is expressed as E1、 E2、E3、……、En；
S4. the numerical value for comparing the comparison item in two groups of step S2 goes to step S5 if numerical value is identical；If numerical value is different, weigh
Two groups of tables of data are newly obtained to be compared；
S5. the characteristic value for comparing the n group data item in step S3 goes to step S6 if the numerical value of characteristic value is equal；If feature
The numerical value of value is unequal, then goes to step S3；
S6. whether judging characteristic value meets corresponding preset condition with the difference of corresponding threshold value；If satisfied, then judging the first number
It is consistent with the comparison item of the second tables of data according to table；If not satisfied, then judging the comparison item of the first tables of data and the second tables of data not
Unanimously.
The present embodiment also compares the spy of n group data item in addition to comparing the comparison item between the first tables of data and the second tables of data
The expression formula of value indicative, each group of data item is optional and different, can give full expression to the degree of association of the related data compared with, energy
The consistency of item is compared in enough accurate reactions.
Wherein, in step S3, the method to data item grouping includes：The data of first tables of data and the second tables of data are arranged
Be listed in together, and wait number be divided into 3 sections, according to data put in order successively from 3 sections choose data be put into the 1st group, the 2nd group,
3rd group so that the characteristic value of data item calculates the data used evenly, as a result also more accurate；If the first tables of data and second
The numerical value of the comparison item of tables of data is identical, and E1Meet the first preset condition, E with the difference of first threshold2With the difference of second threshold
The second preset condition of different satisfaction and E3Meet third preset condition with the difference of third threshold value, then judges the first tables of data and the
The comparison item of two tables of data is consistent.It can accurately react by comparing numerical value and three characteristic values and compare the consistent of item
Property, and the first preset condition, the second preset condition and third preset condition are adjustable, thus the accuracy of comparison can be adjusted,
Adapt to the requirement of various environment.
The characteristic value E of three groups of data item1、E2And E3Expression formula it is different, one kind in following formula：A0+
Ai∑Xi、B0+Bi∑Xi iAnd C0+Ci∑lnXi；Wherein, XiFor the data of corresponding grouping, A0、Ai、B0、Bi、C0And CiPass through more
Group data are fitted to obtain, most suitable according to actual conditions selection, can give full expression to the degree of association of the related data compared with.
After step s 5：If judging, the first tables of data is consistent with the comparison item of the second tables of data, is sent out to corresponding system
Send comparison consistent information；If judging, the comparison item of the first tables of data and the second tables of data is inconsistent, stores comparison result, and to
Corresponding system sends a warning message, and correspondence system is facilitated to be modified.
In addition, in step S1, in each tables of data after each system obtains data item, stamped for the corresponding data of each data item
Time marks；In step S2, the time mark of the first tables of data item compared with the second tables of data is identical.Time mark is stamped for data, just
In determining tables of data that needs compare according to the time；It chooses first default before the first tables of data and the second tables of data compare
Data in time fit A0, Ai, B0, Bi, C0 and Ci, the first preset time can be selected according to actual conditions, if data
Variation is fast, and the first preset time is also corresponding short；Be spaced the second preset time period fit again A0, Ai, B0, Bi, C0 and
Ci, the second preset time of interval are updated each term coefficient so that the E of calculating1、E2And E3It more accurately can be used to compare.
Embodiment two
Embodiment two is the Compare System based on multisystem data application, including acquisition device, computing device and comparison device：
Acquisition device, for obtaining the first tables of data and the second tables of data to be compared, the first tables of data and the second tables of data it
Between include at least a comparison item.
Computing device is connect with acquisition device, for the data item of the first tables of data and the second tables of data to be divided into three groups,
And calculate the characteristic value of three groups of data item；
Comparison device is connect with computing device, the comparison item for comparing the first tables of data and the second tables of data；If numerical value is identical,
And E1Meet the first preset condition, E with the difference of first threshold2Meet the second preset condition and E with the difference of second threshold3
Meet third preset condition with the difference of third threshold value, then judges that the first tables of data is consistent with the comparison item of the second tables of data.
Obviously, the above embodiment of the present invention be only to clearly illustrate example of the present invention, and not be pair
The restriction of embodiments of the present invention.For those of ordinary skill in the art, may be used also on the basis of the above description
To make other variations or changes in different ways.There is no necessity and possibility to exhaust all the enbodiments.It is all this
All any modification, equivalent and improvement etc., should be included in the claims in the present invention made by within the spirit and principle of invention
Protection domain within.
Claims (8)
1. a kind of comparison method based on multisystem data application, which is characterized in that the multisystem includes production system, marketing
System, goods and materials system and toll collection system, the described method comprises the following steps：
S1. it is respectively that each system establishes tables of data, each tables of data interval setting time scans the data that each system obtains each system
, the variable of each tables of data corresponds to the data item of each system；
S2. the first tables of data and the second tables of data to be compared are determined, between first tables of data and the second tables of data at least
Including a comparison item；
S3. the data item of the first tables of data and the second tables of data is divided into n groups, and calculates the characteristic value of n group data item, respectively
It is expressed as E1、 E2 、E3、 ……、En；
S4. the numerical value for comparing the comparison item described in two groups of step S2 goes to step S5 if numerical value is identical；If numerical value is different,
Two groups of tables of data are then reacquired to be compared；
S5. the characteristic value for comparing the n group data item in step S3 goes to step S6 if the numerical value of characteristic value is equal；If feature
The numerical value of value is unequal, then goes to step S3；
S6. whether judging characteristic value meets corresponding preset condition with the difference of corresponding threshold value；If satisfied, then judging the first number
It is consistent with the comparison item of the second tables of data according to table；If not satisfied, then judging the comparison item of the first tables of data and the second tables of data not
Unanimously.
2. the comparison method according to claim 1 based on multisystem data application, which is characterized in that right in step S3
Data item grouping method include：Together with the first tables of data and the data arrangement of the second tables of data, and number is waited to be divided into n sections,
According to data put in order successively from n sections choose data be put into the 1st group, the 2nd group ..., n-th group.
3. the comparison method according to claim 2 based on multisystem data application, which is characterized in that by the first tables of data
It is divided into three groups with the second tables of data, the corresponding threshold value includes the adjustable first threshold of numerical value, second threshold and third threshold value,
Corresponding preset condition includes adjustable first preset condition of numerical value, the second preset condition and third preset condition.
4. the comparison method according to claim 3 based on multisystem data application, which is characterized in that three groups of data item
Characteristic value E1、E2And E3Expression formula it is different, one kind in following formula：A0+Ai∑Xi、B0+Bi∑Xi iAnd C0+
Ci∑lnXi；Wherein, XiFor the data of corresponding grouping, A0、Ai、B0、Bi、C0And CiIt is fitted to obtain by multi-group data.
5. the comparison method according to claim 1 based on multisystem data application, which is characterized in that in step S1,
Each tables of data stamps time mark after each system obtains data item, for the corresponding data of each data item；In step S2, the first data
The time mark of table item compared with the second tables of data is identical.
6. the comparison method according to claim 1 based on multisystem data application, which is characterized in that step S5 it
Afterwards：
If judging, the first tables of data is consistent with the comparison item of the second tables of data, and sending comparison one to corresponding system writes
Breath；
If judging, the comparison item of the first tables of data and second tables of data is inconsistent, stores comparison result, and be to corresponding
System sends a warning message.
7. a kind of Compare System based on multisystem data application, which is characterized in that including acquisition device, computing device and ratio
To device：
The acquisition device, for obtaining the first tables of data and the second tables of data to be compared；
The computing device is connect with acquisition device, for the data item of the first tables of data and the second tables of data to be divided into n groups, and
Calculate the characteristic value of n group data item；
The comparison device is connect with computing device, the comparison item for comparing the first tables of data and the second tables of data.
8. the Compare System according to claim 7 based on multisystem data application, which is characterized in that first data
A comparison item is included at least between table and the second tables of data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810322822.XA CN108681559B (en) | 2018-04-11 | 2018-04-11 | Comparison method and system based on multi-system data application |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810322822.XA CN108681559B (en) | 2018-04-11 | 2018-04-11 | Comparison method and system based on multi-system data application |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108681559A true CN108681559A (en) | 2018-10-19 |
| CN108681559B CN108681559B (en) | 2020-09-25 |
Family
ID=63800904
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810322822.XA Active CN108681559B (en) | 2018-04-11 | 2018-04-11 | Comparison method and system based on multi-system data application |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108681559B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110287182A (en) * | 2019-05-05 | 2019-09-27 | 浙江吉利控股集团有限公司 | A kind of data comparison method, apparatus, equipment and the terminal of big data |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102411588A (en) * | 2010-09-26 | 2012-04-11 | 金蝶软件（中国）有限公司 | Comparison checking method and system of data table |
| CN104239301A (en) * | 2013-06-06 | 2014-12-24 | 阿里巴巴集团控股有限公司 | Data comparing method and device |
| CN105677645A (en) * | 2014-11-17 | 2016-06-15 | 阿里巴巴集团控股有限公司 | Data sheet comparison method and device |
| CN106846136A (en) * | 2016-12-23 | 2017-06-13 | 税友软件集团股份公司 | A kind of data comparison method and equipment |
-
2018
- 2018-04-11 CN CN201810322822.XA patent/CN108681559B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102411588A (en) * | 2010-09-26 | 2012-04-11 | 金蝶软件（中国）有限公司 | Comparison checking method and system of data table |
| CN104239301A (en) * | 2013-06-06 | 2014-12-24 | 阿里巴巴集团控股有限公司 | Data comparing method and device |
| CN105677645A (en) * | 2014-11-17 | 2016-06-15 | 阿里巴巴集团控股有限公司 | Data sheet comparison method and device |
| CN106846136A (en) * | 2016-12-23 | 2017-06-13 | 税友软件集团股份公司 | A kind of data comparison method and equipment |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110287182A (en) * | 2019-05-05 | 2019-09-27 | 浙江吉利控股集团有限公司 | A kind of data comparison method, apparatus, equipment and the terminal of big data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108681559B (en) | 2020-09-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105550199B (en) | A kind of point polymerization and device based on multi-source map | |
| CN104537068B (en) | A kind of electronic map cut-in method and device | |
| CN107169041A (en) | Subgrade and pavement compacting counting monitoring device and method based on grid graph | |
| CN106230907A (en) | A kind of big data visualization method of social security and system | |
| CN109977273A (en) | A kind of topology drawing generating method, device, equipment and readable storage medium storing program for executing | |
| Zhao et al. | Morphological quantitative criteria and aesthetic evaluation of eight female Han face types | |
| CN109726587A (en) | A kind of Spatial-data Integration method based on difference privacy | |
| CN109254976A (en) | A kind of method for drafting of figure, device, electronic equipment and storage medium | |
| CN108681559A (en) | A kind of comparison method and system based on multisystem data application | |
| CN108932433A (en) | A kind of industrial data shared system and method based on block chain | |
| CN106817271B (en) | Method and device for forming flow map | |
| CN110310368A (en) | A kind of soil regime thematic mapping method based on Mapgis | |
| CN106484845B (en) | Information point area determination method and device based on electronic map | |
| CN110008521A (en) | A kind of distribution dynamic loading Time domain identification method based on subregion interpolation | |
| US20180113924A1 (en) | Data provision apparatus and data provision method | |
| CN110933743A (en) | Positioning method and device based on Received Signal Strength Indicator (RSSI) | |
| CN105893998A (en) | Method and device for estimating density of real points in assigned area | |
| CN102136110A (en) | Method for generating specification and size comparison table for scale clothes ordering and scale clothes ordering production method | |
| CN108897799A (en) | A kind of water resource based on Web GIS and economic society matching relationship visualization system | |
| CN109002997B (en) | SV server product line working hour KPI accounting method and system based on MES data | |
| Gold | Modeling short-run cost and production functions in computerized business simulations | |
| CN108510778B (en) | Vehicle aggregation display implementation method based on recorder management platform | |
| CN107544954A (en) | A kind of clothes number of sentencing check mark method automatically | |
| Krishnaji | On Measuring Incidence of Undernutrition: What Is a Consumer Unit? | |
| Morrison | Marginal Cost Pricing and the Theory of Second Best |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |