Data importer for a sales prospector

• US 9,152,972 B2
• Filed: 06/18/2009
• Issued: 10/06/2015
• Est. Priority Date: 11/03/2008
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Casas, Francisco V., Kim, Jooyoung John, Danko, Krisztian Z., Stengard, Peter J., Mozes, Ari, Campos, Marcos
• Primary Examiner(s): Shanmugasundaram, Kannan
• Application Number:
  US12/486,933
• Publication Number:
  US 20100114992A1
• Time in Patent Office: 2,301 Days
• Field of Search: 707/703, 707999001-999005, 707/792
• US Class Current: 1/1
• 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 non-transitory 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 into corresponding intermediate tables and working tables, the importing comprising:

receiving a selection of data tables from a database to import, wherein dependencies among the selected data tables are according to a dependency tree comprising at least two branches connecting a first group of at least three data tables with three different corresponding record types, wherein each branch of the dependency tree that connects a second group of two data tables with two different corresponding record types corresponds to all attributes that are in common between the two different corresponding record types;

importing the selected data tables into one or more intermediate tables;

(a) for a first data table, if the first data table does not depend on another data table as defined by the dependency tree, moving the first data table to a first working table;

(b) if the first data table depends on a second data table as defined by the dependency tree, determining which records of the first data table depend only on records that have already been imported from the database into the intermediate tables or the working tables, and moving to the first working table the determined records, wherein the first data table comprises a plurality of first data table records, and the determined records in addition to remaining records comprises the plurality of first data table records, wherein the remaining records remain in a first intermediate table when the determined records are moved to the first working table;

(c) determining a next data table that has been imported to a next intermediate table and that depends on the first data table as defined by the dependency tree; and

assigning the next data table as the first data table and repeating (b) and (c);

wherein (a)-(c) are executed at least once before all of the data tables in the dependency tree are imported into the one or more intermediate tables.

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, 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;

or an order lines data table.

4. 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;

or an annual revenue record.

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

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

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

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

9. A computer-implemented method for importing a data table including a plurality of records into corresponding intermediate tables and working tables, the method comprising:

receiving a selection of data tables from a database to import, wherein dependencies among the selected data tables are according to a dependency tree comprising at least two branches connecting a first group of at least three data tables with three different corresponding record types, wherein each branch of the dependency tree that connects a second group of two data tables with two different corresponding record types corresponds to all attributes that are in common between the two different corresponding record types;

importing the selected data tables into one or more intermediate tables;

(a) for a first data table, if the first data table does not depend on another data table as defined by the dependency tree, moving the first data table to a first working table;

(b) if the first data table depends on a second data table as defined by the dependency tree, determining which records of the first data table depend only on records that have already been imported from the database into the intermediate tables or the working tables, and moving to the first working table the determined records, wherein the first data table comprises a plurality of first data table records, and the determined records in addition to remaining records comprises the plurality of first data table records, wherein the remaining records remain in a first intermediate table when the determined records are moved to the first working table;

(c) determining a next data table that has been imported to a next intermediate table and that depends on the first data table as defined by the dependency tree; and

assigning the next data table as the first data table and repeating (b) and (c);

wherein (a)-(c) are executed at least once before all of the data tables in the dependency tree are imported into the one or more intermediate tables.

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

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

11. The computer-implemented method of claim 9, 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;

or an order lines data table.

12. The computer-implemented method of claim 9, wherein a plurality of data tables are imported out of referential order.

13. A data import processor for importing one or more selected data tables that each comprise one or more records from a database, the processor comprising:

a plurality of intermediate tables;

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

means for importing the selected data tables into one or more intermediate tables, wherein dependencies among the selected data tables are according to a dependency tree comprising at least two branches connecting a first group of at least three data tables with three different corresponding record types, wherein each branch of the dependency tree that connects a second group of two data tables with two different corresponding record types corresponds to all attributes that are in common between the two different corresponding record types;

(a) for a first data table, if the first data table does not depend on another data table as defined by the dependency tree, means for moving the first data table to a first working table;

(b) if the first data table depends on a second data table as defined by the dependency tree, means for determining which records of the first data table depend only on records that have been already been imported from the database into the intermediate tables or the working tables, and means for moving to the first working table the determined records, wherein the first data table comprises a plurality of first data table records, and the determined records in addition to remaining records comprises the plurality of first data table records, wherein the remaining records remain in a first intermediate table when the determined records are moved to the first working table;

(c) means for determining a next data table that has been imported to a next intermediate table and that depends on the first data table as defined by the dependency tree; and

means for assigning the next data table as the first data table and repeating (b) and (c);

wherein (a)-(c) are executed at least once before all of the data tables in the dependency tree are imported into the one or more intermediate tables.

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

15. The data import processor of claim 13, wherein a plurality of data tables are imported out of referential order.