ModelRight, a data modeling software company, has released version 3.5 of its flagship product ModelRight, adding support for three additional database platforms as well as a wide variety of productivity enhancements. There are two editions of the product, the ModelRight Professional Version and the Free Community Version, and the new 3.5 release applies to both of them.
ModelRight Professional 3.5 now supports six leading databases in one easy to use and cost-effective product. The databases it supports are PostgreSQL, DB2 for z/OS and LUW, Microsoft Access, Oracle, MySQL, and Microsoft SQL Server. It is also available as an a la carte/per database version. The Free Community Version of ModelRight 3.5 provides support for PostgreSQL and MySQL databases.
Support for PostgreSQL (Versions 8.2, 8.3 and 8.4) includes domains, composite, enumerated and base types, array dimensions, table rules, table spaces, sequences, and index properties like fill factor, concurrent, partial expression and nulls first. Support for DB2 LUW (Versions 8, 9, 9.5 and 9.7) and DB2 for z/OS (Versions 8 and 9) include bufferpools, database partition groups, security policy, materialized queries, structured, distinct, and array types, table spaces, table and index physical properties, structured tables/views and sub-tables/views, computed columns and many DB2-specific column properties, triggers, synonyms, sequences, and table and index partitioning.
In addition to new database support, significant productivity enhancements have been added to ModelRight 3.5, including auto-naming options, change script, reverse engineer into model, alias types and object level filtering in reverse engineer.
"The focus of version 3.5 continues to be on physical modeling, with rounded out support for three additional database platforms, web-like navigation with an easier to use GUI, and enhancements that enable full cycle development," Tim Guinther, president and founder of ModelRight, tells 5 Minute Briefing. "Full cycle development refers to the ability to do both forward and reverse engineering. Forward engineering involves creating new data models to develop new tables, columns, indices, and entire databases. Reverse engineering is beneficial when customers have inherited existing databases and want to visualize and document the schema of these databases."
For more information about ModelRight 3.5, go here.