What is a Database?

A Database is a collection of related data organized in a way that data can be easily accessed, managed and updated. Database can be software based or hardware based, with one sole purpose, storing data.

What is DBMS?

What is DBMS?

A DBMS ( Database Management System ) is a software that allows creation, definition and manipulation of database, allowing users to store, process and analyzing data easily. DBMS provides us with an interface or a tool, to perform various operations like creating database, storing data in it, updating data, creating tables in the database and a lot more. Here are some examples of popular DBMS used these days:

  • 1.MySql
  • 2.Oracle
  • 3.SQL Server
  • 4.IBM DB2
  • 5.PostgreSQL

The DBMS is perhaps most useful for providing a centralized view of data that can be accessed by multiple users, from multiple locations, in a controlled manner. A DBMS can limit what data the end user sees, as well as how that end user can view the data, providing many views of a single database schema. End users and software programs are free from having to understand where the data is physically located or on what type of storage media it resides because the DBMS handles all requests.

Some Types of DBMSes :

Some popular database models below:

  • RDMS (Relational database management system)
  • IMDBMS (In-memory database management system)
  • CDBMS (Columnar database management system)

Advantages of DBMS :

Using a DBMS to store and manage data comes with advantages, but also overhead. One of the biggest advantages of using a DBMS is that it lets end users and application programmers access and use the same data while managing data integrity. Data is better protected and maintained when it can be shared using a DBMS instead of creating new iterations of the same data stored in new files for every new application. The DBMS provides a central store of data that can be accessed by multiple users in a controlled manner.

Disadvantages of DBMS :

  • Complexity / Not very easy
  • DBMSes are generally costly (Don't include MySQL and other open source DBMSes).
  • Generally they are large in size.
What is CrossFire, CrossfireX or SLI (AMD/ATI/NVDIA)? SLI Works

What is CrossFire, CrossfireX or SLI (AMD/ATI/NVDIA)? SLI Works :

26/01/2019

CrossFire is a high-performance PC gaming graphics platform made possible by the use of multiple graphics cards coupled with a CrossFire enabled motherboard.

Read More
Programming Language Generations - 1GL, 2GL, 3GL, 4GL, 5GL

Programming Language Generations - 1GL, 2GL, 3GL, 4GL, 5GL :

01/12/2018

A programming language is a set of written symbols that instructs the computer hardware to perform specific tasks. Typically, programming language consists of a vocabulary.

Read More
Transmission Modes, Describe Briefly - Simplex, Half-duplex, Full-duplex

Transmission Modes, Describe Briefly - Simplex, Half-duplex, Full-duplex :

22/04/2020

Transmission mode refers to the mechanism of transferring data between two devices connected over a network basically this process called Communication Mode.

Read More

Next Update

Loading...

We Are Currently Working On Our Android Application Development and We already have two YouTube channels their name is CodeX or NightHawk. CodeX is for programming related videos and NightHawk is for online game streaming so please supporting us and Subscribe to our channels, Thank you