參考書目

有關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.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”.L.RoweandM.Stonebraker.VLDB Conference, Sept. 1987.

[seshadri95]“Generalized Partial Indexes”.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”.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”.M.Stonebraker.VLDB Conference, Sept. 1987.

[ston89]“A commentary on the POSTGRES rules system”.M.Stonebraker,M.Hearst, andS.Potamianos.SIGMOD Record 18(3).Sept. 1989.

[ston89b]“The case for partial indexes”.M.Stonebraker.SIGMOD Record 18(4).Dec. 1989.4-11.

[ston90a]“The implementation of POSTGRES”.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”.M.Stonebraker,A.Jhingran,J.Goh, andS.Potamianos.ACM-SIGMOD Conference on Management of Data, June 1990.