What is sql?, Database Management System

Assignment Help:

What Is Sql?

 Structured Query Language (SQL) is a standard query language. It is usually used with all relational databases for data manipulation and definition.

All the relational systems support SQL, therefore allowing migration of database from one DBMS to a different. In fact, this is one of the reasons of the main success of Relational DBMS. A user may be capable to write a program using SQL for an application that includes data being stored in more than one DBMSs, given these DBMS support standard SQL. This feature is usually referred to as portability. Though, not all the features of SQL executed in one RDBMS are available in others because of customization of SQL. Though, please note there is just ONE standard SQL.

SQL gives an interface where the user can state "What" are the expected results. The query implementation plan and optimisation is performed by the DBMS. The query plan and optimisation shows how a query needs to be implemented. For instance, if three tables X, Y and Z are to be joined mutually then which plan (X JOIN Y) and then Z or X JOIN (Y JOIN Z) may be implemented. All these decisions are depend on statistics of the relations.

SQL is known as a non-procedural language as it just states what is to be dome rather than how it is to be complete. Also, as SQL is a higher-level query language, it is closer to a language like English. Thus, it is very user friendly.

The American National Standard Institute (ANSI) has designed standard versions of SQL. The first standard in this series was formed in 1986. It was known as a SQL-86 or SQL1. This standard was revised and better later and SQL-92 or SQL-2 was released. A newer standard of SQL is SQL3 which is also called as SQL- 99. In this part we will try to cover features from latest standards. Though, some features may be found to be very specific to definite DBMS.

Some of the main features of SQL are:

  • It is an English-like language.
  • It is a non procedural language.
  • It can process a one record as well as sets of records at a time.
  • It is dissimilar from a third generation language (C& COBOL). All SQL

Statements describe what is to be complete rather than how it is to be complete.

  • SQL is a data sub-language having of three built-in languages: Data definition language (DDL), Data manipulation language (DML) and Data control language (DCL).
  • It insulates the user from the underlying algorithm and structure.
  • SQL has facilities for defining database security, views, integrity constraints, transaction controls, etc.

Related Discussions:- What is sql?

Boyce-codd normal form (bcnf), Boyce-Codd Normal Form (BCNF) The relati...

Boyce-Codd Normal Form (BCNF) The relation NEWSTUDENT (Enrolmentno, Sno, Sname, Cname, Cno,) has every attributes participating in candidate keys as all the attributes are assu

Equi join-table handling, Equi Join: A join in which the joining condition...

Equi Join: A join in which the joining condition is based on equality among values in the common columns. Common columns show (redundantly) in the result table. Let us Consider th

What is an e-r model and draw an e-r diagram for the company, What is an E-...

What is an E-R model? Draw an E-R Diagram for the company database with following Descriptions? The company is organized within departments. Each department has a unique name a

N-ary relationship, For every n-ary relationship type R where n>2, we make ...

For every n-ary relationship type R where n>2, we make a new table S to represent R. We contain as foreign key attributes in s the primary keys of the relations that show the parti

What is predictive modelling, Question : (a) Data mining is one of the...

Question : (a) Data mining is one of the best ways to analyse data and using software method, hidden and unexpected patterns and relationships in sets of data can be extracte

What is a transaction, What is a Transaction? A transaction is an even...

What is a Transaction? A transaction is an event which happens on the database. Generally a transaction reads a value from the database or writes a value to the database. If y

Determine the persistent object, Determine the Persistent object Persis...

Determine the Persistent object Persistent object can be stored in one of the following: Files Cheap, permanent, simple storage Low level (Write, Read) Ap

Describe hashing in dbms, Describe Hashing in DBMS? Hashing: Hashing ...

Describe Hashing in DBMS? Hashing: Hashing is a technique to store data within an array so which storing, searching, inserting and deleting data is fast (in theory it's O(1))

Write short notes on domain relational calculus, Write short notes on domai...

Write short notes on domain relational calculus The domain relational calculus uses domain variables that take on values from an attribute domain rather than values for whole t

Write a query that uses the union operator, Write a Query that uses the UNI...

Write a Query that uses the UNION Operator 1. Use the Software Experts database to:   a. Display the first and the last name of all consultants who worked on any projects f

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd