article

Free access

A functional model for macro-databases

Authors:

M. Rafanelli,

F. L. RicciAuthors Info & Claims

ACM SIGMOD Record, Volume 20, Issue 1

Pages 3 - 8

https://doi.org/10.1145/122050.122051

Published: 01 February 1991 Publication History

PDF eReader

Abstract

Recently there have been numerous proposals aimed at correcting the deficiency in existing database models to manipulate macro data (such as summary tables). The authors propose a new functional model, Mefisto, based on the definition of a new data structure, the “statistical entity”, and on a set of operations capable of manipulating this data structure by operating at metadata level.

References

[1]

[BrNS 83] Brown V.A., Navathe S.B., Su S.Y.W. "Complex data types and data manipulation language for statistical and scientific databases", Proceed. of the II° Intern. Workshop on Statistical Database Management, Los Altos, Ca, Sept. 1983.

Digital Library

Google Scholar

[2]

[ChSh 81] Chan P., Shoshani A. "SUBJECT: a directory driven system for organizing and accessing large statistical databases", Proceed. 7th Very Large Data Bases, Cannes, France, Sept. 1981.

Google Scholar

[3]

[Falc 89] Falcitelli G., Meo Evoli L., Nardelli E., Ricci F.L. "The Mefisto* model: an object oriented representation for statistical data management", in "Data Analysis, Learning Symbolic and Numeric Knowledge", Nova Science Publishers, 1989.

Digital Library

Google Scholar

[4]

[Ghosh 86] Ghosh S.P. "Statistical relational tables for statistical database management", IEEE Transactions on Software Engineering, vol. SE-12, no. 12, 1986.

Digital Library

Google Scholar

[5]

[Klug 82] Klug A. "Equivalence of relational algebra and relational calculus query languages having aggregate functions", Journal ACM, Vol. 29, No. 3, July 1982.

Digital Library

Google Scholar

[6]

[MeoE 90] Meo-Evoli L. "Interaction model for Man-Table Base System", Proceed. of the VII IASTED International Symposium on Applied Informatics, Innsbruck, Austria, Feb., 1990.

Google Scholar

[7]

[OzOM 87] Ozsoyoglu G., Ozsoyoglu Z.M., Matos V. "Extending Relational Algebra and Relational Calculus with Set-Valued Attributes and Aggregate Functions", ACM Transaction on Database Systems, Vol. 12, No. 4, Dec. 1987.

Digital Library

Google Scholar

[8]

[RaRi 83] Rafanelli M., Ricci F.L. "Proposal of a logical model for statistical database", Proceed. of the II° Intern. Workshop on Statistical Database Management, Los Altos, Ca, Sept. 1983.

Digital Library

Google Scholar

[9]

[RaRi 90] Rafanelli M., Ricci F.L. "A visual interface for brawsing and manipulating statistical entities", Lecture Notes in Computer Science, 420, Springer Verlag Pub., 1990.

Google Scholar

[10]

[Shos 82] Shoshani A. "Statistical databases: characteristics, problems and solutions", Proceed. 8th Very Large Data Bases, Mexico City, Mexico, Sept. 1982.

Digital Library

Google Scholar

[11]

[ShWo 85] Shoshani A., Wong H.K.T. "Statistical and scientific database issues", IEEE Transactions on Software Engineering, Vol. SE-11, No. 10, Oct. 1985.

Digital Library

Google Scholar

[12]

[Su 83] Su S.Y.W. "SAM*: a semantic association model for corporate and scientific/statistical databases" Information Sciences, Vol. 29, No. 2-3, May-June 1983.

Google Scholar

[13]

[Wong 84] Wong H.K.T. "Micro and macro statistical/ scientific database management", Proceed. 1st IEEE Intern. Conference on Data Engineering, Los Angeles, Ca, Apr. 1984.

Digital Library

Google Scholar

Cited By

View all

Nanda AGupta SVijrania M(2019)A Comprehensive Survey of OLAP: Recent Trends2019 3rd International conference on Electronics, Communication and Aerospace Technology (ICECA)10.1109/ICECA.2019.8822203(425-430)Online publication date: Jun-2019
https://doi.org/10.1109/ICECA.2019.8822203
Jaecksch BLehner W(2011)The planning OLAP modelProceedings of the 13th international conference on Data warehousing and knowledge discovery10.5555/2033616.2033619(14-25)Online publication date: 29-Aug-2011
https://dl.acm.org/doi/10.5555/2033616.2033619
Jaecksch BLehner W(2011)The Planning OLAP Model - A Multidimensional Model with Planning SupportData Warehousing and Knowledge Discovery10.1007/978-3-642-23544-3_2(14-25)Online publication date: 2011
https://doi.org/10.1007/978-3-642-23544-3_2
Show More Cited By

