TAILIEUCHUNG - Database Systems: Lecture 5 - Nguyen Thanh Tung

Database Systems: Lecture 5 - Relational Algebra presents about Relational Algebra (Unary Relational Operations, Relational Algebra Operations from Set Theory, Binary Relational Operations, Additional Relational Operations), Brief Introduction to Relational Calculus. | Relational Algebra Outline Relational Algebra Unary Relational Operations Relational Algebra Operations from Set Theory Binary Relational Operations Additional Relational Operations Brief Introduction to Relational Calculus Reading: [1]: Chapter 6 Relational Algebra Overview Relational algebra is the basic set of operations for the relational model These operations enable a user to specify basic retrieval requests (or queries) The result of an operation is a new relation, which may have been formed from one or more input relations This property makes the algebra “closed” (all objects in relational algebra are relations) A sequence of relational algebra operations forms a relational algebra expression The result of a relational algebra expression is also a relation that represents the result of a database query (or retrieval request) Relational Algebra Overview Relational Algebra consists of several groups of operations Unary Relational Operations SELECT (symbol: .

• Cơ sở dữ liệu
• Database Systems
• Relational Algebra
• Brief Introduction to Relational Calculus
• Unary Relational Operations
• Relational Algebra Operations from Set Theory
• Binary Relational Operations
• 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 approach
• Database management systems
• Lecture Database management systems
• File based system
• Characteristics of the database
• Data dictionary
• Database integration
• Schema matching
• Fundamentals of database systems
• 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
• Database users
• Database applications
• Typical DBMS functionality
• 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