subbayya Posted January 29, 2013 Report Posted January 29, 2013 OLTP lo daily customer data vuntadi.... ee OLTP nundi aa data nightly rebuild process or ETL process dwara OLAP server which is nothing but history db or dataware house ki velthadi...danilo backend business antha nadusthadi. Eg: Nuvvu oka bank branch gurinchu year mottam customer analasys report techu kovali ante OLAP meeda report run chesthav.... aa report decision ni batti business decisions vuntai..
Darling999 Posted January 29, 2013 Report Posted January 29, 2013 painaa andaru cheppindi correct.. adi follow ayipoo. nenu kottagaa cheppedi emi ledu.
Silver_mani Posted January 29, 2013 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]
KOTC Posted January 29, 2013 Author Report Posted January 29, 2013 [quote name='subbayya' timestamp='1359488808' post='1303196799'] Dude nuvvu adi teliya kunda innirojula nundi DBA ga chesthunnava..? I'm not pointing (every one has to learn at some point).... Just surprised.... [/quote] avunu bhayya teliyadhu telusukuntana.OLTP ante online tranaction ani OLAP dataware house ani telusu kani more specific ga teliyadhu so learning nenu database ki conect ayinapudu adi OLAP ani chupistundi ante datware housing use chestara?
Terminator II Posted January 29, 2013 Report Posted January 29, 2013 [quote name='Silver_mani' timestamp='1359489514' post='1303196869'] [/quote]
Silver_mani Posted January 29, 2013 Report Posted January 29, 2013 [quote name='kevkekaa' timestamp='1359489702' post='1303196889'] [/quote] mayyaaa
KOTC Posted January 29, 2013 Author Report Posted January 29, 2013 [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]Fact tables diminision tables are associated with warehouse and data mart design and while OLAP can be done with these object structures in a real OLAP system the data will most likely be loaded into cubes. Special cube construction and retrieval instructions rather than normal SQL are normally used to process OLAP data.[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]The following Oracle support master note on OLAP leads to the second note which in turn leads to the third note.[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]Note: 1107593.1 Master Note for the Oracle OLAP Option[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]Note: 1107603.1 OLAP Option FAQ's, How-To's, Advice... [/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)] Note: 983565.1 OLAP Cube Build Techniques Also Note: 352598.1 How To Verify Whether The Olap Option Is Installed Properly And Working ?[/background][/size][/font][/color][color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)] If you are only dealing with queries against fact and diminision tables and not cubes then you are not really dealing with OLAP so much as data warehouse which means normal queries plus some warehouse specific situations such as star trransformations. Star transformations are discussed in the Warehouse guide. Dealing with large quantities of data and working on SQL that may runs hours is the big change from tuning normal OLTP.[/background][/size][/font][/color]
Silver_mani Posted January 29, 2013 Report Posted January 29, 2013 [quote name='KOTC' timestamp='1359489844' post='1303196898'] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242,242,242)]Fact tables diminision tables are associated with warehouse and data mart design and while OLAP can be done with these object structures in a real OLAP system the data will most likely be loaded into cubes. Special cube construction and retrieval instructions rather than normal SQL are normally used to process OLAP data.[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242,242,242)]The following Oracle support master note on OLAP leads to the second note which in turn leads to the third note.[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242,242,242)]Note: 1107593.1 Master Note for the Oracle OLAP Option[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242,242,242)]Note: 1107603.1 OLAP Option FAQ's, How-To's, Advice... [/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242,242,242)]Note: 983565.1 OLAP Cube Build Techniques Also Note: 352598.1 How To Verify Whether The Olap Option Is Installed Properly And Working ?[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242,242,242)]If you are only dealing with queries against fact and diminision tables and not cubes then you are not really dealing with OLAP so much as data warehouse which means normal queries plus some warehouse specific situations such as star trransformations. Star transformations are discussed in the Warehouse guide. Dealing with large quantities of data and working on SQL that may runs hours is the big change from tuning normal OLTP.[/background][/size][/font][/color] [/quote] cubes konchaam advanced concept bhayya
Terminator II Posted January 29, 2013 Report Posted January 29, 2013 [quote name='Silver_mani' timestamp='1359489790' post='1303196895'] mayyaaa [/quote] mayya..
srikanthraparla Posted January 29, 2013 Report Posted January 29, 2013 [quote name='Silver_mani' timestamp='1359489790' post='1303196895'] mayyaaa [/quote] gay comment??? [img]http://i.imgflip.com/c9tm.gif[/img]
Terminator II Posted January 29, 2013 Report Posted January 29, 2013 [quote name='srikanthraparla' timestamp='1359490119' post='1303196922'] gay comment??? [img]http://i.imgflip.com/c9tm.gif[/img] [/quote] mama nuvvu brod ye na??
Terminator II Posted January 29, 2013 Report Posted January 29, 2013 [quote name='DARLING...' timestamp='1359489228' post='1303196835'] painaa andaru cheppindi correct.. adi follow ayipoo. nenu kottagaa cheppedi emi ledu. [/quote]
Silver_mani Posted January 29, 2013 Report Posted January 29, 2013 [quote name='srikanthraparla' timestamp='1359490119' post='1303196922'] gay comment??? [img]http://i.imgflip.com/c9tm.gif[/img] [/quote] hi srikanthraparla ... tell me man ...ru loving lollilolli2012 [img]http://i.imgflip.com/c9tm.gif[/img]
srikanthraparla Posted January 29, 2013 Report Posted January 29, 2013 [quote name='Silver_mani' timestamp='1359490223' post='1303196932'] hi srikanthraparla ... tell me man ...ru loving lollilolli2012 [img]http://i.imgflip.com/c9tm.gif[/img] [/quote] u nela ticket, i luv balabob [img]http://i.imgflip.com/c9tm.gif[/img]
srikanthraparla Posted January 29, 2013 Report Posted January 29, 2013 [quote name='kevkekaa' timestamp='1359490166' post='1303196927'] mama nuvvu brod ye na?? [/quote] enduku maya madipoyina gayanni refutav [img]http://i.imgflip.com/c9tm.gif[/img]
Recommended Posts