Method of automatic database field identification for postal coding
    1.
    发明授权
    Method of automatic database field identification for postal coding 失效
    邮政编码自动数据库字段识别方法

    公开(公告)号:US5761665A

    公开(公告)日:1998-06-02

    申请号:US551257

    申请日:1995-10-31

    IPC分类号: G06F17/30

    摘要: The invention is a method of determining the contents of a selected data field. The steps begin by attaching, from an application program, a database to be mapped. Once the database is attached, a field identification module (FIM), will scan the contents of the database to determine a data field identifier for each of the data fields to be worked upon. The FIM will then compare each of the data field identifiers with a list of known identifiers stored in a repository 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 will sample the data field according to a pre-selected list of requirements and make a second comparison with the data field. The FIM will then assess a second score. After sampling and scoring the data field, the FIM will construct a test case wherein the data field is used in the postal coding or host application and a third comparison is made in respect of the test case. The FIM will then assess a third score. The FIM will choose a field type based on the weighted average result of the three scores, and then request that the system operator confirm the selected field type. Once confirmed, the data field identifier and the data field represented thereby are added to the repository as one of the known identifiers.

    摘要翻译: 本发明是确定所选数据字段的内容的方法。 步骤首先从应用程序附加要映射的数据库。 数据库附加后,字段识别模块(FIM)将扫描数据库的内容,以确定要处理的每个数据字段的数据字段标识符。 然后,FIM将每个数据字段标识符与存储在存储库中的已知标识符的列表进行比较,并且评估关于比较的第一分数,其中分数表示比较是精确比较的概率。 当已经确定了第一概率分数时,FIM将根据预先选择的需求列表对数据字段进行采样,并与数据字段进行第二次比较。 然后,FIM将评估第二个分数。 在对数据字段进行抽样和评分后,FIM将构建一个测试用例,其中数据字段用于邮政编码或主机应用程序,并且就测试用例进行了第三次比较。 FIM将评估第三名。 FIM将根据三个分数的加权平均结果选择一个字段类型,然后请求系统操作员确认所选字段类型。 一旦被确认,数据字段标识符和由其表示的数据字段被作为已知标识符之一被添加到存储库中。