Database

Overview of Couchbase: The NoSQL Database

Reading Time: 3 minutes NoSQL Database Couchbase works as a NoSQL database. So, we will first know about NoSQL Databases. NoSQL Databases use a variety of data models for accessing and managing data, optimized for large data volume, low latency and flexible data models. Features of NoSQL Database Flexibility: Enables faster and more iterative development. Scalability: NoSQL databases are designed to scale out by using distributed clusters. High-performance: Enable Continue Reading

Introduction to Apache Beam

Reading Time: 3 minutes What is Apache Beam? Apache Beam is a unified programming model for batch and streaming data processing jobs. It provides a software development kit to define and construct data processing pipelines as well as runners to execute them. Apache Beam is designed to give a portable programming layer. The Beam Pipeline Runners translate the data processing pipeline into the API compatible with the back-end of the user’s Continue Reading

How to implement Data Pipelines with the help of Beam

Reading Time: 4 minutes Throughout this blog, I will provide a deeper look into this specific data processing model and explore its data pipeline structures and how to process them. Apache Beam Apache Beam is one of the latest projects from Apache, a consolidated programming model for expressing efficient data processing pipelines. It is an open-source, unified model for defining both batches- and streaming-data parallel-processing pipelines. The Apache Beam programming model Continue Reading

How to Implement WordPress using Helm Chart on Kubernetes

Reading Time: 5 minutes Hey readers, In this blog, we are going to install WordPress with MariaDB using the Helm Charts on Kubernetes cluster. With this installation, we are going to see – How we can upgrade as well as rollback the Helm Chart release of WordPress. This complete setup inherited the benefits of the Kubernetes .i.e. scalability and availability. Prerequisites: Before we start there are certain minimum setup requirements Continue Reading

BigQuery: Querying nested arrays

Reading Time: 2 minutes In a previous blog, we had seen BigQuery facilitate efficient data warehouse schema design. BigQuery supports the nested & repeated columns. We can use a combination of ARRAY and STRUCT data types to define our schema in BigQuery. It enables to denormalize data efficiently in single table. In this blog, for the same schema of sales data, we will execute a few DML operations on nested array fields. Schema In Continue Reading

BigQuery:  Efficient Data Warehouse Schema Design

Reading Time: 3 minutes Conventional data warehouses support data models based on star schema and snowflake schema. In these models, there are a number of fact tables and dimension tables. In order to minimize redundancy it is recommends to split data into multiple tables in . This is a normalization process. Normalization is the technique of eliminating the redundant data. It minimize the insertion, deletion, and update anomalies. It saves the disk Continue Reading

BigQuery: Rescue to the Conventional Data warehouse Problems

Reading Time: 4 minutes The present and future of every industry sector somehow depends on the ability to use the massive amounts of data. Use the data available to drive better product quality at a lower cost. Make favourable business decisions with data. Primarily, for decades, to store a wide variety of massive data and perform analysis on it, using Data Warehouse solutions. Traditional data warehouses designed on-premise specifically Continue Reading

Let’s have a look at the PostgreSQL CRUD operation

Reading Time: 4 minutes We are aware that PostgreSQL is one of the most popular and powerful databases in the market. Its amazing features and support from large developer communities always make a difference in the industry. Now, this blog is for you if you want to get familiar with the basic concepts of Postgre SQL. This blog will cover the basic CRUD operation (Create Read Update Delete) in Continue Reading

PostgreSQL OR APACHE CASSANDRA: WHICH ONE IS THE BETTER OPTION

Reading Time: 3 minutes We are living in the 20th century the century of technologies. Because of this, we come across a lot of data in our daily life. So it is important for us to have a database that can help in maintaining a huge amount of data. Now we have many popular databases in the market like PostgreSQL, Cassandra, MySQL MongoDB, and many more. But the question Continue Reading

An Introduction to Caching in Mule Soft 4

Reading Time: 5 minutes Mule runtime engine (Mule) offers customizable strategies, such as the Cache scope and the HTTP Caching API Gateway policy, to enable cache according to your needs. Let’s first have a look at caching, being followed by Cache scope: Caching: It is the process of storing frequently used data in memory, file system, or database which saves processing time and load if it would have to Continue Reading

Apache Cassandra: CQL Commands

Reading Time: 4 minutes In previous two blogs of Apache Cassandra series, we have already explained the Basics of Apache Cassandra and How Cassandra Reads and Writes. Now here in this blog we will cover another important topic in Apache Cassandra i.e., CQL commands. So let us name this blog as “Apache Cassandra: CQL commands“. We recommend to go through the other two blogs of this series before diving Continue Reading

Introduction to ER-Diagram Model

Reading Time: 5 minutes As we know that a database can be modeled as a collection of entities and relationships among entities. ER Diagram stands for entity relationship diagram which helps us to explain the logical structure of databases. An ER diagram looks like the flow chart but it consists of many more specializations like symbols and meaning of those symbols etc, which makes this model very unique. In Continue Reading

kubernetes

How to Deploy MySQL Statefulset in Kubernetes

Reading Time: 4 minutes This blog aims to explain each of the components required to deploy MySQL statefulset cluster on Kubernetes. While deploying the MySQL on Kubernetes, what object type should be used and why? Deployments or StatefulSets? The answer is StatefulSet. Let’s discuss! StatefulSet is the Kubernetes object used to manage stateful applications.It is preferred over deployments as it provides guarantees about the ordering and uniqueness of these Pods i.e. Continue Reading