參考書目

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

[bowman01]The Practical SQL Handbook.Using SQL Variants. Fourth Edition. Judith Bowman, Sandra Emerson, and Marcy Darnovsky. ISBN 0-201-70309-2. Addison-Wesley Professional. 2001.

[date97]A Guide to the SQL Standard.A user's guide to the standard database language SQL. Fourth Edition. C. J. Date and Hugh Darwen. 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. Ramez Elmasri and Shamkant Navathe. ISBN 0-321-12226-7. Addison-Wesley. 2003.

[melt93]Understanding the New SQL.A complete guide. Jim Melton and Alan 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.

[sqltr-19075-6]SQL Technical Report.Part 6: SQL support for JavaScript Object Notation (JSON). First Edition. 2017.

PostgreSQL-specific Documentation

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

[yu95]The Postgres95. User Manual.A. Yu and J. Chen. University of California. Berkeley, California. Sept. 5, 1995.

[fong]The design and implementation of the POSTGRES query optimizer.Zelaine Fong. University of California, Berkeley, Computer Science Department.

Proceedings and Articles

[ports12] “Serializable Snapshot Isolation in PostgreSQL”. D. Ports and K. Grittner. VLDB Conference, August 2012.

[berenson95] “A Critique of ANSI SQL Isolation Levels”. H. Berenson, P. Bernstein, J. Gray, J. Melton, E. O'Neil, and P. O'Neil. ACM-SIGMOD Conference on Management of Data, June 1995.

[olson93]Partial indexing in POSTGRES: research project.Nels Olson. 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. Ong and J. Goh. ERL Technical Memorandum M90/33. University of California. Berkeley, California. April, 1990.

[rowe87] “The POSTGRES data model”. L. Rowe and M. Stonebraker. VLDB Conference, Sept. 1987.

[seshadri95] “Generalized Partial Indexes”. P. Seshadri and A. 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. Stonebraker and L. Rowe. ACM-SIGMOD Conference on Management of Data, May 1986.

[ston87a] “The design of the POSTGRES rules system”. M. Stonebraker, E. Hanson, and C. 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, and S. 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, and M. 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, and S. Potamianos. ACM-SIGMOD Conference on Management of Data, June 1990.

PreviousO. Obsolete or Renamed Features

Was this helpful?

hashtagSQL Reference Books

hashtag[bowman01]The Practical SQL Handbook.Using SQL Variants. Fourth Edition. Judith Bowman, Sandra Emerson, and Marcy Darnovsky. ISBN 0-201-70309-2. Addison-Wesley Professional. 2001.

hashtag[date97]A Guide to the SQL Standard.A user's guide to the standard database language SQL. Fourth Edition. C. J. Date and Hugh Darwen. ISBN 0-201-96426-0. Addison-Wesley. 1997.

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

hashtag[elma04]Fundamentals of Database Systems.Fourth Edition. Ramez Elmasri and Shamkant Navathe. ISBN 0-321-12226-7. Addison-Wesley. 2003.

hashtag[melt93]Understanding the New SQL.A complete guide. Jim Melton and Alan R. Simon. ISBN 1-55860-245-3. Morgan Kaufmann. 1993.

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

hashtag[sqltr-19075-6]SQL Technical Reportarrow-up-right.Part 6: SQL support for JavaScript Object Notation (JSON). First Edition. 2017.

hashtagPostgreSQL-specific Documentation

hashtag[sim98]Enhancement of the ANSI SQL Implementation of PostgreSQL.Stefan Simkovics. Department of Information Systems, Vienna University of Technology. Vienna, Austria. November 29, 1998.

hashtag[yu95]The Postgres95. User Manual.A. Yu and J. Chen. University of California. Berkeley, California. Sept. 5, 1995.

hashtag[fong]The design and implementation of the POSTGRES query optimizerarrow-up-right.Zelaine Fong. University of California, Berkeley, Computer Science Department.

hashtagProceedings and Articles

hashtag[ports12] “Serializable Snapshot Isolation in PostgreSQLarrow-up-right”. D. Ports and K. Grittner. VLDB Conference, August 2012.

hashtag[berenson95] “A Critique of ANSI SQL Isolation Levelsarrow-up-right”. H. Berenson, P. Bernstein, J. Gray, J. Melton, E. O'Neil, and P. O'Neil. ACM-SIGMOD Conference on Management of Data, June 1995.

hashtag[olson93]Partial indexing in POSTGRES: research project.Nels Olson. UCB Engin T7.49.1993 O676. University of California. Berkeley, California. 1993.

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

hashtag[rowe87] “The POSTGRES data modelarrow-up-right”. L. Rowe and M. Stonebraker. VLDB Conference, Sept. 1987.

hashtag[seshadri95] “Generalized Partial Indexesarrow-up-right”. P. Seshadri and A. Swami. Eleventh International Conference on Data Engineering, 6-10 March 1995. Cat. No.95CH35724. IEEE Computer Society Press. Los Alamitos, California. 1995. 420-7.

hashtag[ston86] “The design of POSTGRESarrow-up-right”. M. Stonebraker and L. Rowe. ACM-SIGMOD Conference on Management of Data, May 1986.

hashtag[ston87a] “The design of the POSTGRES rules system”. M. Stonebraker, E. Hanson, and C. H. Hong. IEEE Conference on Data Engineering, Feb. 1987.

hashtag[ston87b] “The design of the POSTGRES storage systemarrow-up-right”. M. Stonebraker. VLDB Conference, Sept. 1987.

hashtag[ston89] “A commentary on the POSTGRES rules systemarrow-up-right”. M. Stonebraker, M. Hearst, and S. Potamianos. SIGMOD Record 18(3). Sept. 1989.

hashtag[ston89b] “The case for partial indexesarrow-up-right”. M. Stonebraker. SIGMOD Record 18(4). Dec. 1989. 4-11.

hashtag[ston90a] “The implementation of POSTGRESarrow-up-right”. M. Stonebraker, L. A. Rowe, and M. Hirohama. Transactions on Knowledge and Data Engineering 2(1). IEEE. March 1990.

hashtag[ston90b] “On Rules, Procedures, Caching and Views in Database Systemsarrow-up-right”. M. Stonebraker, A. Jhingran, J. Goh, and S. Potamianos. ACM-SIGMOD Conference on Management of Data, June 1990.