Method, system, program, and data structure for cleaning a database table
US7249151B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jul 26, 2005 |
| Grant date | Jul 24, 2007 |
| Priority date | — |
| Expiry date | Jul 26, 2025 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99945
- 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. The input table to clean is indicated in an input data table name. At least one rule definition is processed to clean the input table. Each rule definition indicates a find criteria, a replacement value, and an input data column in the input table. For each rule definition, the input data column is searched for any fields that match the find criteria. The replacement value for the particular rule definition is inserted in the fields in the input data column that match the find criteria. Subsequent applications of additional rule definitions applied to the same input data column operate on replacement values inserted in the input data column during previously applied rule definitions.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.