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
#questiontypes of keys examples..

Nested Queries Let us see some more complex queries in this section. Sub-queries: Some of the basic concerns of sub-queries are: A sub-query is a SELECT statemen

Foreign Keys and NULL Let us take the relation:                 DEPT DEPT ID DNAME BUDGET D1 M

Our company hires independent contractors to install equipment at precise locations across North America. We want to track the installation data and generate reports. The compan

State the data flow diagram of functional model Any action initiated by transition in the state diagram can be extended into an entire data flow diagram in functional model. Th

What is the initial step for object-oriented designing The initial step for object-oriented designing is object modeling. Before we go into deep about object modeling first of

Related fields in a database are grouped in which form? Related data fields in a database are grouped to form a data record. (A record is a collection of related fields)

Recovery Techniques: After Reading the types of failures and database errors, let us talk about how to recover from the failures. Recovery can be complete using/restoring the previ

project on dbms

What is the State Machine Engine The straightest approach to implement control is to have any way of explicitly representing and executing state machines. With the help of thi