Features of SQL
Some of the features of SQL are: SQL is an ANSI and ISO standard computer language for creating and manipulating databases. It manages the data held in relational database management system. SQL allows the user to create, update, delete, and retrieve data from a database. SQL is very simple and easy to learn. SQL enables end users and system persons to deal with a number of database management systems where it is available. Applications written in SQL can be easily ported across systems. Such porting could be required when the underlying DBMS needs to be upgraded because of change in transaction volumes or when a system developed in one environment is to be used on another. SQL as a language is independent of the way it is implemented internally. A query returns the same result regardless of whether optimizing has been done with indexes or not. This is because SQL specifies what is required and not how it is to be done. Advantages of SQL are: High speed, existence of well defined standards, no coding required and emergence of ORDBMS. Disadvantages of SQL are: difficulty in interfacing and more features implemented in proprietary way.
Summary
Some of the features of SQL are: SQL is an ANSI and ISO standard computer language for creating and manipulating databases. It manages the data held in relational database management system. SQL allows the user to create, update, delete, and retrieve data from a database. SQL is very simple and easy to learn. SQL enables end users and system persons to deal with a number of database management systems where it is available. Applications written in SQL can be easily ported across systems. Such porting could be required when the underlying DBMS needs to be upgraded because of change in transaction volumes or when a system developed in one environment is to be used on another. SQL as a language is independent of the way it is implemented internally. A query returns the same result regardless of whether optimizing has been done with indexes or not. This is because SQL specifies what is required and not how it is to be done. Advantages of SQL are: High speed, existence of well defined standards, no coding required and emergence of ORDBMS. Disadvantages of SQL are: difficulty in interfacing and more features implemented in proprietary way.
Things to Remember
Features of SQL
- SQL is an ANSI and ISO standard computer language for creating and manipulating databases. It manages the data held in relational database management system.
- SQL allows the user to create, update, delete, and retrieve data from a database.
- SQL is very simple and easy to learn.
- SQL enables end users and system persons to deal with a number of database management systems where it is available.
- Applications written in SQL can be easily ported across systems. Such porting could be required when the underlying DBMS needs to be upgraded because of change in transaction volumes or when a system developed in one environment is to be used on another.
- SQL as a language is independent of the way it is implemented internally. A query returns the same result regardless of whether optimizing has been done with indexes or not. This is because SQL specifies what is required and not how it is to be done.
- Thelanguage while being simple and easy to learn can cope with complex situations.
- The results to be expected are well defined in SQL.
- SQL works with database programs like DB2, Oracle, MS Access, Sybase, MS SQL Sever etc.
Advantages of SQL
- High Speed: As we know,SQL Queries can be used to retrieve large amounts ofrecords from a database. It does this quickly and efficiently. Therefore, maintainig a high speed.
- Well Defined Standards Exist:SQL databases use long-established standard,which is being adopted by ANSI & ISO. Non-SQL
databases do not adhere to any clear standard. - No Coding required: While using standard SQL, it makes easier tomanage database systems without having to write substantial amount of code.
- Emergence of ORDBMS:Previously SQL databases were synonymous with relational database. With the emergence of Object
Oriented DBMS, object storage capabilities areextended to relational databases.
Disadvantages of SQL
- Difficulty in interfacing: Interfacing an SQL database is more complex than writing lines of codes.
- More Features Implemented in Proprietary way: Although SQL databases conform to ANSI and ISO standards, some databases go fro proprietary extensions to standard SQL to ensure vendor lock-in.
MCQs
No MCQs found.
Subjective Questions
No subjective questions found.
Videos
No videos found.
Features of SQL
Features of SQL
- SQL is an ANSI and ISO standard computer language for creating and manipulating databases. It manages the data held in relational database management system.
- SQL allows the user to create, update, delete, and retrieve data from a database.
- SQL is very simple and easy to learn.
- SQL enables end users and system persons to deal with a number of database management systems where it is available.
- Applications written in SQL can be easily ported across systems. Such porting could be required when the underlying DBMS needs to be upgraded because of change in transaction volumes or when a system developed in one environment is to be used on another.
- SQL as a language is independent of the way it is implemented internally. A query returns the same result regardless of whether optimizing has been done with indexes or not. This is because SQL specifies what is required and not how it is to be done.
- Thelanguage while being simple and easy to learn can cope with complex situations.
- The results to be expected are well defined in SQL.
- SQL works with database programs like DB2, Oracle, MS Access, Sybase, MS SQL Sever etc.
Advantages of SQL
- High Speed: As we know,SQL Queries can be used to retrieve large amounts ofrecords from a database. It does this quickly and efficiently. Therefore, maintainig a high speed.
- Well Defined Standards Exist:SQL databases use long-established standard,which is being adopted by ANSI & ISO. Non-SQL
databases do not adhere to any clear standard. - No Coding required: While using standard SQL, it makes easier tomanage database systems without having to write substantial amount of code.
- Emergence of ORDBMS:Previously SQL databases were synonymous with relational database. With the emergence of Object
Oriented DBMS, object storage capabilities areextended to relational databases.
Disadvantages of SQL
- Difficulty in interfacing: Interfacing an SQL database is more complex than writing lines of codes.
- More Features Implemented in Proprietary way: Although SQL databases conform to ANSI and ISO standards, some databases go fro proprietary extensions to standard SQL to ensure vendor lock-in.
Lesson
Relational Languages and Relational Model
Subject
Computer Engineering
Grade
Engineering
Recent Notes
No recent notes.
Related Notes
No related notes.