RDBMS
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 1st
transaction get over, 2nd 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 |
1. Rigid Schema : We cannot add new column in a table
2. High Cost :
3. Scalability Issues : Horizontal Scaling / Sharding is very difficult.
Comments
Post a Comment