By combining dimensions and information, Ralph Kimball came up with Dimensional Modelling. SELECT OPERATION is best suited to this approach because its primary objective is to enhance data retrieval. Using this model, we can store data in a way that makes it easier to save and retrieve data once it has been stored in a data warehouse. Many OLAP systems employ the dimensional model as their primary data structure. Dimensional