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, ., .

• Cơ sở dữ liệu
• Database Management Systems
• DBMS Capabilities
• Data Definition Language Commands
• Answering the query
• Buffer manager
• Transaction processor’s tasks
• Lecture Database Systems
• Database systems
• Database systems concepts
• Database systems architecture
• Database languages
• Data management systems framework
• Lecture Database management systems
• File based system
• Characteristics of the database
• Data dictionary
• Fundamentals of database management systems
• Logical database design
• Physical database design
• Object oriented database management
• Data administration
• Bài giảng Hệ quản trị cơ sở dữ liệu
• Operating systems
• Attribute alias
• Relational database design
• EER to relational mapping
• Mapping EER model
• Regular entity types
• Database application development process
• Data flow diagrams
• Database design
• Lecture Distributed Database Management Systems
• Distributed Database Management Systems
• Bài giảng Hệ quản trị cơ sở dữ liệu phân tán
• Transaction management
• Database consistency
• Database development
• Relational databases
• Database environments
• Object database management systems
• Object database
• Distributed database systems
• Principles of distributed database systems
• Cơ sở dữ liệu phân tán
• Peer to peer data management
• Peer reference architecture
• Web data management
• Web models
• Entity relationship model
• ER Diagram
• ER model
• Relational model
• Relational data model
• Relational database
• Relation schema
• Database definition
• Commercial applications
• File processing system
• Database architecture
• Data independence
• Conceptual schema
• Physical implementation of the database
• Physical data independence
• Cross reference matrix
• Database modeling
• Entity relationship data model
• Semantic data model
• Conceptual database design
• Data flow diagram
• E R data model
• E R database design
• Mathematical relations
• Normalization summary
• Data processing
• Consistent state of the database
• Transaction terminates
• Transaction boundaries
• Traditional file processing system
• Database approach
• Distributed computing system
• Fragmentation transparency
• Operating system
• Data modeling
• Relational data retrieval
• Relational database model
• Introduction to MIS
• Management Information Systems
• Information systems
• Database applications