Normalization

 Normalization:

Putting data in multiple tables to avoid redundancy.


It combines data & organises it in a single table.




Comments

Post a Comment

Popular posts from this blog

Polyglot Persistence

Image
  Polyglot Persistence: Application requires multiples types of database Here multiple types of DB is used to perform operation in application. ***if you store data in disk, it will persist even if database server goes down. ***if you write data in memory, it will not persist as database server goes down.
Read more

RDBMS

Image
 RDBMS  Software That performs data operation on relational database Operations Store, manage, query & retrieve data Tables Data is stored in the form of tables Foreign Key Relation between two tables is represented by foreign keys Advantages : No data redundancy & inconsistency Different User refer to same table, avoid inconsistency Data Concurrency A locking system is provided by RDBMS to prevent abnormalities from occurring **Until 1 st transaction get over, 2 nd transaction is not performed   Data Searching Built in searching capabilities **Using queries you can search Data Integrity Constraint restricting allow it to follow according to rules Problem : 1. Rigid Schema : We cannot add new column in a table 2. High Cost : 3. Scalability Issues : Horizontal Scaling / Sharding is very difficult.
Read more

File Based Storage System

Image
  File Based Storage System  A file based storage system is a database management system where data is store in form of files. Challenges: 1. Data Redundancy - Update/ Delete Anomaly leads to data inconsistency. 2. Poor Security - Some data is present in the system which causes possibility of data breaches by                                              unauthorized users. 3. Slow - Speed is slow . Due to which data retrieval is not very efficient.
Read more