DEV Community

Esraa Nasr
Esraa Nasr

Posted on

Database Management system(DBMS) Part1

Hello guys,

Hope everything is going well. I'm Esraa a frontend developer and postgraduate student at AAST in Computer Science. This semester, I'm studying three subjects Data structure and algorithms, Database Management Systems(DBMS), and Object object-oriented programming (OOP).

I'll contribute tutorials for each subject to share information, and if you have an external tutorial, please share it with us:).

So, get to the point. What is the meaning of Data? What is the difference between Data and Information? Why do we need this information?

Data: refers to raw facts, building blocks of information. Unprocessed information.

Information: data is processed to reveal meaning (ذات معنى)

If we have accurate, relevant, and timely information we have a key to effective decision-making. effective decision-making is the key to survival in the global environment.

Database: Shared, integrated computer structure that houses
End user data (raw facts)
Metadata (data about data)

Let's go further and discover a database management system.

Do you consider how may I manage and control access to data? Is it possible to share it? How can I make data more effective and efficient?!

DBMS can answer all questions about this point because:

  • It's a collection of programs that manage database structure and control access to data.

  • It's possible to share data among multiple apps or users.

  • Make database management more efficient and effective.

Image description

Feature on details:

  • Support massive amounts of data

    • Giga/tera/petabytes
    • Far too big for main memory
  • Persistent storage

    • Programs update, query, manipulate data.
    • Data continues to live long after program finishes.
  • Efficient and convenient access

    • Efficient: do not search entire database to answer a query.
    • Convenient: allow users to query the data as easily as possible.
  • Secure, concurrent, and atomic access

    • Allow multiple users to access database simultaneously.
    • Allow a user access to only to authorized data.
    • Provide some guarantee of reliability against system failures.

Last but not least

Here's a diagram for a type of database and location

Image description

Top comments (0)