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
Advantages of Data Distribution The primary benefit of distributed database systems is the ability to access and share data in a reliable and efficient manner.

Explain the Query Processing  Data Query Processing permits a user to report or analyze structured and unstructured data pulled from multiple data sources.

1.  Develop a flowchart using the decision structure to solve the following problem. A Box Lunch Bonanza is a small catering company that offers 2 different types of box lunches

Heap files (unordered file) Mostly these files are unordered files. It is the easiest and most basic type. These files having of randomly ordered records. The records will have

Differance between Open addressing and chaining for collision resolution ? In open addressing , proceeding from the occupied position specified by hash address the program che

Example : Create a sequence named SEQSS that starts at 105, has a step of 1 and can take maximum value as 2000.  CREATE SEQUENCE SEQSS START WITH 105 INCREMENT BY 1 MAX VA

Describe the algorithm for updating indices for a single level index when a record is    (i) Inserted  (ii)  deleted What will be the modification if there are multilevel in

What is Stored Procedure? A stored procedure is a named group of SQL statements that have been previously formed and kept in the server database. Stored procedures accept input

Explain Clustering file organization (i) Determine if a record of file is physically ordered on a nonkey field - that does not comprise a different value for each record - that

What is the use of RAID? A variety of disk-organization methods, collectively called redundant arrays of independent disks are used to better the performance and reliability.