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
Whst is logical schema ? Logical schema is the entire database.


What is OLTP (Online Transaction Processing)? In OLTP - online transaction processing systems relational database design use the discipline of data modeling and generally follo

What are the two integrity rules?  Ans:  The two integrity rules are: Entity Integrity Rule & Referential Integrity Rule.   Entity Integrity Rule - If the attribute A of rel

what is attribute is attribute inheritance in dbms?

Submit the table creation statements (including constraints) for the Database Model. Submit them all in a single script file. Also submit a document explaining what test data yo


What is vertical fragmentation? Vertical fragmentation divides the relation by decomposing the scheme R of relation r.

What is Identity? Identity (or AutoNumber) is a column that automatically produces numeric values. A start and increment value can be set, but most DBA leave these at 1. A GUID

Equi Join: A join in which the joining condition is based on equality among values in the common columns. Common columns show (redundantly) in the result table. Let us Consider th