Relational: SQL / PostgreSQL / MySQL

 The Relational Database is as the term gives the idea, Relational database is a tool that holds any type of information related to each other (i.e two databases having similar information). For instance, A social media company has a list of their customers and other databases have the detail of the customer.

 The Relational Database has a vast range of usage, It can be used in many fields and is popular even today because it is easy to use, convenient, and reliable technology, It is very useful in managing data, and their relations.

Here in this blog, we'll see the bit history and how Relational Database works and types of Relational: SQL, MySQL, Oracle

HISTORY :

In 1970 at IBM the terminology "relational database" was coined by E. F. Codd. In his paper and later papers, he described what he meant by "relational". A very known definition of what consists of a relational database system is composed of Codd's 12 rules. 

In June 1976, the First sold system was Multics Relational Data Store as an RDBMS. In 1979 Relational Software released the Oracle, now the company is known as  Oracle Corporation.  IBM and Ingres BS12 followed.

At IBM UK Scientific Centre at Peterlee – IS1 (1970–72) and its successor, PRTV (1973–79). The most frequent term of an RDBMS is a result that represents a view of data as a collection of rows and columns, even if it is not strictly based upon relational theory. By this definition, RDBMS products typically implement some but not all of Codd's 12 rules.

In 1984, the first RDBMS by Macintosh began to be developed, The code-name was Silver Surfer and was released in 1987 as 4th Dimension and known today as 4D.

In 2009, most commercial relational DBMSs employ SQL as their query language. Alternative query languages have been proposed and implemented, notably the pre-1996 implementation of Ingres QUEL.

Present the data to the user as relations (a presentation in tabular form, i.e. as a collection of tables with each table consisting of a set of rows and columns);

#SQL:

SQL stands for Structured Query Language. SQL is a domain-specific language used by programmers and designed to manage the  data held in a relational database management system (RDBMS). It is particularly useful in handling structured data,managing the data in easier manner. 

SQL offers fe major advantages over older read–write APIs such as  VSAM or ISAM . As, it introduced the concept of accessing more than one records with one single command. And it reduct the necessity  to specify how to reach a record, e.g. with or without an index.

Originally based upon tuple relational calculus  and relational algebra, SQL includes of many types of statements, which can be informally classified as sublanguages, commonly: a data query language (DQL),a data control language (DCL), a data definition language (DDL),  and a data manipulation language (DML). The scope of SQL includes data query, data manipulation (insert, update and delete), data access control and data definition (schema creation and modification). Although SQL is essentially a declarative language (4GL), it also includes procedural elements.

#mySQL:

MySQL () is an open-source relational database management system (RDBMS). The name is an amalgam of "My", The initials of co-founder Michael Widenius's daughter, and "SQL", the shorttening  for Structured Query Language. SQL is a  Query language programmer use to create, extract and modify data from the relational database, as well as it let controlled user access to the database.Additionally, To relational databases and SQL, an RDBMS like MySQL works with an operating system to imply a relational database in the computer's storage system, let the system manages users, allows for network access ,facilitates testing database integrity and creation of backups.

Overview:

MySQL is written in C and C++. Its SQL parser is written in yacc, but it uses a home-brewed lexical analyzer. MySQL works on many system platforms, including  Linux, macOS, Microsoft Windows, NetBSD,AIX, BSDi, FreeBSD, HP-UX, ArcaOS, eComStation, IBM i, IRIX, Novell NetWare, OpenBSD, OpenSolaris,etc.

MySQL has a lot of positive response like "It is easy to handle", "Efficient for average cases" ,"Great interface for the begginers ".

Features:

MySQL is offered under two alternative editions: The proprietary Enterprise Server and the open source MySQL Community Server. MySQL Enterprise Server is differentiated by a versions of proprietary extensions which were install as server plugins, but otherwise shares the version numbering system and is built from the same code base.

#Oracle: