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
For Colorado customers calculate the number of single products ordered. If a product is purchased on multiple orders, it should be counted only single time. The result should conta

Dirty Reads: T10 reads a value which is updated by T9. This update has not been committed and T9 aborts. T9 T10 Value of x old value = 200

Load sample data into the database tables design and test queries to return the following information • All rows and columns for employees • All rows and columns for customers •

What is catalog in DBMS? Catalog - A relational DBMS maintains information about every table and index in which it contains. A catalog is a collection of special tables that st

What are the costs to be considered when a transaction has to be rolled back when recovering from deadlock?         Ans: A few transaction will must rolled back (made a victim)

We will explain here an example database application having COLLEGE database and use it in showing several E-R modelling concepts. College database remains track of faculty, Stu

Q.   Explain  data aggregatio n and discuss different design constraints. Sol. Aggregation   One limitation of the E-R model is that it cannot express relationships amon

Distributed query and transaction processing a.  Construct a query around any one of the functional divisions you made in 4a such that if executed in the distributed design of 4

Explain the Log Based Recovery Method? The system log that is generally written on stable storage consists of the redundant data required to recover from volatile storage failu

What is the use of unique function? UNIQUE function: If UNIQUE is specified then only unique values are used to computed the mean.