Aditya Chatterjee's Blog, page 108

Graph Database in System Design

In this article, we will look at what are graph databases, how they differ from traditional relational databases, and their uses in System Design.

Table of Contents

What is a Graph?Graph DatabasesTypes of Graph DatabasesNeed for Graph DatabasesPopular Graph DatabasesUsecase - Credit Card Fraud DetectionChallenges in Graph DatabasesWhat is a Graph?

A graph is a collection of nodes that are connected by edges. An edge always connects 2 nodes.

In the above image, 1,2,3,4 and 5 are called ...

Data Warehousing using SSIS

In this article, we will learn how SQL Server Integration Services (SSIS) is used for Data Warehousing in Data Science.

Table of contentsPrerequisitesCreating an ETL solution using SSIS

Prerequisites

For this tutorial, we will be using SQL server 2019 and Visual Studio 2019. Make sure that you use VS 2019 as VS 2022 does not contain certain extensions that we will be using as of now. Download the extensions Microsoft Analysis Services Projects, Microsoft Reporting Services Projrcts and SQL ...

Data Warehousing

In this article, we will understand the concept of Data Warehousing in Data Science and get an idea of some tools used for data warehousing.

Table of contentsWhat is Data Warehousing?Tools used for data warehousingGoogle BigQueryMS SSISIBM Db2 WarehouseAmazon RedshiftSnowflakeTeradataProgestreSQL
What is Data Warehousing?

A data warehouse is a relational database that is designed for query and analysis. It is used for aggregating data from many data sources into a single consisten...

tf.reshape(): Reshape tensors in TensorFlow

In this article, we have explored the idea of Reshaping tensors in TensorFlow with tf.reshape() and which models like GoogleNet use it.

Table of contents:

Introductiontf.reshape()Usage of reshape in ModelsConclusionIntroduction

TensorFlow is a module that allows engineers to create and build models by representing sets of data as tensors. A tensor is a generalization of vectors and matrices to potentially higher dimensions. Tensorflow represents tensors as n-dimensional arrays of specified...

journalctl in Linux

In Linux, systemd provides a centrally managed journal where all kernel and userland processes' logs are stored. We use journalctl to interact with journals.

Table of contents.Introduction.Syntax.Commands.Summary.References.Introduction.

In Linux, system logs are stored in the /var/log directory:

ls /var/log

systemd provides a centrally managed journal where all kernel and userland processes' logs will be stored.

This journal contains logs collected from different services as can be se...

SSH passwordless login in Linux

Passwordless login is useful in cases whereby we want to automate server administration tasks. We discuss how to configure ssh passwordless login in Linux.

Table of contents.Introduction.Requirements.Setup.Configuring passwordless login.Disabling passwordless login.Summary.References.Introduction.

Secure Shell(SSH) is a cryptographic networking protocol we use for encrypting communications between computers over the internet.

For use to use ssh we require authentication and the two aut...

Accessing a remote server using SSH

Secure Shell(ssh) is a cryptographic protocol for networking that encrypts communication between two remote hosts. In this article, we learn how to safely access a remote server using ssh.

Table of contents.Introduction.Prerequisites.Initial setup.Server configuration.Client configuration.Terminating the connection.Summary.References.Introduction.

SSH(Secure Shell) is a networking protocol that is used to encrypt communication between two hosts. In the following sections, we will see ...

Managing packages with yum/dnf in RHEL

Package management involves managing software on a system. This includes installing, upgrading, downgrading, updating, removing, etc. We discuss package management in Red Hat Enterprise Linux Distros using yum and dnf.

Table of contents.Introduction.Syntax.Commands.Differences between dnf and yum.Summary.References.Introduction.

yum(Yellowdog Updater Modified) is the primary package manager for Red Hat Enterprise Linux distributions such as Rocky Linux, AlmaLinux, CentOS, Fedora, etc.
d...

Factory Pattern in Python

In this article, we have explained the idea of Factory Pattern in Python with a complete Python implementation example.

Table of contents:

Introduction to Factory PatternReasons for using Factory MethodImplementations without using Factory MethodProblem with using the non-factory methodImplementations using Factory MethodSolution offered by using Factory MethodIntroduction to Factory Pattern

Factory method also known as Virtual Constructor is a Creational Design Pattern which allow reusi...

Managing Debian packages with dpkg

In Linux software is considered a package and is distributed using remote repositories. As end-users, we use package managers such as dpkg to manage packages.

Table of contents.Introduction.Syntax.Commands.Summary.References.Introduction.

Package management involves downloading, installing, upgrading, updating, downgrading, removing, and purging software just to name a few.
dpkg is a Linux package manager used to extract, analyze, unpack, build, install, remove .deb files.

Syntax.

When w...