presentation on data warehousing

8/19/2019 Presentation on Data Warehousing

1/12

Prepared By:

Group 6

15P017 – Devyash Jain

15P024 – Ishita Dwivedi

15P026 – Kalpesh Sadani

15P033 – Mridl !hansali

15P050 – "ive# Sis$dia

15P051 – Siddharth %pta

Data Warehousing


2/12

Data and Database

Data is in&$r'ati$n in raw $rn$r)ani*ed &$r' +s,h as alpha-ets.n'-ers. $r sy'-$ls/ that re&er t$.

$r represent. ,$nditi$ns. ideas. $r $-e,tsData is li'itless and )r$win) at a rapid pa,e

database is a ,$lle,ti$n $& in&$r'ati$nthat is $r)ani*ed s$ that it ,an easily -ea,,essed. 'ana)ed. and pdated


3/12

Why Data Warehouse ?Taking Business Decisions


4/12

What is a Data Warehouse?

spe,ial type $& data-ase

sin)le. ,$'plete and ,$nsistent st$re $& data

Data $-tained &r$' dierent s$r,es

Made availa-le t$ end sers in a &$r' they ,annderstand and se in a -siness ,$ntet

Data wareh$se plat&$r's pr$vide -sinesspe$ple with a wind$w int$ their $r)ani*ati$nshist$ri,al a,tivities -$th s,,esses and&ailres


5/12


6/12

Data Warehouse Architecture: with a Staging Area

perati$nal Data 'st -e ,leansed andpr$,essed -e&$re pttin) it int$ the wareh$se

M$st data wareh$ses se a staging area &$r

this prp$se


7/12

OTP !s OAP8e ,an divide I9 syste's int$ $nline

transa,ti$nal pr$,essin) +:9P/ and $nlineanalyti,al pr$,essin) +:P/

In )eneral we ,an ass'e that :9P

syste's pr$vide s$r,e data t$ datawareh$ses. whereas :P syste's help t$analy*e it


8/12

OTP !s OAPOTP

"Operationa#Syste$%

OAP

"Data Warehouse%

S$r,e $& data perati$nal data;:9Ps are the $ri)inals$r,e $& the data

eveals a snapsh$t $&$n)$in) -siness

pr$,esses

Mltidi'ensi$nalviews $& vari$s #inds

$& -siness a,tivities?eries >elatively

standardi*ed andsi'ple @eries>etrnin) relatively&ew re,$rds

&ten ,$'ple@eries inv$lvin)a))re)ati$ns

Spa,e >e@ire'ents


9/12

&ey 'haracteristics o( a DW)

Data is str,tred &$r si'pli,ity $& a,,ess andhi)hspeed @ery per&$r'an,e

And sers are ti'esensitive and desire speed$&

th$)ht resp$nse ti'es:ar)e a'$nts $& hist$ri,al data are sed

?eries $&ten retrieve lar)e a'$nts $& data.perhaps 'any th$sands $& r$ws

!$th predeBned and ad h$, @eries are ,$''$n 9he data l$ad inv$lves 'ltiple s$r,es and

trans&$r'ati$ns


10/12

Why Do We *eed DataWarehouses?


11/12


12/12

Thank +ou,-uestions?

presentation on data warehousing

Documents