1 / 18

CS 3630 Database Design and Implementation

CS 3630 Database Design and Implementation. Dr. Qi Yang 213 Ullrich My Home Page: http://www.uwplatt.edu/~yangq/ The Class Page: http://www.uwplatt.edu/~yangq/cs363/cs363.html. Prerequisites. CS 243 (Better CS323!) MATH 273 (Removed!) Not a programming course

moses-marquez
Download Presentation

CS 3630 Database Design and Implementation

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. CS 3630 Database Design and Implementation Dr. Qi Yang 213 Ullrich My Home Page: http://www.uwplatt.edu/~yangq/ The Class Page: http://www.uwplatt.edu/~yangq/cs363/cs363.html

  2. Prerequisites CS 243 (Better CS323!) MATH 273 (Removed!) Not a programming course Basic theory and concepts Oracle Programming

  3. Course Work • Assignments 100 • Quizzes 80 • Tests 120 • Project 100 • Final 100 • Total 500

  4. Grading NO CURVE! Required Course! Graduating Seniors to Waive Final A 372 - 400 93% B 332 - 371 83% C 292 - 331 73%

  5. Underlying Framework of CIS • Most IS are based on databases • Fundamentally changed the way many organizations operate • Business without database?

  6. One Important Development in Software Engineering • Query Processing • Access Control • Transactions • Distributed computing • Networking • …

  7. What can you do after taking the course? • Internship • Projects with databases • Job title = SQL Query Specialist • DBA • SQA • …

  8. What is a computer? Network CPU Output Input MEMORY Storage

  9. File Systems Files Users Programs

  10. Issues in File Systems • Program-Data Dependence Physical structure is defined in application code • Separation and Isolation of Data Information is stored in separate files • Duplication of Data and Data Inconsistency • Incompatible File Formats Files from C++ and COBOL may be different

  11. Issues in File Systems • Fixed Queries New queries requires new/modified programs • Transactions Concurrent access to the same file Access different portions of a file • Access Control and Security Who can and cannot access files, fields… • Recovery • …

  12. Database Systems DBMS: Database Management system D B M S Files Users Programs

  13. Advantages of Database • Data Independence • Physical structure is unknown to application code • Data Relationship • Primary key and Foreign key • Limited Duplication of Data and Data Consistency • Query Processing • Access Control • Security • Recovery

  14. Disadvantages of Database • Complexity • Cost • Performance • Higher Impact of Failure

  15. Roles in Database Environment (People) • DA (Data Administrator) • DBA (Database Administrator) • Database Designers • Application Developers • End-Users

  16. Database Management Systems • First generation Hierarchical Network • Second generation Relational • Third generation OODB GIS Fuzzy DB … • Non-Relational Google’s BigTable Amazon's Dynamo

  17. Highest Academic Award in Computer Science? • Turing Award • Nobel Prize of Computing • http://en.wikipedia.org/wiki/Turing_Award • 1981: Dr. E.F. Codd Relational Database Model

  18. Chapter 1

More Related