METHOD AND APPARATUS FOR MOVING DATA FROM AN EXTENSIBLE MARKUP LANGUAGE FORMAT TO NORMALIZED FORMAT

• US 20080114802A1
• Filed: 11/15/2006
• Published: 05/15/2008
• Est. Priority Date: 11/15/2006
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Plassmann, Ernst R., Lita, Christian, Gheorghioiu, Ovidiu, Ramamoorthy, Karthikeyan, Ramanathan, Jayashree
• Granted Patent: US 7,475,090 B2
• Time in Patent Office: Days
• US Class Current: 707/102
• CPC Class Codes: G06F 16/86 Mapping to a database
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A computer implemented method, apparatus, and computer usable program code for creating normalized data from markup language data. User defined parameters are received for retrieving event data, wherein the parameters define a type of event and a subset of attributes for the type of event. In response to receiving the parameters, a process is configured using the type of event and the subset of attributes for the type of event to form a configured process. A set of records is processed using the configured process, wherein the configured process places data corresponding to each attribute in the subset of attributes for the type of event from the set of records into a table to form the normalized data.

Claims

1. A computer implemented method for creating normalized data from markup language data, the computer implemented method comprising:

receiving user defined parameters for retrieving event data, wherein the parameters define a type of event and a subset of attributes for the type of event;

responsive to receiving the parameters, configuring a process using the type of event and the subset of attributes for the type of event to form a configured process; and

processing a set of records using the configured process, wherein the configured process places data corresponding to each attribute in the subset of attributes for the type of event from the set of records into a table to form the normalized data.

2. The computer implemented method of claim 1 further comprising:

generating a report using the normalized data.

3. The computer implemented method of claim 1, wherein an input defines a second type of event and a second subset of attributes associated with the second type of event and wherein the configuring step further comprises:

configuring a second process using the second type of event and the second subset of attributes associated with the second type of event to form a second configured process.

4. The computer implemented method of claim 3, wherein the processing step further comprises:

processing a second a set of records using the second configured process, wherein the second configured process places data corresponding to each attribute associated with the second event type from the second set of records into the table to form the normalized data.

5. The computer implemented method of claim 1, wherein the user defined parameters are received in a form of a configuration file defined by a user.

6. The computer implemented method of claim 1 further comprising:

receiving a unit of work, wherein a range of record identifiers are defined in the unit of work; and

retrieving the set of records from a database using the range of record identifiers.

7. The computer implemented method of claim 1, wherein the processing step further comprises:

decompressing the set of records.

8. The computer implemented method of claim 1, wherein the process comprises a shredder, wherein the shredder uses a table class and a column class to place data corresponding to each attribute in the subset of attributes for the event type from the set of records into the table.

9. A computer program product comprising:

a computer usable medium having computer usable program code for executing creating normalized data from markup language data, the computer program medium comprising;

computer usable program code for receiving user defined parameters for retrieving event data, wherein the parameters define a type of event and a subset of attributes for the type of event;

computer usable program code, responsive to receiving the parameters, for configuring a process using the type of event and the subset of attributes for the type of event to form a configured process; and

computer usable program code for processing a set of records using the configured process, wherein the configured process places data corresponding to each attribute in the subset of attributes for the type of event from the set of records into a table to form the normalized data.

10. The computer program product of claim 9 further comprising:

computer usable program code for generating a report using the normalized data.

11. The computer program product of claim 9, wherein the input defines a second type of event and a second subset of attributes associated with the second type of event and wherein the computer usable program code, responsive to receiving the parameters, for configuring a process using the type of event and the subset of attributes for the type of event to form a configured process, comprises:

computer usable program code for configuring a second process using the second type of event and the second subset of attributes associated with the second type of event to form a second configured process.

12. The computer program product of claim 11, wherein the computer usable program code for processing a set of records using the configured process, wherein the configured process places data corresponding to each attribute in the subset of attributes for the type of event from the set of records into a table to form the normalized data further comprises:

computer usable program code for processing a second a set of records using the second configured process, wherein the second configured process places data corresponding to each attribute associated with the second event type from the second set of records into the table to form the normalized data.

13. The computer program product of claim 9, wherein the user defined parameters are received in a form of a configuration file defined by a user.

14. The computer program product of claim 9 further comprising:

computer usable program code for receiving a unit of work, wherein a range of record identifiers are defined in the unit of work; and

computer usable program code for retrieving the set of records from a database using the range of record identifiers.

15. The computer program product of claim 9, wherein the computer usable program code for processing a set of records using the configured process, wherein the configured process places data corresponding to each attribute in the subset of attributes for the type of event from the set of records into a table to form the normalized data further comprises:

computer usable program code for decompressing the set of records.

16. The computer program product of claim 9, wherein the process comprises a shredder, wherein the shredder uses a table class and a column class to place data corresponding to each attribute in the subset of attributes for the event type from the set of records into the table.

17. A data processing system comprising:

a bus;

a communications unit connected to the bus;

a storage device connected to the bus, wherein the storage device includes computer usable program code; and

a processor unit connected to the bus, wherein the processor unit executes the computer usable program code to receive user defined parameters for retrieving event data, wherein the parameters define a type of event and a subset of attributes for the type of event;

configure a process using the type of event and the subset of attributes for the type of event to form a configured process in response to receiving the parameters; and

process a set of records using the configured process, wherein the configured process places data corresponding to each attribute in the subset of attributes for the type of event from the set of records into a table to form the normalized data.

18. The data processing system of claim 17 wherein the processor unit further executes the computer usable program code to generate a report using the normalized data.

19. The data processing system of claim 17, wherein the input defines a second type of event and a second subset of attributes associated with the second type of event and wherein in executing the computer usable program code to configure a process using the type of event and the subset of attributes for the type of event to form a configured process in response to receiving the parameters, configure a second process using the second type of event and the second subset of attributes associated with the second type of event to form a second configured process.

20. The data processing system of claim 19, wherein in executing the computer usable program code for processing a set of records using the configured process, wherein the configured process places data corresponding to each attribute in the subset of attributes for the type of event from the set of records into a table to form the normalized data, the processor unit further executes the computer usable program code to process a second a set of records using the second configured process, wherein the second configured process places data corresponding to each attribute associated with the second event type from the second set of records into the table to form the normalized data.