Правильная ссылка на эту страницу
http://az-design.ru/Support/DataBase/SQL/CelkoJ/01hapl.shtml

ПРИЛОЖЕНИЕ

Книги для чтения и полезные ресурсы

Общие ссылки
       Adams, Douglas. 1979. Hitchhiker's Guide to the Galaxy. New York: Harmony Books. ISBN 0-517-54209-9.
       Babbage, Charles. Всю информацию можно получить в Институте Chalks Babbage Institute, университет Миннесоты.

Логика
       Boole, George. 1854, 1951. An Investigation of the Laws of Thought, on Which are Founded the Mathematical Theories of Logic and Probabilities. New York: Macmillan and Co., 1854. New York: Dover, 1951. Вы можете получить репринт оригинального издания 1854 г. (Dover Books, 1951). ISBN 0-486-60028-9.
       Bole, Leonard, and Piotr Borowik. 1993. Many-Valued Logics. New York: Spnnger-Verlag. ISBN 0-387-55926-4. Целая глава в этой книге посвящена трехзначной логике.
       Celko, Joe. 1992b. "SQL Explorer: Voting Systems." DBMS (November).

Математические методы
       Gardner, Martin. 1983. Wheels, Life, and Other Mathematical Amusements. New York: W. H. Freeman. ISBN 0-716-71589-9.
       Huff, Darrell. 1954. How to Lie with Statistics. New York: Norton.
       Melzak, Z. A. 1933. Bypasses: A Simple Approach to Complexity. New York: Wiley-InterScience. ISBN 0-471-86854-Х.
       Mrdalj, Stevan, Branislav Vujovic, and Vladanjovanovic. 1996. "SQL Matrix Processing." Database Programming & Design (August).

Случайные числа
       Bays, Carter, and W.E.Sharp. 1992. "Improved Random Numbers for Your Personal Computer or Workstation." Geobyte 7(2):25.
       Carta, David G. 1990. "Two Fast Implementations of the 'Minimal Standard' Random Number Generator." Communications of the ACM 33(1):87.
       Chambers, W.G., and Z.D. Dai. 1991. "Simple But Effective Modification to a Multiplicative Congruential Random Number Generator." IEEE Proceedings: Computers and Digital Technology 138(3):121.
       Chassing, P. 1989. "An Optimal Random Number Generator Zp." Statistics & Probability Letters 7(4):307.
       Elkins, T.A. 1989. "A Highly Random Number Generator." Computer Language 6(12):59.
       Hulquist, Paul F. 1991. "A Good Random Number Generator for Microcomputers." Simulation 57(4):258.
       Kao, Chiang. 1989. "A Random Number Generator for Microcomputers." OR' The Journal of the Operation Research Society 40(7):687.
       Knuth, Donald. 1981. Art of Computer Programming, Vol. 2: Seminumeral Algorithms. 2d ed. Reading, MA: Addison-Wesley, page 29.
       Komo.John J. 1991. "Decimal Pseudo-Random Number Generator." Simulation 57(4)228.
       Lancaster, Don. 1977. CMOS Cookbook. Indianapolis, IN: Sams Publishing, page 318.
       Leva, Joseph L. 1992a. "A Fast Normal Random Number Generator." ACM Transactions on Mathematical Software 18 (4):449.
       —. 1992b. "Algorithm 712: A Normal Random Number Generator." ACM Transactions on Mathematical Software 18(4) :454.
       Macomber, James H., and Charles S. White. 1990. "An N-Dimensional Uniform Random Number Generator Suitable for IBM-Compatible Microcomputers." Interfaces 20(3)A9.
       Maier, W.L. 1991. "A Fast Pseudo Random Number Generator." Dr. Dobb's Journal 17(5):152.
       Marsaglia, G., B. Narasimhan, and A. Zaman. 1990. "A Random Number Generator for PCs." Computer Physics Communications (60):345-349.
       Marsaglia, G., and A. Zaman. 1990. "Toward a Universal Random Number Generator." Statistics & Probability Letters (8):35-39.
       Morton, Mike. 1985. "A Digital Dissolve for Bit-Mapped Graphics Screens." Dr. Dobb'sJournal (November) :48.
       Press, William H., Brian P. Flannery, and William T. Vetterling. 1989. Numerical Recipes in Pascal: The Art of Scientific Computing. Cambridge, UK: Cambridge University Press, page 233.
       Sezgin, Fatin. 1990. "On a Fast and Portable Uniform Quasi- Random Number Generator." Simulation Digest 21(2):30.

Масштабы и меры
       Crocker, Linda, and James Algina. 1986. Introduction to Classical and Modern Test Theory. Austin, TX: Holt, Rinehart 8c Winston. ISBN 0-030-61634-4.

Отсутствующие значения
       Codd, E. F. 1975. "Understanding Relations." FDTi-.ЪЛ.
       Grahne, G. 1989. "Horn Tables — An Efficient Tool for Handling Incomplete Information in Databases." ACM SIGACT/SIGMOD/SIGART Symposium on Principles of Database Systems:75-82.
       Grant, J. 1977. "Null Values in a Relational Database." Information Processing Letters 6(5):156-157.
       —. 1979. "Partial Values in a Tabular Database Model." Information Processing Letters 9(2):97-99.
       Honeyman. 1980. "Functional Dependencies and the Universal Instance Property in the Relational Model of Database Systems." (Ph.D dissertation, Princeton University).
       Lien. 1979. "Multivalued Dependencies with Null Values in Relational Databases." Proceedings of the Fifth International Conference on Very Large Databases. New York: ACM; Piscataway, NJ: IEEE.
       Lipski, W. 1981."On Databases with Incomplete Information." Journal of the ACM 28(l):41-70.
       — 1981. "On Semantic. Issues Connected with Incomplete Information." ACM Transactions on Database Systems (September):262-296.
       McGoveran, David. 1993. "Nothing from Nothing Part I (or, What's Logic Got to Do with It?)." Database Programming & Design 6(12):32. A four-part series on missing values that argues against the SQL style NULL in favor of indicators.
       — 1994a. "Nothing from Nothing Part II: Classical Logic: Nothing Compares 2 U." Database Programming & Design 7(1) :54.
       —. 1994b. "Nothing from Nothing Part III: Can't Lose What You Never Had." Database Programming & Design 7(2) :42.
       —. 1994c. "Nothing from Nothing Part IV: It's in the Way That You Use It." Database Programming &f Design 7 (3): 54.
       Rozenshtein, David. 1981. "Implementing Null Values in Relations." (unpublished, May).
       —. 1995. Optimizing Transact-SQL: Advanced Programming Techniques. Fremont, CA.SQL Forum Press. ISBN 0-964-98120-3.
       SPARC Study Group on Database Management Systems. 1975. "Interim Report 75-02-08 to the ANSI X3." FDT-Bulletin ACM SIGMOD 7(2).
       Vassiliou, Y. 1979. "Null Values in Database Management — A Denotational Semantics Approach." ACM SIGMOD Conference Proceedings: 162-169.
       —. 1980. "Functional Dependencies and Incomplete Information." Proceedings of the Sixth International Conference on Very Large Databases. New York: ACM; Piscataway, NJ: IEEE.
       Zaniolo, C. 1984. "Database Relations with Null Values." Journal of Computer and System Sciences 28(1):142-166.

Теория графов
       Eve, Shimon. 1979. Graph Algorithms. New York: Computer Science Press. ISBN 0-914-89421-8.
       Fulkerson, D. R., ed. 1975. Studies in Graph Theory, Vols. 1 & 2. Providence, RI: American Mathematical Association. ISBN 0-883- 58111- 3 and ISBN0-883-58112-3.
       Harary, Frank. 1972. Graph Theory. Reading, MA: Addison-Wesley ISBN 0-201-02787-9.
       McHugh, James A. 1990. Algorithmic Graph Theory. Englewood Cliffs, NJ: Prentice Hall. ISBN 0-130-23615-2.
       Ore, Oystein (revised by Robin J. Wilson). 1990. Graphs and Their Uses. Providence, RI: American Mathematical Association. ISBN 0-883-58635-2.

Вводные книги по SQL
       Atzeni, Paolo, and Valeria De Antonellis. 1993. Relational Database Theory. Redwood City CA: Benjamin/Cummings. ISBN 0-805-30261-1.
       Codd, E. F. 1990. The Relational Model for Database Management: Version 2. Reading, MA: Addison-Wesley.
       Date, C.J. 1983. Database, A Primer. Reading, MA: Addison-Wesley. ISBN 0-201-11358-9.
       —. 1995. An Introduction to Database Systems, Vols. 1 & 2. 6th ed. Reading, MA: Addison-Wesley. ISBN 0-201-51381-1 and ISBN 0-201-14474-3.
       Groff, James R., and Paul N. Weinberg. 1994. LAN Times Guide to SQL. New York: McGraw-Hill. ISBN 0-078-82026-X.
       Gruber, Martin. 1990. Understanding SQL. Alameda, CA: Sybex. ISBN 0-895-88644-8.
       Lorie, Raymond A., and Jean-Jacques Daudenarde. 1991. SQL audits Applications. Englewood Cliffs, NJ: Prentice Hall. ISBN 0-138- 37956-4.
       Lusardi, Frank. 1988. The Database Expert's Guide to SQL. New York: McGraw-Hill. ISBN 0-070-39002-9.
       Pascal, Fabian. 1989. SQL and Relational Basics. New York: M&T Books.
       — 1993. Understanding Relational Databases. New York: M&T Books. ISBN 0-471-58538-6.
       Shasha, Dennis E. 1992. Database Tuning: A Principled Approach. Englewood Cliffs, NJ: Prentice Hall. ISBN 0-132-05246-6.
       Stonebraker, Michael. 1998. Readings in Database Systems. 3d ed. San Francisco: Morgan Kaufmann. ISBN 1-55860-523-1.
       Trimble, Harvey, and David Chappel. 1989. A Visual Introduction to SQL. New York: John Wiley. ISBN 0-471-61684-2.
       van der Lans, Rick F. 1989. The SQL Standard: A Complete Reference Guide. Englewood Cliffs, NJ: Prentice Hall International. Schoonhaven Academic Service. ISBN 0-138-40059-8.
       Wellesley Software Group. 1991. Learning SQL. Englewood Cliffs, NJ: Prentice Hall. ISBN 0-135-28704-9.
       —. 1992. Learning Advanced SQL. Englewood Cliffs, NJ: Prentice Hall. ISBN 0-135-28712-X.

Оптимизация запросов
       Gulutzan, Peter, and Trudy Pelzer. 1994. Optimizing SQL: Embedded SQL in C. Lawrence, KS: R&D Publications. ISBN 0-131-00215-5.
       Shasha, Dennis E. 1992. Database Tuning: a Principled Approach. Englewood Cliffs, NJ: Prentice Hall. ISBN 0-132-05246-6.

