What Is Data abstraction In DBMS And Data Independence?


 

The complex nature of a database system is known by all. Therefore, it is crucial to perform additional operations to make databases simpler especially if you are working with large and complex databases.

There are multiple methods that you can use to make the DBMS system simpler. One such approach is data abstraction.

The data abstraction in DBMS includes dividing the given database into multiple segments and hiding the data which is not required at every level of the database.

This makes it easy for the user to sort and view the data at each level.

With data abstraction comes data independence!

Most people may get confused when it comes to data abstraction and data independence.

However, The two are generally considered to be the same. Well, that’s not right.

Data independence is nothing but one of the benefits of performing data abstraction. If you are not aware of what these two terms mean or what is the difference between the two, this post will be worth reading.

Let’s check out data abstraction in DBMS and data independence in detail.

Meaning Of Data Abstraction

Data abstraction in DBMS is the procedure of keeping irrelevant information present at each level hidden. It completely depends on the level of abstraction at which information is irrelevant and relevant.

The data abstraction process is crucial when dealing with a larger and more complex DBMS. It will break the given problem into different subproblems and those subproblems become easy to solve and manage.

The Levels Of The Data Abstraction Process

Data abstraction in DBMS is divided into the following three levels read full article...

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