Explore the fundamentals of database systems, including what they are, how they function, and the role of a database management system (DBMS). Learn the essential components, purpose, and principles of databases to enhance your understanding and skills in database development.
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
CSCE-608 Database Systems Spring 2025 Instructor: Jianer Chen Office: PETR 428 Phone: 845-4259 Email: chen@cse.tamu.edu Notes 1: Introduction
What is a Database System? A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. Notes 1
What is a Database System? A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. Notes 1
What is a Database System? A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. Notes 1
Two parts about database purpose Learn how to develop DB (database design) Understand how DB works (database principle)
Two parts about database purpose After the study Learn how to develop DB (database design) Be able to build a DB Understand how DB works (database principle)
Two parts about database purpose After the study Learn how to develop DB (database design) Be able to build a DB Understand how DB works (database principle) Know better about DB
Two parts about database purpose After the study Learn how to develop DB (database design) Be able to build a DB necessary Understand how DB works (database principle) Know better about DB
Two parts about database purpose After the study Learn how to develop DB (database design) Be able to build a DB Help develop better DB necessary Understand how DB works (database principle) Know better about DB
Two parts about database purpose After the study Assuming certain familarity Learn how to develop DB (database design) Be able to build a DB Will give an in-depth review Help develop better DB necessary Understand how DB works (database principle) Know better about DB
Two parts about database purpose After the study Assuming certain familarity Learn how to develop DB (database design) Be able to build a DB Will give an in-depth review Help develop better DB necessary Understand how DB works (database principle) Know better about DB The focus of this course
in tables (relations) lock table DDL language DDL complier database administrator concurrency control file logging & recovery manager transaction manager index/file manager buffer manager DML (query) language query execution engine database programmer DML complier main memory buffers secondary storage (disks) DBMS
in tables (relations) lock table DDL language DDL complier database administrator concurrency control file logging & recovery manager transaction manager Database Design index/file manager buffer manager DML (query) language query execution engine database programmer DML complier main memory buffers secondary storage (disks) DBMS Database development
in tables (relations) lock table DDL language DDL complier database administrator concurrency control file logging & recovery manager transaction manager Database Management System index/file manager buffer manager DML (query) language query execution engine database programmer DML complier main memory buffers secondary storage (disks) DBMS The principle of database systems
Course Description Homework Assignments Homework assignments are to let students test their understanding of the class lectures and practice the techniques and theories studied in the classes. The assignments are due on the designated due dates before the class starts. No late submissions will be accepted. Discuss unusual circumstances in advance with the instructor.
Course Description Homework Assignments Homework assignments are to let students test their understanding of the class lectures and practice the techniques and theories studied in the classes. The assignments are due on the designated due dates before the class starts. No late submissions will be accepted. Discuss unusual circumstances in advance with the instructor. Course Projects There are two course projects. The course projects provide students with opportunities to gain further experience in database development and principle of database systems. Project #1 is due March 21, and project #2 is due April 28.
Course Description Homework Assignments Homework assignments are to let students test their understanding of the class lectures and practice the techniques and theories studied in the classes. The assignments are due on the designated due dates before the class starts. No late submissions will be accepted. Discuss unusual circumstances in advance with the instructor. Course Projects There are two course projects. The course projects provide students with opportunities to gain further experience in database development and principle of database systems. Project #1 is due March 21, and project #2 is due April 28. Examinations There will be a midterm examination on March 7 (taken in class-time) and a final examination on May 5 (8:00 am 10:00 am).
Course Description Textbook H. Garcia-Molina, J. Ullman, and J. Widom Database Systems: The Complete Book, 2nd Ed., Prentice Hall, Upper Saddle River, NJ, 2008. Supplementary reading materials will also be provided.
Course Description Textbook H. Garcia-Molina, J. Ullman, and J. Widom Database Systems: The Complete Book, 2nd Ed., Prentice Hall, Upper Saddle River, NJ, 2008. Supplementary reading materials will also be provided. Grading Homework: 18%, Project #1: 22%, Project #2: 15%, Midterm: 15%, Final: 30%
Course Description Textbook H. Garcia-Molina, J. Ullman, and J. Widom Database Systems: The Complete Book, 2nd Ed., Prentice Hall, Upper Saddle River, NJ, 2008. Supplementary reading materials will also be provided. Grading Homework: 18%, Project #1: 22%, Project #2: 15%, Midterm: 15%, Final: 30% Remark Course materials, including course description, lecture notes, and homework assignments, can be found via the instructor's home page at http://faculty.cs.tamu.edu/chen
Computer for Information Processing General information processing: data are in computer (memory) and users run CPU to process the data. CPU Data in memory 28
Computer for Information Processing General information processing: data are in computer (memory) and users run CPU to process the data. Information processing is involved in four components: CPU Data in memory 29
Computer for Information Processing General information processing: data are in computer (memory) and users run CPU to process the data. Information processing is involved in four components: data structure, Data structure 30
Computer for Information Processing General information processing: data are in computer (memory) and users run CPU to process the data. Information processing is involved in four components: data structure, basic operations Data structure +, , , 31
Computer for Information Processing General information processing: data are in computer (memory) and users run CPU to process the data. Information processing is involved in four components: data structure, basic operations, algorithm Algorithm (ideas) Data structure +, , , 32
Computer for Information Processing General information processing: data are in computer (memory) and users run CPU to process the data. Information processing is involved in four components: data structure, basic operations, algorithm, and programming language Algorithm (ideas) main(); { } Data structure +, , , 33
Computer for Information Processing General information processing: data are in computer (memory) and users run CPU to process the data. Information processing is involved in four components: data structure, basic operations, algorithm, and programming language. Example: programming with Java, C++ etc. Algorithm (ideas) main(); { } Data structure +, , , 34
Database is just another model of information processing Then why study DB? Much more data, regular data techs would be very inefficient: How should data be stored? 37
Database is just another model of information processing Then why study DB? Much more data, regular data techs would be very inefficient: How should data be stored? CPU Data in memory 38
Database is just another model of information processing Then why study DB? Much more data, regular data techs would be very inefficient: How should data be stored? Data 39
Database is just another model of information processing Then why study DB? Much more data, regular data techs would be very inefficient: How should data be stored? Data (in disks) 40
Database is just another model of information processing Then why study DB? Much more data, regular data techs would be very inefficient: How should data be stored? Operations are simpler & more specific: How do we take advantage of it? , , , , , \, , , C Data (in disks) 41
Database is just another model of information processing Then why study DB? Much more data, regular data techs would be very inefficient: How should data be stored? Operations are simpler & more specific: How do we take advantage of it? New programming languages for the above. , , , , , \, , , C Data (in disks) SQL 42
Database is just another model of information processing Then why study DB? Much more data, regular data techs would be very inefficient: How should data be stored? Operations are simpler & more specific: How do we take advantage of it? New programming languages for the above. (ACID) Reliability, security, consistency, currency , , , , , \, , , C Data (in disks) SQL 43
