Database Reference
In-Depth Information
INSERT INTO "home_status_updates"
("timeline_username", "status_update_id",
"status_update_username", "body")
VALUES (
'alice',
16e2f240-2afa-11e4-8069-5f98e903bf02,
'dave',
'dave update 4'
);
The flow of the write operation looks pretty much the same as the partially denormalized
version:
1. Look up the author's followers.
2. Write the status update to the author's user timeline.
3. Write a copy of the status update to each of the followers' home timelines.
The only difference between partial and full denormalization is that, in the final step, we
write all the data from the status update to the home timeline, not just the primary key val-
ues.
Search WWH ::




Custom Search