CN108681559B - Comparison method and system based on multi-system data application - Google Patents
Comparison method and system based on multi-system data application Download PDFInfo
- Publication number
- CN108681559B CN108681559B CN201810322822.XA CN201810322822A CN108681559B CN 108681559 B CN108681559 B CN 108681559B CN 201810322822 A CN201810322822 A CN 201810322822A CN 108681559 B CN108681559 B CN 108681559B
- Authority
- CN
- China
- Prior art keywords
- data
- comparison
- data table
- items
- groups
- 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.)
- Active
Links
Images
Abstract
The invention relates to the technical field of information system data comparison methods, in particular to a comparison method and a comparison system based on multi-system data application1A difference from the first threshold value satisfies a first preset condition, E2The difference from the second threshold value satisfies a second preset condition and E3And if the difference between the first data table and the third threshold value meets a third preset condition, judging that the comparison items of the first data table and the second data table are consistent. The invention not only compares the data from the numerical value of the comparison item, but also utilizes the characteristic value of the data related to the comparison item to assist in comparison; the expressions of the characteristic values are different, so that the relevance degree of the data related to the comparison items can be fully expressed, and the consistency of the comparison items can be accurately reflected; the characteristic value can be updated in real time, and the comparison accuracy can be improved; the preset condition is adjustable, and the comparison accuracy can be adjusted according to the applicable environment, so that the requirements of various environments are met.
Description
Technical Field
The invention relates to the technical field of information system data comparison methods, in particular to a comparison method and a comparison system based on multi-system data application.
Background
The power supply enterprise is provided with a plurality of application systems, such as a production system, a marketing system, a material system, a charging system and the like, wherein each application system has an own operating environment and a data storage mode, so that various databases are generated. The development modes, development environments, development technologies and compliance degrees of development specifications of all application systems are different, all the systems are closed, data cannot be exchanged and shared, and therefore a large and small information isolated island is formed, and all the systems are integrated into a necessary trend of development. However, the power supply enterprise has overlapping data in each system, and if all the systems are to be integrated, one set of data needs to be selected as a standard for use.
Disclosure of Invention
The invention aims to overcome the defects of the prior art and provide a comparison method and a comparison system based on multi-system data application, which not only compare data from the numerical value of a comparison item, but also assist in comparison by utilizing the characteristic value of the data related to the comparison item, and can improve the comparison accuracy.
In order to solve the technical problems, the invention adopts the technical scheme that:
the method for comparing the data of multiple systems based on application is provided, wherein the multiple systems comprise a production system, a marketing system, a material system and a charging system, and the method comprises the following steps:
s1, respectively establishing data tables for the systems, scanning the systems at intervals of set time to obtain data items of the systems, wherein variables of the data tables correspond to the data items of the systems;
s2, determining a first data table and a second data table to be compared, wherein at least one comparison item is included between the first data table and the second data table;
s3, dividing the data items of the first data table and the second data table into n groups, and calculating the characteristic values of the n groups of data items, which are respectively expressed as E1、 E2、E3、……、En;
S4, comparing the values of the two sets of comparison items in the step S2, if the values are the same, turning to the step S5; if the numerical values are different, two groups of data tables are obtained again for comparison;
s5, comparing the characteristic values of the n groups of data items in the step S3, and if the numerical values of the characteristic values are equal, turning to the step S6; if the values of the characteristic values are not equal, turning to step S3;
s6, judging whether the difference between the characteristic value and the corresponding threshold value meets the corresponding preset condition; if yes, judging that the comparison items of the first data table and the second data table are consistent; if not, judging that the comparison items of the first data table and the second data table are inconsistent.
The comparison method for the multi-system data application not only compares the comparison items between the first data table and the second data table, but also compares the characteristic values of n groups of data items, and the expressions of the groups of data items are optional and different, so that the association degree of the data related to the comparison items can be fully expressed, and the consistency of the comparison items can be accurately reflected.
Preferably, in step S3, the method of grouping data items includes: and arranging the data of the first data table and the second data table together, equally dividing the data into n sections, and sequentially selecting the data from the n sections according to the arrangement sequence of the data to be placed into the 1 st group, the 2 nd group, … … and the nth group. This makes the feature value calculation of the data item more uniform and the result more accurate.
Preferably, the first data table and the second data table are divided into three groups, the corresponding threshold includes a first threshold, a second threshold and a third threshold, which are adjustable in value, and the corresponding preset condition includes a first preset condition, a second preset condition and a third preset condition, which are adjustable in value. If the values of the comparison items in the first data table and the second data table are the same, and E1A difference from the first threshold value satisfies a first preset condition, E2The difference from the second threshold value satisfies a second preset condition and E3And if the difference between the first data table and the third threshold value meets a third preset condition, judging that the comparison items of the first data table and the second data table are consistent. The consistency of the comparison items can be accurately reflected by comparing the numerical values of the comparison items with the three characteristic values, and the first preset condition, the second preset condition and the third preset condition are adjustable, so that the comparison accuracy can be adjusted, and the requirements of various environments are met.
Preferably, the characteristic values E of three groups of data items1、E2And E3Are different from each other and are selected from one of the following expressions: a. the0+Ai∑Xi、B0+Bi∑Xi iAnd C0+Ci∑lnXi(ii) a Wherein, XiFor data of the corresponding packet, A0、Ai、B0、Bi、C0And CiAre obtained by fitting multiple sets of data. E1、E2And E3The expression of (2) is selected to be most suitable according to actual conditions, and the correlation degree of the data related to the comparison item can be fully expressed.
Preferably, in step S1, after each data table acquires data items from each system, each number isTime marks are marked on data corresponding to the items; in step S2, the time stamps of the comparison entries of the first data table and the second data table are the same. Time marks are marked on the data, so that a data table needing to be compared can be conveniently determined according to time; selecting a first data table and a second data table to match data in a first preset time before comparison to obtain A0, Ai, B0, Bi, C0 and Ci, wherein the first preset time can be selected according to actual conditions, and if the data change is fast, the first preset time is correspondingly short; fitting A0, Ai, B0, Bi, C0 and Ci again at intervals of a second preset time period, and updating each coefficient at intervals of the second preset time period to enable the calculated E1、E2And E3Can be used more accurately for alignment.
Preferably, after step S5:
if the comparison items of the first data table and the second data table are judged to be consistent, comparison consistent information is sent to a corresponding system;
and if the comparison items of the first data table and the second data table are not consistent, storing the comparison result and sending alarm information to the corresponding system.
The scheme for feeding back the data to the system generating the data is provided, and if the comparison result is inconsistent, the alarm information is sent, so that the corresponding system can be corrected conveniently.
The invention also provides a comparison system based on multi-system data application, which is characterized by comprising an acquisition device, a calculation device and a comparison device, wherein the acquisition device comprises a first acquisition module, a second acquisition module and a comparison module, and the comparison device comprises a first comparison module, a second comparison module and a third comparison module, wherein the first comparison module comprises a first comparison module:
the acquisition device is used for acquiring a first data table and a second data table to be compared;
the calculating device is connected with the acquiring device and is used for dividing the data items of the first data table and the second data table into three groups and calculating the characteristic values of the three groups of data items;
the comparison device is connected with the calculation device and is used for comparing the comparison items of the first data table and the second data table; if the values are the same, and E1A difference from the first threshold value satisfies a first preset condition, E2The difference from the second threshold value satisfies a second preset condition and E3The difference from the third threshold satisfies the secondAnd if the three preset conditions are met, judging that the comparison items of the first data table and the second data table are consistent.
Preferably, at least one comparison item is included between the first data table and the second data table.
Compared with the prior art, the invention has the beneficial effects that:
(1) the comparison method and the comparison system based on the multi-system data application not only compare the corresponding comparison items, but also compare the characteristic values corresponding to the data items, and the expressions of the characteristic values are optional and different, so that the association degree of the relevant data with the comparison items can be fully expressed, and the consistency of the comparison items can be accurately reflected.
(2) The characteristic values corresponding to the data items can be updated in real time, and the comparison accuracy can be further improved.
(3) The invention can send the alarm information to the corresponding system according to the comparison result.
(4) The preset condition corresponding to the difference between the characteristic value and the corresponding threshold value is adjustable, and the comparison accuracy can be adjusted according to the applicable environment, so that the requirements of various environments are met.
Drawings
FIG. 1 is a flowchart of the comparison method based on multi-system data application of the present invention.
Detailed Description
The present invention will be further described with reference to the following embodiments. Wherein the showings are for the purpose of illustration only and are shown by way of illustration only and not in actual form, and are not to be construed as limiting the present patent; to better illustrate the embodiments of the present invention, some parts of the drawings may be omitted, enlarged or reduced, and do not represent the size of an actual product; it will be understood by those skilled in the art that certain well-known structures in the drawings and descriptions thereof may be omitted.
The same or similar reference numerals in the drawings of the embodiments of the present invention correspond to the same or similar components; in the description of the present invention, it should be understood that if there is an orientation or positional relationship indicated by the terms "upper", "lower", "left", "right", etc. based on the orientation or positional relationship shown in the drawings, it is only for convenience of describing the present invention and simplifying the description, but it is not intended to indicate or imply that the referred device or element must have a specific orientation, be constructed in a specific orientation, and be operated, and therefore, the terms describing the positional relationship in the drawings are only used for illustrative purposes and are not to be construed as limiting the present patent, and the specific meaning of the terms may be understood by those skilled in the art according to specific circumstances.
Example one
Fig. 1 is a flowchart of a comparison method based on multi-system data application according to a first embodiment of the present invention, where the multi-system includes a production system, a marketing system, a material system, and a charging system, and the method includes the following steps:
s1, respectively establishing data tables for the systems, scanning the systems at intervals of set time to obtain data items of the systems, wherein variables of the data tables correspond to the data items of the systems;
s2, determining a first data table and a second data table to be compared, wherein at least one comparison item is included between the first data table and the second data table;
s3, dividing the data items of the first data table and the second data table into n groups, and calculating the characteristic values of the n groups of data items, which are respectively expressed as E1、 E2、E3、……、En;
S4, comparing the values of the two sets of comparison items in the step S2, if the values are the same, turning to the step S5; if the numerical values are different, two groups of data tables are obtained again for comparison;
s5, comparing the characteristic values of the n groups of data items in the step S3, and if the numerical values of the characteristic values are equal, turning to the step S6; if the values of the characteristic values are not equal, turning to step S3;
s6, judging whether the difference between the characteristic value and the corresponding threshold value meets the corresponding preset condition; if yes, judging that the comparison items of the first data table and the second data table are consistent; if not, judging that the comparison items of the first data table and the second data table are inconsistent.
In the embodiment, in addition to comparing the comparison items between the first data table and the second data table, the characteristic values of n groups of data items are also compared, the expressions of the groups of data items are optional and different, the association degree of the data related to the comparison items can be fully expressed, and the consistency of the comparison items can be accurately reflected.
In step S3, the method for grouping data items includes: arranging the data of the first data table and the data of the second data table together, equally dividing the data into 3 sections, and sequentially selecting the data from the 3 sections according to the arrangement sequence of the data and putting the data into a 1 st group, a 2 nd group and a 3 rd group, so that the characteristic values of the data items are calculated and used more uniformly, and the result is more accurate; if the values of the comparison items in the first data table and the second data table are the same, and E1A difference from the first threshold value satisfies a first preset condition, E2The difference from the second threshold value satisfies a second preset condition and E3And if the difference between the first threshold and the third threshold meets a third preset condition, judging that the comparison items of the first data table and the second data table are consistent. The consistency of the comparison items can be accurately reflected by comparing the numerical values of the comparison items with the three characteristic values, and the first preset condition, the second preset condition and the third preset condition are adjustable, so that the comparison accuracy can be adjusted, and the requirements of various environments are met.
Characteristic values E of three groups of data items1、E2And E3Are different from each other and are selected from one of the following expressions: a. the0+Ai∑Xi、B0+Bi∑Xi iAnd C0+Ci∑lnXi(ii) a Wherein, XiFor data of the corresponding packet, A0、Ai、B0、Bi、C0And CiAll the data are obtained by fitting a plurality of groups of data, the most suitable data are selected according to actual conditions, and the association degree of the data related to the comparison items can be fully expressed.
After step S5: if the comparison items of the first data table and the second data table are judged to be consistent, comparison consistent information is sent to a corresponding system; and if the comparison items of the first data table and the second data table are not consistent, storing the comparison result, and sending alarm information to the corresponding system, so that the corresponding system can be corrected conveniently.
In step S1, after the data items are acquired from the systems in the data tables, time stamps are applied to the data corresponding to the data items; in step S2, the time stamps of the comparison entries of the first data table and the second data table are the same. Time marks are marked on the data, so that a data table needing to be compared can be conveniently determined according to time; selecting a first data table and a second data table to match data in a first preset time before comparison to obtain A0, Ai, B0, Bi, C0 and Ci, wherein the first preset time can be selected according to actual conditions, and if the data change is fast, the first preset time is correspondingly short; fitting A0, Ai, B0, Bi, C0 and Ci again at intervals of a second preset time period, and updating each coefficient at intervals of the second preset time period to enable the calculated E1、E2And E3Can be used more accurately for alignment.
Example two
The second embodiment is a comparison system based on multi-system data application, which comprises an acquisition device, a calculation device and a comparison device:
the device comprises an acquisition device and a comparison device, wherein the acquisition device is used for acquiring a first data table and a second data table to be compared, and at least one comparison item is included between the first data table and the second data table.
The calculating device is connected with the acquiring device and is used for dividing the data items of the first data table and the second data table into three groups and calculating the characteristic values of the three groups of data items;
the comparison device is connected with the calculation device and used for comparing the comparison items of the first data table and the second data table; if the values are the same, and E1A difference from the first threshold value satisfies a first preset condition, E2The difference from the second threshold value satisfies a second preset condition and E3And if the difference between the first threshold and the third threshold meets a third preset condition, judging that the comparison items of the first data table and the second data table are consistent.
It should be understood that the above-described embodiments of the present invention are merely examples for clearly illustrating the present invention, and are not intended to limit the embodiments of the present invention. Other variations and modifications will be apparent to persons skilled in the art in light of the above description. And are neither required nor exhaustive of all embodiments. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the claims of the present invention.
Claims (4)
1. A comparison method based on multi-system data application is characterized in that the multi-system comprises a production system, a marketing system, a material system and a charging system, and the method comprises the following steps:
s1, respectively establishing data tables for each system, scanning each system at intervals of set time to obtain data items of each system, wherein variables of each data table correspond to the data items of each system;
s2, determining a first data table and a second data table to be compared, wherein at least one comparison item is included between the first data table and the second data table;
s3, dividing the data items of the first data table and the second data table into n groups, and calculating characteristic values of the n groups of data items, wherein the characteristic values are respectively expressed as E1、E2、E3、……、En;
S4, comparing the numerical values of the comparison items in the two groups of the step S2, and if the numerical values are the same, turning to a step S5; if the numerical values are different, two groups of data tables are obtained again for comparison;
s5, comparing the characteristic values of the n groups of data items in the step S3, and if the numerical values of the characteristic values are equal, turning to a step S6; if the values of the characteristic values are not equal, turning to step S3;
s6, judging whether the difference between the characteristic value and the corresponding threshold value meets corresponding preset conditions or not; if yes, judging that the comparison items of the first data table and the second data table are consistent; if not, judging that the comparison items of the first data table and the second data table are inconsistent;
the method of grouping data items includes: arranging the data of the first data table and the second data table together, equally dividing the data into n sections, and sequentially selecting the data from the n sections according to the arrangement sequence of the data to be placed into a 1 st group, a 2 nd group, … … and an nth group;
dividing a first data table and a second data table into three groups, wherein the corresponding threshold comprises a first threshold, a second threshold and a third threshold with adjustable numerical values, and the corresponding preset conditions comprise a first preset condition, a second preset condition and a third preset condition with adjustable numerical values;
characteristic values E of three groups of data items1、E2And E3Are different from each other and are selected from one of the following expressions: a. the0+Ai∑Xi、B0+Bi∑Xi iAnd C0+Ci∑lnXi(ii) a Wherein, XiFor data of the corresponding packet, A0、Ai、B0、Bi、C0And CiAre obtained by fitting multiple sets of data.
2. The multisystem data application-based comparison method as claimed in claim 1, wherein in step S1, after the data items are obtained from each system by each data table, time stamps are applied to the data corresponding to each data item; in step S2, the time stamps of the comparison entries of the first data table and the second data table are the same.
3. The multisystem data application-based alignment method according to claim 1, characterized in that after step S5:
if the comparison items of the first data table and the second data table are judged to be consistent, comparison consistent information is sent to a corresponding system;
and if the comparison items of the first data table and the second data table are not consistent, storing the comparison result and sending alarm information to the corresponding system.
4. A multisystem data application-based comparison system to which the multisystem data application-based comparison method according to any one of claims 1 to 3 is applied, comprising an acquisition device, a calculation device, and a comparison device:
the acquisition device is used for acquiring a first data table and a second data table to be compared;
the calculating device is connected with the acquiring device and is used for dividing the data items of the first data table and the second data table into n groups and calculating the characteristic values of the n groups of data items;
the comparison device is connected with the calculation device and is used for comparing the comparison items of the first data table and the second data table;
at least one comparison item is included between the first data table and the second data table.
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 CN108681559A (en) | 2018-10-19 |
CN108681559B true 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) |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110287182B (en) * | 2019-05-05 | 2021-09-14 | 浙江吉利控股集团有限公司 | Big data comparison method, device, equipment and terminal |
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 |
Also Published As
Publication number | Publication date |
---|---|
CN108681559A (en) | 2018-10-19 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20190377788A1 (en) | Methods and systems for language-agnostic machine learning in natural language processing using feature extraction | |
US10733302B2 (en) | Security vulnerability analytics engine | |
US20120209859A1 (en) | Methods and systems to profile individuals and organizations, and to evaluate culture fit | |
CN109711925A (en) | Cross-domain recommending data processing method, cross-domain recommender system with multiple auxiliary domains | |
US20150186787A1 (en) | Cloud-based plagiarism detection system | |
US20210157842A1 (en) | Information providing system and information providing method | |
CN106528641B (en) | Data storage method and device and communication gateway machine | |
CN110046146A (en) | The monitoring method and device of industrial equipment based on mobile edge calculations | |
CN108681559B (en) | Comparison method and system based on multi-system data application | |
CN102857949A (en) | Method and device for planning data consistency guarantees | |
CN104408189B (en) | The methods of exhibiting and device of keyword ranking | |
Bedau et al. | Open-ended technological innovation | |
CN112463986A (en) | Information storage method and device | |
US20090164432A1 (en) | System and method for generating a product report | |
CA3142579A1 (en) | Method and apparatus for validation of event tracking acquired data | |
CN102542389A (en) | Part information integration system and method | |
WO2019033032A3 (en) | Diversity evaluation in genealogy search | |
US20180129710A1 (en) | Information processing apparatus, information processing method, and non-transitory computer readable recording medium | |
Wang et al. | Personalized individual semantics based approach to MAGDM with the linguistic preference information on alternatives | |
TW201802749A (en) | Landmark recommendation method combined with life behavior analysis and community, and computer program product thereof capable of meeting needs of an user in searching for a landmark | |
Bajeel et al. | Reliability test plan for a series system with variable failure rates | |
KR20150114143A (en) | Apparatus and method for evaluating intellectual property | |
CN104636935A (en) | Software platform for seed tracing | |
Joekes et al. | A comparative study of two proposed CCC-r charts for high quality processes and their application to an injection molding process | |
CN103745314A (en) | Receipt table transmission method and receipt table transmission device |
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 |