We have been working very hard since 2009 to facilitate in your learning Read More. We can't keep up without your support. Donate Now.

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

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

Looking For Something at Site? Search Below

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: 1344

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

Latest Activity

Kamal Qaisar liked Kamal Qaisar's discussion MGT 201 Solved GDB Financial Management
5 hours ago
Kamal Qaisar liked Kamal Qaisar's discussion MGT 201 Solved GDB Financial Management
5 hours ago
Kamal Qaisar liked Kamal Qaisar's discussion MGT 201 Solved GDB Financial Management
5 hours ago
Kamal Qaisar posted discussions
6 hours ago
+M.Tariq Malik replied to Fragrance of Islam's discussion ENG301 Business Communication GDB No 01 Fall 2020 Solution / Discussion in the group ENG301 Business Communication
8 hours ago
Profile IconSamina, sahara, Jero and 12 more joined Virtual University of Pakistan
8 hours ago
+!!! ❤️ Shadow Girl❤️!!! replied to Miss. Churhail's discussion $$$$$AB YE SOCHA HY K HAM HAD SE GUZAR JAYEN GY$$$$$$
8 hours ago
maha replied to +M.Tariq Malik's discussion Mid Term Quiz Will Be Conducted Instead Of Mid Term Examinations - Fall 2020 Semester
8 hours ago
+!!! ❤️ Shadow Girl❤️!!! liked Miss. Churhail's discussion $$$$$AB YE SOCHA HY K HAM HAD SE GUZAR JAYEN GY$$$$$$
8 hours ago
maha replied to +M.Tariq Malik's discussion Mid Term Quiz Will Be Conducted Instead Of Mid Term Examinations - Fall 2020 Semester
8 hours ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion FIN630 GDB No 01 Fall 2020 Solution / Discussion Last Date: 27-11-2020 in the group FIN630 Investment Analysis & Portfolio Management
8 hours ago
Aasma kiran commented on +M.Tariq Malik's group ENG301 Business Communication
8 hours ago
Aasma kiran joined +M.Tariq Malik's group
8 hours ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion CS602 Computer Graphics Assignment 01 Fall 2020 Solution / Discussion Due Date: 04-12-2020 in the group CS602 Computer Graphics
8 hours ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion CS602 Computer Graphics Assignment 01 Fall 2020 Solution / Discussion Due Date: 04-12-2020 in the group CS602 Computer Graphics
8 hours ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion CS602 Computer Graphics Assignment 01 Fall 2020 Solution / Discussion Due Date: 04-12-2020 in the group CS602 Computer Graphics
8 hours ago

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

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

.