What is Data Independence? DBMS System Architecture

Welcome back MechanicaLEi, did you know that Data independence is the type of data transparency that matters for a centralized DBMS? This makes us wonder, What is Data Independence? Before we jump in check out the previous part of this series to learn about what a Database Management System is? Now, Data independence refers to the immunity of user applications to changes made in the definition and organization of data. It is essential because Application programs should not be exposed to details of data representation and storage. There are two types of Data independence: First is the Logical data independence which is the ability to change the Logical schema without changing the user point of view. For example, the addition or removal of new entities, attributes, or relationships to the Logical schema or having to rewrite existing application programs. Second is Physical data independence which, is the ability to change the physical schema without changing the logical schema. For example, a change to the internal schema, such as using different file organization or storage structures or storage devices should be possible without having to change the conceptual or external schemas. The design of a DBMS depends on its architecture. A 3-tier architecture is the most widely used architecture to design a DBMS and as the name suggests, consists of the following three tiers: First is the Database Tier − At this tier, the database resides along with its query processing languages and their respective relations. Second, comes the Application Tier. This tier holds the application server and the programs that access the database. End-users are unaware of any existence of the database beyond the application tier. At the other end, the database tier is not aware of any other user beyond the application tier. Finally comes the User Tier. All End-users operate on this tier. At this tier, multiple views of the database can be provided by the application. All views are generated by applications that reside in the application tier. Hence, we first saw what Data Independence is and then went on to see what DBMS System Architecture is?
In the next episode of MechanicaLEi find out what Database Modelling is?

Attributions:

[MechanicalEI]

Hey MechanicaLEi,
Check out this video of what Data Independence and what DBMS System Architecture is and then let me know what you think.

[krishnamohan]

Awesome man, understand concept in under 3 minutes thank you

[glezelsabanal]

The animation is interesting and the topic is also well explained.

[THERAWstudiosproductions]

It will be a bit more nice if you change the background image

[karanamnaveen]

All the best u can achieve gd results in some days