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

• US 7,856,428 B2
• Filed: 04/26/2005
• Issued: 12/21/2010
• Est. Priority Date: 04/26/2004
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Steinmann, Joerg, Gentes, Wolfgang, A., Karthikeyan, Boruah, Jayanta M., Marar, Mohan, Kacker, Himanshu
• Primary Examiner(s): Fleurantin; Jean B
• Application Number:
  US11/114,897
• Publication Number:
  US 20050240562A1
• Time in Patent Office: 2,065 Days
• Field of Search: 707 1- 10, 707100-1041, 707200-206, 707600-831
• US Class Current: 707/705
• 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, the method comprising the steps of: providing data sets to be imported on a data storage medium, reading the data sets from the data storage medium, storing the data sets in a first table in the system, substantially without processing the data sets, reading the stored data sets from the 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, it is disclosed 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, without dividing any of the data sets, while preserving a form of the data sets as it said form exists in the data storage medium;

reading said stored data sets from said first table; and

writing one or more data segments of each data set read from said first table into sub-tables thereby dividing the data sets, 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 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 without dividing any of the data sets, while preserving a form of the data sets as it said form exists in the data storage medium;

a reading means for reading said stored data sets from said first table; and

a mapping means for mapping data segments of the data sets read from the first table into 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.