Index Terms

A functional model for macro-databases
1. Information systems
  1. Data management systems
    1. Database design and models

Recommendations

Functional Data Structures in R: Advanced Statistical Programming in R
Functional Data Structures as Updatable Objects

The threat of continuous data copying is one of the key problems in applicative programming. The opportunities to implement functional data structures as updatable objects, thus avoiding any form of copying, are discussed. The notion of incremental ...
XML based framework for ETL processes for relational databases
ACOS'06: Proceedings of the 5th WSEAS international conference on Applied computer science

In Data Warehousing, Extraction-Transformation-Loading (ETL) are the key tasks that are responsible for the extraction of data from several sources, their cleansing, customization and insertion into data warehouse [10]. More specifically ETL tools are ...

Comments

Information & Contributors

Information

Published In

ACM SIGMOD Record Volume 20, Issue 1

March 1991

57 pages

ISSN:0163-5808

DOI:10.1145/122050

Editor:
Won Kim
UniSQL, Inc., Austin, TX

Issue’s Table of Contents

Permission to make digital or hard copies of part or all of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for third-party components of this work must be honored. For all other uses, contact the Owner/Author.

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 February 1991

Published in SIGMOD Volume 20, Issue 1

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

14
Total Citations
View Citations
44
Total Downloads

Downloads (Last 12 months)25
Downloads (Last 6 weeks)7

Reflects downloads up to 31 Jan 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

Nanda AGupta SVijrania M(2019)A Comprehensive Survey of OLAP: Recent Trends2019 3rd International conference on Electronics, Communication and Aerospace Technology (ICECA)10.1109/ICECA.2019.8822203(425-430)Online publication date: Jun-2019
https://doi.org/10.1109/ICECA.2019.8822203
Jaecksch BLehner W(2011)The planning OLAP modelProceedings of the 13th international conference on Data warehousing and knowledge discovery10.5555/2033616.2033619(14-25)Online publication date: 29-Aug-2011
https://dl.acm.org/doi/10.5555/2033616.2033619
Jaecksch BLehner W(2011)The Planning OLAP Model - A Multidimensional Model with Planning SupportData Warehousing and Knowledge Discovery10.1007/978-3-642-23544-3_2(14-25)Online publication date: 2011
https://doi.org/10.1007/978-3-642-23544-3_2
Aggarwal SKim IMeng W(2005)Database exploration with dynamic abstractionsDatabase and Expert Systems Applications10.1007/3-540-58435-8_228(621-630)Online publication date: 3-Jun-2005
https://doi.org/10.1007/3-540-58435-8_228
Rafanelli M(2003)Operators for multidimensional aggregate dataMultidimensional databases10.5555/887433.887440(116-165)Online publication date: 1-Jan-2003
https://dl.acm.org/doi/10.5555/887433.887440
Rafanelli M(2003)PrefaceMultidimensional databases10.5555/887433.887435(.007-.027)Online publication date: 1-Jan-2003
https://dl.acm.org/doi/10.5555/887433.887435
Denk MFroeschl KGrossmann W(2002)Statistical CompositesProceedings of the 14th International Conference on Scientific and Statistical Database Management10.1109/SSDM.2002.1029723(217-226)Online publication date: 24-Jul-2002
https://dl.acm.org/doi/10.1109/SSDM.2002.1029723
Jarke MLenzerini MVassiliou YVassiliadis PJarke MLenzerini MVassiliou YVassiliadis P(2000)Multidimensional Data Models and AggregationFundamentals of Data Warehouses10.1007/978-3-662-04138-3_5(87-105)Online publication date: 2000
https://doi.org/10.1007/978-3-662-04138-3_5
Vassiliadis P(1998)Modeling Multidimensional Databases, Cubes and Cube OperationsProceedings of the 10th International Conference on Scientific and Statistical Database Management10.1109/SSDM.1998.688111(53-62)Online publication date: 1-Jul-1998
https://dl.acm.org/doi/10.1109/SSDM.1998.688111
Froeschl K(1996)A metadata approach to statistical query processingStatistics and Computing10.1007/BF001615706:1(11-29)Online publication date: Mar-1996
https://doi.org/10.1007/BF00161570
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Abstract

References

Cited By

Index Terms

Recommendations

Functional Data Structures in R: Advanced Statistical Programming in R

Functional Data Structures as Updatable Objects

XML based framework for ETL processes for relational databases

Comments

Information

Published In

Publisher

Publication History

Check for updates

Qualifiers

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

View options

PDF

eReader

Login options

Full Access

Share

Share this Publication link

Share on social media

Affiliations