KOTC Posted January 29, 2013 Report Posted January 29, 2013 http://datawarehouse4u.info/OLTP-vs-OLAP.html zara detail ga chepandi vayya ini rojulu madi OLTP anukuna kadhu OLAP?
peru_edaite_enti Posted January 29, 2013 Report Posted January 29, 2013 retail sector lo oltp vadutaru ani gurtundi KOTC,that too if systems connected to DB are operational from stores or such ... maadi retail sector ee...
KOTC Posted January 29, 2013 Author Report Posted January 29, 2013 [quote name='CBZ' timestamp='1359484012' post='1303196329'] retail sector lo oltp vadutaru ani gurtundi KOTC,that too if systems connected to DB are operational from stores or such ... maadi retail sector ee... [/quote] major difference enti bhayya ippudu OLTP inka OLAP ki
peru_edaite_enti Posted January 29, 2013 Report Posted January 29, 2013 [quote name='KOTC' timestamp='1359484144' post='1303196342'] major difference enti bhayya ippudu OLTP inka OLAP ki [/quote] aada undi kada vaa.."[color=#000000][font=Tahoma, verdana][size=4] [/size][/font][/color]OLTP systems[color=#000000][font=Tahoma, verdana][size=4] provide source data to data warehouses, whereas OLAP systems help to analyze it. "[/size][/font][/color]
Ranga_The_Donga Posted January 29, 2013 Report Posted January 29, 2013 fact tables...cubes emaina vunte adhi OLAP..
Joey_Tribbiani Posted January 29, 2013 Report Posted January 29, 2013 OLTP -all Business operatio n data andulo untundi ... ekkuva insert/update/delete ivvi nadustai OLAP -- OLTP data meeda reporting ununtaadi ... Select lu nadustai .. Queries , Analysis , reporting ..
KOTC Posted January 29, 2013 Author Report Posted January 29, 2013 [quote name='Joey_Tribbiani' timestamp='1359484334' post='1303196360'] OLTP -all Business operatio n data andulo untundi ... ekkuva insert/update/delete ivvi nadustai OLAP -- OLTP data meeda reporting ununtaadi ... Select lu nadustai .. Queries , Analysis , reporting .. [/quote] OLTP apps emi untayi bhayya selects leka pothe???
Silver_mani Posted January 29, 2013 Report Posted January 29, 2013 OLTP - For performing business process OLAP - For analyzing a business Process
KOTC Posted January 29, 2013 Author Report Posted January 29, 2013 [quote name='Silver_mani' timestamp='1359484564' post='1303196383'] OLTP - For performing business process OLAP - For analyzing a business Process [/quote] zara examples eyya radhe ardham chesukunta
Silver_mani Posted January 29, 2013 Report Posted January 29, 2013 [quote name='KOTC' timestamp='1359484652' post='1303196393'] zara examples eyya radhe ardham chesukunta [/quote] nuvvu deeni meeda working baa ..........dani scope batti nenu example chepta
iTeachSAP Posted January 29, 2013 Report Posted January 29, 2013 chala simple bayya.. all transactions anni OLTP systems lo untayi .. Current transactions maatrame untayi .. history analyze cheyadaaniki kudaradhu .. fast retrieval of data... denormalised tables untayi ... OLAP exact gaa opposite vesuko...
Silver_mani Posted January 29, 2013 Report Posted January 29, 2013 [quote name='iTeachSAP' timestamp='1359485118' post='1303196434'] chala simple bayya.. all transactions anni OLTP systems lo untayi .. Current transactions maatrame untayi .. history analyze cheyadaaniki kudaradhu .. fast retrieval of data... [b]denormalised tables untayi ...[/b] OLAP exact gaa opposite vesuko... [/quote] Relational modelling Vs Dimensional modelling
KOTC Posted January 29, 2013 Author Report Posted January 29, 2013 [quote name='Silver_mani' timestamp='1359484993' post='1303196427'] nuvvu deeni meeda working baa ..........dani scope batti nenu example chepta [/quote] nenu school ki pani chesta bhayya
Josh Posted January 29, 2013 Report Posted January 29, 2013 [quote name='Joey_Tribbiani' timestamp='1359484334' post='1303196360'] OLTP -all Business operatio n data andulo untundi ... ekkuva insert/update/delete ivvi nadustai OLAP -- OLTP data meeda reporting ununtaadi ... Select lu nadustai .. Queries , Analysis , reporting .. [/quote] GP
Recommended Posts