Statistical Database Query Languages

Databases that are mainly used for statistical analysis are called statistical databases (SDB). A statistical database management system (SDBMS) may be defined as a database management system that provides capabilities 1) to model, store, and manipulate data in a manner suitable for the needs of SDB users, and 2) to apply statistical data analysis techniques that range from simple summary statistics to advanced procedures. This paper surveys the existing and proposed SDB data definition and data manipulation (i.e., query) languages.

[1]  Gultekin Özsoyoglu,et al.  Extending relational algebra and relational calculus with set-valued attributes and aggregate functions , 1987, TODS.

[2]  Sakti P. Ghosh,et al.  An Application of Statistical Databases in Manufacturing Testing , 1984, IEEE Transactions on Software Engineering.

[3]  Gultekin Özsoyoglu,et al.  A Query Language for Statistical Databases , 1985, Query Processing in Database Systems.

[4]  Hans-Jörg Schek,et al.  Remarks on the algebra of non first normal form relations , 1982, PODS.

[5]  Frank Olken.  How Baroque Should a Statistical Database Management System Be? , 1983, SSDBM.

[6]  Sue M. Dintelman,et al.  The GENISYS Data Definition Facilities , 1983, SSDBM.

[7]  Anthony C. Klug.  Access paths in the "Abe" statistical query facility , 1982, SIGMOD '82.

[8]  Dorothy E. Denning,et al.  Cryptography and Data Security , 1982 .

[9]  Peter P. Chen.  The entity-relationship model: toward a unified view of data , 1975, VLDB '75.

[10]  Barry Robinson,et al.  An Integrated Research Support System for Inter-Package Communication and Handling Large Volume Output From Statistical Database Analysis Operations , 1983, SSDBM.

[11]  M. J. Turner,et al.  A DBMS For Large Statistical Databases , 1979, Fifth International Conference on Very Large Data Bases, 1979..

[12]  Arie Shoshani,et al.  SUBJECT: A Directory Driven System for Organizing and Accessing Large Statistical Databases , 1981, VLDB.

[13]  John L. McCarthy,et al.  Metadata Management for Large Statistical Databases , 1982, VLDB.

[14]  Lynn A. Hollabaugh,et al.  GPI: A Statistical Package/Data Base Interface , 1981, SSDBM.

[15]  Sue M. Dintelman,et al.  An implementation of a query language supporting path expressions , 1982, SIGMOD '82.

[16]  Gary G. Hendrix,et al.  Developing a natural language interface to complex data , 1977, TODS.

[17]  R. G. G. Cattell,et al.  An entity-based database user interface , 1980, SIGMOD '80.

[18]  Shamkant B. Navathe,et al.  Complex Data Types and a Data Manipulation Language for Scientific and Statistical Databases , 1983, SSDBM.

[19]  Gultekin Özsoyoglu,et al.  On optimizing summary-table-by-example queries , 1985, PODS '85.

[20]  Anthony C. Klug.  Abe: A Query Language for Constructing Aggregates-by-Example , 1981, SSDBM.

[21]  Anthony C. Klug.  Equivalence of Relational Algebra and Relational Calculus Query Languages Having Aggregate Functions , 1982, JACM.

[22]  Fredric C. Gey,et al.  Distributed Data Management in a Minicomputer Network: The SEEDIS Experience , 1983, SSDBM.

[23]  Arie Shoshani,et al.  Statistical Databases: Characteristics, Problems, and some Solutions , 1982, VLDB.

[24]  Per Svensson,et al.  An Overview of Cantor - A New System for Data Analysis , 1983, SSDBM.

[25]  Arnon Rosenthal,et al.  Extending the Algebraic Framework of Query Processing to Handle Outerjoins , 1984, VLDB.

[26]  Dennis Tsichritzis,et al.  LSL: a Link and Selector Language , 1976, SIGMOD '76.

[27]  Roald Buhler.  Data Manipulation in P-STAT , 1981, SSDBM.

[28]  Stephen E. Weiss,et al.  Must We Navigate Through Databases? , 1981, SSDBM.

[29]  Shamkant B. Navathe,et al.  Logical and Physical Modeling of Statistical Scientific Databases , 1983, SSDBM.

[30]  Stephen E. Weiss,et al.  Paste - A Tool to Put Application Systems Together Easily , 1983, SSDBM.

[31]  Mauro Maier,et al.  System/K: A Knowledge Base Management System , 1983, SSDBM.

[32]  Stanley Y. W. Su,et al.  SAM*: A Semantic Association Model for Corporate and Scientific/Statistical Databases , 1983, Inf. Sci..

[33]  Sue M. Dintelman,et al.  Design of the Genealogical Information System , 1981, SSDBM.

[34]  Gultekin Özsoyoglu,et al.  An Extension of Relational Algebra for Summary Tables , 1983, SSDBM.

[35]  Z. Meral Ozsoyoglu,et al.  An extension of relational algebra for summary tables , 1983 .

[36]  Sakti P. Ghosh.  Statistical relational tables for statistical database management , 1986, IEEE Transactions on Software Engineering.

[37]  Rowland R. Johnson,et al.  Modelling summary data , 1981, SIGMOD '81.

[38]  Gultekin Özsoyoglu,et al.  A language and a physical organization technique for summary tables , 1985, SIGMOD Conference.

[39]  Kohji Shibano,et al.  Statistical Database Research Project in Japan and the CAS SDB Project , 1983, SSDBM.

[40]  Sandra Heiler,et al.  SIBYL: An Economist's Workbench , 1983, SSDBM.

[41]  David L. Hall,et al.  ALDS Project: Motivation, Statistical Database Management Issues, Perspectives, and Directions , 1983, SSDBM.

[42]  C. J. Date.  An Introduction to Database Systems, 3rd Edition , 1977 .

[43]  Jonathan B. Fry.  Data Manipulation in SPSS and SPSS-X , 1981, SSDBM.

[44]  Harry K. T. Wong,et al.  GUIDE: Graphical User Interface for Database Exploration , 1982, VLDB.

[45]  J. D. Uiiman,et al.  Principles of Database Systems , 2004, PODS 2004.

[46]  Don S. Batory,et al.  On searching transposed files , 1978, ACM Trans. Database Syst..

[47]  Michael Stonebraker,et al.  A Rules System for a Relational Data Base Management System , 1982, JCDKB.

[48]  Hideto Ikeda,et al.  Additional Facilities of a Concentional DBMS to Support Interactive Statistical Analysis , 1981, SSDBM.

[49]  Matthias Jarke,et al.  Query Optimization in Database Systems , 1984, CSUR.

[50]  John C. Klensin.  A Statistical Database Component of a Data Analysis and Modelling System: Lessons From Eight Years of User Experience , 1983, SSDBM.

[51]  Michael Stonebraker,et al.  The design and implementation of INGRES , 1976, TODS.

[52]  Roy Hammond.  Metadata in the RAPID DBMS , 1981, SSDBM.

[53]  H. Sato.  Handling summary information in a database: derivability , 1981, SIGMOD '81.