Database Management System(DBMS) Interface in Database
Casual end users use a high level query language to specify their requests whereas programmer use the DML in its embedded form.Naive and parametric users use user friendly interfaces for interacting with the database.These can also be used by casual users or others who do not want to learn the details of a high level query language.
DBMS interfaces are
- Menu based Interface.
- Form based Interface.
- Graphical user Interface.
- Natural language Interface.
- Interfaces for parametric users.
- Interfaces for the DBA.
Menu based Interface
These interfaces present the users with lists of options that lead the user through the formulation of a request.Menu do away the need to memorize the specific commands and syntax of query language.Pull down menu are a popular technique in web based user interfaces.They are also often used in browsing interfaces which allow a user to look through the contents of a database in an unstructured manner.
Form based interfaces
A form based interface displays a form to each user.Users can fill out all of the form entries to insert new data or they can fill out only certain entries.Forms are usually designed and programmed for naive users as interfaces to canned transaction.Oracle forms is a component of the oracle product suite that provides an extensive set of features to design and build applications using forms.
Graphical user interface
A graphical user interface displays a schema to the user in diagrammatic form.The user then can specify a query by manipulating the diagram.GUI utilize both menu and forms.Most GUI use a pointing device such as mouse to select certain parts of the displayed schema.
Natural Language Schema
These interfaces accepts requests written in English or some other language.A natural language interface 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.If the interpretation is successful the interface generates a high level query corresponding to the natural language request and submits it to the DBMS for processing otherwise a dialogue is started with the user to clarify the request.
Interfaces for parametric users
Parametric users such as bank tellers often have a small set of operations that they must perform repeatedly.
Interfaces for the DBA
Most database systems contain privileged commands that can be used only by the DBA staff.These include commands for creating accounts,setting system parameters,changing a schema,reorganizing the storage structure of a database.
0 Comments