Actian Case Studies C&K Market Rings Up Business with Actian Open Source

Edit This Case Study Record

	C&K Market Rings Up Business with Actian Open Source Actian

C&K Market Rings Up Business with Actian Open Source

Actian

Technology Category	Application Infrastructure & Middleware - Database Management & Storage
Applicable Industries	Retail
Applicable Functions	Business Operation Sales & Marketing
Use Cases	Inventory Management Supply Chain Visibility
Services	System Integration
Challenge	C&K Market, a supermarket chain servicing Oregon and Northern California, was facing the need to transition from its legacy VMS platform to a new platform. The company wanted to adopt an open source database solution to take advantage of improved efficiencies, scalability, and low total cost of ownership. The company had been running Ingres on a VMS platform, which was being phased out. The efficient reporting and analysis of pricing and inventory – and effective control of costs – was all enabled through the Ingres Database, an enterprise open source database. Read More
About Customer	C&K Market Inc. is a well-known supermarket chain servicing Oregon and Northern California customers. The company has grown in 20 years from three stores to 60, with Ingres supporting it all the way. The retailer’s recent migration to the open source version of the Ingres Database registers with C&K Market by giving the company access to the wealth of knowledge in the open source community and a low total cost of ownership. In addition, the scalability, 24x7 availability, and enterprise-strength applications help keep the store in check, with customers happy and returning to shop again and again. Read More
Solution	C&K Market decided to migrate to the Actian Ingres open source database running Linux. Using the Ingres ABF development tool, C&K Market created a wide range of mission-critical applications, such as inventory, financial, and human resources – all built on the Ingres Database. The company now uses Ingres as the central data source for mission-critical applications across its 60 stores. A wide variety of end users tap into the database, from manual data entry clerks to people at the stores maintaining pricing to corporate control pricing to payroll and financial analysts accessing information. Read More Log in to view content
Contents

Technology Category

Application Infrastructure & Middleware - Database Management & Storage

Applicable Industries

Retail

Applicable Functions

Business Operation

Sales & Marketing

Use Cases

Inventory Management

Supply Chain Visibility

Services

System Integration

Challenge

C&K Market, a supermarket chain servicing Oregon and Northern California, was facing the need to transition from its legacy VMS platform to a new platform. The company wanted to adopt an open source database solution to take advantage of improved efficiencies, scalability, and low total cost of ownership. The company had been running Ingres on a VMS platform, which was being phased out. The efficient reporting and analysis of pricing and inventory – and effective control of costs – was all enabled through the Ingres Database, an enterprise open source database.

About Customer

C&K Market Inc. is a well-known supermarket chain servicing Oregon and Northern California customers. The company has grown in 20 years from three stores to 60, with Ingres supporting it all the way. The retailer’s recent migration to the open source version of the Ingres Database registers with C&K Market by giving the company access to the wealth of knowledge in the open source community and a low total cost of ownership. In addition, the scalability, 24x7 availability, and enterprise-strength applications help keep the store in check, with customers happy and returning to shop again and again.

Solution

C&K Market decided to migrate to the Actian Ingres open source database running Linux. Using the Ingres ABF development tool, C&K Market created a wide range of mission-critical applications, such as inventory, financial, and human resources – all built on the Ingres Database. The company now uses Ingres as the central data source for mission-critical applications across its 60 stores. A wide variety of end users tap into the database, from manual data entry clerks to people at the stores maintaining pricing to corporate control pricing to payroll and financial analysts accessing information.

Impact #1	In moving to the Ingres open source database, C&K Market expects to leverage the benefits of the open source model, including cost savings and integration with other open source applications, such as graphical reporting tools.
Impact #2	Access to the open source development community will enhance C&K Market’s own development team, extending its development resources while enabling the four-person team to focus on requests from across the C&K Market chain of stores.

Impact #1

In moving to the Ingres open source database, C&K Market expects to leverage the benefits of the open source model, including cost savings and integration with other open source applications, such as graphical reporting tools.

Impact #2

Access to the open source development community will enhance C&K Market’s own development team, extending its development resources while enabling the four-person team to focus on requests from across the C&K Market chain of stores.

Benefit #1	In the corporate office, about 80 people access the database on a near daily basis, for payroll, accounts payable, and other applications.
Benefit #2	At store levels, users can get into the pricing system that’s also built on Ingres –about 200 people at any given time.

Benefit #1

In the corporate office, about 80 people access the database on a near daily basis, for payroll, accounts payable, and other applications.

Benefit #2

At store levels, users can get into the pricing system that’s also built on Ingres –about 200 people at any given time.

Download PDF Version

Overview

C&K Market Rings Up Business with Actian Open Source

Operational Impact

Quantitative Benefit