1 / 13

CSC 453 Database Technologies

CSC 453 Database Technologies. Tanu Malik DePaul University. Course Overview. Introduction Relational Model-Concepts Relational Model-Implementation SQL. Why take this course?. The digital world runs on data Data must quickly lead to information/ knowledge.

sarajensen
Download Presentation

CSC 453 Database Technologies

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. CSC 453 Database Technologies Tanu Malik DePaul University

  2. Course Overview • Introduction • Relational Model-Concepts • Relational Model-Implementation • SQL

  3. Why take this course? • The digital world runs on data • Data must quickly lead to information/ knowledge. • Loss, corrupt, compromised, or mismanaged data can cost dearly • Equifax data breaches • Silent data corruption every 10-20 minutes (1 bit-error every 10 to 20 TB stored) • Theft and stolen data • Data management jobs are high in demand

  4. What is a database? • A collection of persistent related pieces of data Course Database "CID" "COURSENAME" "DEPARTMENT" "COURSENR" "1020" "Theory of Computation" "CSC" "489" "1092" "Cryptography" "CSC" "440" "3201" "Data Analysis" "IT" "223" "9219" "Databases Systems" "CSC" "355" "3111" "Theory of Computation" "CSC" "389" "8772" "History of Games" "GAM" "206" "2987" "Topics in Digital Cinema" "DC" "270"

  5. Student database "LASTNAME" "FIRSTNAME" "SID" "PROGRAM" "CITY" "STARTED" "Gloria" "Chan" "12300" "COMP-SCI" “Naperville” “2010” "Brennigan" "Marcus" "90421" "COMP-GAM" "Evanston" "2010" "Patel" "Deepa" "14662" "COMP-SCI" "Evanston" "2013"

  6. Storage Options in Computers • CPU Registers-Volatile • Memory-Volatile • Hard disk-Persistent • Most common to store in files

  7. Computing on Files • How to find a particular record? • Find all students who joined later than 2013 • Find all students who live in Chicago • What if two threads try to write to the same file at the same time? • How to ensure that the studentid remains same in all files? • What is data is overwritten?

  8. Issues with Files • Data Integrity • Querying the data • Security • Durability

  9. Database Management Software (DBMS) • A DBMS is software that allows applications to store and analyze information in a database. • A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases. • Database ≠ DBMS

  10. Focus of Course Applications SQL Database Design Database Internals

  11. Learning Objectives • Students will learn the fundamentals of database management systems. • When to use them • How to model data with them • How to store and retrieve information • How to search quickly for information • System internals & key algorithms

  12. Course Plan • Syllabus • Content • Slides only supplement the lecture • Worksheets are trust-based • Assessment • Rules and rights

  13. Using Oracle SQLDeveloper • Connect with information on D2L • Viewing Tables

More Related