Data warehousing, What is the difference between OLTP and OLAP

Anonymous

Question Description

What is the difference between OLTP and OLAP?

What is real-time data warehousing?

What is ODS?

What is the difference between View and Materialized View?

What is ETL?

What is VLDB?


Tutor Answer

DR_SHINAWATA
School: Boston College

Attached.

Running Head: DATA WAREHOUSING

1

Data Warehousing
Institutional Affiliation
Date

DATA WAREHOUSING

2

Data warehouse

Data warehousing involve the catch of information from many sources for valuable investigation
and access, however does not by and large begin from the perspective of the end client who may
require access to specific, here and there neighborhood databases. There are two ways to deal
with data warehousing, top down and bottom up. The top-down approach turns o...

flag Report DMCA
Review

Anonymous
Return customer, been using sp for a good two years now.

Anonymous
Thanks as always for the good work!

Anonymous
Excellent job

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors