View Of Data - Introduction to DBMS - Database Management System

TL;DR

This video discusses the levels of data abstraction in DBMS, which include physical, logical, and view levels.

Transcript

click the bell icon to get latest videos from ekeeda hello friends today we will talk about the views of data in three different parts the first part will be the data abstraction part the next part will be the instances and schemas part and the last part will be the abstraction and instance schemas combination now when we talk about ndbms the datab... Read More

Key Insights

• 👤 DBMS involves providing different levels of abstraction to users for accessing and managing data.
• 🫵 There are three levels of abstraction in DBMS: physical, logical, and view.
• 🅰️ Instances represent the actual values of data, while schemas describe the structure and types of data.
• ❓ Different data models, such as relational and entity-relationship models, can be used to represent the relationships between data.
• 👻 Data abstraction allows users to interact with data without needing to understand the underlying complexity.
• 🏪 The physical level of abstraction focuses on how data is stored and maintained in the database.
• 🤝 The logical level of abstraction deals with relationships between data and includes concepts like relations and attributes.
• 🫵 The view level of abstraction provides customized views of the data to different users.

Questions & Answers

Q: What is data abstraction in DBMS?

Data abstraction in DBMS refers to the process of providing different levels of instruction and access to data, including the physical, logical, and view levels.

Q: What is the physical level of abstraction?

The physical level of abstraction in DBMS deals with the lowest level of data abstraction. It includes information on how data is stored and maintained in the database.

Q: What is the logical level of abstraction?

The logical level of abstraction in DBMS focuses on the relationships between data. It includes concepts like relations, attributes, tuples, and data models.

Q: What is the view level of abstraction?

The view level of abstraction in DBMS provides different views of the data to different users. It allows for customizations and restrictions based on user roles and permissions.

Q: What are instances and schemas in DBMS?

In DBMS, instances refer to the actual values of data. Schemas, on the other hand, describe the structure and types of data. Schemas are handled by the database administrator and can be modified, while instances represent specific data values.

Summary & Key Takeaways

• The video explains the concept of data abstraction in DBMS, which involves providing different levels of instruction and access to data.

• There are three levels of abstraction: physical, logical, and view. The physical level deals with how data is stored and maintained, while the logical level focuses on the relationships between data. The view level provides different views of the data to different users.

• The video also covers the concepts of instances and schemas, where instances refer to the actual values of data and schemas describe the structure and types of data.