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?

Give expression in tuple calculus and domain calculus, Consider the subsequ...

Consider the subsequent relation schemes:  Project (Project#, Project_name, chief_architect)  Employee (Emp#, Empname)  Assigned_To (Project#, Emp#)  Give expression i

What is the main advantage of the object model, What is the main advantage ...

What is the main advantage of the object model? What are its different components? The object model focuses on the logical data structures. Each object model comprises of many

What is hierarchical dbms, What is Hierarchical DBMS In HDBMS, data is ...

What is Hierarchical DBMS In HDBMS, data is structured in a tree like manner. There is a parent-child relationship between data items and the data model is very suitable for re

Domains, Every simple attribute of an entity type have a possible set of va...

Every simple attribute of an entity type have a possible set of values that can be attached to it. This is known as the domain of an attribute. An attribute cannot have a value out

Product adder required for ecommerce website, Product adder required for Ec...

Product adder required for Ecommerce website Project Description: Want a product adder for 500 products I have a magento website and need products pulled from site A to my si

What are the advantages of object id, What are the advantages of object ID?...

What are the advantages of object ID? The main advantages of Object IDs are as below: i) IDs are not changing  ii) IDs are completely independent of the changes in data v

Create a database model, Submit the table creation statements (including co...

Submit the table creation statements (including constraints) for the Database Model. Submit them all in a single script file. Also submit a document explaining what test data yo

Views, what is view?explain

what is view?explain

What is oom, What is OOM? Object oriented modeling is an approach by wh...

What is OOM? Object oriented modeling is an approach by which modeling of systems is done by visualizing the system based on real world concepts. Object oriented modeling does

What are the constituents of file, What are the Constituents of File? Also ...

What are the Constituents of File? Also elaborates all the possible file operations? A file is organised logically as sequence of record. These records are mapped onto disk blo

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