Типы данных времени и проблема 2000 года
       ANSI X3. 1985, 1991. "Representation for Calendar Date and Ordinal Date for Information Interchange." 30-1985 (R-1991). New York: American National Standards Institute. Эта публикация занимает две страницы и стоит $14 плюс $4 за доставку.
       —. 1994. "Information Systems-Representations of Universal Time, Local Time Differentials, and United States Time Zone References for Information Interchange." 51-1994. New York: American National Standards Institute. Эта публикация стоит $15 и $4 за доставку.
       Arnold, Robert S. 1995a. "Millennium Now: Solutions for Century Data Change Impact." Application Development Trends (January).
       —. 1995b. "Resolving Year 2000 Problems in Legacy Software." Presentation at Software Quality Week, June, San Francisco.
       Associated Press. 1995. "Troubled Time" (May 25).
       Celko.Joe. 1981. "Father Time Software Secrets Allows Updating of Dates." Information Systems News (February).
       Cini, Al. 1995. "System Bug of the Apocalypse." Internetwork (January).
       Cohn, Michael B. "No Need to Fear the Year 2000." ComputerWorld.
       Fine, Doug, 1995. "Companies Brace for Millennium." Infoworld (April 10).
       Furman, Jeff, Albert Marotta, and Cliff Candiotti. 1995. "Party When It's 1999." Software Magazine (April).
       Hayes, Brian. 1995. 'Waiting for 01-01-00." American Scientist 83 (January-February). Hitchens, Randall L. 1991. "Viewpoint." ComputerWorld (January).
       ISO. 1988. "Data Elements and Interchange Formats — Information Interchange — Representation of Dates and Times." ISO 8601:1988. New York: American National Standards Institute. Цена $48 плюс $5 за доставку.
       Ross, Noah. 1995. "The End of the Century is Nearer than You Think." Application Development Trends (April).
       Rubin, Howard, and Jim Woodward, [n.d.] "Millennium: A Billion Dollar Software Crisis." Videotape. The Computer Channel Inc.
       Sullivan, R. Lee. 1995. "Ghosts in the Machines." Forbes (June 19).
       Tantzen, Robert G. 1980. "Algorithm 199: Conversion between Calendar Date and Julian Day Number." Collected Algorithms from the ACM. New York: Association for Computing Machinery.
       Xenakisjohn. 1995. "The Millenium Bug: The Fin De Siecle Computer Virus." CFOMagazine (July).

Книги
       Murray, Jerome Т., and Marilyn J. Murray. 1984. Computers in Crisis: How to Avert the Coming Worldwide Computer Systems Collapse. New York: Petrocelli Books. ISBN 0-894-33223-6. A solution, with code, for the Year 2000 problem.
       Zerubavel, Eviatar. 1985. The Seven Day Circle! New York: The Free Press. ISBN 0-029-34680-0. A history of the week in different calendar systems.

Информационные бюллетени
       Tick, Tick, Tick Newsletter. Box #020538, Brooklyn, NY 11202.

Приемы программирования на SQL
       Celkojoe. 1992a. "Implementing T-Joins in SQL Queries." DBMS (March).
       —. 1993. "Views: More than Meets the Eye." Database Pyogramming & Design (September). Citing Nelson Mattos, from an ANSI X3H2 paper.
       CelkoJoe, and CJ. Date. 1993. "Access Path: Lauds and Lectures, Kudos and Critiques." Database Programming & Design (September) :9 (letter to the editor).

Классические труды
       Codd, E. F. 1970. "A Relational Model of Data for Large Shared Data Banks." Communications of the ACM 13(6):377-87. New York: Association for Computing Machinery.
       Comer, D. 1978. "The Difficulty of Optimum Index Selection." ACM Transactions on Database Systems 3(4):440-5.
       Damerau, F.J. 1964. "A Technique for Computer Detection of Correction of Spelling Errors." Communications of the ACM 7(3).
       Date, С J. 1992a. "According to Date: Shedding Some Light." Database Programming & Design (February): 15-7.
       Goodman, Nathan. 1990. "VIEW Update is Practical." InfoDB 5(2).
       Information Systems Week (ISW). 1987. "Code Overload Plagues NYC Welfare System." Information Systems Week (December).
       Limeback, Rudy [n.d.] "SQL Workshop Challenge." Explain (18). Undated publication; no. 18 issued 1991-1993.
       Lorie, Raymond A., and Jean-Jacques Daudenarde. 1991. SQL and Its Applications. Englewood Cliffs, NJ: Prentice Hall.
       Martinis, Miljenko. 1992. DBMS (May) (letters column).
       Melton, Jim, and Alan R. Simon. 1993. Understanding the New SQL: A Complete Guide. San Francisco: Morgan Kaufmann. ISBN 1-55860-245-3.
       Murchison, Rory. [n.d.] "SQL Workshop Challenge." Explain (16). Undated publication; no. 16 issued 1991-1993.
       Paitetsky-Shapiro, G. 1983. "The Optimal Selection of Secondary Indexes in NP-Complete." SIGMODRecord 13(2):72-75.
       Palmer, Roger. 1994. The Bar Code Book. Peterborough, NH: Helmer's Publishing. ISBN 0-911-261-09-5.
       Philips, Lawrence. 1990. "Hanging on the Metaphone. (A Phonetic Text-Retrieval Algorithm Better than Soundex)." Computer Language 7(12):38.
       Rozenshtein, David, Anatoly Abramovich, and Eugene Birger. 1993. "Loop-Free SQL Solutions for Finding Continuous Regions." SQL Forum 2(6).
       Smithwick, Terry. 1991. Pascal version of Lawrence Philips' Metaphone. CompuServe. CLMFORUM. Originally published by Lawrence Philips. 1990. "Hanging on the Metaphone. (A Phonetic Text-Retrieval Algorithm Better than Soundex)." Computer Language 7(12):38.
       SQL Forum. 1993, 1994. SQL Forum. See articles by Anatoly Abramovich, Yelena Alexandrova, and Eugene Birger (July/August 1993, March/April 1994).
       Stevens, S. S. 1957. "On the Psychophysical Law." Psychological Review 64:153-81.
       Tillquist, John, and Feng-Yang Kuo. 1989. "An Approach to the Recursive Retrieval Problem in the Relational Database." Communications Of the ACM 32(2):239.
       van der Lans, Rick F. 1991. "SQL Portability." The Relational Journal 2(6).
       Verhoeff, J. 1969. "Error Detecting Decimal Codes." Mathematical Centre Tract #29. Amsterdam: The Mathematical Centre.
       Vicik, Rick. 1993. "Advanced Transact SQL." SQL Forum (July/August).
       Wankowskijim. [n.d.] "SQL Workshop Solutions." Explain (17). Undated publication; no.17 issued 1991-1993.
       Yozallinas.J. R. 1981. Tech Specialist (May) (letters column).

