OLAP Newsletter Customer Feature April 07

Circle K Sunkus operates a 30 Terabyte Data Warehouse built with Oracle Database 10g. Running Oracle Database 10g on Fujitsu's powerful Primequest server, they have more than 10 million data points processed by the Data Warehouse which is available for analysis through Oracle OLAP. Data is gathered from the convenience stores across Japan, and input to the DW daily; merchandisers and supervisors are able to have a company wide view of products, can control stock and recommend new products. The overall solution was implemented quickly and for a low cost. See press releases by Fujitsu and Oracle for further information.

Technical Solution: The central data warehouse is built with Oracle Database 10g. Powered by Oracle OLAP 10g, merchandisers use Discoverer and SQL tools via the Web to analyze trends in sales results. Query times are in seconds, compared to minutes on their old system. Cubes range in model size from 5 to 7 dimensions with around 35 stored measures and millions of records.

About Circle K Sunkus: Circle K Sunkus manages the business activities of stores and franchises of this major convenience store chain in Japan.


View more Oracle OLAP Customer references here


Copyright © 2004, 2007 Oracle. All rights reserved.