• Home
  • Subscribe
  • Contribute Us
    • Share Your Interview Experience
  • Contact Us
  • About Us
    • About CSEStack:
    • Campus Ambassador
  • Forum & Discus
  • Tools for Geek
  • Campus Ambassador
  • LeaderBoard
CSEstack

What do you want to Learn Today?

  • Programming
    • C/C++
    • Python
    • Java
    • HTML CSS
    • SQL
  • CSE Subject
    • Compiler Design
    • Computer Network
    • COA
    • Data Structure
    • DBMS
    • Operating System
    • Theory of Automata
    • Web Technology
  • Linux
  • Trend
    • Artificial Intelligence (AI)
    • Big Data
    • Cloud Computing
    • Machine Learning (ML)
  • GATE CSE 2020
    • Self Study Plan
    • Complete Syllabus
    • FREE Test Series
    • Topper Interview (AIR 15)
    • Recommended Books by Topper
  • Career
    • Placement Interview
    • Jobs
    • Aptitude
    • Quiz
  • Material
    • Recommended Books
    • Software Installation
  • Contribute to Us
    • Write for Us
    • Submit Source Code or Program
    • Share Interview Experience
  • Tools

9 Advantages of Database Management System over File System

Aniruddha Chaudhari/07 Apr, 16/38310/14
CSE SubjectDBMS

In an earlier post, we have seen, how the industry is going to be data-driven and what are the types of programmer needs for software developer jobs in the future. In this post, advantages of database management system over file system have been proposed.

To provide the backbone for any application needs the huge collection of data. That comes with database management system.

In early era, data was used to be saved in a simple text file. There is main disadvantage of using a file system to store the data. We can not structure the data. Data becomes too verbose and cluttered.

Today large scales of databases are available such as IBM DB2, Oracle, SQL. With these databases, data processing, and data manipulation has become so much easy.

9 Advantages of Database Management System over File System:

#1 Concurrency

In the file system management, there is no such control over Multi-user access to data. Concurrent updates may lead to data corruption. In modern Database Management System, we can concurrently access data.

#2 Rich Query Set:

To work on database content, there is database language. It provides rich query set to manipulation database contents.

Ex in SQL language:

select * from <table_name> //to read the data from SQL database

insert into <table_name>// to insert data in SQL database

Select SQL query is used to retrieve the data from the database which comes with the rich query set as aggregate functions, filters and order by clause.

#3 Indexing:

Internet of Things implies collecting data to drive physical devices without human interaction. Behavioral data is getting collected for Artificial Intelligence. Collecting data and searching particular information in this huge amount of data has become the tedious job.

To address this issue, data indexing is very much useful.

Indexing is the process of ordering database entries. It helps to improve the speed of data retrieval operations. Indexing makes search quicker. It is one of the advantages of database management system over the file system.

#4 Transaction:

The transaction is the sequence of operations to be carried out in a single logical work unit. To preserve the reliability of data, the database must ensure ACID properties. ACID stands for Atomicity, Consistency, Isolation and Durability.

  • Atomicity: It ensures, all or none of operations to be executed in a single logical unit of work.
  • Consistency: State of the database system should be same, before starting the transaction and after completion of the transaction.
  • Isolation: If there is multiple transactions are executing, one transaction should not interfere in other transaction.
  • Durability: Database must ensure all the changes to be saved after completion of the transaction.

You can read detail about ACID properties with real world example.

With these ACID properties on transactions, it is easy to apply complex updates safely. It adds one more point to be considered for advantages of database management system.

#5 Privileges:

It may lead to security issues if we allow admin privileges to all database user. One of the main advantages of Database Management System is that it has a provision to give different privileges to the different users.

The database administrator can have all the privileges to insert into, update and delete the database. The database administrator is supposed to give privileges to other database users. For the end user, accessing data can be allowed but updating a database.

#6 Remote data access:

Online shopping has become the fad. Apps are getting rolling out. Everything is getting online. Data has been accessed remotely.

Simple data access queries for Database Management System provides data access easy and simple. With simple plugin or command, data can be accessed by online websites or apps.

#7 Client Supportive:

Users or clients can embed database queries regardless of whatever programming languages they are using.

Suppose client want to provide online services through the website as well as mobile application. The database queries do not depend on computer programming language. So a single database can be used for both the platforms.

#8 Database management tools:

There are lots of database management tools are available. It is lagging in earlier file system data management.

  • Database backup is important. It ensures availability of stable database in case if data gets corrupted.
  • Data replication is required for faster availability of database in the various regional areas.
  • Suppose there are large numbers of user accessing data. Load balancing reduces the load on a particular database by sharing a load among all the replicated databases.
  • Ther is a need to prevent unwanted data access. So database monitoring and security has become biggest concern.

#9 Scalability:

Last but not the least one of the advantages of database management system is database scalability.

To address every business requirement to store data, there is an availability from small scale to large scale databases. Today almost every apps and online services are using database management system.

