Key Performance Features of Innovator for Information Architects

Data Modeling

  • Conceptual database modeling with entity relationship diagrams in Chen, James Martin, DSA, UML, IDEF1X or SERM notation.

  • Design of database schema in IDEF1X notation

  • Standard mapping between the conceptual ER models and database schema

  • Automated mapping from the conceptual ER model to a database schema

  • OO-ER mapping from and to object-oriented UML 2 models

  • Customizable SQL/DDL generation

  • Reverse engineering via JDBC

  • Support for all databases, such as IBM DB2, Oracle, Microsoft SQL Server and Informix

Data Governance

  • Integration of unstructured NoSQL data

  • Process modeling using BPMN notation for data origin

  • Data Vault 2.0 modeling with hub, satellite and link for data integration and data provision in a Data Warehouse

Business Intelligence

  • Multi-Dimensional Modeling in Cube and Dimension Diagrams

  • Mapping between the multi-dimensional model and database schema

  • Data mart visualization of view relationships in entity relationship models or in a Data Warehouse

  • Visualization of data origin with impact analysis

General Functions

  • Central model server for team work throughout the organization

  • Complete configurable model elements enable organization-specific and project-specific extensions

  • Consistency checks and extendable validation of models

  • Documents with customizable reports for HTML and Microsoft Word

  • Impact analysis displays the interconnection of model elements using analysis graphs

  • Whiteboard diagrams for visualizing relationships in the model

  • API for extensions in Java and .NET (C#, C++, VB.NET)