The database management system (DBMS) is the software that interacts with end users, applications, and the database itself to capture and analyze the data. The DBMS software additionally encompasses the core facilities provided to administer the database. The sum total of the database, the DBMS and the associated applications can be referred to as a "database system". Often the term "database" is also used loosely to refer to any of the DBMS, the database system or an application associated with the database.
Computer scientists may classify database-management systems according to the database models that they support. Relational databases became dominant in the 1980s. These model data as rows and columns in a series of tables, and the vast majority use SQL for writing and querying data. In the 2000s, non-relational databases became popular, referred to as NoSQL because they use different query languages.
In this post, we are going to learn DBMS starting from the basic terminologies and concepts associated to DBMS.
Basic Concepts:
Data is organized in a data storage hierarchy of increasingly complex levels: bits, bytes (characters), fields, records, files, and databases.
A character is a letter, number, or special character.
A field consists of one or more characters (bytes).
A record is a collection of related fields.
A file is a collection of related records.
A database is, as mentioned, an organized collection of integrated files. Important to data organization is the key field, a field used to uniquely identify a record so that it can be easily retrieved and processed.
Introduction to database
Every one deals with data every day. When anyone wants to listen to his/her favourite songs, he opens his playlist from the smartphone. In this case, the playlist is a database.
When you take a photo and upload it to your account in a social network like Facebook, your photo gallery is a database.
Databases are everywhere. So what is a database? By definition, a database is simply a structured collection of data, or you can say – a collection of information.
The data relates to each other by nature, e.g., a product belongs to a product category and associated with multiple tags. This is why we use the term relational database. In the relational database, we model data like products, categories, tags, etc., using tables.
A table contains columns and rows. It is like a spreadsheet. A table may relate to another table using a relationship, e.g., one-to-one and one-to-many relationships. Because we deal with a large amount of data, we need a way to define the databases, tables, etc., and process data more effectively. In addition, we want to turn the data into information.
SQL
SQL – the language of database SQL stands for Structured Query Language. SQL is the standardized language used to access the database. ANSI/SQL defines the SQL standard. The current version of SQL is SQL:2003. Whenever we refer to the SQL standard, we mean the current SQL version. SQL contains three parts:
- Data definition language contains statements that help you define the database and its objects e.g., tables, views, triggers, stored procedures, etc.
- Data manipulation language contains statements that allow you to update and query data.
- Data control language allows you to grant the permissions to a user to access a certain data in the database.
MySQL
MySQL is an open source relational database management system (RDBMS) based on Structured Query Language (SQL). It is used to manage the relational database by exploiting SQL. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter,[8] and “SQL”, the abbreviation for Structured Query Language. MySQL is a database management system that allows you to manage relational databases. It is open source software backed by Oracle. It means you can use MySQL without paying a dime. In addition, if you want, you can change its source code to suit your needs. MySQL is pretty easy to master in comparison with other database software like Oracle Database, or Microsoft SQL Server. MySQL can run on various platforms UNIX, Linux, Windows, etc. You can install it in a server or even in a desktop. In addition, MySQL is reliable, scalable, and fast.
RDBMS
A Relational Database management System (RDBMS) is a database management system based on relational model introduced by E.F Codd. In relational model, data is represented in terms of tuples(rows).
RDBMS is used to manage Relational database. A relational database is a collection of organized set of tables from which data can be accessed easily. Relational Database is the most commonly used database. It consists of a number of tables and each table has its own primary key.
What is Table ?
In a Relational database, a table is a collection of data elements organized in terms of rows and columns. A table is also considered as convenient representation of relations. But a table can have duplicate tuples, while a true relation cannot have duplicate tuples. Table is the simplest form of data storage. Below is an example of Employee table.
What is a Record ?
A single entry in a table is called a Record or Row. A Record in a table represents a set of related data. For example, the above Employee table has 4 records. Following is an example of single record.
1 Adam 34 13000
What is Field ?
A table consists of several records(row), each record can be broken into several smaller entities known as Fields. The above Employee table consist of four fields, ID, Name, Age and Salary.
What is a Column ?
In Relational table, a column is a set of value of a particular type. The term Attribute is also used to represent a column. For example, in Employee table, Name is a column that represent names of employee.
Name
Adam
Alex
Stuart
Ross
Practice questions
What is the difference between MySQL and SQL?
SQL stands for Structured Query Language. It’s a standard language for accessing and manipulating databases. MySQL is a database management system, like SQL Server, Oracle, Informix, Postgres, etc. MySQL is a RDMS (Relational Database Management System).
What is the difference between Database and DBMS?
Generally if anyone asked about the difference between Database and DBMS then everyone says that both are same, but there is huge difference between them are as:-
- Both are part of the Database system.
- Database contains a) Data b)schema (structure of the table).
- DBMS contains a) Query Processing software. b)storage Management software. Examples :-MySQL, MS SQL Server, Oracle.
- Both are interdependent.