Data importer for a sales prospector

Patent metadata

Field	Value
Publication number	US-9773030-B2
Application number	US-201514841844-A
Country	US
Kind code	B2
Filing date	Sep 1, 2015
Priority date	Nov 3, 2008
Publication date	Sep 26, 2017
Grant date	Sep 26, 2017

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.

First claim

What is claimed is:

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 secondary tables, the processor:
importing, from a database, into one or more intermediate tables, particular data tables with corresponding record types, wherein the particular data tables have dependencies specified in a dependency tree that comprises branches connecting the particular data tables, wherein a data table depends on another data table when a record of the data table depends on a record of another data table;
determining whether the dependency tree specifies that a first data table of the particular data tables depends on another data table in the dependency tree;
in response to a determination that the dependency tree specifies that the first data table depends on another data table in the dependency tree, moving, to a first working table of the secondary tables, records of the first data table that depend only on records that have already been imported from the database into the secondary tables, wherein the first data table includes further records in addition to the records moved to the first working table;
determining whether the dependency tree specifies that a second data table of the particular data tables depends on the first data table; and
in response to a determination that the dependency tree specifies that the second data table depends on the first data table, moving, to a second working table of the secondary tables, records of the second data table that depend only on records that have already been imported from the database into the secondary tables.

2. The computer-readable medium of claim 1 , wherein the secondary tables comprise intermediate tables and working tables, and wherein the working tables comprise the first working table and the second working table.

3. The computer-readable medium of claim 1 , wherein the moving of the records of the first data table and the moving of the records of the second data table are performed at least once before all of the data tables specified in the dependency tree are imported into one or more intermediate tables of the secondary tables.

4. The computer-readable medium of claim 1 , wherein the first data table comprises a plurality of first data table records, and wherein moving the records of the first data table comprises:
moving the plurality of first data table records to a first intermediate table of the secondary tables; and
moving the plurality of first data table records from the first intermediate table to the first working table.

5. The computer-readable medium of claim 1 , wherein each branch of the dependency tree that connects a group of data tables with particular corresponding record types corresponds to all attributes that are in common between the particular corresponding record types.

6. The computer-readable medium of claim 1 , wherein the branches connecting the particular data tables include two branches that connect at least three data tables with three different corresponding record types.

7. The computer-readable medium of claim 1 , wherein the instructions, when executed by the processor, cause the processor to perform operations comprising:
determining whether the dependency tree specifies that a third data table of the particular data tables depends on another data table; and
in response to a determination that the dependency tree does not specify that the third data table depends on another data table, moving records of the third data table to a third working table of the secondary tables.

8. A method for importing one or more data tables that each comprise one or more records into corresponding secondary tables, comprising:
importing, from a database, into one or more intermediate tables, particular data tables with corresponding record types, wherein the particular data tables have dependencies specified in a dependency tree that comprises branches connecting the particular data tables, wherein a data table depends on another data table when a record of the data table depends on a record of another data table;
determining whether the dependency tree specifies that a first data table of the particular data tables depends on another data table in the dependency tree;
in response to a determination that the dependency tree specifies that the first data table depends on another data table in the dependency tree, moving, to a first working table of the secondary tables, records of the first data table that depend only on records that have already been imported from the database into the secondary tables, wherein the first data table includes further records in addition to the records moved to the first working table;
determining whether the dependency tree specifies that a second data table of the particular data tables depends on the first data table; and
in response to a determination that the dependency tree specifies that the second data table depends on the first data table, moving, to a second working table of the secondary tables, records of the second data table that depend only on records that have already been imported from the database into the secondary tables.

9. The method of claim 8 , wherein the secondary tables comprise intermediate tables and working tables, and wherein the working tables comprise the first working table and the second working table.

10. The method of claim 8 , wherein the moving of the records of the first data table and the moving of the records of the second data table are performed at least once before all of the data tables specified in the dependency tree are imported into one or more intermediate tables of the secondary tables.

11. The method of claim 8 , wherein the first data table comprises a plurality of first data table records, and wherein moving the records of the first data table comprises:
moving the plurality of first data table records to a first intermediate table of the secondary tables; and
moving the plurality of first data table records from the first intermediate table to the first working table.

12. The method of claim 8 , wherein each branch of the dependency tree that connects a group of data tables with particular corresponding record types corresponds to all attributes that are in common between the particular corresponding record types.

13. The method of claim 8 , wherein the branches connecting the particular data tables include two branches that connect at least three data tables with three different corresponding record types.

14. The method claim 8 , further comprising:
determining whether the dependency tree specifies that a third data table of the particular data tables depends on another data table; and
in response to a determination that the dependency tree does not specify that the third data table depends on another data table, moving records of the third data table to a third working table of the secondary tables.

15. A system comprising:
a processor; and
a memory coupled to the processor, wherein the memory comprises modules that, when executed by the processor, import one or more data tables that each comprise one or more records into corresponding secondary tables, the processor:
importing, from a database, into one or more intermediate tables, particular data tables with corresponding record types, wherein the particular data tables have dependencies specified in a dependency tree that comprises branches connecting the particular data tables, wherein a data table depends on another

Assignees

• Oracle Int Corp

Inventors

• Casas Francisco V
• Kim Jooyoung John
• Danko Krisztian Z
• Stengard Peter J
• Mozes Ari Wolfe
• Campos Marcos M

Classifications

• G06F17/30339

  Physics · mapped topic

• G06F17/303 Primary

  Physics · mapped topic

• G06Q30/0201

  Market modelling; Market analysis; Collecting market data · CPC title

• G06Q10/067 Primary

  Enterprise or organisation modelling · CPC title

• G06Q30/02

  Marketing; Price estimation or determination; Fundraising · CPC title