CN104731814B - Data flexibly compare analysis system and method - Google Patents
Data flexibly compare analysis system and method Download PDFInfo
- Publication number
- CN104731814B CN104731814B CN201310717829.9A CN201310717829A CN104731814B CN 104731814 B CN104731814 B CN 104731814B CN 201310717829 A CN201310717829 A CN 201310717829A CN 104731814 B CN104731814 B CN 104731814B
- Authority
- CN
- China
- Prior art keywords
- data
- information
- source
- comparison
- module
- 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
Abstract
The invention discloses a kind of data flexibly to compare analysis system and method, and the analysis system includes：Data source configuration module, tables of data AM access module, user-defined data table data module, comparison model configuration module, correlation model configuration module, comparison task management module, comparison result warning module, comparison result statistical analysis module, comparison result correlation inquiry module；Wherein, comparison model configuration module can carry out the configuration of next round comparison model on the basis of comparison result data message, to realize the recycle ratio pair of data.
Description
Technical field
The invention mainly relates to comparing, data statistics and the association analysis of data mining, more particularly to a kind of number
Analysis system is compared according to flexible.
Background technology
With the continuous progress of society, scientific and technical fast development, all generated greatly in industry-by-industry, government department
Amount, multiple types data.How according to different demands to utilize these data well, find relation between data and
The value of data inner deep time, is current urgent problem.
In order to solve these problems, occurring a variety of comparing instruments on current market, alignments are also a lot, but its
The relation that cardinal principle is all based between data is compared, and comparison data source is mostly based on database of the same race, alignments profit
It is associated with the associate field between database table；For this kind of comparing instrument, because the data of comparison can only be based on
Database of the same race, therefore, the selection of the comparison data source of this kind of comparison instrument lack flexibility；
For being compared between data, it is necessary first to carry out the contextual definition between data, that is, we often say
Comparison model defines, and often most of comparison instruments embody less to the concept of model definition, and configuration is also fairly simple, it is impossible to according to
Some complex logic models are flexibly configured according to the thinking of user.This kind of comparing instrument causes business personnel to be difficult to according to certainly
Oneself demand carries out flexibly comparing configuration；
For comparison result caused by comparison instrument, most of instruments provide single result retrieval function.It is but right
For a powerful comparison instrument, it can not only be retrieved for caused result, it is also necessary to result data by difference
Dimension carries out statistical analysis, finds its inherent law, while should also further go to find the association between result data, and
Associating between the source data of result data and other data sources, therefore this kind of comparing instrument lacks deep layer to comparison result
Secondary application, business personnel are difficult to the profound value for finding comparison result.
Some comparison instruments in existing patent application be present, as disclosed in Chinese patent application CN201210461090.5
A kind of similar document query method based on stop words, this kind of method is compared by obtaining the data of multiple data sources,
But this kind of method can not flexibly configure comparison model, and then make it that this kind of method alignments are single, can only be to two groups of numbers
According to once being compared, it is impossible to model configuration is compared according to the demand of business personnel oneself.
For the quick identification project of transmitting and converting electricity environmental risk of one kind disclosed in Chinese patent CN201010509834.7
Method, this kind of method includes analysis, early warning, comparison and statistics to data, but this kind of method can not be configured flexibly
Comparison model, and analysis means included in this kind of method simply simple analysis, do not accomplish the profound level to data
Analysis and statistics.
Due to the above problems, the present inventor grinds to the existing comparison correlation technique such as software and comparison technology
Study carefully and analyze, with expect develop can flexibly select data source, multiple recycle ratio to, comparison model can be flexibly set
The data that profound analysis can be carried out to the result data of comparison again simultaneously flexibly compare analysis system and method.
The content of the invention
In order to solve the above problems, present inventor has performed studying with keen determination, as a result find：By setting data source to configure mould
Block carries out the definition of data source information to multiple different Service Databases, to allow the system to carry out multiple data sources
Flexibly use；By setting comparison model configuration module to be used to set comparison model so that business personnel can be according to the need of oneself
Ask flexible and comparison model be set, at the same by comparison model be circularly set the system can repeatedly recycle ratio to this
The time that sample saves comparison improves comparison efficiency；By set comparison result warning module, comparison result statistical analysis and
Comparison result correlation inquiry module allows business personnel to carry out profound analysis, statistics excavation to comparing result data information
Or early warning；So as to complete the present invention.
It is an object of the invention to provide following aspect：
First aspect, a kind of data flexibly compare analysis system, it is characterised in that the analysis system includes showing system
001st, application system 002 and data system 003；
Wherein, application system 002 includes：
Data source configuration module 0021, it is used for causing tables of data AM access module 0022 receives to come as Data connection module
From the data table information of Service Database 0031, and cause user-defined data table data module 0023 receives to come from self-defining data storehouse
0032 data table information；
Tables of data AM access module 0022, it receives data table information in Service Database 0031, and by reception
Data table information is respectively transmitted to comparison model configuration module 0025 and correlation model configuration module 0026；
User-defined data table data module 0023, its business datum of input is stored in self-defining data storehouse 0032,
Also match somebody with somebody to receive the data table information in self-defined database 0032 and the data table information of reception is sent into comparison model
Put in module 0025；
Comparison model configuration module 0025, after it receives source data table information and target matrix information, set and compare mould
Type, and the comparison model of setting is sent to and compares task management module 0024, wherein, source data table information is to be connect from tables of data
The data table information, the data table information transmitted from user-defined data table data module 0023 or following compare for entering the transmission of module 0022 are appointed
Management module 0024 of being engaged in caused comparison result data message, target matrix information during the comparison model is performed
For the data table information transmitted from tables of data AM access module 0022 or the tables of data letter transmitted from user-defined data table data module 0023
Breath；With
Task management module 0024 is compared, it carries out task to the comparison model set by comparison model configuration module 0025
Management, comparison result data message is produced during the comparison model is performed, comparison result data information memory is arrived
In comparison result storehouse 0033, or by comparison result data message be sent to comparison result statistical analysis module 0012, compare tie
In any one of fruit correlation inquiry module 0013 and the three of comparison model configuration module 0025 or more persons；
Wherein, showing system 001 includes：
Comparison result statistical analysis module 0012, its comparison result data message to reception are united by different dimensions
Meter, and shown in a manner of form or figure；With
Comparison result correlation inquiry module 0013, its comparison result data message to reception are entered by the search condition of input
After row precise search or fuzzy search, retrieval result is produced, and the retrieval result is shown in the form of a list, is also used
The source information of retrieval result is operated and shows to the retrieval result trace to the source.
Second aspect, the data according to above-mentioned first aspect flexibly compare analysis system, it is characterised in that
Application system 002 also includes correlation model configuration module 0026, and it is used to receive from tables of data AM access module 0022
The data table information and comparison result correlation inquiry module 0013 of transmission caused source information in operation is traced to the source in execution, and look into
Look for the data message shared between the data table information and source information and display；And/or
Showing system 001 also includes comparison result warning module 0011, and it receives comparison task management module 0024 and held
Caused comparison result data message during the row comparison model, carry out early warning according to data category and the early warning frequency and carry
Show.
The third aspect, the data according to above-mentioned first aspect flexibly compare analysis system, it is characterised in that compare mould
Type includes：
Title submodule, to store the title of comparison model；
Source table data source submodule, to the data source information of storage source tables of data；
Source data table submodule, to the table name of storage source data table information；
Source table delta field submodule, to the delta field of storage source data table information；
Object table data source submodule, to store the data source information of target matrix information；
Target matrix submodule, to store the table name of target matrix information；
Object table delta field submodule, to store the delta field of target matrix information；
Correlation Criteria defines submodule, to storage source data table information related information；
Alignments submodule, to set the alignments of source data table information and target matrix information；
Source table filter condition submodule, to set the filter condition to source data table information；
Object table filter condition submodule, to set the filter condition to target matrix information；With
Optional comparison model step submodule, to set alignments submodule, source table filter condition submodule and
The execution sequence of object table filter condition submodule.
Fourth aspect, the data according to above-mentioned first aspect flexibly compare analysis system, it is characterised in that set ratio
Model is comprised the following steps：
Input source data table information,
Target matrix information is inputted,
The comparison data object to be compared respectively between input source data table information and target matrix information, refers to
For the source data table information to be compared and target matrix information, input inquiry condition so that source data table information and target
Data table information carries out comparing in the range of querying condition,
The source data to be compared between input source data table information and target matrix information row or incremental data column information,
Refer to for the source data table information to be compared and target matrix information, input the data to be compared row or incremental data
Row, and
The comparison logical relation inputted between comparison data row, refers to be directed to the source data table information and number of targets to be compared
The comparison column information inputted according to table information, input the comparison relation to be compared.
5th aspect, the data according to above-mentioned first aspect flexibly compare analysis system, it is characterised in that
Data system 003 includes：
Service Database, including the database of bank, household register information database, flight information database and other conventional numbers
According to storehouse；
Self-defining data storehouse, its to store user input business datum, wherein, business datum include bank client letter
Breath, personal household register information, personal Flight Information and other data；
Comparison result storehouse, its to store tasks management module 0024 during perform the comparison model caused by
Comparison result data message；With
Optional core database, it is used to store the system data in the data system；
Wherein, data source configuration module 0021 causes tables of data AM access module 0022 receives to come from as Data connection module
Data table information in multiple Service Databases.
6th aspect, a kind of data flexibly compare analysis method, it is characterised in that the analysis method comprises the following steps：
Step（1）：Data source configuration module 0021 is used for causing tables of data AM access module 0022 as Data connection module
The data table information from Service Database 0031 is received, and causes user-defined data table data module 0023 receives to come from self-defined number
According to the data table information in storehouse 0032；
Step（2）：Tables of data AM access module 0022 receives the data table information in Service Database 0031, and will connect
The data table information of receipts is respectively transmitted to comparison model configuration module 0025 and correlation model configuration module 0026；
Step（3）：User-defined data table data module 0023 by the business datum of input being stored in self-defining data storehouse
In 0032, also receiving the data table information in self-defined database 0032 and the data table information of reception be sent into comparison
In model configuration module 0025；
Step（4）：After comparison model configuration module 0025 receives source data table information and target matrix information, ratio is set
To model, and the comparison model of setting is sent to and compares task management module 0024, wherein, source data table information is from data
Data table information, the data table information from the transmission of user-defined data table data module 0023 or the following ratios that table AM access module 0022 transmits
To task management module 0024 during the comparison model is performed caused comparison result data message, target matrix
Information is the data table information transmitted from tables of data AM access module 0022 or the data transmitted from user-defined data table data module 0023
Table information；With
Step（5）：Task management module 0024 is compared to enter the comparison model set by comparison model configuration module 0025
Row task management, comparison result data message is produced during the comparison model is performed, by comparison result data message
Store in comparison result storehouse 0033, or by comparison result data message be sent to comparison result statistical analysis module 0012,
In any one of comparison result correlation inquiry module 0013 and the three of comparison model configuration module 0025 or more persons；
Step（6）：Comparison result statistical analysis module 0012 presses different dimensions to the comparison result data message of reception
Counted, and shown in a manner of form or figure；With
Step（7）：Comparison result correlation inquiry module 0013 is to the comparison result data message of reception by the retrieval inputted
After condition carries out precise search or fuzzy search, retrieval result is produced, and the retrieval result is shown in the form of a list
Show, also operate and show the source information of retrieval result to the retrieval result trace to the source.
7th aspect, the data according to the above-mentioned 6th aspect flexibly compare analysis method, it is characterised in that this method
Also comprise the following steps：
Correlation model configuration module 0026, its be used for receive from tables of data AM access module 0022 transmit data table information with
And comparison result correlation inquiry module 0013 execution trace to the source operation in caused source information, and search the data table information and
The data message shared between source information and display；And/or
Showing system 001 also includes comparison result warning module 0011, and it receives comparison task management module 0024 and held
Caused comparison result data message during the row comparison model, carry out early warning according to data category and the early warning frequency and carry
Show.
Eighth aspect, the data according to the above-mentioned 6th aspect flexibly compare analysis method, it is characterised in that step
（4）In comparison model include：
Title submodule, to store the title of comparison model；
Source table data source submodule, to the data source information of storage source tables of data；
Source data table submodule, to the table name of storage source data table information；
Source table delta field submodule, to the delta field of storage source data table information；
Object table data source submodule, to store the data source information of target matrix information；
Target matrix submodule, to store the table name of target matrix information；
Object table delta field submodule, to store the delta field of target matrix information；
Correlation Criteria defines submodule, to storage source data table information related information；
Alignments submodule, to set the alignments of source data table information and target matrix information；
Source table filter condition submodule, to set the filter condition to source data table information；
Object table filter condition submodule, to set the filter condition to target matrix information；With
Optional comparison model step submodule, to set alignments submodule, source table filter condition submodule and
The execution sequence of object table filter condition submodule.
9th aspect, the data according to the above-mentioned 6th aspect flexibly compare analysis method, it is characterised in that step
（4）In setting comparison model comprise the following steps：
Input source data table information,
Target matrix information is inputted,
The comparison data object to be compared respectively between input source data table information and target matrix information, refers to
For the source data table information to be compared and target matrix information, input inquiry condition so that source data table information and target
Data table information carries out comparing in the range of querying condition,
The source data to be compared between input source data table information and target matrix information row or incremental data column information,
Refer to for the source data table information to be compared and target matrix information, input the data to be compared row or incremental data
Row, and
The comparison logical relation inputted between comparison data row, refers to be directed to the source data table information and number of targets to be compared
The comparison column information inputted according to table information, input the comparison relation to be compared.
Tenth aspect, the data according to the above-mentioned 6th aspect flexibly compare analysis method, it is characterised in that
The database of this method application includes：
Service Database, including the database of bank, household register information database, flight information database and other conventional numbers
According to storehouse；
Self-defining data storehouse, its to store user input business datum, wherein, business datum include bank client letter
Breath, personal household register information, personal Flight Information and other data；
Comparison result storehouse, its to store tasks management module 0024 during perform the comparison model caused by
Comparison result data message；With
Optional core database, it is used to store the system data in the data system；
Wherein, data source configuration module 0021 causes tables of data AM access module 0022 receives to come from as Data connection module
Data table information in multiple Service Databases.
Analysis system and method are flexibly compared according to data provided by the invention, changes the Land use systems to data, is improved
The information value of available data, business personnel's operating efficiency is improved, enables fast and accurately to find the pass between data
Connection, therefrom excavates valuable information.The present invention specifically has the advantages that：
Firstth, the present invention carries out determining for data source information by data source configuration module to multiple different Service Databases
Justice so that the present invention is not limited to single Database Systems, can access different databases, can be to arbitrary data storehouse
Data message is compared；
Secondth, the present invention can flexibly set comparison model by comparison model configuration module so that in comparison process,
Alignments are various, flexible, improve the practicality of the system, while be circularly set the system section by comparison model
Comparison time is saved, improves comparison efficiency；
3rd, the present invention carries out early warning, analysis and deep layer statistics to comparing result data information, is easy to business personnel to carry out
Data analysis and data excacation.
4th, the present invention can flexibly define the executive mode of comparison task, and energy by comparing task management module
The execution state of enough comparison tasks of monitoring in real time.
5th, the present invention can carry out profound association analysis by correlation model configuration module to data.
6th, the present invention can flexibly define business number by user-defined data table data module according to the needs of business personnel
According to.
Brief description of the drawings
Fig. 1 shows flexibly to compare the structural representation of analysis system according to a kind of data of preferred embodiment of the present invention；
Fig. 2 shows flexibly to compare the core database of analysis system according to a kind of present invention data of preferred embodiment
Tables of data schematic diagram；
The tables of data that Fig. 3 a show flexibly to compare analysis system according to a kind of data of preferred embodiment of the present invention is illustrated
Figure；
Fig. 3 b show flexibly to compare the flow chart of analysis method according to a kind of data of preferred embodiment of the present invention；
The comparison model that Fig. 4 shows flexibly to compare analysis system according to a kind of data of preferred embodiment of the present invention configures
The flow chart of module；
Fig. 5 shows flexibly to compare the comparison task management of analysis system according to a kind of data of preferred embodiment of the present invention
The flow chart of module.
The comparison result that Fig. 6 shows flexibly to compare analysis system according to a kind of data of preferred embodiment of the present invention counts
The flow chart of analysis.
The comparison result that Fig. 7 shows flexibly to compare analysis system according to a kind of data of preferred embodiment of the present invention associates
The flow chart of inquiry.
Drawing reference numeral explanation：
001- shows system
0011- comparison result warning modules
0012- comparison result statistical analysis modules
0013- comparison result correlation inquiry modules
002- application systems
0021- data source configuration modules
0022- tables of data AM access modules
0023- user-defined data table data modules
0024- compares task management module
0025- comparison model configuration modules
0026- correlation model configuration modules
003- data systems
0031- Service Databases
0032- self-defining datas storehouse
0033- comparison results storehouse
Embodiment
Below by the present invention is described in detail, the features and advantages of the invention will become more with these explanations
To be clear, clear and definite.
Special word " exemplary " is meant " being used as example, embodiment or illustrative " herein.Here as " exemplary "
Illustrated any embodiment should not necessarily be construed as preferred or advantageous over other embodiments.Although each of embodiment is shown in the drawings
In terms of kind, but unless otherwise indicated, it is not necessary to accompanying drawing drawn to scale.
According in a preferred embodiment of the present invention, as shown in figs. 1-4, there is provided a kind of data flexibly compare point
Analysis system, it is characterised in that the analysis system includes showing system 001, application system 002 and data system 003；
Wherein, application layer 002 includes：Data source configuration module 0021, tables of data AM access module 0022, user-defined data table data
Module 0023, comparison model configuration module 0025 and comparison task management module 0024；
Wherein, showing system 001 includes：Comparison result statistical analysis module 0012 and comparison result correlation inquiry module
0013。
In one preferred embodiment, as shown in figs. 1-2, the system data system 003 includes four databases,
It is Service Database, self-defining data storehouse, comparison result database and core database respectively；
Wherein, Service Database is the database of enterprise, and the system is directly invoked, and enterprise is stored in Service Database
Business information data, including the employee information of enterprise, product information, sales information, main activities information etc., business datum
The type in storehouse has no specifically limited, can be Oracle, SQLServer or DB2 database；Neck belonging to Service Database simultaneously
Domain also has no specifically limited, and Service Database can be household register information database, flight information database or other routine datas
Storehouse, due to applied business database so that the systematic difference is in extensive range, improves the practicality of the system.
Self-defining data storehouse is that business personnel adds the database used during business datum,
Comparison result database is storing the comparison result data message of the system；
Core database is storing the data that the system carries；
As shown in Figure 2, data storage source table, access tables of data, access literary name section, comparison task are matched somebody with somebody in core database
Put, comparison model allocation list, correlation model allocation list, user-defined data table and eight tables of data of user-defined data table field；This eight data
Table is supported in the system operation for systems with data.
In one preferred embodiment, as shown in figs. 1 and 2, the system passes through comparison model configuration module 0025
Comparison model is configured so that work can be flexibly compared in the system, can be flexible according to the demand of business personnel
Definition alignments, add practicality and the flexibility of the system；The use range of the system is also improved simultaneously so that
The system is applied to more comparing fields.
Wherein, comparison model includes：Title submodule, source table data source submodule, source data table submodule, source table increment
Field submodule, object table data source submodule, target matrix submodule, object table delta field submodule, Correlation Criteria
Define submodule, alignments submodule, source table filter condition submodule, object table filter condition submodule and comparison model step
13 submodules of rapid submodule；
By addition of the comparison model configuration module 0025 to the data message of comparison model allocation list, modification and inquiry with
Reach the purpose configured to comparison model；The comparison model allocation list is stored in core database, comparison model
Each submodule corresponds to a unique field in comparison model allocation list in 13 submodules；
Wherein, " source table data source " and " object table data source " field and " number in Data source table in comparison model allocation list
Being identified according to source " field is corresponding, " the source data table " and " target matrix " field in comparison model allocation list and access data
" table name " field in table is corresponding "；Comparison model configuration module 0025 passes through " the source table data in comparison model allocation list
Source " and " source data table " obtain the data table information in Service Database, the data table information in self-defining data storehouse or comparison
Result data information；Comparison model configuration module 0025 passes through " the object table data source " and " target in comparison model allocation list
Tables of data " obtains the data table information in Service Database or the data table information in self-defining data storehouse；
Between " Correlation Criteria " field storage source data sheet field and target data literary name section in comparison model allocation list
Incidence relation between the multiple associate fields and field of definition, is such as equal to, is not equal to, is more than, is less than, is more than or equal to, is less than
It is equal to, instantiation：Source data table information is household register information table, and target matrix information is Flight Information table, " Correlation Criteria "
Identification card number for household register information table is equal to the passport NO. of Flight Information table or the name of household register information table is believed equal to flight
The date of birth for ceasing the name of table and household register information table is equal to the date of birth of Flight Information table and the property of household register information table
Not Deng Yu Flight Information table sex.
Between " alignments " field storage source data table information and target matrix information in comparison model allocation list
Annexation, such as：Interior connection, complete outer connection, left outside connection, it is right it is outer connect, such as lower graph A, table B respectively have COL1 and COL2
Two arrange, and interior connection is exactly common equivalent connection, if attended operation in the COL1 of Table A and table B COL1 progress, then it is tied
Fruit is as follows：
| COL1 | COL2 | COL1 | COL2 |
| 001 | 10A | 001 | 10B |
Left outside connection is exactly that the non-matched data in main table is added on the basis of connecting inside, if the COL1 of Table A and table B
COL1 carry out left outside attended operation, then its result is as follows：
| COL1 | COL2 | COL1 | COL2 |
| 001 | 10A | 001 | 10B |
| 002 | 20A |
Right outer connection is plus the non-matched data for being connected table on the basis of connecting inside, if the COL1 of Table A and table B
COL1 carry out right outer attended operation, then its result is as follows：
| COL1 | COL2 | COL1 | COL2 |
| 001 | 10A | 001 | 10B |
| 003 | 30B |
Complete outer connection is all to add the non-matched data of left-handed watch and right table on the basis of connecting inside, if Table A
COL1 and table B COL1 carries out complete outer attended operation, then its result is as follows：
| COL1 | COL2 | COL1 | COL2 |
| 001 | 10A | 001 | 10B |
| 002 | 20A | ||
| 003 | 30B |
Wherein, Table A and table B are as follows：
Table A
| COL1 | COL2 |
| 001 | 10A |
| 002 | 20A |
Table B
In one preferred embodiment, as shown in Figure 2, data source configuration module 0021 to data source by configuring
Addition, modification and the management for deleting the complete paired data source information of work of table, the major key of data source allocation list is " data source mark
Know ", unique data source identification can be generated by often establishing a data source;
Specifically, the present invention is by between JDBC mode tables of data AM access module 0022 and Service Database 0031
Establish connection；By establishing connection between JDBC mode user-defined data tables data module 0023 and self-defining data storehouse 0032.
In one preferred embodiment, as shown in Figure 2, tables of data AM access module 0022 passes through to accessing tables of data
Addition, deletion and modification complete to be managed access source data table information；
In one preferred embodiment, as shown in Figure 2, user-defined data table data module 0023 is by user-defined data table
Addition, modification and the deletion work of tables of data are with the self-defined work of complete paired data；Pass through user-defined data table data module 0023
The system application can be made more flexible so that not only existing one group of data can be compared for the system, while
Available data is compared the system allow with customized data.
In one preferred embodiment, as shown in figs. 2 and 4, correlation model configuration module 0026 passes through to association
The work that model allocation list is added, changes and deleted is to complete the configuration to correlation model；The master of correlation model allocation list
Key is " model name ", correlation model allocation list by " tables of data A " fields with " tables of data B " fields find the number for needing to associate
According to table, " relation direction " field includes positive, reverse and two-way；" data correlation relation " field includes tables of data A and tables of data B
Between the relation for being equal to, be not equal to, be more than, be less than, being more than or equal to or being less than or equal to.
Instantiation, model configuration is such as associated to household register information table and Flight Information table, if household register information table with
" the relation direction " that Flight Information table is set is forward direction, " data correlation relation " of setting for household register information table identification card number with
The passport NO. of Flight Information table is equal, then leads to carrying out the when can realization using the correlation model from household register information table
Cross that identification card number is equal with the passport NO. of Flight Information table to be gone to associate its Flight Information, but cannot lead to from Flight Information table
Identification card number is crossed to go to associate household register information table with the passport NO. equivalent way of Flight Information table；If the relation between two tables
Direction is arranged to two-way, it is possible to realizes that household register information table passes through identification card number and the certificate of Flight Information table with Flight Information table
Number equivalent way goes interrelated.
In one preferred embodiment, as shown in Fig. 2 and 5, compare task management module 0024 and pass through to comparing
Task configuration data table is added, changed and deleted to complete the management to comparing task, compares task configuration data table master
Key is " task names "；" executive mode " in comparison task configuration data table perform for timing, perform in real time, performing immediately or
The executory one kind of single；" task status " refers to whether task is in and starts or stops state." execution state " refers to task
Whether it is in comparison process.The module can flexibly define the executive mode of comparison task, can monitor comparison task in real time
Execution state.
In one preferred embodiment, comparison result warning module 0011 receives comparison task management module 0024 and existed
Caused comparison result data message during the comparison model is performed, early warning is carried out according to data category and the early warning frequency
Prompting,
Wherein, data category refers to the classification defined according to the data class of comparison model access, such as：The number of access
It is household register information and Flight Information according to species, then the data category that we define compares Flight Information for household register information;Early warning
The frequency refers to the early warning rule defined according to different data categories, such as the early warning rule for different pieces of information class declaration
Including:Daily early warning once, at interval of a few minutes early warning once, at interval of a few houres early warning once.
Wherein, comparison result warning module carries out early warning to new caused comparison result data message, appoints when comparing
After management module 0024 of being engaged in performs comparison task, in comparison result table（Comparison result table is stored in comparison result storehouse, than
Result table is used to store comparison result data message）It is middle to produce new comparison result data message.Comparison result warning module
Can go in comparison result table to count whether have new comparison result data message by frequency timing, if new information, then can
Early warning is carried out by comparison model classification.Instantiation, source data table information（The household register information table of table 1）With target matrix
Information（The hotel accommodations information table of table 4）Model setting is compared, the scope for defining comparison data is name " Zhang San ", defines ratio
Data are classified as with " identification card number " of household register information table and " passport NO. " of hotel accommodations information table, definition is compared between row
Relation is " being equal to ", and the incremental data list for defining comparison data shows the information of 2013, comparison model point for comparison result
Class is defined as " household register information compare hotel accommodations information ", definition compare early warning rule be at interval of early warning in 1 minute once, then
Comparison task is performed, comparison result table just has new comparison result data message and produced after tasks carrying is compared
(230182197701020001, Zhang San, man, Beijing, on November 7th, 19770102,001,2,2013)；It is every according to early warning rule
The one minute comparison result warning module in interval is counted once to new caused information in comparison result table, and statistical result is new
Information 1 is produced, comparison result warning module just carries out early warning, and " household register information, which compares hotel accommodations information, new result
1 ".
In one preferred embodiment, as shown in Figure 6, comparison result function of statistic analysis module will mainly compare
Result data information according to different dimensions, such as people, thing, thing, group carry out statistical analysis, then by analysis result with table
The mode of lattice or figure is shown.By comparison result data message according to personage's dimension, organization dimensionality, article dimension, place
Dimension, time dimension carry out statistical analysis, are then shown with form or chart two ways, can be with after being shown for form
Carry out by the operations such as row sort, screening scope of statistics, statistical result further drill through are counted, showing for chart can be according to post
The diagrammatic representations such as shape figure, cake chart, line chart.Profound excavation can be carried out to comparing result data information by the module,
Allow business personnel to make the reasoning of inductive, therefrom excavate potential pattern, help business personnel to adjust market strategy, subtract
Few risk, makes correct decision-making.
In one preferred embodiment, as shown in Figure 7, comparison result correlation inquiry functional module will mainly compare
Result data information is according to condition inquired about, while the result data of inquiry is carried out tracing to the source operation and produces source information, in source
Correlation model in information according to configuration carries out the deep layer secondary association of multiple data sources, and potential value is closed between finding data
System.Instantiation is retrieved by customized condition as shown in Figure 7, by comparison result data message, and retrieval result is to arrange
Table mode is shown, can be carried out by the sequence of result row, to retrieval result screening or the behaviour that traces to the source retrieval result for retrieval result
Make；Need to combine comparison model when tracing to the source to retrieval result, be associated the source number searched and obtain comparison result data message
According to table information and target matrix information；The module is carried out more for the result traced to the source in conjunction with associated configuration model information simultaneously
The association of wide scope, obtain its integrated information details；In conjunction with correlation model information on the basis of integrated information different pieces of information
Deep layer secondary association is carried out, obtains more valuable related informations；
Instantiation：Trace to the source and be just to look for the information source of comparison result data message, household register information table has a personage
Zhang San is, Flight Information table has Zhang San's to seize the opportunity record, association is compared by the way that passport NO. is equal to two tables of data, just
It is Zhang San and its Flight Information to obtain comparison result data message, but if wanting to know Zhang San by comparison result data message
Specific household register information, it is possible to pass through the source data table information in the comparison model of setting（The household register information table of table 1）, compare and close
Series searches the household register information of Zhang San for passport NO., and this process searched is exactly the process traced to the source.
According in a preferred embodiment of the present invention, as shown in figs. 1-4, there is provided data flexibly compare analysis side
Method, this method comprise the following steps：
（1）Disposition data source step S1：By data source configuration module 0021 to needing to access the business datum of the system
The data source information in storehouse 0031 is defined, and the data source information in self-defining data storehouse is defined；
（2）According to step（1）Defined in data source information access source data table information S3：Tables of data AM access module 0022
Data table information in Service Database 0031 is accessed by the system according to the data source information that data source configuration module 0021 configures,
By the data access of self-defining data table information in self-defining data storehouse 0032 to system S2；
（3）The configuration S4 of model is compared by source data table information or target matrix information；Pass through the number of access
Model configuration S5 is associated according to table information；
（4）To step（3）In the comparison model that has set be compared：By comparing task management module 0024 to comparing
Model is managed S6, compares task management module 0024 and comparison result data message is produced during comparison model is performed
S8, and comparison result data message is deposited into comparison result storehouse in the form of comparison result table（0033）；
（5）To step（4）In caused comparison result data message carry out early warning operation S10, statistical analysis operation S9 and
Data query operation S11；
Wherein, after the completion of data query work, the operation S7 that traces to the source is carried out to the result of inquiry, then to result profit of tracing to the source
Profound association analysis is carried out in multiple Service Databases with configured correlation model.
Embodiment：
1st, Service Database 0031:Household register information database or flight information database, wherein, in household register information database
Including household register information table；Flight information database includes Flight Information table and external Flight Information table；Other databases（It is internal
Including hotel accommodations information table）；
2nd, self-defining data storehouse：
3rd, data source configuration module 0021 by JDBC modes by Service Database 0031 and tables of data AM access module 0022
It is connected；Self-defining data storehouse is connected with user-defined data table data module 0023 by JDBC modes；
4th, tables of data AM access module 0022 receives household register information table and Flight Information table and two tables is sent into ratio respectively
To model configuration module 0025；
5th, comparison model is set by comparison model configuration module 0025：
A) definition of source data table information：Source data table information is household register information table（Table 1）,
B) definition of target matrix information：Target matrix information is Flight Information table（Table 2）
C) scope of comparison data is defined：Surname " is opened "
D) comparison data row are defined：" identification card number " row in household register information table and " passport NO. " in Flight Information table
Row are compared
E) relation between comparison row is defined：" being equal to " relation
F) the incremental data row of comparison data are defined：Comparison result is shown in the information of 2013.
6th, compare task management module 0024 and perform comparison model：Caused comparison result data message is：
（230182197701020001, Zhang San, man, Beijing, 19770102, Beijing-Shanghai, on November 7th, 2013, November 3 in 2013
Day）；
7th, by the way that to comparing, result data information is secondary to be compared：Comparison result data message is sent to comparison model
Configuration module 0025 is used as source data table information；By " hotel accommodations information table（Table 4）" it is used as target matrix information;
Comparison model is set by comparison model configuration module 0025：
A) definition of source data table information：Source data table information is comparison result data message
（230182197701020001, Zhang San, man, Beijing, 19770102 Beijing-Shanghai, on November 7th, 2013, November 3 in 2013
Day）,
B) definition of target matrix information：Target matrix information is hotel accommodations information table（Table 4）
C) scope of comparison data is defined：Surname " is opened "
D) comparison data row are defined：In " identification card number " row and hotel accommodations information table in comparison result data message
" passport NO. " row are compared
E) relation between comparison row is defined：" being equal to " relation
F) the incremental data row of comparison data are defined：Comparison result is shown in the information of 2013.
8th, compare task management module 0024 and perform comparison model：Caused secondary comparison result data message is：
（230182197701020001, Zhang San, Beijing-Shanghai, on November 7th, 2013, on November 3rd, 2013,001,2
My god, on November 7th, 2013）；
8-1, comparison result correlation inquiry module 0013 are associated inquiry：Wherein, when with a plurality of comparison result data
One therein can be found during information by accurate or fuzzy search, the comparison result data message in the present embodiment only has one
Bar, so need not accurate or fuzzy search；
8-2, as shown in Figure 7, comparison result correlation inquiry module 0013 are traced to the source operation：Secondary comparison result data are believed
Breath（230182197701020001, Zhang San, Beijing-Shanghai, on November 7th, 2013, on November 3rd, 2013,001,2 day, 2013
On November 7, in）" Zhang San " household register information, result of tracing to the source can be traceable in household register information table by the comparison model of setting
For：（230182197701020001, Zhang San, man, Beijing, 19770102）；
Source data after tracing to the source is passed through correlation model configuration module 0026 by 8-3, comparison result correlation inquiry module 0013
Retrieval is associated in Service Database 0031, wherein in the function, is had steps of：
First, the source household register information after tracing to the source is（230182197701020001, Zhang San, man, Beijing, 19770102；）
Secondly the data table information for, needing associative search is Flight Information table；
Again, the configuration of correlation model configuration module 0026, correlation model configuration module 0026 is by database
Whole configuration work is completed in the operation of associated configuration model table：Wherein " tables of data A " is the source household register information after tracing to the source；" data
Table B " is external Flight Information table；" relation direction " is forward direction;" data correlation relation " is " being equal to "；
Finally, associative search result is drawn, wherein, this time retrieval can Flight Information table abroad using positive incidence
（Table 3）In find the external Flight Information of " Zhang San ", show that associative search result is：（230182197701020001, Zhang San,
Beijing-the U.S., on November 7th, 2014, on November 3rd, 2013）
The household register information table of table 1
| Identification card number（Major key） | Name | Sex | Address | Date of birth |
| 230182197701020001 | Zhang San | Man | Beijing | 19770102 |
| 230182197701020002 | Zhang Si | Female | Shanghai | 19770102 |
| 230182197701020003 | Open five | Female | Tianjin | 19770102 |
| 230010199002022930 | Lee three | Man | Guangdong | 19900202 |
The Flight Information table of table 2
The external Flight Information table of table 3
The hotel accommodations information table of table 4
Analysis system and method are flexibly compared according to data provided by the invention, changes the Land use systems to data, is improved
The information value of available data, business personnel's operating efficiency is improved, enables fast and accurately to find the pass between data
Connection, therefrom excavates valuable information.The present invention specifically has the advantages that：
Firstth, the present invention carries out determining for data source information by data source configuration module to multiple different Service Databases
Justice so that the present invention is not limited to single Database Systems, can access different databases, can be to arbitrary data storehouse
Data message is compared；
Secondth, the present invention can flexibly define comparison model by comparison model configuration module so that in comparison process,
Alignments are various, flexible, improve the practicality of the system；
3rd, the present invention carries out early warning, analysis and deep layer statistics to comparing result data information, is easy to business personnel to carry out
Data analysis and data excacation.
4th, the present invention can flexibly define the executive mode of comparison task, and energy by comparing task management module
The execution state of enough comparison tasks of monitoring in real time.
5th, the present invention can carry out profound association analysis by correlation model configuration module to data.
6th, the present invention can flexibly define business number by user-defined data table data module according to the needs of business personnel
According to.
The present invention is described in detail for engagement embodiment and exemplary example above, but these explanations are simultaneously
It is not considered as limiting the invention.It will be appreciated by those skilled in the art that without departing from the spirit and scope of the invention,
A variety of equivalencing, modification or improvement can be carried out to technical solution of the present invention and embodiments thereof, these each fall within the present invention
In the range of.Protection scope of the present invention is determined by the appended claims.
Claims (10)
1. a kind of data flexibly compare analysis system, it is characterised in that the analysis system includes showing system (001), using body
It is (002) and data system (003)；
Wherein, application system (002) includes：
Data source configuration module (0021), it is used for causing tables of data AM access module (0022) receives to come as Data connection module
Data table information from Service Database (0031), and cause user-defined data table data module (0023) receives to come from self-defining data
The data table information in storehouse (0032)；
Tables of data AM access module (0022), it receives the data table information come from Service Database (0031), and by reception
Data table information is respectively transmitted to comparison model configuration module (0025) and correlation model configuration module (0026)；
User-defined data table data module (0023), its business datum of input is stored in self-defining data storehouse (0032),
Also receiving the data table information in self-defined database (0032) and the data table information of reception be sent into comparison model
In configuration module (0025)；
Comparison model configuration module (0025), after it receives source data table information and target matrix information, comparison model is set,
And the comparison model of setting is sent to and compares task management module (0024), wherein, source data table information is to be connect from tables of data
Enter the data table information, the data table information from user-defined data table data module (0023) transmission or following ratios of module (0022) transmission
To task management module (0024) during the comparison model is performed caused comparison result data message, target data
Table information is to be transmitted from the data table information of tables of data AM access module (0022) transmission or from user-defined data table data module (0023)
Data table information；With
Task management module (0024) is compared, it carries out task to the comparison model set by comparison model configuration module (0025)
Management, comparison result data message is produced during the comparison model is performed, comparison result data information memory is arrived
In comparison result storehouse (0033), or by comparison result data message be sent to comparison result statistical analysis module (0012), ratio
To in any one of result correlation inquiry module (0013) and comparison model configuration module (0025) three or more persons；
Wherein, showing system (001) includes：
Comparison result statistical analysis module (0012), its comparison result data message to reception are united by different dimensions
Meter, and shown in a manner of form or figure；With
Comparison result correlation inquiry module (0013), its comparison result data message to reception are carried out by the search condition of input
After precise search or fuzzy search, produce retrieval result, and the retrieval result shown in the form of a list, also to
The retrieval result trace to the source and operates and show the source information of retrieval result.
2. data according to claim 1 flexibly compare analysis system, it is characterised in that
Application system (002) also includes correlation model configuration module (0026), and it is used to receive from tables of data AM access module
(0022) data table information of transmission and comparison result correlation inquiry module (0013) the caused source in operation is traced to the source in execution
Information, and search the data message shared between the data table information and source information and display；And/or
Showing system (001) also includes comparison result warning module (0011), and it receives comparison task management module (0024) and existed
Caused comparison result data message during the comparison model is performed, early warning is carried out according to data category and the early warning frequency
Prompting.
3. data according to claim 1 flexibly compare analysis system, it is characterised in that comparison model includes：
Title submodule, to store the title of comparison model；
Source table data source submodule, to the data source information of storage source tables of data；
Source data table submodule, to the table name of storage source data table information；
Source table delta field submodule, to the delta field of storage source data table information；
Object table data source submodule, to store the data source information of target matrix information；
Target matrix submodule, to store the table name of target matrix information；
Object table delta field submodule, to store the delta field of target matrix information；
Correlation Criteria defines submodule, to storage source data table information related information；
Alignments submodule, to set the alignments of source data table information and target matrix information；
Source table filter condition submodule, to set the filter condition to source data table information；
Object table filter condition submodule, to set the filter condition to target matrix information；With
Optional comparison model step submodule, to set alignments submodule, source table filter condition submodule and target
The execution sequence of table filter condition submodule.
4. data according to claim 1 flexibly compare analysis system, it is characterised in that set comparison model to include following
Step：
Input source data table information,
Target matrix information is inputted,
The comparison data object to be compared respectively between input source data table information and target matrix information, refers to be directed to
The source data table information to be compared and target matrix information, input inquiry condition so that source data table information and target data
Table information carries out comparing in the range of querying condition,
The source data to be compared between input source data table information and target matrix information row or incremental data column information, refer to
For the source data table information to be compared and target matrix information, the data to be compared row or incremental data row are inputted,
With
The comparison logical relation inputted between comparison data row, refer to source data table information and target matrix for be compared
The comparison column information of information input, inputs the comparison relation to be compared.
5. data according to claim 1 flexibly compare analysis system, it is characterised in that
Data system (003) includes：
Service Database, including the database of bank, household register information database, flight information database and other routine datas
Storehouse；
Self-defining data storehouse, its to store user input business datum, wherein, business datum include customer information of bank,
Personal household register information, personal Flight Information and other data；
Comparison result storehouse, it is produced to store comparison task management module (0024) during the comparison model is performed
Comparison result data message；With
Optional core database, it is used to store the system data in the data system；
Wherein, data source configuration module (0021) causes tables of data AM access module (0022) receives to come from as Data connection module
Data table information in multiple Service Databases.
6. a kind of data flexibly compare analysis method, it is characterised in that the analysis method comprises the following steps：
Step (1)：Data source configuration module (0021) is used for causing tables of data AM access module (0022) as Data connection module
The data table information from Service Database (0031) is received, and causes user-defined data table data module (0023) receives to make by oneself
The data table information of adopted database (0032)；
Step (2)：Tables of data AM access module (0022) receives the data table information come from Service Database (0031), and will connect
The data table information of receipts is respectively transmitted to comparison model configuration module (0025) and correlation model configuration module (0026)；
Step (3)：User-defined data table data module (0023) by the business datum of input being stored in self-defining data storehouse
(0032) in, also receiving the data table information in self-defined database (0032) and be sent to the data table information of reception
In comparison model configuration module (0025)；
Step (4)：After comparison model configuration module (0025) receives source data table information and target matrix information, set and compare
Model, and the comparison model of setting is sent to and compares task management module (0024), wherein, source data table information is from data
Table AM access module (0022) transmission data table information, from user-defined data table data module (0023) transmission data table information or under
State and compare task management module (0024) caused comparison result data message, target during the comparison model is performed
Data table information is from the data table information of tables of data AM access module (0022) transmission or from user-defined data table data module (0023)
The data table information of transmission；With
Step (5)：Task management module (0024) is compared to enter the comparison model set by comparison model configuration module (0025)
Row task management, comparison result data message is produced during the comparison model is performed, by comparison result data message
Store in comparison result storehouse (0033), or comparison result data message is sent to comparison result statistical analysis module
(0012), any one of comparison result correlation inquiry module (0013) and comparison model configuration module (0025) three or more persons
In；
Step (6)：Comparison result statistical analysis module (0012) is entered to the comparison result data message of reception by different dimensions
Row statistics, and shown in a manner of form or figure；With
Step (7)：Comparison result correlation inquiry module (0013) is to the comparison result data message of reception by the retrieval bar inputted
After part carries out precise search or fuzzy search, retrieval result is produced, and the retrieval result is shown in the form of a list,
Also the source information of retrieval result is operated and shows to the retrieval result trace to the source.
7. data according to claim 6 flexibly compare analysis method, it is characterised in that this method also includes following step
Suddenly：
Correlation model configuration module (0026), its be used for receive from tables of data AM access module (0022) transmission data table information with
And comparison result correlation inquiry module (0013) caused source information in operation is traced to the source in execution, and search the data table information
The data message shared between source information and display；And/or
Showing system (001) also includes comparison result warning module (0011), and it receives comparison task management module (0024) and existed
Caused comparison result data message during the comparison model is performed, early warning is carried out according to data category and the early warning frequency
Prompting.
8. data according to claim 6 flexibly compare analysis method, it is characterised in that the comparison model in step (4)
Including：
Title submodule, to store the title of comparison model；
Source table data source submodule, to the data source information of storage source tables of data；
Source data table submodule, to the table name of storage source data table information；
Source table delta field submodule, to the delta field of storage source data table information；
Object table data source submodule, to store the data source information of target matrix information；
Target matrix submodule, to store the table name of target matrix information；
Object table delta field submodule, to store the delta field of target matrix information；
Correlation Criteria defines submodule, to storage source data table information related information；
Alignments submodule, to set the alignments of source data table information and target matrix information；
Source table filter condition submodule, to set the filter condition to source data table information；
Object table filter condition submodule, to set the filter condition to target matrix information；With
Optional comparison model step submodule, to set alignments submodule, source table filter condition submodule and target
The execution sequence of table filter condition submodule.
9. data according to claim 6 flexibly compare analysis method, it is characterised in that the setting in step (4) compares
Model comprises the following steps：
Input source data table information,
Target matrix information is inputted,
The comparison data object to be compared respectively between input source data table information and target matrix information, refers to be directed to
The source data table information to be compared and target matrix information, input inquiry condition so that source data table information and target data
Table information carries out comparing in the range of querying condition,
The source data to be compared between input source data table information and target matrix information row or incremental data column information, refer to
For the source data table information to be compared and target matrix information, the data to be compared row or incremental data row are inputted,
With
The comparison logical relation inputted between comparison data row, refer to source data table information and target matrix for be compared
The comparison column information of information input, inputs the comparison relation to be compared.
10. data according to claim 6 flexibly compare analysis method, it is characterised in that
The database of this method application includes：
Service Database, including the database of bank, household register information database, flight information database and other routine datas
Storehouse；
Self-defining data storehouse, its to store user input business datum, wherein, business datum include customer information of bank,
Personal household register information, personal Flight Information and other data；
Comparison result storehouse, it is produced to store comparison task management module (0024) during the comparison model is performed
Comparison result data message；With
Optional core database, it is used to store the system data in the data system；
Wherein, data source configuration module (0021) causes tables of data AM access module (0022) receives to come from as Data connection module
Data table information in multiple Service Databases.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310717829.9A CN104731814B (en) | 2013-12-23 | 2013-12-23 | Data flexibly compare analysis system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310717829.9A CN104731814B (en) | 2013-12-23 | 2013-12-23 | Data flexibly compare analysis system and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104731814A CN104731814A (en) | 2015-06-24 |
| CN104731814B true CN104731814B (en) | 2017-12-08 |
Family
ID=53455711
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310717829.9A Active CN104731814B (en) | 2013-12-23 | 2013-12-23 | Data flexibly compare analysis system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104731814B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110428319A (en) * | 2019-08-05 | 2019-11-08 | 深圳乐信软件技术有限公司 | A kind of comparing platform, method, equipment and storage medium |
Families Citing this family (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105095473B (en) * | 2015-08-11 | 2018-12-18 | 北京思特奇信息技术股份有限公司 | The method and system that a kind of pair of variance data is analyzed |
| CN105389764A (en) * | 2015-11-25 | 2016-03-09 | 安徽瑞信软件有限公司 | Household registration identification management system |
| CN106855862B (en) * | 2015-12-08 | 2020-09-08 | 中国移动通信集团湖南有限公司 | Rapid comparison method and device |
| CN106897285B (en) * | 2015-12-17 | 2020-04-07 | 北京宸瑞国新科技有限公司 | Data element extraction and analysis system and data element extraction and analysis method |
| CN106775854B (en) * | 2016-12-06 | 2020-03-10 | 中国银行股份有限公司 | Method and device for generating configuration file |
| CN108694179A (en) * | 2017-04-06 | 2018-10-23 | 北京宸瑞科技股份有限公司 | Personage's view analysis system based on attribute extraction and method |
| CN107861929A (en) * | 2017-09-30 | 2018-03-30 | 深圳市买买提乐购金融服务有限公司 | Document structure tree method, terminal and computer-readable medium |
| CN108197237B (en) * | 2017-12-29 | 2020-03-24 | 北京恒泰实达科技股份有限公司 | Visual data acquisition and display system |
| CN110109908B (en) * | 2017-12-29 | 2023-06-06 | 成都蜀信信用服务有限公司 | Analysis system and method for mining potential relationship of person based on social basic information |
| CN107918679A (en) * | 2018-01-04 | 2018-04-17 | 国网福建省电力有限公司 | Data warehouse model technological layer difference comparison method |
| CN109727146B (en) * | 2018-06-15 | 2023-07-21 | 中国平安人寿保险股份有限公司 | Method, apparatus, device and readable storage medium for analyzing cause of change in preparation gold |
| CN110019435A (en) * | 2018-09-19 | 2019-07-16 | 中建科技有限公司深圳分公司 | Data processing method and system based on assembled architecture platform |
| CN111190965B (en) * | 2018-11-15 | 2023-11-10 | 北京宸瑞科技股份有限公司 | Impromptu relation analysis system and method based on text data |
| CN109656975A (en) * | 2018-12-13 | 2019-04-19 | 上海航天电源技术有限责任公司 | Fault early warning system and method based on big data |
| CN109669983B (en) * | 2018-12-27 | 2020-11-10 | 杭州火树科技有限公司 | Visual multi-data-source ETL tool |
| CN110287182B (en) * | 2019-05-05 | 2021-09-14 | 浙江吉利控股集团有限公司 | Big data comparison method, device, equipment and terminal |
| CN112231324B (en) | 2019-06-26 | 2023-03-24 | 金篆信科有限责任公司 | System and method for realizing incremental data comparison |
| CN112214554A (en) * | 2019-07-10 | 2021-01-12 | 北京宸瑞科技股份有限公司 | Excel data integration analysis system and method |
| CN110472216B (en) * | 2019-08-19 | 2022-12-06 | 北京明略软件系统有限公司 | Method and device for determining field, storage medium and electronic device |
| CN115617819B (en) * | 2022-12-19 | 2023-03-14 | 思创数码科技股份有限公司 | Data storage method, system, computer device and storage medium |
| CN117271485A (en) * | 2023-09-07 | 2023-12-22 | 索菲亚家居股份有限公司 | Big data quality management method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101009608A (en) * | 2007-01-10 | 2007-08-01 | 中国电信股份有限公司 | Automatic comparison method and system for the consistency test of the network management interface information model |
| US7822710B1 (en) * | 2006-05-24 | 2010-10-26 | Troux Technologies | System and method for data collection |
| CN102945262A (en) * | 2012-10-19 | 2013-02-27 | 大唐移动通信设备有限公司 | Comparing method and device for RNC (Radio Network Controller) configuration data |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7698016B2 (en) * | 2003-02-18 | 2010-04-13 | Tti Acquisition Corporation | Feature-based translation system and method |
-
2013
- 2013-12-23 CN CN201310717829.9A patent/CN104731814B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7822710B1 (en) * | 2006-05-24 | 2010-10-26 | Troux Technologies | System and method for data collection |
| CN101009608A (en) * | 2007-01-10 | 2007-08-01 | 中国电信股份有限公司 | Automatic comparison method and system for the consistency test of the network management interface information model |
| CN102945262A (en) * | 2012-10-19 | 2013-02-27 | 大唐移动通信设备有限公司 | Comparing method and device for RNC (Radio Network Controller) configuration data |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110428319A (en) * | 2019-08-05 | 2019-11-08 | 深圳乐信软件技术有限公司 | A kind of comparing platform, method, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104731814A (en) | 2015-06-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104731814B (en) | Data flexibly compare analysis system and method | |
| Wang et al. | Patent co-citation networks of Fortune 500 companies | |
| CN104123346B (en) | A kind of structured data search method | |
| CN106897285A (en) | Data Elements extract analysis system and Data Elements extract analysis method | |
| CN107958086A (en) | The multi-source heterogeneous database data for solving data semantic Heterogeneity integrates method | |
| CN105117442B (en) | A kind of big data querying method based on probability | |
| CN109299154A (en) | A kind of data-storage system and method for big data | |
| Danping et al. | The data mining of the human resources data warehouse in university based on association rule | |
| CN106649460A (en) | Data loading method for examination and approval form based on search engine | |
| Girsang et al. | Business intelligence for construction company acknowledgement reporting system | |
| CN109190984A (en) | Data processing system and method based on Data cube model | |
| Zhao et al. | Ontology mapping based on rough formal concept analysis | |
| Meroño-Peñuela et al. | Detecting and reporting extensional concept drift in statistical linked data | |
| Ni et al. | The analysis and research of clustering algorithm based on PCA | |
| Zeraatkar | Radiology, nuclear medicine, and medical imaging: A bibliometric study in Iran | |
| Hassan et al. | Integrated architecture of data warehouse with business intelligence technologies | |
| Pham Van et al. | Over Three Decades of Data Envelopment Analysis Applied to the Measurement of Efficiency in Higher Education: A Bibliometric Analysis. | |
| Rekatsinas et al. | Crowdgather: Entity extraction over structured domains | |
| CN105138544B (en) | A kind of searching method for remolding logical deduction chain | |
| Asrani et al. | Review of techniques used in data warehouse implementation: An initiative towards designing a frame work for effective data warehousing | |
| DivyaYadav | Business Intelligence For Local Mining Company Acknowledgement Reporting System | |
| Awick et al. | Exploring Federated Learning for Data Integration: A Structured Literature Review | |
| Stumpf et al. | Data, information and knowledge quality in retail security decision making | |
| Singh et al. | Design Aspects of a Multi-dimensional Hybrid Analytical Processing System | |
| Penkova et al. | Constructing the integral OLAP-model based on Formal Concept Analysis |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 100190 Beijing, Zhongguancun, Haidian District, north two, No. 13, 46, 1, 102 Applicant after: Beijing Chen Rui Polytron Technologies Inc Address before: 100036 Haidian District Fuxing Road, Beijing, No. 65, block A, floor 16 Applicant before: Beijing Chenrui Technology Co., Ltd. |
|
| CB02 | Change of applicant information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |