Best Practices Working with Billion-row Tables in Databases
In this video, I discuss 3 methods to work with tables of billion rows. This discussion is inspired by a comment on my YouTube video on Twitter System Design right here https://www.youtube.com/watch?v=gfq-LG9ZJQA&lc=UgyYbm5889dW0XtKhsV4AaABAg
Chapters
Intro 0:00
1. Brute Force Distributed Processing 2:30
2. Working with a Subset of table 3:35
2.1 Indexing 3:55
2.2 Partitioning 5:30
2.3 Sharding 7:30
3. Avoid it all together (reshuffle the whole design) 9:10
Summary 11:30
🎙️Listen to the Backend Engineering Podcast
https://husseinnasser.com/podcast
🏭 Backend Engineering Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQUNnO4p00ua_C5mKTfldiYT
💾 Database Engineering Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQXjD0HOzN7P2tgzu7scWpl2
🏰 Load Balancing and Proxies Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQVMeBmWI2AhxULWEeo7AaMC
🏛️ Software Archtiecture Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQXNP6mQchJVP3S-3oKGEuw9
📩 Messaging Systems
https://www.youtube.com/playlist?list=PLQnljOFTspQVcumYRWE2w9kVxxIXy_AMo
Become a Member
https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join
Support me on PayPal
https://bit.ly/33ENps4
Stay Awesome,
Hussein
Видео Best Practices Working with Billion-row Tables in Databases канала Hussein Nasser
Chapters
Intro 0:00
1. Brute Force Distributed Processing 2:30
2. Working with a Subset of table 3:35
2.1 Indexing 3:55
2.2 Partitioning 5:30
2.3 Sharding 7:30
3. Avoid it all together (reshuffle the whole design) 9:10
Summary 11:30
🎙️Listen to the Backend Engineering Podcast
https://husseinnasser.com/podcast
🏭 Backend Engineering Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQUNnO4p00ua_C5mKTfldiYT
💾 Database Engineering Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQXjD0HOzN7P2tgzu7scWpl2
🏰 Load Balancing and Proxies Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQVMeBmWI2AhxULWEeo7AaMC
🏛️ Software Archtiecture Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQXNP6mQchJVP3S-3oKGEuw9
📩 Messaging Systems
https://www.youtube.com/playlist?list=PLQnljOFTspQVcumYRWE2w9kVxxIXy_AMo
Become a Member
https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join
Support me on PayPal
https://bit.ly/33ENps4
Stay Awesome,
Hussein
Видео Best Practices Working with Billion-row Tables in Databases канала Hussein Nasser
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Asynchronous vs Multithreading and Multiprocessing Programming (The Main Difference)How to Make a Colored Epoxy Resin TableCan Redis be used as a Primary database?Amazing Extremely Creative Woodworking Idea From Discarded Wood // Build Outdoor Table For GardenFundamentals of Amazon DynamoDB Single Table Design with Rick HoulihanShow your Backend Engineering Skills To Recruiters - Building a Full Backend PortfolioColumn vs Row Oriented Databases ExplainedData modeling best practices - Part 1 - in Power BI and Analysis ServicesUUIDs are Bad for Performance in MySQL - Is Postgres better? Let us DiscussHAProxy Crash Course (TLS 1.3, HTTPS, HTTP/2 and more)Is there a Limit to Number of Connections a Backend can handle?HUGE 60L Epoxy Live Edge River Table!node http is beautifulIs SELECT * Expensive?5 Apps To Create Profitable T-Shirt Designs (For FREE!) - Print On Demand Designing TutorialSystem Design Introduction For Interview.How Important are Algorithms and Data Structures in Backend Engineering?How do nested loop, hash, and merge joins work? Databases for Developers Performance #7Why Timeouts are Critical on the Backend #shorts #nginxBecoming a better developer by using the SOLID design principles by Katerina Trajchevska