Database management for modifying data related to industrial assets using an intelligent data queue for data ingestion

A computer-implemented method comprising:

• receiving a data modification payload associated with a request to modify one or more portions of asset data stored in a time series database, wherein the asset data digitally represents one or more assets within an industrial environment;
• parsing the data modification payload to identify a type of modification with respect to the asset data stored in the time series database;
• storing the data modification payload in at least one of a first data cache configured for storing pending data modification payloads and a second data cache configured for processing data modification payloads;
• and
• in response to a determination that the data modification payload is stored in the second data cache, modifying, based at least in part on the type of modification, the asset data stored in the time series database to facilitate one or more asset data queries for the one or more assets via the time series database.

A computer program product comprising at least one non-transitory computer-readable storage medium having computer-readable program code portions stored therein, the computer-readable program code portions comprising an executable portion configured to:

• receive a data modification payload associated with a request to modify one or more portions of asset data stored in a time series database, wherein the asset data digitally represents one or more assets within an industrial environment;
• parse the data modification payload to identify a type of modification with respect to the asset data stored in the time series database;
• store the data modification payload in at least one of a first data cache configured for storing pending data modification payloads and a second data cache configured for processing data modification payloads;
• and
• in response to a determination that the data modification payload is stored in the second data cache, modify, based at least in part on the type of modification, the asset data stored in the time series database to facilitate one or more asset data queries for the one or more assets via the time series database.