Learn about the differences in row store vs column store database. This is a very important concept for understanding the difference between analytical and transactional databases, and we talk about the tradeoffs between using row and column stores for saving the data.
We get into the weeds and talk about disk blocks and the different types of queries that work well for row and column stores.
Поделиться в:
Доступные форматы для скачивания:
Скачать видео mp4
Информация по загрузке:
Скачать аудио mp3
Похожие видео
array(10) {
[0]=>
object(stdClass)#4390 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "B8r4YZ248l8"
["related_video_title"]=>
string(30) "Episode 3: Transactions Part 1"
["posted_time"]=>
string(19) "5 лет назад"
["channelName"]=>
string(21) "Databases Demystified"
}
[1]=>
object(stdClass)#4363 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "i-FFVM4cIXQ"
["related_video_title"]=>
string(138) "База по Базам Данных - Storage (Индексы, Paging, LSM, B+-Tree, R-Tree) | Влад Тен Систем Дизайн"
["posted_time"]=>
string(21) "5 дней назад"
["channelName"]=>
string(15) "Влад Тен"
}
[2]=>
object(stdClass)#4388 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "pLoBQMnwLZc"
["related_video_title"]=>
string(39) "Episode 1: Analytical vs. Transactional"
["posted_time"]=>
string(19) "5 лет назад"
["channelName"]=>
string(21) "Databases Demystified"
}
[3]=>
object(stdClass)#4395 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "J-sj3GUrq9k"
["related_video_title"]=>
string(39) "Episode 5: Distributed Databases Part 1"
["posted_time"]=>
string(19) "5 лет назад"
["channelName"]=>
string(21) "Databases Demystified"
}
[4]=>
object(stdClass)#4374 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "8L51FUsjMxA"
["related_video_title"]=>
string(115) "Как устроена База Данных? Кластеры, индексы, схемы, ограничения"
["posted_time"]=>
string(27) "5 месяцев назад"
["channelName"]=>
string(25) "Артём Шумейко"
}
[5]=>
object(stdClass)#4392 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "k9DpO91W76o"
["related_video_title"]=>
string(82) "SQL Columnstore Index Explained | Columnstore vs Rowstore Indexes | #SQL Course 36"
["posted_time"]=>
string(27) "7 месяцев назад"
["channelName"]=>
string(15) "Data with Baraa"
}
[6]=>
object(stdClass)#4387 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "blWdjRUPP6E"
["related_video_title"]=>
string(72) "Разведчик о том, как использовать людей"
["posted_time"]=>
string(25) "2 недели назад"
["channelName"]=>
string(18) "Коллектив"
}
[7]=>
object(stdClass)#4397 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "pJWCwfv983Q"
["related_video_title"]=>
string(87) "How do nested loop, hash, and merge joins work? Databases for Developers Performance #7"
["posted_time"]=>
string(21) "4 года назад"
["channelName"]=>
string(16) "The Magic of SQL"
}
[8]=>
object(stdClass)#4373 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "T24C5W9ps1A"
["related_video_title"]=>
string(94) "Россия в 2035: будет ли, как в Иране? Екатерина Шульман"
["posted_time"]=>
string(23) "5 часов назад"
["channelName"]=>
string(18) "The Breakfast Show"
}
[9]=>
object(stdClass)#4391 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "qMQLnkTOkCo"
["related_video_title"]=>
string(173) "Израиль vs Иран: чья армия сильнее? | «Железный купол», ПВО, МОССАД vs дроны, самолеты, прокси"
["posted_time"]=>
string(21) "1 день назад"
["channelName"]=>
string(8) "varlamov"
}
}
