Data Warehousing

Data Warehousing

When the vast amount of information is gathered it is to be properly stored. The storage should be so designed that the retrieval of information from giga bits of data is simple, quick and reliable. The data warehouse is thus a storage system in which billions of bits of data are classified and arranged for easy reach. There is a close similarity between ordinary warehouses and data warehouses.

Definition : Data warehouse is a subject-oriented, integrated, non volatile and time-variant collection of data in support of management decisions.

Subject oriented – information is stored as per topics and relevance to each other. Like the books which are arranged on shelves in the library.

Non volatile – data collected is not allowed to be lost.

Time-variant – means that data items are continuously being updated in the warehouse.

Important characteristics of data warehouse are

Data collected from many sources

Organization of data is in systematic manner to facilitate easy access when required.

Follows protocols, procedures and directions for easy use

Emphasis is on product, vendor, customer, activity etc.

Applications of Data Warehouses

Any organization which has a large turnover of business or dealings with a large number of individuals like a university will stand to benefit by the development of data warehouse provided the cost of such an activity is justified by the gins obtained.

Banking Telephone companies

Marketing Insurance

Why Data Warehouse – Reasons for the development of Data Warehouses

• Availability of sophisticated computers at low prices which has more space and high storing capacity (memory)

• Use of advanced technology concepts such as credit cards, e-cash etc

• Extent of computerized processing required for generation of reports for decision making.

• Customer requirements and demands

• Customer relationship management

• Social impact of modern methods

•...