CN106202091A - A kind of field method to set up and device - Google Patents
A kind of field method to set up and device Download PDFInfo
- Publication number
- CN106202091A CN106202091A CN201510222343.7A CN201510222343A CN106202091A CN 106202091 A CN106202091 A CN 106202091A CN 201510222343 A CN201510222343 A CN 201510222343A CN 106202091 A CN106202091 A CN 106202091A
- Authority
- CN
- China
- Prior art keywords
- field
- matching
- history
- created
- transfer
- 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.)
- Pending
Links
Abstract
The embodiment of the present application provides a kind of field method to set up and device.This field method to set up includes: receive the first field pre-created；Described first field is carried out fuzzy matching with the field in history lists；According to matching result, it is determined whether create described first field.The embodiment of the present application is by when creating field, first this field is mated with the field in history lists, then determine whether to create this field according to matching result, make during data warehouse builds table, the reasonability of field can be judged timely and effectively, decrease the generation of redundant field, thus save storage resource.
Description
Technical field
The application relates to database technical field, particularly relates to a kind of field method to set up and a kind of field
Device is set.
Background technology
During traditional Construction of Data Warehouse, it usually needs create field.Wherein, field is one
Member, the variable that its expression associates with object or class, in data base, " the arranging " of general table is referred to as " word
Section ", each field comprises the information of a certain special topic.
At present, when Construction of Data Warehouse, some base rules about field name can be pre-established,
According to this base rule, the name of field can be evaluated when creating field, to guarantee the field of table
Naming conventions.But, the method rules according to which when creating a certain field cannot avoid close field
Appearance, therefore, easily cause the different field of same implication to occur in multiple table, produce redundancy word
Section, and redundant field wastes substantial amounts of storage resource.
Therefore, a technical problem that those skilled in the art urgently solve is presently required is exactly: how can
Reduce redundant field, save storage resource.
Summary of the invention
The embodiment of the present application technical problem to be solved is to provide a kind of field method to set up, it is possible to reduce
Redundant field, saves storage resource.
Accordingly, the embodiment of the present application additionally provides a kind of field and arranges device, in order to ensure said method
Realization and application.
In order to solve the problems referred to above, this application discloses a kind of field method to set up, including:
Receive the first field pre-created；
Described first field is carried out fuzzy matching with the field in history lists；
According to matching result, it is determined whether create described first field.
Further, described field in described first field and history lists is carried out fuzzy matching, including:
The normalization field searched belonging to described first field is concentrated in the history field being pre-created；
Transfer the field corresponding to described normalization field and carry out fuzzy matching with described first field respectively；
Wherein, described history field is concentrated and is comprised the field in all history lists, and implication is same or similar
The corresponding identical normalization field of field.
Further, the first field that described reception pre-creates, including:
Receive user and concentrate the first field selected, wherein, described conventional field name collection at conventional field name
In comprise the field name meeting preset field Naming conventions.
Further, the first field that described reception pre-creates, including:
Receive first field pre-created of user's input.
Further, described field in described first field and history lists is carried out fuzzy matching before,
Also include:
The first field described in the field specification set pair being pre-created is used to verify, in verification by rear,
Again described first field is carried out fuzzy matching with the field in history lists；
Wherein, described field specification is concentrated and is comprised the naming rule that type belonging to each field is corresponding.
Further, described according to matching result, it is determined whether to create described first field, including:
When described matching result is without matching field, create described first field.
Further, described according to matching result, it is determined whether to create described first field, including:
When obtaining matching field, transfer the related information of described matching field；
When the related information of described matching field meets prerequisite, give up described first field.
Further, described in transfer the related information of described matching field, including:
Transfer the description information of described matching field and the history lists information at place thereof；And/or,
Field in each field being pre-created is worth to concentrate searches the field valency that described matching field is corresponding
Value collection, wherein, the field of described each field be worth concentrate the storage size accounting including at least each field,
One of utilization rate, contribution rate.
The embodiment of the present application also discloses a kind of field and arranges device, including:
Field receives unit, is configured to receive the first field pre-created；
Matching unit, is configured to the field in history lists, described first field is carried out fuzzy matching；
Determine unit, be configured to according to matching result, it is determined whether create described first field.
Further, described matching unit includes:
Search subelement, be configured to concentrate in the history field being pre-created search described first field institute
The normalization field belonged to；
Coupling subelement, is configured to transfer the field corresponding to described normalization field respectively with described the
One field carries out fuzzy matching；
Wherein, described history field is concentrated and is comprised the field in all history lists, and implication is same or similar
The corresponding identical normalization field of field.
Further, described determine that unit includes:
Transfer subelement, when being configured as obtaining matching field, transfer the association letter of described matching field
Breath；
Subelement is set, is configured as the related information of described matching field when meeting prerequisite, house
Abandon described first field.
Further, described in transfer subelement, be configured to transfer the description information of described matching field and
The history lists information at place；And/or, the field in each field being pre-created is worth to concentrate searches described
Joining field corresponding to field and be worth collection, wherein, the field of described each field is worth to be concentrated including at least each word
One of the storage size accounting of section, utilization rate, contribution rate.Compared with prior art, the embodiment of the present application
Including advantages below:
Field in this field and history lists by when creating field, is first carried out by the embodiment of the present application
Join, then determine whether to create this field according to matching result so that during data warehouse builds table,
The reasonability of field can be judged timely and effectively, decrease the generation of redundant field, thus saved and deposited
Storage resource.
Accompanying drawing explanation
Fig. 1 is the flow chart of steps of a kind of field method to set up embodiment of the application；
Fig. 2 is the flow chart of steps of the another kind of field method to set up embodiment of the application；
Fig. 3 is a kind of method that with the field in history lists, the first field is carried out fuzzy matching of the application
The flow chart of steps of embodiment；
Fig. 4 is that the one of the application is according to matching result, it is determined whether the method creating the first field is implemented
The flow chart of steps of example；
Fig. 5 is the structured flowchart that a kind of field of the application arranges device embodiment；
Fig. 6 is the structured flowchart of a kind of matching unit in the embodiment of the present application；
Fig. 7 is a kind of structured flowchart determining unit in the embodiment of the present application.
Detailed description of the invention
Understandable, below in conjunction with the accompanying drawings for enabling the above-mentioned purpose of the application, feature and advantage to become apparent from
With detailed description of the invention, the application is described in further detail.
With reference to Fig. 1, it is shown that the flow chart of steps of a kind of field method to set up embodiment of the application, tool
Body may include steps of:
Step 101, receives the first field pre-created.
In the embodiment of the present application, first the device (hereinafter referred to as this device) arranged for field receives use
The first field that family pre-creates, this first field can be that user directly inputs, it is also possible to is this device
Option is provided to be selected by user.Specifically please participate in the description of subsequent embodiment.
Step 102, carries out fuzzy matching by the first field with the field in history lists.
This step can carry out fuzzy matching with the first field one by one with the field in traversal history table.Also may be used
In advance the field in history lists is sorted out, then transfer in the history lists generic with the first field
Field mate with the first field one by one.The method of the coupling in this step can be semantic matches,
Concrete similar with existing matching process, here is omitted.Wherein, history lists has been built in being data base
The tables of data erected.
Step 103, according to matching result, it is determined whether create the first field.
After receiving matching result, if history lists does not has the field of coupling, then may determine that establishment
This first field, it is also possible to further according to other prerequisite etc. carry out follow-up judgement whether to create this
One field.
If history lists exists matching field, then can determine according to the relevant information of matching field and be
This first field of no establishment, for example, it is possible to give up this first field and inherit this matching field etc., specifically
Refer to the description of subsequent embodiment.
Field in this field and history lists by when creating field, is first carried out by the embodiment of the present application
Join, then determine whether to create this field according to matching result so that during data warehouse builds table,
The reasonability of field can be judged timely and effectively, decrease the generation of redundant field, thus saved and deposited
Storage resource.
In one of them embodiment of the application, above-mentioned steps 101 receives the first field pre-created,
Can be specifically to receive user to concentrate the first field selected at conventional field name.
In the present embodiment, this device can pre-build that conventional field name collection selects for user, and this is commonly used
Field name is concentrated and is comprised the field name meeting preset field Naming conventions, such as, and commonly used word in territory, basis
Section English name etc..This conventional field name collection can have one or more, and the most different types of field is corresponding
There is different conventional field name collection.
When user's field to be created, this device can eject conventional field name collection, and user can quickly select
Select out the first field meeting Naming conventions.
In another embodiment of the application, above-mentioned steps 101 receives the first field pre-created,
It can be specifically the first field pre-created receiving user's input.In this embodiment, as in figure 2 it is shown,
Before stating step 102 before execution, the method can also include:
Step 201, uses field specification set pair the first field being pre-created to verify.
This device has been pre-created field specification collection, wherein can comprise the life that type belonging to each field is corresponding
Name rule.Such as: date type field must be taken the lead with " gmt_ ", value is the word of " be/non-"
Duan Bixu takes the lead with " is_ ", and field is minimum or greatest length is arranged.This set is mainly used in
Field is carried out most basic Naming conventions verification.
In this step, after this device receives the first field of user's input, i.e. may utilize this field
This first field is verified by specifications set, concrete, can be that first user selects the first word at interface
Type belonging to Duan, such as: date type, numeric type etc., this device treats, in reception, the class that this user selects
After type, field specification set pair the first field transferring corresponding types verifies, and check results is returned
To user, it is also possible to provide corresponding prompting and for user, the first field is modified simultaneously, until the first word
Section verification is passed through.
In verification by rear, then perform abovementioned steps 102 and carry out the fuzzy matching of interfield.
Above-described embodiment can be with the life of normative field by arranging conventional field name collection and/or field specification collection
Name, is also beneficial to reduce the redundancy of field.
In another embodiment of the application, the first field and the field in history lists are being carried out fuzzy
During joining, as it is shown on figure 3, specifically may include that
Step 301, concentrates the normalization field searched belonging to the first field in the history field being pre-created.
Being pre-created history field collection in this device, this history field is concentrated and is comprised in all history lists
Field in field, and this set all did normalization, and the same or analogous field of implication is corresponding identical
Normalization field, this set is by the field name in the history lists before normalization and the normalization field after normalizing
Name all preserves, and checks to facilitate.
This device is i.e. concentrated in history field after receiving the first field and is searched returning belonging to the first field
One changes field, and this search procedure can be the semantic matches mistake between first field and normalization field
Journey.
Step 302, transfers the field corresponding to normalization field and carries out fuzzy matching with the first field respectively.
After the normalization field finding correspondence, this device transfers out the institute corresponding with this normalization field
There is the field in history lists, carry out fuzzy matching with this first field the most one by one, can be specifically semantic
Coupling etc..
Concrete, this device can arrange matching degree threshold value, selects wherein to reach the history of matching degree threshold value
Field in table is as matching field.
In one of them embodiment of the application, when matching result is without matching field, this device can
Directly to create this first field in new table.When matching result exists matching field, this is according to coupling
Result, it is determined whether create the process of the first field, as shown in Figure 4, may include that
Step 401, when obtaining matching field, transfers the related information of matching field.
In the present embodiment, this device can transfer the description information of matching field and the history lists letter at place thereof
Breath；And/or, the field in each field being pre-created is worth to concentrate searches the field valency that matching field is corresponding
Value collection.
This device can be pre-created the field of each field and be worth collection, and at least a part of which comprises depositing of each field
Storage one of size accounting, utilization rate, contribution rate or combination in any.This set is mainly used in carrying out field
Plausibility check after reaching the standard grade.
Field storage size accounting can represent a field shared storage ratio in all fields of this table.
Computational methods: the length (byte number) of content-length (byte number) the ÷ all fields of this table of this field
Field utilization rate (width) can represent the ratio that a field is used at direct downstream node.
Computational methods: employ the direct downstream node number ÷ of this field employ this field place table direct under
Trip nodes
Field contribution rate (degree of depth) can represent the ratio that a field is used at indirect downstream node.
Computational methods: employ the indirect downstream node number ÷ of this field employ this field place table indirect under
Trip nodes.
Step 402, when the related information of matching field meets prerequisite, gives up the first field.
If this device obtains description information and the history lists information at place thereof of matching field, then can root
Set according to user or other prerequisite judges, when meeting prerequisite, gives up the first word
Section.Such as, the related information of matching field is returned to user by this device, and user understands matching field and exists
Which table occurs, thus judges whether in new table, to give up this first field, wherein, give up
This first field is probably and makes the first field directly inherit matching field, it is also possible in new table the most not
Comprise this first field or similar field.If needing to inherit matching field, then need to guarantee this first field
Definition with matching field is consistent.
If this device obtain matching field field be worth collection, then can according to user set or other
Prerequisite judge, when meeting prerequisite, give up the first field.Such as, this device can
So that the field of matching field value collection is returned to user, user judge whether accordingly to give up this first word
Section, it is also possible to preset the threshold value of storage size accounting, utilization rate, contribution rate etc. in this device, such as
When the storage size accounting of the first field or utilization rate or contribution rate are to a certain threshold value, this device is automatic
Give up this first field.
Above-mentioned prerequisite can set as required.
This device can also obtain the description information of matching field and the history lists information at place thereof simultaneously, and
The field of matching field is worth collection.This device can be first according to the description information of matching field and place thereof
History lists information determines whether to make the first field inherit matching field, if inheriting, recycling matching field
Field is worth collection, finally determines whether to use this matching field in new table；This device also can also first root
It is worth collection according to the field of matching field to judge whether to use this matching field, if using, further according to coupling word
The description information of section and the history lists information at place thereof determine the need for arranging this coupling word in new table
Section etc..In the case of this device obtains above two information at the same time, can adjust as required judge suitable
Sequence, until finally determining whether to give up this first field.
In this step, if the related information of matching field is unsatisfactory for prerequisite, then this device can be newly
Table creates this first field.
This device by after above-mentioned steps in all fields that pre-create, automatically generates and builds table statement, it is possible to
Literary name section is increased newly in field specification collection, conventional field name collection, history field collection three set, follow-up
New literary name section is reached the standard grade after actual application, then the service condition of each field increases newly field value concentration.
The present embodiment is by creating field specification collection, conventional field name collection, history field collection, field value
Collection, automatically carries out the verifications such as field name, field redundancies, not only avoids manual review field to be likely to result in
Deviation, allow user can judge the feasibility of field in time, decrease field redundancies, save and deposit
Storage resource, and ensure that the Naming conventions of literary name section, and can lead to reach the standard grade after field utilization rate
Statistics, take the circumstances into consideration to roll off the production line by field low for utilization rate, both ensure that the reasonability of field, saved again
Storage resource.
It should be noted that for embodiment of the method, in order to be briefly described, therefore it is all expressed as one it be
The combination of actions of row, but those skilled in the art should know, and the embodiment of the present application is not by described
The restriction of sequence of movement because according to the embodiment of the present application, some step can use other orders or
Person is carried out simultaneously.Secondly, those skilled in the art also should know, embodiment described in this description
Belong to preferred embodiment, necessary to involved action not necessarily the embodiment of the present application.
With reference to Fig. 5, it is shown that a kind of field of the application arranges the structured flowchart of device embodiment, specifically may be used
To include such as lower unit:
Field receives unit 501, is configured to receive the first field pre-created.
Matching unit 502, is configured to described first field and the field in history lists are carried out fuzzy
Join.
Determine unit 503, be configured to according to matching result, it is determined whether create described first field.
This field when creating field, is first carried out with the field in history lists by this device by said units
Coupling, then determines whether to create this field according to matching result so that build table process at data warehouse
In, the reasonability of field can be judged timely and effectively, decrease the generation of redundant field, thus save
Storage resource.
In another embodiment, field reception unit 501 can be configured to receive user in conventional field
Name concentrates the first field selected, and wherein, described conventional field name is concentrated to comprise and met preset field name
The field name of specification.
In another embodiment, this device can also include verification unit.
Wherein, field reception unit 501 can be configured to receive first word pre-created of user's input
Section.
Verification unit, is configured to use the first field described in the field specification set pair being pre-created to carry out school
Test.Wherein, described field specification is concentrated and is comprised the naming rule that type belonging to each field is corresponding.
Matching unit 502, be configured to verification unit verify by rear, then will described first field and
Field in history lists carries out fuzzy matching.
In another embodiment, as shown in Figure 6, matching unit 502 may further include:
Search subelement 601, be configured to concentrate in the history field being pre-created search described first word
Normalization field belonging to Duan.
Coupling subelement 602, be configured to transfer the field corresponding to described normalization field respectively with institute
State the first field and carry out fuzzy matching.
Wherein, described history field is concentrated and is comprised the field in all history lists, and implication is same or similar
The corresponding identical normalization field of field.
In another embodiment, determine that unit 503 can be configured as described matching result for without coupling
During field, create described first field.
In another embodiment, as it is shown in fig. 7, determine that unit 503 may further include:
Transfer subelement 701, when being configured as obtaining matching field, transfer the pass of described matching field
Connection information；
Subelement 702 is set, is configured as the related information of described matching field when meeting prerequisite,
Give up described first field.
Wherein, transfer subelement 701, be configured to transfer the description information of described matching field and institute thereof
History lists information；And/or, the field in each field being pre-created is worth to concentrate searches described coupling
The field value collection that field is corresponding, wherein, the field of described each field is worth to be concentrated including at least each field
Storage size accounting, utilization rate, one of contribution rate.
This device is worth collection by establishment field specification collection, conventional field name collection, history field collection, field,
Automatically carrying out the verification such as field name, field redundancies, that not only avoids that manual review field is likely to result in is inclined
Difference, allows user can judge the feasibility of field in time, decreases field redundancies, saves storage money
Source, and ensure that the Naming conventions of literary name section, and can lead to reach the standard grade after the system of field utilization rate
Meter, takes the circumstances into consideration to roll off the production line by field low for utilization rate, both ensure that the reasonability of field, saved again and deposit
Storage resource.
The embodiment of the present application also discloses a kind of field and arranges device, including memorizer, receptor and process
Device.
Processor is connected with each other by bus with memorizer, receptor；Bus can be isa bus, PCI
Bus or eisa bus etc..Described bus can be divided into address bus, data/address bus, control bus etc..
Wherein, memorizer is for one section of program of storage, and specifically, program can include program code, institute
State program code and include computer-managed instruction.Memorizer may comprise high-speed RAM memorizer, it is possible to
Can also include nonvolatile memory (non-volatile memory), for example, at least one disk memory.
Receptor is for receiving the first field pre-created.
Processor is used for reading the program code in memorizer, execution following steps:
Described first field is carried out fuzzy matching with the field in history lists；
According to matching result, it is determined whether create described first field.
For device embodiment, due to itself and embodiment of the method basic simlarity, so the comparison described
Simply, relevant part sees the part of embodiment of the method and illustrates.
Each embodiment in this specification all uses the mode gone forward one by one to describe, and each embodiment stresses
Be all the difference with other embodiments, between each embodiment, identical similar part sees mutually
?.
Those skilled in the art are it should be appreciated that the embodiment of the embodiment of the present application can be provided as method, dress
Put or computer program.Therefore, the embodiment of the present application can use complete hardware embodiment, completely
Software implementation or the form of the embodiment in terms of combining software and hardware.And, the embodiment of the present application
Can use and can be situated between with storage at one or more computers wherein including computer usable program code
The upper computer journey implemented of matter (including but not limited to disk memory, CD-ROM, optical memory etc.)
The form of sequence product.
In a typical configuration, described computer equipment includes one or more processor
(CPU), input/output interface, network interface and internal memory.Internal memory potentially includes computer-readable medium
In volatile memory, the shape such as random access memory (RAM) and/or Nonvolatile memory
Formula, such as read only memory (ROM) or flash memory (flash RAM).Internal memory is computer-readable medium
Example.Computer-readable medium includes removable media permanent and non-permanent, removable and non-
Information storage can be realized by any method or technology.Information can be computer-readable instruction,
Data structure, the module of program or other data.The example of the storage medium of computer includes, but
Be not limited to phase transition internal memory (PRAM), static RAM (SRAM), dynamic random are deposited
Access to memory (DRAM), other kinds of random access memory (RAM), read only memory
(ROM), Electrically Erasable Read Only Memory (EEPROM), fast flash memory bank or other in
Deposit technology, read-only optical disc read only memory (CD-ROM), digital versatile disc (DVD) or other
Optical storage, magnetic cassette tape, tape magnetic rigid disk storage other magnetic storage apparatus or any its
His non-transmission medium, can be used for the information that storage can be accessed by a computing device.According to herein
Defining, computer-readable medium does not include the computer readable media (transitory media) of non-standing,
Data signal and carrier wave such as modulation.
The embodiment of the present application is with reference to the method according to the embodiment of the present application, terminal unit (system) and meter
The flow chart of calculation machine program product and/or block diagram describe.It should be understood that can be by computer program instructions
Each flow process in flowchart and/or block diagram and/or square frame and flow chart and/or square frame
Flow process in figure and/or the combination of square frame.Can provide these computer program instructions to general purpose computer,
The processor of special-purpose computer, Embedded Processor or other programmable data processing terminal equipment is to produce
One machine so that performed by the processor of computer or other programmable data processing terminal equipment
Instruction produce for realizing at one flow process of flow chart or multiple flow process and/or one square frame of block diagram or
The device of the function specified in multiple square frames.
These computer program instructions may be alternatively stored in and computer or other programmable datas can be guided to process
In the computer-readable memory that terminal unit works in a specific way so that be stored in this computer-readable
Instruction in memorizer produces the manufacture including command device, and this command device realizes flow chart one
The function specified in flow process or multiple flow process and/or one square frame of block diagram or multiple square frame.
These computer program instructions also can be loaded into computer or other programmable data processing terminals set
Standby upper so that on computer or other programmable terminal equipment, to perform sequence of operations step in terms of producing
The process that calculation machine realizes, thus the instruction performed on computer or other programmable terminal equipment provides and uses
In realizing in one flow process of flow chart or multiple flow process and/or one square frame of block diagram or multiple square frame
The step of the function specified.
Although having been described for the preferred embodiment of the embodiment of the present application, but those skilled in the art being once
Know basic creative concept, then these embodiments can be made other change and amendment.So,
Claims are intended to be construed to include preferred embodiment and fall into the institute of the embodiment of the present application scope
There are change and amendment.
Finally, in addition it is also necessary to explanation, in this article, the relational terms of such as first and second or the like
It is used merely to separate an entity or operation with another entity or operating space, and not necessarily requires
Or imply relation or the order that there is any this reality between these entities or operation.And, art
Language " includes ", " comprising " or its any other variant are intended to comprising of nonexcludability, so that
Process, method, article or terminal unit including a series of key elements not only include those key elements, and
Also include other key elements being not expressly set out, or also include for this process, method, article or
The key element that person's terminal unit is intrinsic.In the case of there is no more restriction, statement " include one
It is individual ... " key element that limits, it is not excluded that including the process of described key element, method, article or end
End equipment there is also other identical element.
Above a kind of field method to set up provided herein and a kind of field are arranged device, carry out
Being discussed in detail, principle and the embodiment of the application are set forth by specific case used herein,
The explanation of above example is only intended to help and understands the present processes and core concept thereof；Meanwhile, right
In one of ordinary skill in the art, according to the thought of the application, in detailed description of the invention and range of application
On all will change, in sum, this specification content should not be construed as the restriction to the application.
Claims (12)
1. a field method to set up, it is characterised in that including:
Receive the first field pre-created；
Described first field is carried out fuzzy matching with the field in history lists；
According to matching result, it is determined whether create described first field.
Method the most according to claim 1, it is characterised in that described by described first field with
Field in history lists carries out fuzzy matching, including:
The normalization field searched belonging to described first field is concentrated in the history field being pre-created；
Transfer the field corresponding to described normalization field and carry out fuzzy matching with described first field respectively；
Wherein, described history field is concentrated and is comprised the field in all history lists, and implication is same or similar
The corresponding identical normalization field of field.
Method the most according to claim 1, it is characterised in that described reception pre-create first
Field, including:
Receive user and concentrate the first field selected, wherein, described conventional field name collection at conventional field name
In comprise the field name meeting preset field Naming conventions.
Method the most according to claim 1, it is characterised in that described reception pre-create first
Field, including:
Receive first field pre-created of user's input.
Method the most according to claim 4, it is characterised in that described by described first field
Before carrying out fuzzy matching with the field in history lists, also include:
The first field described in the field specification set pair being pre-created is used to verify, in verification by rear,
Again described first field is carried out fuzzy matching with the field in history lists；
Wherein, described field specification is concentrated and is comprised the naming rule that type belonging to each field is corresponding.
Method the most as claimed in any of claims 1 to 5, it is characterised in that described
According to matching result, it is determined whether create described first field, including:
When described matching result is without matching field, create described first field.
Method the most as claimed in any of claims 1 to 5, it is characterised in that described
According to matching result, it is determined whether create described first field, including:
When obtaining matching field, transfer the related information of described matching field；
When the related information of described matching field meets prerequisite, give up described first field.
Method the most according to claim 7, it is characterised in that described in transfer described matching field
Related information, including:
Transfer the description information of described matching field and the history lists information at place thereof；And/or,
Field in each field being pre-created is worth to concentrate searches the field valency that described matching field is corresponding
Value collection, wherein, the field of described each field be worth concentrate the storage size accounting including at least each field,
One of utilization rate, contribution rate.
9. a field arranges device, it is characterised in that including:
Field receives unit, is configured to receive the first field pre-created；
Matching unit, is configured to the field in history lists, described first field is carried out fuzzy matching；
Determine unit, be configured to according to matching result, it is determined whether create described first field.
Device the most according to claim 9, it is characterised in that described matching unit includes:
Search subelement, be configured to concentrate in the history field being pre-created search described first field institute
The normalization field belonged to；
Coupling subelement, is configured to transfer the field corresponding to described normalization field respectively with described the
One field carries out fuzzy matching；
Wherein, described history field is concentrated and is comprised the field in all history lists, and implication is same or similar
The corresponding identical normalization field of field.
11. according to the device described in claim 9 or 10, it is characterised in that described determine unit bag
Include:
Transfer subelement, when being configured as obtaining matching field, transfer the association letter of described matching field
Breath；
Subelement is set, is configured as the related information of described matching field when meeting prerequisite, house
Abandon described first field.
12. devices according to claim 11, it is characterised in that
Described transfer subelement, be configured to transfer the description information of described matching field and going through of place thereof
History table information；And/or, the field in each field being pre-created is worth to concentrate searches described matching field pair
The field answered is worth collection, and wherein, the field of described each field is worth concentrates the storage including at least each field
One of size accounting, utilization rate, contribution rate.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510222343.7A CN106202091A (en) | 2015-05-04 | 2015-05-04 | A kind of field method to set up and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510222343.7A CN106202091A (en) | 2015-05-04 | 2015-05-04 | A kind of field method to set up and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106202091A true CN106202091A (en) | 2016-12-07 |
Family
ID=57458014
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510222343.7A Pending CN106202091A (en) | 2015-05-04 | 2015-05-04 | A kind of field method to set up and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106202091A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108255883A (en) * | 2016-12-29 | 2018-07-06 | 北京国双科技有限公司 | Data capture method and device |
| CN109375900A (en) * | 2018-10-16 | 2019-02-22 | 广州市南方人力资源评价中心有限公司 | A kind of tables of data and data field name automatic generation |
| CN110348974A (en) * | 2019-05-21 | 2019-10-18 | 深圳壹账通智能科技有限公司 | Financial statement treating method and apparatus |
| CN110909003A (en) * | 2019-11-25 | 2020-03-24 | 车智互联（北京）科技有限公司 | Method for creating data table and computing equipment |
| CN113010517A (en) * | 2021-03-08 | 2021-06-22 | 中国工商银行股份有限公司 | Data table management method and device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101504640A (en) * | 2009-03-23 | 2009-08-12 | 金蝶软件（中国）有限公司 | Data sheet editing method and apparatus |
| CN102043823A (en) * | 2010-09-27 | 2011-05-04 | 深圳市五巨科技有限公司 | Method and device for flexibly selecting and gathering fields in dynamic pages |
| CN102346785A (en) * | 2011-11-15 | 2012-02-08 | 北京创腾科技有限公司 | Method and device for directly self-defining field of database |
| CN103365891A (en) * | 2012-04-01 | 2013-10-23 | 金蝶软件（中国）有限公司 | Method and device for classifying data through agent fields |
| CN103500183A (en) * | 2013-09-12 | 2014-01-08 | 国家计算机网络与信息安全管理中心 | Storage structure based on multiple-relevant-field combined index and building, inquiring and maintaining method |
-
2015
- 2015-05-04 CN CN201510222343.7A patent/CN106202091A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101504640A (en) * | 2009-03-23 | 2009-08-12 | 金蝶软件（中国）有限公司 | Data sheet editing method and apparatus |
| CN102043823A (en) * | 2010-09-27 | 2011-05-04 | 深圳市五巨科技有限公司 | Method and device for flexibly selecting and gathering fields in dynamic pages |
| CN102346785A (en) * | 2011-11-15 | 2012-02-08 | 北京创腾科技有限公司 | Method and device for directly self-defining field of database |
| CN103365891A (en) * | 2012-04-01 | 2013-10-23 | 金蝶软件（中国）有限公司 | Method and device for classifying data through agent fields |
| CN103500183A (en) * | 2013-09-12 | 2014-01-08 | 国家计算机网络与信息安全管理中心 | Storage structure based on multiple-relevant-field combined index and building, inquiring and maintaining method |
Non-Patent Citations (3)
| Title |
|---|
| 何炎祥等: "物联网环境中数据存储与查询机制研究", 《计算机科学》 * |
| 凯文加内特: "mysql在增加列前进行判断该列是否存在", 《HTTPS://WWW.2CTO.COM/DATABASE/201310/253029.HTML》 * |
| 卢晶: "CT病案库的计算机管理经验", 《影像诊断与介入仿射学》 * |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108255883A (en) * | 2016-12-29 | 2018-07-06 | 北京国双科技有限公司 | Data capture method and device |
| CN108255883B (en) * | 2016-12-29 | 2021-12-24 | 北京国双科技有限公司 | Data acquisition method and device |
| CN109375900A (en) * | 2018-10-16 | 2019-02-22 | 广州市南方人力资源评价中心有限公司 | A kind of tables of data and data field name automatic generation |
| CN110348974A (en) * | 2019-05-21 | 2019-10-18 | 深圳壹账通智能科技有限公司 | Financial statement treating method and apparatus |
| CN110909003A (en) * | 2019-11-25 | 2020-03-24 | 车智互联（北京）科技有限公司 | Method for creating data table and computing equipment |
| CN110909003B (en) * | 2019-11-25 | 2022-06-10 | 车智互联（北京）科技有限公司 | Method for creating data table and computing equipment |
| CN113010517A (en) * | 2021-03-08 | 2021-06-22 | 中国工商银行股份有限公司 | Data table management method and device |
| CN113010517B (en) * | 2021-03-08 | 2024-02-09 | 中国工商银行股份有限公司 | Data table management method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10719662B2 (en) | Knowledge map-based question-answer method, device, and storage medium | |
| Peng et al. | Pythagorean fuzzy Choquet integral based MABAC method for multiple attribute group decision making | |
| Wu et al. | An interactive clustering-based approach to integrating source query interfaces on the deep web | |
| CN107526800B (en) | Device, method and the computer readable storage medium of information recommendation | |
| US9524310B2 (en) | Processing of categorized product information | |
| CN106202091A (en) | A kind of field method to set up and device | |
| CN106156145A (en) | The management method of a kind of address date and device | |
| US20130031126A1 (en) | Weighting metric for visual search of entity-relationship databases | |
| US9501567B2 (en) | User-guided multi-schema integration | |
| CN102693246B (en) | Method and system for obtaining information from dataset | |
| CN107016047A (en) | Document query, document storing method and device | |
| WO2022019973A1 (en) | Enterprise knowledge graphs using enterprise named entity recognition | |
| WO2022019974A1 (en) | Enterprise knowledge graph building with mined topics and relationships | |
| Xue et al. | Ontology alignment based on instance using NSGA-II | |
| Chiang et al. | Progressive simplification of tetrahedral meshes preserving all isosurface topologies | |
| US20130151519A1 (en) | Ranking Programs in a Marketplace System | |
| Amiri et al. | Data‐driven business process similarity | |
| WO2022019986A1 (en) | Enterprise knowledge graphs using multiple toolkits | |
| WO2015084757A1 (en) | Systems and methods for processing data stored in a database | |
| Li et al. | Exploiting statistically significant dependent rules for associative classification | |
| WO2022020005A1 (en) | Enterprise knowledge graphs using user-based mining | |
| CN104463460A (en) | Method and device for processing scheduling information for network data delivery | |
| CN110502589B (en) | Node blood-edge relationship determination method and device and electronic equipment | |
| CN110232088B (en) | Method and device for classification merging and storage medium | |
| Hońko | Upgrading a granular computing based data mining framework to a relational case |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20161207 |
|
| RJ01 | Rejection of invention patent application after publication |