Clustered index, covering, multi-column & fuzzy indexبالعربي - Designing Data Intensive Apps Ch3.3

Walking through the great book for Martin Kleppmann

https://www.amazon.de/Designing-Data-Intensive-Applications-Reliable-Maintainable/dp/1449373321

Chapter 3 - #database #storage and Retrieval

Slides

https://github.com/ahmdelemam/designing-data-intensive-slides/blob/main/Designing%20Data%20Intensive%20apps%20-%20CH3%203.pdf

▬ Contents of this video ▬▬▬▬▬▬▬▬▬▬

00:00 - How secondary index works inside the database engine?
03:40 - What is #clustered #index?
04:30 - What is #covering #index?
05:18 - What is #multi-column / #composite index and #Spatial index / #Geo-Spatial index?
07:20 - What is #fuzzy index? How #searchengine works?
10:16 - In memory databases.
12:25 - Comparison between #OLTP vs #OLAP
14:30 - What is data warehouse?
17:30 - Stars schema vs snowflakes schema in data warehouse.
19:30 - what is column oriented storage and how it is used inside data warehouse?
22:00 - What is bitmap encoding and Run-length encoding?
24:38 - How #Bitwise OR / Bitwise AND works?
27:50 - what is #Materialized view and how it works?

Resources

https://github.com/msarhan/lucene-arabic-analyzer

https://blog.mikemccandless.com/2011/03/lucenes-fuzzyquery-is-100-times-faster.html

https://www.youtube.com/watch?v=zIjfhVPRZCg&ab_channel=HackerRank

Видео Clustered index, covering, multi-column & fuzzy indexبالعربي - Designing Data Intensive Apps Ch3.3 канала Ahmed Elemam - أحمد الإمام