Method, system, program, and data structure for cleaning a database table using a look-up table
US6965888B1 · kind B1 · utility
26Cited by
34References
39Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Sep 21, 1999 |
| Grant date | Nov 15, 2005 |
| Priority date | — |
| Expiry date | Sep 21, 2019 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99931
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Disclosed is a method, system, program, and data structure for performing a clean operation on an input table. An input data table name indicates the input table. A first column in a table including a plurality of entries and at least one rule definition are processed. Each rule definition indicates a look-up column including a plurality of entries and a clean operation. A determination is made, for each record in the input table column, whether the record matches one entry in the look-up column. If so, the clean operation indicated in the rule definition is performed on each record that matches one entry in the look-up column.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.