Database

Dataframe and Datasets: Apache Spark’s Developers Friendly Structured APIs

Reading Time: 4 minutes This is a two-part blogs in which first we’ll be covering Dataframe API and in the second part Datasets. Spark 2.x introduced the concept of structuring the spark by introducing two concepts: – to express some computation by using common patterns found in data analysis, such as filtering, selecting, counting, aggregating, and grouping. And the second one of order and structure your data in a Continue Reading

knoldus data-carbon

How To Create And Insert Data In Postgre Hstore

Reading Time: 2 minutes Postgre without a doubt is one of the most popular databases in the market. The reason behind this is PostgreSQL’s speed, security, and robustness. PostgreSQL isn’t just a relational database. PostgreSQL invented many post-relational concepts like in-database functions and user-defined datatypes. Other than that it has many amazing features like Hstore. Now, this blog is for you if you want to know about PostgreSQL Hstore. Continue Reading

How to integrate Liquibase into your application

Reading Time: 4 minutes Introduction Hi everyone! Today we’ll be discussing about how you can integrate Liquibase into your application so that it automatically updates your database. That is especially interesting when you build smaller applications that don’t run in a highly regulated enterprise environment. In these situations, it’s often not possible to run the update process yourself. And there might be no operations team which executes the SQL Continue Reading

black and gray laptop computer turned on doing computer codes

Liquibase : Getting started with Version Based Database Migration

Reading Time: 6 minutes Hi everyone, today in this blog we are going to talk about version-based database migration With Liquibase. Introduction Creating the database for your application seems to be easy. As long as you don’t need to support multiple versions or work in a huge team. You just generate an SQL script from your database model. Or in the worst case, export the required statements from your Continue Reading

Pentaho Database Connection

Reading Time: 3 minutes If you want to work with a database, either read, write, view data, etc, in Pentaho the first thing you will have to do is to create a connection with that database. This blog will teach you how to do this. So, let’s start. Getting ready In order to set up the connection, you will require to know the connection settings. At least you will need 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

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

Getting Started – Spring Boot with MongoDB

Reading Time: 6 minutes Spring Boot with MongoDB Topics to cover in Spring Boot and MongoDB In this blog we are going to see the beginning basics of what Spring Boot is? Ways to create Spring Boot Application? What is MongoDB? How to install MongoDB in Ubuntu? How to connect Spring Boot with MongoDB in Ubuntu? Let’s dive right in… What is Spring Boot? Spring Boot is a module 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

Loading JSON data into Snowflake

Reading Time: 4 minutes Have you ever faced any use case or scenario where you’ve to load JSON data into the Snowflake? We better know JSON data is one of the common data format to store and exchange information between systems. JSON is a relatively concise format. If we are implementing a database solution, it is very common that we will come across a system that provides data in Continue Reading

Want to know about Greenplum?

Reading Time: 6 minutes Hello Developer’s, this blog is about what is Greenplum and the feature of Greenplum. So it is an MPP SQL Database based on PostgreSQL. Greenplum Database scales to multi-petabyte data sizes with ease. It also allows a cluster of powerful servers to work together to provide a single SQL interface to the data. We also discuss how to install Greenplum on the system. What is Continue Reading