VDMGEN is a simple, flexible and expandable framework for building and maintaining SQL/DDL/DML or PHP code libraries. It is perfectly suited for automating the maintenance of MQTs and other derived data in the database, or for application data access and other layered components. Because of its simplicity and openness it can be expanded to other uses as well.
The original intention was to find a simple way to generate consistent and correct code libraries in a data-centric fashion for developers that work with complex SQL, database applications and DBAs. It is based on templates that allow SQL to be prepeared, developed and exectuted standalone, facilitating debugging and performance testing. The templates use a limited number of macro-substitution constructs that allow the SQL to be read and understandood as a whole, without fragmenting it into pieces.