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
These are designed to reduce the effects of a database failure and make sure a database is restored to a consistent state if a failure does arise. Manual backup/restore utilities n

how can apply joins on table

What is a transaction ? The Transaction is a unit of data processing. For instance, many of the transactions at a bank may be withdrawal or deposit of money; transfer of money f

While using extract datasets it is required to have a special workarea for interface False.  It is not required to have a special workarea for interface

What are the advantages of object oriented databases in comparison with others? Why it is still not widely used? Object oriented designs are coherent, efficient and less prone

Define the concept of Object Diagram An object diagram shows a set of the objects and their relationships with each other at a point of time. In a static view, object diagram

What is meant by object identifiers? Object-oriented systems use an object identifier to recognize objects. Object identifiers are unique: that is every object has a single ide

The following data are required to be stored by a family physician. Family#, FamilyAddress, Patient#, PatientName, ServiceCode, ServiceFee, ServiceDate A family can have seve

Discuss the problem of Spurious tuples and how we may prevent it.    Ans:  A spurious tuple is, mainly, a record in a database that gets created while two tables are joined bad

Can a domain, assigned to a data element be changed? Yes.  We can do so by just overwriting the entry in the field domain.