MySQL is the popular open source database used for web-based applications.
MySQL is a relational database management system (RDBMS) developed by Oracle that is based on structured query language (SQL).
It is a structured collection of data.
MySQL stores data in tables made up of rows and columns.
RDBMS is a database management system (DBMS) that is based on relational model as introduced by E.F.Code.
It is a DBMS in which the database is organized and accessed according to the relation between data.
In a relational database, relationships between two or more tables by primary and foreign key.
Example- SQL, Orcle, Mysql, Mysql server
Features
1)-Data to be stored in tables.
2)-Data in the form of rows and columns.
3)-Provides facility primary key to uniquely identify the rows.
4)-Creates indexes for quicker data retrival.
5)-Sharing a common column in two or more tables (Primary Key and Foreign Key).
6)-Provides multiuser accessibility that controlled by individual users.
Advantages
1)-Data Security
2)-On-Demand Scalability
3)-High Performance
4)-24×7 Uptime
5)-Comprehensive Transactional Support
6)-Complete Workflow Control
7)-Reduced Total Cost of Ownership
8)-Open Source
Disadvantages
1)-MySQL lower version (5.0 or less) doesn't support ROLE, COMMIT and stored procedure.
2)-MySQL does not support a very large database size as efficiently.
3)-MySQL doesn't handle transactions very efficiently.
4)-MySQL doesn't have a good developing and debugging tool compared to other databases.
5)-MySQL doesn't support SQL check constraints.
Copyright ©2022 coderraj.com. All Rights Reserved.