User interface in database system

user interface is the view of a database interface that is seen by the user.
User interfaces are often graphical or at least partly graphical (GUI –
graphical user interface) constructed and offer tools which make the
interaction with the database easier.
of user interface in database system

Menu-based interfaces for web clients or browsing:
These interfaces present the user with lists of options, called menus, that
lead the user through the formulation of a request. Menus do away with the need
to memorize the specific commands and syntax of a query language; rather, the
query is composed step by step by picking options from a menu that is displayed
by the system.
Forms-based interfaces: A
forms-based interface displays a form to each user. Users can fill out all of
the form entries to insert new data, or they fill out only certain entries, in
which case the DBMS will retrieve matching data for the remaining entries.
Forms are usually designed and programmed for naive users as interfaces to
canned transactions.
Graphical user interfaces: A
graphical interface (CUI) typically displays a schema to the user in
diagrammatic form. The user can then specify a query by manipulating the
diagram. In many cases, CUIs utilize both menus and forms. Most CUIs use a
pointing device, such as a mouse, to pick certain parts of the displayed schema
Natural language interfaces: These
interfaces accept requests written in English or some other language and
attempt to “understand” them. A natural language interface usually
has its own “schema,” which is similar to the database conceptual
schema, as well as a dictionary of important words. The natural language
interface refers to the words in its schema, as well as to the set of standard
words in its dictionary, to interpret the request.
Interfaces for parametric users: Parametric
users, such as bank tellers, often have a small set of operations that they
must perform repeatedly. Systems analysts and programmers design and implement
a special interface for each known class of naive users. Usually, a small set
of abbreviated commands is included, with the goal of minimizing the number of
keystrokes required for each request.
Interfaces for the DBA: Most
database systems contain privileged commands that can be used only by the DBA’s
staff. These include commands for creating accounts, setting system parameters,
granting account authorization, changing a schema, and reorganizing the storage
structures of a database.

Leave a Comment Here