Challenges and Possibilities of a Data Warehouse to the Cloud
By means of using data warehouse organizations become able to consolidate data from
different sources while the analysis workload remains separated from transaction workload. Instead of going for the transaction processing, 'analysis and query' based on a relational database which consists of historical data- particularly derived from transactional data including various information from other sources is usually called a data warehouse. In the cloud, data warehousing offers significant conveniences that can be effectively implemented through the operation of SAP solutions. Using the real time data warehousing users can get quick access to fundamental information while the SAP HANA platforms empower providers' tools to be ranged from packaged warehouses to dynamic tiring including Big Data analytics. Remarkable challenges while getting a data warehouse made, developed, and well- maintained can lead the entire method to become a throbbing process. These challenges can be addressed below- A data warehouse setup can be a time-consuming process. During peak workloads a distinct service level may need to be fixed for over-estimating the requirement of the system so that the over-provisioning can be possible. A standardized prevalence of expertise is needed in order to get a data warehouse well- maintained. An organization usually experiences system crash, system overload, and downtime that comprehensively beget a number of consequences.
Because of the lack of carefulness in analysis to carry the fitness between the cloud platforms and the relational database it's still a big drawback to make the most of data warehouse in the cloud. Data importing into the cloud for storage can be a tough challenge
since during the use of cloud a user relies on the cloud provider's infrastructure and the internet which can associate the cost and/or performance issues. Collecting large amount of data from storage to cloud provider's virtual nodes for computing can be a performance issue. As cloud providers usually offer nodes of low-end such as virtual machines for
manipulation, but on the other hand local warehousing system of information tends to be well-estimated in respect of disk bandwidth, memory, and cPU, the desired performance may become challenging. There is more obstacles like- WAN latency can be availed when the applications are running. There can be security and trust issues because of the lack of control. Data lifecycle management and a dependable cloud based administrative system are required.
Being a cloud computing environment data migration turns out to be an effective exercise in the risk management. It includes getting applied with both the quantity and quality factors. To ensure that the organization can be safeguarded well the risk must be balanced concerning security measures. To make the most of cloud migration applications to the cloud should be perfect. Difficulties during the migration of cloud application should be avoided. The development of software applications needs the capability of an on-premises
considering the migrations tests earlier to the cloud. Also organizations may need to have an
exit strategy especially when they are depending on the usage