Data importer for a sales prospector

• US 9,773,030 B2
• Filed: 09/01/2015
• Issued: 09/26/2017
• 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 Wolfe, Campos, Marcos M.
• Primary Examiner(s): Shanmugasundaram, Kannan
• Application Number:
  US14/841,844
• Publication Number:
  US 20150370790A1
• Time in Patent Office: 756 Days
• 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 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 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.

16. The system of claim 15, 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.

17. The system of claim 15, 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.

18. The system of claim 15, 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.

19. The system of claim 15, 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.

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