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.
