Wal-Mart partnered with NCR in 1997 to dramatically increase the size and information analysis capabilities of its data warehouse by adding new customer preferences data.
As part of the contract, NCR supplied a WorldMark(TM) 5100M massively parallel processing (MPP) server and upgraded a second installed NCR 5100M from 32 to 96 nodes. The contract also covered NCR professional services, including database design, data transformation and data management, as well as maintenance.
The two WorldMark 5100M servers -- running NCR's Teredata(TM) relational database management system (RDBMS) -- tripled the size of Wal-Mart's existing data warehouse from 7.5 terabytes to over 24 terabytes.
With the increased capacity, Wal-Mart retained its position of having the `world's largest commercial data warehouse,' with more than 30 applications running on the system and handling as many as 50,000 queries in one week.
"This expansion is part of Wal-Mart's drive to deliver what its customers want: the right item, at the right store, at the right time and at the right price," said Randy Mott, senior vice president and chief information officer for Wal-Mart. "It's the ultimate form of customer service."
"Our business strategy depends on detailed data at every level," Mott explained. "Every cost, every line item is carefully analyzed, enabling better merchandising decisions to be made on a daily basis. It is the foundation for maintaining Wal-Mart's competitive edge and its continuing success in providing everyday low prices and superior customer satisfaction."
That competitive edge and commitment to customer satisfaction is underscored by the unique aspects in Wal-Mart's implementation. For example, although Wal-Mart's data warehouse incorporates information on a nationwide basis, that information can be tailored by store to allow merchandise buyers to gain insight into local purchasing patterns.
"Our extended partnership with Wal-Mart is another significant milestone for NCR," said Bill Eisenman, senior vice president of NCR's Computer Systems Group. "It underscores NCR's commitment to customer service -- as it does Wal-Mart's -- and NCR's expertise in building very large data warehouses to support complex customer information and decision-support systems."
Information stored in the data warehouse -- which is collected from the retailer's 2,900 stores -- will be used to enhance Wal-Mart's Decision Support System, particularly for the retailer's rapidly growing chain of Supercenters and Wal-Mart International units. Using the 65 weeks of data kept by item/by store/by day, Wal-Mart buyers and vendors can query and analyze information to make informed decisions on replenishment, look at customer buying trends around the world, analyze seasonal buying trends, make mark-down decisions, and react to merchandise volume and movement at any time.
The NCR WorldMark servers were installed and upgraded by mid-97. One system is configured with 32 nodes, 256 Pentium Pro 200 processors and 8 terabytes of storage; the second server will be upgraded to 96 nodes, 768 Pentium Pro 200 processors and 16 terabytes of storage. For more historical information, read the press release from January 9, 1995 announcing "Wal-Mart buys world's largest decision-support system from AT&T".
Wal-Mart (
) also implemented a Strategic Decision Support System called Retail Link. It is an example of an Inter-organizational DSS. Managers at Wal-Mart felt that by integrating their processes and information flows with their suppliers they would bind the suppliers to their organization, resulting in improved revenues for both parties.
In 1991, Wal-Mart launched Retail Link which allows Wal-Mart to collect sales data from various stores, consolidate it into useful reports, and distribute it to suppliers with weekly forecasting information. In addition to forecasting information, suppliers get electronic order forms that help ensure there is an adequate supply of the items that Wal-Mart needs. This system used existing electronic data interchange (EDI) and satellite technologies to create a competitive advantage that other retailer’s have tried to mimic but none have replicated. The result of Retail Link is less inventory in stores, more inventory of the right products at the right time and place, improved revenues for both supplier and retailer, and better partner relationships with suppliers.
In 1998, Wal-Mart and Warner-Lambert began using the Internet to communicate interactively about sales forecasts. They have reduced the time a product is in the supply chain by 2 1/2 weeks. That translates into millions of dollars in reduced inventory. Check on the Collaborative Forecasting and Replenishment Initiative (CFAR) website at
Well-known as the world's largest retailer, Wal-Mart had annual revenues of over $104.4 billion for the year ending Jan. 31, 1997, and has more than 2,900 stores and over 700,000 employees. Based in Bentonville, Arkansas, it has pioneered concepts such as Supercenters and its SAM's Club, which is a members-only shopping club that carries products at wholesale prices. A highly successful offshoot of Wal-Mart's traditional retail stores, SAM's Clubs comprise 20 percent of Wal-Mart's business.
More information about Wal-Mart can be found on the World Wide Web at: