Nidhi Gupta – Medium

1 day ago

DATA PROCESSING

DATA PROCESSING There are two mechanism’s that help us in creating visualization from the data that is structured, unstructured, or semi-structured. In order to perform ETL or ELT activities data is the major component i.e., …

Data Science

2 min read

Jun 20

Hive

The term Big Data is used for the collection of a huge amount of data in a distributed environment where data is measured in terms of VVV(Velocity, Variety, and Volume). …

Hive

2 min read

Jun 11

Fivetran

After a long 🙂 back with another article. This article is about Fivetran🤔. No worries 🙃 if you heard this for the first time or it's great if you already know about it. This article is for the people i.e; my audience who heard it for the first time. As…

Cloud

2 min read

May 28

Dimension, Fact, and Measure in Data warehouse

Dimension, Fact, and Measure in Data warehouse Datawarehouse is the storehouse or central repository for structured data. Data coming from various resources CRM, ERP, Billing, Supply chain, etc…., are first cleaned, transform, and then loaded into a storehouse called a data warehouse. In order to store data in the data warehouse, we use a design pattern called…

Sql

1 min read

Dimension, Fact, and Measure in Data warehouse

May 13

MYSQL MERGE STATEMENT

MYSQL MERGE STATEMENT Merge statements are available in the Microsoft SQL Server and will be available in PostgreSQL soon with the latest version mostly available in all databases. But whether it exists in MySQL too?🤔 This article is about MySQL Merge Statement. This statement is mostly used when we need…

My SQL

3 min read

May 1

Enable security on ELK

Security plays an important when it comes to data. In order to protect our data, we must enable security to our database access. This article will help in understanding how to secure ELK data from unauthorized access by enabling security features on Elasticsearch, Logstash, and Kibana. Step1: Enable the security…

Kibana

1 min read

Apr 24

OLAP vs OLTP

OLAP vs OLTP With the rate at which data is increasing day by day so the requirement for data analysis, data processing, data migration, data operation, and data conversion is also increasing. In a world full of different types of data OLTP and OLAP places a major role. In this article let’s understand OLAP vs OLTP Thank for the read. Do clap if find it useful.😊 “keep learning and keep sharing knowledge”

Cloud Computing

1 min read

OLAP vs OLTP

With the rate at which data is increasing day by day so the requirement for data analysis, data processing, data migration, data operation, and data conversion is also increasing. In a world full of different types of data OLTP and OLAP places a major role.

In this article let’s understand OLAP vs OLTP

Thank for the read. Do clap if find it useful.😊

“keep learning and keep sharing knowledge”

Apr 17

Primary shards & Replica shards in Elasticsearch

Primary shards & Replica shards in Elasticsearch Shards offer the most competitive balance between allocation speed, nodes balancing, and overall cluster management. In this article let’s understand the theoretical and practical concept of sharding in elastic search. Let’s understand first what sharding is, and how it proved to be an advantage or disadvantage in databases. If we…

Women In Tech

3 min read

Primary shards & Replica shards in Elasticsearch

Apr 5

PostgreSQL-15 with few new updates

PostgreSQL-15 with few new updates Postgresql is a powerful, open-source, and object-relational database. Each version of PostgreSQL comes with major updates so this time PostgreSQL version-15 is coming with few new updates. This article is all about the upcoming release of PostgreSQL version 15 and its new updates. IS JSON predicate Resource link: Waiting for PostgreSQL 15 - IS JSON predicate Title: Waiting for PostgreSQL 15 - IS JSON predicate On 28th of March 2022, Andrew Dunstan committed patch: This is…www.depesz.com

Postgresql

1 min read

Apr 1

Re-Indexing in elastic search

Re-Indexing in elastic search Recently working on my current project had faced a scenario where a particular field of an index is not able to add or update data. …

No SQL

2 min read