Database Schema & Data Independence
PDF version of this post also available. to download the click the link given at the end of this post.
Database Schema: - A database schema is the skeleton structure that represents the logical view of the entire database. It defines how the data is organized and how relation among them are associated. Database schema formulates all the constrains that are to be applied on the data.
A database schema defines its entities and the relationship among them. It contains descriptive details of the database which can be described by means of schema diagram. A database schema can be divided into two categories.
I. Physical database schema: - this schema contain to the actual storage of data and its form of storage like files, indices etc. It defines how the data will be stored in a secondary storage.
I. Physical database schema: - this schema contain to the actual storage of data and its form of storage like files, indices etc. It defines how the data will be stored in a secondary storage.
II. Logical database schema: - this schema defines all the logical constrains that need to be applied on the data stored. It defines tables, views and integrality constrains.
Data Independence: - Data Independence can be explained using 3three schema architecture. Data independence refers characteristic of being able to modified schema at one level of the database without altering the schema at next higher level.
There are two types of data independence.
There are two types of data independence.
I. Logical
data independence: - It refers characteristic being able to change
conceptual schema without having to change the external schema. Logical data
independence is used to separate the external level from conceptual view.
Logical data independence occurs at user inference level.
II. Physical data independence:- Physical data independence can be defined as
capacity to change internal schema without having to change conceptual schema.
Physical data independence used to separate conceptual level from internal
level. Physical data independence occurs at the logical interference
level.
PDF of short notes on database schema and data independence
Such a very useful article. Very interesting to read this article. I would like to thank you for the efforts you had made for writing this awesome article
ReplyDeleteData Science Training in Hyderabad
Data Science course in Hyderabad
Data Science coaching in Hyderabad
Data Science Training institute in Hyderabad
Data Science institute in Hyderabad
I appreciate you taking the time and effort to share your knowledge. This material proved to be really efficient and beneficial to me. Thank you very much for providing this information. Continue to write your blog.
ReplyDeleteData Engineering Services
Data Analytics Solutions
Artificial Intelligence Solutions
Data Modernization Services