Method and system for managing databases having records with missing values
AssigneeSap SE
InventorsWen-Syan Li, Yu Cheng
Life of this patent
Estimating the term…
Abstract
The method includes selecting a target record from a dataset, the target record including a missing value, partitioning records of the dataset into at least two groups including co-related data, the partitioned records including records having a value for a same field as the missing value in the target record, predicting the missing value based on a relationship between fields in each of the at least two groups associated with the partitioned records, and setting the missing value of the target record to the predicted value.
Claims20
A method, comprising:
- selecting a target record from a dataset, the target record including a missing value;
- partitioning records of the dataset into at least two groups including co-related data, the partitioned records including records having a value for a same field as the missing value in the target record;
- predicting the missing value based on a relationship between fields in each of the at least two groups associated with the partitioned records;
- and
- setting the missing value of the target record to the predicted value.
A non-transitory computer-readable storage medium having stored thereon computer executable program code which, when executed on a computer system, causes the computer system to perform steps comprising:
- select a target record from a dataset, the target record including a missing value;
- partition records of the dataset into at least two groups including co-related data, the partitioned records including records having a value for a same field as the missing value in the target record;
- predict the missing value based on a relationship between fields in each of the at least two groups associated with the partitioned records;
- and
- set the missing value of the target record to the predicted value.
An apparatus including a processor and a non-transitory computer readable medium, the apparatus comprising:
- a value prediction module configured to:
- select a target record from a dataset, the target record including a missing value;
- and
- set the missing value of the target record to a predicted value;
- and
- a model generation module configured to:
- partition records of the dataset into at least two groups including co-related data, the partitioned records including records having a value for a same field as the missing value in the target record;
- and
- predict the missing value based on a relationship between fields in each of the at least two groups associated with the partitioned records.
Dependencies are inferred from the claim text.