Article

Additional facilities of a concentional DBMS to support interactive statistical analysis

Authors:

Yasuyuki KobayashiAuthors Info & Claims

SSDBM'81: Proceedings of the 1st LBL Workshop on Statistical database management

Pages 25 - 36

Published: 02 December 1981 Publication History

Abstract

This paper proposes to add some facilities to a conventional database management system (DBMS) to support interactive survey analysis of statistical data. Data dictionaries were developed, derived statistical data is treated as regular data and summary tables as the results of analysis are optionally stored. The extension of an existing DBMS enables us to retrieve the database for queries that including statistical operations, e.g., means, variances, and can survey very large data interactively. An implemented prototype system is also presented.

References

[1]

{1} ...]]

[2]

{2} ...]]

[3]

{3} ...]]

[4]

{4} ...]]

[5]

{5} ...]]

[6]

{6} ...]]

[7]

{7} Dorothy E. Denning, Peter J. Denning, Mayer D. Schwartz: The Tracker: A Threat to Statistical Database Security. ACM Trans. Database Syst. 4(1): 76-96(1979).]]

[8]

{8} ...]]

[9]

{9} ...]]

[10]

{10} ...]]

[11]

{11} Michael Hammer, Dennis McLeod: The Semantic Data Model: A Modelling Mechanism for Data Base Applications. SIGMOD Conference 1978: 26-36.]]

[12]

{12} ...]]

[13]

{13} ...]]

[14]

{14} ...]]

[15]

{15} ...]]

[16]

{16} ...]]

[17]

{17} ...]]

[18]

{18} ...]]

[19]

{19} ...]]

[20]

{20} ...]]

[21]

{21} Clesio Saraiva dos Santos, Erich J. Neuhold, Antonio L. Furtado: A Data Type Approach to the Entity-Relationship Approach. ER 1979: 103-119.]]

[22]

{22} ...]]

[23]

{23} H. Sato: Handling Summary Information in a Database: Derivability. SIGMOD Conference 1981: 98-107.]]

[24]

{24} David W. Shipman: The Functional Data Model and the Data Language DAPLEX (Abstract). SIGMOD Conference 1979.]]

[25]

{25} John Miles Smith, Diane C. P. Smith: Database Abstractions: Aggregation and Generalization. ACM Trans. Database Syst. 2(2): 105-133(1977).]]

[26]

{26} ...]]

[27]

{27} Masaaki Tsubaki, Ryosuke Hotaka: Distributed Multi-Database Environment with a Supervisory Data Dictionary Database. ER 1979: 553-574.]]

Cited By

Meo-Evoli LNardelli EPisanelli DRicci F(1993)ADAMSProceedings of the 1993 ACM/SIGAPP symposium on Applied computing: states of the art and practice10.1145/162754.167188(652-659)Online publication date: 1-Mar-1993
https://dl.acm.org/doi/10.1145/162754.167188
Rafanelli MRicci F(1993)MefistoIEEE Transactions on Knowledge and Data Engineering10.1109/69.2347785:4(670-681)Online publication date: 1-Aug-1993
https://dl.acm.org/doi/10.1109/69.234778
Özsoyoğlu GMatos VÖzsoyoğlu M(1989)Query processing techniques in the summary-table-by-example database query languageACM Transactions on Database Systems10.1145/76902.7690614:4(526-573)Online publication date: 1-Dec-1989
https://dl.acm.org/doi/10.1145/76902.76906
Show More Cited By

Index Terms

Additional facilities of a concentional DBMS to support interactive statistical analysis
1. Applied computing
  1. Physical sciences and engineering
    1. Mathematics and statistics
2. Information systems

Recommendations

A DBMS for large statistical databases
VLDB '79: Proceedings of the fifth international conference on Very Large Data Bases - Volume 5

This paper describes the approach taken at Statistics Canada to create a generalized DBMS appropriate for the management of large statistical databases. The authors describe the requirements for statistical database processing which differ from more ...
Volume testing of DBMS software: the ORACLE relational DBMS
SSDBM'81: Proceedings of the 1st LBL Workshop on Statistical database management

