Characteristics of dbms

This tutorial covers the overview of database management system. In this tutorial author covered introduction of data and database , introduction to database management system, dbms examples, characteristics of dbms, advantages of dbms.

Characteristics of dbms and dbms introduction

What is Data ?

Before introducing the introduction to database management system , advantages of dbms, characteristics of dbms  let us know something about data what is data ? The term data may be defined as a collection of facts which provide information  about something. Data may be in the form of text, table figure graph audio and video. In context of computer world data is processed by computer and it is recorded or store in some suitable form which can be understand by the user. Data can be stored on secondary device like had disk or in primary memory.

Data can be collected stored, processed and it can be manipulated it means we can perform some operation on the data. When data  is processed then it becomes information. Information is nothing but meaningful data.

What is Database ?

Now let us see what actually the database is

Database can be simply defined as a collection of data but here we should keep in mind that this data may be related. So in more accurate way we can say  that database is collection of related data. Database should be organized in a way such that it It should be easy to update , access and manage the database for the user.

What is dbms ?

Now come to the introduction of database managements system . DBMS is a software or set of programs which helps us in the  creation, definition and manipulation of database. DBMS  allow users to store, process and access the data easily. we have lot of advantages of dbms

User interact with dbms by  an interface  generally this interface is a command user interface. You may also say it as a tool which is used by the user to perform the several operation  like creating a database, storing data in the database, updating data, creating tables in the, security. User give the commands on this interface in order to perform these operations. Normally SQL Structured Query Language commands are used on most of the database .

DBMS gives the facility to the user to  protect  the databases used in database management system. It also provide a way so that multiple user can use the same database. Some widely used  dbms in industry are MySql,Oracle,SQL Server ,IBM DB2.

characteristics of dbms

Characteristics of dbms

In this section we will discuss about various features or characteristics of dbms.  Most of the time it is asked in the examination that why we prefer the dbms over the traditional file system or what are the advantages of dbms over traditional file system. So due to some of the following characteristics of dbms it is preferred over traditional file system

1. Way of Storing the data: In database management system data is stored into tables, structure for the table is created initially . This table structure is also known as schema in dbms. Schema in dbms provides the information about various attributes  of name the table , data type of the attribute. DBMS a provide a facility to represent a relationship among the related table.

2. Reduced Redundancy: This is one of the important feature of the dbms that it reduces the redundancy. Here the term redundancy can be seen as  unnecessary repetition or duplicacy of data in database . To reduce the redundancy  DBMS use Normalization concept  which decompose the given table into smaller tables in order to minimize the redundancy. Note that DBMS does not guarantee the 100% removal of the redundancy it can only minimize the redundancy.

3. DBMS support the concurrent access of the database to the multiple users. Multiple users can work on the database at the same time and still maintained the consistency.

4. Data Consistency: The term data consistency means  state of data should be consistent.  Result of any manipulation or updation should be reflected.

5.Support to Structure  Query Language: DBMS support to SQL . the query of SQL provide a easy way to the user to create, insert, update, delete the data in database.

6. Security: DBMS give s the facility to protect the database from unautorised users. Different  user accounts may have different access permissions, using which user can easily secure their  data by unauthorized users..

7. Transaction Support: DBMS supports transactions  which helps the user to maintain the integrity of the database..

These feature of DBMS can also be views as advantages of using DBMS.

Disadvantages of dbms

When we talk about disadvantages of DBMS then there are no such disadvantages of using dbms we can see It's Complexity and cost as a disadvantages. And user should have good knowledge of database management system and sql.



addressing modes types,1,advance-java,2,aktu entrance exam,1,aktu exam schedule,1,ASP,1,bare machine,1,base register and limit register,1,C Programming,18,C Plus Plus,1,c programming notes for gate,18,C programming Tutorials,8,Cache Memory,1,Childcare,1,CJ,1,Cloud Computing,1,CN,4,Computer Architecture,2,Computer architecture based questions for gate exam,11,Computer architecture Tutorials,1,Computer Network,3,Computer Network Study Material,2,Computer network study material for gate,1,Computer Networks,10,Computer networks gate questions with answer,3,computer networks notes,1,computer networks tutorial,1,Computer Science Study Material for Gate,13,computer science study material for gate exam,17,contiguous memory allocation,2,Core Java,3,cyber crime report,1,Cyber crime status,1,cybercrime and security,1,cybercrime examples,1,data communications and networking,1,Data Structure,2,Data Structure Questions,1,Data Transmission Architecture,1,Data Transmission in wsn,1,database normalization,1,dbmas study material,1,DBMS,8,dbms gate questions with answer,1,dbms multiple choice questions with answers for gate,1,dbms question paper,1,DE,1,Digital Electronics,1,DS,4,Electroencephalogram,1,ER diagram Tutorial,1,Gate 2017,3,Gate 2017 Admit card,1,GATE 2020,1,gate cse c programming questions,10,gate cse study material,2,gate cse syllabus,2,gate practice set,7,gate questions on c programming,10,gate study material for computer science,14,Gate study material for computer science 2017,1,gate study material for cse,46,General,3,HCL Aptitude Test,1,HR Interview Questions,1,HTML,4,Important Date of Gate 2017 Exam,1,Information Security Policy,1,internal and external fragmentation,1,Java Tutorials,3,JDBC,2,JDBC Tutorial,1,JS,1,memory fragmentation,1,memory management,1,memory management questions and answer in os,1,Motivational,4,NCER,1,Numerical Techniques Lab,1,OOT,1,Operating System,6,Operating System Gate Questions,2,Operating System Objective Questions,4,Operating System Questions Bank,1,operating system study material for gate exam,11,operating system tutorial notes,8,Operating System tutorials resident monitor,1,page swapping,1,paged memory allocation,1,paged memory allocation in operating system,1,Regression testing,1,relocation register,1,routing table,1,Software Engineering,10,Software Engineering baes study material for gate,1,Software Quality Assurance,3,software verification methods,1,Stack,1,Study Material for gate Computer Science,5,swapping in memory management,1,swapping in operating system,1,TCS Code Vita,1,TCS Interview Questions,1,Technical Interview,1,Technical Questions from DBMS,1,Tips to Learn Coding,1,UML,1,Virtualization,1,What is process control block ?,1,what is software testing?,1,Wireless Sensor Network,3,worst fit algorithm for memory allocation,1,XML,2,
Computer Science Junction: Characteristics of dbms
Characteristics of dbms
This tutorial covers the overview of database management system. In this tutorial author covered introduction of data and database , introduction to database management system, dbms examples, characteristics of dbms, advantages of dbms.
Computer Science Junction
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share. STEP 2: Click the link you shared to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy