๐Ÿ’ป
Albert's Til
GitHub
  • ๋งค์ผ๋งค์ผ ์กฐ๊ธˆ์”ฉ ์„ฑ์žฅํ•˜๊ธฐ
    • README
    • CS
      • Network
      • HTTP
        • NO-CACHE
      • ์˜ค๋ฅ˜ ์ฝ”๋“œ
      • ORM ๋„๊ตฌ
      • Design Pattern
        • CQRS Pattern
          • Event Sourcing and CQRS pattern
        • Builder Pattern
    • DB
      • MySQL
        • Timeline
        • Pagination
        • Index
        • Database Performance Optimization Strategies
        • B+ tree
        • MySQL Connectors VS MySQL Shell(Scripting) VS MySQL Workbench
        • MySQL Storage Engine Architecture
      • Normalization & Denormalization
      • JPA
        • @Transactional
        • Why JPA?
        • About JPA
        • N+1 Issue
        • Index
        • ElementCollection&CollectionTable
        • orphanRemoval
        • CascadeType
        • Use Subselect
        • Dynamic Instance Creation
        • Paging
        • Order
        • Spefication
        • mappedBy
      • MongoDB
        • ObjectId
      • Why MySQL?
      • ACID properties of transactions
      • Between JPA and JDBC
      • Identifiers in Hibernate/JPA
    • Java
      • Jackson de/serialize
      • Collections.singletonList() vs List.of()
      • Manage dependencies in Gradle
      • Logging Level
      • Bean Validation
      • JVM Internals
        • Threads
          • Frame
        • Shared Between Threads
          • Classloader
            • Class Loader Hierarchy
            • Loading Linking Initialization
      • Java Collection Framework
      • Annotation
      • Generic
      • ๋””๋ฏธํ„ฐ ๋ฒ•์น™
    • Spring
      • Caching
      • Spring Integration Overview
        • ThreadPollTaskExecutor
        • Messaging Bridge
        • Channel Adapter
        • Poller
        • Configuration and @EnableIntegration
        • Message Endpoints
        • Message Channels
      • HATEOAS
      • @Autowired vs Constructor Dependency Injection
      • Spring Security
        • JWT ํ† ํฐ ์‚ฌ์šฉํ•œ ์ธ๊ฐ€
        • OAuth 2 Login
        • OAuth 2 ์ธ์ฆ
        • ์ธ๊ฐ€
        • ์ธ์ฆ
        • PasswordEncoder
      • IoC Container
      • Filter,Interceptor,AOP,Argument Resolver
      • Spring Annotation
      • About Spring
    • Kafka
      • Error Channel
    • Infra
      • Scale Up || Scale Out
      • Docker
        • Dockerfile
        • Docker Hub Deploy
        • Command
      • Cloud ์œ ํ˜•
        • Infrastructure as a Service
        • Platform as a Service
        • Software as a Service
      • ๋ฌด์ค‘๋‹จ ๋ฐฐํฌ
        • ์—”์ง„์—‘์Šค(Nginx)
      • ์ฝ”๋“œ ์ž๋™ ๋ฐฐํฌ
        • Technical
      • AWS EC2
        • PEM(Privacy Enhanced Mail) ํ‚ค
      • AWS RDS
      • AWS S3
    • CodeSquad
      • Spring Boot Project 1์ฃผ์ฐจ ํšŒ๊ณ 
      • Spring Boot Project 2์ฃผ์ฐจ ํšŒ๊ณ 
      • Spirng Boot Project 3์ฃผ์ฐจ ํšŒ๊ณ 
      • Spring Boot Project 4์ฃผ์ฐจ ํšŒ๊ณ 
    • Foody Moody ํ”„๋กœ์ ํŠธ
      • Query Performance Comparison
      • HeartCount Asynchronous Issue
      • DeferredResult
      • ResponseBodyEmitter
      • SseEmitter (Spring)
      • Server-Sent Events (SSE)
      • ๊ธฐ์ˆ  ์Šคํƒ ์ ์šฉ ์ด์œ 
      • NO-CACHE(HTTP)
      • Transactional
    • DDD
      • AggregateId
    • Test
      • RestAssured
    • Coding and Algorithmic Problems
      • 819. Most Common Word
      • 344. Reverse String
      • 125. Valid Palindrome
      • 937. Reorder Data in Log Files
    • Node
      • Async... Await...
      • Custom Transactional Decorator Challenger
    • Python
      • Python Basic Grammar
        • Comments and Input/Output
        • Variable
        • Data type
        • Operations and syntax
        • List,Tuple,Dictionary,Set
        • Function
        • Conditional statement
        • Loop
    • HTML
      • HTML Basic
      • HTML Basic Tags
      • HTML Form Tags
      • HTML Table Tags
    • CSS
      • CSS Basic
      • CSS Practice
