We are using a databse application from our software vendor for electronic medical records. While I was poking around the database structure, I noticed they use string keys for every table, for ...

Surrogate means a stand-in, a substitute. Surrogate keys take the place of a natural key as the primary key within a database table. Ideally, surrogate keys stand in the shadows and are used in ...