Database Management System and SQL
Database Management System and SQL
  • Database Management System and SQL
  • Database
    • Introduction to Database
      • Definition
      • File System
      • Different types of Database
      • Uses of DBMS
      • Basic Terms in Database
      • Query Language
    • View of Data
      • Data Abstraction
      • Schema & Instance
      • Data Models
    • Database Architecture
      • DBMS Tier Architecture
      • Three Schema Architecture
      • Data Independence
    • Relational Database Management System (RDBMS)
      • Entity-Relationship (ER) Model
      • Attributes
      • Keys
      • Relationship
    • Functional Dependencies
    • Normalization
  • MySQL
    • Terminology
    • Database Statements
    • Table
      • Data Type
      • Create
      • Show
      • Describe
      • Drop
      • Alter
      • Auto Increment
      • Index
    • Insert
    • Select
      • Condition
      • Aggregate Functions
      • Join
    • View
    • Delete
    • Update
    • MySQL Constraints
      • NOT NULL
      • DEFAULT
      • CHECK
      • UNIQUE
      • PRIMARY KEY
      • FOREIGN KEY
Powered by GitBook
On this page
  • Data Independence
  • Data Independence Classification
  • Logical Data Independence
  • Physical Data Independence

Was this helpful?

  1. Database
  2. Database Architecture

Data Independence

Data Independence

  • Data independence is explained using the three-schema architecture.

  • It is the characteristic of being able to modify the schema at one level of the database system without altering the schema at the next higher level.

Data Independence Classification

  • Logical Data Independence

  • Physical Data Independence

Logical Data Independence

  • It is the capacity to change the conceptual schema without having to change the external schema.

  • It separates the external level from the conceptual level.

  • Any changes in the conceptual view of the data would not affect the user view of the data.

  • Logical data independence occurs at the user interface level.

Physical Data Independence

  • It is the capacity to change the internal schema without having to change the conceptual schema.

  • Any changes in storage size of the database system server would not affect the conceptual structure of the database.

  • It separates conceptual levels from the internal level.

  • Physical data independence occurs at the logical interface level.

PreviousThree Schema ArchitectureNextRelational Database Management System (RDBMS)

Last updated 1 year ago

Was this helpful?