CS4221 -- Database Design References

Books

  1. Serge Abiteboul, Peter Buneman, and Dan Suciu. Data on the Web: From Relations to Semi-structured Data and XML. Morgan Kaufmann, 2000. (in Central Library RBR Collection)
  2. Paolo Atzeni, Stefano Ceri, Stefano Paraboshchi, and Richcardo Torlone. Database Systems, Concepts, Languages and Architectures. McGraw-Hill, 1999. (in Central Library RBR Collection)
  3. C Batini, S Ceri, and S B Navathe. Conceptual Database Design, An Entity-Relationship Approach. The Benjamin Cummings Publishing Company Inc, 1992.
  4. Thomas Connolly and Carolyn Begg. Database Systems: A Practical Approach to Desing, Implementation, and Management. Fifth Edition, Pearson, 2010.
  5. C J Date. An Introduction to Database Systems. Third edition, Addison-Wesley, 1981.
  6. C J Date. An Introduction to Database Systems. Eighth edition, Addison-Wesley, 2004.
  7. Ramez Elmasri and Shamkant B. Navathe. Fundamentals of Database Systems. Sixth Edition, Addison Wesley, 2011
  8. R Gillette, D Muench, and J Tabaka. Physical Database Design for SYSBASE SQL Server. Prentice Hall, 1995.
  9. W Kim. Introduction to Object-Oriented Databases. The MIT Press, 1990.
  10. Tok Wang Ling, Mong Li Lee, and Gillian Dobbie. Semistructured Database Design. Springer, 2005. (in Central Library RBR Collection) pdf file
  11. David Maier. The Theory of Relational Databases. Computer Science Press, 1984. (in Central Library RBR Collection)
  12. Raghu Ramakrishnan and Johannes Gehrke. Database Management Systems. 3rd edition, McGraw Hill, 2003. (in Central Library RBR Collection)
  13. Toby Teorey, Sam S. Lightstone, Tom Nadeau. Database Modeling and Design: Logical Design. 4th Edition, Morgan Kaufmann, 2006.
  14. J D Ullman. Principles of Database Systems. Second Edition, Computer Science Press, 1982.
  15. J D Ullman. Principles of Database and Knowledge-BaseSystems, Volume 2. Computer Science Press, 1989.

