About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Publication
IEEE Transactions on Software Engineering
Paper
Statistical Relational Tables for Statistical Database Management
Abstract
This paper extends Codd's relational view to represent statistical data and to achieve the efficient analysis of statistical data. It discusses why the relational calculus has not been popular with statisticians. A new view called a statistical relational table is presented, to meet the needs of the statisticians. Some of Codd's relational operators are extended to the statistical relational tables. New operators, based on the statistical relational tables, are introduced for communicating requests for statistical analysis. A new query language, called the query-by-statistical-relational-table (which has some similarities with query-by-example), is introduced. Extensions of SQL language for processing the commands of the new query language are also discussed. Creation and storage of metadata for fast statistical analysis are considered. Some problems related to privacy in statistical databases are also examined. © 1986 IEEE