We could then compare the key values and use it to estimate how many new profiles were created during that day. If that were the case then we could wait a day and create a new profile. Suppose that 67638 is the auto-incrementing key value that was uniquely assigned to the profile. Leakiness in this case means that key values convey information about the state of the system that we didn't intend to disclose.įor example, suppose you would subscribe to a new social media site, and you get assigned a personal profile page which looks like this: Much has been written about this subject with regard to storage space, query performance and so on, but in this particular case the main consideration was leakiness. I recently overheard a statement about whether to use auto-incrementing id's (i.e, a sequence managed by the RDBMS) or universal unique identifiers (UUIDs) as method for generating surrogate key values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |