LinkedIn Professional Network · View 13 of 30 · 4 · Data
Decisions
- Identity is a URN (urn:li:member:123), assigned once and never reused. Vanity URL, name and email are mutable attributes, never keys
- A connection is one row per member pair, smaller URN first, so there is never an A-to-B versus B-to-A disagreement to repair
- Messages are keyed by conversation and sequence number, which makes their order a property of the key
Partition keys
- Member data by member_urn · posts by author_urn · messages by conversation_urn
- Jobs by company_urn · connections by pair_key, with an adjacency index per member
- Applications by member for the seeker's view, with a second index by job for the recruiter's view
Deliberately omitted
- Education, skills, certifications, groups and schools: each is shaped like position
- Hashtags and mentions, which are URN arrays on the post