StORES Magazine - February 2006 - (Page 70)

DATA WAREHOUSING Marketing Muscle United States feature the printers, and another 6,000 are installed internation- Catalina ups the targeting ante with ally. T Retailers can also use the service to data warehousing appliance determine which shoppers are defecting from the store, Williams says. Then they can directly communicate promo- BY DEENA M. AMATO-McCOY tions to these shoppers to entice them to come back. hanks to its expertise in processing consumer data and providing The marketing possibilities are endless, customer-specific analysis, Catalina Marketing has become a strate- especially with a database filled with ro- g i c marketing partner for the retail industry. When the company bust volumes of data. In fact, there are expanded its trademark analysis program into an interactive model, 425 billion rows of data in one table however, it quickly became evident that Catalina's legacy data warehouse alone. configuration could no longer support detailed queries across its growing vol- Data volume umes of data. As our [retail] partners continue to In an effort to make the program more By transitioning its traditional OLAP grow their businesses and add stores, interactive, Catalina now enables retail configuration to a more cost-effective they also ask us to expand the volume of partners to submit data online. Now re- data warehouse appliance, Catalina data available to them, Williams says. tailers can query data in real time and achieved faster query speeds and im- To date, our retail partners can access drill down to specific information about proved manageability. By delving into up to two years' worth of transaction their stores, says Eric Williams, execu- consumers' purchase behavior, Catalina data. Catalina's legacy OLAP data tive vice president and CIO for the St. Pe- warehouse was having a tough time enables retailers to foster more effec- tersburg, Fla.-based company. Armed meeting the demand, however. tive, cost-efficient promotions than tra- Relational databases can easily be connected to analysis tools and they can process large volumes of data, Williams says. However, where the challenge lay was in its ability to efficiently handle queries across this large volume of data. Some queries could take seconds, while others could take minutes or more. That is not interactive. In addition to speeding up its queries, Catalina needed a solution that could pro- vide a lower total cost of ownership. Clearly, it is a costly endeavor to manage a database's processor, related software and storage disks. There is also a signifi- Catalina Marketing c a n t cost associated retrieves about 250 million to maintain the system, with the people needed transactions from more Williams says. Labor with this data, they ditional marketing approaches. w o r k with us to than 21,000 grocery stores and maintenance costs Catalina upholds this promise with its each week. create promotions add up, making it quite Retail Direct Online RDOL program. and deliver money- expensive. This service enables retailers to transfer saving coupons. their loyalty card and transaction infor- After some evaluation, Catalina real- ized it would be more cost-efficient to mation directly to Catalina which ana- Retailers can deliver these promotions lyzes this data and creates sophisticated in a variety of ways. Some rely on direct migrate its RDOL operations to a data warehouse appliance integrated with the marketing campaigns for its retail part- mail or e-mail messages; others deliver ners. Catalina Marketing retrieves about company's existing solutions, such as its these coupons at the Catalina coupon 250 million transactions from more than MicroStrategy business intelligence machines placed at retail point-of-sale 21,000 grocery stores each week. units. More than 17,500 stores in the front end. 70 S TO R E S / FEBRUARY 2 0 0 6 W W W. S TO R E S . O R G http://WWW.STORES.ORG

Table of Contents for the Digital Edition of StORES Magazine - February 2006

Contents
Executive Editor's Page
President's Page
UPfRONT
NRF News
Retail People
Concept2Watch
Credit
COVER STORY: Spicing Up Service
In-Store Marketing
Online
Loyalty Programs
Store Redesign
Customer Service
Content Management
Human Resources
Electronic Signage
Supply Chain
Logistics
Channel Compatibility
Data Warehousing
Workplace Law
Loeb Retail Letter
Point of View
Advertising Index
Company Index
Retail Profit Scoreboard
Retail Industry Calendar

StORES Magazine - February 2006

