Seed data automation

• US 8,688,624 B2
• Filed: 08/30/2011
• Issued: 04/01/2014
• 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.
• Primary Examiner(s): Richardson, James E
• Application Number:
  US13/221,079
• Publication Number:
  US 20130054626A1
• Time in Patent Office: 945 Days
• Field of Search: 707/602, 707/756, 707/804
• US Class Current: 707/602
• 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 in a seed data table; 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 received in a first format comprising at least one object;

automatically convert the input data into a second format, the second format comprising a plurality a metadata data strings, each metadata data string comprising a plurality of key value-pairs;

assign a first portion of the plurality of metadata data strings associated with a first object type to a first level;

assign a second portion of the plurality of metadata data strings associated with a second object type to a second level; and

without requiring further conversion of the input data and during the performance of a plurality of performance tests, repeatedly load the first portion and the second portion of the metadata data strings into the seed data table, wherein loading the metadata data strings comprises;

loading the first portion of the metadata data strings associated with the first level into the seed data table before the second portion of the metadata strings associated with the second level; and

storing each metadata data string comprising the plurality of key-value pairs in a single field of a record in the seed data table.

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 the at least one key-value pair.

3. 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.

4. 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.

5. 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 received 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 plurality of records, each record comprising a metadata data string, each metadata string comprising a plurality of key value-pairs;

assigning a first portion of the metadata strings associated with a first object type to a first level;

assigning a second portion of the metadata data strings associated with a second object type to a second level; and

without requiring further conversion of the input data and during the performance of a plurality of performance tests, repeatedly loading the first portion and the second portion of the metadata data strings into a seed data table of a database, wherein loading the metadata data strings comprises;

loading the first portion of the metadata strings associated with the first level into the seed data table before the second portion of the metadata strings associated with the second level; and

storing each metadata data string comprising the plurality of key-value pairs in a single field of a record in the seed data table.

6. The method of claim 5, 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 the at least one key-value pair.

7. The method of claim 5, further comprising:

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

8. The method of claim 5, 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.

9. A 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 received in a first format comprising at least one object;

automatically convert the input data into a second format, the second format comprising a plurality of meta data strings, each metadata data string comprising a plurality of key value-pairs;

assign a first portion of the plurality of metadata data strings associated with a first object type to a first level;

assign a second portion of the plurality of metadata data strings associated with a second object type to a second level; and

without requiring further conversion of the input data and during the performance of a plurality of performance tests, repeatedly load the first portion and the second portion of the metadata data strings into a seed table of a database, wherein loading the metadata data strings comprises;

loading the first portion of the metadata data strings associated with the first level into the seed data table before the second portion of the metadata data strings associated with the second level; and

storing each metadata data string comprising the plurality of key-value pairs in a single field of a record of in the seed data table, the metadata data string comprising the plurality of key value-pairs in the single field of the record of the database during the performance of a plurality of performance tests.

10. The non-transitory computer readable medium of claim 9, 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 the at least one key-value pair.

11. The non-transitory computer readable medium of claim 10, further operable to:

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