Interface means “The way of communication performed in between a user and a Database management system” like query passing.
This interface is further divided into four categories on the basis of technology used.
- Menu based
- Form based
- Graphical user interface (GUI) based
- Natural language based
Let’s discuss them one by one in detail.
In this, all the options are displayed in form of a list or menu, through which we can select any option and that option leads us to the destination.
Example: When we search anything in a web browser then it shows all the possible results in a list manner, from which we can click on any option.
Or access any website, where all available options are arranged in menu form.
The latest SQL softwares provide the facility to perform different operations on Database with the help of these menu-based options, in which query writing is not required. Maximum commands are already arranged in form of a list or menu, in which we just need to select the command we wanted to perform.
Popup menus are the best example of it.
This interface provides an easy way to access, manipulate or insert data.
These are used at those places where browsing type operations are performed.
No need to follow any sequence or structure, we can access directly the required place in the database.
No need to remember all the coding or commands.
The rollback function is available, which means we can get back to the first position just by pressing back.
In network-based Databases, we can access any part of a database available on any server.
In this, a form type structure is shown to the user to insert data or operate data in a database.
Example: online form filling for exams.
This is also a good option to prevent redundancy because each and every user need to go through these forms to access or manipulate databases.
This concept makes computing very easy for those who have only basic knowledge of computer operation.
Commit buttons (submit/save/next) are given at the end of every form so that the last work done can be saved and only after that user can go further. Sometimes after clicking these commit buttons, we can’t change the old entries made. So before clicking on it we need to be very careful.
These forms follow a sequence to maintain the new data in a specific order.
Individual forms are popups for each query.
If a form is very big and split in small parts then all the parts of the form are filled by a user stored at one server.
Graphical User Interface Based
In this, all the available options are present as graphical symbols or buttons, like keys on the calculator.
All the possible queries are given in an image format to make the experience easy and smooth. Sometimes it follows a combination of form and menu-based interface.
In this the overall schema is represented as a graphical image, when we click on any specific part then the resulting query is executed.
This makes computing very fast because the user needs to use images instead of passing queries.
Online games are the best example of it. The user moves in which direction the related commands start functioning.
Natural Language Based
In this user can pass its query just by writing them in natural language (for computers it’s English).
To pass on a query to the database user need to follow a structure to write a query.
The wrong format can deny the operation.
These schemas are consisting of commands and keywords which are predefined.
In this user needs to understand and memories the format of queries and all the commands.
Sometimes the query runs on a different page and the output is displayed on a different page. This will make computing a little cozy.