The structured query language, Database Management System

The Structured Query Language

INTRODUCTION

Database is an organised set of information about an entity having controlled redundancy and serves numerous applications. DBMS (database management system) is application software that is developed to make and influence the data in database. A query language can simply access a data in a database. SQL (Structured Query Language) is language used by most relational database systems. IBM developed the SQL language in mid-1979. All communication with the RDBMS and the clients or among RDBMS is by SQL. Whether the client is a disguised engine or a basic SQL engine such as a GUI, one RDBMS talking to another or report writer, SQL statements pass from the client to the server. The server responds by processing the SQL and returning the results. The benefits of this approach are that the only network traffic is the first query and the resulting response. The processing power of the client is reserved for running the application.

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 is a fourth generation language. SQL has many more benefits and features. It should be noted that a lot of commercial DBMS may or may not execute all the details given in this unit. For instance, MS-ACCESS does not support some of these features. Even some of the constructs  may  not  be  portable,  please  consult  the  DBMS  Help  for  any  such dissimilarity.

 

 

Posted Date: 3/8/2013 6:18:57 AM | Location : United States







Related Discussions:- The structured query language, Assignment Help, Ask Question on The structured query language, Get Answer, Expert's Help, The structured query language Discussions

Write discussion on The structured query language
Your posts are moderated
Related Questions
Read the description below and draw an Entity-Relationship diagram for it. You must use the symbols described in the course materials. This database will help the Parents Assocc

What are the two types of indices? The two types of indices are:- A)     Dense index B)      Sparse index

Consider the following relations:  S (S#, SNAME, STATUS, CITY)  SP (S#, P#, QTY)  P (P#, PNAME, COLOR, WEIGHT, CITY) Give an expression within SQL for each of queries b

What are the physical characteristics of magnetic disks?   Ans: A magnetic disk is a circular plate or platter of plastic or metal that is coated with magnetizable material lik

What are the disadvantages of file processing system? The drawbacks of file processing systems are a) Data redundancy and inconsistency b) Complexity in accessing data

Control as a State Machine Engine First let us define the state machine: "the state machine is a machine which is an object but not an application object. It is a part of lang

What is the use of a slotted-page structure and what is the information are there in the header? The slotted-page structure is used for organizing records within a one block.

What are the two types of errors? The two types of errors are: a) Logical error b) System error

Question 1 List and explain various Normal Forms. How BCNF differs from the Third Normal Form and 4th Normal forms? Question 2 Describe the concepts of Structural Semantic Da

Isolation or Independence : The isolation property shows that the updates of a transaction should not be visible till they are committed. Isolation assurance that the progresses of