KOTC Posted January 29, 2013 Author 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... denormalised tables untayi ... OLAP exact gaa opposite vesuko... [/quote] OLTP ekkav ekkada vadutaru?
Terminator II Posted January 29, 2013 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]
Terminator II 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] OLTP lo normalized tables anukunta.. data redundancy elimination kosam.. no need to insert/update/delete a record in multiple locations... OLAP lo de nomalized.. easy to run select quesries.. 1
Silver_mani Posted January 29, 2013 Report Posted January 29, 2013 [quote name='KOTC' timestamp='1359485426' post='1303196460'] nenu school ki pani chesta bhayya [/quote] suppose ur aplying for an admission ... . school website vundi .......say its build on java or dot net ...the website is supporting ur business processing or transaction (applying admission). This is OLTP say the school recivies 1000 applications , Now u want to analyze all those applyication .You have to build a Warehouse or Datamarts which help u analyzing ur data .THis is Analyzing ur Business Process. - OLAP
Silver_mani Posted January 29, 2013 Report Posted January 29, 2013 [quote name='kevkekaa' timestamp='1359485767' post='1303196493'] OLTP lo normalized tables anukunta.. data redundancy elimination kosam.. no need to insert/update/delete a record in multiple locations... OLAP lo de nomalized.. easy to run select quesries.. [/quote]
Terminator II Posted January 29, 2013 Report Posted January 29, 2013 [quote name='Silver_mani' timestamp='1359485812' post='1303196498'] suppose ur aplying for an admission ... . school website vundi .......say its build on java or dot net ...the website is supporting ur business processing or transaction (applying admission). This is OLTP say the school recivies 1000 applications , Now u want to analyze all those applyication .You have to build a Warehouse or Datamarts which help u analyzing ur data .THis is Analyzing ur Business Process. - OLAP [/quote]
Terminator II Posted January 29, 2013 Report Posted January 29, 2013 [quote name='Silver_mani' timestamp='1359485812' post='1303196498'] suppose ur aplying for an admission ... . school website vundi .......say its build on java or dot net ...the website is supporting ur business processing or transaction (applying admission). This is OLTP say the school recivies 1000 applications , Now u want to analyze all those applyication .You have to build a Warehouse or Datamarts which help u analyzing ur data .THis is Analyzing ur Business Process. - OLAP [/quote]
KOTC Posted January 29, 2013 Author Report Posted January 29, 2013 [quote name='Silver_mani' timestamp='1359485812' post='1303196498'] suppose ur aplying for an admission ... . school website vundi .......say its build on java or dot net ...the website is supporting ur business processing or transaction (applying admission). This is OLTP say the school recivies 1000 applications , Now u want to analyze all those applyication .You have to build a Warehouse or Datamarts which help u analyzing ur data .THis is Analyzing ur Business Process. - OLAP [/quote] Kathi bhayya nuv,kani nuv chepina dani bhati chala varaku OLAP e vadataru kadha???
Silver_mani Posted January 29, 2013 Report Posted January 29, 2013 [quote name='KOTC' timestamp='1359485941' post='1303196512'] Kathi bhayya nuv,kani nuv chepina dani bhati chala varaku OLAP e vadataru kadha??? [/quote] ala kadu bhayya ...OLTP lenidi OLAP vundadu ....
Silver_mani Posted January 29, 2013 Report Posted January 29, 2013 [quote name='kevkekaa' timestamp='1359485927' post='1303196510'] [/quote] u nasty vuncle [url="http://www.andhrafriends.com/user/8151-kevkekaa/"][img]http://www.andhrafriends.com/uploads/profile/photo-thumb-8151.png?_r=1352999605[/img][/url][url="http://www.andhrafriends.com/user/8151-kevkekaa/"][img]http://www.andhrafriends.com/uploads/profile/photo-thumb-8151.png?_r=1352999605[/img][/url]
Terminator II Posted January 29, 2013 Report Posted January 29, 2013 [quote name='KOTC' timestamp='1359485941' post='1303196512'] Kathi bhayya nuv,kani nuv chepina dani bhati chala varaku OLAP e vadataru kadha??? [/quote] Source transaction system --> using OLTP --> ODS --> using OLAP --> Ware house and marts
KOTC Posted January 29, 2013 Author Report Posted January 29, 2013 [quote name='Silver_mani' timestamp='1359486020' post='1303196517'] ala kadu bhayya ...OLTP lenidi OLAP vundadu .... [/quote] idi bhayya naku kavalisi na answer.last question bhayya only OLTP use chestara ekkada ayina?
KOTC Posted January 29, 2013 Author Report Posted January 29, 2013 [quote name='kevkekaa' timestamp='1359486107' post='1303196525'] Source transaction system --> using OLTP -->[size=5][b] ODS -[/b][/size]-> using OLAP --> Ware house and marts [/quote] ODS???
lolliman Posted January 29, 2013 Report Posted January 29, 2013 keka ehee.... neenu bhi daani meede choostunnaa
jaffanajeffada 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... [color=#ff0000][b]denormalised tables untayi ...[/b][/color] OLAP exact gaa opposite vesuko... [/quote] OLTP lo denormalized kaadhu, normalized tables untayi...
Recommended Posts