Powered by GitBook
On this page
  • ๊ท ํ˜• ์œ ์ง€
  • ๋…ธ๋“œ ๊ตฌ์กฐ
  • ๋ฆฌํ”„ ๋…ธ๋“œ์˜ ๋ฐ์ดํ„ฐ
  • ๋…ธ๋“œ ํฌ๊ธฐ์™€ ๋ฉ”๋ชจ๋ฆฌ ํŽ˜์ด์ง€
  • Relation

Was this helpful?

  1. ๋งค์ผ๋งค์ผ ์กฐ๊ธˆ์”ฉ ์„ฑ์žฅํ•˜๊ธฐ
  2. DB
  3. MySQL

B+ tree

Last updated 1 year ago

Was this helpful?

๊ท ํ˜• ์œ ์ง€

  • B+ํŠธ๋ฆฌ๋Š” ์‚ฝ์ž…๊ณผ ์‚ญ์ œ ์‹œ ํ•ญ์ƒ ๊ท ํ˜•์„ ์œ ์ง€ํ•˜๋Š” ๊ตฌ์กฐ๋ฅผ ๊ฐ€์ง„๋‹ค.

  • ์ด๋Š” ๊ฒ€์ƒ‰,์‚ฝ์ž…,์‚ญ์ œ ์ž‘์—…์˜ ํšจ์œจ์„ฑ์„ ๋ณด์žฅ ํ•œ๋‹ค.

๋…ธ๋“œ ๊ตฌ์กฐ

  • ํ•˜๋‚˜์˜ ๋…ธ๋“œ๋Š” ์—ฌ๋Ÿฌ ๊ฐœ์˜ ์ž์‹ ๋…ธ๋“œ๋ฅผ ๊ฐ€์งˆ ์ˆ˜ ์žˆ์œผ๋ฉฐ, ์ด๋Š” ํŠธ๋ฆฌ์˜ ๊ทœํ˜•๊ณผ ๊ฒ€์ƒ‰ ํšจ์œจ์„ฑ์„ ๋†’์ธ๋‹ค.

๋ฆฌํ”„ ๋…ธ๋“œ์˜ ๋ฐ์ดํ„ฐ

  • ์‹ค์ œ ๋ฐ์ดํ„ฐ๋Š” ๋ฆฌํ”„ ๋…ธ๋“œ์—๋งŒ ์กด์žฌํ•œ๋‹ค. ์ด๋Š” ์—ฐ์†์ ์ธ ๋ฐ์ดํ„ฐ ์ ‘๊ทผ์— ์œ ๋ฆฌํ•˜๋ฉฐ, ์ˆœ์ฐจ์ ์ธ ์ฝ๊ธฐ ์ž‘์—…์—์„œ ๋†’์€ ์„ฑ๋Šฅ์„ ์ œ๊ณตํ•œ๋‹ค.

๋…ธ๋“œ ํฌ๊ธฐ์™€ ๋ฉ”๋ชจ๋ฆฌ ํŽ˜์ด์ง€

  • B+ํŠธ๋ฆฌ์˜ ๋…ธ๋“œ ํฌ๊ธฐ๋Š” ๋Œ€๊ฐœ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์‹œ์Šคํ…œ์˜ ๋ฉ”๋ชจ๋ฆฌ ํŽ˜์ด์ง€ ํฌ๊ธฐ์— ๋งž์ถฐ ์„ค์ •ํ•œ๋‹ค.

// Apple M1 Pro ๊ฐ€์ฅฐ
getconf PAGESIZE
16384 (16KB)

Relation

B+ tree WIKI
B+ tree ์‹œ๋ฎฌ๋ ˆ์ด์…˜
From Wiki