Be the first!
 
 
WhereScape, a provider of a comprehensive integrated development environment (IDE) for data warehousing, has announced that IPC, an independent Subway franchisee-owned and -operated purchasing cooperative, has purchased WhereScape RED to enable the rapid development and deployment of its Microsoft SQL Server-based enterprise data warehouse. The announcement was made at PASS Summit 2009.
 
IPC, headquartered in Miami, is implementing its new SQL Server data warehouse to gain additional business insights from its terabytes of Subway Card processing data, finance and supply chain data in support of Subway's 25,000 restaurants across the United States and Canada.
 
IPC is responsible for procuring all of the Subway food, packaging, equipment and services for the United States and Canada through negotiating price, supply, and distribution terms while improving quality, enhancing competitiveness and ensuring the best value to Subway restaurants and their customers.
 
IPC's enterprise data warehouse consists of several massive modules including card model, store model, finance and supply chain. For example, just one of the activity fact tables contains more than one billion records, with the enterprise data warehouse containing almost two terabytes of data.
 
"The data contained in each of these modules is quite complex, and WhereScape is enabling us to effectively manage that complexity," said Anthony Ronconi, IPC director of information technology.
 
Two major modules ― card model and store model ― have completed testing and have been placed into production. The supply chain module is expected to be in production by year-end, and the finance data will be incorporated into the data warehouse in a multi-phased approach throughout next year.
 
WhereScape RED provides native support for SQL Server as well as IBM DB2, Oracle and Teradata. The same WhereScape integrated development environment is used to build SQL Server data warehouses as well as Analysis Services cubes.

Reader Comments

Add a Comment

We welcome your thoughtful comments. All comments will display your real name.

Want to participate in the discussion?

Or log in for complete access.

  • Clear
  • Post
Be the first to post a comment for this story.
Products & Services

Starmount Systems Digital Media Suite Modules

http://global.networldalliance.com/new/images/products/digitalmediaservices_100.gif

280/Starmount-Systems-Digital-Media-Suite-Modules

Touch Screen Information Kiosk

http://global.networldalliance.com/new/images/products/hsk0802_100.gif

3649/Touch-Screen-Information-Kiosk

Pizza Butler

http://global.networldalliance.com/new/images/products/pizza_butler_logo_150.png

1928/Pizza-Butler

California Milk Advisory Board

http://global.networldalliance.com/new/images/products/CalCheese_Seal_120.jpg

1871/California-Milk-Advisory-Board

TruFlavors Natural Beef Chili with No-Till Pinto Beans

http://global.networldalliance.com/new/images/products/Copy_of_Chili_100_rgb.jpg

1759/TruFlavors-Natural-Beef-Chili-with-No-Till-Pinto-Beans

Baked Cinnamon Fuji Apples

http://global.networldalliance.com/new/images/products/Cinnamon_Apples_100.jpg

1752/Baked-Cinnamon-Fuji-Apples

MonkeyMedia Software

http://global.networldalliance.com/new/images/products/MonkeyMedia_150.jpg

1693/MonkeyMedia-Software

Digital Signage Content - Content Design and Creation

http://global.networldalliance.com/new/images/products/content_5.jpg

130/Digital-Signage-Content-Content-Design-and-Creation

NCR SelfServ Order and Pay

http://global.networldalliance.com/new/images/products/1823.png

1823/NCR-SelfServ-Order-and-Pay

Digital Signage | NEXTEP SYSTEMS

http://global.networldalliance.com/new/images/products/digital_signage.jpg

1475/Digital-Signage-NEXTEP-SYSTEMS

Request Information From Suppliers
Save time looking for suppliers. Complete this form to submit a Request for Information to our entire network of partners.