Views-data control, Database Management System


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
Describe sequential file organization.  Explain the rules for (i)  Inserting a new record. (ii)  Deleting an existing record.          Ans:A sequential f

Explain the utilities which help the DBA to manage the database? Every DBA uses database utilities to maintain and control their databases. But there is a lot of confusion wit

Use the IRIS dataset that comes with Weka to compare the classification performance of the following algorithms. 1. NaiveBayesSimple 2. MultiLayerPerceptron J48 (

Describe Object Relational model ? Object Relational Model - This model combines the characteristics of both relational model and object oriented model. It extends the tradit

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

I need to Map an E-R diagram to a relational schema

How external/conceptual mapping and conceptual /internal mapping is performed

What are the ways of obtaining the connection parameters?  Hardwire the parameters into the program. Ask for the parameters interactively. Get the parameters

#floating point representation is used to store