<script type="text/javascript">
<!--
document.write('<div id="oa_widget"></div>');
document.write('<script type="text/javascript" src="https://www.openaire.eu/index.php?option=com_openaire&view=widget&format=raw&projectId=undefined&type=result"></script>');
-->
</script>
A new formalism for null values is developed, based on the semantics that a null value conveys no information; that it is less informative then either an ''exists but unknown'' or a ''no value'' null. What results is a theory of ''heterogeneous relations'': relations with tuples over different schemes. The concept is essentially that of \textit{E. Sciore}'s relations with objects [''The universal instance and database design'', Ph. D. Thesis, Princeton University (1980)] although the paper contains results that Sciore's work does not. After outlining previous approaches to null value semantics and their deficiencies, the author motivates his semantics and defines various orderings on the information content of tuples and relations. The key concept is an equivalence class, termed an x-relation, of information- equivalent heterogeneous relations. Boolean operations on x-relations are given, and it is shown how these operations can be realized efficiently through computations on minimal representatives of x-relations. The paper next considers query evaluation in the presence of nulls, introducing selection, join and projection for x-relations, and also a quotient operator that is the basis for defining universal quantification in the presence of incomplete information. The author concludes by showing that the operations defined for x-relations are a consistent extension of relational algebra for total relations and that the extension is maximal in the sense that all operations are defined for all arguments (unlike the standard model in which arguments are constrained to have certain scheme compatibilities).
heterogeneous relations, Data structures, relations with objects, Computer Networks and Communications, query processing, Applied Mathematics, Other classical set theory (including functions, relations, and set algebra), null value semantics, relations with tuples, universal quantification, Theoretical Computer Science, Information storage and retrieval of data, Computational Theory and Mathematics, relational database, incomplete information, relational algebra
heterogeneous relations, Data structures, relations with objects, Computer Networks and Communications, query processing, Applied Mathematics, Other classical set theory (including functions, relations, and set algebra), null value semantics, relations with tuples, universal quantification, Theoretical Computer Science, Information storage and retrieval of data, Computational Theory and Mathematics, relational database, incomplete information, relational algebra
citations This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically). | 228 | |
popularity This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network. | Top 10% | |
influence This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically). | Top 1% | |
impulse This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network. | Top 10% |