tailieunhanh - Database Management Systems: Chapter 0 - An Overview of a Database Management System

Database Management Systems: Chapter 0 - An Overview of a Database Management System includes about What is a DBMS? DBMS Capabilities, Data-Definition Language Commands, Answering the query, Buffer manager, Transaction processor’s tasks. | Course: Database Management Systems Credits: 3 Prepared by: Assoc. Prof. Dr. Duong Tuan Anh Faculty of Computer Science & Engineering HoChiMinh City University of Technology Vietnam National University of HoChiMinh City References [1] R. Elmasri, S. R. Navathe, Fundamentals of Database Systems- 4th Edition, Pearson- Addison Wesley, 2003. [2] H. G. Molina, J. D. Ullman, J. Widom, Database System Implementation, Prentice-Hall, 2000. [3] H. G. Molina, J. D. Ullman, J. Widom, Database Systems: The Complete Book, Prentice-Hall, 2002 [4] A. Silberschatz, H. F. Korth, S. Sudarshan, Database System Concepts –3rd Edition, McGraw-Hill, 1999. Course Outline 1. Overview of a DBMS 2. Disk Storage, File Structures and Hashing 3. Indexing Structures 4. Query Processing 5. Transaction Processing 6. Concurrency Control 7. Recovery Techniques Three parts Storage management: how secondary storage is used effectively to hold data and allow it to be accessed quickly Query processing: how queries | Course: Database Management Systems Credits: 3 Prepared by: Assoc. Prof. Dr. Duong Tuan Anh Faculty of Computer Science & Engineering HoChiMinh City University of Technology Vietnam National University of HoChiMinh City References [1] R. Elmasri, S. R. Navathe, Fundamentals of Database Systems- 4th Edition, Pearson- Addison Wesley, 2003. [2] H. G. Molina, J. D. Ullman, J. Widom, Database System Implementation, Prentice-Hall, 2000. [3] H. G. Molina, J. D. Ullman, J. Widom, Database Systems: The Complete Book, Prentice-Hall, 2002 [4] A. Silberschatz, H. F. Korth, S. Sudarshan, Database System Concepts –3rd Edition, McGraw-Hill, 1999. Course Outline 1. Overview of a DBMS 2. Disk Storage, File Structures and Hashing 3. Indexing Structures 4. Query Processing 5. Transaction Processing 6. Concurrency Control 7. Recovery Techniques Three parts Storage management: how secondary storage is used effectively to hold data and allow it to be accessed quickly Query processing: how queries expressed in a very high-level language such as SQL can be executed efficiently Transaction management: how to support transactions. Chapter 0 An Overview of a Database Management System Course: Database Management Systems What is a DBMS? The power of database comes from a body of knowledge and technology that has developed over several decades and is embodied in a specialized software called a database management system, or DBMS. A DBMS is a powerful tool for creating and managing large amount of data efficiently and allowing it to persist over long periods of time safely. DBMS Capabilities The capabilities that a DBMS provides the user are: Persistent Storage. A DBMS supports the storage of very large amounts of data that exists independently of any processes that are using the data. Programming Interface. A DBMS allows the user to access and modify data through a powerful query language. Transaction management. A DBMS supports concurrent access to data, ., .