Innovating the potential of #bigdata in the #banking sector. #BigData #BI #Agile #ML #Devops #AI #FinTech
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 […]
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 […]
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, […]
In a data Platform, there is an obvious need of a Relational Database. Though proprietary systems like Oracle are more widely used, open-source systems like PostgreSQL have gained popularity over the last years. This fact is supported by the strength of the open-source community, which has made possible the maturity process in order to […]