Keio Department Store builds data lakehouse with Oracle for real-time insights

Keio Department Store uses Oracle Autonomous Database on OCI to revamp its enterprise system and build a strategic data analysis platform.


In running a department store, the digitalization of customer contact points is incredibly important in improving the customer experience. The Keio Department Store Data Lake, now built on OCI with Autonomous Data Warehouse, gives us an integrated information platform that can analyze all data gathered from customer contact points.

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

Business challenges

One of the major retail complexes at Shinjuku Station in Tokyo, Keio Department Store is core to the retail business of the Keio Group. With eight stores and an online shopping site, the company is one of the premier department stores in Japan. For more than 50 years, the store has offered high-quality, contemporary products, and has always attempted to offer superior customer service.

Recently, Keio Department Store decided to expand its presence online to globally connect with customers through social media, the internet, and email and to develop new businesses.

To build a data-driven, real-time strategic information utilization platform that would allow staff to quickly ascertain customer needs by collecting and managing customer data more easily, the company considered breaking away from its legacy mainframe systems on-premises to further increase customer satisfaction and loyalty by modernizing the data platform.

Why Keio Department Store chose Oracle

Although Keio Department Store considered a number of cloud providers, company leaders were drawn to Oracle Cloud Infrastructure (OCI) and its Autonomous Database because they wouldn’t need to waste time and resources on complex administration and would reap great cost savings.


Oracle Autonomous Data Warehouse serves as the Keio Department Store’s enterprise warehouse and started the Keio Department Store Data Lake, with existing BI tools that were brought to OCI and also integrated with its ERP. This allowed data management, expansion, monitoring, tuning, and backups to all be automated—which cut costs by 30%. Additionally, OCI and its high-availability architecture was another big plus, as it eliminated fears of system outages.

While Keio Department Store’s data grows daily, self-tuning with Oracle’s autonomous cloud database maintains high performance, so there is no worry about performance degradation. The retailer’s current system is very fast, requiring only a few seconds’ response time, even when searching 2 years of data and more than 40 million records.

Sales staffers appreciate that they are now able to reference updated data in real time. Additionally, all transaction details from in-store POS systems are now received instantly, so managers can determine what is going on in a store in a timely manner. Coordination with APIs has dramatically improved business efficiency, and eliminated the manual work that was once required for a gift delivery system.

To strengthen delivery for internet orders, the retailer moved the transactional workloads to Oracle Standard Database Service on OCI.

The cloud databases make data more accessible for store staff to perform a variety of analyses and instantly maximize opportunities for sales. Customers can now check orders and stock availability in near real time during gift-buying seasons for a better shopping experience.


Keio Department Store was able to begin using its new system in just one month, thanks to in-depth services provided by Oracle Partner Ashisuto and the Rapid Start Service for Autonomous Data Warehouse offered by Oracle Consulting.