Data Ware House And Oltp Data Bases

  • Uploaded by: Deepanshu
  • 0
  • 0
  • May 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Data Ware House And Oltp Data Bases as PDF for free.

More details

  • Words: 268
  • Pages: 1
Data ware house and OLTP Data bases The data warehouse and the OLTP data base are both relational 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 application used 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 also contain data extracted from external data sources. The differences between these two relational databases, is tabulated below for information. Data warehouse database

OLTP database

Designed for analysis of business measures by categories and attributes

Designed for real time business operations.

Optimized for bulk loads and Optimized for a common set large, complex, unpredictable of transactions, usually queries that access many adding or retrieving a single rows per table. row at a time per table. Optimized for validation of Loaded with consistent, valid incoming data during data; requires no real time transactions; uses validation validation data tables. Supports few concurrent users relative to OLTP

Supports thousands of concurrent users.

However, the data warehouse supports OLTP system by providing a place for the latter to offload data as it accumulates and by providing services which would otherwise degrade the performance of the database. Posted in DWH Concepts, Data flow | Tagged Data flow, DWH | No Comments Yet

Related Documents

Data Ware
November 2019 18
Data Bases
June 2020 3
House Building Cost Data
October 2019 29
Data Were House
June 2020 5

More Documents from ""