Database

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

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

Introduction to DBMS

Reading Time: 4 minutes A database is a collection of related data and data is a collection of facts and figures that can be processed to produce information. Mostly data represents recordable facts. Data aids in producing information, which is based on facts. Now let us know about the DBMS which stands for the Database management system. DBMS is software for sorting and retrieving user data by considering appropriate security Continue Reading

“All You Need To Know About Cloud Computing”

Reading Time: 6 minutes CLOUD COMPUTING Cloud computing is a term for characterising the facilitating administration over the internet. It implies securing and getting to your data, records and tasks over the web instead of your PC hard drive. Cloud computerises your data at whatever time, any place utilising any service over the internet. It gives us opportunity of doing things with more abilities power & straight forwardness. We Continue Reading

All about data connectors

Reading Time: 3 minutes Bottomline: A data connector is used to copy the data from one(or more) source(s) to the data warehouse (usually a single location where it is easy to perform certain operations) What is data connector? A data connector is the logic that enable developers (or data-science folks) to transfer the data from source (after extracting) to the destination. For example you need to prepare a model Continue Reading

Top-5-Reasons-to-Convert-Your-Cloud-Data-Lake-to-a-Delta-Lake

Top 5 Reasons to Convert Your Cloud Data Lake to a Delta Lake

Reading Time: 6 minutes There are various resources that give advice on how to [and how not to] partition your data, how to calculate the ideal file size, how to handle evolving schemas, how to build compaction routines, how to recover from failed ETL jobs, how to stream raw data into the data lake, etc. We have been working with customers throughout this time to encapsulate all of the Continue Reading

DAO | Abstraction of the Application/Business layer from the persistence layer

Reading Time: 3 minutes DAO…. In this blog we’ll be learning about data access objects , it’s pros and cons and implementation in Scala Language. What is DAO …. ? It’s an abbreviation of Data Access Object. It is a structural pattern that provides an abstract API to isolate the application/business layer from the persistence layer . This Layer could be a database or any other persistence mechanism The main purpose Continue Reading

Indexes in Cassandra

Reading Time: 2 minutes Cassandra is a distributed database from Apache which is highly scalable and effective in managing large amounts of structured data. It provides high availability with no single point of failure. Cassandra is column oriented DB. Often used for time series data. Primary keys in Cassandra It is a primary key database which means data is persisted and organised around a cluster based on hash values(partition Continue Reading

Generate logical plan in Calcite

Reading Time: 2 minutes Hello everyone! in the previous blog of Apache Calcite we discussed how Apache Calcite helps you to parse the database query and some basics. In this blog, we will discuss how to generate the logical plan of the database query you have written. What is logical plan A logical plan is a relational expression with only a logical operator. Logical algebra has no implementation of the relational operator and therefore Continue Reading

Different types of Keys in DBMS (Database Management)

Reading Time: 4 minutes Introduction A huge amount of data is available in this real-world. Now, for storing the data in DBMS, a large number of tables are required. These tables may contain thousand of duplicate, sorted, and unsorted Records. Now, to fetch any particular or specific record, without any constraints/ restrictions from these tables is a very difficult process. To overcome all the difficulties, a new concept of Continue Reading