In Pentaho, a metadata model transforms your database’s physical structure into a logical business model. These mappings are kept in a single repository, allowing developers and administrators to create cost-effective and efficient business-logical DB tables. It also makes business users’ jobs easier by allowing them to produce prepared reports and dashboards while maintaining data security.
Overall, the metadata model encapsulates the physical and logical definitions of your database, as well as the relationships that exist between them.