What is denormalization

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

Home > .NET > SQL

What is denormalization ?

✍: Guest

Denormalization is the process of putting one fact in numerous places (its vice-versa of normalization).Only one valid reason exists for denormalizing a relational design - to enhance performance.The sacrifice to performance is that you increase redundancy in database.

2007-10-25, 5396👍, 0💬

Explain in detail the fundamental of connection pooling
Explain in detail the fundamental of connection pooling? When a connection is opened first time a connection pool is created and is based on the exact match of the connection string given to create the connection object. Connection pooling only works if the connection string is the same. If the conn... 2007-10-24, 7059👍, 0💬

What is difference between Dataset. clone and Dataset.copy
What is difference between Dataset. clone and Dataset. copy ? Clone: - It only copies structure, does not copy data. Copy: - Copies both structure and data. 2007-10-24, 5494👍, 0💬

What is Maximum Pool Size in ADO.NET Connection String
What is Maximum Pool Size in ADO.NET Connection String? 2007-10-24, 5436👍, 0💬

What is the use of OLAP
What is the use of OLAP ? OLAP is useful because it provides fast and interactive access to aggregated data and the ability to drill down to detail. 2007-10-25, 5407👍, 0💬

What is denormalization
What is denormalization ? Denormalization is the process of putting one fact in numerous places (its vice-versa of normalization).Only one valid reason exists for denormalizing a relational design - to enhance performance.The sacrifice to performance is that you increase redundancy in database. 2007-10-25, 5397👍, 0💬

What is a candidate key
What is a candidate key ? A table may have more than one combination of columns that could uniquely identify the rows in a table; each combination is a candidate key. During database design you can pick up one of the candidate keys to be the primary key. For example, in the supplier table supplierid... 2007-10-25, 5276👍, 0💬

Can you explain the difference between an ADO.NET Dataset and an ADO Recordset
Can you explain the difference between an ADO.NET Dataset and an ADO Recordset? There two main basic differences between recordset and dataset ? With dataset you an retrieve data from two databases like oracle and sql server and merge them in one dataset , with recordset this is not possible ? All r... 2007-10-24, 5239👍, 0💬

How can you increase SQL performance
How can you increase SQL performance ? Following are tips which will increase your SQl performance Every index increases the time takes to perform INSERTS, UPDATES and DELETES, so the number of indexes should not be too much. Try to use maximum 4-5 indexes on one table, not more. If you have read-on... 2007-10-25, 5156👍, 0💬

What are the different types of joins? What is the difference between them
What are the different types of joins? What is the difference between them ? INNER JOIN Inner join shows matches only when they exist in both tables.Example, in the below SQL there are two tables Customers and Orders and the inner join in made on Customers Customerid and Orders Customerid.So this SQ... 2007-10-25, 5110👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.