Discussion about this post

User's avatar
John Elliot V's avatar

Hi Pat. I'd like to think more about syndicated reference data. Particularly, with syndicated reference data, what do you think the role is for auto_increment integer primary keys? I'm thinking that syndicated reference data would prefer natural keys, such as e.g. Part Number 'ZX1234', rather than Part ID 1234 (which, being an auto_increment ID, might vary across syndicated schemata? And if Part ID is not auto_increment then how is it allocated and managed?). But if we do use natural keys for syndicated reference data, then how do we reference them within our own schema? Do we just use the natural key directly in our foreign key table, as, e.g., 'ZX1234', or should we wrap the natural key in our own table and allocate it an auto_increment ID for within our schema..? Also what processes do we have for maintaining and distributing syndicated reference data? Are hard deletions allowed or only soft deletions as with an 'is_deleted' flag? If you wanted to talk more about this I'd be happy to hear from you via your blog of you could email me at jj5@jj5.net. Hope to hear from you. Thanks!

Expand full comment
Dave Feldman's avatar

Since teched2002 I’ve used your deck to shape the thinking of my teams around how we thinking about system boundaries and interfaces. Really glad to see this updated new version of the content

Expand full comment
1 more comment...

No posts