Synonyms
Database schema; DBMS
Definition
These concepts were developed to separate the database schema that the users and programmers see from the storage details and indexing methods of the database and are best explained using the database architecture known as the three-schema architecture. This architecture assumes that there are database schemas or descriptions at three levels: (1) the user view level, which describes a portion of the database for a particular class of users; (2) the conceptual schema, which describes a whole database in a representational data model such as the relational model or the object model; and (3) the internal schema, which describes the storage structures and indexing methods that describe the database files. Physical data independence is defined as the capability to change the internal schema (storage structures/indexes) without having to change the conceptual schema. Logical database independence is defined as the capability to change the conceptual...
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsRecommended Reading
Elmasri R, Navathe S. Fundamentals of database systems. 7th ed. Pearson; 2016.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Elmasri, R. (2018). Logical and Physical Data Independence. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_80651
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_80651
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering