1 / 12

CS461: Principles and Internals of Database Systems Instructor: Ying Cai

CS461: Principles and Internals of Database Systems Instructor: Ying Cai Department of Computer Science Iowa State University yingcai@iastate.edu Office: Atanasoff 201 Office Hours: MT 2:00pm-3:00pm. Database. A collection of related data [Elmasri]

sydnee
Download Presentation

CS461: Principles and Internals of Database Systems Instructor: Ying Cai

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CS461: Principles and Internals of Database Systems Instructor: Ying Cai Department of Computer Science Iowa State University yingcai@iastate.edu Office: Atanasoff 201 Office Hours: MT 2:00pm-3:00pm

  2. Database • A collection of related data [Elmasri] • A database represents some aspect of real world called “miniworld” [Elmasri] or “enterprise” [Ramakrishnan] • A database can be of any size and of varying complexity. • It may be generated and maintained manually or using computers

  3. Database Management System (DBMS) • A software package designed to store and manage databases • Relational DBMSs: DB2, Informix, Oracle, Microsoft Access, Microsoft SQL Server, FoxBase, Paradox

  4. Objectives • To understand • database design techniques and theories behind • design/implementation of some components of database management system (DBMS) • Some advanced topics • To be familiar with some commercial relational database management systems • To experience working as a team, consisting of 3-4 members

  5. Course Materials • Reading materials • Database Management Systems (3rd ed.), by R. Ramakrishnan and J. Gehrke. • Others will be posted on the Internet • Lecture notes • available for downloading on the course web site http://www.cs.iastate.edu/~cs461

  6. Topic Coverage • Part 1: Database design • Introduction, conceptual database design (chapters 1-3) • Review of SQL (Chapter 5) • Schema refinement and normal forms (Chapters 19-20) • Database application design and development (through project)

  7. Topic Coverage • Part 2: Database Internals • Relational Algebra (Chapter 4) • Storage and Indexing (Chapters 8-9, 10.1, 10.3-10.6) • Query evaluation (Chapters 12-14) • Query optimization (Chapter 15) • Transaction management (Chapters 16-17)

  8. Topic Coverage • Part 3: Advanced Topics • Security • Spatial indexing • Mobile object database management • Data mining • Internet search

  9. Team Project • What to do • Your idea • Project manager • Main contact with the instructor • Task and time allocation • Lead efforts in requirement analysis, project report and presentation • DBA • Lead database design, implementation, and database security • Lead developer • Code development and review

  10. Grading Policy (tentative) • Class discussion: 5% • Exams: 40% • Midterm (20%) • Final (20%) • Homework: 30% • Group Project: 25% • Report (5%) • Software (10%) • Presentation (10%)

  11. Mutual Contract • Instructor • I will provide information about database principles and practice to the best of my knowledge • I will uphold my professional ethics • Students • I will participate in this course and practice concepts learned through lectures, assignments, exams, and team projects to the best of my ability • I will uphold academic honesty, professional ethics and be a good class and world citizen

  12. Other Policies • Academic Honesty • Students who plagiarize other work in any part of assignment/tests will receive F as the letter grade for this course, and will be reported to the university. • Disability • If you have a documented disability and anticipate needing accommodations in this course, please make arrangements to meet with me soon.

More Related