In most of print works, 300 dpi is standard print resolution. The standard resolution for web is 72 dpi. This works best in computer screens. If you you're scanning in an image and only going to use it for web you could maintain it at 72 dpi. Film print’s standard resolution on other hand is 720 dpi. That way you can make enlargements. The general rule with resolution is that never go up but you can always go down. If you have a 720 dpi image, you can at any rate bring it down to 300 dpi and still look sound.

If you are using photographs for your web, scan them at 72 or 100 dpi.72 dpi is screen resolution and preferred format for saving image is jpeg though you can also use .psd. Remember that when you Save As, you are creating a copy of your current document and you are decreasing its file size. You can also save your file within Photoshop. This will allow you to preview your work to adjust quality of same. If image is really huge, simply go to Image > Image Size and bring down resolution to 300 for print or 72 for web or change image dimensions if it is indispensable.

Data from different data sources is stored in a relational database for end use analysis Data is organized in summarized, aggregated, subject oriented, non volatile patterns.

Data is a data warehouse is consolidated, flexible collection of data Supports analysis of data but does not support online analysis of data.

Online Analytical Processing

A tool to evaluate and analyze data in data warehouse using analytical queries.

A tool which helps organize data in data warehouse using multidimensional models of data aggregation and summarization.

Supports data analyst in real time and enables online analysis of data with speed and flexibility.

Ralph Kimball co-founder of data warehousing concept has defined data warehouse as a “"a copy of transaction data specifically structured for query and analysis”.

Both definitions highlight specific features of data warehouse. The former definition focuses on structure and organization of data and latter focuses upon usage of data. However, a listing of features of a data warehouse would necessarily include aspects highlighted in both these definitions.

For more visualization of this article along with screen shots and more visit http://www.exforsys.com/content/category/17/253/332/