CONTENT EXTRACTOR

• US 20120016856A1
• Filed: 08/18/2010
• Published: 01/19/2012
• Est. Priority Date: 07/15/2010
• Status: Abandoned Application

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: Google Inc. (Alphabet Inc.)
• Inventors: Gandhi, Kawaljit, Lee, Paul
• Application Number:
  US12/859,022
• Publication Number:
  US 20120016856A1
• Time in Patent Office: Days
• US Class Current: 707/705
• CPC Class Codes: G06Q 20/20 Point-of-sale [POS] network systems
• CPC Class Codes: G06Q 20/202 Interconnection or interaction of plural electronic cash registers [ECR] or to host computer, e.g. network details, transfer of information from host to ECR or from ECR to ECR
• CPC Class Codes: G06Q 20/204 comprising interface for record bearing medium or carrier for electronic funds transfer or payment credit
• CPC Class Codes: G06Q 20/208 Input by product or record sensing, e.g. weighing or scanner processing
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions

Abstract

Systems and methods for extracting data related to product sales and businesses that sell products are disclosed. The method may include obtaining a database connection parameter and a remote system connection parameter. The method also may include establishing a connection with a database using the database connection parameter, where the database has a table with a table attribute. Additionally, the method may include obtaining a mapping of one of the table attributes to a predefined attribute so that data may be extracted from the database using the mapping. The method may further include establishing a connection with a remote system using the remote system connection parameter and transmitting the extracted data to the remote system.

Claims

1. A computer-implemented method for extracting data, comprising:

receiving a database connection parameter and a remote system connection parameter;

establishing a connection with a database using the database connection parameter, the database comprising at least one table having at least one table attribute;

receiving a mapping of one of the at least one table attributes to at least one predefined attribute;

extracting data from the database based on the mapping;

establishing a connection with a remote system using the remote system connection parameter; and

transmitting the extracted data to the remote system,

wherein the method is implemented by a software module in at least one computer system that comprises instructions stored in a machine-readable medium and a processor that executes the instructions.

2. The method of claim 1, wherein the extracted data comprises at least one of product sales data and commercial retailer data.

3. The method of claim 1, wherein the extracted data comprises product inventory data.

4. The method of claim 1, wherein the remote system comprises a remote storage system and a remote computer.

5. The method of claim 1, wherein the steps of extracting data from the database and transmitting the extracted data to the remote system occur in response to a predetermined event.

6. The method of claim 5, wherein the predetermined event is a time of day.

7. The method of claim 5, wherein the predetermined event is an updating of the at least one table.

8. The method of claim 5, wherein the predetermined event is external to the database.

9. The method of claim 5, wherein the extracted data comprises at least one of product sales data and commercial retailer data.

10. The method of claim 1, wherein the database is a remote database.

11. The method of claim 1, wherein the database comprises multiple databases.

12. The method of claim 1, further comprising means for processing the extracted data.

13. The method of claim 1, further comprising:

auto-generating, based on the extracted data, data corresponding to at least one predefined attribute for which a mapping has not been obtained; and

transmitting the auto-generated data to the remote system along with the extracted data.

14. A data extraction system, comprising:

a storage resource;

a network module;

a database comprising a table having one or more table attributes;

a processor communicatively coupled to the storage resource and the network module, wherein the processor executes application code instructions that are stored in the storage resource and that cause the data extraction system to;

receive a database connection parameter, a remote system connection parameter, and a mapping of at least one table attribute to a predefined attribute;

establish a connection with the database using the database connection parameter;

extract data from the database based on the mapping;

process the extracted data;

establish, via the network module, a connection with a remote system using the remote system connection parameter; and

transmit, via the network module, the processed data to the remote system.

15. The data extraction system of claim 14, wherein the application code instructions further cause the data extraction system to:

receive a schedule for extracting data from the database; and

extract, process, and transmit data from the database to the remote system according to the received schedule.

16. The data extraction system of claim 15, wherein the schedule is one of a predetermined time of day, a predetermined day, instantly in response to a database update event, and in response to an event that is external to the database.

17. A data extraction system, comprising:

a storage resource;

a network module;

a display;

a database comprising a table having one or more table attributes;

a processor communicatively coupled to the storage resource and the network module, wherein the processor executes application code instructions that are stored in the storage resource and that cause the data extraction system to;

provide, on the display, at least one graphical user interface comprising inputs for receiving a database connection parameter, a remote system connection parameter, a one-to-one mapping of at least one table attribute to a predefined attribute, and a schedule for extracting data from the database;

receive the database connection parameter, the remote system connection parameter, the mapping, and the schedule;

establish, in accordance with the schedule, a connection with the database using the database connection parameter;

extract, in accordance with the schedule, data from the database using the mapping;

process, in accordance with the schedule, the extracted data;

establish, in accordance with the schedule and via the network module, a connection with a remote system using the remote system connection parameter; and

transmit, in accordance with the schedule and via the network module, the processed data to the remote system.

18. A data extraction system, comprising:

one or more processors for executing programs;

a network interface for receiving and transmitting data;

a storage resource containing one or more data objects, each data object having one or more attributes; and

a data extraction engine executable by the one or more processors, the engine comprising;

instructions for obtaining a mapping of the one or more attributes to one or more predefined attributes;

instructions for extracting data from the storage resource based on the mapping; and

instructions for transmitting the data to a remote system via the network interface.

19. A computer program product for use in conjunction with a computer system and a database comprising a table having one or more table attributes, the computer program product comprising a computer readable storage medium and a computer program mechanism embedded therein, the computer program mechanism comprising:

instructions for receiving a database connection parameter, a remote system connection parameter, and a mapping of at least one table attribute to a predefined attribute;

instructions for establishing a connection with the database using the database connection parameter;

instructions for extracting data from the database based on the mapping;

instructions for establishing a connection with a remote system using the remote system connection parameter; and

instructions for transmitting the processed data to the remote system.

20. A computer program product for use in conjunction with a computer system and a database comprising data objects having one or more attributes, the computer program product comprising a computer readable storage medium and a computer program mechanism embedded therein, the computer program mechanism comprising:

instructions for receiving a mapping of at least one data object attribute to a predefined attribute;

instructions for extracting data from the database based on the mapping; and

instructions for transmitting the extracted data to a remote system.

21. A data extraction system, comprising:

a storage resource;

a network module;

a database comprising a table having one or more table attributes;

a processor communicatively coupled to the storage resource and the network module, wherein the processor executes application code instructions that are stored in the storage resource; and

a means for extracting data from the database.