Dynamic materialization of feeds for enabling access of the feed in an online social network

One or more computing devices for of dynamic materialization of a feed for enabling access of the feed in an online social network, the one or more computing devices comprising:

• a memory storing one or more instructions;
• and
• one or more processors configured to execute the one or more instructions to:
• receive a request for a feed, wherein the feed is defined based on two or more parameters,
• determine a state of the feed, wherein the state of the feed can be any one of an active state, an inactive state, an activating state, an inactivating state, and a disabled state,
• responsive to determining that the state of the feed is the inactive state, perform the following:
• to cause the request for the feed to be processed at a first relational database system,
• to cause materialization of the feed populating a materialized feeds table in the a second non-relational database system with feed items of the feed from the first relational database system, and
• to set the state of the feed to the activating state,
• responsive to determining that the state of the feed is the active state, cause the request for the feed to be processed from the materialized feeds table in the second non-relational database system;
• responsive to determining that the state of the feed is the inactivating state, cause the request for the feed to be processed from the first relational database system;
• and
• responsive to determining that the state of the feed is the disabled state, perform the following:
• to cause the request for the feed to be processed from the first relational database system, and
• to cause an update of the materialized feeds table in the second non-relational database system to be postponed for a predetermined amount of time.

A non-transitory computer-readable storage medium storing instructions executable by a computing device to perform a method of dynamic materialization of a feed for enabling access of the feed in an online social network, the method comprising:

• receiving a request for a feed, wherein the feed is defined based on two or more parameters;
• determining a state of the feed, wherein the state of the feed can be at least any one of an active state, an inactive state, an activating state, an inactivating state, and a disabled state;
• responsive to determining that the state of the feed is the inactive state, performing the following:
• causing the request for the feed to be processed at a first relational database system,
• causing materialization of the feed by populating a materialized feeds table in the second non-relational database system with feed items of the feed from the first relational database system, and
• setting the state of the feed to the activating state;
• responsive to determining that the state of the feed is the active state, causing the request for the feed to be processed from the materialized feeds table in the second non-relational database system;
• responsive to determining that the state of the feed is the inactivating state, causing the request for the feed to be processed from the first relational database system;
• and
• responsive to determining that the state of the feed is the disabled state, performing the following:
• causing the request for the feed to be processed from the first relational database system, and
• causing an update of the materialized feeds table in the second non-relational database system to be postponed for a predetermined amount of time.