Placid ACID or embrace BASE? Mind the CAP

Placid ACID or embrace BASE? Mind the CAP

SQL, ACID and BASE The term “NoSQL” has been used for several years referring to non-relational databases. Some of the concepts attached with NoSQL implied schema-less and scaling out capabilities. However, relational databases (RDBMSs) are adding features like JSON compatibility, that can make them schema-free, as well as architecture designs involving clustering and partitioning. On […]

Isolation levels and bankruptcy

Isolation levels and bankruptcy

In database systems, isolation determines how transaction integrity is visible to other users and systems. Though it’s often used in a relaxed way, this property of ACID in a DBMS (Database Management System) is an important part of any transactional system. This property specifies when and how the changes implemented in an operation become visible […]

Choosing a RDB for a Data Platform: a Journey Towards PostgreSQL (Part II)

Choosing a RDB for a Data Platform: a Journey Towards PostgreSQL (Part II)

  This is the continuation of the comparison study between PostgreSQL and Oracle. In this part, we will explain the key-concepts of high-availability and the conclusions of the study. High-Availability   Getting high-availability strongly depends on the use cases to be covered with the database. Read-only databases have to ensure reliability and minimize outage time, […]