Method, computer program product and device for importing a plurality of data sets into a system

• US 20050240562A1
• Filed: 04/26/2005
• Published: 10/27/2005
• Est. Priority Date: 04/26/2004
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Steinmann, Joerg, Boruah, Jayanta M., Gentes, Wolfgang, Marar, Mohan, Kacker, Himanshu, A., Karthikeyan
• Granted Patent: US 7,856,428 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24554 Unary operations; Data partitioning operations
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

A method for importing a plurality of data sets into a system, each data set comprising data segments separated by a separator, comprises the steps of: providing data sets to be imported on a data storage medium; reading said data sets from said data storage medium; storing said data sets in a first table in said system, substantially without processing said data sets; reading said stored data sets from said first table; and writing one or more data segments of each data set into sub-tables, each sub-table comprising at least one data field. Furthermore, there is provided a computer program product and a device for importing a plurality of data sets into a system.

Claims

1. A method for importing a plurality of data sets into a system, each data set comprising data segments separated by a separator, the method comprising the steps of:

providing data sets to be imported on a data storage medium;

reading said data sets from said data storage medium;

storing said data sets in a first table in said system, substantially without processing said data sets;

reading said stored data sets from said first table; and

writing one or more data segments of each data set into sub-tables, each sub-table comprising at least one data field.

2. The method according to claim 1, wherein the step of writing said data segments into sub-tables comprises steps of substituting a predefined value of a data segment by another predefined value and writing said another predefined value into a data field of one of said sub-tables.

3. The method according to claim 1, wherein the step of writing said data segments into sub-tables comprises a step of introducing a predefined value into a data field of one of said sub-tables, said predefined value being given by properties of the imported data sets and/or data file.

4. The method according to claim 1, furthermore comprising a step of inputting additional information relating to said data sets.

5. The method according to claim 1, further comprising a step of inputting the type of separator used.

6. The method according to claim 1, further comprising a step of updating a status of the data sets in a status-table.

7. The method according to claim 1, further comprising a step of tracking erroneous data sets and marking said erroneous data sets in an error table.

8. The method according to claim 1, further comprising a step of checking whether two substantially identical data sets are present among the imported data sets.

9. The method according to claim 1, wherein said method further comprises a step of checking whether the predefined properties of said data are correct.

10. A computer program product tangibly embodied in an information carrier, the computer program product including instructions that, when executed, cause a processor to perform operations comprising:

providing data sets to be imported on a data storage medium;

reading said data sets from said data storage medium;

storing said data sets in a first table in said system, substantially without processing said data sets;

reading said stored data sets from said first table; and

writing one or more data segments of each data set into sub-tables, each sub-table comprising at least one data field.

11. A device for importing data sets into a system, said data sets being stored on a storage medium, each data set comprising data segments separated by a separator said device comprising:

a reading means for reading said data sets from said data storage medium;

a first table for storing said read data sets substantially without processing said data sets;

reading said stored data sets from said first table; and

a plurality of sub-tables, each sub-table comprising at least one data field for storing one or more data segments of each data set.