1 / 21

Introduction to Database Systems

This course provides an introduction to database systems, covering topics such as data abstraction, database management systems, data reliability, data efficiency, and how to study database systems. It also includes examples of real-world database systems and hands-on exercises and projects.

bdoris
Download Presentation

Introduction to Database Systems

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. 数 据 库 系 统 阮 树 骅 Database Systems Shuhua Ruan 13708090854 ruanshuhua@cs.scu.edu.cn http://cs.scu.edu.cn/~database/Database School of Software,Sichuan University

  2. Preface  What is “A Database”?  What is “A Database-Management System” ?  What is “A Database System”?  Why to Study “Database Systems” ?  How to Study “Database Systems” ?  Book  Course Plan  References 数 据 库 系 统 阮 树 骅 School of Software,Sichuan University

  3. Preface  What is “A Database”? 1) Data Data are raw facts that describe people, objects and events. 2)A Database (DB) An integrated collection of related data -- related data: The data represent logically coherent facts about some aspects of the real world. -- integrated: The data for multiple applications are stored together and manipulated in a uniform way on a secondary storage such as a magnetic or an optical disk. To support information sharing 数 据 库 系 统 阮 树 骅 School of Software,Sichuan University

  4. Preface  What is “A Database-Management System”? a collection of programs that controls a database -- to create, maintain, and manipulate databases -- to maintain database integrity and security -- concurrency control under multiple users -- recovering or restoring database 数 据 库 系 统 阮 树 骅 School of Software,Sichuan University

  5. Preface  What is “A Database System”? A software system -- to store, access, modify, manage and manipulate data -- to support the operations of a specific organization or a specific set of applications 1) an application specific database 2) A DBMS that maintains the database 3) the application software that manipulates the database 数 据 库 系 统 阮 树 骅 School of Software,Sichuan University

  6. 数 据 库 系 统 阮 树 骅 School of Software,Sichuan University

  7. Preface  Why to Study “Database Systems” ? 1) Database management is a central component of a modern computing environment 2) Knowledge about database systems has become an essential part of an education in computer science 数 据 库 系 统 阮 树 骅 School of Software,Sichuan University

  8. Preface  Why to Study “Database Systems” ? The approach characteristics to data storage and manipulation: 1) Data abstraction with high-level, conceptual representations of the data -- a table in relational DBMSs -- an object in object-oriented or object-relational DBMSs data together with operations program-data independence and program-operation independence 数 据 库 系 统 阮 树 骅 School of Software,Sichuan University

  9. Preface  Why to Study “Database Systems” ? The approach characteristics to data storage and manipulation: 2) Reliability -- enforcing integrity constraints the meaning (or, the semantics) of the data data type constraints primary key constraints (uniqueness) unique key constraints (uniqueness) foreign key constraints (referential integrity) check constraints (domain integrity) 数 据 库 系 统 阮 树 骅 School of Software,Sichuan University

  10. Preface  Why to Study “Database Systems” ? The approach characteristics to data storage and manipulation: 2) Reliability -- ensuring data consistency When, for whatever reason, the system fails, DBMSs still guarantee data consistency. A DBMS rolls back all interrupted transactions, obliterating their updates from the database, restoring the database to the consistent state in which it existed just prior to the interruption. 数 据 库 系 统 阮 树 骅 School of Software,Sichuan University

  11. Preface  Why to Study “Database Systems” ? The approach characteristics to data storage and manipulation: 3) Efficiency -- efficient space utilization by storing each data item only once -- efficient access to data by eliminating the need of multiple updates to keep the replicas consistent and up-to-date -- enhance the performance of queries by means of optimizations -- decrease response time of transactions by allowing multiple users to access the database concurrently 数 据 库 系 统 阮 树 骅 School of Software,Sichuan University

  12. Preface  How to Study “Database Systems” ? Theory and Practice Exercises and Project The fundamental concepts of database management -- database design -- database languages -- database-systems implementation -- database-systems management 数 据 库 系 统 阮 树 骅 School of Software,Sichuan University

  13. Preface  Book Thomas M. Connolly, et al. Database Systems: A practical approach to Design, Implementation, and Management 4th Edition ISBN: 0321210255 Addison-Wesley 2004 or 2001 数 据 库 系 统 阮 树 骅 School of Software,Sichuan University

  14. Preface •  Course Plan -- The contents • Examples of Database Systems • A Library System • An E-Commerce System • 2) Relational Databases • Key Concepts • Relational Operations • QBE(Query By Example) 数 据 库 系 统 阮 树 骅 School of Software,Sichuan University

  15. Preface  Course Plan -- The contents 3) Basic SQL SQL DDL SQL DML 4) Advanced SQL Views Integrity Constraints in SQL Access Control Embedded SQL 数 据 库 系 统 阮 树 骅 School of Software,Sichuan University

  16. Preface  Course Plan -- The contents 5) Web Databases Web Database Applications HTTP and HTML Forms JDBC (Java DataBase Connectivity) Java Servlets Java Server Pages JavaBeans MVC Architecture (Model-View-Controller) 数 据 库 系 统 阮 树 骅 School of Software,Sichuan University

  17. Preface  Course Plan -- The contents 6) Database Design Database System Design Entity-Relationship Models Normalization 7) Transaction Management Transaction Support Concurrency Control Protocols Database Recovery Programming With Transactions 数 据 库 系 统 阮 树 骅 School of Software,Sichuan University

  18. Preface  Course Plan -- The contents 8) Indexes Database Storage and Query Performance Hash Files Indexes Query Optimization and Index Choice 9) Current Trends Object Relational Models Data Warehousing OLAP and Data Mining 数 据 库 系 统 阮 树 骅 School of Software,Sichuan University

  19. 数 据 库 系 统 阮 树 骅 Preface  Course Plan -- The exercises and project -- Multiple-Choice Quiz 1 – 9 (10 marks) -- Exercise 1 – 10 (20 marks) -- project (40 marks) School of Software,Sichuan University

  20. Preface  Course Plan -- The exams -- Exam 1 (10 marks) (the fifth week) SQL/Set Theory/Relational Query -- Exam 2 (10 marks) (the tenth week) ER-Modeling/Normalization -- Exam 3 (10 marks) (the fifteenth week) Transactions/Index/Project 数 据 库 系 统 阮 树 骅 School of Software,Sichuan University

  21. Preface  References • Microsoft SQL Server 2000 Database Design and Implementation （光盘） • DB2 基础教程，李志伟 编著，清华大学出版社，2003年12月。 • Oracle 9i 中文版 入门与提高，赵松涛 编著，人民邮电出版社， 2003年4月。 数 据 库 系 统 阮 树 骅 School of Software,Sichuan University

More Related