Database Design 26 - Should I use Surrogate Keys or Natural Keys?

Подписаться 624 тыс.

Просмотров 27 тыс.

50% 1

Start your software dev career - calcur.tech/dev-fundamentals 💯 FREE Courses (100+ hours) - calcur.tech/all-in-ones
🐍 Python Course - calcur.tech/python-courses
✅ Data Structures & Algorithms - calcur.tech/dsa-youtube
~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~
✉️ Newsletter - calcur.tech/newsletter
📸 Instagram - / calebcurry
🐦 Twitter - / calebcurry
🔗 LinkedIn - / calebcurry
▶️ Subscribe - calcur.tech/subscribe
👨🏻‍🎓 Courses - www.codebreakthrough.com
~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~
↪ My Amazon Store - www.amazon.com/shop/calebcurry
🅿 Patreon - calcur.tech/patreon-calebcurry
🅖 GitHub Sponsors - github.com/sponsors/CalebCurry
Ⓟ Paypal - paypal.me/calcur
🅑 Bitcoin - 3HnF1SWTzo1dCU7RwFLhgk7SYiVfV37Pbq
🅔 Eth - 0x350139af84b60d075a3a0379716040b63f6D3853
📈 Buy Bitcoin - calcur.tech/crypto
Reserve the Ruby Steel crypto rewards card and get a $25 bonus (use affiliate code "Caleb") - calcur.tech/crypto

Наука

Опубликовано:

8 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 25

@Professor__Cow 2 месяца назад

Caleb - Your theatrics were adorable and make these videos entertaining!

@MariuszKlinikowski 6 лет назад

Yes, you're saving some space with natural keys, but surrogate keys, like just number (integer) are faster during comparisons. Like you need to compare 4 bytes of integer versus 10-11 for string "CelebCurry\0". Databases grows big, so it's more and more important to use numbers, because actualy indexes are usually smaller with integers than strings. :) Anyway - good videos.

@TheSkepticSkwerl 5 лет назад

TBH i think it comes down to the size. I bet Facebook would be best with user names. But a smaller database, say a few million, would be better with id's

@PravinJanjal92 7 лет назад

Your explanation is the best!

@Andrew300082 6 лет назад

Your videos are very helpful to me for doing my homework. Thank you!

@codebreakthrough 10 лет назад

Should you use Surrogate Keys or Natural Keys? Watch this video to find out! buff.ly/V1CEvh

@cassondrad2280 2 года назад

Thanks Caleb, Great way of breaking it down for better understanding.

@VelevGeorgi 8 лет назад

regardless this kid looks pretty much high at the beginning of this video I like the way explanation. Nice and simple

@ScottDamery 9 лет назад

Would you say that you should use Natural Keys for User interfaces and 3rd party services. Use Surrogate for internal db keys. I am looking at creating a trigger that creates a surrogate key when the columns for a natural key change...because I am also creating a type 2 scd table.

@Ejun0 Год назад

Hi Caleb, you got to go back to the chalk board or white board. These videos are great and love your humor throughout them! Much love from NC

@davygriffiths8581 7 лет назад

Hi Caleb, thanks for your videos. V helpful. I'm a bit confused around the difference between Natural and Surrogate key. A natural key is basically a collection of columns that if concatenated would yield unique rows in table, which is effectively the same as adding a unique ID as a proxy for those columns. Wouldn't you always need to know what the natural key would be to establish a surrogate key? Thanks

@codebreakthrough 7 лет назад

+davy Griffiths Hi! You can just add a surrogate 🔑 if you do not have enough data to make a natural one.

@sajadsh8260 3 года назад

thank you , very good

@Cheece777 7 лет назад

Hey Caleb, awesome video series, really helped me understand the basics of Database management systems. However... Seriously do you only have t-shirts with stars and stribes?! :D