Selected references and readings for SQL and PostgreSQL.

Some white papers and technical reports from the original POSTGRES development team are available at the University of California, Berkeley, Computer Science Department web site.

SQL Reference Books

BowmanJudith, EmersonSandra, 그리고 DarnovskyMarcy, The Practical SQL Handbook: Using SQL Variants, Fourth Edition, Addison-Wesley Professional, ISBN 0-201-70309-2, 2001.

DateC. J. 그리고 DarwenHugh, A Guide to the SQL Standard: A user's guide to the standard database language SQL, Fourth Edition, Addison-Wesley, ISBN 0-201-96426-0, 1997.

DateC. J., An Introduction to Database Systems, Eighth Edition, Addison-Wesley, ISBN 0-321-19784-4, 2003.

ElmasriRamez 그리고 NavatheShamkant, Fundamentals of Database Systems, Fourth Edition, Addison-Wesley, ISBN 0-321-12226-7, 2003.

MeltonJim 그리고 SimonAlan R., Understanding the New SQL: A complete guide, Morgan Kaufmann, ISBN 1-55860-245-3, 1993.

UllmanJeffrey D., Principles of Database and Knowledge: Base Systems, Volume 1, Computer Science Press, 1988.

PostgreSQL-specific Documentation

SimkovicsStefan, Enhancement of the ANSI SQL Implementation of PostgreSQL, Department of Information Systems, Vienna University of Technology, November 29, 1998.

Discusses SQL history and syntax, and describes the addition of INTERSECT and EXCEPT constructs into PostgreSQL. Prepared as a Master's Thesis with the support of O. Univ. Prof. Dr. Georg Gottlob and Univ. Ass. Mag. Katrin Seyr at Vienna University of Technology.

YuA. 그리고 ChenJ., The POSTGRES Group, The Postgres95 User Manual, University of California, Sept. 5, 1995.

FongZelaine, The design and implementation of the POSTGRES query optimizer , University of California, Berkeley, Computer Science Department.

Proceedings and Articles

OlsonNels, Partial indexing in POSTGRES: research project, University of California, UCB Engin T7.49.1993 O676, 1993.

OngL. 그리고 GohJ., "A Unified Framework for Version Modeling Using Production Rules in a Database System", ERL Technical Memorandum M90/33, University of California, April, 1990.

RoweL. 그리고 StonebrakerM., " The POSTGRES data model ", Proc. VLDB Conference, Sept. 1987.

SeshadriP. 그리고 SwamiA., "Generalized Partial Indexes (cached version) ", Proc. Eleventh International Conference on Data Engineering, 6-10 March 1995, IEEE Computer Society Press, Cat. No.95CH35724, 1995, 420-7.

StonebrakerM. 그리고 RoweL., " The design of POSTGRES ", Proc. ACM-SIGMOD Conference on Management of Data, May 1986.

StonebrakerM., HansonE., 그리고 HongC. H., "The design of the POSTGRES rules system", Proc. IEEE Conference on Data Engineering, Feb. 1987.

StonebrakerM., " The design of the POSTGRES storage system ", Proc. VLDB Conference, Sept. 1987.

StonebrakerM., HearstM., 그리고 PotamianosS., " A commentary on the POSTGRES rules system ", SIGMOD Record 18(3), Sept. 1989.

StonebrakerM., " The case for partial indexes ", SIGMOD Record 18(4), Dec. 1989, 4-11.

StonebrakerM., RoweL. A., 그리고 HirohamaM., " The implementation of POSTGRES ", Transactions on Knowledge and Data Engineering 2(1), IEEE, March 1990.

StonebrakerM., JhingranA., GohJ., 그리고 PotamianosS., " On Rules, Procedures, Caching and Views in Database Systems ", Proc. ACM-SIGMOD Conference on Management of Data, June 1990.