May 5 · 7 min read · If you have mastered the basic SELECT, FROM, and WHERE statements, congratulations! You have taken the first step into the world of databases. However, to truly analyze data and extract meaningful bus
Join discussion
Jan 19 · 6 min read · Originally published on tudor96stani.com Intro Insertion in heap pages is, in theory, straightforward: you find some free space in the page, place the row there and create a slot pointing to that location. There are, however, multiple small details t...
Join discussionJan 5 · 7 min read · Originally published on tudor96stani.com intro Christmas, New Year's, a 1-week ski trip, time with family, the rabbit hole of a full re-organization of my Obsidian vault into a Zettelkasten slip box after reading How to take smart notes - all of thes...
Join discussionNov 19, 2025 · 2 min read · Why do we need databases? Or even storage? Suppose you are ordering a book from an e-commerce platform. You open the app, search for the book, and the system must fetch that information instantly. This means the application needs a place to store pro...
Join discussion
Aug 20, 2025 · 5 min read · To connect an Oracle database(this time we use an AWS RDS Custom for Oracle) with an SQL Server (Cloud or On-Prem) you could make use of the Oracle database gateway for SQL Server. In general the gateway serves as a link between Oracle and external s...
Join discussion
Aug 8, 2025 · 5 min read · Relational Database Management Systems (RDBMS) are the backbone of modern data-driven applications. Unlike flat-file or hierarchical systems, an RDBMS structures information into tables linked by relationships, enabling fast queries, efficient storag...
Join discussion
Jul 29, 2025 · 1 min read · These days I decided to start learning SQL and tried installing PostgreSQL on my openSUSE 15.6 machine. In Windows it's just one installer and done. But in Linux, I got totally stuck. First I added the PostgreSQL repo and managed to run the server us...
Join discussionJul 30, 2025 · 8 min read · Data Structures Data Structures can be defined as containers that hold and organize data in specific formats. Data structures also determine how data are stored, accessed or modified. Data structures can be categorized into two main types; Primitive...
Join discussion
Jul 26, 2025 · 1 min read · 什麼是 Hash Index？ Hash Index 是資料庫系統中的一種索引結構，它使用雜湊函數（Hash Function）將索引鍵（Key）映射到資料表中的記錄位置。相較於傳統的 B-Tree 索引，Hash Index 在某些特定查詢場景下能提供更高效的性能。 基本原理 Hash Index 的核心原理是： 使用雜湊函數將索引鍵轉換為雜湊值（Hash Value） 雜湊值決定資料記錄在雜湊表（Hash Table）中的儲存位置 查詢時，系統對索引鍵應用相同的雜湊函數，直接定位到對應...
Join discussion
