厳選されたSQLとPostgreSQLに関する参考文献と図書です。
元となったPOSTGRES開発チームの白書と技術レポートが、カリフォルニア大学バークレイ校コンピュータサイエンス学部のWebサイトにあります。
SQLの特徴についての参考書です。
[bowman01] The Practical SQL Handbook. Bowman et al, 2001. Using SQL Variants. Fourth Edition. 0-201-70309-2. 2001. Addison-Wesley Professional. 製作著作 © 2001.
[date97] A Guide to the SQL Standard. Date and Darwen, 1997. A user's guide to the standard database language SQL. Fourth Edition. 0-201-96426-0. 1997. Addison-Wesley. 製作著作 © 1997 Addison-Wesley Longman, Inc.[訳注:翻訳は『標準SQLガイド』、4-7561-2047-4].
[date04] An Introduction to Database Systems. Date, 2004. Eighth Edition. 0-321-19784-4. 2003. Addison-Wesley. 製作著作 © 2004 Pearson Education, Inc..
[elma04] Fundamentals of Database Systems. Fourth Edition. 0-321-12226-7. 2003. Addison-Wesley. 製作著作 © 2004.
[melt93] Understanding the New SQL. Melton and Simon, 1993. A complete guide. 1-55860-245-3. 1993. Morgan Kaufmann. 製作著作 © 1993 Morgan Kaufmann Publishers, Inc.[訳注:改訂版の翻訳は『SQL:1999リレーショナル言語詳解』、4-8947-1531-7].
[ull88] Principles of Database and Knowledge. Base Systems. Ullman, 1988. Computer Science Press. 1988.
本節はPostgreSQL関連文書です。
[sim98] Enhancement of the ANSI SQL Implementation of PostgreSQL. Simkovics, 1998. November 29, 1998. Department of Information Systems, Vienna University of Technology. Vienna, Austria.
[yu95] The Postgres95. User Manual. Yu and Chen, 1995. Sept. 5, 1995. University of California. Berkeley, California.
[fong] The design and implementation of the POSTGRES query optimizer . University of California, Berkeley, Computer Science Department.
本節は会報や時事通信です。
[olson93] Partial indexing in POSTGRES: research project. Olson, 1993. 1993. UCB Engin T7.49.1993 O676. University of California. Berkeley, California.
[ong90] 「A Unified Framework for Version Modeling Using Production Rules in a Database System」. Ong and Goh, 1990. ERL Technical Memorandum M90/33. April, 1990. University of California. Berkeley, California.
[rowe87] 「 The POSTGRES data model 」. Rowe and Stonebraker, 1987. VLDB Conference. Sept. 1987. Brighton, England. .
[seshadri95] 「Generalized Partial Indexes (キャッシュされたバージョン) 」. Seshardri, 1995. Eleventh International Conference on Data Engineering. 6-10 March 1995. Taipeh, Taiwan. . 1995. Cat. No.95CH35724. IEEE Computer Society Press. Los Alamitos, California. 420-7.
[ston86] 「 The design of POSTGRES 」. Stonebraker and Rowe, 1986. ACM-SIGMOD Conference on Management of Data. May 1986. Washington, DC. .
[ston87a] 「The design of the POSTGRES rules system」. Stonebraker, Hanson, Hong, 1987. IEEE Conference on Data Engineering. Feb. 1987. Los Angeles, California. .
[ston87b] 「 The design of the POSTGRES storage system 」. Stonebraker, 1987. VLDB Conference. Sept. 1987. Brighton, England. .
[ston89] 「 A commentary on the POSTGRES rules system 」. Stonebraker et al, 1989. SIGMOD Record 18(3). Sept. 1989.
[ston89b] 「 The case for partial indexes 」. Stonebraker, M, 1989b. SIGMOD Record 18(4). 4-11. Dec. 1989.
[ston90a] 「 The implementation of POSTGRES 」. Stonebraker, Rowe, Hirohama, 1990. Transactions on Knowledge and Data Engineering 2(1). IEEE. March 1990.
[ston90b] 「 On Rules, Procedures, Caching and Views in Database Systems 」. Stonebraker et al, ACM, 1990. ACM-SIGMOD Conference on Management of Data. June 1990. .