Package org.pentaho.aggdes.model

Interface Schema

public interface Schema
Star schema.

A star schema is a collection of tables: a central fact table, and several dimension tables. Each table except the fact table is joined to a parent table.

  • Method Details

    • getTables

      List<? extends Table> getTables()
      Returns a list of all Table objects in the schema.
      Returns:
      list of tables

    • getMeasures

      List<Measure> getMeasures()
      Returns a list of Measure objects in the schema.
      Returns:
      list of measures

    • getDimensions

      List<? extends Dimension> getDimensions()
      Returns a list of Dimension objects in the schema;
      Returns:

    • getAttributes

      List<? extends Attribute> getAttributes()
      Returns a list of all attributes in this schema.
      Returns:
      list of all attributes in all tables

    • getStatisticsProvider

      StatisticsProvider getStatisticsProvider()
      Returns the statistics provider for this Schema.
      Returns:
      statistics provider

    • getDialect

      Dialect getDialect()
      Returns the dialect of the underlying database.
      Returns:
      dialect

    • generateAggregateSql

      String generateAggregateSql(Aggregate aggregate, List<String> columnNameList)
      Converts an aggregate to a SELECT statement. Uses the schema's SQL dialect.
      Parameters:
      aggregate - Aggregate
      columnNameList - List of column names, one per attribute
      Returns:
      SQL SELECT statement to populate aggregate