Concept of OOPS and DBMS Architecture

 

Concept of OOPS

1. Class : A class is like a blueprint of data member and functions class is a user-defined data types which holds its own data.
2. Object : An object is a self- contained component which consists of methods and properties to make data useful.
3. Inheritance : Inheritance is a mechanism where the sub or child class inherits the properties and characteristics of super class
4. Encapsulation : Encapsulation is a concept that binds data together and function that manipulate the data and that keeps both safe and outside interence  example: Calculator
5. Abstraction : Abstraction is the concept of oop that "shows" only essential attributes and 'bides' unnecessary information
6. Polymorphism : Polymorphism is a method in an oop that performs different things as per objects, class, which calls it 

DBMS Architecture 

The architecture has three levels :

• External level

• Conceptual level

• Internal level

1. External level :- It also called as view level. This level is called "view" is because several users can view their desired data from this level. The user does it need to know the database schema details such as data structure , table etc. User is only concerned about data which is what is returned back to view level. after it has been fetched from database.

Note: External level is the "Top level" of the three level DBMS architecture.

      2 . Conceptual level : It also called logical level. The whole design of database such as relationship among data schema of data etc. are described in this level.

          Database constraint & security are implemented in this level of architecture. This level is maintain by DSA.

      3 . Internal level : This level is also called known as physical level. This level describe how data is actually storage devices. This level is also responsible for allocation space to the data .This is the lower level architecture .