Discussion about normal forms in SQL

[manoghna]

[quote author=Jeedeelu link=topic=219396.msg2703125#msg2703125 date=1312303432]
at times of heavy access load......

denormalization use chestharemo....... sCo_^Y sCo_^Y sCo_^Y sCo_^Y sCo_^Y
[/quote]  @gr33d but
to be in specific :

1.when we want to use more no.of joins between tables or edaina VIEW ki more than 3 joins unte we have to go for this denormalization

2.when ever they are more insertion and deletions on the more tables.... endhukante table ki index vunte apudu insertions ,and deletions will be a problem so alnti apudu kooda denormalization chestham,in order to get rid of the indexing problem

[Ranga_The_Donga]

[quote author=cinema pichodu link=topic=219396.msg2703152#msg2703152 date=1312303647]
ikkada andaru ROCK bayya......ee thread susthunte edupu aapukoleka pothunna.........
*=: *=: *=: *=: *=: *=:
naaku oka doubt...........naaku basic queries thappa asalu em theleedhu....que mari silly ga untundemo em anukokandi..........

que : asalu oka table duplicate columns untaya......(i mean column name).......oka vela ala unte...insert column use chesinappudu data endulo insert avuthundi.........
s%H# s%H# s%H# s%H# s%H# s%H# s%H#
[/quote]

naku thelisi duplicate rows vuntayi....duplicate data vuntadhi......ah column ki primary key lekapothe...u can insert data into it....

[Ranga_The_Donga]

[quote author=meghana9 link=topic=219396.msg2703173#msg2703173 date=1312303800]
  @gr33d but
to be in specific :

1.when we want to use more no.of joins between tables or edaina VIEW ki more than 3 joins unte we have to go for this denormalization

2.when ever they are more insertion and deletions on the more tables.... endhukante table ki index vunte apudu insertions ,and deletions will be a problem so alnti apudu kooda denormalization chestham,in order to get rid of the indexing problem
[/quote]

thaliya...thaliya....meghs..... sHa_clap4 sHa_clap4 sHa_clap4 sHa_clap4 sHa_clap4

[galigannarao]

process speed up cheyyataniki denorm vadatam. You may apply Denormalization in the process of deriving a physical data model from a logical form. H&*()

[skchinnari]

nice thread 

[manoghna]

[quote author=galigannarao link=topic=219396.msg2703216#msg2703216 date=1312304157]
process speed up cheyyataniki denorm vadatam. You may apply Denormalization in the process of deriving a physical data model from a logical form. H&*()
[/quote]what is physical and logical data model

[pulithoka]

[quote author=Jeedeelu link=topic=219396.msg2703167#msg2703167 date=1312303756]
database lo fast ga data retrive cheyadaniki....chese process e denormalization.....otherwise performance tuning....


[/quote]  thankyou thankyou

[galigannarao]

[quote author=meghana9 link=topic=219396.msg2703236#msg2703236 date=1312304291]
what is physical and logical data model
[/quote]bommalu esta chusko explain chese time ledu ippudu
logical model
[img]http://www.1keydata.com/datawarehousing/logical-data-model.jpg[/img]
Physical model
[img width=440 height=370]http://www.1keydata.com/datawarehousing/physical-data-model.jpg[/img]

[manoghna]

[quote author=galigannarao link=topic=219396.msg2703251#msg2703251 date=1312304553]
bommalu esta chusko explain chese time ledu ippudu
logical model
[img]http://www.1keydata.com/datawarehousing/logical-data-model.jpg[/img]
Physical model
[img width=440 height=370]http://www.1keydata.com/datawarehousing/physical-data-model.jpg[/img]
[/quote]ok nenu explain chesthanu..... evarikaina use avuthundhi ani explain cheyamannanu  s%H#

[galigannarao]

[quote author=meghana9 link=topic=219396.msg2703279#msg2703279 date=1312304888]
ok nenu explain chesthanu..... evarikaina use avuthundhi ani explain cheyamannanu  s%H#
[/quote]okay meghs ayte nuvvu explain cheyyu S%Hi S%Hi

[chowdary10]

thankyou gali and team all of u  you rock you rock  sHa_clap4 sHa_clap4


unix meda or dataware house concepts meda disco pettandi, it helps

[galigannarao]

[quote author=KINDAL link=topic=219396.msg2703293#msg2703293 date=1312304975]
thankyou gali and team all of u  you rock you rock  sHa_clap4 sHa_clap4


unix meda or dataware house concepts meda disco pettandi, it helps
[/quote]nuvvu seppina rendu topics naaku teliyadu baaa. eppudo btech lo saduvukunna. unix ayte gurutndi kani DWH matram arava cinemane ippatiki sSa_j@il

[chowdary10]

cry@fl cry@fl cry@fl cry@fl[quote author=galigannarao link=topic=219396.msg2703302#msg2703302 date=1312305055]
nuvvu seppina rendu topics naaku teliyadu baaa. eppudo btech lo saduvukunna. unix ayte gurutndi kani DWH matram arava cinemane ippatiki sSa_j@il
[/quote]

[cinema pichodu]

[quote author=galigannarao link=topic=219396.msg2703302#msg2703302 date=1312305055]
nuvvu seppina rendu topics naaku teliyadu baaa. eppudo btech lo saduvukunna. unix ayte gurutndi kani DWH matram arava cinemane ippatiki sSa_j@il
[/quote]
avunu baa.......konchem unix meedha kuda disco pettandi....chala helpful avuthndi........
you rock you rock you rock you rock

[topulake topu]

[quote author=galigannarao link=topic=219396.msg2703302#msg2703302 date=1312305055]
nuvvu seppina rendu topics naaku teliyadu baaa. eppudo btech lo saduvukunna. unix ayte gurutndi kani DWH matram arava cinemane ippatiki sSa_j@il
[/quote]
same here... unix ante manage chesta kani.... DWH ante ..assameee