Papers

  1. E,F. Codd, A Relational Model of Data for Large Shared Data Banks, CACM Vol 13, No 6, pp 377-387, 1970. pdf file
  2. Philip A Bernstein, Synthesizing Third Normal Form Relations form Functional Dependencies, ACM Transactions on Database Systems, vol 1, no 4, pp 277-298, 1976. pdf file
  3. Tok Wang Ling, Frank W Tompa, & Tiko Kameda, An Improved Third Normal Form for Relational Databases, ACM TODS, vol 6, no 2, pp 329-346, 1981. pdf file
  4. R Fagin, Multivalued Dependencies and a new Normal Form for Relational Databases, ACM TODS, vol 2, no 3, pp 262-278, 1977. pdf file
  5. Carlo Zaniolo, A New Normal Form for the Design of Relational Database Schemata, ACM Transactions on Database Systems, Vol. 7, No. 3, September 1982, pp 489-499. pdf file
  6. P P Chen, The Entity-Relationship Model: Toward a Unified View of Data, ACM TODS, vol 1, no 1, pp 9-36, 1976. pdf file
  7. Tok Wang Ling and Mong Li Lee, A Theory for Entity-Relationship View Updates, ER 1992, pp 262-279, 1992 pdf file
  8. Tok Wang Ling and Mong Li Lee, View Updates in Entity-Relationship Approach, DKE 19(2), pp 135-169, 1996 pdf file
  9. P P Chen, English Sentence Structure and Entity-Relationship Diagram, Information Sciences, vol 1, no 1, pp 127-149, May 1983. pdf file
  10. Tok Wang Ling, A Normal Form for Entity-Relationship Diagrams, The 4th International Conference on Entity-Relationship Approach, Chicago, pp 24-35, 1985. pdf file
  11. Toby J. Teorey, Dongqing Yang, and James P. Fry, A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model, Computing Surveys, vol 18, no 2, pp 197-222, 1986. pdf file
  12. C Beeri and M Kifer, An Integrated Approach to Logical Design of Relational Database Schemes, ACM TODS, vol 11, no 2, pp 134-158, 1986. pdf file
  13. C Batini, M Lenzerini, and S B Navathe, A Comparative Analysis of Methodologies for Database Schema Integration, ACM Computing Surveys, vol 18 no 4, pp 321 -364, 1986. pdf file
  14. D Quass, A Rajaraman, J Ullman, J Widom, Querying Semistructured Heterogeneous Information, DOOD'95 proceedings, Springer-Verlag, 1995. pdf file
  15. Tok Wang Ling and Pit Koon Teo, Toward Resolving Inadequacies in Object-Oriented Data Models, Information and Software Technology, vol 35, no 5, 1993. pdf file
  16. Tok Wang Ling, Pit Koon Teo, Ling-Ling Yan: Generating Object-Oriented Views from an ER-Based Conceptual Schema. DASFAA 1993: pp 148-155 pdf file
  17. Tok Wang Ling and Pit Koon Teo, On Rules and Integrity Constraints in Database Systems, Information and Software Technology, vol 34, no 3, 1992. pdf file
  18. Ling-Ling Yan, Tok Wang Ling: Translating Relational Schema With Constraints Into OODB Schema. DS-5 1992: 69-85 pdf file
  19. Tok Wang Ling and Pit Koon Teo, A Normal Form Object-Oriented Entity-Relationship Diagram, Proceedings of ER'94, Springer-Verlag, 1994. pdf file
  20. Mong Li Lee and Tok Wang Ling, Resolving structural conflicts in the integration of entity-relationship schemas. Proceedings of ER'95, Springer-Verlag, 1995. pdf file
  21. Tok Wang Ling and Pit Koon Teo, Inheritance conflicts in object-oriented systems, Proceedings of DEXA'93, Springer-Verlag, 1993. pdf file
  22. Tok Wang Ling, Cheng Hian Goh, Mong-Li Lee: Extending classical functional depen dencies for physical database design. Information & Software Technology 38(9): 6 01-608 (1996) pdf file
  23. Sin Yeung Lee, Mong Li Lee, Tok Wang Ling, and Leonid A. Kalinichenko, Designing Good Semi-Structured Databases and Conceptual Modeling, ER'1999, 131-145. pdf file
  24. Mengchi Liu and Tok Wang Ling, A Data Model for Semistructured Data with Partial and Inconsistent Information. EDBT'2000, 317-331 pdf file
  25. Gillian Dobbie and Tok Wang Ling, Practical approach to designing data warehouse views using data dependencies, ER'2000. pdf file
  26. Gillian Dobbie, Xiaoying Wu, Tok Wang Ling and Mong Li Lee, ORA-SS: An Object-Relationship- Attribute Model for Semi-Structured Data. Technical Report: TR21/00, School of Computing, NUS. pdf file
  27. Tok Wang Ling, Mong Li Lee, and Gillian Dobbie, Applications of ORA-SS: An Object-Relationship-Attribute Data Model for Semistructured Data. The Third International Conference on Information Integration and Web-based Applications and Services (IIWAS2001), Sept 2000. pdf file
  28. Papers (with softcopies) on Object-Relationship-Attribute Model for Semistructured Data (ORA-SS) and XML Query Processing: http://www.comp.nus.edu.sg/~lingtw/orass.papers.html

Some useful web addresses

Computer Science Bibliography: http://www.informatik.uni-trier.de/~ley/db/index.html

ACM Sigmod Anthology: http://www.informatik.uni-trier.de/~ley/db/anthology.html

XML web sites:

  • http://www.w3.org/
  • http://www-db.stanford.edu/~widom
  • http://www-rocq.inria.fr/~abitebou
  • http://www.cs.washington.edu/homes/suciu/

    Bibliography on Data Warehousing and OLAP: http://www.cs.toronto.edu/~mendel/dwbib.html