Обновляемые представления
       Codd, E.F. 1990. "RV-6 VIEW Updating." The Relational Model for Database Management: Version 2. Reading, MA: Addison-Wesley. ISBN 0-201-14192-2.
       Date, C.J. 1986. "Updating VIEWs." Relational Database: Selected Writings. Reading, MA: Addison-Wesley. ISBN 0-201-14196-5.
       Date, C.J., and Hugh Darwen. 1992. "Role of Functional Dependencies in Query Decomposition." Relational Database: Writings, 1989-1991. Reading, MA: Addison-Wesley. ISBN 0-201-54303-6.
       Goodman, Nathan. 1990. "VIEW Update is Practical." InfoDB 5(2).
       Umeshar, Dayal, and P. A. Bernstein. 1982. "On the Correct Translation of Update Operations on Relational VIEWs." ACM Transactions on Database Systems 7(3).

Теория, нормализация и сложные проблемы работы с БД
       Bernstein, P. А. 1976. "Synthesizing Third Normal Form Relations from Functional Dependencies." ACM Transactions on Database Systems l(4):277-298.
       Codd, E. F. 1990. The Relational Model for Database Management: Version 2. Reading, MA: Addison-Wesley.
       Date, C.J. 1986. Relational Database: Selected Writings. Reading, MA: Addison-Wesley ISBN 0-201-14196-5.
       — 1990. Relational Database: Writings, 1985-1989. Reading, MA: Addison-Wesley. ISBN 0-201-50881-8.
       — 1992. Relational Database: Writings, 1989-1991. Reading, MA: Addison-Wesley. ISBN 0-201-54303-6.
       — 1995. Relational Database: Writings, 1991-1994. Reading, MA: Addison-Wesley. ISBN 0-201-82459-0.
       Dutka, Alan, and Howard Hanson. 1989. Fundamentals of Data Normalization. Reading, MA: Addison-Wesley ISBN 0-201-06645-9.
       Fagin, Ron. 1979. "Normal Forms and Relational Database Operators." Proceedings ACM SIGMOD International Conference on Management of Data (May). В этой статье содержатся определения пяти нормальных форм.
       Fleming, Candace С, and Barbara von Halle. 1989. Handbook for Relational Database Design. Reading, MA: Addison-Wesley. ISBN 0-201-11434-8.
       Kent, William. 1983. "A Simple Guide to Five Normal Forms in Relational Database Theory." Communications of the ACM 26(2).
       Maier, David. 1983. The Theory of Relational Databases. New York: Computer Science Press. ISBN 0-914-89442-0.
       Teorey, Toby J. 1994. Database Modeling and Design: The Fundamental Principles. 2d ed. San Francisco: Morgan Kaufmann. ISBN 1-55860- 294-1.

Книги no SQL-92
       Cannan, Stephen, and Gerard Otten. 1992. SQL: The Standard Handbook. New York: McGraw-Hill. ISBN 0-077-07664-8.
       Date, C. J., and Hugh Darwen. 1993. A Guide to the SQL Standard. Reading, MA: Addison-Wesley ISBN 0-201-55822-X.
       Gruber, Martin. 1990. Understanding SQL. Alameda, CA: Sybex. ISBN 0-895-88644-8.
       —. 1994. SQL Instant Reference. Alameda, CA: Sybex. ISBN 0-782-11148-3.
       Melton, Jim, and Alan R. Simon. 1993. Understanding the New SQL: A Complete Guide. San Francisco: Morgan Kaufmann. ISBN 1-55860-245-3.

Стандарты и рабочие группы
       Стандарты ANSI и ISO
       American National Standards Institute 1430 Broadway New York, NY 10018 phone: (212)354-3300
       Director of Publications
       American National Standards Institute
       11 West 42nd Street
       New York, NY 10036
       phone: (212) 642-4900
       Копии документации по SQL-92 и других документов ANSI можно приобрести по адресу:
       Global Engineering Documents Inc. 2805 McGaw Avenue Irvine, CA 92714 phone: (800) 854-7179

