TAILIEUCHUNG - Lecture Database system concepts - Chapter 1: Introduction

Chapter 1 provides a general overview of the nature and purpose of database systems. This chapter explain how the concept of a database system has developed, what the common features of database systems are, what a database system does for the user, and how a database system interfaces with operating systems. This chapter also introduce an example database application: a banking enterprise consisting of multiple bank branches. | Chapter 1: Introduction Database System Concepts, 5th Ed. ©Silberschatz, Korth and Sudarshan See ­ for conditions on re­use Chapter 1: Introduction s Purpose of Database Systems s View of Data s Database Languages s Relational Databases s Database Design s Object­based and semistructured databases s Data Storage and Querying s Transaction Management s Database Architecture s Database Users and Administrators s Overall Structure s History of Database Systems Database System Concepts ­ 5th Edition, May 23, 2005 1. ©Silberschatz, Korth and Sudarshan Database Management System (DBMS) s DBMS contains information about a particular enterprise q Collection of interrelated data q Set of programs to access the data q An environment that is both convenient and efficient to use s Database Applications: q Banking: all transactions q Airlines: reservations, schedules q Universities: registration, grades q Sales: customers, products, purchases q Online retailers: order tracking, customized recommendations q Manufacturing: production, inventory, orders, supply chain q Human resources: employee records, salaries, tax deductions s Databases touch all aspects of our lives Database System Concepts ­ 5th Edition, May 23, 2005 1. ©Silberschatz, Korth and Sudarshan Purpose of Database Systems s In the early days, database applications were built directly on top of file systems s .

• Cơ sở dữ liệu
• Database system concepts
• Lecture Database system concepts
• Database systems
• Database languages
• Database design
• Relational databases
• Database system architectures
• Relational database design
• Recovery system
• Query optimization
• Transaction state
• Concurrency control
• Data analysis
• Information retrieval
• Parallel databases
• Distributed databases
• Advanced application development
• Advanced data types
• Advanced transaction processing
• Relational model
• Basic query structure
• Dynamic SQL
• Tuple relational calculus
• Entity relationship model
• Application design
• Object­ based databases
• XML applications
• Physical storage media
• Static hashing
• Query processing