Database Systems: Design, Implementation, and Management

Database Systems

• Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

• Database consists of logically related data stored in a single repository
• Provides advantages over file system management approach
• Eliminates inconsistency, data anomalies, data dependency, and structural dependency problems
• Stores data structures, relationships, and access paths in addition to application data

Database vs. File Systems

• Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

• Figure 1.6

Database System Environment

• Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

• Figure 1.7

Database System Types

• Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

• Databases can be differentiated by different factors including:
• Single-user vs. Multiuser Database
• Desktop
• Workgroup
• Enterprise
• Centralized vs. Distributed
• Use
• Production or transactional
• Decision support or data warehouse

DBMS Functions

• Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

• Data dictionary management
• Data storage management
• Data transformation and presentation
• Security management
• Multiuser access control
• Backup and recovery management
• Data integrity management
• Database language and application programming interfaces
• Database communication interfaces