added batch processor, updated DDL, fixed bugs