TAILIEUCHUNG - Lecture Fundamentals of database systems: Chapter 1 - Emasri, Navathe

Chapter 1 of lecture Fundamentals of database systems include content: Types of databases and database applications, basic definitions, typical DBMS functionality, example of a database, main characteristics of the database approach, database users, advantages of using the database approach, when not to use databases. | Copyright 2007 Ramez Elmasriand Shamkant B. Navathe e iiTypeso iíDanạbSsesandíDatabaseiiiiiiiiiiiii Types of Databases and Database Applications Basic Definitions Typical DBMS Functionality Example of a Database UNIVERSITY Main Characteristics of the Database Approach Database Users Advantages of Using the Database Approach When Not to Use Databases Traditional Applications Numeric and Textual Databases More Recent Applications Multimedia Databases Geographic Information Systems GIS Data Warehouses Real-time and Active Databases Many other applications First part of book focuses on traditional applications A number of recent applications are described later in the book for example Chapters 24 26 28 29 30 Copyright 2007 Ramez Elmasri and Shamkant B. Navathe lide 1 Copyright 2007 Ramez Elmasri and Shamkant B. Navathe Slide 1-4 Database A collection of related data. Data Known facts that can be recorded and have an implicit meaning. Mini-world Some part of the real world about which data is stored in a database. For example student grades and transcripts at a university. Database Management System DBMS A software package system to facilitate the creation and maintenance of a computerized database. Database System The DBMS software together with the data itself. Sometimes the applications are also included. Copyright 2007 RamezElmasri and Shamkant B. Navathe Slide 1-5 1 Define a particular database in terms of its data types structures and constraints Construct or Load the initial database contents on a secondary storage medium Manipulating the database Retrieval Querying generating reports Modification Insertions deletions and updates to its content Accessing the database through Web applications Processing and Sharing by a set of concurrent users and application programs - yet keeping all data valid and consistent Other features Protection or Security measures to prevent unauthorized access Active processing to take internal actions on data Presentation and .

• Cơ sở dữ liệu
• Database systems
• Fundamentals of database systems
• Database users
• Database applications
• Typical DBMS functionality
• Database approach
• Lecture Database Systems
• Database systems concepts
• Database systems architecture
• Database languages
• Data management systems framework
• Introduction to Database Systems
• Database system concepts
• Entity Relationship model
• Database security
• Distributed database systems
• Principles of distributed database systems
• Cơ sở dữ liệu phân tán
• Parallel database systems
• Load balancing
• Database architecture
• Database management systems
• Lecture Database management systems
• File based system
• Characteristics of the database
• Data dictionary
• Database integration
• Schema matching
• The relational data model
• Database design
• Database programming techniques
• Relational database constraints
• Database System
• Relational databases
• Relational database design algorithms
• Relational database systems
• Computer networks
• Practical Database Design
• Physical Database Design in Relational Databases
• An Overview of Database Tuning in Relational Systems
• Physical Database Design Decisions
• Data models
• Hierarchical model
• Designing a set of relations
• Relational decompositions
• Relational database schema
• Databases and database users
• Relational calculus
• Physical database design
• Concurrency control techniques
• Database recovery techniques
• Distributed databases
• Multivalued dependencies
• Fundamentals of database management systems
• Logical database design
• Object oriented database management
• Data administration
• Design problem
• Dimensions of the problem
• Database development
• Database environments
• Object database management systems
• Object database
• Bài giảng Hệ quản trị cơ sở dữ liệu
• Operating systems
• Attribute alias
• Lecture Database system concepts
• Database system architectures
• Relational database design