ACM SIGMOD Anthology ACM SIGMOD dblp.uni-trier.de

Modelling Summary Data.

Rowland R. Johnson: Modelling Summary Data. SIGMOD Conference 1981: 93-97
@inproceedings{DBLP:conf/sigmod/Johnson81,
  author    = {Rowland R. Johnson},
  editor    = {Y. Edmund Lien},
  title     = {Modelling Summary Data},
  booktitle = {Proceedings of the 1981 ACM SIGMOD International Conference on
               Management of Data, Ann Arbor, Michigan, April 29 - May 1, 1981},
  publisher = {ACM Press},
  year      = {1981},
  pages     = {93-97},
  ee        = {http://doi.acm.org/10.1145/582318.582333, db/conf/sigmod/Johnson81.html},
  crossref  = {DBLP:conf/sigmod/81},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX

Abstract

Several problems in specifying aggregate functions in relational systems are investigated. We propose a solution to these problems in the form of an extension of the relational data model. In particular we introduce the concept of summary data. The query language STRAND is presented in order to describe retrieval operations on the extended model. STRAND allows a user to formulate queries involving aggregate functions without conceptualizing the query in terms of aggregation. Two example applications, proposal tracking and socio-demographic data bases, are used to illustrate the concepts of the extended model.

Copyright © 1981 by the ACM, Inc., used by permission. Permission to make digital or hard copies is granted provided that copies are not made or distributed for profit or direct commercial advantage, and that copies show this notice on the first page or initial screen of a display along with the full citation.


ACM SIGMOD Anthology

Online Version (ACM WWW Account required): Full Text in PDF Format

CDROM Version: Load the CDROM "Volume 1 Issue 2, SIGMOD '75-'92" and ...

DVD Version: Load ACM SIGMOD Anthology DVD 1" and ... BibTeX

Printed Edition

Y. Edmund Lien (Ed.): Proceedings of the 1981 ACM SIGMOD International Conference on Management of Data, Ann Arbor, Michigan, April 29 - May 1, 1981. ACM Press 1981 BibTeX
Contents

Online Edition: ACM Digital Library


References

[Allman 76]
...
[Chamberlain 76]
...
[Chen 76]
Peter P. Chen: The Entity-Relationship Model - Toward a Unified View of Data. ACM Trans. Database Syst. 1(1): 9-36(1976) BibTeX
[Codd 80]
...
[Johnson 80]
...
[Schneiderman 80]
Ben Shneiderman, Glenn Thomas: Path Expressions for Complex Queries and Automatic Database Program Conversion. VLDB 1980: 33-44 BibTeX
[Scheuermann 79]
Peter Scheuermann, Gerd Schiffner, H. Weber: Abstraction Capabilities and Invariant Properties Modelling within the Entity-Relationship Approach. ER 1979: 121-140 BibTeX
[Shoshani 78]
...
[Smith 77a]
John Miles Smith, Diane C. P. Smith: Database Abstractions: Aggregation and Generalization. ACM Trans. Database Syst. 2(2): 105-133(1977) BibTeX
[Stonebraker 76]
Michael Stonebraker, Eugene Wong, Peter Kreps, Gerald Held: The Design and Implementation of INGRES. ACM Trans. Database Syst. 1(3): 189-222(1976) BibTeX

Referenced by

  1. Wolfgang Lehner, Thomas Ruf: A Redundancy-Based Optimization Approach for Aggregation in Multidimensional Scientific and Atatistical Databases. DASFAA 1997: 253-262
  2. Maurizio Rafanelli, Fabrizio L. Ricci: Mefisto: A Functional Model for Statistical Entities. IEEE Trans. Knowl. Data Eng. 5(4): 670-681(1993)
  3. Carla Basili, Roberto Basili, Leonardo Meo-Evoli: A Knowledge-Based Approach to Statistical Query Processing. EDBT 1992: 437-452
  4. Maurizio Rafanelli, Fabrizio L. Ricci: A Visual Interface for Browsing and Manipulating Statistical Entities. SSDBM 1990: 163-182
  5. Gultekin Özsoyoglu, Victor Matos, Z. Meral Özsoyoglu: Query Processing Techniques in the Summary-Table-by-Example Database Query Language. ACM Trans. Database Syst. 14(4): 526-573(1989)
  6. Lotfi Lakhal, Rosine Cicchetti, Serge Miranda: RTL - A Relation and Table Language for Statistical Databases. MFDBS 1989: 285-300
  7. Rosine Cicchetti, Lotfi Lakhal, Nanh Le Thanh, Serge Miranda: A Logical Summary-Data Model for Macro Statistical Databases. DASFAA 1989: 43-51
  8. Maurizio Rafanelli: Research Topics in Statistical and Scientific Database Management: the IV SSDBM. SSDBM 1988: 1-18
  9. Francesco M. Malvestuto, C. Zuffada: The Classification Problem with Semantically Heterogeneous Data. SSDBM 1988: 157-176
  10. Erik Malmborg: Design of the User-Interface for an Object-Oriented Statistical Data-Base. SSDBM 1988: 314-326
  11. Alessandro D'Atri, Fabrizio L. Ricci: Interpretation of Statistical Queries to Relational Databases. SSDBM 1988: 246-258
  12. Francesco M. Malvestuto: The Derivation Problem for Summary Data. SIGMOD Conference 1988: 82-89
  13. Ramez Elmasri, James A. Larson: A Graphical Query Facility for ER Databases. ER 1985: 236-245
  14. Chaitanya K. Baru, Stanley Y. W. Su: Performance Evaluation of the Statistical Aggregation by Caterogization in the SM3 System. SIGMOD Conference 1984: 77-89
  15. Maurizio Rafanelli, Fabrizio L. Ricci: Proposal of a Logical Model for Statistical Data Base. SSDBM 1983: 264-272
  16. Frank Olken: How Baroque Should a Statistical Database Management System Be? SSDBM 1983: 212-219
  17. Paul Chan, Susan J. Eggers, Fredric C. Gey, Harvard Holmes, Peter Kreps, John McCarthy, Deane Merrill, Frank Olken, Arie Shoshani, Harry K. T. Wong: Statistical Data Management Research at Lawrence Berkeley Laboratory. SSDBM 1983: 273-279
  18. V. A. Brown, Shamkant B. Navathe, Stanley Y. W. Su: Complex Data Types and a Data Manipulation Language for Scientific and Statistical Databases. SSDBM 1983: 188-195
  19. Harry K. T. Wong, Ivy Kuo: GUIDE: Graphical User Interface for Database Exploration. VLDB 1982: 22-32
  20. Arie Shoshani: Statistical Databases: Characteristics, Problems, and some Solutions. VLDB 1982: 208-222
  21. Paul Chan, Arie Shoshani: SUBJECT: A Directory Driven System for Organizing and Accessing Large Statistical Databases. VLDB 1981: 553-563
  22. Rowland R. Johnson: A Data Model for Integrating Statistical Interpretations. SSDBM 1981: 176-189
  23. Fredric C. Gey: Data Definition for Statistical Summary Data or Appearances Can Be Deceiving. SSDBM 1981: 3-18
BibTeX
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Sat May 16 23:39:29 2009