I Basic Concepts of Database ManagementII Introduction to the Relational Data ModelIV The Entity Relationship Data ModelVI Introduction to KDD and Data WarehousingVIII Internet Databases and XMLXI Object-Oriented DatabasesX Summary: Where Do We Stand?Preview Labs and Home Works COSC 3480LabsHomework2: covers topics of Section VII of the courseShort Term PlanPreliminary Teaching Plan and Textbook CoverageI Basic Concepts of Database Management (3 classes; Chapter 1, 2.1,2.2, 2.3; instructor teaching material)II Introduction to the Relational Data Model (1 class; Chapter 3.1, 3.2, 3.3, 3.4, 3.6)III Introduction to the Relational Algebra and SQL (3.5 classes; 4.2 and Chapter 5)IV Conceptual Schema Design using the Entity Relationship Data Model (2.5 classes; instructor material; Sections 2.1-2.5)V Relational Database Design and Normalization (2.5 classes; instructor material, Chapter 19)VI Introduction to KDD and Data Warehousing (2 classes; instructor material, Chapter 26)VIII Internet Databases and XML (1 class; Chapter 7 and 27)IX Object-Oriented DatabasesDr. Christoph F. EickCOSC 3480 Lecture Organization I Basic Concepts of Database Management - Sham Navathe's database introduction (in Word) - Dr. Eick's "database introduction" transparencies databases and data models (updated on January 14, 2003)II Introduction to the Relational Data Model - Dr. Eick's Rel/SQL-transparencies (Postscript; to be used in lecture, if enough time), Raghu's Introduction to SQL (Powerpoint).III Introduction to Relational Algebra and SQL- Jeff Ullman's SQL Intro. Part1 and SQL Intro. Part II, SQL Constraints, Triggers, and Assertions and PL/SQL Introduction (Postscript; useful for Project2) - Raghu's Relational Algebra Transparencies (will be partially be discussed in class). IV The Entity Relationship Data Model - Ullman's E/R-Model Introduction (Part1, Part2 in Postscript Format). - Designing E/R Diagrams (transparencies added on Jan. 16, 2002) - Mapping E/R Diagrams to the Relational Data ModelV Relational Database Design and Normalization- Functional Dependencies, BCNF, and Normalization (to be used in lecture) - Dr. Eick's Normalization Transparencies (to be used in lecture) - Jeff Ullman's Normalization Transparencies (only transparencies 1-6 are relevant; the others discuss relational algebra; will not be used in lecture) VI Introduction to KDD and Data Warehousing- Dr. Eick's Introduction to KDD transparencies. - OLAP/data warehouse transparencies to be used for COSC 6340; other more detailed collections include: Hector Garcia-Molina's Data Warehouse and OLAP transparencies, Raghu's OLAP/dataware house transparencies and Han/Kamber's OLAP/data warehouse transparencies. An "easy down-to earth" example of building a simple OLAP application. Moreover, Olapreport gives good discussion about the commercial aspects of products and companies being involved in OLAPmarket. Other parts discuss how Microsoft managed to enter the OLAP market after not being involved with OLAP technology at all through 1998. 1- Han/Kamber's Concept Learning transparencies (to be discussed in class) VII Disks, Files, Storage Structures, Index Structures and Physical Database Design - Raghu's Discusssions conc. Secondary Storage (Powerpoint; not to be discussed in class but relevant for the Feb. 19 review exam!) - Raghu's transparencies discussing file systems (not to be disussed in class).- Disk Sorting Algorithms- Raghu's/Dr. Eick's transparencies discussing B+-trees and Hashing Techniques forStorage and Index Structures (to be used in lectures; cover material of chapters 9 and 10, but also contain a few "new" transparencies; a "new" transparency 26 wasadded on Feb. 5, 2002) - Raghu's Physical Database Design Transparencies VIII Internet Databases and XML - Raghu's internet database transparencies (those transparencies discussing XML and semi-structured data will be used in the lecture) - Jeff Ullman's Semi-structured database transparencies (transparencies 11 to 22 will be used in the lecture) - The followings are the links to information on how to use XML-DTD (might be helpful for Homework2): DTD1, DTD2, and DTD3. - The following links refer to XML tutorials additional reading material): John Punin's US XML-Tutorial (please review John Punin's slide show --- it gives you a more "state of the art" discussion of XML and XML products) XI Object-Oriented Databases - Jeff Ullman's ODL transparencies and OQL transparencies (Part1, Part2; Part1 likely to be used in lectures). - Dr. Eick's 3 OBJ-TransparenciesX Summary: Where Do We Stand?Remark: It is highly unlikely that Object-oriented Databases will be covered in Fall 2003;very likely there will be just enough time for a brief introduction to internet databases2Dr. Christoph F. EickPreview Labs and Home Works COSC 3480LabsLab1: Getting started due: September 23, 2003Lab2: Simple SQL Queries due: October 2, 2003Lab3: Complex SQL Queries & Views due: October 21, 2003Lab4: Logical database design due: Nov. 4, 2003Lab5: PL/SQL programming due: Nov. 20, 2003Lab6: TBDL due: Dec. 4, 2003Home WorksHomework1: covers topics of Section V of the course Homework2: covers topics of Section VII of the courseExamsMidterm1 (Tu., October 7, 2003)Midterm2 (Tu., November 11, 2003)Final Exam (Tu., December 16, 5p)Short Term Plan- There will be makeup “double” classes on Th., Sept. 4and Th., Sept. 25 4-7p.- The lab sessions will likely start in the Sept. 8 week.3Preliminary Teaching Plan and Textbook CoverageI Basic Concepts of Database Management (3 classes; Chapter 1, 2.1,2.2, 2.3; instructor teaching material)II Introduction to the Relational Data Model (1 class; Chapter 3.1, 3.2, 3.3, 3.4, 3.6)III Introduction to the Relational Algebra and SQL (3.5 classes; 4.2and Chapter 5)IV Conceptual Schema Design using the Entity Relationship Data Model (2.5 classes; instructor material; Sections 2.1-2.5)V Relational Database Design and Normalization (2.5 classes; instructor material, Chapter 19)VI Introduction to KDD and Data Warehousing (2 classes; instructor material, Chapter 26)VII Disks, Files, Storage Structures, Index Structures and Physical Database Design (5 classes, Chapter 8, 9, 10, 11.1, 11.2, 13, 20)VIII Internet Databases and XML (1 class; Chapter 7 and 27) IX Object-Oriented Databases X Summary: Where Do We Stand? (1 class; instructor material)Summary: 21-22 classes regular lectures; 2 classes are allocated to exams; 2-3 classes are allocated to reviews, discussing homework