Database Management System (DBMS)

Published by StudyMuch on

Database Management System studymuch

Database Management System (DBMS)

In this tutorial you will learn about Database Management System (DBMS), advantage and disadvantage of Database management system, Architecture,

Key in Database Management System etc. about (DBMS).

What is Database Management System?

A Database Management System (DBMS) is a computer program designed for creating and managing the database. It provides a systematic way to run operations like creating, retrieving, storing data, deleting data from the database. It serves as an interface between the database and end users. It also provides protection and security to the databases.

Example; MySQL, SQL, SQL Server, IBM DB2, PostgreSQL, Amazon Simple DB, (Cloud based) are some popularly used DBMS.

DBMS studymuch.in

Advantage of DBMS –

  • Data security and consistency
  • Reduced Data redundancy
  • Easily accessible
  • Better data transferring
  • Integrity Constraints

Disadvantage of DBMS –

  • Frequency Upgrade or Replace Cycle
  • Large in size
  • Complexity
  • Difficult Backup and Recovery
  • Licensed DBMS are costly

Architecture (Level of Data Abstraction in DBMS)

Database system consist of complex data structure. The process of masking irrelevant information from users is known as Data Abstraction. Data abstraction reduced the complexity of users with the database. Three levels of data abstraction are Physical Level, Logical Level and View Level.

The Architecture of commercial DBMS is based on ANSI-SPARC database architecture.

Database Management System

View Level/Internal Level –

It is the highest level of abstraction and is viewed by the user in terms of tables and relations. It describes only a part of the entire database and hides the details of the logical level.

Physical Level/Internal Level –

It is the lowest level of abstraction. It describes how the data is physically stored in detail. B+ tree, Hash file organization methods are used in this level.

Logical Level/Conceptual Level –

It is the next level of abstraction and describes what data is stored and what is the relationship among that data. At the logical level, each record is described by a type and the interrelationship of these record types. Database administrators work at this level of abstraction. The changes which are done at this level will not affected the external or physical levels of data.

 

Keys in Database Management System

A key is a field in the database which is used to retrieve and sort rows in the table. Keys are used to speeding up the data accessing and creating links between different tables.

Types of Keys in DBSM –

Super Key – It is a set of one or more attributes whose values uniquely determine each entity in the database table. It is a subset of a candidate key.

Candidate Key – It is a set of columns in the table form which primary key can be selected to identify each record. Every database table may have one or more candidate keys.

Primary Key – It is a special key that uniquely identifies each record in the table. It has unique value for each row of data and it cannot contain null values.

Alternate Key – All keys except primary key are known as Alternate. Alternate keys are also called Secondary Keys.

Foreign Key – Foreign key points to the primary key of another table. It acts as a reference between tables. It can accept the null and duplicate value.

Composite Key – It is a combination of more than one column in the table that can be used to uniquely identify each record. It is also known as a Composed Key.

So, in this tutorial you learned Database Management System (DBMS), with advantage and disadvantage of DBMS, Keys in Database Management System etc. I hope you read this tutorial well and learn something new.

Learn Also –


14 Comments

zoritoler imol · September 13, 2022 at 6:17 pm

Great line up. We will be linking to this great article on our site. Keep up the good writing.

marizonilogert · October 9, 2022 at 9:17 pm

After all, what a great site and informative posts, I will upload inbound link – bookmark this web site? Regards, Reader.

iHerb Code · October 19, 2022 at 3:42 pm

I apologise, but, in my opinion, you commit an error. Let’s discuss it. Write to me in PM, we will talk.

zoritoler imol · November 6, 2022 at 8:06 am

An interesting discussion is worth comment. I think that you should write more on this topic, it might not be a taboo subject but generally people are not enough to speak on such topics. To the next. Cheers

zoritoler imol · November 27, 2022 at 2:23 am

Hey! I know this is kind of off topic but I was wondering if you knew where I could locate a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having trouble finding one? Thanks a lot!

situs bokep · April 9, 2024 at 1:06 pm

Thanks for your post. I would really like to write my opinion that the expense of car insurance differs from one scheme to another, for the reason that there are so many different facets which play a role in the overall cost. Such as, the model and make of the vehicle will have a large bearing on the price. A reliable older family vehicle will have a less expensive premium than just a flashy racecar.

bokep jepang · April 24, 2024 at 7:39 pm

Thank you a lot for sharing this with all of us you actually realize what you are speaking about! Bookmarked. Please additionally seek advice from my site =). We could have a link alternate arrangement among us!

bokep indo · April 30, 2024 at 3:27 am

Wow, awesome blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your web site is wonderful, let alone the content!

situs bokep · May 5, 2024 at 10:17 pm

There are some interesting closing dates in this article however I don?t know if I see all of them center to heart. There may be some validity but I’ll take hold opinion till I look into it further. Good article , thanks and we wish extra! Added to FeedBurner as well

kontol kuda · May 6, 2024 at 5:53 am

I’m so happy to read this. This is the type of manual that needs to be given and not the random misinformation that’s at the other blogs. Appreciate your sharing this greatest doc.

kontol kuda · May 6, 2024 at 10:18 am

This site does not display appropriately on my iphone 3gs – you might want to try and fix that

bokep indo · May 6, 2024 at 7:59 pm

Awesome blog! Is your theme custom made or did you download it from somewhere? A theme like yours with a few simple tweeks would really make my blog shine. Please let me know where you got your theme. Bless you

link bokep · May 7, 2024 at 3:55 am

whoah this blog is excellent i really like reading your articles. Stay up the good paintings! You realize, many people are searching round for this information, you could help them greatly.

Renters Car Insurance · May 25, 2024 at 1:18 pm

Great paintings! This is the type of info that should be shared around the internet. Disgrace on the seek engines for now not positioning this post higher! Come on over and consult with my website . Thank you =)

Leave a Reply

Avatar placeholder

Your email address will not be published. Required fields are marked *