Data Volume Management

Having a system running for months or years we need to properly maintain it. We need to ensure the system is available during business hours and performance is at the required level. As the system is growing together with your company, at one moment, you must decide what to do with data that is no longer used before migrating to S/4HANA system.

Growth in data volumes can be driven by numerous factors. As a result too much data tends to remain on the live database. In many cases, data that is never used is stored on the live database. Retaining too much data or keeping it when it is no longer useful or required can lead to rising IT costs, complex system management, and decelerated system performance.

Data Volume Management is the key process to be done to clean the unwanted data from your system.

data

IF NOT NOW, WHEN?

If no actions are taken for the huge storage of unwanted data, your business is exposed to the following,

  1. Continued cost of higher storage of expired data
  2. Exposure to compromise/lost data during upgrade
  3. Declining performance of the systems

HOT AND COLD DATA

Data Types

Do I really require historical data for my current business scenario?

  • Volume:    The more data you need to store, the more complex these problems will become. What works cleanly for a small volume of data may not work the same for bigger demands.

 

  • Predictability:   You might not be able to predict your short- term or long-term storage needs. This makes it                       nearly impossible to respond with agility or                accurately forecast your future demand.

SOLUTION:

1.DATA ARCHIVING:

Data archiving is the process of moving data that is no longer actively used to a separate storage device for long-term retention. Archive data consists of older data that is still important to the organization and may be needed for future reference, as well as data that must be retained for regulatory compliance.

It is a service provided by SAP for the consistent removal of data objects from database tables of the SAP database, where all table entries that characterize a data object are written to an archive file outside the database.

BENEFITS OF DATA ARCHIVING:

  1. Reduces the costs of memory, disk and administration costs.
  2. Ensures cost efficient system upgrades and migration.
  3. Improved system performance due to shorter response time.
  4. Reduces the cost of maintenance and run of growing application infrastructure.

2.How to perform Data Aging in S/4HANA?

Data aging is new possibility to manage outdated information and helps to move sets of data within a database by specifying a data temperature.

Hot data resides in current area of the database, when the warm / cold data is moved to historical area.

Data Volume Management Evolution

For performing data aging, carry out several manual activities defined as a series of process by SAP.

Example:

SFLIGHT data generation

For data aging using SFLIGHT data SAP prepared separate set of tables:

DAAG_SPFLI – Flight schedule

DAAG_SFLIGHT – Flights

DAAG_SBOOK – Single Flight Booking

The idea in data aging is to partition hot and cold data in the system separately.

Partitioning object is a set of tables that will be partitioned together. In our case it consists of two tables: DAAG_SBOOK and DAAG_SFLIGHT:

Partitioning Objects

Before performing partitioning all the records reside in the current area.

Display hot and cold data

After carrying out several activities the hot and cold data are partitioned separately based on a selection criteria in our example (based on Starting and Ending Dates).

Display hot and cold data partitions of table

Tired of performing numerous activities to clean up the data? Here is an easy solution!

The best approach is to use an automated tool that when provided with your system credentials will automatically clean up the data and provide you with only the necessary data before migrating to HANA system.

Get in touch with Akilesh at sakilesh@kaartech.com to know more.

Supriya Ashok

Related Posts
Leave a reply
Captcha Click on image to update the captcha .