DATA IMPORTER FOR A SALES PROSPECTOR

• US 20100114992A1
• Filed: 06/18/2009
• Published: 05/06/2010
• Est. Priority Date: 11/03/2008
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: CAMPOS, Marcos, MOZES, Ari, DANKO, Krisztian Z., STENGARD, Peter J., KIM, Jooyoung John, CASAS, Francisco V.
• Granted Patent: US 9,152,972 B2
• Time in Patent Office: Days
• US Class Current: 707/809
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/902 using more than one table in sequence, i.e. systems with three or more layers
• CPC Class Codes: G06Q 10/067 Enterprise or organisation modelling
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G06Q 30/0201 Market modelling; Market analysis; Collecting market data
• CPC Class Codes: G06Q 30/0202 Market predictions or forecasting for commercial activities
• CPC Class Codes: G06Q 30/0204 Market segmentation

Abstract

A data importer for a sales prospecting system imports one or more data tables that each may include one or more records. The data importer first (a) imports a data table into an intermediate table. The data importer then (b) determines if the imported data table depends on another data table and moves one or more records from the imported data table that have no missing dependencies to a corresponding working table; and (c) determines a set of previously imported data tables that refer to the imported data table. The data importer then, for each previously imported data table, repeats (b) and (c) above.

Claims

1. A computer-readable medium having instructions stored thereon that, when executed by a processor, cause the processor to import one or more data tables that each comprise one or more records, the instructions comprising:

(a) importing a first data table into a first intermediate table;

(b) if the first data table depends on a second data table, moving one or more first records from the first data table that have no missing dependencies to a first corresponding working table;

(c) determining a second set of previously imported data tables that refer to the first data table; and

for each of the second set of previously imported data tables, designating that table as the first data table and repeating (b) and (c).

2. The computer-readable medium of claim 1, further comprising:

repeating (a)-(c) for each table to be imported.

3. The computer-readable medium of claim 1, wherein (b) comprises reviewing a stored dependency tree.

4. The computer-readable medium of claim 1, where the first data table is one of:

a customer data table, a product data table;

a product category data table;

an order data table; and

an order lines data table.

5. The computer-readable medium of claim 1, wherein the customer data table includes at least one of:

a customer name record;

a customer location record;

an industry record;

a headquarter country record;

a public corporation status record;

an importer status record;

an exporter status record, a number of locations record;

a number of employees record; and

an annual revenue record.

6. The computer-readable medium of claim 4, wherein the product data table refers to the product category data table.

7. The computer-readable medium of claim 4, wherein the order data tables refers to the product data table.

8. The computer-readable medium of claim 4, wherein the customer data table refers to the product data table.

9. The computer-readable medium of claim 1, wherein a plurality of data tables are imported out of referential order.

10. A computer-implemented method for importing a data table including a plurality of records, comprising:

(a) importing a first data table into a first intermediate table;

(b) if the first data table depends on a second data table, moving one or more first records from the first data table that have no missing dependencies to a first corresponding working table;

(c) determining a second set of previously imported data tables that refer to the first data table; and

for each of the second set of previously imported data tables, designating that table as the first data table and repeating (b) and (c).

11. The computer-implemented method of claim 10, further comprising:

repeating (a)-(c) for each table to be imported.

12. The computer-implemented method of claim 10, wherein (b) comprises reviewing a stored dependency tree.

13. The computer-implemented method of claim 10, where the first data table is one of:

a customer data table;

a product data table;

a product category data table; and

order data table; and

an order lines data table.

14. A data import processor, comprising:

a plurality of intermediate tables;

a plurality of working tables corresponding to the plurality of intermediate tables; and

a data importer that imports a first data table including a plurality of records, stores the first data table in one of the plurality of intermediate tables, determines a referential integrity of each of the plurality of records in the first data table, and moves each of the plurality of records of the first data table from the intermediate table to a corresponding working table after the referential integrity has been determined.

15. The data import processor of claim 14, wherein the data importer imports a plurality of data tables, each of the plurality of tables referring to at least one other data table.