The data warehouse and the OLTP data base are bothrelational databases. However, the objectives of both these databases are different.

The OLTP database records transactions in real time and aims to automate clerical data ENTRY processes of a business entity. Addition, modification and deletion of data in the OLTP database is ESSENTIAL and the semantics of the applicationused in the front end impact on the organization of the data in the database.

The data warehouse on the other HAND does not cater to real time operational requirements of the enterprise. It is more a storehouse of CURRENT and historical data and may alsocontain data extracted from external data sources.

The data warehouse and the OLTP data base are bothrelational databases. However, the objectives of both these databases are different.

The OLTP database records transactions in real time and aims to automate clerical data entry processes of a business entity. Addition, modification and deletion of data in the OLTP database is essential and the semantics of the applicationused in the front end impact on the organization of the data in the database.

The data warehouse on the other hand does not cater to real time operational requirements of the enterprise. It is more a storehouse of current and historical data and may alsocontain data extracted from external data sources.