Overview:

Nihon Shurui Hanbai offers distribution and information infrastructure between approximately 3000 manufactures / suppliers of alcoholic and non-alcoholic beverages, and around 40000 supermarkets and retail stores. Starting in 2012, the company began using the Unicage software development method, Unicage for Short, to renovate a sales performance batch processing system vital for their business. The system was previously based on the COBOL program, which loads accumulated sales performance data onto DWH. The data, which is batch processed daily, is essential for formulating sales strategies and aiding various business activities. Nihon Shurui Hanbai came across Unicage as a promising solution to their expanding business.

Challenge:

As the amount of data and thus the programming scale expanded due to the growing business, the batch processing time tended to take longer as well. Taking into consideration the continued growth of the business and thus proportionally the data collected, Nihon Shurui Hanbai struggled to maintain a structural digital system that still maintained efficiency and speed during data processing. The system built on the COBOL program, simply did not meet the requirements anymore; it was simply too slow.

Solution:

After obtaining the company’s approval, Nihon Shurui Hanbai dispatched information integration staffs to attend the laboratory’s training lectures. Through the attended workshops and assisted guidance, the employees took charge in migrating the batch processing system. Starting in November of 2011, the company has switched the functionality of data extraction and conversion from various sources (DB, etc.), to shell scripts based on Unicage. There are now development plans initiated to do the same for batch processing and integration. Not only was the processing time drastically reduced, making the program much faster, it was also faster to implement in general which accelerated the development process.

Makoto Matsumaru: NH Information Distribution Headquarter, Information Integration Office, Deputy Manager

“We have realized that the UNICAGE approach is extremely effective in providing in-house infrastructure with high potential, as well as a stable service that meets the needs of the local site”

17

Number of steps reduced from 97293 to 5714, 17 times less steps

Parallel processing does not require special programming since it can automatically be executed if the commands are connected by pipe

Compilation before execution is not necessary - immediate testing after entering the command has contributed to the improvement of development efficiency

Accelerated development due to the ease of use