Scribd
Upload
141 views1 page

Overview of DBMS Languages and Interfaces

This document discusses database management system languages and interfaces. It describes the different types of database languages, including data definition language, storage definition language, view definition language, and data manipulation language. It also notes that SQL is commonly used as the de facto standard language. Finally, it outlines various interfaces for database users, including menu-based, forms-based, GUI, natural language, and specialized interfaces for parametric users and database administrators.

Uploaded by

wuvesevar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
141 views1 page

Overview of DBMS Languages and Interfaces

This document discusses database management system languages and interfaces. It describes the different types of database languages, including data definition language, storage definition language, view definition language, and data manipulation language. It also notes that SQL is commonly used as the de facto standard language. Finally, it outlines various interfaces for database users, including menu-based, forms-based, GUI, natural language, and specialized interfaces for parametric users and database administrators.

Uploaded by

wuvesevar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Database Management Systems (10cs54)

Database Languages and Interfaces

A DBMS supports a variety of users and must provide appropriate languages and
interfaces for each category of users.

DBMS Languages
DDL (Data Definition Language): used (by the DBA and/or database designers)
to specify the conceptual schema.
SDL (Storage Definition Language): used for specifying the internal schema
VDL (View Definition Language): used for specifying the external schemas (i.e.,
user views)
DML (Data Manipulation Language): used for performing operations such as
retrieval and update upon the populated database. The above description represents
some kind of ideal. In real-life, at least so far, the de facto standard DBMS language
is SQL (Standard Query Language), which has constructs to support the functions
needed by DDL, VDL, and DML languages. (Early versions of SQL had features in
support of SDL functions, but no more.)

DBMS Languages

Menu-based, forms-based, gui-based, natural language, special purpose for


parametric users, for DBA.

DBMS Interfaces

Menu-based interfaces for web clients or browsing


Forms-based interfaces
GUI's
Natural Language Interfaces
Speech Input and Output
Interfaces for parametric users
Interfaces for the DBA

You might also like