| DB2 | PostgreSQL | Oracle | SQL Server | Cassandra (NoSQL) |
|---|---|---|---|---|
| Instance | Cluster | Instance | Instance | Cluster |
| Table | Relation | Table | Table | |
| Row | Tuple | Row | Row | |
| Lock | Block | Lock | ||
| Agent | Process | Process | ||
| Sql | Pgsql | PL/SQL | CQL | |
| Syscat | Pgclass | Sys | ||
| DB and DBM configuration | Postgresql.configuration | SP files | ||
| Transaction | WAL(Write Ahead Log) | Redo Log | Tlog | Memtables |
| Online Reorg | Vacuum | Compaction | ||
| Offline Reorg | Vacuum FULL | |||
| Runstats | Vacuum analyze | DBstats | ||
| Tablespace | Tablespace | Tablespace | Keyspace | |
| Bufferpools | Shared buffers | Bufferpools | Caching | |
| Threshold | Work_mem | |||
| Export & IMPORT | Copy | Export & Import | ||
| Authentication control | PG_hba.configuration control | Listener | Authentication and Authorization | |
| HADR | Streaming Replication | DataGuard | NA- Always Replication | |
| Primary and standby | Master and Slave | Primary and Standby | Nodes | |
| Auxiliary standby | Secondary Slave | No standby concepts | ||
| TSA (Tivoli system Automation) | EFM(Enterprise Fail over manger) | dgconfig | No fail-over concepts | |
| Online Backup | Export Backup | HOT Backup | Snapshot | |
| FULL Backup | Base backup | COLD Backup | ||
| Restore | PG_Retsore | Snapshot Restore | ||
| Pure scale | MMR(Multi Master Replication) | RAC(Real Application cluster) |
Still Loading …….!
DayDreamsDatabases 