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 5G Network? It's time to upgrade your mobile? More About 5G Network

What is 5G Network? It's time to upgrade your mobile? More About 5G Network :

25/02/2020

5G is a next-generation high-speed Mobile network connection, that replaces our 4G LTE network connections. Samsung Galaxy S10 5G, is the first 5G support mobile.

Read More
Domain Name Server (DNS). Generic Domains, Country Domains, Inverse Domains

Domain Name Server (DNS). Generic Domains, Country Domains, Inverse Domains :

22/02/2020

The purpose of DNS (Domain Name Server) is to translate domain names into IP addresses. A service is used for translating domain names into IP addresses.

Read More
How ATM works? Role of ATM in Internetworks and ATM network speed

How does a SIM card work? SIM card History and SIM card size :

21/02/2020

SIM (Full form: Subscriber Identity Module or Subscriber Identification Module) card technology is one of the most popular technologies. The first SIM card was developed in 1991.

Read More
How ATM works? Role of ATM in Internetworks and ATM network speed

How ATM works? Role of ATM in Internetworks and ATM network speed :

21/02/2020

ATM (Asynchronous Transmission Mode) communicates with cells rather than transmitting frames. ATM cells can be encapsulated in other protocols.

Read More
What is File Compression? Lossless Compression and Lossy Compression

What is File Compression? Lossless Compression and Lossy Compression :

20/02/2020

The process of reducing data by applying a compression technique is called compression, and the resulting data is called compressed data. The reverse process is decommission.

Read More
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
Types Of Networks - LAN, WAN, MAN, VAN etc

Types Of Networks (Short Description) - LAN, WAN, MAN, VAN etc :

25/01/2019

Networking of PCs has been developed for all levels, from local to international, in diverse sectors of society, Example are networks used by government organizations.

Read More
Different Types of Wireless Communication or Transmission

Different Types of Wireless Communication or Transmission :

24/01/2019

In the present days, wireless communication system has become an essential part of various types of wireless, many devices used wireless communication.

Read More
What Is a Firewall and Types of Firewall ( Packet, Application, Proxy, NGFW )

What Is a Firewall and Types of Firewall ( Packet, Application, Proxy, NGFW ) :

22/01/2019

Firewalls are often categorized as either network firewalls or host-based firewall. Firewalls may also be a component of your computer's operating system.

Read More
Encryption and Decryption (Data), Encoding and Decoding

Encryption and Decryption (Data), Encoding and Decoding :

22/01/2019

Encryption is the process of translating plain text data (plaintext) into something that appears to be random and meaningless (ciphertext). Encryption algorithm is difficult.

Read More
What is a Database/DBMS? Some Types of DBMSes with Advantages or Disadvantages

What is a Database/DBMS? Some Types of DBMSes with Advantages or Disadvantages :

21/01/2019

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.

Read More
Algorithm and Flowchart, Symbols in Flowcharts and Examples of flowcharts

Algorithm and Flowchart, Symbols in Flowcharts and Examples of flowcharts :

02/12/2018

TCP/IP is an industry-standard protocol suit for Wide Area Networks (WANs) developed in the 1970s and 1980 by the U.S Department of Defense (DoD).

Read More
What is TCP/IP? How To Work TCP/IP ? Most Common TCP/IP protocols

What is TCP/IP? How To Work TCP/IP ? Most Common TCP/IP protocols :

02/12/2018

TCP/IP is an industry-standard protocol suit for Wide Area Networks (WANs) developed in the 1970s and 1980 by the U.S Department of Defense (DoD).

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
The OSI Model - Layers, Features, Principles and Merits or Demerits

The OSI Model - Layers, Features, Principles and Merits or Demerits :

24/10/2018

ISO stands for International organization of Standardization. This is called a model for Open System Interconnection (OSI) and is commonly known as OSI model.

Read More
What Is GPU? World First GPU Details and Where Company's use GPUs?

What Is GPU? World First GPU Details and Where Company's use GPUs?

23/10/2018

GPU (Graphics Processing Unit) is an electronic circuit used to speed up the creation of both 2D and 3D images. A GPU can be present on a video card or motherboard.

Read More
Types of Network Topology with Advantages and Disadvantages

Types of Network Topology with Advantages and Disadvantages :

21/10/2018

Network Topology is the schematic description of a network arrangement, connecting various nodes (sender and receiver) through lines of connection.

Read More

Next Update

Loading...

We 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