ROUTING ORDER LOOKUPS
First Claim
1. At a computer system, the computer system including one or more processors and system memory, the computer system communicatively coupled to an order database for a retailer and to an order database cache, the order database containing order data for a plurality of customer orders, the order database cache containing order data synchronized from the order database, a method for routing an order lookup, the method comprising:
- receiving an order lookup from a requesting computer system, the order lookup indicating a database command type and indicating a portion of order data associated with a customer order;
a processor determining an appropriate data source to service the order lookup based on characteristics of the order lookup, including the indicated database command type and the indicated portion of order data, the appropriate data source selected from among the order database and the order database cache;
routing the order lookup to the appropriate data source in response to the determination;
receiving the indicated portion of order data back from the appropriate data source, the indicated portion of order data responsive to the lookup request; and
returning the indicated portion of order data to the requesting computer system.
2 Assignments
0 Petitions
Accused Products
Abstract
The present invention is generally directed to methods, systems, and computer program products for routing order lookups. Order data from order management system database is synchronized to an order cache. When an order lookup is received, a business layer determines if the cache can appropriately service the order lookup. If so, the business layer routes the order lookup to the cache. Otherwise, the business layer routes the order lookup to the order management system database. In some embodiments, order lookups configured to impact state of the order management system database (e.g., that write or change order data) are routed to the order management system database. In these same embodiments, order lookups configured to not impact state of the order management system database (e.g., that read order data) are routed to the cache.
-
Citations
20 Claims
-
1. At a computer system, the computer system including one or more processors and system memory, the computer system communicatively coupled to an order database for a retailer and to an order database cache, the order database containing order data for a plurality of customer orders, the order database cache containing order data synchronized from the order database, a method for routing an order lookup, the method comprising:
-
receiving an order lookup from a requesting computer system, the order lookup indicating a database command type and indicating a portion of order data associated with a customer order; a processor determining an appropriate data source to service the order lookup based on characteristics of the order lookup, including the indicated database command type and the indicated portion of order data, the appropriate data source selected from among the order database and the order database cache; routing the order lookup to the appropriate data source in response to the determination; receiving the indicated portion of order data back from the appropriate data source, the indicated portion of order data responsive to the lookup request; and returning the indicated portion of order data to the requesting computer system. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A computer program product for use at a computer system, the computer system communicatively coupled to an order database for a retailer and to an order database cache, the order database containing order data for a plurality of customer orders, the order database cache containing order data synchronized from the order database, the computer program product for implementing a method for routing an order lookup, the computer program product comprising one or more computer storage devices having stored thereon computer-executable instructions that, when executed at a processor, cause the computer system to perform the method, including the following:
-
receive an order lookup from a requesting computer system, the order lookup indicating a database command type and indicating a portion of order data associated with a customer order; determine an appropriate data source to service the order lookup based on characteristics of the order lookup, including the indicated database command type and the indicated portion of order data, the appropriate data source selected from among the order database and the order database cache; route the order lookup to the appropriate data source in response to the determination; receive the indicated portion of order data back from the appropriate data source, the indicated portion of order data responsive to the lookup request; and return the indicated portion of order data to the requesting computer system. - View Dependent Claims (12, 13, 14, 15)
-
-
16. A system, the system comprising:
-
one or more processors; system memory; an order database for a retailer, the order database containing order data for a plurality of customer orders; an order database cache, the order database cache containing order data synchronized from the order database; and one or more computer storage devices having stored thereon computer-executable instructions representing a business layer, the business layer configured to; receive an order lookup from a requesting computer system, the order lookup indicating a database command type and indicating a portion of order data associated with a customer order; determine an appropriate data source to service the order lookup based on characteristics of the order lookup, including the indicated database command type and the indicated portion of order data, the appropriate data source selected from among the order database and the order database cache; route the order lookup to the appropriate data source in response to the determination; receive the indicated portion of order data back from the appropriate data source, the indicated portion of order data responsive to the lookup request; and return the indicated portion of order data to the requesting computer system. - View Dependent Claims (17, 18, 19, 20)
-
Specification