发明名称 Automatic database field identification eg for postal coding
摘要 A method of determining the nature of the contents of a data field. A field identification module (FIM) 102, scans the contents of the database 106 to determine a data field identifier for each of the data fields to be worked upon. The FIM 102 then compares each of the data field identifiers with a list of known identifiers stored in a repository 108 and assess a first score in respect of the comparison wherein the score is representative of a probability that the comparison is an accurate comparison. When a first probability score has been determined, the FIM 102 samples the data field according to a preselected list of requirements and make a second comparison with the data field. The FIM 102 then assesses a second score. After sampling the FIM 102 constructs a test case wherein the data field is used in the host application and a third comparison is made in respect of the test case. The FIM 102 then assesess a third score. The FIM 102 chooses a field type based on the weighted average result of the three scores and confirmed by a system operator. Once confirmed, the data field identifier and the data field represented thereby are added to the repository 108 as one of the known identifiers. The host application may be a postal coding system.
申请公布号 GB2306715(A) 申请公布日期 1997.05.07
申请号 GB19960022731 申请日期 1996.10.31
申请人 * PITNEY BOWES INC 发明人 DAVID P * GARDNER;STEVEN M * KAYE;JEFFERY D * PIERCE
分类号 G06F17/30;(IPC1-7):G06F17/60 主分类号 G06F17/30
代理机构 代理人
主权项
地址