Terminator II Posted January 29, 2013 Report Posted January 29, 2013 [quote name='KOTC' timestamp='1359486271' post='1303196545'] ODS??? [/quote] operational data store
Silver_mani Posted January 29, 2013 Report Posted January 29, 2013 [quote name='KOTC' timestamp='1359486219' post='1303196540'] idi bhayya naku kavalisi na answer.last question bhayya only OLTP use chestara ekkada ayina? [/quote] OLTP use cheyyadam kadu .....its implemantation of a business process .... so running a business process is nothing but implementaion of OLTP ..
Silver_mani Posted January 29, 2013 Report Posted January 29, 2013 [quote name='kevkekaa' timestamp='1359486359' post='1303196554'] operational data store [/quote]
jaffanajeffada Posted January 29, 2013 Report Posted January 29, 2013 [quote name='KOTC' timestamp='1359486271' post='1303196545'] ODS??? [/quote] http://en.wikipedia.org/wiki/Operational_data_store
KOTC Posted January 29, 2013 Author Report Posted January 29, 2013 [quote name='kevkekaa' timestamp='1359486107' post='1303196525'] Source transaction system --> using OLTP --> ODS --> using OLAP --> Ware house and marts [/quote] alane ippudu www.bofa.com ela work avtundi chepu bhayya database use chesukoni like front tools lo nuv money transfer chesa adi nightly jobs run avutai kadha a change ekkada avtundi database----website aa leka madhya lo inka em ayina untai??
KOTC Posted January 29, 2013 Author Report Posted January 29, 2013 [quote name='Silver_mani' timestamp='1359486365' post='1303196556'] OLTP use cheyyadam kadu .....its implemantation of a business process .... so running a business process is nothing but implementaion of OLTP .. [/quote] champesav bhayya,naku e doubt enduku vachindi ante database lo login aye appudu OLAP ani vachindi appati varaki ardham kaledhu OLTP ante OLAP ento ani
Terminator II Posted January 29, 2013 Report Posted January 29, 2013 [quote name='KOTC' timestamp='1359486420' post='1303196562'] alane ippudu www.bofa.com ela work avtundi chepu bhayya database use chesukoni like front tools lo nuv money transfer chesa adi nightly jobs run avutai kadha a change ekkada avtundi database----website aa leka madhya lo inka em ayina untai?? [/quote] naku mari antha detail ga telidu bhayya.. through web services (xml files) ee data ni tables loki process cheyyochu.. nightly job process or something.. TIBCO EMS.. lanti realtime messaging tools vuntay to process these kind of data.. may be evarikina detail ga telisthe better
iTeachSAP Posted January 29, 2013 Report Posted January 29, 2013 [quote name='KOTC' timestamp='1359486219' post='1303196540'] idi bhayya naku kavalisi na answer.last question bhayya only OLTP use chestara ekkada ayina? [/quote] Inthaka mundhu only OLTP undevi ... Mana kunna ATM centres anni OLTP ki examples .. it will have current data.
KOTC Posted January 29, 2013 Author Report Posted January 29, 2013 [quote name='kevkekaa' timestamp='1359486744' post='1303196584'] naku mari antha detail ga telidu bhayya.. through web services (xml files) ee data ni tables loki process cheyyochu.. nightly job process or something.. TIBCO EMS.. lanti realtime messaging tools vuntay to process these kind of data.. may be evarikina detail ga telisthe better [/quote] avuna evaru ayina unte chepandi vayya
raj9002 Posted January 29, 2013 Report Posted January 29, 2013 Dude, this might help... Nuv per suppose oka super market velli oka transaction chesavu.. ne product scan cheyagane vadikii a product details anni sale tho saha vachestayyii... avii velli if Oracle Database(EBS aithe Forms loki vachestayyii) so vatini OLTP antaruu.... so e roju jargina transactions anni OLTP lone vuntayyii... prathi night Data transfer jargutundii... appudu e OLTP lo vunna data ni inko datawarehouse lokii transfer chestaru ah data warehouse ni OLAP antaru. so malli next day process repeat avtundii... ila current transaction details anni OLTP and historical transactions anni OLAP lo vuntayyi..... Mana business analysis cheyali anteyy manakii patha sales history kavali kabatii we will go for OLAP, mana business transactions ekkada okka degara store cheyali kabatii we will use OLTP.
KOTC Posted January 29, 2013 Author Report Posted January 29, 2013 [quote name='raj9002' timestamp='1359487820' post='1303196682'] Dude, this might help... Nuv per suppose oka super market velli oka transaction chesavu.. ne product scan cheyagane vadikii a product details anni sale tho saha vachestayyii... avii velli if Oracle Database(EBS aithe Forms loki vachestayyii) so vatini OLTP antaruu.... so e roju jargina transactions anni OLTP lone vuntayyii... prathi night Data transfer jargutundii... appudu e OLTP lo vunna data ni inko datawarehouse lokii transfer chestaru ah data warehouse ni OLAP antaru. so malli next day process repeat avtundii... ila current transaction details anni OLTP and historical transactions anni OLAP lo vuntayyi..... Mana business analysis cheyali anteyy manakii patha sales history kavali kabatii we will go for OLAP, mana business transactions ekkada okka degara store cheyali kabatii we will use OLTP. [/quote] Thanks bhayya kathi la chepavu ,kani naku malli doubts vache la chesav bhayya.OLTP use chestundi annav akkada nuchi OLAP ki transfer annav ikkada database nadi OLAP ani chuptundii?? confusing OLTP databases separate ga untai OLAP separate ga untai anthe na?
Terminator II Posted January 29, 2013 Report Posted January 29, 2013 [quote name='KOTC' timestamp='1359488221' post='1303196735'] Thanks bhayya kathi la chepavu ,kani naku malli doubts vache la chesav bhayya.OLTP use chestundi annav akkada nuchi OLAP ki transfer annav ikkada database nadi OLAP ani chuptundii?? confusing OLTP databases separate ga untai OLAP separate ga untai anthe na? [/quote] yeah avi rendu seperate ga vuntay.. OLAP database ki OLTP source anuko..
KOTC Posted January 29, 2013 Author Report Posted January 29, 2013 [quote name='kevkekaa' timestamp='1359488539' post='1303196767'] yeah avi rendu seperate ga vuntay.. OLAP database ki OLTP source anuko.. [/quote] vati madhya nightly jobs schedule cheyali anthe na??
subbayya Posted January 29, 2013 Report Posted January 29, 2013 [quote name='KOTC' timestamp='1359483899' post='1303196319'] [url="http://datawarehouse4u.info/OLTP-vs-OLAP.html"]http://datawarehouse...TP-vs-OLAP.html[/url] zara detail ga chepandi vayya ini rojulu madi OLTP anukuna kadhu OLAP? [/quote] Dude nuvvu adi teliya kunda innirojula nundi DBA ga chesthunnava..? I'm not pointing (every one has to learn at some point).... Just surprised....
Terminator II Posted January 29, 2013 Report Posted January 29, 2013 [quote name='KOTC' timestamp='1359488591' post='1303196769'] vati madhya nightly jobs schedule cheyali anthe na?? [/quote] yeah anthe.. depending on business requirement daily, monthly, weekly ala..
Recommended Posts