Define view? how it is related to data independence, Database Management System


A View may be defined of as a virtual table, that is, a table that does not really exist in its own right but is instead inferred from one or more underlying base data table. There is no stored file that direct shows the view instead a definition of view is loaded in data dictionary. Restructuring and growth of base tables is not shown in views. Thus the view may insulate end users from the effects of developing and growth in the database.




Posted Date: 7/30/2012 1:38:35 AM | Location : United States

Related Discussions:- Define view? how it is related to data independence, Assignment Help, Ask Question on Define view? how it is related to data independence, Get Answer, Expert's Help, Define view? how it is related to data independence Discussions

Write discussion on Define view? how it is related to data independence
Your posts are moderated
Related Questions
State about the Activity Diagram Activity diagrams show flow from one activity to other. It is an ongoing non atomic execution within a state machine. Activity finally results

Define Query Processing Query processing is the process of selecting the best plan or strategy to be employed in responding to a database request. The plan is then executed to

The Transactions- A transaction is definite as the unit of work in a database system. Database systems that deal with a huge number of transactions are also termed as transaction p

Consider the subsequent relations for a database which keeps track of business trips of salespersons in a sales office: SALESPERSON (SSN, Name, start_year, Dept_no) TRIP (SSN, Fr

What is SQL Profiler? SQL Profiler is a graphical tool that permits system administrators to monitor events in an instance of Microsoft SQL Server. You can capture and save dat

Selective replication: This is a combination of generating small fragments of relation and replicating them rather than a entire relation. The data should be fragmented on require

real life situations where database management system are most suitable

Convert the following ER - diagram (Entity Relationship Diagram) into a relational database (the primary keys are underlined):       Ans:  The relational database schema f

What is the difference between link and reference? The fundamental difference between links and references is that links are symmetrical on the other hand references refer only

what are the reasons having variable length records