These are advantages of database management system over the file system. For the same reason, database management system has evolved. Today it is used everywhere than File System. If you have any question or do you want to suggest any point, use the comment section below to write.

databaseDBMS

Related Posts

CSE SubjectDBMS

7 Different Types of Database Keys Explained with Example

CodeCSE SubjectDBMSSQL

Difference Between CHAR and VARCHAR and VARCHAR2

CSE SubjectDBMS

Different Types of Read-Write Conflict in Database [Explained with Example]

Aniruddha Chaudhari
I am complete Python Nut, love Linux and vim as an editor. I hold Master of Computer Science from NIT Trichy. I dabble in C/C++, Java too. I keep sharing my coding knowledge and my own experience on CSEstack Portal.

Comments

  • Reply
    Pavan Dehadre
    April 14, 2016 at 12:35 am

    Well written and easy to understand difference

    • Reply
      Aniruddha Chaudhari
      June 1, 2017 at 3:48 am

      Thanks Pavan!

  • Reply
    Pranita Venki
    April 16, 2016 at 9:41 pm

    Nice post.

    • Reply
      Aniruddha Chaudhari
      June 1, 2017 at 3:49 am

      Glad you like it.

  • Reply
    Shena Tambe
    April 19, 2016 at 2:53 pm

    Good stuff, Thanks for sharing

    • Reply
      Aniruddha Chaudhari
      June 1, 2017 at 3:51 am

      Thanks for your positives vibes.

  • Reply
    Samuals Staphen
    April 29, 2016 at 9:28 pm

    Thanks for elaborating this topic. Good difference and some clear points to understand. Well done!

    • Reply
      Aniruddha Chaudhari
      June 1, 2017 at 3:50 am

      Hey Samuals,

      You are welcome.

  • Reply
    Oluwa Malwiy
    September 25, 2017 at 2:52 pm

    Well done sir may ALMIGHTY GOD CONTINUE TOO STRENGTH YOU AND GIVE YOU MORE WISDOM, KNOWLEDGE, AND UNDERSTANDING. AMEN.

    • Reply
      Aniruddha Chaudhari
      February 3, 2018 at 11:00 am

      This means a lot to me. Thanks for all your best wishes, Oluwa.

  • Reply
    Palab
    August 3, 2018 at 12:44 am

    Simple to understand. thanks

    • Reply
      Aniruddha Chaudhari
      August 3, 2018 at 9:27 am

      Thanks, Palab. I am glad knowing as it adds value for your better understanding.

  • Reply
    Thabisi Mothupi
    November 14, 2018 at 9:45 am

    Very clear, um going to write computer test today, and if this topic may appear I am going to master it. Thank you sir

    • Reply
      Aniruddha Chaudhari
      November 15, 2018 at 8:54 am

      That’s really great, Thabisi. Best wishes for your test!

Leave a Reply Cancel reply

Interview Experiences

AccentureAgriChain Akamai Amazon Amdocs American Express Attra Infotech BARC Barclays BlockGrain BYJUS Cisco Cognizant Coupon Dunia Credit Suisse DE Shaw Druva Experis IT Eze Software Factset Fiorano General Electric Incture Technologies Infosys Kasmo Cloud Microsoft MindTree Mu Sigma Numerify Opteamix Oracle Persistent Pole to Win Qualcomm Reliance Riverbed Syntel TCS Tech Mahindra Teradata Terralogic Virtusa Wipro

Interview Questions



You can share your interview experience.

Don’t Miss !

Latest Articles

Cisco Online Test Pattern and Interview Questions for Freshers


[7 Best Tips] How to Make Daily Study Timetable and Stick to It?


Persistent Written Test and Technical Coding Questions [Paper Pattern]


10 Top Website Design Tips for Small Business to Boost Up Your Sales


Main Difference Between remove del and pop in Python List


Tech Mahindra Placement (Online Test | Essay Writing | Interview Questions)


Importance of Career Exploration for High-School Students | Why?


Favorite Topic

AI algorithm array bigdata bit manipulation career Code Computer Network cpp data analytics database data scientist Data Structure db DBMS difference between Django education GATE GATE Topper Interview HTML ibm IBM ISDL interview IP address Java JavaScript Jobs Linked List linux linux cmd nit OOPs Concept os Programming Python python list Qualcomm SOAP sorting stack string vim webbrowser web development

Contribution to Community

  • Contribute to CSEstack Portal
  • Submit Your Source Code or Program
  • Share Your Interview Experience
  • CSEStack Leadership Board
  • Campus Ambassador Program by CSEstack

About CSEstack Portal

  • About CSEStack:
  • Contact Us
  • CSEStack Campus Ambassador
  • Recommended Books by Expert

© 2019 – CSEstack.org. All Rights Reserved.

  • Home
  • Subscribe
  • Contribute Us
    • Share Your Interview Experience
  • Contact Us
  • About Us
    • About CSEStack:
    • Campus Ambassador
  • Forum & Discus
  • Tools for Geek
  • Campus Ambassador
  • LeaderBoard