PREVIOUS

What is Data warehouse?

Data warehouse is relational database used for query analysis and reporting. By definition data warehouse is Subject-oriented, Integrated, Non-volatile, Time variant.

Subject oriented : Data warehouse is maintained particular subject.

Integrated : Data collected from multiple sources integrated into a user readable unique format.

Non volatile : Maintain Historical date.

Time variant : data display the weekly, monthly, yearly.


What is Data mart?

A subset of data warehouse is called Data mart.


Difference between Data warehouse and Data mart?

Data warehouse is maintaining the total organization of data. Multiple data marts used in data warehouse. where as data mart is maintained only particular subject.


Difference between OLTP and OLAP?

OLTP is Online Transaction Processing. This is maintained current transactional data. That means insert, update and delete must be fast.

OLAP is Online Analytical Processing which will be used to analyze the business and will be helpful in taking decisions in betterment of the business.


Explain ODS?

Operational data store is a part of data warehouse. This is maintained only current transactional data.

ODS is subject oriented, integrated, volatile, current data.

NEXT