---
title: "#surrogate-key articles | Hashnode"
description: "Explore 3 articles tagged #surrogate-key on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/surrogate-key"
---

Tag

# #surrogate-key

3 posts · 0 followers

[Joony](https://hashnode.com/@joony) · [Nov 12, 2025](https://hashnode.com/posts/surrogate-key-instead-of-sequence/691477ba444bc2c7510ea900)

### [순번 속성 대신 인조식별자를 사용하는 방법론](https://joony.hashnode.dev/surrogate-key-instead-of-sequence?utm_source=hashnode&utm_medium=feed)

💡 이 글은 본질식별자(Natural Key)에 대한 이해가 있는 독자를 대상으로 합니다. 본질식별자에 발생시각 속성이 있을 때, 물리적으로 동일 시각에 여러 인스턴스가 발생하여 유일성이 깨지는 문제를 해결하기 위해 순번을 부분 인조식별자를 추가하는 경우가 있다. 식별자를 이렇게 설계할 경우, 순번 속성의 추가가 식별자의 수를 늘리고 성능에 악영향을 줄 수 있다. 이때 일련번호성 인조식별자를 도출하여 여기에 순번의 역할을 부여하면 본질...

2 min read · [joony.hashnode.dev](https://joony.hashnode.dev/surrogate-key-instead-of-sequence?utm_source=hashnode&utm_medium=feed)

[Nicolas Perron](https://hashnode.com/@nicolasperron) · [Apr 23, 2023](https://hashnode.com/posts/doit-on-utiliser-les-cles-de-substitut-surrogate-keys/6444a9f70564bc8f7cfba117)

### [Doit-on utiliser les clés de substitut (Surrogate keys)?](https://blogdev.ca/doit-on-utiliser-les-cles-de-substitut-surrogate-keys?utm_source=hashnode&utm_medium=feed)

L’utilisation de clés de substitut (Surrogate keys) est très utile afin d’éviter de propager la clé logique dans d’autres tables en tant que clés étrangères (Foreign key). Le but est de pouvoir modifier la clé de la table sans avoir à faire des man...

2 min read · [blogdev.ca](https://blogdev.ca/doit-on-utiliser-les-cles-de-substitut-surrogate-keys?utm_source=hashnode&utm_medium=feed)

[Tiffany Chong](https://hashnode.com/@sciffany) · [Jan 25, 2023](https://hashnode.com/posts/primary-key-vs-surrogate-key-when-working-with-3rd-party-database/63d0eea3629bc902ab033076)

### [Primary Key vs Surrogate Key When Working with 3rd Party Database](https://blog.sciffany.com/primary-key-vs-surrogate-key-when-working-with-3rd-party-database?utm_source=hashnode&utm_medium=feed)

Which key should you use as primary key when working with a third party database?

3 min read · [blog.sciffany.com](https://blog.sciffany.com/primary-key-vs-surrogate-key-when-working-with-3rd-party-database?utm_source=hashnode&utm_medium=feed)