Views-data control, Database Management System

Views

A view is like a window by which data from tables can be changed or viewed. The table on which a view is based is known as Base table. The view is stored as a SELECT statement in the data dictionary. When the user needs to retrieve data, using view. Then the following steps are defined.

1)  View definition is finding from data dictionary table. For example, the view definitions in oracle are to be finding from table name USER-VIEWS.

2)  Checks access privileges for the view base table.

3)  Changes the view query into an equivalent operation on the underlying base table

 

 

Posted Date: 3/11/2013 1:19:52 AM | Location : United States







Related Discussions:- Views-data control, Assignment Help, Ask Question on Views-data control, Get Answer, Expert's Help, Views-data control Discussions

Write discussion on Views-data control
Your posts are moderated
Related Questions
a set of possible data value of an attribute is called??

Greater potential for bugs: Since the sites of a distributed system operate simultaneously, it is more complex to ensure the correctness of algorithms. The art of constructing dis

What is the difference between SQL Server 2000 complete and differential backups? A complete backup makes a copy of the whole database. A differential backup creates a copy of

Failure Controlling Methods: Failures can be handled using different recovery methods that are talk about later in the unit. But the first question is doing we really require recov

What is data integrity? Ans: It is the data consisted of in database that is accurate and consistent.  (Data integrity means that the data should be valid as per to the give

Which operator is Cartesian product in relational algebra? Cartesian product in relational algebra is a binary operator. (It requires two operands. e.g., P X Q)

Can a domain, assigned to a data element be changed? Yes.  We can do so by just overwriting the entry in the field domain.

Describe the storage structure of indexed sequential files and their access method. Ans: Index offers a lookup capability to rapidly reach the vicinity of the desired record.

What are audit trails? An audit trail is a log of all alters to the database along with information like which user performed the change and when the alter was performed.

Explain Hierarchical Model ? Hierarchical Model - It was established to model several kinds of hierarchical organizations which exist in the real world. It uses tree structur