Sql

Search

difference between normalization and denormalization

Normalization is the process of dividing data into tables to remove redundant 
data and improve data integrity. 

Denormalization is used to combine multiple tables in order to reduce
the time required to perform queries.

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql limit order by
Sql :: how to import mysql database command line
Sql :: sql update record
Sql :: rand mysql
Sql :: select into insert sql server
Sql :: how to make case insensitive in sql
Sql :: mysql show category once count how many products
Sql :: create table with float datatype in sql server
Sql :: initcap in sql
Sql :: json not contains mysql
Sql :: sql date function
Sql :: choose only one for each distinct collumn regardless of other columns
Sql :: mysql find max value row
Sql :: Add a new column into table
Sql :: sql like case sensitive
Sql :: mysql is odd
Sql :: sql to c# model
Sql :: Write SQL in ruby on rails
Sql :: show specific events on mysql
Sql :: mysql generate create table script
Sql :: enum in sql server
Sql :: create-table
Sql :: connect by query in oracle
Sql :: oracle last connexion
Sql :: sqlite create record
Sql :: no suitable driver found for sqlite
Sql :: collation in sql
Sql :: compression of dabatase mysqldumo
Sql :: postgres meta command to show all rows in table
Sql :: insert or update cassandra

Search

SQL

difference between normalization and denormalization

ADD CONTENT