http://www.nxtbook.com/nxtbooks/nrf/STORES2019_tuesday
http://www.nxtbook.com/nxtbooks/nrf/STORES2019_monday
http://www.nxtbook.com/nxtbooks/nrf/STORES2019_sunday
http://www.nxtbook.com/nxtbooks/nrf/STORES2019_preview
http://www.nxtbook.com/nxtbooks/nrf/STORES_bigshowdaily20180116
http://www.nxtbook.com/nxtbooks/nrf/STORES_bigshowdaily20180115
http://www.nxtbook.com/nxtbooks/nrf/STORES_bigshowdaily20180114
http://www.nxtbook.com/nxtbooks/nrf/STORES2018_preview
http://www.nxtbook.com/nxtbooks/nrfe/STORES0415
http://www.nxtbook.com/nxtbooks/nrfe/STORES0315
http://www.nxtbook.com/nxtbooks/nrfe/STORES0215
http://www.nxtbook.com/nxtbooks/nrfe/STORES0115
http://www.nxtbook.com/nxtbooks/nrfe/STORES1214
http://www.nxtbook.com/nxtbooks/nrfe/STORES1114
http://www.nxtbook.com/nxtbooks/nrfe/STORES1014
http://www.nxtbook.com/nxtbooks/nrfe/STORES0914
http://www.nxtbook.com/nxtbooks/nrfe/STORES0814
http://www.nxtbook.com/nxtbooks/nrfe/STORES0714
http://www.nxtbook.com/nxtbooks/nrfe/STORES0614
http://www.nxtbook.com/nxtbooks/nrfe/STORES0514
http://www.nxtbook.com/nxtbooks/nrfe/STORES_sourcebook2014
http://www.nxtbook.com/nxtbooks/nrfe/STORES0414
http://www.nxtbook.com/nxtbooks/nrfe/STORES0314
http://www.nxtbook.com/nxtbooks/nrfe/STORES0214
http://www.nxtbook.com/nxtbooks/nrfe/STORES0114
http://www.nxtbook.com/nxtbooks/nrfe/STORES1213
http://www.nxtbook.com/nxtbooks/nrfe/STORES1113_buyersguide
http://www.nxtbook.com/nxtbooks/nrfe/STORES1113
http://www.nxtbook.com/nxtbooks/nrfe/STORES1013
http://www.nxtbook.com/nxtbooks/nrfe/STORES_mediakit2014
http://www.nxtbook.com/nxtbooks/nrfe/STORES0913
http://www.nxtbook.com/nxtbooks/nrfe/STORES0813
http://www.nxtbook.com/nxtbooks/nrfe/STORES0713
http://www.nxtbook.com/nxtbooks/nrfe/STORES0613
http://www.nxtbook.com/nxtbooks/nrfe/STORES0513
http://www.nxtbook.com/nxtbooks/nrfe/STORES0413
http://www.nxtbook.com/nxtbooks/nrfe/STORES0313
http://www.nxtbook.com/nxtbooks/nrfe/STORES0213
http://www.nxtbook.com/nxtbooks/nrfe/STORES2013_20130115
http://www.nxtbook.com/nxtbooks/nrfe/STORES2013_20130113
http://www.nxtbook.com/nxtbooks/nrfe/STORES2013_20130114
http://www.nxtbook.com/nxtbooks/nrfe/STORES2013_preview
http://www.nxtbook.com/nxtbooks/nrfe/STORES0113
http://www.nxtbook.com/nxtbooks/nrfe/STORES1212
http://www.nxtbook.com/nxtbooks/nrfe/STORES1112
http://www.nxtbook.com/nxtbooks/nrfe/STORES1012
http://www.nxtbook.com/nxtbooks/nrfe/STORES_mediakit2013
http://www.nxtbook.com/nxtbooks/nrfe/STORES0912
http://www.nxtbook.com/nxtbooks/nrfe/STORES0812
http://www.nxtbook.com/nxtbooks/nrfe/STORES0712
http://www.nxtbook.com/nxtbooks/nrfe/STORES0612
http://www.nxtbook.com/nxtbooks/nrfe/STORES0512
http://www.nxtbook.com/nxtbooks/nrfe/STORES0412
http://www.nxtbook.com/nxtbooks/nrfe/STORES0312
http://www.nxtbook.com/nxtbooks/nrfe/STORES0212
http://www.nxtbook.com/nxtbooks/nrfe/STORES2012_preview
http://www.nxtbook.com/nxtbooks/nrfe/STORES0112
http://www.nxtbook.com/nxtbooks/nrfe/STORES1211
http://www.nxtbook.com/nxtbooks/nrfe/STORES1111
http://www.nxtbook.com/nxtbooks/nrfe/STORES1011
http://www.nxtbook.com/nxtbooks/nrfe/STORES_mediakit2012
http://www.nxtbook.com/nxtbooks/nrfe/STORES0911
http://www.nxtbook.com/nxtbooks/nrfe/STORES0811
http://www.nxtbook.com/nxtbooks/nrfe/STORES0711
http://www.nxtbook.com/nxtbooks/nrfe/STORES0611
http://www.nxtbook.com/nxtbooks/nrfe/STORES0511
http://www.nxtbook.com/nxtbooks/nrfe/STORES0411
http://www.nxtbook.com/nxtbooks/nrfe/STORES0311_v2
http://www.nxtbook.com/nxtbooks/nrfe/STORES0311
http://www.nxtbook.com/nxtbooks/nrfe/STORES0211
http://www.nxtbook.com/nxtbooks/nrfe/STORES0111
http://www.nxtbook.com/nxtbooks/nrfe/stores1210
http://www.nxtbook.com/nxtbooks/nrfe/stores_mediakit2011
http://www.nxtbook.com/nxtbooks/nrfe/stores1110
http://www.nxtbook.com/nxtbooks/nrfe/stores1010
http://www.nxtbook.com/nxtbooks/nrfe/stores0910
http://www.nxtbook.com/nxtbooks/nrfe/stores0810
http://www.nxtbook.com/nxtbooks/nrfe/stores0710
http://www.nxtbook.com/nxtbooks/nrfe/stores0610
http://www.nxtbook.com/nxtbooks/nrfe/stores0510
http://www.nxtbook.com/nxtbooks/nrfe/stores0410
http://www.nxtbook.com/nxtbooks/nrfe/stores0310
http://www.nxtbook.com/nxtbooks/nrfe/stores0210
http://www.nxtbook.com/nxtbooks/nrfe/store_bigshow2010_post
http://www.nxtbook.com/nxtbooks/nrfe/stores_bigshow_20100112
http://www.nxtbook.com/nxtbooks/nrfe/stores_bigshow_20100111
http://www.nxtbook.com/nxtbooks/nrfe/stores_bigshow_20100110
http://www.nxtbook.com/nxtbooks/nrfe/stores0110
http://www.nxtbook.com/nxtbooks/nrfe/store_bigshowpreview2010
http://www.nxtbook.com/nxtbooks/nrfe/stores1209
http://www.nxtbook.com/nxtbooks/nrfe/stores1109
http://www.nxtbook.com/nxtbooks/nrfe/stores1009
http://www.nxtbook.com/nxtbooks/nrfe/stores0909
http://www.nxtbook.com/nxtbooks/nrfe/stores0809
http://www.nxtbook.com/nxtbooks/nrfe/stores0709
http://www.nxtbook.com/nxtbooks/nrfe/stores0609
http://www.nxtbook.com/nxtbooks/nrfe/stores0509
http://www.nxtbook.com/nxtbooks/nrfe/stores0409
http://www.nxtbook.com/nxtbooks/nrfe/stores0309
http://www.nxtbook.com/nxtbooks/nrfe/stores0209
http://www.nxtbook.com/nxtbooks/nrfe/stores0109
http://www.nxtbook.com/nxtbooks/nrfe/stores1208
http://www.nxtbook.com/nxtbooks/nrfe/stores1108
http://www.nxtbook.com/nxtbooks/nrfe/stores1008
http://www.nxtbook.com/nxtbooks/nrfe/stores0908
http://www.nxtbook.com/nxtbooks/nrfe/stores0808
http://www.nxtbook.com/nxtbooks/nrfe/stores0708
http://www.nxtbook.com/nxtbooks/nrfe/stores0608
http://www.nxtbook.com/nxtbooks/nrfe/stores0508
http://www.nxtbook.com/nxtbooks/nrfe/stores0408
http://www.nxtbook.com/nxtbooks/nrfe/stores0308
http://www.nxtbook.com/nxtbooks/nrfe/stores0208
http://www.nxtbook.com/nxtbooks/nrfe/stores-globalretail08
http://www.nxtbook.com/nxtbooks/nrfe/stores0108
http://www.nxtbook.com/nxtbooks/nrfe/stores1207
http://www.nxtbook.com/nxtbooks/nrfe/stores1107
http://www.nxtbook.com/nxtbooks/nrfe/stores1007
http://www.nxtbook.com/nxtbooks/nrfe/stores0907
http://www.nxtbook.com/nxtbooks/nrfe/stores0807
http://www.nxtbook.com/nxtbooks/nrfe/stores0707
http://www.nxtbook.com/nxtbooks/nrfe/stores0607
http://www.nxtbook.com/nxtbooks/nrfe/stores0507
http://www.nxtbook.com/nxtbooks/nrfe/stores0407
http://www.nxtbook.com/nxtbooks/nrfe/stores0307
http://www.nxtbook.com/nxtbooks/nrfe/stores0207
http://www.nxtbook.com/nxtbooks/nrfe/stores-globalretail07
http://www.nxtbook.com/nxtbooks/nrfe/stores0107
http://www.nxtbook.com/nxtbooks/nrfe/stores1206
http://www.nxtbook.com/nxtbooks/nrfe/stores1106
http://www.nxtbook.com/nxtbooks/nrfe/stores1006
http://www.nxtbook.com/nxtbooks/nrfe/stores0906
http://www.nxtbook.com/nxtbooks/nrfe/stores0806
http://www.nxtbook.com/nxtbooks/nrfe/stores0706
http://www.nxtbook.com/nxtbooks/nrfe/stores0606
http://www.nxtbook.com/nxtbooks/nrfe/stores0506
http://www.nxtbook.com/nxtbooks/nrfe/stores0406
http://www.nxtbook.com/nxtbooks/nrfe/stores0306
http://www.nxtbook.com/nxtbooks/nrfe/stores0206
http://www.nxtbook.com/nxtbooks/nrfe/stores0106-globalretail
http://www.nxtbook.com/nxtbooks/nrfe/stores0106
http://www.nxtbook.com/nxtbooks/nrfe/stores1205
http://www.nxtbook.com/nxtbooks/nrfe/stores1105
http://www.nxtbookMEDIA.com