Summary of "DBMS Languages, Interfaces, and Classification"

Main Ideas and Concepts

DBMS Languages
- Data Definition Language (DDL): Used to define schemas (conceptual and internal). It is primarily utilized by database administrators and designers.
- Storage Definition Language (SDL): Specifies the internal schema and mappings between conceptual and internal schemas, used in systems with clear separation of schemas.
- View Definition Language (VDL): Used to define user views and their mappings to the conceptual schema, particularly in a true three-schema architecture.
- Data Manipulation Language (DML): Allows users to manipulate data (retrieve, update, insert, delete). It is classified into:
  - High-Level DML: Also known as set-at-a-time DML, retrieves multiple records in a single statement.
  - Low-Level DML: Also known as record-at-a-time DML, retrieves records one at a time, often embedded in a general-purpose programming language.
DBMS Interfaces
- Menu-Based Interfaces: Users select options from a list of menus.
- Form-Based Interfaces: Users fill out forms designed for novice or parametric users.
- Graphical User Interfaces (GUI): Users interact with a graphical representation of the database schema.
- Natural Language Interfaces: Accept requests in natural language and interpret them to generate high-level queries.
- Parametric User Interfaces: Tailored for users who perform a limited set of operations repeatedly, minimizing keystrokes.
- Database Administrator Interfaces: Provide privileged commands for database administrators to manage the system.
Classification of DBMS
- Based on Data Models:
  - Relational Model: Most popular, representing data as tables (e.g., Oracle, MySQL).
  - Object-Oriented Model: Represents real-world situations as objects with attributes and relationships.
  - Legacy Models: Hierarchical and network models, which are less commonly used due to complexity.
- Based on Number of Users:
  - Single User Systems: Support one user at a time.
  - Multi-User Systems: Support multiple users concurrently.
- Based on Cost:
  - Low Cost: $100 to $3,000.
  - Medium Cost: $10,000 to $100,000.
  - High Cost: Over $100,000.
- Based on Distribution:
  - Centralized Database Systems: Data stored at a single site.
  - Distributed Database Systems: Data distributed across multiple sites connected by a network.