# 參考書目

有關SQL及PostgreSQL值得閱讀的書籍及參考資料。

部份原始文件及技術報告亦可參閱University of California, Berkeley, Computer Science Department的網頁：\
<http://db.cs.berkeley.edu/papers/>

## SQL Reference Books

\[bowman01]*The PracticalSQLHandbook*.Using SQL Variants.Fourth Edition.JudithBowman,SandraEmerson, andMarcyDarnovsky.ISBN 0-201-70309-2.Addison-Wesley Professional.2001.

\[date97]*A Guide to theSQLStandard*.A user's guide to the standard database languageSQL.Fourth Edition.C. J.DateandHughDarwen.ISBN 0-201-96426-0.Addison-Wesley.1997.

\[date04]*An Introduction to Database Systems*.Eighth Edition.C. J.Date.ISBN 0-321-19784-4.Addison-Wesley.2003.

\[elma04]*Fundamentals of Database Systems*.Fourth Edition.RamezElmasriandShamkantNavathe.ISBN 0-321-12226-7.Addison-Wesley.2003.

\[melt93]*Understanding the NewSQL*.A complete guide.JimMeltonandAlan R.Simon.ISBN 1-55860-245-3.Morgan Kaufmann.1993.

\[ull88]*Principles of Database and Knowledge*.Base Systems.Jeffrey D.Ullman.Volume 1.Computer Science Press.1988.

## PostgreSQL-specific Documentation

\[sim98]*Enhancement of the ANSI SQL Implementation of PostgreSQL*.StefanSimkovics.Department of Information Systems, Vienna University of Technology.Vienna, Austria.November 29, 1998.

\[yu95]*ThePostgres95.User Manual*.A.YuandJ.Chen.University of California.Berkeley, California.Sept. 5, 1995.

\[fong][*The design and implementation of thePOSTGRESquery optimizer*](http://db.cs.berkeley.edu/papers/UCB-MS-zfong.pdf).ZelaineFong.University of California, Berkeley, Computer Science Department.

## Proceedings and Articles

\[olson93]*Partial indexing in POSTGRES: research project*.NelsOlson.UCB Engin T7.49.1993 O676.University of California.Berkeley, California.1993.

\[ong90]“A Unified Framework for Version Modeling Using Production Rules in a Database System”.L.OngandJ.Goh.*ERL Technical Memorandum M90/33*.University of California.Berkeley, California.April, 1990.

\[rowe87]“[The POSTGRES data model](http://db.cs.berkeley.edu/papers/ERL-M87-13.pdf)”.L.RoweandM.Stonebraker.VLDB Conference, Sept. 1987.

\[seshadri95]“[Generalized Partial Indexes](http://citeseer.ist.psu.edu/seshadri95generalized.html)”.P.SeshadriandA.Swami.Eleventh International Conference on Data Engineering, 6-10 March 1995.Cat. No.95CH35724.IEEE Computer Society Press.Los Alamitos, California.1995.420-7.

\[ston86]“[The design of POSTGRES](http://db.cs.berkeley.edu/papers/ERL-M85-95.pdf)”.M.StonebrakerandL.Rowe.ACM-SIGMOD Conference on Management of Data, May 1986.

\[ston87a]“The design of thePOSTGRESrules system”.M.Stonebraker,E.Hanson, andC. H.Hong.IEEE Conference on Data Engineering, Feb. 1987.

\[ston87b]“[The design of the POSTGRES storage system](http://db.cs.berkeley.edu/papers/ERL-M87-06.pdf)”.M.Stonebraker.VLDB Conference, Sept. 1987.

\[ston89]“[A commentary on the POSTGRES rules system](http://db.cs.berkeley.edu/papers/ERL-M89-82.pdf)”.M.Stonebraker,M.Hearst, andS.Potamianos.*SIGMOD Record 18(3)*.Sept. 1989.

\[ston89b]“[The case for partial indexes](http://db.cs.berkeley.edu/papers/ERL-M89-17.pdf)”.M.Stonebraker.*SIGMOD Record 18(4)*.Dec. 1989.4-11.

\[ston90a]“[The implementation of POSTGRES](http://db.cs.berkeley.edu/papers/ERL-M90-34.pdf)”.M.Stonebraker,L. A.Rowe, andM.Hirohama.*Transactions on Knowledge and Data Engineering 2(1)*.IEEE.March 1990.

\[ston90b]“[On Rules, Procedures, Caching and Views in Database Systems](http://db.cs.berkeley.edu/papers/ERL-M90-36.pdf)”.M.Stonebraker,A.Jhingran,J.Goh, andS.Potamianos.ACM-SIGMOD Conference on Management of Data, June 1990.

* <https://www.postgresql.org/docs/10/static/biblio.html>