Cogito Ergo Sum
Hello and welcome to my blog.
A father, wanderer, lifelong learner, runner, and software engineer writing about technology, data, mathematics, and the spaces between them.
Fabric · Power BI · Running · Numbers · AI · Mathematics
Graphs
A graph is a collection of nodes (vertices) connected by edges (lines)
Markovian Property and Markov Chain
The Markovian property states that the future state of a process depends only on the present state, not the past, and a Markov Chain is a sequence of states following this property with defined transition probabilities.
SQL statement types
SQL statements are categorized into three main types: DDL (Data Definition Language), DCL (Data Control Language), and DML (Data Manipulation Language).
Data Roles
A Database Administrator (DBA) manages and secures databases, a Data Engineer builds data pipelines and infrastructure, and a Data Analyst interprets and visualizes data to extract insights.
The ACID Principle
ACID ensures database transactions are Atomic (all or nothing), Consistent (valid state maintained), Isolated (independent execution), and Durable (permanent after commit).
Optimized file formats
File formats like Avro, Optimized Row Columnar (ORC) and Parquet