Overview of Database Management System (DBMS) Part – 8
Database End Users plus End User Interfaces
There are four (4) dissimilar kinds of database application end users, distinguished by means of the method they imagine to work with the database application. Dissimilar kinds of end user interfaces have been planned for the dissimilar kinds of end users.
1. Inexperienced end users are naive end users who work with the database application by means of raising one (1) of the database system programs which have been coded before. For an instance, a bank employee who wants to transfer $ 10 from one account to another account invokes a software code named as Transfer. This software code requests the employee to enter the amount of money that need to be transferred, and the debiting account number from which the money will be transferred, as well as the crediting account number to which the money will be transferred.
Consider another instance, where an end user desires to know his or her outstanding account balance over the net banking facility. Such an end user may possibly use a web form, in which he or she can input his or her account number. A database application program which is at the web server then and there recovers the outstanding account balance, by means of the provided account number, as well as shows this data back to the end user. The classic end user interface for inexperienced end users is a web form interface, where the end user can provide the proper information at the required fields of the web form. Inexperienced end users may possibly also just read reports produced by the database application.
2. Database application programmer is computer specialists who do the coding part of the database application. Database application programmers can select from numerous tools to design the end user interfaces. Fast application designing tools allow a database application programmer to build web or windows forms as well as reports devoid of writing a software code. There are extraordinary kinds of program writing languages which combine domineering control constructions like – for loop, do – while loop, while loop, switch – case statement as well as if – else statements along with the code of the data manipulation language (DML). These languages, occasionally are referred as 4th generation languages, frequently contain extraordinary features to simplify the development of the web or windows forms as well as to present the information on the screen. A maximum main business database application system is comprised of a 4th generation language.
3. Classy end users work with the database application system devoid of writing software programs. As an alternative, they formulate their demands in a database query language with the help of Structured Query Language (SQL). They give every single such type of query to a query processor, whose job is to slice down the Data Manipulation Language (DML) statements and turn it into instructions which the storing manager will recognize. Specialists who give these queries to discover information in the database belongs to this group. Online analytical processing (OLAP) make things easier for the analysts by means of permitting them to view outlines of information in diverse methods. For an example, an expert can get entire sales of the company by area – wise, or product – wise, or by a grouping of area – wise as well as product – wise, which are the entire sales of every single product in every area. The tools allow the specialist to choose the exact areas and to take a look at information in further detail like – sales by city in an area or else to take a look at the information with fewer details like – total products sold collectively in a category. An additional group of tools for specialists is information mining, which benefit them in discovering convinced types of patterns in information.
4. Expert end users are classy end users who compose dedicated database application systems which do not apt in the outmoded information handling outline. And the systems are computer aided design application, information based as well as skilled applications, and the applications which stock information with composite data types like – pictures as well as audio & video, along with the environment displaying application.
Database Management System (DBMS) Architecture plus Information Independence
Three (3) significant features of the database methodology are (1) separation of software programs as well as information which is the software program – information plus software program – job independence; (2) provision of several end users working simultaneously; (3) practice of a catalog to stock the database definition (schema).
In this section the architecture of database systems, usually known as the three tire architecture, will be discussed, this was planned to benefit the achievement as well as the visualization of these features. Then the idea of information independence has been discussed.
In the upcoming part we will be discussing the Three Tire Architecture and the Information Independence.