TAILIEUCHUNG - Lecture Database Systems - Lecture 17

After completing this chapter, students will be able to: Introduction to database security, discretionary access control (DAC), mandatory access control (MAC), role-based access control (RBAC), encryption & public key infrastructure (PKI), common attacks on databases, SQL injection, challenges of database security. | CSC271 Database Systems Lecture # 17 Summary: Previous Lecture View updatability Advantages and disadvantages of views View materialization Transactions SQL defines transaction model based on COMMIT and ROLLBACK Transaction is logical unit of work with one or more SQL statements guaranteed to be atomic with respect to recovery An SQL transaction automatically begins with a transaction-initiating SQL statement (., SELECT, INSERT) Changes made by transaction are not visible to other concurrently executing transactions until transaction completes Transactions Transaction can complete in one of four ways: COMMIT ends transaction successfully, making changes permanent ROLLBACK aborts transaction, backing out any changes made by transaction For programmatic SQL, successful program termination ends final transaction successfully, even if COMMIT has not been executed For programmatic SQL, abnormal program aborts the transaction Transactions New transaction starts with next transaction-initiating statement SQL transactions cannot be nested SET TRANSACTION configures transaction: SET TRANSACTION [READ ONLY

• Cơ sở dữ liệu
• Database System
• Lecture Database Systems
• Relational databases
• Database design
• Enhanced Entity Relationship
• Database system concepts
• Lecture Database system concepts
• Database systems
• Database languages
• Database system architectures
• Relational database design
• Lecture Database System
• Database system architecture
• File based approach
• Data management systems framework
• Recovery system
• Database architecture
• Database approach
• Database design process
• 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