Four Fundamental Database Concepts

• Data: Symbolic representations that describe entities and their attributes. ``` Data encompasses various formats including numbers, text, graphics, images, audio, and video in modern computing systems.

• Database: An organized collection of structured information stored persistently in computer systems. ``` Database characteristics include persistent storage, structured organization, and shared accessibility.

• Database Management System (DBMS): Core software that manages data storage, retrieval, and maintenance operations. ### Primary DBMS Functions:

  1. Data Definition: Provides Data Definition Language (DDL) for specifying database structure and object composition
  2. Data Organization and Storage: Manages data classification, storage structures, data dictionaries, and access paths
  3. Data Manipulation: Offers Data Manipulation Language (DML) for querying, inserting, updating, and deleting records
  4. Transaction Management: Ensures data consistency, security, integrity, concurrent access control, and system recovery
  5. Database Maintainance: Handles database creation, optimization, and ongoing management
  6. Additional Capabilities: Includes network communication, data conversion, and interoperability between heterogeneous systems

• Database System: Complete environment comprising database, DBMS, applications, and database administrators for comprehensive data management.

Evolution of Data Management

Data management involves classification, organization, encoding, storage, retrieval, and maintenance of information.

Three Historical Stages:

1. Manual Management: No persistent storage, application-managed data, limited sharing, and no data independence
2. File System Era: Long-term storage via file systems, but poor sharing capabilities, high redundancy, and weak data independence
3. Database System Era: Supports multi-user, multi-application data sharing with enhanced service capabilities

Database System Characteristics:

• Structured data organization
• High data sharing with minimal redundancy and easy extensibility
• Strong data independence (physical and logical)
• Unified management providing security, integrity, concurrency control, and recovery

Data Modeling

Data models abstract real-world data characteristics for description, organization, and manipulation.

Model Classification

• Conceptual Models: User-focused data representation for database design
• Logical Models: Computer-oriented implementations including hierarchical, network, relational, object-oriented, and semi-structured models
• Physical Models: Low-level abstractions describing internal storage structures and access methods

Ifnormation World Concepts

• Entity: Distinct, identifiable objects in the real world
• Attribute: Characteristic properties of entities
• Key: Attribute set that uniquely identifies entities
• Entity Type: Abstract representation of entity classes using names and attribute collections
• Entity Set: Collection of entities sharing the same type
• Relationship: Connections between entity attributes and across different entity sets

Entity relationships include one-to-one, one-to-many, and many-to-many associations.

Conceptual modeling method: Entity-Relationship (E-R) approach

Data Model Components

Data models consist of data structures, operations, and integrity constraints.

Primary Logical Data Models

Hierarchical Model

• Structure: Single root node with each child having exactly one parent
• Operations: Query, insert, delete, update with parent-child dependency constraints
• Advantages: Simple structure, efficient queries, good integrity support
• Disadvantages: Limited non-hierarchical relationship representation, parent-dependent queries, procedural commands

Network Model

• Structure: Multiple parent nodes allowed, flexible relationship mapping
• Operations: Flexible constraints with system-specific limitations
• Advantages: Direct real-world representation, high performance
• Disadvantages: Complex structure, challenging implementation

Relational Model

• Structure: Normalized two-dimensional tables
• Operations: Query, insert, delete, update with relational integrity constraints
• Advantages: Mathematical foundation, simple structure, high data independence, security
• Disadvantages: Potentially lower query efficiency than formatted models

Database System Architecture

Database models distinguish between type (structure and attribute definitions) and value (specific instances).

Schema Concepts

Schema represents the logical structure and characteristics of entire database data.

Three-Level Architecture

1. Conceptual Schema: Global logical structure and data characteristics, common data view for all users
2. External Schema: User-specific logical structure, localized data view for application requirements
3. Internal Schema: Physical storage structure and organization methods, single instance per database

Data Independence Through Mapping

Two-level mapping between schemas ensures logical and physical data independence:

• External/Conceptual Mapping: Translates between global and local logical structures
• Conceptual/Internal Mapping: Defines correspondence between logical and physical structures, enabling physical changes without affecting applications

Database System Components

Hardware Requirements

Sufficient memory, disk storage, and high-throughput channels for efficient data transfer rates.

Software Components

• Database Management System
• Operating System supporting DBMS operations
• High-level languages with database interfaces
• Application development tools centered around DBMS
• Specialized database applications

Human Resources

• Database Administrators
• System Analysts and Database Designers
• Application Programmers
• End Users accessing through application interfaces (browsers, menus, forms, reports)