Commercial database architecture, Database Management System

At its most essential level the DBMS architecture can be divide into two parts: the back end and the front end.

The back end is responsible for managing the physical database and giving the essential support and mappings for the conceptual, internal and external levels. Other advantages of a DBMS, such as integrity, security and access control, are also the duty of the back end.

The front end is really just any application that runs on top of the DBMS. These may be applications given by the DBMS vendor, the user, or a third party. The user deals with the front end, and may not even be aware that the back end exists. This interaction is complete through Applications and Utilities which are the major interface to the DBMS for most users.

Posted Date: 3/6/2013 5:03:33 AM | Location : United States







Related Discussions:- Commercial database architecture, Assignment Help, Ask Question on Commercial database architecture, Get Answer, Expert's Help, Commercial database architecture Discussions

Write discussion on Commercial database architecture
Your posts are moderated
Related Questions
Define a table in SQL known as Client that is used to store information about the clients. Define CLIENT_NO as the primary key whose first letter must begin with ‘C'. Also ensure t

What are the features of embedded SQL? Explain. Embedded SQL - SQL could be implemented within two ways. It can be used interactively or embedded in a host language or throu

Which component is not included in database environment ? A users component is not included in database environment.

Define lock? Lock is the most common used to execute the requirement is to permit a transaction to access a data item only if it is currently holding a lock on that item.

Describe the development process of Object oriented methods Object oriented methods have roots which are strongly anchored back in the 60s, functional and structured methods we

Draw the database using the ER approach and then make the tables accordingly. Populate the tables so that every table have at least 10 tuples. Then using Java and SQL, execute the

Define what Immediate database modification technique uses?  Ans: Both undo and redo.

Define the Two Phase Locking Protocol This is a protocol that is used to make sure serializability of transactions. This protocol needs that every transaction issue lock and u

Why did SAP introduce the extended star schema? Explain why it is reported to be better than the traditional schema model?

An ideal data dictionary should have everything a DBA wants to know about the database. 1 Conceptual, External, and internal database descriptions. 2.    Descriptions of attr