Summary -
In this topic, we described about the Features in detail.
Some important features of SQL are shown below -
- Flexibility - SQL Supports flexibility that it can create new tables and delete or modify the existing data easily.
- Robust - SQL is Robust that it can deals with massive data and Operates arithmetic transactions on database.
- High Performance - performance is depending upon Less response time and More end users. SQL Supports high performance it deals with multiple users on database to fetch data within less time.
- High Availability - Different RDBMS like MySQL, Oracle, MS Access used different dialects as T-SQL, PL/SQL, JET SQL etc. All these RDMS using SQL as the standard database query language.
- High Security - SQL give access permission to user and it take back permission from user on tables, procedures, views. Hence data is highly secured.
- Open Source - SQL is open source language. Everyone can use SQL for database management with free of cost.
- Data Management - some common standard SQL commands like create, update, drop, insert, and delete are used in different RDMS to manage massive amount of data.
- Broad Application Enhancement - Many programmers used SQL to retrieve data from database. Even small or large industries also used SQL.
- Portability - SQL supports portability that data from database can moved wherever we want.
- Longevity - SQL Supports longevity that it supports long life.
- Decreased dependence - SQL has many versions that it decreases the dependence on one particular vendor.
- Client/server architecture - SQL have various commands that the client applications can interact with database over a network to maintain many to one relationship.