This paper discusses the use of the ORACLE relational database management system to solve data manipulation problems and produce frequency distributions from complex data structures typical of social science statistical data processing applications. ...
The Ubiquitous DBMS
11th International Conference on Web Information Systems Engineering --- WISE 2010 - Volume 6488

Recent widespread use of mobile technologies and advancement in computing power prompted strong needs of database systems that can be used in small devices such as sensors, cellular phones, PDA, ultra PCs, and navigators. We call database systems that ...

Comments

Information & Contributors

Information

Published In

cover image Guide Proceedings

SSDBM'81: Proceedings of the 1st LBL Workshop on Statistical database management

December 1981

402 pages

ISBN:155555222X

Editor:
Harry K. T. Wong

Publisher

Lawrence Berkeley Laboratory

Berkeley, United States

Publication History

Published: 02 December 1981

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

10
Total Citations
View Citations
0
Total Downloads

Downloads (Last 12 months)0
Downloads (Last 6 weeks)0

Reflects downloads up to 14 Jan 2025

Other Metrics

View Author Metrics

Citations

Cited By

Meo-Evoli LNardelli EPisanelli DRicci F(1993)ADAMSProceedings of the 1993 ACM/SIGAPP symposium on Applied computing: states of the art and practice10.1145/162754.167188(652-659)Online publication date: 1-Mar-1993
https://dl.acm.org/doi/10.1145/162754.167188
Rafanelli MRicci F(1993)MefistoIEEE Transactions on Knowledge and Data Engineering10.1109/69.2347785:4(670-681)Online publication date: 1-Aug-1993
https://dl.acm.org/doi/10.1109/69.234778
Özsoyoğlu GMatos VÖzsoyoğlu M(1989)Query processing techniques in the summary-table-by-example database query languageACM Transactions on Database Systems10.1145/76902.7690614:4(526-573)Online publication date: 1-Dec-1989
https://dl.acm.org/doi/10.1145/76902.76906
Chen MMcNamee L(1989)On the Data Model and Access Method of Summary Data ManagementIEEE Transactions on Knowledge and Data Engineering10.1109/69.434261:4(519-529)Online publication date: 1-Dec-1989
https://dl.acm.org/doi/10.1109/69.43426
Ozsoyoglu GOzsoyoglu ZMata F(1985)A language and a physical organization technique for summary tablesACM SIGMOD Record10.1145/971699.31889914:4(3-16)Online publication date: 1-May-1985
https://dl.acm.org/doi/10.1145/971699.318899
Ozsoyoglu GOzsoyoglu ZMata FNavathe SDale A(1985)A language and a physical organization technique for summary tablesProceedings of the 1985 ACM SIGMOD international conference on Management of data10.1145/318898.318899(3-16)Online publication date: 1-May-1985
https://dl.acm.org/doi/10.1145/318898.318899
Baru CSu S(1984)Performance evaluation of the statistical aggregation by categorization in the SM3 systemACM SIGMOD Record10.1145/971697.60227014:2(77-89)Online publication date: 1-Jun-1984
https://dl.acm.org/doi/10.1145/971697.602270
Baru CSu SSmith DYormark B(1984)Performance evaluation of the statistical aggregation by categorization in the SM3 systemProceedings of the 1984 ACM SIGMOD international conference on Management of data10.1145/602259.602270(77-89)Online publication date: 18-Jun-1984
https://dl.acm.org/doi/10.1145/602259.602270
Shoshani A(1982)Statistical DatabasesProceedings of the 8th International Conference on Very Large Data Bases10.5555/645910.673595(208-222)Online publication date: 8-Sep-1982
https://dl.acm.org/doi/10.5555/645910.673595
Bates DBoral HDeWitt DSu SSchkolnick M(1982)A framework for research in database management for statistical analysis or a primer on statistical database management problems for computer scientistsProceedings of the 1982 ACM SIGMOD international conference on Management of data10.1145/582353.582365(69-78)Online publication date: 2-Jun-1982
https://dl.acm.org/doi/10.1145/582353.582365

View Options

View options

Media

Figures

Other

Tables

View Table of Contents