2003F CS157A Links
Introduction
http://www.biz.uiowa.edu/class/6K182_blegen/Lecture02.htm
Database Environment
http://www.biz.uiowa.edu/class/6K182_blegen/Lecture03.htm
Database Design
http://www.biz.uiowa.edu/class/6K182_blegen/Lecture4A.htm
Database Design 2
http://faculty.uaeu.ac.ae/~baghdadi/PDF/DBDPresentation.pdf
Information for database designer-----IBM
http://www.rational.com/analyst/database_designer.jsp?SMSESSION=NO
ER-diagram
http://www.biz.uiowa.edu/class/6K182_blegen/Lecture05.htm
Transform EER to relational Model 2
http://www.dis.unimelb.edu.au/staff/veres/230/lecture17.pdf
Relational Model 1
http://www.biz.uiowa.edu/class/6K182_blegen/Lecture04.htm
Relational Model 2
http://www.csee.usf.edu/~mlast/db/db6.pdf
Relational Algebra1
http://www.csee.usf.edu/~mlast/db/db7.pdf
Implement of relation operations
http://www.cse.ogi.edu/class/cse514/rel-op-algorithms.pdf
Relational Algebra 2
http://www.csee.usf.edu/~mlast/db/db8.pdf
Relational Algebra and Relational Calculus
http://www.csee.usf.edu/~mlast/db/db9.pdf
SQL1
http://www.csee.usf.edu/~mlast/db/db10.pdf
SQL2
http://www.csee.usf.edu/~mlast/db/db11.pdf
Simple SQL 3
http://www.dis.unimelb.edu.au/staff/veres/230/lab2.prn.pdf
MySQL
http://www.cs.cuw.edu/csc/csc450/w04d2.ppt
Normal Forms
http://www.csee.usf.edu/~mlast/db/db12.pdf
Schema Refinement & Normalization
http://www.cse.ogi.edu/class/cse514/normalization.pdf
Physical DB design
http://www.cse.ogi.edu/class/cse514/physical-design.pdf
Datawarehouse and datamining
http://www.csee.usf.edu/~mlast/db/db20.pdf
Understanding Normalization
http://safariexamples.informit.com/0201752840/white_paper.pdf
Normalization---formal definition 2
http://www.dis.unimelb.edu.au/staff/veres/230/lecture5.pdf
It-is-not-true –more-is-best
http://go.6to23.com/sujiehui/web/flash1.htm
Anomalies
http://www.dis.unimelb.edu.au/staff/veres/230/lecture4.pdf
Peter P. Chen. The entity-relationship model -
Towards a unified view of data. ACM Transactions on Database Systems
(TODS), 1(1):9-36, 1976.
E. F. Codd. A relational model of data for large
shared databanks. Communications of the ACM, 13(6):377-387, 1970.
(.pdf) (.html )
E. F. Codd. Data
models in database management. In Proc. ACM SIGMOD/PODS Workshop on Data
Abstraction, Databases, and Conceptual Modeling, pp. 112-114,
1980.
William Kent. A simple guide to five normal
forms in relational database theory. Communications of the ACM,
26(2):120-25, 1983
J. Gray. The Transaction Concept, Virtues And
Limitations. In Proc. 7th VLDB Conference, Cannes, France, pp. 144-154.
1981. (MS
Word document)
Zloof Moshe. Query-by-Example: A data base language. IBM Systems Journal, 16(4):324-343, 1977.
----------------------------ER-diagram
http://www.biz.uiowa.edu/class/6K182_blegen/Lecture05.htm
Normal Forms
http://www.csee.usf.edu/~mlast/db/db12.pdf
Rules of Data Normalization
http://www.datamodel.org/NormalizationRules.html
Data Modeling vs. Database Design
http://www.aisintl.com/case/library/R-Theory_vs_ER/r-theory_vs_er.html
Schema Refinement & Normalization
http://www.cse.ogi.edu/class/cse514/normalization.pdf
Implement of relation operations
http://www.cse.ogi.edu/class/cse514/rel-op-algorithms.pdf
Relational Algebra 2
http://www.csee.usf.edu/~mlast/db/db8.pdf
Query Optimization
http://www.cse.ogi.edu/class/cse514/query-optimization.pdf
Transactions
http://www.biz.uiowa.edu/class/6K182_blegen/Lecture%2016.html
Query Processing
http://www.csee.usf.edu/~mlast/db/db15.pdf
Concurrency Control 1
http://www.csee.usf.edu/~mlast/db/db16.pdf
Concurrency Control 2
http://www.csee.usf.edu/~mlast/db/db17.pdf
Concurrency Control3
http://www.cse.ogi.edu/class/cse514/concurrency-recovery.pdf
Recovery
http://www.csee.usf.edu/~mlast/db/db18.pdf
Web and database
http://www.cs.cuw.edu/csc/csc450/w11d1.ppt
Distributed Database systems1
http://www.biz.uiowa.edu/class/6K182_blegen/Lecture%2017.html
Distributed Database systems2
http://www.cs.cuw.edu/csc/csc450/w14d1.ppt
XML and data managements
http://www.cse.ogi.edu/class/cse514/xml-dm-2003-08-28.pdf
Functional dependencies and Normalization
http://www.cs.montana.edu/~defrance/classes/spring-2003/cs435/lectures/FD.html
Relation Algebra
http://www.doc.mmu.ac.uk/STAFF/P.Quick/relatnot.doc
The relational model: operations
http://www.cs.montana.edu/~defrance/classes/spring-2003/cs435/lectures/RelationaAlgebra.html
The SQL language
http://www.cs.montana.edu/~defrance/classes/spring-2003/cs435/lectures/SQL1.html
Data
Manipulation: Retrieval Operations
http://www.cs.montana.edu/~defrance/classes/spring-2003/cs435/lectures/SQL_DML.html
Advanced
SQL
http://www.cs.montana.edu/~defrance/classes/spring-2003/cs435/lectures/AdvancedSQL.html
More Queries
http://www.cs.montana.edu/~defrance/classes/spring-2003/cs435/lectures/MoreQueries.html
Object-relational Data model
http://www.cs.montana.edu/~defrance/classes/spring-2003/cs435/lectures/warehousing.html
Data Warehouse
http://www.cs.montana.edu/~defrance/classes/spring-2003/cs435/lectures/warehousing.html
Data warehouse 2
http://www.dis.unimelb.edu.au/staff/veres/230/lecture20.pdf
ER diagrams 4
http://www.cis.ohio-state.edu/~srini/670/Lectures/lec7.pdf
ER-diagrams 5
http://www.cis.ohio-state.edu/~srini/670/Lectures/lec8.pdf
ER and EER
http://www.cis.ohio-state.edu/~srini/670/Lectures/lec9.pdf
Relation Algebra and SQL
http://www.ug.cs.sunysb.edu/~kifer/cse532/slides/ch6.pdf
Relational Calculus
http://www.cs.unc.edu/Courses/comp130-s03/comp130-8.pdf
Relational Calculus and visual query language
http://www.ug.cs.sunysb.edu/~kifer/cse532/slides/ch7.pdf
Theory of functional dependencies
http://www.cis.ohio-state.edu/~srini/670/Lectures/lec12.pdf
Theory of normalization
http://www.cis.ohio-state.edu/~srini/670/Lectures/lec13.pdf
Normalization 2
http://www.cis.ohio-state.edu/~srini/670/Lectures/lec10.pdf
Normalization 3
http://www.cis.ohio-state.edu/~srini/670/Lectures/lec11.pdf
Database Normalization Basic
http://databases.about.com/library/weekly/aa080501a.htm
Schema refinement and normal forms
http://www.sis.pitt.edu/~vladimir/classes/infsci2710/Ch19-SRef-95.pdf
Database design:Normalization
http://www.cs.unc.edu/Courses/comp130-s03/comp130-11.pdf
Relational Normalization
http://www.ug.cs.sunysb.edu/~kifer/cse532/slides/ch8.pdf
Distributed Databases
http://www.ug.cs.sunysb.edu/~kifer/cse532/slides/ch18.pdf
OLAP and data mining
http://www.ug.cs.sunysb.edu/~kifer/cse532/slides/ch19.pdf
Data mining 3
http://www.dis.unimelb.edu.au/staff/veres/230/Lecture21.pdf