Closed World Databases Opened Through Null Values
نویسندگان
چکیده
We propose a new approach to the treatment of nullvalued attributes in the relational model. The approach is based on the new concept of locally-controlled open world database. A locally-controlled open world dab base permits the definition of portions of a traditional closed world database as open-world. Attributes, part of a relation, or entire relations can be explicitly defined as ‘open” through the insertion of null-values. Under this assumption, we consider three different types of null values: the standard unknown, does not e&t, and the new one, called open. We give a complete formal specification of the semantics of these null values. We extend the arithmetic and logical operators to cover nulls and outline how relational operators cau be extended accordingly. This paper describes ongoing work. We state some open problems to be solved iu order to render our approach more operational
منابع مشابه
Completeness in the Relational Model: a Comprehensive Framework
Completeness is a well known data quality dimension in the area of databases. Intuitively, a database is complete if it represents every fact of the real world coherent with the database semantics, i.e. its intension. In the paper, we provide a comprehensive framework for characterizing completeness in the relational model, investigating several different paradigms typical of database models, s...
متن کاملSTRESS INTENSITY FACTORS FOR AN INTERIOR GRIFFITH CRACK OPENED BY HEATED WEDGE IN A STRIP WHOSE EDGES ARE NORMAL TO CRACK AXIS
After second world war, we have seen a very rapid development of Thermoelasticity stimulated by various engineering sciences. As we know, structures behave in different fashion under climate variation and the most responsible factor for these variations is heat which falls through and causes deformation of the body. A considerable progress in the field of aircraft and machine structures, mainly...
متن کاملThe problem of missing data in geoscience databases
SQL is the (more or less) standardised language that is used by the majority of commercial database management systems. However, it is seriously flawed, as has been documented in detail by Date, Darwen, Pascal, and others. One of the most serious problems with SQL is the way it handles missing data. It uses a special value ‘NULL’ to represent data items whose value is not known. This can have a...
متن کامل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...
متن کاملContainment of Conjunctive Queries over Databases with Null Values
We study containment of conjunctive queries that are evaluated over databases that may contain tuples with null values. We assume the semantics of SQL for single block queries with a SELECT DISTINCT clause. This problem (“null containment” for short) is different from containment over databases without null values and sometimes more dif-
متن کامل