Columnar Database-MonetDB
Hey readers, recently I was exploring one of the databases offering MonetDB which is a columnar database available open source. As per the documentation, the database has very high read performance and works very well with the data rollups. Apart from this it also supports transactions and other features of transactional databases. In this blog, I will be covering a few things that I learned while exploring the Database. Traditional Transactional DB NO SQL Databases Columnar Databases MonetDB Querying MonetDB using Python Transactional Databases: A decade ago the main purpose of databases was to store info and provide the information as and when required. The operations were mainly write heavy and information was stored in normalized form to avoid redundancy and maintain the integrity of information. The most popular OLTP databases that we have in the market and widely used are : Oracle SQL Server My SQL There are many other open...