#rdbms

RDB 에서 큰 컬럼을 인덱스로 잡으면 안되는 이유

B-Tree 는 기본적으로 페이지 사이즈 와 저장할 수 있는 원소의 개수를 고정값으로 사용한다. 하지만 우리가 실제로 페이지에 저장하는 값은 가변적인 크기를 가지고 있기 때문에 필연적으로 물리적으로 저장해야할 개수가 다 차기도 전에 페이지가 넘치는 상황에 부딪히게 된다. 예를 들어 100KB 를 저장하는 페이지에 위와 같이 데이터를 저장한 상태이다. 여

1d ago2 min read

TSTudor Stanilatrdb.hashnode.dev

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...

Jan 196 min read

TSTudor Stanilatrdb.hashnode.dev

maintaining stable row identifiers during page maintenance

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...

Jan 57 min read

NKNiranjan Kumarscalable.hashnode.dev

Database Concepts for Modern System Design

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...

Nov 19, 20252 min read

MMichaelmmuehlbeyer.hashnode.dev

Connect AWS RDS Custom for Oracle to SQL Server

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...

Aug 20, 20255 min read

JJebitoksharonjebitok.com

Challenges: Poster (TryHackMe)

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...

Aug 8, 20255 min read

SMSourav Mahatoblog.souravmahato.in

PostgreSQL Setup on openSUSE [Linux] pgAdmin4 Authentication Issue (peer, ident to md5)

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...

Jul 29, 20251 min read

LALord Abiollaalx-data-analytics.hashnode.dev

Querying Data

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...

Jul 30, 20258 min read

李李卡爾cyl.hashnode.dev

關於 Hash index

什麼是 Hash Index？ Hash Index 是資料庫系統中的一種索引結構，它使用雜湊函數（Hash Function）將索引鍵（Key）映射到資料表中的記錄位置。相較於傳統的 B-Tree 索引，Hash Index 在某些特定查詢場景下能提供更高效的性能。基本原理 Hash Index 的核心原理是：使用雜湊函數將索引鍵轉換為雜湊值（Hash Value）雜湊值決定資料記錄在雜湊表（Hash Table）中的儲存位置查詢時，系統對索引鍵應用相同的雜湊函數，直接定位到對應...

Jul 26, 20251 min read

LWLim Woojaejaylog.hashnode.dev

[SQL] Writing Efficient SQL Queries

Think of yourself building a program. It can be any types, such as website, app, etc. These applications may require database to show the data that the user requested. For example, you can think of a table that stores GPS-related data. The longitude ...

Jun 30, 20254 min read

Tag feed

Tag feed

#rdbms

RDB 에서 큰 컬럼을 인덱스로 잡으면 안되는 이유

insertion in heap pages

maintaining stable row identifiers during page maintenance

Database Concepts for Modern System Design

Connect AWS RDS Custom for Oracle to SQL Server

Challenges: Poster (TryHackMe)

PostgreSQL Setup on openSUSE [Linux] pgAdmin4 Authentication Issue (peer, ident to md5)

Querying Data

關於 Hash index

[SQL] Writing Efficient SQL Queries

#rdbms

Search Hashnode

#rdbms

RDB 에서 큰 컬럼을 인덱스로 잡으면 안되는 이유

insertion in heap pages

maintaining stable row identifiers during page maintenance

Database Concepts for Modern System Design

Connect AWS RDS Custom for Oracle to SQL Server

Challenges: Poster (TryHackMe)

PostgreSQL Setup on openSUSE [Linux] pgAdmin4 Authentication Issue (peer, ident to md5)

Querying Data

關於 Hash index

[SQL] Writing Efficient SQL Queries