Overview of DBMS

what is dbms in hindi,codd rule in dbms,geeksforgeeks dbms,overview of database management system,characteristics of dbms,introduction to dbms,database management system

This article cover the overview of database management system. In this article author covered introduction of data and database , database management software, dbms examples, characteristics of dbms, advantages of dbms.

What is Data ?

Before introducing the database 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 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.

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. 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

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 features dbms is preferred over traditional file system

1. Way of Storing the data: In DBMS  Data is stored into tables, structure for the table is created initially . This table structure is also known as Schema. Schema provide 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 disdavantages. And user should have good knowledge of database management system and sql.



addressing modes types,1,advance-java,2,advancejava,1,aktu entrance exam,1,aktu exam schedule,1,ASP,1,bare machine,1,base register and limit register,1,C Programming,14,C Plus Plus,1,C Programming,3,C Programming MCQ,2,C Programming Questions,2,C programming study material for gate exam,12,Cache Memory,1,CBNST Program,1,Childcare,1,CJ,2,Cloud Computing,1,COA GATE Questions,1,components of use case diagram,1,Computer Architecture,2,Computer architecture based questions for gate exam,11,Computer Network,4,Computer Network Study Material,2,Computer network study material for gate,2,Computer Networks,6,Computer networks GATE Questions,1,Computer Science Study Material for Gate,19,computer science study material for gate exam,34,content based image retrieval content based image retrieval system,1,contiguous memory allocation,2,Core Java,8,COre Java Interview Questions,1,core java interviews questions,1,cyber crime report,1,Cyber crime status,1,cybercrime and security,1,cybercrime examples,1,Data Mining,1,Data Structure Questions,1,Data Transmission Architecture,1,Data Transmission in wsn,1,DBMS,5,dbms question paper,1,DE,1,Digital Electronics,1,DS,1,dynamic linking,1,dynamic linking in memory management,1,Dynamic memory allocation in c,1,Electroencephalogram,1,File Handling,1,file management in operating system notes,1,FOC,1,Fundamenatl of Computer,1,Gate 2017,5,Gate 2017 Admit card,1,Gate 2017 Exam Schedule,1,Gate 2017 Syllabus,1,gate 2018,1,gate cse study material,1,gate practice set,10,gate study material for computer science,16,Gate study material for computer science 2017,1,GatePreviousYear,1,General,3,HCL Aptitude Test,1,HR Interview Questions,1,HTML,1,Image Processing,1,Important Date of Gate 2017 Exam,1,Information Security Policy,1,internal and external fragmentation,1,JS,1,lagrange's interpolation formula,1,lagrange's interpolation formula examples,1,Looping in C,1,MComputing,1,memory fragmentation,1,memory management,1,memory management questions and answer in os,1,Motivational,4,NCER,2,Numerical Techniques Lab,1,OOT,1,Operating System,12,Operating System Gate Questions,1,Operating System Objective Questions,4,Operating System Questions Bank,1,Operating system questions for gate,1,Operating System Study material,2,operating system study material for gate exam,16,Operating system tutorial,2,page swapping,1,paged memory allocation,1,paged memory allocation in operating system,1,paging technique of memory management .paging technique,1,paging technique of memory management program in c,1,Pointer in C,4,Process based question for gate,1,Quiz on non conventional energy resources,1,Regression testing,1,relocation in memory management,1,relocation registe,1,relocation register,1,resident monitor,1,resident monitor in operating system,1,routing table,1,segmentation in memory management,1,segmentation in memory management in operating system,1,Servlet,1,session tracking,1,session tracking in java,1,session tracking in servlet,1,Software Engineering,10,Software Engineering baes study material for gate,1,software engineering interview questions,1,Software Quality Assurance,3,software verification methods,1,SPM,1,Structure in C,1,Study Material for gate Computer Science,9,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,Thrashing in Operating System,1,Threads concept in operating system,1,Tips to Learn Coding,1,Top 30 Core Java Interview Questions with Answer,2,top down approach,1,top down approach in programming,1,Types of operating system,1,UML,1,use case diagram explanation,1,website uses cookies,1,what is cookies website,1,What is process control block ?,1,what is software testing?,1,Wireless Sensor Network,3,worst fit algorithm for memory allocation,1,XML,1,
Computer Science Junction: Overview of DBMS
Overview of DBMS
what is dbms in hindi,codd rule in dbms,geeksforgeeks dbms,overview of database management system,characteristics of dbms,introduction to dbms,database management system
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