Database: Collection of related information. Databases can be stored in different ways
Eg.:, computer, phone, paper, comment section
Database Management System (DBMS)
A special software program that helps users create and maintain a database.
Two types of databases:
Relational databases (SQL) à Organises data in one or more tables
- Each table has columns and rows
- A unique key identifies each row
Non-Relational databases (noSQL/ not just SQL) à Organises data is any format
- Key-Value stores
- Documents (JSON, XML, etc.)
- Graphs
Relational Databases (SQL)
- Relational Database Management System (RDBMS)
- Help users create and maintain a relational database
Eg.: mySQL, Oracle, prostgreSQL, MariaDB, etc
- Structured Query Language (SQL)
- Standardized language for interacting with RDBMS
- Used to define tables and structures
- SQL code used on one RDBMS is not always portable to another without modification
Non-Relational Databases (noSQL/ not just SQL)
- Non-Relational Database Management Systems (NRDBMS)
- Help users create and maintain a non-relational database
Eg.: mongoBD, DynamoDB, apache Cassandra, firebase, etc
- Implementation Specific
- Any non-relational database falls under this category, so there’s no set language standard
Published By : Sushmita Mandal
