THE ADVANTAGES OF SQL - IBM Mainframe

SQL is a high level language that provides a greater degree of abstraction than procedural languages. It is fashioned so that the programmer can specify what data is needed but need not specify how to retrieve it. SQL is coded without embedded data-navigational instructions. This will be taken care by the Database Management System.

  • SQL enables the end-users and systems personnel to deal with a number of database management systems where it is available. Increased acceptance and availability of SQL are also in its favor.
  • Applications written in SQL can be easily ported across systems. Such porting could be required when the underlying Database Management System needs to be upgraded or changed.
  • 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 should be done.
  • The language while being simple and easy to learn can handle complex situations.
  • The results to be expected are well defined. The language has sound theoretical base and there is no ambiguity about the way a query will interpret the data and produce the result.
  • SQL is not merely a query language. The same language can be used to define data structures, control access to the data and delete, insert and modify occurrences of the data.
  • All SQL operations are performed at a set level. One select statement can retrieve multiple rows. One modify statement can modify multiple rows. This set-at-a time feature of the SQL makes it increasingly powerful than the record-at-a-time processing techniques employed in languages like say COBOL. For example one will have to code a full fledged COBOL program with more than 60 to 70 lines of code to achieve the same results achieved by the SQL statement UPDATE emptable SET bonus=1000 WHERE emp_no= 86096.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

IBM Mainframe Topics