— Microservices Data Access Patterns — Database selection process depends on the Application Architecture. Data Management in a monolithic systems can get pretty complex. However, it could be a completely different ball-game in a microservices architecture. There are different patterns available to help with this complexity. Few of them are discussed below. CQRS (Command Query Responsibility…

— Indexing — Indexing is a way of improving the performance of the database by reducing the number of access to disk when query is processed. It is a data structure technique which is used to quickly locate and access the data in a database. This comes with the cost of additional writes…

— Replication Properties — Replication Techniques and Types Replication: Process of storing the same information in additional nodes to improve the availability of data is called replication. Different databases perform replication differently like Master-Slave, Primary-Secondary, Coordinator-Participant models perform replication differently. Replication can also be used for backup and restore purpose. The biggest advantage of replication is that it…

— 5 V Properties of Big Data — Volume This internet resolution has caused data explosion from digital and social media, data is rapidly being produced in such large chunks. The amount of data the organizations gathering on a daily basis skyrocketed tremendously. This has become a great challenge for organizations to store and process it using conventional methods…

— Partition / Sharding — Audience: The article covers the some of the common properties (Partitioning & Sharding) and its implementation techniques. These concepts will be referred in the later parts of this series during the database selection and design procedures. Proficiency Level: Intermediate to Expert In the previous part, we saw how distributed database…

— Non-Relational Properties — Audience: The article covers the Non-Relational Properties (Distributed Computing, CAP Theorem and PACELC Theorem) and its details. These concepts will be referred in the later parts of this series during the database selection and design procedures. Proficiency Level: Intermediate to Expert In the previous parts, we reviewed the relational properties…

— Internals of ACID implementation — In the previous part, we saw about different types of databases and their properties. In this section, let us look at what a transaction is, how it is written to the memory, logged, and stored in disk. What is a Transaction? People often confuse individual database statements to transactions. A…

— Relational Properties (ACID) — In the last part in this series, we reviewed the different key databases based on their structural categorization, properties and types. Let us closely look at the relational properties. We will review the ACID properties in this section and will review other properties in the upcoming sections. Transactional Management (ACID) Requirements ACID stands for…

— Introduction to Database Technologies — Database is the backbone of any technology enterprise, to store information in a structured set, and for efficient management of information. Database has evolved to a greater extend in the last 50+ years from Hierarchical, Network, Relational, Object Oriented, No-SQL, New-SQL to HTAP (Hybrid transaction/analytical processing). Before Database’s era, things…