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.
Comments
Post a Comment