IP Library › Granted Patent US 12,014,322
Granted Patent B2
US 12,014,322 · App. 17/514,275 · Granted Jun 18, 2024

Updating and validating data stored in a database

Inventors: Avid Ghamsari (Frisco, TX); Qiaochu Tang (The Colony, TX); Geoffrey Dagley (Mckinney, TX)
Assignee: Capital One Services, LLC
G06Q10/087G06Q30/0201G06Q30/0631
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 12,014,322
App. No.
17/514,275
Granted
Jun 18, 2024
Kind
B2
Abstract

Disclosed herein are system, method, and computer program product embodiments for validating and updating data in a database. In an embodiment, a server may receive an HTML, file including content of a third-party website controlled by a third party from a web-component. The content may include a first set of data associated with an item. The web-component may be configured to extract the content of the third party website and generate the HTML file in response to executing code embedded in the third-party website. The server may retrieve a second set of data associated with the item available at the third-party from the database. The server may identify a difference between the mapped first set of data and the second set of data and execute an action in the database to update to the second set of data.

Claims (41)

1. A computer-implemented method comprising:

receiving, by one or more computing devices, an HTML file including content of a third-party website controlled by a third party from a web-component, the content including a first set of data associated with an item and a geographic location of the third-party, wherein the web-component executes a web-scraping algorithm to extract the content of the third-party website and generate the HTML file in response to executing code embedded in the third-party website, and wherein a new HTML file is received each instance the third-party website is loaded on a user device;

mapping, by the one or more computing devices, the first set of data associated with the item to a set of fields of a database;

retrieving, by the one or more computing devices, a second set of data associated with the item available at the third-party website from the database;

identifying, by the one or more computing devices, a difference between the mapped first set of data and the second set of data based on a comparison of the mapped first set of data and the second set of data;

executing, by the one or more computing devices, an action in the database to update the second set of data based on the difference between the mapped first set of data and the second set of data;

identifying, by the one or more computing devices, a trend attribute associated with the item or the geographic location of the third party based on the first set of data;

identifying, by the one or more computing devices, a new item with similar characteristics as the item in response to identifying the trend attribute associated with the item or the geographic location of the third party; and

rendering, by the one or more computing devices, information about the new item on a different website in response to a user located in the geographic location of the third-party interacting with the different website.

2. The computer-implemented method of claim 1 , further comprising:

storing, by the one or more computing devices, a plurality of data sets associated with the item, including the first set of data received from the third-party website, over a period of time; and

identifying, by the one or more computing devices, the trend attribute associated with the item or the third party within the period of time based on the plurality of data sets.

3. The computer-implemented method of claim 1 , further comprising transmitting, by the one or more computing devices, an alert to the third party to confirm the difference between the first set of data and the second set of data.

4. The computer-implemented method of claim 1 , wherein the difference corresponds to a value in at least one field of the set of fields of the database.

5. A system comprising:

a memory;

a processor coupled to the memory, the processor configured to:

receive an HTML file including content of a third-party website controlled by a third party from a web-component, the content including a first set of data associated with an item and a geographic location of the third party, wherein the web-component executes a web-scraping algorithm to extract the content of the third party website and generate the HTML file in response to executing code embedded in the third-party website, and wherein a new HTML file is received each instance the third-party website is loaded on a user device;

map the first set of data associated with the item to a set of fields of a database; retrieve a second set of data associated with the item available at the third-party website from the database;

identify a difference between the mapped first set of data and the second set of data based on a comparison of the mapped first set of data and the second set of data;

execute an action in the database to update the second set of data based on the difference between the mapped first set of data and the second set of datai identify a trend attribute associated with the item or the geographic location of the third party based on the first set of data;

identify a new item with similar characteristics as the item in response to identifying the trend attribute associated with the item or the geographic location of the third party; and

render information about the new item on a different website in response to a user located in the geographic location of the third party interacting with the different website.

6. The system of claim 5 , the processor further configured to:

store a plurality of data sets associated with the item, including the first set of data received from the third-party website, over a period of time; and

identify the trend attribute associated with the item or the third party within the period of time based on the plurality of data sets.

7. The system of claim 5 , the processor further configured to transmit an alert to the third party to confirm the difference between the first set of data and the second set of data.

8. The system of claim 5 , wherein the difference corresponds to a value in at least one field of the set of fields of the database.

9. A non-transitory computer-readable medium having instructions stored thereon, execution of which, by one or more processors of a device, causes the one or more processors to perform operations comprising:

receiving an HTML file including content of a third-party website controlled by a third party from a web-component, the content including a first set of data associated with an item and a geographic location of the third party, wherein the web-component executes a web-scraping algorithm to extract the content of the third party website and generate the HTML file in response to executing code embedded in the third-party website, and wherein a new HTML file is received each instance the third-party website is loaded on a user device;

mapping the first set of data associated with the item to a set of fields of a database;

retrieving a second set of data associated with the item available at the third-party website from the database;

identifying a difference between the mapped first set of data and the second set of data based on a comparison of the mapped first set of data and the second set of data;

executing an action in the database to update the second set of data based on the difference between the mapped first set of data and the second set of data;

identifying a trend attribute associated with the item or the geographic location of the third party based on the first set of data;

identifying a new item with similar characteristics as the item in response to identifying the trend attribute associated with the item or the geographic location of the third party; and

rendering information about the new item on a different website in response to a user located in the geographic location of the third party interacting with the different website.

10. The non-transitory computer-readable medium of claim 9 , the operations further comprising:

storing a plurality of data sets associated with the item, including the first set of data received from the third-party website, over a period of time; and

identifying the trend attribute associated with the item or the third party within the period of time based on the plurality of data sets.

11. The non-transitory computer-readable medium of claim 9 , the operations further comprising transmitting an alert to the third party to confirm the difference between the first set of data and the second set of data.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Oct 29, 2021
From: GHAMSARI, AVID; TANG, QIAOCHU; DAGLEY, GEOFFREY
To: CAPITAL ONE SERVICES, LLC
Reel/Frame 057961/0525 →
Continuity (1)
Related Publication 20230132457A1 · May 4, 2023