The POSTGRES next generation database management system

Subscribe (Full Service)


	Search: The ACM Digital Library The Guide

	Feedback

The POSTGRES next generation database management system

Full text

Pdf (5.74 MB)

Source

Communications of the ACM archive
Volume 34 , Issue 10 (October 1991) table of contents

Pages: 78 - 92

Year of Publication: 1991

ISSN:0001-0782

Authors

Michael Stonebraker	Univ. of California, Berkeley
Greg Kemnitz	Univ. of California, Berkeley

Publisher

ACM New York, NY, USA

Bibliometrics

Downloads (6 Weeks): 20, Downloads (12 Months): 107, Citation Count: 78

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/125223.125262 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.

	1	R. Agrawal , N. H. Gehani, ODE (Object Database and Environment): the language and the data model, Proceedings of the 1989 ACM SIGMOD international conference on Management of data, p.36-45, June 1989, Portland, Oregon, United States
	2	Dina Bitton , David J. DeWitt , Carolyn Turbyfill, Benchmarking Database Systems A Systematic Approach, Proceedings of the 9th International Conference on Very Large Data Bases, p.8-19, October 31-November 02, 1983
	3	Michael J. Carey , David J. DeWitt, A data model and query language for EXODUS, Proceedings of the 1988 ACM SIGMOD international conference on Management of data, p.413-423, June 01-03, 1988, Chicago, Illinois, United States
	4	R. G. G. Cattell , J. Skeen, Object operations benchmark, ACM Transactions on Database Systems (TODS), v.17 n.1, p.1-31, March 1992 [doi>10.1145/128765.128766]
	5	W F. Clocksin , Christopher S. Mellish, Programming in Prolog (2nd ed.), Springer-Verlag New York, Inc., New York, NY, 1984
	6	The Committee for Advanced DBMS Function Corporate, Third-generation database system manifesto, ACM SIGMOD Record, v.19 n.3, p.31-44, Sep. 1990 [doi>10.1145/101077.390001]
	7	Date, C. Referential integrity. In Proceedings, of the .Seventh Internatinal VLDB Conferencee (Cannes: France. Sept. i98 I).
	8	O. Deux et al., The Story of O2, IEEE Transactions on Knowledge and Data Engineering, v.2 n.1, p.91-108, March 1990 [doi>10.1109/69.50908]
	9	Eswaren, K, Specification, hnplementation and interactions o.f a rule subsystem in an integrated database svstem. IBM Research, San Jose, Catif. Res. Rep. RJ 1820, Aug. 1976.
	10	Forgy, C. The OPS5 user's manual. Carnegie Mellon univ Techo Rep. 1981.
	11	Kaiz, R, and Lehman, T. Storage structures for versioas .and alternatives. Computer Science Dept, University of Wisconsin,Madison. Wise. Rep, 479, july 1982.
	12	Kemnitz, G, Ed. The POSTGRES Reference Manual, Version 2.1. Electronics Research Laboratory, University of California, Berkeley. Calif. Rep M91/10. Feb. 1991,
	13	Kemoitz, G and Stonebraker, M. The POS'I'GRES tmorial. Elec:ronits Research Laboratory, Mere. M91/8:2, Feb. 1991.
	14	W. Kim , J. F. Garza , N. Ballou , D. Woelk, Architecture of the ORION Next-Generation Database System, IEEE Transactions on Knowledge and Data Engineering, v.2 n.1, p.109-124, March 1990 [doi>10.1109/69.50909]
	15	Dennis McCarthy , Umeshwar Dayal, The architecture of an active database management system, Proceedings of the 1989 ACM SIGMOD international conference on Management of data, p.215-224, June 1989, Portland, Oregon, United States
	16	Ong, L. and Goh, J. A unified framewovk for version modeling using production rules in a database system. University of California, Electronics Research Laboratory, Mem. UCB/ERL M90/33, Apr. 1990
	17	Sylvia L. Osborn , T. E. Heaven, The design of a relational database system with abstract data types for domains, ACM Transactions on Database Systems (TODS), v.11 n.3, p.357-373, Sept. 1986 [doi>10.1145/6314.6461]
	18	Joel E. Richardson , Michael J. Carey, Programming constructs for database system implementation in EXODUS, Proceedings of the 1987 ACM SIGMOD international conference on Management of data, p.208-219, May 27-29, 1987, San Francisco, California, United States
	19	Lawrence A. Rowe , Michael Stonebraker, The POSTGRES Data Model, Proceedings of the 13th International Conference on Very Large Data Bases, p.83-96, September 01-04, 1987
	20	Michael Stonebraker, Inclusion of New Types in Relational Data Base Systems, Proceedings of the Second International Conference on Data Engineering, p.262-269, February 05-07, 1986
	21	Stonebraker, M. The F'OSIGREB storage systems. In Proceeding<, ,f the !987 VLJ)B CoE/}'ren.ce (Brighton, England, Sept. I987).
	22	Michael Stonebraker, Managing persistent objects in a multi-level store, Proceedings of the 1991 ACM SIGMOD international conference on Management of data, p.2-11, May 29-31, 1991, Denver, Colorado, United States
	23	Stonebraker, M. a~M Rowe. L. The design M" POS'I:GRES. l_n Proceedings of the 1986 ACM-SIGMOD conference (Washington. D.C., June 1986),
	24	Stonebraker. M. et al. Extensibility in POSTGRES rules system. IEEE (Sept, 1987).
	25	Smnebrakcr, M. et al. The POSTGRES rules system. IEEE Truths. Softw. Eng. (july 1988).
	26	M. Stonebraker , L. A. Rowe , M. Hirohama, The Implementation of POSTGRES, IEEE Transactions on Knowledge and Data Engineering, v.2 n.1, p.125-142, March 1990 [doi>10.1109/69.50912]
	27	Michael Stonebraker , Anant Jhingran , Jeffrey Goh , Spyros Potamianos, On rules, procedure, caching and views in data base systems, Proceedings of the 1990 ACM SIGMOD international conference on Management of data, p.281-290, May 23-26, 1990, Atlantic City, New Jersey, United States
	28	Wang, Y. The PI(;ASSO shared objec: hierarchv~ MS Rep., University of (;aliforma, Berkeley, Jo_n_e 1988.
	29	Jennifer Widom , S. J. Finkelstein, Set-oriented production rules in relational database systems, Proceedings of the 1990 ACM SIGMOD international conference on Management of data, p.259-270, May 23-26, 1990, Atlantic City, New Jersey, United States
	30	K. Wilkinson , P. Lyngbæk , W. Hasan, The Iris Architecture and Implementation, IEEE Transactions on Knowledge and Data Engineering, v.2 n.1, p.63-75, March 1990 [doi>10.1109/69.50906]
	31	John Woodfill , Michael Stonebraker, An Implementation of Hypothetical Relations, Proceedings of the 9th International Conference on Very Large Data Bases, p.157-166, October 31-November 02, 1983

CITED BY 78

	Norman W. Paton , Oscar Díaz, Active database systems, ACM Computing Surveys (CSUR), v.31 n.1, p.63-103, March 1999
	Roelof van Zwol , Peter M. G. Apers, The webspace method: on the integration of database technology with multimedia retrieval, Proceedings of the ninth international conference on Information and knowledge management, p.438-445, November 06-11, 2000, McLean, Virginia, United States
	Peter J. Nürnberg , John J. Leggett , Erich R. Schneider , John L. Schnase, Hypermedia operating systems: a new paradigm for computing, Proceedings of the the seventh ACM conference on Hypertext, p.194-202, March 16-20, 1996, Bethesda, Maryland, United States
	Neil Goldman , K. Narayanaswamy, Software evolution through iterative prototyping, Proceedings of the 14th international conference on Software engineering, p.158-172, May 11-15, 1992, Melbourne, Australia
	Tzi-cker Chiueh , Ganesh Venkitachalam , Prashant Pradhan, Integrating segmentation and paging protection for safe, efficient and transparent software extensions, ACM SIGOPS Operating Systems Review, v.33 n.5, p.140-153, Dec. 1999
	George H. Collier , Laurie Miller , Eric Sigman, Cheyenne to LEIM/TMM: from research vision to product reality, Proceedings of the 1993 ACM/SIGAPP symposium on Applied computing: states of the art and practice, p.410-415, February 14-16, 1993, Indianapolis, Indiana, United States
	Ali-Reza Adl-Tabatabai , Geoff Langdale , Steven Lucco , Robert Wahbe, Efficient and language-independent mobile programs, ACM SIGPLAN Notices, v.31 n.5, p.127-136, May 1996
	John L. Schnase , John J. Leggett , David L. Hicks , Ron L. Szabo, Semantic data modeling of hypermedia associations, ACM Transactions on Information Systems (TOIS), v.11 n.1, p.27-50, Jan. 1993
	N. H. Gehani , H. V. Jagadish , O. Shmueli, Event specification in an active object-oriented database, ACM SIGMOD Record, v.21 n.2, p.81-90, June 1, 1992
	Wei Hong, Exploiting inter-operation parallelism in XPRS, ACM SIGMOD Record, v.21 n.2, p.19-28, June 1, 1992
	A. Prasad Sistla , Ouri Wolfson, Temporal conditions and integrity constraints in active database systems, ACM SIGMOD Record, v.24 n.2, p.269-280, May 1995
	Larry Press, Emerging dynabase tools, Communications of the ACM, v.37 n.3, p.11-16, March 1994
	Kalervo Järvelin , Timo Niemi, An NF2 relational interface for document retrieval, restructuring and aggregation, Proceedings of the 18th annual international ACM SIGIR conference on Research and development in information retrieval, p.102-110, July 09-13, 1995, Seattle, Washington, United States
	M. Tamer Özsu , Adriana Muñoz , Duane Szafron, An extensible query optimizer for an objectbase management system, Proceedings of the fourth international conference on Information and knowledge management, p.188-196, November 29-December 02, 1995, Baltimore, Maryland, United States
	John V. Harrison, Active rules in deductive databases, Proceedings of the second international conference on Information and knowledge management, p.174-183, November 01-05, 1993, Washington, D.C., United States
	Behrooz Seyed-Abbassi, Object oriented relational database with SQL interface, Proceedings of the 1993 ACM conference on Computer science, p.497-504, February 16-18, 1993, Indianapolis, Indiana, United States
	Arunprasad P. Marathe , Kenneth Salem, Query processing techniques for arrays, ACM SIGMOD Record, v.28 n.2, p.323-334, June 1999
	T. D. C. Little , G. Ahanger , R. J. Folz , J. F. Gibbon , F. W. Reeve , D. H. Schelleng , D. Venkatesh, A digital on-demand video service supporting content-based queries, Proceedings of the first ACM international conference on Multimedia, p.427-436, August 02-06, 1993, Anaheim, California, United States
	Peter Kochevar , Len Wanger, The Tecate data space exploration utility, Proceedings of the 1995 symposium on Interactive 3D graphics, p.157-164, April 09-12, 1995, Monterey, California, United States
	Allison Woodruff , James Landay , Michael Stonebraker, Constant density visualizations of non-uniform distributions of data, Proceedings of the 11th annual ACM symposium on User interface software and technology, p.19-28, November 01-04, 1998, San Francisco, California, United States
	Weimin Chen , Volker Turau, An optimized implementation for VML based on pattern matching and dynamic programming, Proceedings of the third international conference on Information and knowledge management, p.88-96, November 29-December 02, 1994, Gaithersburg, Maryland, United States
	Edward Grabczewski , John Cosmas , Peter Van Santen , Damian Green , Takebumi Itagaki , Fred Weimer, 3D MURALE: multimedia database system architecture, Proceedings of the 2001 conference on Virtual reality, archeology, and cultural heritage, November 28-30, 2001, Glyfada, Greece
	Malcolm Atkinson , Ronald Morrison, Orthogonally persistent object systems, The VLDB Journal — The International Journal on Very Large Data Bases, v.4 n.3, July 1995
	H. M. Gladney, Access control for large collections, ACM Transactions on Information Systems (TOIS), v.15 n.2, p.154-194, April 1997
	Hasanat M. Dewan , Salvatore J. Stolfo , Mauricio Hernández , Jae-Jun Hwang, Predictive dynamic load balancing of parallel and distributed rule and query processing, ACM SIGMOD Record, v.23 n.2, p.277-288, June 1994
	E. E. Villarreal , Don Batory, Rosetta: a generator of data language compilers, ACM SIGSOFT Software Engineering Notes, v.22 n.3, p.146-156, May 1997
	Jon Oler , Gary Lindstrom , Terence Critchlow, Migrating relational data to an ODBMS: strategics and lessons from a molecular biology experience, ACM SIGPLAN Notices, v.32 n.10, p.243-252, Oct. 1997
	Joseph M. Hellerstein, Optimization techniques for queries with expensive methods, ACM Transactions on Database Systems (TODS), v.23 n.2, p.113-157, June 1998
	Allison Woodruff , James Landay , Michael Stonebraker, Constant information density in zoomable interfaces, Proceedings of the working conference on Advanced visual interfaces, May 24-27, 1998, L'Aquila, Italy
	Samuel Madden , Michael J. Franklin , Joseph M. Hellerstein , Wei Hong, The design of an acquisitional query processor for sensor networks, Proceedings of the 2003 ACM SIGMOD international conference on Management of data, June 09-12, 2003, San Diego, California
	Roelof van Zwol , Peter M. G. Apers, The webspace method, Information modeling for internet applications, Idea Group Publishing, Hershey, PA, 2003
	J. Alfredo Sánchez , John J. Leggett , John L. Schnase, HyperActive: extending an open hypermedia architecture to support agency, ACM Transactions on Computer-Human Interaction (TOCHI), v.1 n.4, p.357-382, Dec. 1994
	David L. Hicks , John J. Leggett , Peter J. Nürnberg , John L. Schnase, A hypermedia version control framework, ACM Transactions on Information Systems (TOIS), v.16 n.2, p.127-160, April 1998
	Santanu Paul , Ataul Prakash, A Query Algebra for Program Databases, IEEE Transactions on Software Engineering, v.22 n.3, p.202-217, March 1996
	Amol Deshpande , Suman Nath , Phillip B. Gibbons , Srinivasan Seshan, Cache-and-query for wide area sensor databases, Proceedings of the 2003 ACM SIGMOD international conference on Management of data, June 09-12, 2003, San Diego, California
	John Grant , Jarek Gryz , Jack Minker , Louiqa Raschid, Logic-Based Query Optimization for Object Databases, IEEE Transactions on Knowledge and Data Engineering, v.12 n.4, p.529-547, July 2000
	Dave D. Straube , M. Tamer Özsu, Query Optimization and Execution Plan Generation in Object-Oriented Data Management Systems, IEEE Transactions on Knowledge and Data Engineering, v.7 n.2, p.210-227, April 1995
	Don Batory , Jeff Thomas, P2: A Lightweight DBMS Generator, Journal of Intelligent Information Systems, v.9 n.2, p.107-123, Sept./Oct. 1997
	Eric N. Hanson, The Design and Implementation of the Ariel Active Database Rule System, IEEE Transactions on Knowledge and Data Engineering, v.8 n.1, p.157-172, February 1996
	Alan Abrahams , David Eyers , Jean Bacon, An asynchronous rule-based approach for business process automation using obligations, Proceedings of the 2002 ACM SIGPLAN workshop on Rule-based programming, p.93-103, October 05, 2002, Pittsburgh, Pennsylvania
	Vinay Kanitkar , Alex Delis, Time Constrained Push Strategies in Client-Server Databases, Distributed and Parallel Databases, v.9 n.1, p.5-38, January 1, 2001
	Michael C. Burl , Lars Asker , Padhraic Smyth , Usama Fayyad , Pietro Perona , Larry Crumpler , Jayne Aubele, Learning to Recognize Volcanoes on Venus, Machine Learning, v.30 n.2-3, p.165-194, Feb./ March, 1998
	Shashi Shekhar , Sanjay Chawla , Siva Ravada , Andrew Fetterer , Xuan Liu , Chang-tien Lu, Spatial Databases-Accomplishments and Research Needs, IEEE Transactions on Knowledge and Data Engineering, v.11 n.1, p.45-55, January 1999
	David Botzer , Opher Etzion, Optimization of Materialization Strategies for Derived Data Elements, IEEE Transactions on Knowledge and Data Engineering, v.8 n.2, p.260-272, April 1996
	Daniel J. Abadi , Samuel Madden , Wolfgang Lindner, REED: robust, efficient filtering and event detection in sensor networks, Proceedings of the 31st international conference on Very large data bases, August 30-September 02, 2005, Trondheim, Norway
	Samuel R. Madden , Michael J. Franklin , Joseph M. Hellerstein , Wei Hong, TinyDB: an acquisitional query processing system for sensor networks, ACM Transactions on Database Systems (TODS), v.30 n.1, p.122-173, March 2005
	Arie Segev , Abhirup Chatterjee, Supporting statistical operations in extensible databases: a case study, Proceedings of the 7th international conference on Scientific and Statistical Database Management, p.54-63, September 28-30, 1994, Charlottesville, Virginia
	Joseph M. Hellerstein, Practical predicate placement, ACM SIGMOD Record, v.23 n.2, p.325-335, June 1994
	Sophie Cockcroft, A Taxonomy of Spatial Data Integrity Constraints, Geoinformatica, v.1 n.4, p.327-343, December 1997
	Thomas A. Phelps , Robert Wilensky, Toward active, extensible, networked documents: multivalent architecture and applications, Proceedings of the first ACM international conference on Digital libraries, p.100-108, March 20-23, 1996, Bethesda, Maryland, United States
	Guy M. Lohman , Bruce Lindsay , Hamid Pirahesh , K. Bernhard Schiefer, Extensions to Starburst: objects, types, functions, and rules, Communications of the ACM, v.34 n.10, p.94-109, Oct. 1991
	Ying Qiao , Kang Zhong , HongAn Wang , Xiang Li, Developing event-condition-action rules in real-time active database, Proceedings of the 2007 ACM symposium on Applied computing, March 11-15, 2007, Seoul, Korea
	Peter T. Liu , Brian Smith , Lawrence Rowe, Tcl-DP name server, Proceedings of the 3rd conference on USENIX Third Annual Tcl/Tk Workshop, p.1-1, July 06-08, 1995, Toronto, Canada
	Rubao Lee , Minghong Zhou , Huaming Liao, Request Window: an approach to improve throughput of RDBMS-based data integration system by utilizing data sharing across concurrent distributed queries, Proceedings of the 33rd international conference on Very large data bases, September 23-27, 2007, Vienna, Austria
	Sang-Won Lee , Bongki Moon, Design of flash-based DBMS: an in-page logging approach, Proceedings of the 2007 ACM SIGMOD international conference on Management of data, June 11-14, 2007, Beijing, China
	Michael Stonebraker , Paul M. Aoki , Witold Litwin , Avi Pfeffer , Adam Sah , Jeff Sidell , Carl Staelin , Andrew Yu, Mariposa: a wide-area distributed database system, The VLDB Journal — The International Journal on Very Large Data Bases, v.5 n.1, p.048-063, January 1996
	Yuh-Ming Shyy , Javier Arroyo , Stanley Y.W. Su , Herman Lam, The design and implementation of K: a high-level knowledge-base programming language of OSAM*.KBMS, The VLDB Journal — The International Journal on Very Large Data Bases, v.5 n.3, p.181-195, August 1996
	Eric N. Hanson , I.-Cheng Chen , Roxana Dastur , Kurt Engel , Vijay Ramaswamy , Wendy Tan , Chun Xu, A flexible and recoverable client/server database event notification system, The VLDB Journal — The International Journal on Very Large Data Bases, v.7 n.1, p.12-24, February 1998
	Stefan Deßloch , Theo Härder , Nelson Mattos , Bernhard Mitschang , Joachim Thomas, Advanced data processing in KRISYS: modeling concepts, implementation techniques, and client/server issues, The VLDB Journal — The International Journal on Very Large Data Bases, v.7 n.2, p.79-95, May 1998
	E. Panagos , A. Biliris, Synchronization and recovery in a client-server storage system, The VLDB Journal — The International Journal on Very Large Data Bases, v.6 n.3, p.209-223, August 1997
	Paul W. P. J. Grefen, Combining Theory and Practice in Integrity Control: A Declarative Approach to the Specification of a Transaction Modification Subsystem, Proceedings of the 19th International Conference on Very Large Data Bases, p.581-591, August 24-27, 1993
	Dennis Heimbigner, Experiences With an Object Manager for a Process-Centered Environment, Proceedings of the 18th International Conference on Very Large Data Bases, p.585-595, August 23-27, 1992
	Christine Collet , Thierry Coupaye , T. Svensen, NAOS - Efficient and Modular Reactive Capabilities in an Object-Oriented Database System, Proceedings of the 20th International Conference on Very Large Data Bases, p.132-143, September 12-15, 1994
	Narain H. Gehani , H. V. Jagadish , Oded Shmueli, Composite Event Specification in Active Databases: Model & Implementation, Proceedings of the 18th International Conference on Very Large Data Bases, p.327-338, August 23-27, 1992
	Stefano Ceri , Roberta Cochrane , Jennifer Widom, Practical Applications of Triggers and Constraints: Success and Lingering Issues (10-Year Award), Proceedings of the 26th International Conference on Very Large Data Bases, p.254-262, September 10-14, 2000
	Sunita Sarawagi , Michael Stonebraker, Reordering Query Execution in Tertiary Memory Databases, Proceedings of the 22th International Conference on Very Large Data Bases, p.156-167, September 03-06, 1996
	Sin Yeung Lee , Tok Wang Ling, Unrolling Cycles to Decide Trigger Termination, Proceedings of the 25th International Conference on Very Large Data Bases, p.483-493, September 07-10, 1999
	Opher Etzion, PARDES: a data-driven oriented active database model, ACM SIGMOD Record, v.22 n.1, p.7-14, March 1993
	Jan Chomicki , Sofie Haesevoets , Bart Kuijpers , Peter Revesz, Classes of Spatio-Temporal Objects and their Closure Properties, Annals of Mathematics and Artificial Intelligence, v.39 n.4, p.431-461, December 2003
	Mansour Zand , Val Collins , Dale Caviness, A survey of current object-oriented databases, ACM SIGMIS Database, v.26 n.1, p.14-29, Feb. 1995
	Sunita Sarawagi , Shiby Thomas , Rakesh Agrawal, Integrating Association Rule Mining with Relational Database Systems: Alternatives and Implications, Data Mining and Knowledge Discovery, v.4 n.2-3, p.89-125, July 2000
	Joseph M. Hellerstein , Ron Avnur , Vijayshankar Raman, Informix under CONTROL: Online Query Processing, Data Mining and Knowledge Discovery, v.4 n.4, p.281-314, October 2000
	Minsoo Lee , Stanley Y. W. Su , Herman Lam, A Web-Based Knowledge Network for Supporting Emerging Internet Applications, World Wide Web, v.4 n.1-2, p.121-140, 2001
	Alex Ramirez , Josep Ll. Larriba-Pey , Carlos Navarro , Mateo Valero , Josep Torrellas, Software Trace Cache for Commercial Applications, International Journal of Parallel Programming, v.30 n.5, p.373-395, October 2002
	Russell Sears , Eric Brewer, Stasis: flexible transactional storage, Proceedings of the 7th symposium on Operating systems design and implementation, November 06-08, 2006, Seattle, Washington
	Shi-Kuo Chang , Vincenzo Deufemia , Giuseppe Polese , Mario Vacca, A Normalization Framework for Multimedia Databases, IEEE Transactions on Knowledge and Data Engineering, v.19 n.12, p.1666-1679, December 2007
	Lenwood S. Heath , Allan A. Sioson, Multimodal Networks: Structure and Operations, IEEE/ACM Transactions on Computational Biology and Bioinformatics (TCBB), v.6 n.2, p.321-332, April 2009
	Lenwood S. Heath , Allan A. Sioson, Semantics of Multimodal Network Models, IEEE/ACM Transactions on Computational Biology and Bioinformatics (TCBB), v.6 n.2, p.271-280, April 2009