STORES Magazine - January 2010 - (Page 51)

NUTS AND BOLTS / DATA MANAGEMENT Busting Bottlenecks Application gives Schnuck Markets faster reporting performance BY DEENA M. AMATO-McCOY etailers improve customer relationships based on the nuggets of information found in each transaction. This data often traverses multiple divisions of the organization – many of which are supported by disparate databases. For Schnuck Markets, a database management system that monitors transactions also supports business analysis and ensures optimal applications performance. R Database applications have steadily expanded and improved as computing systems have evolved, helping keep retailers abreast of the relationship between consumer data and applications’ end-user performance. Due to this expansion of database applications and retailers’ multi-channel operations, corporate databases have evolved into treasure chests of transaction and customer information pertaining to staying on top of daily consumer trends and seasonal business cycles. due to performance issues,” says Lisa Hu, the retailer’s database administrator leader. Rather than reconfigure operations to consolidate data and streamline data flow, it had added solutions that merely improved visibility into siloed data. This caused two issues for Schnucks. First, it could take as long as four hours to create reports. “We needed a way to identify performance or pinpoint when a bottleneck is occurring,” Hu says. “We had no baseline for applica- tions, middleware and databases. While the solution provides insight into how the company’s systems are operating, a lack of historical data made it difficult to determine the source of performance-related issues. “It became apparent we needed to find a way to pinpoint problems and pro-actively find resolutions and fix problems,” Hu says. Overall, what the chain needed was a database and application management solution that could improve the applica- TPM has allowed Schnucks to slash the many hours spent creating reports to a mere 10 minutes, a factor in helping the retailer save on labor costs There is a downside, however: Retail chains continue to struggle with exactly where this data resides and how to access it in an efficient manner. Some organizations operate siloed applications and data storage, a configuration that can be costly to support and from which extracting data can be difficult. St. Louis-based Schnuck Markets relies on its internal data to run regular reports on merchandise forecasts and sales, as well as to analyze results from customer surveys. “These reports could take us hours, even days, to complete, WWW.STORES.ORG tion or database performance. We would know performance was declining, but had nothing to compare it to.” Worse, this caused the chain to be reactionary when addressing performance issues of its computing and storage systems. Schnucks operates a UNIX box that supports multiple databases. It was outfitted with the Oracle Enterprise Manager solution, an application management system that monitors the health and performance of application processes and components, including applica- tion development process – a foundation that would allow Schnucks to support operations, best serve shoppers and build profits. More specifically, the ideal solution had to provide insight into historical data and previous performance activities and issues. “We didn’t want to write a lot of code to remediate solutions,” Hu says. “That would be horrible from a cost and labor standpoint. We wanted an out-of-thebox solution that could easily find indexes for poorly-written SQL (structured query language).” Schnucks chose STORES / JANUARY 2010 51 http://WWW.STORES.ORG

Table of Contents for the Digital Edition of STORES Magazine - January 2010

STORES Magazine - January 2010
Contents
Editor's Page
President’s Page
Retail People
Marketing
CEO Profile
20 Ideas Worth Stealing
Concept2Watch
Digital Coupons
Customer Loyalty
CRM
Labor Scheduling
Online
Data Management
Human Resources
Retail Fraud
Policy
Security
Loeb Retail Letter
ARTS Update
NRF News
Point of View
Retail Industry Calendar
End Cap
Global Powers of Retailing

STORES Magazine - January 2010

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