OLAP and statistical databases

Subscribe (Full Service)


	Search: The ACM Digital Library The Guide

	Feedback

OLAP and statistical databases: similarities and differences

Full text

Pdf (1.66 MB)

Source

Symposium on Principles of Database Systems archive
Proceedings of the sixteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems table of contents

Tucson, Arizona, United States

Pages: 185 - 196

Year of Publication: 1997

ISBN:0-89791-910-6

Author

Arie Shoshani

Lawrence Berkeley National Lahoratory, Berkeley, California

Sponsor

SIGMOD: ACM Special Interest Group on Management of Data

Publisher

ACM New York, NY, USA

Bibliometrics

Downloads (6 Weeks): 14, Downloads (12 Months): 86, Citation Count: 29

Additional Information:

references cited by index terms collaborative colleagues

Tools and Actions:	Request Permissions Review this Article Save this Article to a Binder Display Formats: BibTeX EndNote ACM Ref

DOI Bookmark:	Use this link to bookmark this Article: http://doi.acm.org/10.1145/263661.263682 What is a DOI?

REFERENCES

Note: OCR errors may be found in this Reference List extracted from the full text article. ACM has opted to expose the complete List rather than only correct and linked references.

	AGS97	Rakesh Agrawal , Ashish Gupta , Sunita Sarawagi, Modeling Multidimensional Databases, Proceedings of the Thirteenth International Conference on Data Engineering, p.232-243, April 07-11, 1997
	ArborSoft	The Role of the Multidimensional Database in a Data Warehousing, An Arbor Software White Paper, http:/lwww.arborsoft.com/papers/rolapTOC.html.
	CS81	Chan, P., Shoshani, A., Subject: A Directory driven System for Organizing and Accessing Large Statistical Databases, VLDB 1981, pp. 553-563.
	CD+95	L. T. Chen , R. Drach , M. Keating , S. Louis , D. Rotem , A. Shoshani, Efficient organization and access of multi-dimensional datasets on tertiary storage systems, Information Systems, v.20 n.2, p.155-183, April 1995 [doi>10.1016/0306-4379(95)98559-V]
	DP96	Conference on Data Protection, organized by Eurostat, Bled, Slovenia, October, 1996.
	DS80	Dorothy E. Denning , Jan Schlörer, A fast procedure for finding a tracker in a statistical database, ACM Transactions on Database Systems (TODS), v.5 n.1, p.88-102, March 1980 [doi>10.1145/320128.320138]
	EOA81	Susan j. Eggers, Frank Olken, Arie Shoshant, A Compression Technique for Large Statistical Data- Bases, VLDB 1981, pp. 424-434.
	GB+96	Jim Gray , Adam Bosworth , Andrew Layman , Hamid Pirahesh, Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Total, Proceedings of the Twelfth International Conference on Data Engineering, p.152-159, February 26-March 01, 1996
	HUR96	Venky Harinarayan , Anand Rajaraman , Jeffrey D. Ullman, Implementing data cubes efficiently, Proceedings of the 1996 ACM SIGMOD international conference on Management of data, p.205-216, June 04-06, 1996, Montreal, Quebec, Canada
	LRT96	Wolfgang Lehner , Thomas Ruf , Michael Teschke, CROSS-DB: a feature-extended multidimensional data model for statistical and scientific databases, Proceedings of the fifth international conference on Information and knowledge management, p.253-260, November 12-16, 1996, Rockville, Maryland, United States [doi>10.1145/238355.238547]
	LS97	Hans-Joachim Lenz , Arie Shoshani, Summarizability in OLAP and Statistical Data Bases, Proceedings of the Ninth International Conference on Scientific and Statistical Database Management, p.132-143, August 11-13, 1997 [doi>10.1109/SSDM.1997.621175]
	MRS92	Leonardo Meo-Evoli , Fabrizio L. Ricci , Arie Shoshani, On the semantic completeness of macro-data operators for statistical aggregation, Proceedings of the 6th international working conference on Scientific and statistical database management, p.239-258, June 09-12, 1992, Monte Verita, Switzerland
	MicroStrategy	The Case For Relational OLAP, A White Paper Prepared by MicroStrategy, Incorporated, "http:llwww.strategy.eomldwflwp_b al.htm "
	OR95	Olken, F. and Rotem, D., "'Random Sampling from Databases -A Survey," (invited paper), Statistics & Computing, March 1995, vol.5, no.l, pages 25-42. (many more references in http://www.lbl.gov/~olken/sampling.html)
	OOM85	Gultekin Ozsoyoglu , Z. Meral Ozsoyoglu , Francisco Mata, A language and a physical organization technique for summary tables, Proceedings of the 1985 ACM SIGMOD international conference on Management of data, p.3-16, May 1985, Austin, Texas, United States
	RS90	Maurizio Rafanelli , Arie Shoshani, STORM: a statistical object representation model, Proceedings of the fifth international conference on Statistical and scientific database management, p.14-29, March 1990, Charlotte, North Carolina, United States
	RZ86	Doron Rotem , J. Leon Zhao, Extendible Arrays for Statistical Databases and OLAP Applications, Proceedings of the Eighth International Conference on Scientific and Statistical Database Management, p.108-117, June 18-20, 1996 [doi>10.1109/SSDM.1996.506053]
	RKR97	Nick Roussopoulos , Yannis Kotidis , Mema Roussopoulos, Cubetree: organization of and bulk incremental updates on the data cube, Proceedings of the 1997 ACM SIGMOD international conference on Management of data, p.89-99, May 11-15, 1997, Tucson, Arizona, United States
	SS94	Sunita Sarawagi , Michael Stonebraker, Efficient Organization of Large Multidimensional Arrays, Proceedings of the Tenth International Conference on Data Engineering, p.328-336, February 14-18, 1994
	S82	Arie Shoshani, Statistical Databases: Characteristics, Problems, and some Solutions, Proceedings of the 8th International Conference on Very Large Data Bases, p.208-222, September 08-10, 1982
	THC79	M. J. Turner, R. Hammond, P. Cotton, A DBMS for Large Statistical Databases, VLDB 1979, pp. 319-327.
	WL+85	Harry K. T. Wong, Hsiu-Fen Liu, Frank Olken, Doron Rotem, Linda Wong, Bit Transposed Files, VLDB 1985, pp. 448-457. (An expanded version appeared in Algorithmica (1986) 1, pp. 289-309.)
	ZDN97	Yihong Zhao , Prasad M. Deshpande , Jeffrey F. Naughton, An array-based algorithm for simultaneous multidimensional aggregates, Proceedings of the 1997 ACM SIGMOD international conference on Management of data, p.159-170, May 11-15, 1997, Tucson, Arizona, United States

CITED BY 29

	Nguyen Thanh Binh , A. Min Tjoa, Conceptual multidimensional data model based on object-oriented metacube, Proceedings of the 2001 ACM symposium on Applied computing, p.295-300, March 2001, Las Vegas, Nevada, United States
	Laks V. S. Lakshmanan , Fereidoon Sadri , Subbu N. Subramanian, SchemaSQL: An extension to SQL for multidatabase interoperability, ACM Transactions on Database Systems (TODS), v.26 n.4, p.476-519, December 2001
	Amin Y. Noaman , Ken Barker, A horizontal fragmentation algorithm for the fact relation in a distributed data warehouse, Proceedings of the eighth international conference on Information and knowledge management, p.154-161, November 02-06, 1999, Kansas City, Missouri, United States
	Stéphane Grumbach , Maurizio Rafanelli , Leonardo Tininini, Querying aggregate data, Proceedings of the eighteenth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, p.174-184, May 31-June 03, 1999, Philadelphia, Pennsylvania, United States
	Dennis Pedersen , Karsten Riis , Torben Bach Pedersen, A powerful and SQL-compatible data model and query language for OLAP, Australian Computer Science Communications, v.24 n.2, p.121-130, January-February 2002
	Torsten Priebe , Günther Pernul, Towards OLAP security design — survey and research issues, Proceedings of the 3rd ACM international workshop on Data warehousing and OLAP, p.33-40, November 06-11, 2000, McLean, Virginia, United States
	Elaheh Pourabbas , Maurizio Rafanelli, Characterization of hierarchies and some operators in OLAP environment, Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP, p.54-59, November 02-06, 1999, Kansas City, Missouri, United States
	Stéphane Grumbach , Leonardo Tininini, On the content of materialized aggregate views, Proceedings of the nineteenth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, p.47-57, May 15-18, 2000, Dallas, Texas, United States
	Rónán Páircéir , Sally McClean , Bryan Scotney, Discovery of multi-level rules and exceptions from a distributed database, Proceedings of the sixth ACM SIGKDD international conference on Knowledge discovery and data mining, p.523-532, August 20-23, 2000, Boston, Massachusetts, United States
	Curtis E. Dyreson , Torben Bach Pedersen , Christian S. Jensen, Incomplete information in multidimensional databases, Multidimensional databases: problems and solutions, Idea Group Publishing, Hershey, PA, 2003
	Elaheh Pourabbas, Cooperation with geographic databases, Multidimensional databases: problems and solutions, Idea Group Publishing, Hershey, PA, 2003
	Arie Shoshani, Multidimensionality in statistical, OLAP, and scientific databases, Multidimensional databases: problems and solutions, Idea Group Publishing, Hershey, PA, 2003
	Maurizio Rafanelli, Operators for multidimensional aggregate data, Multidimensional databases: problems and solutions, Idea Group Publishing, Hershey, PA, 2003
	Stéphane Grumbach , Leonardo Tininini, On the content of materialized aggregate views, Journal of Computer and System Sciences, v.66 n.1, p.133-168, 01 February 2003
	H. Papageorgiou , Fragkiskos Pentaris , Eirini Theodorou , Maria Vardaki , Michalis Petrakos, A Statistical Metadata Model for Simultaneous Manipulation of both Data and Metadata, Journal of Intelligent Information Systems, v.17 n.2-3, p.169-192, December 2001
	Riccardo Torlone, Conceptual multidimensional models, Multidimensional databases: problems and solutions, Idea Group Publishing, Hershey, PA, 2003
	John Horner , Il-Yeol Song , Peter P. Chen, An analysis of additivity in OLAP systems, Proceedings of the 7th ACM international workshop on Data warehousing and OLAP, November 12-13, 2004, Washington, DC, USA
	Maurizio Rafanelli, Basic notions, Multidimensional databases: problems and solutions, Idea Group Publishing, Hershey, PA, 2003
	Doug Burdick , Prasad M. Deshpande , T. S. Jayram , Raghu Ramakrishnan , Shivakumar Vaithyanathan, OLAP over uncertain and imprecise data, Proceedings of the 31st international conference on Very large data bases, August 30-September 02, 2005, Trondheim, Norway
	António Abelha , José Machado , Victor Alves , José Neves, Health data management in the medical arena, Proceedings of the 4th WSEAS International Conference on Applied Informatics and Communications, p.1-6, December 17-19, 2004, Tenerife, Canary Islands, Spain
	Reynold Cheng , Dmitri V. Kalashnikov , Sunil Prabhakar, Evaluation of probabilistic queries over imprecise data in constantly-evolving environments, Information Systems, v.32 n.1, p.104-130, March, 2007
	Elaheh Pourabbas , Arie Shoshani, Efficient estimation of joint queries from multiple OLAP databases, ACM Transactions on Database Systems (TODS), v.32 n.1, p.2-es, March 2007
	David Maier , Mary Edie Meredith , Leonard Shapiro, Selected Research Issues in Decision Support Databases, Journal of Intelligent Information Systems, v.11 n.2, p.169-191, Sept./Oct. 1998
	Doug Burdick , Prasad M. Deshpande , T. S. Jayram , Raghu Ramakrishnan , Shivakumar Vaithyanathan, OLAP over uncertain and imprecise data, The VLDB Journal — The International Journal on Very Large Data Bases, v.16 n.1, p.123-144, January 2007
	Peter Baumann , Paula Furtado , Roland Ritsch , Norbert Widmann, Geo/Environmental and Medical Data Management in the RasDaMan System, Proceedings of the 23rd International Conference on Very Large Data Bases, p.548-552, August 25-29, 1997
	Francesco M. Malvestuto , Mauro Mezzini , Marina Moscarini, An analytical approach to the inference of summary data of additive type, Theoretical Computer Science, v.385 n.1-3, p.264-285, October, 2007
	E. J. Otoo , Doron Rotem , Sridhar Seshadri, Optimal chunking of large multidimensional arrays for data warehousing, Proceedings of the ACM tenth international workshop on Data warehousing and OLAP, November 09-09, 2007, Lisbon, Portugal
	Pierpaolo Vittorini , Monica Michetti , Ferdinando di Orio, A SOA statistical engine for biomedical data, Computer Methods and Programs in Biomedicine, v.92 n.1, p.144-153, October, 2008
	Alfredo Cuzzocrea , Filippo Furfaro , Domenico Saccà, Enabling OLAP in mobile environments via intelligent data cube compression techniques, Journal of Intelligent Information Systems, v.33 n.2, p.95-143, October 2009