There are four different types of database-system users. differentiated by the manner they expect to interact with the system. Different types of user interfaces have been designed for the different types of users.
Naive users are unworldly users who interact with the system by raising one of the application plans that have been written antecedently. For illustration. a bank Teller who needs to reassign $ 50 from history A to account B raise a plan called transportation. This plan asks the Teller for the sum of money to be transferred. the history from which the money is to be transferred. and the history to which the money is to be transferred.
As another illustration. see a user who wishes to happen her history balance over the World Wide Web. Such a user may entree a signifier. where she enters her history figure. An application plan at the Web waiter so retrieves the history balance. utilizing the given history figure. and passes this information back to the user.
The typical user interface for naif users is a forms interface. where the user can make full in appropriate Fieldss of the signifier. Naive users may besides merely read studies generated from the database
Application coders are computing machine professionals who write application plans. Application coders can take from many tools to develop user interfaces. Rapid application development ( RAD ) tools are tools that enable an application coder to build signifiers and studies without composing a plan. There are besides particular types of scheduling linguistic communications that combine imperative control constructions ( for illustration. for cringles. while cringles and if-then-else statements ) with statements of the informations use linguistic communication.
These linguistic communications. sometimes called fourth-generation linguistic communications. frequently include particular characteristics to ease the coevals of signifiers and the show of informations on the screen. Most major commercial database systems include a fourthgeneration linguistic communication. Sophisticated users interact with the system without composing plans. Alternatively. they form their petitions in a database question linguistic communication. They submit each such question to a question processor. whose map is to interrupt down DML statements into instructions that the storage director understands. Analysts who submit questions to research informations in the database autumn in this class.
Online analytical processing ( OLAP ) tools simplify analysts’ undertakings by allowing them position sum-ups of informations in different ways. For case. an analyst can see entire gross revenues by part ( for illustration. North. South. East. andWest ) . or by merchandise. or by a combination of part and merchandise ( that is. entire gross revenues of each merchandise in each part ) . The tools besides permit the analyst to choose specific parts. expression at informations in more item ( for illustration. gross revenues by metropolis within a part ) or expression at the information in less item ( for illustration. sum merchandises together by class ) .
Another category of tools for analysts is data excavation tools. which help them happen certain sorts of forms in informations.
Specialized users are sophisticated users who write specialised database applications that do non suit into the traditional data-processing model. Among these applications are computer-aided design systems. knowledge base and adept systems. systems that shop informations with complex informations types ( for illustration. artworks informations and audio information ) . and environment-modeling systems.