US 12,450,529 B1
Computer systems and methods for determining environment impact indicators for food products
Lucas Gevaerd Cava, Curitiba (BR); Andrew Carlos Kondlatsch, Rio Negro (BR); Jeanny Zimeri Franz, Budd Lake, NJ (US); Meng Sun, Easton, PA (US); Qiaoxuan Zhou, East Hanover, NJ (US); and Hsiu Wei Yang, Atlantic Highlands, NJ (US)
Assigned to INTERCONTINENTAL GREAT BRANDS LLC, East Hanover, NJ (US)
Filed by INTERCONTINENTAL GREAT BRANDS LLC, East Hanover, NJ (US)
Filed on Oct. 31, 2024, as Appl. No. 18/933,591.
Int. Cl. G06Q 10/063 (2023.01); G01N 33/02 (2006.01); G06Q 50/04 (2012.01)
CPC G06Q 10/063 (2013.01) [G06Q 50/04 (2013.01); G01N 33/02 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A computing platform comprising:
at least one network interface;
at least one processor;
at least one non-transitory computer-readable medium; and
program instructions stored on the at least one non-transitory computer-readable medium that, when executed by the at least one processor, cause the computing platform to:
detect a trigger event for determining environmental-impact indicators for product-level resources across multiple different food products;
in response to detecting the trigger event, invoke a data pipeline that is configured to determine environmental-impact indicators for product-level resources across multiple different food products rather than for an individual food product, wherein, when invoked, the data pipeline functions to:
extract a first source dataset from a first database table containing data about food products, wherein the first source dataset comprises (i) a set of rows representing data records for a given set of multiple different food products and (ii) a set of columns representing data variables that, for each respective row in the set of rows, provide respective information about a respective food product represented by the respective row;
extract a second source dataset from a second database table containing data about manufacturing processes for food products, wherein the second source dataset comprises (i) a set of rows representing data records for a given set of multiple different manufacturing processes and (ii) a set of columns representing data variables that, for each respective row in the set of rows, provide respective information about a respective manufacturing process represented by the respective row;
merge the first source dataset and the second source dataset into a first merged dataset by performing a left join operation using the first source dataset as a left table, the second source dataset as a right table, and a manufacturing-process identifier as a key for joining the first and second source datasets, wherein the first merged dataset comprises (i) a set of rows representing data records for the given set of multiple different food products and (ii) a set of columns representing data variables that, for each respective row in the set of rows, provide respective information about a respective food product represented by the respective row, wherein at least a given subset of columns in the set of columns represent data variables that each indicates an amount of a given type of resource that is used or produced by a respective manufacturing process used to manufacture the respective food product represented by the respective row;
update the first merged dataset by performing an unpivot operation on the given subset of columns in the set of columns and thereby generate an updated first merged dataset that comprises (i) an updated set of rows representing data records for a given set of multiple different product-level resources that are each defined by a respective combination of food product and resource type, and (ii) an updated set of columns representing data variables that, for each respective row in the set of rows, provide respective information about a respective product-level resource represented by the respective row;
extract a third source dataset from a third database table containing data about resource types that are used or produced by manufacturing processes for food products, wherein the third source dataset comprises (i) a set of rows representing data records for a given set of multiple different resource types and (ii) a set of columns representing data variables that, for each respective row in the set of rows, provide respective information about a respective resource type represented by the respective row;
extract a fourth source dataset from a fourth database table containing data about plants where food products are manufactured, wherein the fourth source dataset comprises (i) a set of rows representing data records for a given set of multiple different plants and (ii) a set of columns representing data variables that, for each respective row in the set of rows, provide respective information about a respective plant represented by the respective row;
extract a fifth source dataset from a fifth database table containing environmental-impact values for types of resources, wherein the third source dataset comprises (i) a set of rows representing data records for a given set of multiple different resource types and (ii) a set of columns representing data variables that, for each respective row in the set of rows, provide respective environmental-impact values for a respective resource type represented by the respective row;
merge the updated first merged dataset, the third source dataset, the fourth source dataset, and the fifth source dataset into a second merged dataset by (i) producing a first intermediate dataset by performing a first left join operation using the first merged dataset as a first left table, the third source dataset as a first right table, and a resource-type identifier as a first key for joining the first merged dataset and the third source dataset, (ii) producing a second intermediate dataset by performing a second left join operation using the first intermediate dataset as a second left table, the fourth source dataset as a second right table, and a plant identifier as a second key for joining the first intermediate dataset and the fourth source dataset, (iii) producing the second merged dataset by performing a third left join operation using the second intermediate dataset as a third left table, the fifth source dataset as a third right table, and an environmental-impact-contributor identifier as a third key for joining the second intermediate dataset and the fifth source dataset, wherein the second merged dataset comprises (i) a set of rows representing data records for the given set of product-level resources and (ii) a set of columns representing data variables that, for each respective row in the set of rows, provide respective information about a respective product-level resource represented by the respective row; and
determine a respective group of environmental-impact indicators for each respective product-level resource in the given set using the second merged dataset;
store the respective group of environmental-impact indicators for each respective product-level resource in the given set into a target database table; and
utilize the target database table to service network-based requests from users for visualizations of environmental-impact indicators for food products from the given set of multiple different food products.