Estimating Null Values in Relational Databases Using Analogical Proportions

نویسندگان

  • William Correa Beltran
  • Hélène Jaudoin
  • Olivier Pivert
چکیده

This paper presents a novel approach to the prediction of null values in relational databases, based on the notion of analogical proportion. We show in particular how an algorithm initially proposed in a classification context can be adapted to this purpose. This work focuses on the case of a transactional database, where attributes are Boolean. The experimental results reported here, even though preliminary, are encouraging since the approach yields a better precision, on average, than the classical nearest neighbors technique.

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Adaptive-clustering Based Method to Estimate Null Values in Relational Databases

Data preprocessing is an essential step of knowledge discovery. Data preprocessing comprises data cleaning, data integration, data transformation, data reduction and data discretization. Estimating null values is a task of data cleaning. Null values in a database are significant sources of poor data quality. Therefore, the appropriate handling of null values is an important task of data preproc...

متن کامل

Estimating Null Values In Relational Database Systems Based On Genetic Algorithms

In this paper, we present a new method to estimate null values in relational database systems based on genetic algorithms. It can tune the membership functions of the linguistic values of the attributes in relational database systems for estimating null values. The proposed method can get a higher average estimated accuracy rate than the existing methods for estimating null values in relational...

متن کامل

Generating weighted fuzzy rules from relational database systems for estimating values using genetic algorithms

In recent years, some methods have been proposed to estimate null values in relational database systems. However, the estimated accuracy of the existing methods are not good enough. In this paper, we present a new method to generate weighted fuzzy rules from relational database systems for estimating null values using genetic algorithms (GAs), where the attributes appearing in the antecedent pa...

متن کامل

On the Logic of SQL Nulls

The logic of nulls in databases has been subject of investigation since their introduction in Codd’s Relational Model, which is the foundation of the SQL standard. In the logic based approaches to modelling relational databases proposed so far, nulls are considered as representing unknown values. Such existential semantics fails to capture the behaviour of the SQL standard. We show that, accord...

متن کامل

The Algebra and the Logic for SQL Nulls

The logic of nulls in databases has been subject of investigation since their introduction in Codd’s Relational Model, which is the foundation of the SQL standard. In the logic based approaches to modelling relational databases proposed so far, nulls are considered as representing unknown values. Such existential semantics fails to capture the behaviour of the SQL standard. We show that, accord...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2014