What did you succeed in the key system of Keio Department Store, which was a "fierce battle"

Mr. Hirokazu Sugiyama, General Manager, System Development, Management Planning Office, Keio Department Store

Mr. Sugiyama describes the company's DX (digital transformation) as defined in the Ministry of Economy, Trade and Industry's 2018 "DX Report-Overcoming the IT System '2025 Cliff' and Full-scale Deployment of DX-" According to him, the core system was "type 1 (mainframe preservation)", and the peripheral system was "type 3 (simple cloud conversion of on-premises)".

In the background, the host's operational deadline was approaching March 2020, and there were three "no waits". The first is to respond to laws and regulations such as the introduction of tax increases and reduced tax rates in October 2019, the second is to respond to aging systems, and the third is to respond to changes in the commercial environment, such as the diversification of payment methods. is. In 2017, the company integrated the group's point service, and in the fall of 2018, it was promoting advanced initiatives such as the industry's first Tomonokai native app.

Actually, this is not the first time that we have worked on the renovation of the core system. In 2013, he tried again and gave up. We recognize that the main reason for this is that we left it up to a major IT vendor, and this time we also boldly challenged ourselves as a "fighting battle".

Easy data management with Autonomous Data Warehouse

This project was organized in 2018, and the renovation project started in October 2019. At that time, the word "DX" was not used as much as it is now. However, from the time the Corporate Planning Office compiled its IT strategy in October 2017, the word "digital transformation" was used to indicate the need for management.

“If you compare it to a mobile phone, I have been using a “garakei” since 1987, and it was a system that could not withstand changes in the world.Including issues such as labor shortages, DX I explained to management that I would create an intelligent system and create a mechanism to revitalize the company,” says Mr. Sugiyama.

More than 20 companies were involved in the project, and the number of people exceeded 200.

ITFO's "RITS" was adopted as the core system, and Oracle Cloud Infrastructure (OCI) and "Oracle Autonomous Data Warehouse" were introduced as the information utilization platform for utilizing the data accumulated here. A data lake called "Keio Department Store Data Lake (KDSDL)" was built on top of this. Data rights belong to the company, and users can view the data using BI's Yellowfin.

Autonomous Data Warehouse features automatic optimization through learning. In fact, in addition to being able to process tens of millions of data in seconds, "Even if the amount of data increases, performance will not be affected," says Sugiyama. Looking back, it was easy to import and export data from the on-prem. Data management was the decisive factor in introducing OCI. “Data management is costly. The Autonomous Data Warehouse did not require a DBA (database administrator),” says Mr. Sugiyama.