Abstract: A system automatically produces records comprising an associative data structure specifying a relationship between two or more separate data structures in response to user entered selection criteria for individual separate data structures. A system for creating associative database records, includes a selection processor for selecting a first dataset in response to user command. A data processor, in response to user command, initiates a search to identify at least one second dataset linked to the first dataset. The data processor selects particular records of a particular second dataset of the identified at least one second dataset and initiates creation of a plurality of records associating the selected particular records of the particular second dataset with the first dataset. A storage processor stores the plurality of created records in a repository.

Abstract: A structured data transformation system includes a source of first data determining an existing hierarchically ordered data structure. A source of transformation data determines transformations to be performed to convert the existing hierarchically ordered data structure to a target different hierarchically ordered data structure. A validation processor examines the first data to validate the transformation data is able to successfully process the first data by determining data elements, required for the transformation, exist in the first data. A transformation processor initiates transformation of the first data into second data representing the target different hierarchically ordered data structure using the transformation data in response to successful validation.