发明名称 PROCESSING DATA LOADS
摘要 A method and system for processing a data load. A request is received for a data load to load data into a database in accordance with a data template that includes data to be loaded into the database. The template includes columns and rows. The request specifies a request type characterized by at least one column that collectively includes unique data for each row. The columns include N sets of columns (N≧1) in addition to the at least one column. The data load is split into multiple loads of data. The multiple loads include one load and N additional loads. The one load is associated with the at least one column. The N additional loads are respectively associated with the N sets of columns and are configured to generate or modify one or more rows in each table of N respective additional tables in the database.
申请公布号 US2014317153(A1) 申请公布日期 2014.10.23
申请号 US201313866209 申请日期 2013.04.19
申请人 INTERNATIONAL BUSINESS MACHINES CORPORATION 发明人 Chen Danny Yen-Fu;Cormier Craig A.;Morgan Fabian F.;Sridhar Badri;Stevens Wesley
分类号 G06F17/30 主分类号 G06F17/30
代理机构 代理人
主权项 1. A method for processing a data load, the method comprising: one or more processors of receiving a request for a data load to load data into a database in accordance with a data template that includes the data to be loaded into the database, the template comprising a plurality of columns and a plurality of rows, the request specifying a request type characterized by at least one column of the plurality of columns, the at least one column collectively including unique data for each row of the plurality of rows, the plurality of columns comprising N sets of columns in addition to the at least one column, N being at least 1; and the one or more processors splitting the requested data load into multiple loads of data, the multiple loads comprising one load of data and N additional loads of data, the one load being associated with the at least one column, the N additional loads respectively associated with the N sets of columns, the one load configured to generate or modify one or more rows of one table in the database, the one table comprising a column serving as a primary key in association with the at least one column, the N additional loads configured to generate or modify one or more rows in each table of N respective additional tables in the database, each table of the N additional tables comprising a column serving as a foreign key with respect to the primary key of the one table.
地址 Armonk NY US