We all know that information is a big strategic asset. But what type of data is more important and more valuable? Making the information effective and a long-standing asset is the key for running your business efficiently. In order to achieve this goal, companies invest a lot in BI tools for analysis, reporting and archiving solutions. One of the most innovative archiving solutions that we would like to introduce today is Nearline Storage (NLS) – it keeps your data “cold” and reduces the BW database size and administration costs significantly, as well as improves performance.
What is cold data?
Nearline Storage (NLS) is a concept that defines the type of data storage archiving between online storage and offline storage.
This solution stores data in a compressed form with less backups and reduces costs for the data which is less accessed (cold data). This advanced technology is based on Information Life Cycle Management (ILM) to secure backups and store data on less expensive storage devices. The most frequently accessed data is more valuable for the company (hot data). Thus, new data is stored on high-performance storage devices which are more expensive. In time, the level of importance of data decreases and it is less accessed and it is moved on a cost-efficient storage nearline repository where data is remaining accessible for read-only purposes.
It is worth it?
There is a considerable improvement when choosing this solution, for example query performance. In order to understand the advantages of this solution we present to you a case study based on a real customer scenario. You can see the expected query performance when NLS solution is applied. There are two tests for different types of queries which compare query runtimes on normal conditions and on those when using the NLS solution. The results are impressive regarding NLS usage: faster access to the archived data (avg. 5 times faster), reduced database administration and improved performance.
In addition to that, when Nearline Storage is implemented the costs of managing growing data streams decreases. As you can see below, year by year, the DB gets bigger and bigger. Which means that – when archiving cold data with NLS – you can save up to 40% of your DB storage. This represents a prominent cost reduction as well. The benefits are clear and measurable. NLS solution removes less frequent data from the online DB and compresses it by 90%, reducing storage costs but also keeping and increasing the performance.
To wrap things up, I would like to emphasize the importance of NLS in order to keep your BW fit daily. Even if your data grows fast, there is no reason to worry about it when you have the NLS asset in your pocket. It helps significantly to reduce your BW database size, hardware and administration costs. Furthermore, less effort is needed for backup and disaster recovery.
Additionally, when considering SAP HANA in the future, Nearline Storage helps the user to benefit from a leaner BW system, which might lower the TCO for the future HANA migration. The size of the working memory in use is reduced considerably – allowing huge cost savings for licenses and hardware for SAP BW on HANA.
Any questions regarding Nearline Storage? Contact us or make an appointment with us. You can also download a market research with case studies on NLS by sending us an E-mail with the subject “Market Research NLS”. We are looking forward hearing from you!