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
how to prepare a data dictionary for online examination system for certified courses?

Define What are the desirable properties of a decomposition Ans: What are the desirable properties of decomposition - dependency preserving.  Because Lossless join and dependen

For every n-ary relationship type R where n>2, we make a new table S to represent R. We contain as foreign key attributes in s the primary keys of the relations that show the parti

Given the subsequent relations:    vehicle (reg_no, make, colour)    Person (eno, name, address)    Owner (eno, reg_no)   Write expressions

Task Partitioning, Sequencing and Project Planning The tasks required for the service might be broadly partitioned into: 0.      Set up database tables and account file

Problem 1. Write an assembly program to find the smallest among two numbers Writing an assembly program to find the smallest among two numbers 2. Explain the intern

What is Alternate Key Alternate Key: This is the candidate key which is not taken as the primary key of the table. They are named so because although not the primary key, the

INSERT INTO command : Values can be inserted for all columns or for the selected columns Values can be given by sub query. In place of values parameter substitution

The Third Normal Form (3NF) Even though, transforming a relation that is not in 2NF into a number of relations that are in 2NF take out many of the anomalies, it does not neces

1. Explain different addressing modes of 8086 Explanation of all addressing modes 2. Write a sequence of instructions to exchange two register contents using stack