バージョンごとのドキュメント一覧

参考文献

<title>Bibliography</title>

Selected references and readings for <acronym>SQL</acronym> and <productname>PostgreSQL</productname>. 厳選されたSQLPostgreSQLに関する参考文献と図書です。

Some white papers and technical reports from the original <productname>POSTGRES</productname> development team are available at the University of California, Berkeley, Computer Science Department <ulink url="https://dsf.berkeley.edu/papers/">web site</ulink>. 元となったPOSTGRES開発チームの白書と技術レポートが、カリフォルニア大学バークレイ校コンピュータサイエンス学部のWebサイトにあります。

<title><acronym>SQL</acronym> Reference Books</title>

SQL参考図書

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

[date97] A Guide to the SQL Standard [訳注:翻訳は『標準SQLガイド』、4-7561-2047-4]. A user's guide to the standard database language SQL. Fourth Edition. C. J. Date, 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, Shamkant Navathe. ISBN 0-321-12226-7. Addison-Wesley. 2003.

[melt93] Understanding the New SQL [訳注:改訂版の翻訳は『SQL:1999リレーショナル言語詳解』、4-8947-1531-7]. A complete guide. Jim Melton, Alan R. Simon. ISBN 1-55860-245-3. Morgan Kaufmann. 1993.

[ull88] Principles of Database and Knowledge-Base Systems. Classical Database 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.

<title>PostgreSQL-specific Documentation</title>

PostgreSQLに特化した文書

[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, 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.

<title>Proceedings and Articles</title>

会報ならびに記事

[ports12] Serializable Snapshot Isolation in PostgreSQL」. D. Ports, 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, 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, J. Goh. ERL Technical Memorandum M90/33. University of California. Berkeley, California. April, 1990.

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

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

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