Seed Data Automation

• US 20130054626A1
• Filed: 08/30/2011
• Published: 02/28/2013
• Est. Priority Date: 08/30/2011
• Status: Active Grant

• Current Assignee: Bank of America Corp.
• Original Assignee: Bank of America Corp.
• Inventors: Kuehler, William A., Fuchs, Valerian, Raj, Ramya, Patel, Apurva M.
• Granted Patent: US 8,688,624 B2
• Time in Patent Office: Days
• US Class Current: 707/756
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses

Abstract

According to one embodiment of the present invention, the automated loading seed data for testing in a product integration environment includes receiving input data associated with a test session. The input data may be received in a first format that includes at least one object. A processor may be used to automatically convert the input data into a second format that includes the metadata data string. The metadata data string may then be loaded into a database.

Claims

1. A system for the automated loading of seed data for testing in a product integration environment, comprising:

a database storing at least one record comprising seed data; and

a test module comprising a processor in communication with the database, the processor operable to;

receive input data associated with a test session, the input data receive in a first format comprising at least one object,

automatically convert the input data into a second format, the second format comprising a metadata data string; and

load the metadata data string into the database.

2. The system of claim 1, wherein automatically converting the input data into the second format comprises:

using at least one seed data automation rule to decompose the at least one object into seed data comprising at least one key-value pair;

3. The system of claim 2, wherein the metadata data string comprises a plurality of key-value pairs.

4. The system of claim 1, wherein the processor is further operable to assign an object identifier to the metadata data string, the object identifier identifying a particular object within the input data.

5. The system of claim 1, wherein the processor is further operable to associate a level with the metadata string, the level identifying a level assigned to a particular object within the input data with which the metadata string is associated.

6. The system of claim 1, wherein automatically converting the input data into a second format comprises generating a plurality of records, each record comprising a metadata data string.

7. The system of claim 6, wherein at least a portion of the plurality of records is assigned to a first level and at least a portion of the plurality of records is assigned to a second level, and, wherein all records assigned to the first level are processed before any records assigned to the second level.

8. A method for the automated loading of seed data for testing in a product integration environment, comprising:

receiving input data associated with a test session, the input data receive in a first format comprising at least one object,

using a processor to automatically convert the input data into a second format, the second format comprising a metadata data string; and

loading the metadata data string into a database.

9. The method of claim 8, wherein using the processor to automatically convert the input data into the second format comprises:

using at least one seed data automation rule to decompose the at least one object into seed data comprising at least one key-value pair;

10. The method of claim 9, wherein the metadata data string comprises a plurality of key-value pairs.

11. The method of claim 8, further comprising:

assigning an object identifier to the metadata data string, the object identifier identifying a particular object within the input data.

12. The method of claim 8, further comprising:

associating a level with the metadata string, the level identifying a level assigned to a particular object within the input data with which the metadata string is associated.

13. The method of claim 8, wherein automatically converting the input data into a second format comprises generating a plurality of records, each record comprising a metadata data string.

14. The method of claim 13, further comprising:

assigning at least a first portion of the plurality of records to a first level; and

assigning at least a second portion of the plurality of records to a second level, and

wherein all records assigned to the first level are loaded before any records assigned to the second level.

15. Non-transitory computer readable medium comprising logic, the logic, when executed by a processor, operable to:

receive input data associated with a test session, the input data receive in a first format comprising at least one object,

automatically convert the input data into a second format, the second format comprising the metadata data string; and

load the metadata data string into a database.

16. The non-transitory computer readable medium of claim 15, wherein automatically converting the input data into the second format comprises:

using at least one seed data automation rule to decompose the at least one object into seed data comprising at least one key-value pair;

17. The non-transitory computer readable medium of claim 16, wherein the metadata data string comprises a plurality of key-value pairs.

18. The non-transitory computer readable medium of claim 17, further operable to:

assign an object identifier to the metadata data string, the object identifier identifying a particular object within the input data.

19. The non-transitory computer readable medium of claim 15, wherein automatically converting the input data into a second format comprises generating a plurality of records, each record comprising a metadata data string.

20. The non-transitory computer readable medium of claim 19, further operable to:

assign at least a first portion of the plurality of records to a first level; and

assign at least a second portion of the plurality of records to a second level, and

wherein all records assigned to the first level are loaded before any records assigned to the second level.