【正文】 Database SystemSSD7 Spring, 2022 Tan Changgeng School of Software, Central South University TCGCSU Database Systems ? References ? CMU SSD7 Eresource ? Database system concepts (5th ed.) by Silberschatz, Korth, Sudarshan, 2022,Higher Education Press. ISBN 7040192454 ? 數(shù)據(jù)庫系統(tǒng)概念 （上書中譯本） ， 原著： Silberschatz， 楊冬青譯，機(jī)械工業(yè)出版社 ,ISBN 7111196872 ? Database Systems –A practical Approach to Design , Implementation,and Management(Thomas Connolly,Carolyn Begg,Person Education Inc.), ISBN 7505387847 ? Instructor: Tan Changgeng. Email: :327414529 Offering WorldLeading Curriculum in Computer Programming amp。 Software Systems Development(SSD) TCGCSU Database Systems Two Certificates ? Certificate in Computer Programming ? Courses 1 through 5 ? Certificate in Software Systems Development ? Courses 1 through 10 SSD Curriculum Overview TCGCSU Database Systems iCarnegie Curriculum 15 = Certificate in Computer Programming 110 = Certificate in Software Systems Development 1: Introduction to Information Systems 2: Introduction to Computer Systems 3: Object Oriented Programming and Design 5: Data Structures and Algorithms 6: System Level Programming 10: Software Project Organization and Management 9: Software Specification, Test and Maintenance 8: Networks and Distributed Computing 4 : User Centered Design and Testing 7: Database Systems TCGCSU Database Systems What does iCarnegie do? ? 10 Course Sequence ? Rooted in the expertise of Carnegie Mellon University’s School of Computer Science ? Applied, industryoriented skills ? Software Development Discipline Software Development != Computer Science ? CS trains scientists/researchers ? Focus on Theory ? Higher Mathematics ? Software Developers are not researchers ? Applied, industry oriented skills ? Focus on foundational skills TCGCSU Database Systems The purpose of SSD7 is for students to ? Bee familiar with fundamental DBMS concepts and what a database system is ? Learn to use SQL(structured query language) ? Learn to design database systems ? Learn to design and manage transaction(事務(wù) ) ? Learn to improve query performance ? Gain exposure to future trends in databases TCGCSU Database Systems Students successfully pleting SSD7 will be able to PRODUCE (cont’d) ? Database designs that support a given application ? Data models using ER diagrams ? Sound schema designs using normalization （使用規(guī)范化方法設(shè)計出合理的模式） ? Webbased database applications using SQL and JSP/Servlets TCGCSU Database Systems Students successfully pleting SSD7 will be able to USE ? Index structures of a DBMS to improve performance ? The transaction features of a DBMS to achieve fault recovery(故障恢復(fù) ) and concurrency control (并發(fā)控制 ) ? Key relational operations to manipulate data(操縱數(shù)據(jù) ) ? SQL DDL to model data, constraints, and views(視圖 ) ? SQL DML to write plex queries TCGCSU Database Systems Students will be able to knowledgeably DISCUSS ? The basic concepts of objectrelational and objectoriented database management systems ? The basic concepts and application of data warehousing and data mining (datacubes, OLAP) ? The basic functions and application of multimedia databases ? The basic issues of database privacy and security ? The DBMS offerings of the most important vendors TCGCSU Database Systems Database Prog Distributed Sys OS UI Data Struct amp。 Algorithms 數(shù)據(jù)庫的地位 TCGCSU Database Systems Topics Shall be Learned ? Introduction ? Relational Model ? SQL ? EntityRelationship Model ? RelationalDatabase Design ? Transactions ? Concurrency Control ? Recovery System （ Integrity and Security） ? Database System Architectures ? …… TCGCSU Database Systems Chapter 1: Introduction ? Purpose of Database Systems ? View of Data ? Database Languages ? Relational Databases ? Database Design ? Objectbased and semistructured databases ? Data Storage and Querying ? Transaction Management ? Database Architecture ? Database Users and Administrators ? Overall Structure ? History of Database Systems TCGCSU Database Systems Database Management System (DBMS) ? DBMS contains information about a particular enterprise ? Collection of interrelated data ? Set of programs to access the data ? An environment that is both convenient and efficient to use ? Database Applications? ? Banking: all transactions ? Airlines: reservations, schedules ? Universities: registration, grades ? Sales: customers, products, purchases ? Online retailers: order tracking, customized remendations ? Manufacturing: production, inventory, orders, supply chain ? Human resources: employee records, salaries, tax deductions ? Databases touch all aspects of our lives TCGCSU Database Systems The Examples of Database Systems ? Purchases using your credit card 信用卡 ? A credit card database ? The checkout assistant ? A credit card reader ? Check your credit ? Add the purchases to database ? Monthly statements to each cardholder TCGCSU Database Systems Purpose of Database Systems ? In the early days, database applications were built directly on top of file systems ? Drawbacks of using file systems to store data? TCGCSU Database Systems ? Limitations of the FileBased Approach ? Data redundancy and inconsistency數(shù)據(jù)冗余與非一致性 ? Multiple file formats, duplication of information in different files ? 文件格式不相容， 數(shù)據(jù)冗余 ? Programdata dependence 程序依賴于數(shù)據(jù) ? Need to write a new program to carry out each new task ? Data isolation — multiple files and formats ? 數(shù)據(jù)孤立；文件格式不相容 ? Integrity problems完整性問題 ? Integrity constraints (. account balance