Shortest distance to store
First Claim
Patent Images
1. A computer-implemented method for generating attribute tables and determining the shortest distance between a customer and a retail location, comprising:
- storing customer location data and retail location data in a distributed memory comprising a plurality of storage locations;
presenting a plurality of nodes, each node comprising a processor configured to perform an operation using the customer location data and/or retail location data;
receiving a request over a network to generate an attribute table corresponding to a business plan, wherein the business plan comprises at least one user input that describes a feature of the business plan;
generating, absent manual intervention from a user, at least one attribute corresponding to the at least one user input;
automatically generating, absent manual intervention from the user, an attribute table having at least one field corresponding to the at least one attribute, wherein the attribute table is built and populated while the business plan is in an approval process by automatically creating at least one join and at least one rollup related to the at least one field;
automatically generating a request for location attribute data corresponding to a customer location and a retail store location from dimension tables comprising location attribute data; and
automatically aggregating the requested location attribute data and determining the shortest distance between the customer location and the retail location;
wherein determining the shortest distance comprises;
performing a map command on the location attribute data for the customer location and the retail location;
calculating a distance between the customer location and the retail location using a haversines formula by determining availability of a first node proximate a first storage location from the plurality of storage locations of the attribute data corresponding to the customer location and a second node proximate a second storage location from the plurality of storage locations of the attribute data corresponding to the retail store location, and distributing the process of calculating distance to the first node or the second node as the nearest available node based on the availability determination by transmitting a node-specific request to only one of the first node or the second node to return the distance between the customer location and the retail location;
performing a shuffle command to order location data relative to distances between the customer location and the retail location;
reducing the ordered location data, the customer location data and the retail store location data for storage in a temporary table;
aggregating the reduced location data and populating the fields within the generated attribute table with the aggregated data; and
generating a report conveying aggregated attribute information corresponding to the business plan including the at least one user input that describes a feature of the business plan and the location attribute data.
2 Assignments
0 Petitions
Accused Products
Abstract
The present disclosure extends to methods, systems, and computer program products for generating attribute tables for holding and calculating attributes related to location and distance while a corresponding business plan is in an approval process.
-
Citations
16 Claims
-
1. A computer-implemented method for generating attribute tables and determining the shortest distance between a customer and a retail location, comprising:
-
storing customer location data and retail location data in a distributed memory comprising a plurality of storage locations; presenting a plurality of nodes, each node comprising a processor configured to perform an operation using the customer location data and/or retail location data; receiving a request over a network to generate an attribute table corresponding to a business plan, wherein the business plan comprises at least one user input that describes a feature of the business plan; generating, absent manual intervention from a user, at least one attribute corresponding to the at least one user input; automatically generating, absent manual intervention from the user, an attribute table having at least one field corresponding to the at least one attribute, wherein the attribute table is built and populated while the business plan is in an approval process by automatically creating at least one join and at least one rollup related to the at least one field; automatically generating a request for location attribute data corresponding to a customer location and a retail store location from dimension tables comprising location attribute data; and automatically aggregating the requested location attribute data and determining the shortest distance between the customer location and the retail location; wherein determining the shortest distance comprises; performing a map command on the location attribute data for the customer location and the retail location; calculating a distance between the customer location and the retail location using a haversines formula by determining availability of a first node proximate a first storage location from the plurality of storage locations of the attribute data corresponding to the customer location and a second node proximate a second storage location from the plurality of storage locations of the attribute data corresponding to the retail store location, and distributing the process of calculating distance to the first node or the second node as the nearest available node based on the availability determination by transmitting a node-specific request to only one of the first node or the second node to return the distance between the customer location and the retail location; performing a shuffle command to order location data relative to distances between the customer location and the retail location; reducing the ordered location data, the customer location data and the retail store location data for storage in a temporary table; aggregating the reduced location data and populating the fields within the generated attribute table with the aggregated data; and generating a report conveying aggregated attribute information corresponding to the business plan including the at least one user input that describes a feature of the business plan and the location attribute data. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A system comprising one or more processors and a computer-readable media comprising instructions causing the one or more processors to:
-
store customer location data and retail location data in a distributed memory comprising a plurality of storage locations; present a plurality of nodes, each node comprising a processor configured to perform an operation using the customer location data and/or retail location data; receive a request over a network to create an attribute table corresponding to a business plan, wherein the business plan comprises at least one user input that describes a feature of the business plan; generating, absent manual intervention from a user, at least one attribute corresponding to the at least one user input; automatically generate, absent manual intervention from the user, an attribute table having at least one field corresponding to the at least one attribute, wherein the attribute table is built and populated while the business plan is in an approval process by automatically creating at least one join and at least one rollup related to the at least one field; automatically generate a request for location attribute data corresponding to customer location and retail store location from dimension tables comprising location attribute data; automatically aggregate the requested location attribute data and determine the shortest distance between a customer and a retail location; wherein determining the shortest distance comprises; performing a map command on the location attribute data for the customer location and the retail location; calculating a distance between the customer location and the retail location using a haversines formula by determining availability of a first node proximate a first storage location from the plurality of storage locations of the attribute data corresponding to the customer location and a second node proximate a second storage location from the plurality of storage locations of the attribute data corresponding to the retail store location, and distributing the process of calculating distance to the first node or the second node as the nearest available node based on the availability determination by transmitting a node-specific request to only one of the first node or the second node to return the distance between the customer location and the retail location; performing a shuffle command to order the location data relative to distances between the customer location and the retail location; reducing the ordered location data, the customer location data and the retail store location data for storage in a temporary table; aggregate the reduced location data and populate the fields within the generated attribute table with the aggregated data; and automatically generate a report conveying the aggregated attribute information corresponding to the business plan including the at least one user input that describes a feature of the business plan and the location attribute data. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
Specification