发明名称 DATA IMPORTER FOR A SALES PROSPECTOR
摘要 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.
申请公布号 US2015370790(A1) 申请公布日期 2015.12.24
申请号 US201514841844 申请日期 2015.09.01
申请人 Oracle International Corporation 发明人 CASAS Francisco V.;KIM Jooyoung John;DANKO Krisztian Z.;STENGARD Peter J.;MOZES Ari Wolfe;CAMPOS Marcos M.
分类号 G06F17/30;G06Q30/02 主分类号 G06F17/30
代理机构 代理人
主权项 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 into corresponding secondary tables, the importing comprising: importing, from a database, into one or more intermediate tables, particular data tables having dependencies specified in a dependency tree that comprises branches connecting a first group of data tables with corresponding record types; determining whether the dependency tree specifies that a first data table of the particular data tables depends on another data table; in response to a determination that the dependency tree specifies that the first data table depends on another data table, 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; 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.
地址 Redwood Shores CA US
您可能感兴趣的专利