Sources of utilities for a dbms, Database Management System

There are three main sources of utilities and applications for a DBMS:

a. Vendor applications and utilities are given for working with or maintaining the database, and generally allow users to manipulate and create a database without the need to write custom applications.

b. User applications are usually custom-made application programs written for a exact purpose using a conventional programming language. This programming language is joined to the DBMS query language by the application program interface (API). This permits the user to utilise the power of the DBMS query language with the flexibility of a custom application.

c. Third party applications may be same to those given by the vendor, but with enhancements, or they may load a perceived need that the vendor hasn't formed an application for. They can also be same to user applications, being written for a definite purpose they think a large majority of users will need.

Posted Date: 3/6/2013 5:04:32 AM | Location : United States







Related Discussions:- Sources of utilities for a dbms, Assignment Help, Ask Question on Sources of utilities for a dbms, Get Answer, Expert's Help, Sources of utilities for a dbms Discussions

Write discussion on Sources of utilities for a dbms
Your posts are moderated
Related Questions
Explain what is Aggregation ? Aggregation: This is used whenever we intend to show a relationship between an entity and the relationship. There is no provision for this in th

Define outer union operation of the relational algebra. Compute the outer union for the relations R and S given below. Outer Join - If there are any values in one tabl

differences between a classified catalog and a dictionary catalog

What is system log?  What are the entries?       Ans:  The system log that is generally written on stable storage contains the redundant data required to recover from volatile

What is the difference between a key and a superkey? Key - A key a single attribute or a combination of two or more attributes of an entity set which is used to identify one

Eliminate Redundant Data In the "Database Relation" above, the primary key is made up of the D-ID and the Emp-ID. The database-name relies only on the D-ID. The similar databas

What is database Trigger? A database trigger is a PL/SQL block that can explained to automatically execute for insert, update, and delete statements against a table. The trigge

These are interactive interfaces, graphical that hide the difficulty of the DBMS and query language behind an intuitive, simple to understand, and convenient interface. This permit

One-to-one relationship: For every 1:1 relationship type R in the ER diagram including two entities E1 and E2 we take one of entities (say E1) preferably with total participatio

Run the following queries. For each query show 1) What you expect the output to be based upon the data 2) the SQL code and 3) the output running the query in Oracle. 1. Show all c