Introduction to Database

Information collected in a systematic way to facilitate access, management and various updates is called a database.In introduction to database we learn various topics.

Before moving on to another discussion of the database introduction, we must first know what kind of data it is? 
Data can be defined as a collection of facts and records to which we can apply logic or a possible discussion or some calculation.
introduction to database

Data is always easily accessible and accessible. This can be used to process some useful information. In addition, it may be redundant, it may be irrelevant. 

Data can exist in the form of graphs, reports, tables, text, etc., representing all types of information, facilitating the search, updating, analysis and display of data using a systematic or structured repository of indexed information. does.

Containers with huge amounts of data are called databases, for example, books are stored in a public library. Databases are computer structures that store, organize, protect and disseminate data.
Any system that manages a database is called a database management system or DBM. A typical diagram representation for a database is a cylinder.

Inside the database, data is written to a table, which is a set of rows, columns, and indexed, so that finding relevant information becomes an easier task. As new information is added, data is updated, expanded, and deleted. Various database processes create and update themselves, requesting the data contained in them and launching applications for them.

To date, several different types of database models have been developed, for example, flat, hierarchical, network, and relational. These models describe the operations that can be performed on them, as well as the structure of the respective databases. Usually there is a database schema that describes the exact model, types of objects, and relationships between these objects.

What is a database?

This is probably what comes to your mind when you hear the term “database”.
This is a structured system for placing your data, which imposes rules on this data, and these rules belong to you because the importance of these problems varies depending on your needs. Maybe your problem is size, while someone else has less data for which sensitivity is important.

These are things that you cannot see that are happening in the background; security, forced data integrity, the ability to quickly and reliably reach them, reliability; serve a lot of people at the same time and even properly experience failures and problems with equipment without damaging the data.
And that is what we need to do here; understand how to describe our structure and define these rules so that all these invisible things really happen.

Flat databases have the following characteristics -
  • simply
  • long and dominant
  • useful for very small scales and simple applications.
A relational database has the following characteristics:
  • organizes the data in such a way that it seems to the user that they are stored in a series of interconnected tables
  • used for high performance applications
  • effective
  • ease of use
  • ability to perform many useful tasks

Why do we need a database?

why do we need a database
why do we need a database

When you have some data and you want to store this data somewhere. This data can be anything. This can be customers, products, employees, orders, etc. This data can be in text format, numerical format, dates, document files, images, audio or video.

Perhaps if you have customer data in your company, the first thing that comes to mind is to open a spreadsheet. Then you start writing any data you want to save.

This can be a customer’s name, identifier, position, etc. You can add as many customers, or delete them later, or even change them. And it's all!.

Database Management System (DBMS)

We often mistakenly say that our database is Oracle, MySQL, SQL Server, MongoDB. But these are not databases, they are database management systems (DBMS).

A DBMS is software that will be installed on your personal computer or server, and then you will use it to manage one or more databases.

The database contains your actual data and the rules for this data, and the DBMS is a program that surrounds and manages your actual data, and ensures compliance with the rules that you specified in your data. For example, rules can be a data type, such as an integer or a string, or the relationship between them.

There are various DBMSs, and they are divided into:

  • Relational Database Management Systems
  • Hierarchical Database Systems
  • Network Database Systems
  • Object Oriented Databases
  • NoSQL Database Systems
We are going to focus on relational database management systems (RDBMS). But why? ...

  • They are the most commonly used.
  • The principles we are about to discuss apply to all of them.
  • If you know that you intend to switch to NoSQL databases, most of the views assume that you already understand the concepts of relationship databases and will use these concepts to explain what NoSQL databases offer.
Watch video for more details:

Post a comment