www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

the topic is

“Normalization Process removes the anomalies from the data but ultimately it affects the Query Performance why..?Justify the statement.”

Plz discuss about it here 
It will remain open for 2 days and will open on 18 january 


+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)


Views: 1350

Replies to This Discussion

Please Discuss here about this GDB.Thanks

kuch smjh aye to justify kren na kisi ko smjh ayi k kia justify krna he

ye kio DML oprations ki Query performance pr affect krta he koi bta skta he plzzzzzzzzzzzzzzz

Positive Affect: Normalization save our space by removing redundancy and anomalies and also save our record for curruption.

Negative Affect: It makes the DML query slow because number of joins are involved.

Networkmodel in a database with examples and characteristics.

Fariha Chaudhry gud keep it up 

This is because the Normalization process removes the anomalies from the data but ultimately it affects the Query performance of operations

Positive Affect: Normalization save our space by removing redundancy and anomalies and also save our record for corruption or damage.

Negative Affect: It makes the DML query slow because number of joins are involved

Fariha  Unrelated meterial. Tariq bhai weldon....Really appreciate to you.....

Using of normalization in sql is good because.....

Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships.

thanks both

CS403 GDB SOLUTION

Positive Affect: Normalization save our space by removing redundancy and anomalies and also
save our record for corruption.
Negative Affect: It makes the DML query slow because number of joins is involved.

You can take idea from following paragraphs!
Application of normal forms beyond third normal
form can tend to produce too many entities, resulting in too many
entities in SQL query joins. Too many entities in SQL query joins can
reduce system performance for any type of database. The more entities in a
join, the more difficult queries are to tune. Also, more query complexity
makes it more difficult for a database query optimizer to make a best guess
at the fastest execution path for a query. The result is poor performance.
From a purely commercial perspective, good performance is much more
important than granular perfection in relational database design. It’s not
about the design but more about satisfied customers and end users. Poor
response time from a computer system will upset people. In fact, poor
response time can be much more than simply upsetting because it can
impact business and the bottom line for a company.
Over normalization using third normal forms and beyond can lead to
poor performance in both OLTP and data warehouse type databases. Over normalization
is more commercially in top-down designed Java object
applications. In this situation, an object structure is imposed onto a relational
database. Object and relational data structures are completely different
methodologies, because the fine details of granularity are inherent in
object modeling. The same is true of extreme application of normal forms,
but that creates too many entities, too much processing built into a database
model, and ultimately highly complex SQL coding and poor performance
as a result.


RSS

Looking For Something? Search Below

Latest Activity

+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS610 Assignment No 03 Fall 2020 Solution & Discussion in the group CS610 Computer Network
11 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion STA301 Statistics and Probability Assignment No 03 Fall 2020 Solution & Discussion in the group STA301 Statistics and Probability
34 minutes ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion STA301 Statistics and Probability Assignment No 03 Fall 2020 Solution & Discussion
34 minutes ago
+ M.Tariq Malik added a discussion to the group STA301 Statistics and Probability
36 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion MCM601 Assignment No 02 Fall 2020 Solution / Discussion in the group MCM601 Media Management
42 minutes ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion MCM601 Assignment No 02 Fall 2020 Solution / Discussion
42 minutes ago
+ M.Tariq Malik added a discussion to the group MCM601 Media Management
43 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion MCM501 Assignment No 02 Fall 2020 Solution / Discussion in the group MCM501 Advertising for Print and Electronic Media
48 minutes ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion MCM501 Assignment No 02 Fall 2020 Solution / Discussion
48 minutes ago
+ M.Tariq Malik added a discussion to the group MCM501 Advertising for Print and Electronic Media
49 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion MGT101 Financial Accounting Assignment 01 Fall 2020 Solution / Discussion in the group MGT101 Financial Accounting
54 minutes ago
+ ⵑⵑ ӍᎥŞŞ ⲤһᵘʳһშᎥⵏ ⵑⵑ + liked + Ehtisham +'s discussion یوں ہی بے سَبب
1 hour ago

© 2021   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service

.