All pages
Powered by GitBook
1 of 1

Loading...

參考書目

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

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

[ston89]“”.M.Stonebraker,M.Hearst, andS.Potamianos.SIGMOD Record 18(3).Sept. 1989.

[ston89b]“”.M.Stonebraker.SIGMOD Record 18(4).Dec. 1989.4-11.

[ston90a]“”.M.Stonebraker,L. A.Rowe, andM.Hirohama.Transactions on Knowledge and Data Engineering 2(1).IEEE.March 1990.

[ston90b]“”.M.Stonebraker,A.Jhingran,J.Goh, andS.Potamianos.ACM-SIGMOD Conference on Management of Data, June 1990.

The design and implementation of thePOSTGRESquery optimizer
The POSTGRES data model
Generalized Partial Indexes
The design of POSTGRES
The design of the POSTGRES storage system
A commentary on the POSTGRES rules system
The case for partial indexes
The implementation of POSTGRES
On Rules, Procedures, Caching and Views in Database Systems
https://www.postgresql.org/docs/10/static/biblio.html