Другие консорциумы
       Х/Ореn
       1010 El Camino Real #380 Menlo Park, CA 94025 phone: (415) 323-7992
       NIST (National Institute for Standards and Technology) Technology A-266 Gaithersberg, MD 20899 Attn: FIPS-127 test suites phone: (301) 975-2000
       TPC Council
       c/o Shanley Public Relations 777 North First Street #600 San Jose, CA 95112-6113 phone: (408) 295-8894
       Object Management Group 492 Old Connecticut Path Framingham, MA 01701 phone: (508) 820-4300

Web-сайты, имеющие отношение к SQL
       Домашняя страница по SQL обслуживается одним из участников комитета ХЗН2.
       www.jjc.com/sql_stnd.html
       Получить ответы на вопросы и техническую поддержку можно также по адресу:
       www.inquiry, com/techtips/thesqlpro/index.html

ссылки

       ACM (Association for Computing Machinery). 1980. "Algorithm 199." Collected Algorithms from the ACM. New York: Association for Computing Machinery.
       Adams, Douglas. 1979. Hitchhiker's Guide to the Galaxy. New York: Harmony Books. ISBN 0-517-54209-9.
       ANSI X3. 1985, 1991. "Representation for Calendar Date and Ordinal Date for Information Interchange." 30-1985 (R-1991). New York: American National Standards Institute.
       —. 1994. "Information Systems — Representations of Universal Time, Local Time Differentials, and United States Time Zone References for Information Interchange." 51-1994. New York: American National Standards Institute.
       Arnold, Robert S. 1995a. "Millennium Now: Solutions for Century Data Change Impact." Application Development Trends (January).
       —. 1995b. "Resolving Year 2000 Problems in Legacy Software." Presentation at Software Quality Week, June, San Francisco.
       Associated Press. 1995. "Troubled Time" (May 25).
       Atzeni, Paolo, and Valeria De Antonellis. 1993. Relational Database Theory. Menlo Park, CA: Benjamin/Cummings. ISBN 0-805- 30261-1.
       Bays, Carter, and W. E. Sharp. 1992. "Improved Random Numbers for Your Personal Computer or Workstation." Geobyte 7(2): 25.
       Beech, David. 1989. "New Life for SQL." Datamation (January).
       Bernstein, P. A. 1976. "Synthesizing Third Normal Form Relations from Functional Dependencies." ACM Transactions on Database Systems l(4):277-298.
       Bole, Leonard, and Piotr Borowik. 1993. Many-Valued I jgics. New York: Springer-Verlag. ISBN 0-387-55926-4.
       Boole, George. 1854, 1951. An Investigation of the Laws of Thought, on Which are Founded the Mathematical Theories of Logic and Probabilities. New York: Macmillan and Co., 1854. New York: Dover, 1951 (reprint of 1854 edition -ISBN 0-486-60028-9).
       Cannan, Stephen, and Gerard Otten. 1992. SQL: The Standard Handbook. New York: McGraw-Hill. ISBN 0-077-07664-8.
       Carta, David G. 1990. "Two Fast Implementations of the 'Minimal Standard' Random Number Generator." Communications of the ACM 33(1):87.
       Celko, Joe. 1981. "Father Time Software Secrets Allows Updating of Dates." Information Systems News (February).
       —. 1992а "Implementing T-Joins in SQL Queries." DBMS (March). —. 1992b. "SQL Explorer: Voting Systems." DBMS (November).
       —. 1993. "Views: More than Meets the Eye." Database Programming & Design (September). Citing Nelson Mattos, from an ANSI X3H2 paper.
       —. 1997. Joe Celko's SQL Puzzles and Answers. San Francisco: Morgan Kaufmann. ISBN 1-55860-453-7.
       —. 1999. Joe Celko's Data and Databases: Concepts in Practice. San Francisco: Morgan Kaufmann. ISBN 1-55860-452-4.
       Celko, Joe, and C.J. Date. 1993. "Access Path: Lauds and Lectures, Kudos and Critiques." Database Programming & Design (September) :9 (letter to the editor).
       CFO. 1991. CFO (July): editorial.
       Chambers, W. G., and Z. D. Dai. 1991. "Simple But Effective Modification to a Multiplicative Congruential Random Number Generator." IEEE Proceedings: Computers and Digital Technology 138(3):121.
       Chassing, P. 1989. "An Optimal Random Number Generator Zp." Statistics & Probability Letters 7(4):307.
       Cini, Al. 1995. "System Bug of the Apocalypse." Internetwork (January).
       Codd, E. F. 1970. "A Relational Model of Data for Large Shared Data Banks." Communications of the ACM 13(6):377-387. New York: Association for Computing Machinery.
       —. 1975. "Understanding Relations." FDT 7:3-4.
       —. 1989. "The Need for Duplicate Rows in Tables." Datamation (January).
       —. 1990. "RV-6 VIEW Updating." The Relational Model jor Database Management: Version 2. Reading, MA: Addison-Wesley. ISBN 0-201-14192-2.
       Cohn, Michael B. [n.d.] "No Need to Fear the Year 2000." ComputerWorld.
       Comer, D. 1978. "The Difficulty of Optimum Index Selection." ACM Transactions on Database Systems 3(4):440-445.
       Crocker, Linda, and James Algina. 1986. Introduction to Classical and Modern Test Theory. Austin, TX: Holt, Rinehart & Winston. ISBN 0-030-61634-4.
       Damerau, F.J. 1964. "A Technique for Computer Detection of Correction of Spelling Errors." Communications of the ACM 7(3).
       Date, C.J. 1983. Database, A Primer. Reading, MA: Addison-Wesley ISBN 0-201-11358-9.
       —. 1986. "Updating VIEWs." Relational Database: Selected Writings. Reading, MA: Addison-Wesley. ISBN 0-201-14196-5.
       —. 1990. Relational Database: Writings, 1985-1989. Readmg, MA: Addison-Wesley, page 227. ISBN 0-201-50881-8.
       —. 1992a. "According to Date: Shedding Some Light." Database Programming Design (February): 5-17.
       —. 1992b. Relational Database: Writings, 1989-1991. Reading, MA: Addison-Wesley ISBN 0-201-54303-6.
       —. 1995a. An Introduction to Database Systems, Vols. 1 & 2. 6th ed. Reading, MA: Addison-Wesley ISBN 0-201-51381-1 & ISBN 0-201-14474-3.
       —. 1995b. Relational Database: Writings, 1991-1994. Reading, MA: Addison-Wesley ISBN 0-201-82459-0.
       Date, C.J., and Hugh Darwen. 1992. "Role of Functional Dependencies in Query
       Decomposition." Relational Database: Writings, 1989-1991. Reading,
       MA: Addison-Wesley ISBN 0-201- 54303-6.
       —. 1993. A Guide to the SQL Standard. Reading, MA: Addison- Wesley. ISBN 0-201-55822-X.
       Dutka, Alan, and Howard Hanson. 1989. Fundamentals of Data Normalization. Reading, MA: Addison-Wesley. ISBN 0-201-06645-9.
       Elkins, T.A. 1989. "A Highly Random Number Generator." Computer Language 6(12):59.
       Eve, Shimon. 1979. Graph Algorithms. New York: Computer Science Press. ISBN 0-914-89421-8.
       Fagin, Ronald. 1979. "Normal Forms and Relational Database Operators." Proceedings ACM SIGMOD International Conference on Management of Data (May).
       —. 1981. "A Normal Form for Relational Databases That Is Based on Domains and Keys." ACM TODS 6(3).
       Fine, Doug. 1995. "Companies Brace for Millennium." Infoworld (April 10).
       Fleming, Candace C, and Barbara von Halle. 1989. Handbook for Relational Database Design. Reading, MA: Addison-Wesley ISBN 0-201-11434-8.
       Fulkerson, D.R., ed. 1975. Studies in Graph Theory, Vols. 1 & 2. Providence, RI: American Mathematical Association. ISBN 0-883-58111-3 and ISBN 0-883-58112-3.
       Furman, Jeff, Albert Marotta, and Cliff Candiotti. 1995. "Party When It's 1999." Software Magazine (April).
       Gallagher, Len. 1993. "Access Path." Database Programming & Design (May): 11-13
       —. 1996. Internal X3H2 paper. New York: American National Standards Institute.
       Gardner, Martin. 1983. Wheels, Life, and Other Mathematical Amusements. New York: W. H. Freeman. ISBN 0-716-71589-9.
       Goodman, Nathan. 1990. "VIEW Update is Practical." InfoDB 5(2).
       Grahne, G. 1989. "Horn Tables —An Efficient Tool for Handling Incomplete Information in Databases." ACM SIGACT/SIGMOD/SIGARTSymposium on Principles of Database Systems :7 5-82.
       Grant, J. 1977. "Null Values in a Relational Database." Information Processing Letters 6(5):156-157.
       —. 1979. "Partial Values in a Tabular Database Model." Information Processing Letters 9(2):97-99.
       Groff, James R., and Paul N. Weinberg. 1994. LAN Times Guide to SQL. New York McGraw-Hill. ISBN 0-078-82026-X.
       Gruber, Martin. 1990. Understanding SQL. Alameda, CA: Sybex. ISBN 0-895-88644-8
       —. 1994. SQL Instant Reference. Alameda, CA: Sybex. ISBN 0- 782-11148-3.
       Gulutzan, Peter, and Trudy Pelzer. 1994. Optimizing SQL: Embedded SQL in C. Lawrence, KS: R&D Publications. ISBN 0-131- 00215-5.
       Harary, Frank. 1972. Graph Theory. Reading, MA: Addison-Wesley. ISBN 0-201-02787-9.
       Hayes, Brian. 1995. "Waiting for 01-01-00." American Scientist 83 (January-February).
       Hitchens, Randall L. 1991. "Viewpoint." ComputerWorld (January).
       Honeyman. 1980. "Functional Dependencies and the Universal Instance Property in the Relational Model of Database Systems." (Ph.D dissertation, Princeton University).
       Huff, Darrell. 1954. How to Lie with Statistics. New York: Norton.
       Hulquist, Paul F. 1991. "A Good Random Number Generator for Microcomputers." Simulation 57(4):258.
       Information Systems Week (ISW). 1987. "Code Overload Plagues NYC Welfare System." Information Systems Week (December).
       ISO. 1988. "Data Elements and Interchange Formats — Information Interchange - Representation of Dates and Times." /50 8601:1988. New York: American National Standards Institute.
       Kao, Chiang. 1989. "A Random Number Generator for Microcomputers." OR: The Journal of the Operation Research Society 40(7): 687.
       Kent, William. 1983. "A Simple Guide to Five Normal Forms in Relational Database Theory." Communications of the ACM 26(2).
       Knuth, Donald. 1981. Art of Computer Programming, Vol. 2: Seminumeral Algorithms. 2d ed. Reading, MA: Addison-Wesley, page 29.
       Komo, John J. 1991. "Decimal Pseudo-Random Number Generator." Simulation 57(4)228.
       Lancaster, Don. 1977. CMOS Cookbook. Indianapolis, IN: Sams Publishing, page 318.
       Lardner, Dionysus. 1834. A Treatise on Arithmetic, Practical and Theoretical. London: Longman, Rees, Orme, Brown, Green, & Longman.
       Larsen, Sheryl. 1996. "Powerful SQL: Beyond the Basics." DB-2 On-Line Magazine (Winter), www. db2mag. com/9601 lar. htm.
       Leva, Joseph L. 1992a. "A Fast Normal Random Number Generator." ACM Transactions on Mathematical Software 18(4) :449.
       —. 1992b. "Algorithm 712: A Normal Random Number Generator." ACM Transactions on Mathematical Software 18(4):454.
       — Lien. 1979. "Multivalued Dependencies with Null Values in Relational Databases." Proceedings of the Fifth International Conference on Very Large Databases. New York: ACM; Piscataway, NJ: IEEE.
       — Limeback, Rudy, [n.d.] "SQL Workshop Challenge." Explain (18). Undated publication; no. 18 issued 1991-1993.
       — Lipski, W. 1981a. "On Databases with Incomplete Information." fournal of the ACM28 (l):41-70.
       —. 1981b. "On Semantic Issues Connected with Incomplete Information." ACM Transactions on Database Systems (September): 262-296.
       Lorie, Raymond A., and Jean-Jacques Daudenarde. 1991. SQL and Its Applications. Englewood Cliffs, NJ: Prentice Hall. ISBN 0-138-37956-4.
       Lusardi, Frank. 1988. The Database Expert's Guide to SQL. New York: McGraw-Hill. ISBN 0-070-39002-9.
       Macomber, James H., and Charles S. White. 1990. "An N- Dimensional Uniform Random Number Generator Suitable for IBM- Compatible Microcomputers." Interfaces 20(3)A9.
       Maier, David. 1983. The Theory of Relational Databases. New York: Computer Science Press. ISBN 0-914-89442-0.
       Maier, W. L. 1991. "A Fast Pseudo Random Number Generator." Dr. Dobbs Journal 17 (5):152.
       Marsaglia, G., B. Narasimhan, and A. Zaman. 1990. "A Random Number Generator for PCs." Computer Physics Communications (60):345-349.
       Marsaglia, G., and A. Zaman. 1990. "Toward a Universal Random Number Generator." Statistics & Probability Letters (8):35-39.
       McFadden, F., J. Hoffer, and M. Prescott. 1998. Modern Database Management. 5th ed. Reading, MA: Addison-Wesley.
       McGoveran, David. 1993. "Nothing from Nothing Part I (or, What's Logic Got to Do with It?)." Database Programming & Design 6(12):32.
       —. 1994a. "Nothing from Nothing Part II: Classical Logic: Nothing Compares 2 U." Database Programming &f Design 7(1):54.
       —. 1994b. "Nothing from Nothing Part III: Can't Lose What You Never Had." Database Programming & Design 7(2) :42.
       —. 1994c. "Nothing from Nothing Part IV: It's in the Way That You Use It." Database Programming & Design 7 (3): 54.
       McGoveran, David, and С J. Date. 1992. Guide to Sybase and SQL Server. Reading, MA: Addison-Wesley.
       McHugh, James A. 1990. Algorithmic Graph Theory. Englewood Cliffs, NJ: Prentice Hall. ISBN 0-130-23615-2.
       Melton, Jim. 1998. Understanding SQL's Stored Procedures: A Complete Guide to SQL/PSM. San Francisco: Morgan Kaufmann. ISBN 1-55860-461-8.
       Melton, Jim, and Alan R. Simon. 1993. Understanding the New SQL: A Complete Guide. San Francisco: Morgan Kaufmann. ISBN 1-55860-245-3.
       Melzak, Z. A. 1983. Bypasses: A Simple Approach to Complexity. New York: Wiley-InterScience. ISBN 0-471-86854-X.
       Miljenko, Martinis. 1992. DBMS (May): letters column.
       Morton, Mike. 1985. "A Digital Dissolve for Bit-Mapped Graphics Screens." Dr. Dobb's Journal (November):48.
       Mrdalj, Stevan, Branislav Vujovic, and Vladanjovanovic. 1996. "SQL Matrix Processing." Database Programming & Design (August).
       Murchison, Rory. [n.d.] "SQL Workshop Challenge." Explain (16). Undated publication; no. 16 issued 1991-1993.
       Murray, Jerome Т., and Marilyn J. Murray. 1984. Computers in Crisis: How to Avert the Coming Worldwide Computer Systems Collapse. New York: Petrocelli Books. ISBN 0-894-33223-6.
       Ore, Oystein (revised by Robin J. Wilson). 1990. Graphs and Their Uses. Providence, RI: American Mathematical Association. ISBN 0-883-58635-2.
       Paitetsky-Shapiro, G. 1983. "The Optimal Selection of Secondary Indexes in NP-Complete." SIGMODRecord 13(2):72-75.
       Palmer, Roger. 1994. The Bar Code Book. Peterborough, NH: Helmers Publishing. ISBN 0-911-261-09-5.
       Park, S. K., and K. W. Miller. 1988. "Random Number Generators: Good Ones Are Hard to Find." CACM31(10):1201
       Pascal, Fabian. 1989. SQL and Relational Basics. New York: M&T Books.
       — 1993. Understanding Relational Databases. New York: M&T Books. ISBN 0-471-58538-6.
       Philips, Lawrence. 1990. "Hanging on the Metaphone. (A Phonetic Text-Retrieval Algorithm Better than Soundex)." Computer Language 7(12): 38.
       Press, William H., Brian P. Flannery, and William T. Vetterling. 1989. Numerical Recipes in Pascal: The Art of Scientific Computing. Cambridge, UK: Cambridge University Press, page 233.
       Ross, Noah. 1995. "The End of the Century is Nearer than You Think." Application Development Trends (April).
       Rozenshtein, David. 1981. "Implementing Null Values in Relations." (unpublished, May).
       —. 1995. Optimizing Transact-SQL: Advanced Programming Techniques. Fremont CA: SQL Forum Press. ISBN 0-964-98120-3.
       Rozenshtein, David, Anatoly Abramovich, and Eugene Birger. 1993. "Loop-Free SQL Solutions for Finding Continuous Regions." SQL Forum 2(6).
       Rubin, Howard, and Jim Woodward, [n.d.] "Millennium: A Billion Dollar Software Crisis." Videotape. The Computer Channel Inc.
       Sezgin, Fatin. 1990. "On a Fast and Portable Uniform Quasi- Random Number Generator." Simulation Digest 21(2):30.
       Shasha, Dennis E. 1992. Database Tuning: A Principled Approach. Englewood Cliffs, NJ: Prentice Hall. ISBN 0-132-05246-6.
       Smithwick, Terry. 1991. Pascal version of Lawrence Philips' Metaphone. CompuServe. CLMFORUM. Originally published by Lawrence Philips. 1990. "Hanging on the Metaphone. (A Phonetic Text-Retrieval Algorithm Better than Soundex)." Computer Language 7 (12)'38.
       SPARC Study Group on Database Management Systems. 1975. "Interim Report 75-02-08 to the ANSI X3." FDT-Bulletin ACM SIGMOD 7(2).
       SQL Forum. 1993, 1994. SQL Forum. See articles by Anatoly Abramovich, Yelena Alexandrova, and Eugene Birger (July/August 1993, March/April 1994).
       Stevens, S. S. 1957. "On the Psychophysical Law." Psychological Review 64:153-181.
       Stonebraker, Michael. 1998. Readings in Database Systems. 3d ed. San Francisco: Morgan Kaufmann. ISBN: 1-55860-523-1.
       Sullivan, R. Lee. 1995. "Ghosts in the Machines." Forbes (June 19).
       Tantzen, Robert G. 1980. "Algorithm 199: Conversion between Calendar Date and Julian Day Number." Collected Algorithms from the ACM. New York: Association for Computing Machinery.
       Teorey, TobyJ. 1994. Database Modeling and Design: The Fundamental Principles. 2d ed. San Francisco: Morgan Kaufmann. ISBN 1-55860-294-1.
       Tillquist, John, and Feng-Yang Kuo. 1989. "An Approach to the Recursive Retrieval Problem in the Relational Database." Communications of the ACM 32(2):239.
       Trimble, Harvey, and David Chappel. 1989. A Visual Introduction to SQL. New York: John Wiley. ISBN 0-471-61684-2.
       Umeshar, Dayal, and P. A. Bernstein. 1982. "On the Correct Translation of Update Operations on Relational VIEWs." ACM Transactions on Database Systems 7(3).
       van der Lans, Rick F. 1989. The SQL Standard: A Complete Reference Guide. Englewood Cliffs, NJ: Prentice Hall International. Schoonhaven: Academic Service. ISBN 0-138-40059-8.
       —. 1991. "SQL Portability." The RelationalJournal 2(6).
       Vassiliou, Y. 1979. "Null Values in Database Management - A Denotational Semantics Approach." ACM SIGMOD Conference Proceedings:162-169.
       — 1980. "Functional Dependencies and Incomplete Information." Proceedings of the Sixth International Conference on Very Large Databases. New York: ACM; Piscataway, NJ: IEEE.
       Verhoeff.J. 1969. "Error Detecting Decimal Codes." Mathematical Centre Tract #29. Amsterdam: The Mathematical Centre.
       Vicik, Rick. 1993. "Advanced Transact SQL." SQL Forum (July/August).
       Wankowski, Jim. [n.d.]. "SQL Workshop Solutions." Explain (17). Undated publication; no.17 issued 1991-1993.
       Wellesley Software Group. 1991. Learning SQL. Englewood Cliffs, NJ: Prentice Hall. ISBN 0-135-28704-9.
       —. 1992. Learning Advanced SQL. Englewood Cliffs, NJ: Prentice Hall. ISBN 0-135-28712-X.
       Xenakis, John. 1995. "The Millenium Bug: The Fin De Siecle Computer Virus." CFО Magazine (July).
       Yozallinas,J. R. 1981. Tech Specialist (May): letters column.
       Zaniolo, С 1984. "Database Relations with Null Values." Journal of Computer andSystem Sciences 28(1):142-166.
       Zerubavel, Eviatar. 1985. The Seven Day Circle. New York: The Free Press. ISBN 0-029-34680-0.




<<< Пред. Оглавление
 
След. >>>

Дата последнего изменения:
Thursday, 21-Aug-2014 09:10:55 MSK


Постоянный адрес статьи:
http://az-design.ru/Support/DataBase/SQL/CelkoJ/01hapl.shtml