What is data Abstraction in DBMS?


 

Well, the answer to all these questions is Data Abstraction in DBMS. With the help of data abstraction, developers customize what you can view and what other users can view on the website or application.

If you are a budding developer, data abstraction is one such concept that you must not miss out on.

Therefore, we have come up with a complete guide on what is data abstraction in DBMS, how to use it and why you need it.

What Is Data Abstraction?

Data abstraction is a process to hide irrelevant data from the user or system. The main motive behind this process is to provide different views and implement data independence. Data abstraction is generally used to boost the security of the data and makes it simpler to work with complex databases.

The main purpose of using data abstraction is to divide the given problem into smaller subproblems so as to easily manage the data. It keeps irrelevant data or information hidden from the user to make things and applications more user-friendly.

What Are The Levels Of Data Abstraction In DBMS?

Apart from making complex data structures easier, major goal of using data abstraction is to increase the efficiency of the system. To achieve this efficiency, developers use three types of abstractions which include:

  • Internal Schema
  • Logical Level
  • View Level

Here, we will discuss each of these methods in detail.

Internal Schema

This level of abstraction is also called the physical level in which the exact location of the given data is determined. In simpler terms, this level explains the location where actual data is present in the system.

This includes multiple things including; the drive in which data will be stored, the location of the storage, the number of data fragments and other things that the database administrator decides.

It depends on the administrators to decide the distribution of the data. However, when you view the data, it will be available in the table file and stored in the form of a file in your system. It is the administrator’s choice in which way he wishes to use the data present at this level.

Logical Level

Another level of data abstraction in DBMS is the intermediate and logical level which explains the type of data present in the system. This level is called the conceptual level which explains the relationship between the data present in the table continue reading...

Comments

Post a Comment

Popular posts from this blog

What is the AGGRCOW Problem?

Image
Aggressive cow problem is a tough nut to crack in programming as well as your real life!! This is one of the most advanced problems related to the application of binary search. The aggressive cow question is therefore generally every interviewer’s favorite. This is because to solve this problem, you need to know the basic application and concept of binary search. But how do you actually resolve the  aggressive cows problem ? Well, the answer is obvious: Using Binary Search!! Still not sure how to find the solution? Stick to this post to learn.  Here is everything you need to know about the  aggressive cows  problem and its solution.    The Problem Statement Before understanding the solution to the problem, let’s first understand the problem statement. The problem statement goes like this: John, the farmer, has constructed a new barn consisting of N stalls. He has built all these stalls in a single line X. In his barn, he has a C number of cows. His cow...
Read more

Advantages and Limitations of Using Recursion in Programming

Image
Recursion is a popular programming technique that allows functions to call themselves to solve a problem. It is widely used in many programming languages and has its advantages and limitations. In this essay, we will explore both the advantages and limitations of using recursion in programming. Recursion is a powerful programming technique that involves a function calling itself until a certain condition is met. There are several advantages of using recursion in programming: Simplifies complex problems: Recursion is often used to simplify complex problems by breaking them down into smaller, more manageable sub-problems. This makes it easier to understand and solve the problem at hand. Reduces code complexity: Recursive functions can be used to write elegant and concise code by reducing the need for repetitive code blocks. Recursive solutions can often be shorter and more concise than iterative types of sorting . Easy to read and understand: Recursive solutions can be very easy to re...
Read more

How to use Python code online?

Image
Python is a much-appreciated general-purpose programming language. It is utilized in various industries, including web development, machine learning, and desktop applications.  Luckily, the language Python has an easy-to-use syntax suitable for beginners. This makes Python an excellent language for novices to learn.  In this blog article, all of Python's fundamental concepts will be covered. You will feel confident using a  Python online compiler  to create projects. Let’s get started! About Python Python is one of the most used programming languages in modern-day, created by Guido van Rossum and released to the public in 1991. The public has free access to the source code for Python using a Python online compiler, and there are no restrictions on how it may be used or distributed, including for profit.  Practically anything may be produced with it for web development, including online web apps, mobile applications, tools, machine learning, data analytics, and m...
Read more