Talking City

Go Back   Talking City > Coding and Programming > Database Forum
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Thread Tools Search this Thread Display Modes
Old 09-12-2008, 09:24 AM
Ruby17's Avatar
Ruby17 Ruby17 is offline
Join Date: Sep 2008
Location: chandigarh ,India
Posts: 56
Ruby17 is on a distinguished road
Arrow Logical and physical view of DBMS.

Logical view and physical view

A database management system provides the ability for many different users to share data and process resources. But as there can be many different users, there are many different database needs. The question now is: How can a single, unified database meet the differing requirement of so many users?

A DBMS minimizes these problems by providing two views of the database data: a physical view and a logical view.


The physical view deals with the actual, physical arrangement and location of data in the direct access storage devices(DASDs). Database specialists use the physical view to make efficient use of storage and processing resources. Users, however, may wish to see data differently from how they are stored, and they do not want to know all the technical details of physical storage. After all, a business user is primarily interested in using the information, not in how it is stored.

The logical view/userís view, of a database program represents data in a format that is meaningful to a user and to the software programs that process those data. That is, the logical view tells the user, in user terms, what is in the database. One strength of a DBMS is that while there is only one physical view of the data, there can be an endless number of different logical views. This feature allows users to see database information in a more business-related way rather than from a technical, processing viewpoint. Thus the logical view refers to the way user views data, and the physical view to the way the data are physically stored and processed...

Reply With Quote
Old 11-13-2008, 04:12 PM
trinitybrown trinitybrown is offline
Junior Member
Join Date: Oct 2008
Location: UK
Posts: 8
trinitybrown is on a distinguished road

Very good article and really informative, can you explore it more or either tell me link of this article
Reply With Quote
Old 12-24-2008, 03:26 PM
Jenniferlinn Jenniferlinn is offline
Junior Member
Join Date: Dec 2008
Location: UK
Posts: 10
Jenniferlinn is on a distinguished road

Thanks for the post, I must say it's really very good article, keep posting
Reply With Quote
Old 12-16-2009, 11:47 AM
emily123 emily123 is offline
Junior Member
Join Date: Dec 2009
Posts: 7
emily123 is on a distinguished road

I agree with tremayne. Posting parts of wikipedia articles have absolutely no interest. We are only interested by your thoughts about this. For instance do you understand the differences between physical and logical view ? For instance, are you ready to tell your boss he must buy a very expensive RDBMS manager because it is able to create a materialized view of a complex external join whereas his current database manager cannot ?

Reply With Quote
Old 10-06-2015, 10:38 AM
sonia sharma sonia sharma is offline
Senior Member
Join Date: Jul 2015
Posts: 156
sonia sharma is on a distinguished road

Very nice and useful information. Thank you for sharing...
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

All times are GMT +5.5. The time now is 08:21 PM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Talking City Managed by Megrisoft