define ruby and sql structures, create parallel test data