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
construct a B+ tree for the following set of key value (2,3,5,7,11,19,23,29,31) in ascending order where the pointers that will fit in one node is as follows:A. four B. six C. eigh

Single Valued Normalisation  Codd in the year 1972 formed three normal forms (1NF, 2NF, and 3NF). These were based on functional dependencies between the attributes of a relati

Availability: A site having the copy of a replicated relation fails, even then the relation may be found in another site. Therefore, the system may carry on to process at least th

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? HAVING CLAUSE - HAVING CLAUSE is used only with SELECT statement. - It is normally used in a GROUP BY

Why do so various organizations use MySQL? Advantages: Open source Highly efficient Offers a high scalability in terms of size and connectivity. Highly prote

Given the following set of functional dependencies {cf→ bg, g → d, cdg → f, b → de, d → c} defined on R(b,c,d,e,f,g) a. Is cf→ e implied by the FDs? b. Is dg a superkey?

What are uncommitted modifications? The immediate-modification technique permits database modifications to be output to the database whereas the transaction is still in the act

What is Asterisk in SQL? Asterisk (*): In SQL, the columns for all the tables and views in the FROM clause will be displayed.

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)

What is Conceptual Schema? Conceptual Schema - Conceptual schema elaborates the structure of the overall database for a community of users. It hides the details of physical sto