Dimensional Fact Model

  • Useful graphical representation of facts, measures, dimensions, and hierarchies
  • to specify the requirements for your business analytics applications in a formal but intuitive way
  • The best formalism to define the Conceptual Model of a Business Intelligence System
  • supported by a design tool that makes easy to specify all the aspects of the model

Relational Model

  • Transform your Conceptual Model in a Logical Model that satisfies all the requirements
  • make your design choices (eg. use surrogate keys, slow changing dimensions, ...) and let BI Modeler create the relational model for you
  • Customize your relational database model adding tables, columns, constraints
  • if you have to modify your Conceptual Model you can update the logical one without lose your integrations

Physical model and DDL

  • Add physical specifications to your relational model exploiting all the capabilities of your DBMS (Oracle, SQLServer, SAP HANA, Hadoop HIVE, ...)
  • create indexes and partitions; specify parallel degree and file system allocation
  • Generate the DDL script to build the db with all the details you need for your environment
  • customize the script including/excluding primary keys, foreign keys, comments, ...