CN106484785B - A kind of method of efficient Automatic Adaptation Data field mapping - Google Patents
A kind of method of efficient Automatic Adaptation Data field mapping Download PDFInfo
- Publication number
- CN106484785B CN106484785B CN201610830877.2A CN201610830877A CN106484785B CN 106484785 B CN106484785 B CN 106484785B CN 201610830877 A CN201610830877 A CN 201610830877A CN 106484785 B CN106484785 B CN 106484785B
- Authority
- CN
- China
- Prior art keywords
- matching
- field
- strategy
- interface
- load
- 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
- 238000013507 mapping Methods 0.000 title claims abstract description 38
- 238000000034 method Methods 0.000 title claims abstract description 32
- 230000006978 adaptation Effects 0.000 title claims abstract description 17
- 238000006243 chemical reaction Methods 0.000 claims abstract description 4
- 238000012216 screening Methods 0.000 claims description 24
- 238000012545 processing Methods 0.000 claims description 10
- 230000016507 interphase Effects 0.000 claims description 9
- 241000208340 Araliaceae Species 0.000 claims 1
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 claims 1
- 235000003140 Panax quinquefolius Nutrition 0.000 claims 1
- 235000008434 ginseng Nutrition 0.000 claims 1
- 239000002699 waste material Substances 0.000 abstract description 3
- 238000007726 management method Methods 0.000 description 3
- 230000006399 behavior Effects 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000012546 transfer Methods 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013506 data mapping Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 235000013399 edible fruits Nutrition 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of methods of efficient Automatic Adaptation Data field mapping, belong to the process field of user data in ERP, the technical problem to be solved in the present invention is when matching to the field mapped, if field quantity is excessively and all same field matching, it will lead to user's operation inefficiency, waste the plenty of time.Technical solution are as follows: this method is the group interface standard that defines, the group interface standard is defined on automatically save in field is matched, loaded and is matched after screen required for attribute and operation, again by running the group interface standard, the Data Matching met in the arbitrary data conversion of the group interface standard is realized.
Description
Technical field
The present invention relates to the process field of user data in ERP, specifically a kind of efficient Automatic Adaptation Data word
The method of section mapping.
Background technique
ERP is the abbreviation of Enterprise Resources Plan (Enterprise Resource Planning), is referred in message count
On the basis of, integrate information technology and advanced management thought, is enterprise staff and decision-making level with the management thought of systematization
The management platform of decision making approach is provided.Wherein, data mapping refers to according to business demand, when data are led from source table or source database
When entering object table or target database, the operation that is carried out in the case where needing to convert data.
When being matched to the field mapped, if field quantity is excessive and is all same field matching
When, it will lead to user's operation inefficiency, waste the plenty of time.If system may provide the user with a kind of according to field name
Or the method that number carries out Auto-matching carries out field by system when facing a large amount of same map fields match first
Matching, this will be that a kind of extraordinary system performance can also actually reduce match time while improving user experience,
It improves efficiency.
Summary of the invention
Technical assignment of the invention is place against the above deficiency, provides a kind of efficient Automatic Adaptation Data field mapping
Method, to solve when being matched to the field mapped, if field quantity is excessive and is all same field
When matching, the problem of will lead to user's operation inefficiency, waste the plenty of time.
The technical solution adopted by the present invention to solve the technical problems is: a kind of efficient Automatic Adaptation Data field mapping
Method, this method be define a group interface standard, which is defined on automatically save in field is matched, plus
Attribute and operation required for carrying and being screened after matching, then by running the group interface standard, realize and meet the group interface mark
Data Matching in quasi- arbitrary data conversion；
Wherein, interface standard include fields match state interface, fields match state context, interface fields acquisition connect
Mouth, map field matching strategy interface, interface source field load policy interface, non-matching field screening strategy interface, mapping word
The configuration of section matching strategy, the load strategy configuration of interface source field and the configuration of non-matching field matching strategy；
Fields match state interface be used for define need map field carry out Auto-matching when need realize interface standard,
And include the operation of a reading interface state, when user needs Auto-matching field, the shape at interface is read by the operation
State, fields match state interface include the return value of a fields match state context type；
Fields match state context is for recording the relevant information of interface state；
Interface fields obtain interface and are used for when selecting Auto-matching, execute the acquisition to aiming field；
Map field matching strategy interface is used for when selecting Auto-matching, to the corresponding source number of target data fields match
According to field；
Interface source field loads policy interface and is used for after Auto-matching, carries out to the data in source data word segment limit face
Load；
Non- matching field screening strategy interface is used for after Auto-matching, is carried out to not matched target data field
Screening makes only to show not matched target data field on interface；
Map field matching strategy is configured to when carrying out Auto-matching, records fields match strategy in current system
Set matches field according to field, expression formula, constant or according to other mapping modes；
Source field load strategy in interface is configured to after Auto-matching, and the plan of source data field is loaded on interface
Set slightly, including load label, number or title；
Non- matching field matching strategy is configured in Auto-matching, to can not carry out matched field processing strategie
Set is matched according to field, expression formula, constant or according to other mapping modes；
Running the group interface standard includes following content: obtaining data field, obtains interphase match strategy, automatic personalization
Matched data field obtains interface load strategy, personalized load data field and the screening of non-matching field.
Preferably, the fields match state interface includes five attributes, it is matching status mark, matching status respectively
Extension mark, matching strategy mark, load strategy mark and non-matching strategy mark；
Wherein, matching status mark be used for one field of unique identification, in Auto-matching to the matching status of field into
Row judgement；
Matching status extension mark needs when there are special circumstances through the attribute for one field of accessory ID
Carry out auxiliary judgment when loading source field；
Matching strategy mark is used for the mark of specific field matching strategy, and the matching strategy of field has very much, on interface
The setting to matching strategy is provided, when user carries out Auto-matching, if the mark is not sky, according to specified strategy
Match aiming field；
For loading the mark of strategy after specific field load matching, the load strategy of field has more load strategy mark
Kind, label, number, title provide the setting to load strategy, after Auto-matching, if the mark is not on interface
For sky, source data field is loaded according to specified strategy；
Non- matching strategy mark is used for the mark of the non-matching strategy of specific field, the non-matching strategy of field have very much,
The setting to non-matching strategy is provided on interface, when user carries out Auto-matching, if the mark is not sky, according to finger
Fixed strategy handles non-matching field.
Preferably, the fields match state context include five attributes, be respectively matching status attribute-bit,
With conditional extensions attribute-bit, matching strategy, non-matching strategy and data source；
Wherein, matching status attribute-bit is used for one field of unique identification, in Auto-matching to the matching shape of field
State is judged；
Matching status extended attribute mark needs when there are special circumstances through this for one field of accessory ID
Attribute carrys out auxiliary judgment when loading source field；
Matching strategy be used for record can matching field processing strategie data, the data using xml format character string；
Non- matching strategy be used for record can not matching field processing strategie data, the data using xml format character
String；
Data source is used to record the aiming field data in interface view, which uses an entity type or entity class
The set of type.
Preferably, it includes two operations that the interface fields, which obtain interface, it is to obtain target data field and obtain respectively
Take source data field；
Wherein, it obtains target data field to obtain the target data field loaded on interface, returns to one
The set of entity type or entity type；
It obtains source data field to obtain the data field in the table of source, returns to an entity type or entity type
Set.
Preferably, the map field matching strategy interface includes an Auto-matching field operations, Auto-matching word
Section matches target data field and source data field, and it is source data word respectively that Auto-matching field, which includes four parameters,
The set of Duan Shiti or entity type, the set of target data field entities or entity type, matching configuration strategy and not
With configuration strategy, and return to the data acquisition system of a source data field, the data source as load.
Preferably, the interface source field load policy interface includes a source data field load operation, source data
Field load carries out the load of interface data to the source data field after matching, and the load of source data field is real comprising source data field
The collection of body or entity type unifies a parameter.
Preferably, the non-matching field screening strategy interface includes that a screening does not match aiming field behaviour
Make, screening does not match aiming field and carries out matched target data field to failing after Auto-matching and screen, and returns
Return the set of an entity type or entity type；
The map field matching strategy configuration includes two operations, is to obtain the configuration of default matching strategy and obtain respectively
Customized matching strategy configuration；
It obtains default matching strategy to be configured to obtain the Auto-matching strategy configuration of default, the configuration of Auto-matching strategy is
One character string, for describing detailed configuration information when system Auto-matching；
It obtains customized matching strategy and is configured to interphase match strategy configuration information according to input, include a matching
Tactful identification parameter returns to the configuration of a matching strategy；If do not found, a null character string is returned.
Preferably, the interface source field load strategy configuration includes two operations, it is to obtain default load plan respectively
Slightly configure and obtain customized load strategy configuration；
Default load strategy is obtained to be configured to obtain the data field load strategy configuration of default, default load strategy
Configuration is a character string, for describing detailed configuration information when system loads；
It obtains customized load strategy to be configured to load tactful configuration information according to the interface of input, includes a load
Tactful identification parameter returns to the configuration of a load strategy；If do not found, a null character string is returned.
Preferably, the non-matching field matching strategy configuration includes two operations, it is to obtain default not match respectively
Fields match strategy configures and obtains customized non-matching field matching strategy configuration；
It obtains and defaults the non-matching field matching strategy configuration that non-matching field matching strategy is configured to acquisition default, write from memory
The non-matching field matching strategy configuration recognized is a character string, defaults non-matching field matching configuration information for describing；
Customized non-matching field matching strategy is obtained to be configured to obtain the non-matching field matching configuration in interface of input
Information includes a non-matching strategy identification parameter, returns to the configuration of a matching strategy；If do not found, one is returned
A null character string.
Preferably, the acquisition data field is to be connect when obtaining source and target data field by interface fields acquisition
Mouth obtains source data field and target data field；
The automatic personalization matched data field is when obtaining interphase match strategy, to be connect first according to fields match state
Mouthful interface state is read, the return value of a fields match state context type is obtained, so that system be made to obtain matching shape
State mark, matching status extension mark, matching strategy mark, load strategy mark, non-matching strategy mark；If matching status
It is identified as sky, then it represents that the field does not need to match, if matching status mark is not sky, then it represents that need to carry out the field
Matching；If matching strategy is identified as sky, the matching strategy of default is selected, is obtained according to the configuration of map field matching strategy silent
The configuration information for the fields match recognized；If matching strategy mark is not sky, customized matching strategy is selected, according to mapping
The configuration of fields match strategy obtains customized fields match configuration information；If non-matching strategy is identified as sky, selection is silent
The non-matching field matching strategy recognized, the non-matching field for configuring acquisition default according to non-matching field matching strategy is matched to match
Confidence breath selects customized non-matching field matching strategy, according to non-matching field if non-matching strategy mark is not sky
Matching strategy configuration obtains the customized non-matched configuration information of matching field；Finally according to matching status, matching configuration plan
Configuration strategy information is not matched slightly and, target map field is matched, and modify the matching status of field, return to a source
The data acquisition system of data field；
The personalized load data field is to be selected according to load strategy mark if load strategy is identified as sky
The load of default configures, and loads the load configuration information that strategy configuration obtains default according to interface source field, if load strategy
Mark is not sky, then customized load is selected to configure, and loads strategy configuration according to interface source field and obtains customized load
Configuration information；Finally according to load configuration information, to being loaded at source data field on interface；
The non-matching field screening is to obtain the matching status of interface fields according to fields match state interface, for
It fails and carries out matched field and screened, user is facilitated to be matched manually.
Compared to the prior art the method for efficient Automatic Adaptation Data field mapping of the invention, has below beneficial to effect
Fruit:
1, content of the present invention is mainly the processing to user data in ERP, especially when user needs data
It is converted or is exported after being calculated, it is therefore an objective to improved user by hand to the efficiency of fields match, and then improve working efficiency；
2, the present invention is by one group interface standard of user interface definition, this group interface standard define data map field into
Row matching, source data field carry out attribute and operation required for load and matching status, thus can based on this group interface standard
To realize the matches in the arbitrary system for meeting interface standard.
Therefore the present invention has the characteristics that design reasonable, easy to use, multi-purpose content, thus, have and promotes the use of well
Value.
Specific embodiment
The present invention is further explained in the light of specific embodiments.
Embodiment 1
The method of efficient Automatic Adaptation Data field mapping of the invention, this method are the group interface standards that defines, should
Group interface standard is defined on automatically save in field is matched, loaded and is matched after screen required for attribute and behaviour
Make, then by running the group interface standard, realizes the Data Matching met in the arbitrary data conversion of the group interface standard；
Wherein, interface standard include fields match state interface, fields match state context, interface fields acquisition connect
Mouth, map field matching strategy interface, interface source field load policy interface, non-matching field screening strategy interface, mapping word
The configuration of section matching strategy, the load strategy configuration of interface source field and the configuration of non-matching field matching strategy；
Fields match state interface be used for define need map field carry out Auto-matching when need realize interface standard,
And include the operation of a reading interface state, when user needs Auto-matching field, the shape at interface is read by the operation
State, fields match state interface include the return value of a fields match state context type；Fields match state interface packet
Containing five attributes, be respectively matching status mark, matching status extension mark, matching strategy mark, load strategy mark and
Non- matching strategy mark；
Wherein, matching status mark be used for one field of unique identification, in Auto-matching to the matching status of field into
Row judgement；
Matching status extension mark needs when there are special circumstances through the attribute for one field of accessory ID
Carry out auxiliary judgment when loading source field；
Matching strategy mark is used for the mark of specific field matching strategy, and the matching strategy of field has very much, on interface
Setting to matching strategy can be provided, it, can be according to specified if the mark is not sky when user carries out Auto-matching
Strategy matching aiming field；
For loading the mark of strategy after specific field load matching, the load strategy of field has more load strategy mark
Kind, it can be label, number, title, the setting to load strategy be provided on interface, after Auto-matching, if should
Mark is not sky, can be according to specified strategy load source data field；
Non- matching strategy mark is used for the mark of the non-matching strategy of specific field, the non-matching strategy of field have very much,
Setting to non-matching strategy can be provided on interface, it, can if the mark is not sky when user carries out Auto-matching
To handle according to specified strategy non-matching field.
Fields match state context is for recording the relevant information of interface state；Fields match state context includes five
A attribute is matching status attribute-bit, matching status extended attribute mark, matching strategy, non-matching strategy and number respectively
According to source；
Wherein, matching status attribute-bit is used for one field of unique identification, in Auto-matching to the matching shape of field
State is judged；
Matching status extended attribute mark needs when there are special circumstances through this for one field of accessory ID
Attribute carrys out auxiliary judgment when loading source field；
Matching strategy be used for record can matching field processing strategie data, the data using xml format character string；
Non- matching strategy be used for record can not matching field processing strategie data, the data using xml format character
String；
Data source is used to record the aiming field data in interface view, which uses an entity type or entity class
The set of type.
Interface fields obtain interface and are used for when selecting Auto-matching, execute the acquisition to aiming field；Interface fields obtain
Taking interface includes two operations, is to obtain target data field and acquisition source data field respectively；
Wherein, it obtains target data field to obtain the target data field loaded on interface, returns to one
The set of entity type or entity type；
It obtains source data field to obtain the data field in the table of source, returns to an entity type or entity type
Set.
Map field matching strategy interface is used for when selecting Auto-matching, to the corresponding source number of target data fields match
According to field；Map field matching strategy interface includes an Auto-matching field operations, and Auto-matching field is to target data word
Section and source data field are matched, and it is source data field entities or entity class respectively that Auto-matching field, which includes four parameters,
The set of type the set of target data field entities or entity type, matches configuration strategy and does not match configuration strategy, and returns
Return the data acquisition system of a source data field, the data source as load.
Interface source field loads policy interface and is used for after Auto-matching, carries out to the data in source data word segment limit face
Load；It includes a source data field load operation that interface source field, which loads policy interface, after the load of source data field is to matching
Source data field carry out the load of interface data, collection of the source data field load comprising source data field entities or entity type
Unify a parameter.
Non- matching field screening strategy interface is used for after Auto-matching, is carried out to not matched target data field
Screening makes only to show not matched target data field on interface；Non- matching field screening strategy interface includes one and screens not
Aiming field operation is matched, screening does not match aiming field and carries out matched target data field to failing after Auto-matching
It is screened, and returns to the set of an entity type or entity type；
Map field matching strategy is configured to when carrying out Auto-matching, records fields match strategy in current system
Set is matched according to field, expression formula, constant or according to other mapping modes；Map field matching strategy configuration packet
It is operated containing two, is to obtain the configuration of default matching strategy and obtain customized matching strategy to configure respectively；
It obtains default matching strategy to be configured to obtain the Auto-matching strategy configuration of default, the configuration of Auto-matching strategy is
One character string, for describing detailed configuration information when system Auto-matching；
It obtains customized matching strategy and is configured to interphase match strategy configuration information according to input, include a matching
Tactful identification parameter returns to the configuration of a matching strategy；If do not found, a null character string is returned.
Source field load strategy in interface is configured to after Auto-matching, and the plan of source data field is loaded on interface
Set slightly, including load label, number or title；Source field load strategy configuration in interface includes two operations, obtains respectively
It takes default load strategy configuration and obtains customized load strategy configuration；
Default load strategy is obtained to be configured to obtain the data field load strategy configuration of default, default load strategy
Configuration is a character string, for describing detailed configuration information when system loads；
It obtains customized load strategy to be configured to load tactful configuration information according to the interface of input, includes a load
Tactful identification parameter returns to the configuration of a load strategy；If do not found, a null character string is returned.
Non- matching field matching strategy is configured in Auto-matching, to can not carry out matched field processing strategie
Set is matched according to field, expression formula, constant or according to other mapping modes；Non- matching field matching strategy configuration
It is operated comprising two, is to obtain to default non-matching field matching strategy configuration and obtain customized non-matching field to match plan respectively
Slightly configure；
It obtains and defaults the non-matching field matching strategy configuration that non-matching field matching strategy is configured to acquisition default, write from memory
The non-matching field matching strategy configuration recognized is a character string, defaults non-matching field matching configuration information for describing；
Customized non-matching field matching strategy is obtained to be configured to obtain the non-matching field matching configuration in interface of input
Information includes a non-matching strategy identification parameter, returns to the configuration of a matching strategy；If do not found, one is returned
A null character string.
Running the group interface standard includes following content: obtaining data field, obtains interphase match strategy, automatic personalization
Matched data field obtains interface load strategy, personalized load data field and the screening of non-matching field；
Wherein, obtaining data field is to obtain interface when obtaining source and target data field by interface fields and obtain source
Data field and target data field；
Automatic personalization matched data field be obtain interphase match strategy when, first according to fields match state interface come
Interface state is read, the return value of a fields match state context type is obtained, so that system be made to obtain matching status mark
Know, matching status extended attribute mark, matching strategy mark, load strategy mark, non-matching strategy mark；If matching status
It is identified as sky, then it represents that the field does not need to match, if matching status mark is not sky, then it represents that need to carry out the field
Matching；If matching strategy is identified as sky, the matching strategy of default is selected, is obtained according to the configuration of map field matching strategy silent
The configuration information for the fields match recognized；If matching strategy mark is not sky, customized matching strategy is selected, according to mapping
The configuration of fields match strategy obtains customized fields match configuration information；If non-matching strategy is identified as sky, selection is silent
The non-matching field matching strategy recognized, the non-matching field for configuring acquisition default according to non-matching field matching strategy is matched to match
Confidence breath selects customized non-matching field matching strategy, according to non-matching field if non-matching strategy mark is not sky
Matching strategy configuration obtains the customized non-matched configuration information of matching field；Finally according to matching status, matching configuration plan
The information such as configuration strategy are not matched slightly and, target map field is matched, and modify the matching status of field, returns to one
The data acquisition system of source data field；
Personalization load data field is to select to default if load strategy is identified as sky according to load strategy mark
Load configuration, according to interface source field load strategy configuration obtain default load configuration information, if load strategy mark
It is not sky, then customized load is selected to configure, customized load is obtained according to the load strategy configuration of interface source field and is configured
Information；Finally according to load configuration information, to being loaded at source data field on interface；
Non- matching field screening is the matching status of interface fields to be obtained, for failing according to fields match state interface
Success carries out matched field and is screened, and user is facilitated to be matched manually.
Embodiment 2
Implement scene is divided into two stages, is respectively as follows: development phase, operation phase.With a simple data field
For mapping.
In the development phase, three kind strategies of the system intialization for user's Auto-matching:
TargetFieldMatchStrategy (aiming field matching strategy), TargetFieldUnMatchStrategy (target word
The non-matching strategy of section), FieldLoadStrategy (field load strategy).Three kinds of strategies provide one kind quickly certainly for user
Move matched configuration information.
By taking following fields match as an example, it is broadly divided into target column field, editing type, mapping expression formula:
| Selection | Sequentially | Target column number | Target column name | Data type | Editing type | Map expression formula |
| 1 | ID | ID | Sting | Field mapping | ||
| 2 | Creator | Founder | Sting | Field mapping | ||
| 3 | CreatedDate | Creation time | Date Time | Field mapping | ||
| 4 | LastModifier | Finally modify people | Sting | Field mapping | ||
| 5 | LastModifiedDate | Last modification time | Date Time | Field mapping | ||
| 6 | Name | Name | Sting | Field mapping |
Firstly, the mapping interface needs to realize fields match state interface, corresponding attribute is provided that
The mapping interface needs to realize fields match state interface.
In the operation phase, system first reads matching status and is identified as MatchStateView, i.e. selection radio box, chooses
Then illustrate matched, does not need to be matched again.Judge whether field is matched, matched if necessary, then
Reading matching strategy is identified as MatchStateStrategy and non-matching strategy is identified as UnMatchStateStrategy, adjusts
With matching strategy configuration and non-matching strategy configuration, obtain corresponding matching strategy information and can not successful match when strategy believe
Breath, using current interface as fields match state interface type transfer to the Auto-matching field method of matching process, automatic
Timing calls interface fields to obtain the acquisition target data field method in interface and obtains source data word phase method, forms phase
The Auto-matching field method of the entity answered or entity sets type transfer to matching process.In Auto-matching field method,
System matches target data field according to default configuration or customized configuration, forms data source as source data
The parameter of field load.
After Auto-matching, interface source field is called to load policy interface, source is executed according to the data source after matching
Data field load operation calls load strategy configuration, updates interface data according to demand.For the matching that fails in system
Field, interface provides non-matching field screening strategy function, realizes that non-matching field screens interface, does not match mesh by screening
Field operations are marked, by judging that matching status identifies, the screening to non-matching field is realized, user is facilitated to be configured by hand.
The technical personnel in the technical field can readily realize the present invention with the above specific embodiments,.But it answers
Work as understanding, the present invention is not limited to two kinds of above-mentioned specific embodiments.On the basis of the disclosed embodiments, the technology
The technical staff in field can arbitrarily combine different technical features, to realize different technical solutions.
Except for the technical features described in the specification, it all is technically known to those skilled in the art.
Claims (9)
1. a kind of method of efficient Automatic Adaptation Data field mapping, it is characterised in that this method is to define a group interface mark
Standard, which is defined on automatically save in field is matched, loaded and is matched after screen required for attribute
And operation, then by running the group interface standard, realize the Data Matching met in the arbitrary data conversion of the group interface standard；
Wherein, interface standard includes fields match state interface, fields match state context, interface fields acquisition interface, reflects
Penetrate fields match policy interface, interface source field load policy interface, non-matching field screening strategy interface, map field matching
Strategy configuration, the load strategy configuration of interface source field and the configuration of non-matching field matching strategy；
Fields match state interface is used to define the interface standard for needing to realize when map field being needed to carry out Auto-matching and wraps
The operation that interface state is read containing one reads the state at interface, word by the operation when user needs Auto-matching field
Section matching status interface includes the return value of a fields match state context type；
Fields match state context is for recording the relevant information of interface state；
Interface fields obtain interface and are used for when selecting Auto-matching, execute the acquisition to aiming field；
Map field matching strategy interface is used for when selecting Auto-matching, to the corresponding source data word of target data fields match
Section；
Interface source field loads policy interface and is used for after Auto-matching, adds to the data in source data word segment limit face
It carries；
Non- matching field screening strategy interface is used for after Auto-matching, is sieved to not matched target data field
Choosing makes only to show not matched target data field on interface；
Map field matching strategy is configured to when carrying out Auto-matching, records the collection of fields match strategy in current system
It closes, field is matched according to field, expression formula, constant or according to other mapping modes；
Source field load strategy in interface is configured to after Auto-matching, and the strategy of source data field is loaded on interface
Set, including load label, number or title；
Non- matching field matching strategy is configured in Auto-matching, to the collection that can not carry out matched field processing strategie
It closes, is matched according to field, expression formula, constant or according to other mapping modes；
Running the group interface standard includes following content: obtaining data field, obtains interphase match strategy, automatic personalization matching
Data field obtains interface load strategy, personalized load data field and the screening of non-matching field；
Obtain data field be obtain source and target data field when, by interface fields obtain interface obtain source data field and
Target data field；
Automatic personalization matched data field is when obtaining interphase match strategy, to be read first according to fields match state interface
Interface state obtains the return value of a fields match state context type, thus make system obtain matching status mark,
With conditional extensions mark, matching strategy mark, load strategy mark, non-matching strategy mark；If matching status is identified as sky,
Then indicate that the field does not need to match, if matching status mark is not sky, then it represents that needs match the field；If
Matching strategy is identified as sky, then selects the matching strategy of default, and the field for obtaining default is configured according to map field matching strategy
Matched configuration information；If matching strategy mark is not sky, customized matching strategy is selected, is matched according to map field
Strategy configuration obtains customized fields match configuration information；If non-matching strategy is identified as sky, select default not
With fields match strategy, the matched configuration information of non-matching field for obtaining default is configured according to non-matching field matching strategy,
If non-matching strategy mark is not sky, customized non-matching field matching strategy is selected, plan is matched according to non-matching field
Slightly configuration obtains the customized non-matched configuration information of matching field；Finally according to matching status, matching configuration strategy and not
Configuration strategy information is matched, target map field is matched, and modify the matching status of field, returns to a source data word
The data acquisition system of section；
Personalization load data field is, if load strategy is identified as sky, to select adding for default according to strategy mark is loaded
Configuration is carried, the load configuration information that strategy configuration obtains default is loaded according to interface source field, if load strategy mark is not
Sky then selects customized load to configure, and loads strategy configuration according to interface source field and obtains customized load configuration information；
Finally according to load configuration information, to being loaded at source data field on interface；
Non- matching field screening is the matching status of interface fields to be obtained, for failing according to fields match state interface
It carries out matched field to be screened, user is facilitated to be matched manually.
2. the method for efficient Automatic Adaptation Data field mapping according to claim 1, it is characterised in that the field
Matching status interface includes five attributes, is matching status mark respectively, matching status extension mark, matching strategy mark, adds
Carry strategy mark and non-matching strategy mark；
Wherein, matching status mark is used for one field of unique identification, sentences in Auto-matching to the matching status of field
It is disconnected；
Matching status extension mark needs adding by the attribute for one field of accessory ID when there are special circumstances
Carry out auxiliary judgment when carrying source field；
Matching strategy mark is used for the mark of specific field matching strategy, and the matching strategy of field has very much, provides on interface
Setting to matching strategy, when user carries out Auto-matching, if the mark is not sky, according to specified strategy matching
Aiming field；
Load strategy mark is for loading the mark of strategy after specific field load matching, there are many load strategies of field, mark
It signs, number, title, the setting to load strategy is provided on interface, after Auto-matching, if the mark is not sky,
According to specified strategy load source data field；
Non- matching strategy mark is used for the mark of the non-matching strategy of specific field, and the non-matching strategy of field has very much, at interface
Setting of the upper offer to non-matching strategy, when user carries out Auto-matching, if the mark is not sky, according to specified
Strategy handles non-matching field.
3. the method for efficient Automatic Adaptation Data field mapping according to claim 1, it is characterised in that the field
Matching status context includes five attributes, is matching status attribute-bit, matching status extended attribute mark, matching plan respectively
Slightly, non-matching strategy and data source；
Wherein, matching status attribute-bit be used for one field of unique identification, in Auto-matching to the matching status of field into
Row judgement；
Matching status extended attribute mark needs when there are special circumstances through the attribute for one field of accessory ID
Carry out auxiliary judgment when loading source field；
Matching strategy be used for record can matching field processing strategie data, the data using xml format character string；
Non- matching strategy be used for record can not matching field processing strategie data, the data using xml format character string；
Data source is used to record aiming field data in interface view, and the data are using an entity type or entity type
Set.
4. the method for efficient Automatic Adaptation Data field mapping according to claim 1, it is characterised in that the interface
It includes two operations that field, which obtains interface, is to obtain target data field and obtain source data field respectively；
Wherein, it obtains target data field to obtain the target data field loaded on interface, returns to an entity
The set of type or entity type；
It obtains source data field to obtain the data field in the table of source, returns to the collection of an entity type or entity type
It closes.
5. the method for efficient Automatic Adaptation Data field mapping according to claim 1, it is characterised in that the mapping
Fields match policy interface includes an Auto-matching field operations, and Auto-matching field is to target data field and source data word
Duan Jinhang matching, Auto-matching field include four parameters, are set, the target of source data field entities or entity type respectively
The set of data field entity or entity type matches configuration strategy and does not match configuration strategy, and returns to a source data
The data acquisition system of field, the data source as load.
6. the method for efficient Automatic Adaptation Data field mapping according to claim 1, it is characterised in that the interface
It includes a source data field load operation that source field, which loads policy interface, and source data field is loaded to the source data word after matching
The load of Duan Jinhang interface data, collection unification ginseng of the source data field load comprising source data field entities or entity type
Number.
7. the method for efficient Automatic Adaptation Data field mapping according to claim 1, it is characterised in that it is described not
It include that a screening does not match aiming field operation with field filter policy interface, screening does not match aiming field to Auto-matching
After fail the set for carrying out matched target data field and being screened, and return to an entity type or entity type；
The map field matching strategy configuration includes two operations, is that acquisition default matching strategy configuration and acquisition are made by oneself respectively
Adopted matching strategy configuration；
It obtains default matching strategy to be configured to obtain the Auto-matching strategy configuration of default, the configuration of Auto-matching strategy is one
Character string, for describing detailed configuration information when system Auto-matching；
It obtains customized matching strategy and is configured to interphase match strategy configuration information according to input, include a matching strategy
Identification parameter returns to the configuration of a matching strategy；If do not found, a null character string is returned.
8. the method for efficient Automatic Adaptation Data field mapping according to claim 1, it is characterised in that the interface
Source field load strategy configuration is operated comprising two, is to obtain default load strategy to configure and obtain customized load strategy respectively
Configuration；
Default load strategy is obtained to be configured to obtain the data field load strategy configuration of default, the configuration of default load strategy
It is a character string, for describing detailed configuration information when system loads；
It obtains customized load strategy to be configured to load tactful configuration information according to the interface of input, includes a load strategy
Identification parameter returns to the configuration of a load strategy；If do not found, a null character string is returned.
9. the method for efficient Automatic Adaptation Data field mapping according to claim 1, it is characterised in that it is described not
Include two operations with the configuration of fields match strategy, is that non-matching field matching strategy configuration is defaulted in acquisition and acquisition is made by oneself respectively
The non-matching field matching strategy configuration of justice；
It obtains and defaults the non-matching field matching strategy configuration that non-matching field matching strategy is configured to acquisition default, default
Non- matching field matching strategy configuration is a character string, defaults non-matching field matching configuration information for describing；
Customized non-matching field matching strategy is obtained to be configured to obtain the non-matching field matching configuration information in interface of input,
Comprising a non-matching strategy identification parameter, the configuration of a matching strategy is returned；If do not found, return one it is empty
Character string.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610830877.2A CN106484785B (en) | 2016-09-19 | 2016-09-19 | A kind of method of efficient Automatic Adaptation Data field mapping |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610830877.2A CN106484785B (en) | 2016-09-19 | 2016-09-19 | A kind of method of efficient Automatic Adaptation Data field mapping |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106484785A CN106484785A (en) | 2017-03-08 |
| CN106484785B true CN106484785B (en) | 2019-07-26 |
Family
ID=58267363
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610830877.2A Active CN106484785B (en) | 2016-09-19 | 2016-09-19 | A kind of method of efficient Automatic Adaptation Data field mapping |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106484785B (en) |
Families Citing this family (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107220274B (en) * | 2017-04-13 | 2020-10-09 | 中科曙光南京研究院有限公司 | Visual data interface market realization method |
| CN107403371B (en) * | 2017-04-13 | 2020-06-09 | 阿里巴巴集团控股有限公司 | Data generation method and device |
| CN108133007A (en) * | 2017-12-22 | 2018-06-08 | 北京明朝万达科技股份有限公司 | A kind of method of data synchronization and system |
| CN109543169B (en) * | 2018-11-26 | 2023-06-13 | 成都四方伟业软件股份有限公司 | Report processing method and device |
| CN109710613A (en) * | 2018-12-26 | 2019-05-03 | 深圳乐信软件技术有限公司 | Management method, device, server and the storage medium of field |
| CN112650799A (en) * | 2019-10-12 | 2021-04-13 | 中国石油化工股份有限公司 | Method and apparatus for analyzing seismic interpretation data text |
| CN110955781A (en) * | 2019-11-14 | 2020-04-03 | 北京明略软件***有限公司 | Model training method and device, and method and device for realizing benchmarking |
| CN112882705B (en) * | 2021-03-01 | 2024-03-19 | 浪潮通用软件有限公司 | Expression computing method, device, equipment and medium based on interface update |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103279542A (en) * | 2013-06-05 | 2013-09-04 | 中国电子科技集团公司第十五研究所 | Data importing processing method and data processing device |
| CN104376062A (en) * | 2014-11-11 | 2015-02-25 | 中国有色金属长沙勘察设计研究院有限公司 | Heterogeneous database platform data synchronization method |
| CN104750787A (en) * | 2015-03-12 | 2015-07-01 | 国家电网公司 | Data integrating and processing system and method |
| CN105843605A (en) * | 2016-03-17 | 2016-08-10 | 中国银行股份有限公司 | Data mapping data and device |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10108352B2 (en) * | 2015-03-03 | 2018-10-23 | International Business Machines Corporation | Incremental replication of a source data set |
-
2016
- 2016-09-19 CN CN201610830877.2A patent/CN106484785B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103279542A (en) * | 2013-06-05 | 2013-09-04 | 中国电子科技集团公司第十五研究所 | Data importing processing method and data processing device |
| CN104376062A (en) * | 2014-11-11 | 2015-02-25 | 中国有色金属长沙勘察设计研究院有限公司 | Heterogeneous database platform data synchronization method |
| CN104750787A (en) * | 2015-03-12 | 2015-07-01 | 国家电网公司 | Data integrating and processing system and method |
| CN105843605A (en) * | 2016-03-17 | 2016-08-10 | 中国银行股份有限公司 | Data mapping data and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106484785A (en) | 2017-03-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106484785B (en) | A kind of method of efficient Automatic Adaptation Data field mapping | |
| CN111199381B (en) | Intelligent work order approval method based on process engine | |
| CN110147722A (en) | A kind of method for processing video frequency, video process apparatus and terminal device | |
| CN101847228B (en) | Workflow static planning method based on process mode | |
| US20120317142A1 (en) | Systmen and method for data management in large data networks | |
| CN101430710A (en) | Data visualization engine system | |
| CN110399420A (en) | A kind of deriving method, electronic equipment and the medium of configurableization Excel format | |
| CN107038533A (en) | A kind of method and system for realizing configurableization workflow examination and approval | |
| CN103020158A (en) | Report form creation method, device and system | |
| CN108681667A (en) | A kind of unit type recognition methods, device and processing equipment | |
| CN109460354B (en) | Method for test case reduction based on RDF reasoning | |
| CN106649503A (en) | Query method and system based on sql | |
| CN109740139A (en) | The customized pattern control method of Document Title, device, computer equipment and storage medium | |
| CN108509501A (en) | A kind of inquiry processing method, server and computer readable storage medium | |
| CN106503223A (en) | A kind of binding site and the online source of houses searching method and device of key word information | |
| CN112115276B (en) | Intelligent customer service method, device, equipment and storage medium based on knowledge graph | |
| CN110515896A (en) | Model resource management method, model file production method, device and system | |
| CN105701251A (en) | Data export and import method based on object definition | |
| CN107391506A (en) | Method and apparatus for inquiring about data | |
| CN103778239A (en) | Multi-database data management method and system | |
| CN113094355A (en) | Model instantiation method, device, equipment and medium based on domestic communication protocol | |
| CN109922131A (en) | Date storage method, device, equipment and storage medium based on block chain | |
| CN109242528A (en) | A kind of the funnel analysis method and device in the customized path of electric business platform | |
| CN106933919A (en) | The connection method of tables of data and device | |
| CN110443382A (en) | A kind of user interaction approach based on intelligent customer service platform |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20190702 Address after: No. 1036, Shandong high tech Zone wave road, Ji'nan, Shandong Applicant after: Langchao General Software Co., Ltd Address before: 250100 First Floor of R&D Building 2877 Kehang Road, Sun Village Town, Jinan High-tech Zone, Shandong Province Applicant before: Ji'nan wave high and New Technology Investment Development Co., Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |