ORM Equivalent for a Star/Snowflake Schema

Question

An ORM (.netTiers, EntityFramework, nHibernate, etc.) can generally be described as bridging the gap between the relational data model and the object oriented model.

Is there an ORM equivalent in the data warehousing world?

The technology would bridge the gap between a denormalized star/snowflake schema and the object oriented model. The goal is to be able to rapidly develop a data layer that sits on top of and consumes said schema.

We are using .Net with MSSQL.

Happy Friday!

Answer 1

If you practice CQRS (Command/Query Responsibility Separation), you could potentially consider your Data Warehouse the Read Model you are querying against. Your normalized OLTP database would be the data model your Commands execute against.

That being said, I don't know any any ORM that can speak MDX and talk to a Data Warehouse.