Библиография

Здесь представлены ссылки на справочные материалы и книги, посвящённые SQL и PostgreSQL.

Некоторые статьи и технические описания, написанные первой командой разработки POSTGRES, можно найти на сайте факультета компьютерных наук Калифорнийского университета в Беркли.

Справочники по языку SQL

[bowman01] The Practical SQL Handbook. Using SQL Variants. Fourth Edition. JudithBowman, SandraEmerson, MarcyDarnovsky. 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.DateHughDarwen. 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. RamezElmasriShamkantNavathe. ISBN 0-321-12226-7. Addison-Wesley. 2003.

[melt93] Understanding the New SQL. A complete guide. JimMeltonAlan 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.

Документация, посвящённая PostgreSQL

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

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

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

Заметки и статьи

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

[rowe87] «The POSTGRES data model». L.RoweM.Stonebraker. VLDB Conference, Sept. 1987.

[seshadri95] «Generalized Partial Indexes». P.SeshadriA.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.StonebrakerL.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.

close