Deriving and Presenting Real Time Marketable Content by Efficiently Deciphering Complex Data of Large Dynamic E-Commerce Catalogs

A computer implemented method for asynchronously generating product's prices in a simple format and structure directly usable by websites, with each price matching certain e-commerce storefront shopping conditions, the method comprising:

• Deciphering, by a processor, complex product prices and price lists with their inheritance relationships from the e-commerce system's central database;
• Reformatting and restructuring, by a processor, all the data as copies of original data.
• Writing, by a processor, the reformatted and restructured product prices into an intermediate data storage, the intermediate data storage also an event store recording the series of events for auditing purposes and the product prices are stored in the intermediate storage for delta detection and deduplication to minimize further unnecessary operations;
• Distributing, by a processor, pre-calculation of a large number of raw product prices among many computational units in parallel to quickly get each result of a combination of certain storefront shopping conditions and writing the results into a search engine;
• and
• Querying, by a processor, the search engine as web services to retrieve product prices matching certain e-commerce storefront shopping conditions input by a user operating on an online storefront.

A computer implemented method for asynchronously generating merchandising discount offer instances in a simple format and structure that can be analyzed by real time multi-dimensional filtering and grouping to determine the best discount offer instance to be applied to a product based on many dynamic storefront shopping conditions at different points in time, the method comprising:

• Deciphering, by a processor, complex discount offers with their primary and secondary instances from the e-commerce system's central database;
• Reformatting, by a processor and restructuring all that data as copies of original data.
• Writing, by a processor, the reformatted and restructured discount offers with their primary and secondary instances into an intermediate data storage, the intermediate data synchronizing the data that has been written to it to another same type of data storage that is physically located in close network proximity as the catalog applications for deriving product's best discount.
• Distributing, by a processor, located in close network proximity as the catalog application that hosts the catalog services for e-commerce websites, distributing real time arbitrations of large number of raw discount offer instances among many computational units in parallel to quickly to get the result for a given combination of multiple storefront shopping conditions at a point in time;
• Accessing, by a processor operatively connected to a powerful distributed computational engine to, a service application comprising product related discount business logic and rules to get product prices with their best discount and discounting information for presentation on online storefronts.

A distributed computing system providing product attributes, pricing and merchandising of products in a request, the system comprising:

• An orchestration engine with memory and processor and a software module stored in memory with executable instructions that when executed by the processor cause the processor to invoke a product data web service API hosted by a product data service application and a product price web service API hosted by the product pricing service application concurrently in parallel, invoking the product best discount web service API hosted by a product discounting service application.
• An aggregation engine with memory and processor and a software module stored in memory with executable instructions that when executed by the processor cause the processor to combine the results from multiple web service invocations together into one single payload, such payload stored into a cache with a time to live.
• The service facade hosting coarse-grained catalog services, each service with memory and processor and a software module stored in memory with executable instructions that when executed by the processor cause the processor to invoke a set of application programming interfaces of these services when called by another client, whereby the client is an e-commerce website or web application, and accessing the cache to get the response payload based on the request parameter with the value or values of the request parameter as the composite key and, if not finding the response payload, accessing the aggregation engine to get the response payload.