Archiving and querying data updates associated with an electronic catalog system

Patent metadata

Field	Value
Publication number	US-2016188652-A1
Application number	US-201615060289-A
Country	US
Kind code	A1
Filing date	Mar 3, 2016
Priority date	Oct 20, 2011
Publication date	Jun 30, 2016
Grant date	—

Abstract

Systems and methods are provided for archiving and querying data updates received or generated by an update processing system associated with an electronic catalog. In some embodiments, the system may receive a query associated with item data updates in a first format. The system may monitor a status of the query and may store data associated with the status. In some embodiments, the system may translate the query from the first format into a second format that is suitable or appropriate for use by an item data update data store. The update data store may include objects having records associated with one or more items, and the system may access the item update data store to retrieve information in response to the query. The system may further generate and provide query results responsive to the query and may update the status of the query.

First claim

What is claimed is:

1 . A computer-implemented method for servicing queries, said method executed on a computing environment, the method comprising:
under control of one or more configured computing devices, receiving a query from an update processing system in a first format, wherein the query is associated with item data updates; initializing a status associated with the query; creating a query request store to store the status associated with the query; translating the query received in the first format into a second format appropriate to an item data update data store; accessing the item update data store to retrieve information in response to the query, wherein the item update data store comprises objects having records associated with one or more items; processing the query to generate query results; updating the status associated with the query in the query request store; and providing the query results in response to the query.

2 . The method of claim 1 , wherein receiving the query from the update processing system in the first format comprises receiving the query as a user input.

3 . The method of claim 1 , wherein:
the first format is a format suitable for querying a hierarchical structure; and the second format is a format suitable for performing a distributed table scan.

4 . The method of claim 1 , wherein accessing the item update data store to retrieve information in response to the query comprises retrieving one or more objects.

5 . The method of claim 1 , wherein processing the query comprises applying a filter to the retrieved information.

6 . The method of claim 1 , wherein the query comprises one or more historical attributes of an item.

7 . The method of claim 1 further comprising persisting item data updates and metadata associated with records of items.

8 . The method of claim 7 further comprising:
identifying, in the query request store, a record of an item associated with the query; and
updating, in the query request store, metadata associated with the record of the item to reflect reception of the query.

9 . The method of claim 1 , wherein initializing the status associated with the query further comprises initializing a cluster of computing devices.

10 . The method of claim 9 further comprises archiving updates to an item by an item data update storage device,
wherein processing the query comprises processing the query by the cluster of computing devices, and
wherein processing the query occurs in parallel to archiving the updates to the item.

11 . The method of claim 9 , wherein updating the status associated with the query comprises updating the status associated with the query with the cluster of computing devices.

12 . A system for servicing queries, the system comprising:
an item data update store configured to store information regarding item data updates; and an item data update storage server comprising a memory and a processor in communication with the memory, wherein the processor is configured with process-executable instructions stored in the memory to perform operations comprising:
receiving a query in a first format, wherein the query is associated with item data updates;
storing data associated with a status of the query received;
monitoring the status of the query received;
translating the query received in the first format into a second format appropriate to the item data update data store;
accessing the item update data store to retrieve information in response to the query, wherein the item update data store comprises objects having records associated with one or more items;
generating query results; and
providing the query results in response to the query.

13 . The system of claim 12 , wherein the status of the query received comprises at least one of: initialized, in progress, completed, or previously completed.

14 . The system of claim 12 , wherein the item data update storage server:
archives updates of an item; and generates the query results in parallel with archiving updates to the item with the item data update storage device.

15 . The system of claim 12 , wherein the item data update storage server applies a filter to the query results.

16 . A non-transitory, computer-readable medium having stored thereon computer-executable software instructions configured to cause a processor of a computing device to perform operations comprising:
receiving a query in a first format, wherein the query is associated with item data updates; initializing a status associated with the query; storing the status associated with the query in a query request store; translating the query received in the first format into a second format; retrieving information in response to the query; generating query results based at least in part on the query; and updating the status associated with the query in the query request store.

17 . The non-transitory, computer-readable medium of claim 16 , wherein:
the first format is a format suitable for querying a hierarchical structure; and the second format is a format suitable for performing a distributed table scan.

18 . The non-transitory, computer-readable medium of claim 16 , wherein generating the query results comprises applying a filter to the query results.

19 . The non-transitory, computer-readable medium of claim 16 , wherein applying the filter to the query results comprises deleting records from one or more objects.

20 . The non-transitory, computer-readable medium of claim 16 , wherein applying the filter to the query results comprises performing de-duplication of the query results.

Assignees

• Amazon Tech Inc

Inventors

• Goo Almann T
• Selberg Erik W
• Suver Chris A

Classifications

• G06F17/30867

  Physics · mapped topic

• G06F17/30368 Primary

  Physics · mapped topic

• G06F17/30477

  Physics · mapped topic

• G06F16/113 Primary

  Details of archiving (lifecycle management in storage systems G06F3/0649; point-in-time backing up or restoration of persistent data G06F11/1446) · CPC title

• G06F16/9535

  Search customisation based on user profiles and personalisation · CPC title