The benefits of implementing EDW
- The benefits of implementing EDW in isle included various impacts on the operations carried out by them. It enabled the manager to view monthly, weekly, and daily reports and helped them to make decisions swiftly. The reports were well classified and categorized, which helped them to detect a problem and find the reason for it. The reports helped in framing up queries and follow up questions, which would help them to improve the business. It reduces the compilation time of the report significantly, and instead of more than one month, the reports could be prepared in a substantially lower amount of time. The reports segment data by properties; hence, the managers could focus on problems and successes of a particular property, and compare them with others if necessary. Other potential benefits include the monitoring of the use of a specific service by the guests. This, in turn, helps the company to provide incentives to the guests. Also, managers are enabled to submit queries of data sets and receive information within minutes.
- ROLAP stands for Relational Online Analytical Processing. It is a storage mode that stores the aggregation of the division indexed view, which was already specified in the data source of the partition. ROLAP has a relatively slower query response than MOLAP or HOLAP. The processing time is also longer since it creates new tables. MOLAP stands for Multidimensional Online Processing Array. It is an online analytical process that indexes directly to a multi-dimensional array. It is highly optimized for maximum query performances. Query times and the processing time is reduced by using aggregations. HOLAP stands for Hybrid Online Analytical Processing. It is analytical processing, which has the combined features of ROLAP and MOLAP. It enables the aggregation of the division and stores it in a SQL server. Queries usually take a shorter time, but queries that require access to the source record take time.