Roadway Drives Legacy Apps Onto the Web

Linda Rosencrance   Today’s Top Stories    or  Other Internet Business Stories  

Six Support Issues That Keep Execs Awake at Night Sign up to receive Security Resource Alerts

April 08, 2002 (Computerworld) -- Information technology managers at Roadway Express Inc. knew that the "green screen" interfaces in mainframe programs and the HTML used in Web site design don't mix very easily.

So when the Akron, Ohio-based trucking company decided to make its enterprise legacy database management system accessible to users through a browser-based interface, its IT managers planned their strategy carefully.

"We felt that our system, the CCA Model 204 database, was perfectly capable of handling the demand from the world at large," says Gary Bailey, manager of applications development at Roadway. The goal was to develop an access point for users trying to connect from outside the corporate hub.

"The key was how to maximize the investment we had in the system—not reinventing the system, but reusing it," Bailey says.

Everything the company knows about each shipment, including payment status, is run off one IBM mainframe application, Computer Corporation of America's (CCA) Model 204. Roadway has centralized its entire business on this transaction-based enterprise database since 1988.

Built in the 1960s, the Model 204 industrial-strength software runs on IBM's OS/390 operating system and compatible mainframe systems. It can perform query and transaction processing on MVS, virtual machine and virtual extended storage systems. The software is also designed to allow rapid access to large-scale databases and to support parallel processing with a multiprocessor option. Model 204 is used by customers with terabytes of data and thousands of concurrent online users, according to Framingham, Mass.-based CCA.

Model 204 stores all of Roadway's mission-critical freight operations data, including customer, dispatch, freight shipment, billing, shipment tracking, invoicing and computerized rate information, according to the company. The system tracks more than 9 million shipments, houses 500,000 customer records and processes more than 2 million transactions per day. Roadway handles 65,000 shipments every day using Model 204. The trick for the company was finding a way to connect the database to Unix workstations from Sun Microsystems Inc. The workstations run Roadway's nondatabase applications, including its Web applications.

Hoping it wouldn't take long to teach experienced coders new tricks, the company decided to train its mainframe programmers in HTML.

The next step was for Roadway's mainframe programmers and its Web design group to build a system that allows Internet users to directly access the mainframe application to schedule and track shipments.

By eliminating middleware on the mainframe, the development team ensured that Roadway's legacy applications would continue to process up to 1,800 transactions per second.

Installing Janus Web Server from Sirius Software Inc. in Cambridge, Mass., on top of Model 204 "allowed us to reuse our existing transportation management systems and administrative systems, such as invoicing and reporting, without having to rewrite our suite of applications," says Dave Pavlich, director of e-commerce technologies and applications development at Roadway. "Janus Web allows us to extend our existing applications written in M204 user language to browser-based presentation layers."

Seamless Links

Pavlich described the way the system works: The proxy server simply delivers HTTP requests to the Janus Web server and then returns HTTP output to users' browsers, without incurring the cost of writing or buying middleware that would sit between the proxy and the mainframe. The system saved Roadway the expense of writing applications that run on its front-end Web servers or proxy servers, he says.

"Our approach saved us time and money in the initial development of My.Roadway.com." Pavlich says. "We did not have to replicate our databases, and we were able to use existing IT staff to build Web-based applications."

The link between the mainframe and Unix platforms is so seamless that users have no idea they're plugged into a technology Roadway has used for more than 14 years, according to the company. Moreover, the cost to Roadway of creating Web access was low—less than $1 million.

Roadway's customers seem to be satisfied with the results.

"This is a value-added [service] for us," says Paul Blissenbach, transportation manager at Coldwater Creek Inc., a Sandpoint, Idaho-based multichannel retailer of women's apparel, gifts, jewelry, home goods and accessories. "It gives us the ability to generate reports on our inbound and outbound shipments. Our transportation department needs to ensure that our merchandise is coming in on time and whether our vendor companies are complying with our routing instructions."

T.J. Johnson, manager of transportation at Freeman Transportation in Dallas, says, "No [carrier's] Web site is as sophisticated as Roadway's. That's one of the reasons we've retained Roadway."

Donald Broughton, an analyst at A.G. Edwards & Sons Inc. in St. Louis, agrees that Roadway is offering its customers more value for their money. But, he says, other carriers such as Yellow Corp. in Overland Park, Kan., and ABF Freight System Inc. in Fort Smith, Ark., offer similar services. And more companies should follow suit if they want to stay competitive, he adds.

"Everyone not doing it will be left behind," Broughton says.

Roadway’s Route to the Web

Print this Story

Send Us Feedback

E-mail this Story

Digg this Story

Slashdot this Story

"Treehugger had a brilliant piece a few weeks about the..." Read more... "It's IT Blogwatch: in which Carl Icahn tag-teams with Steve Ballmer in the fight for control of Yahoo! Not to..." Read more... Read more E-Business & Web 2.0 posts or See all Blogs

DNS hole prompts synchronized patching effort by IT vendors Microsoft plugs nine holes in Windows, DNS, SQL Symantec warns of new Word attack More top stories...

Microsoft sets XP SP3 automatic download for Thursday Don't give Google a free pass on data collection, privacy advocates say after YouTube ruling XP SP3 to reach most users 'shortly,' says Microsoft

This old laptop: Revitalizing an aging notebook on the cheap All it takes is a couple hours and about $125 to breathe new life into an old laptop. Here's how. Bill Gates moves on Is Microsoft's Golden Age over? What are Gates' most memorable quotes? Find out in Computerworld's complete coverage of the end of the Bill Gates era at Microsoft. Five things you should never tell your boss There are some things your CIO definitely doesn't want to hear. Also don't miss the flipside, Five things you should always tell your boss. Hands-On: Firefox 3 fixes what's broke and keeps what's right With its latest version, Mozilla's browser continues to raise the bar for what Web browsers should be. Windows Vista A to Z Reviews, analyses, how-tos, visual tours, hot issues and predictions about Microsoft's new OS. More Continuing Coverage After 9/11: Homeland SecurityAsk a Premier 100 IT LeaderBlackBerry Legal BattleData Security BreachesElectronic VotingFirefoxH-1B VisasHP's Boardroom ScandalHandheld DevicesHurricane Katrina AftermathMicrosoft Legal IssuesMicrosoft's VistaOpen SourceRFID TechnologySCO's Linux FightSarbanes-Oxley ActSpamVoice Over IPWi-FiWindows Meta File VulnerabilityWindows XP Service Pack 3 IT Careers 2010 Four years from now, the IT field will be a vastly different place. Will you be ready? More Special Reports Premier 100 IT Leaders 2007 Best in Class2006 Computerworld Horizon Awards2006 Premier 100 IT Leaders2006 Salary Survey2007 Best Places to Work in IT2007 IT Forecast2007 Premier 100 IT Leaders40 Years of ComputerworldASPs, Take TwoBest Places to Work in IT 2003Best Places to Work in IT 2004Best Places to Work in IT 2005Best Places to Work in IT 2006Business Intelligence Home RunsBusiness Intelligence: Smarter BIBusiness Intelligence: The Future of BICRM Goes VerticalCRM: Sober CRMCareer Planning Guide 2005Careers: IT Profession 2010Computerworld Horizon Awards 2005Data Management: Mining for GemsData Management: Taming Data ChaosDevelopment: Hard-Workin' Web SitesDevelopment: New Tools New ChoicesDevelopment: The New World of Application DevelopmentDevelopment: The Web Services TsunamiDevelopment: Web Services HurdlesDisaster Recovery: Preparing for the WorstE-commerce Grows UpE-mail/Groupware: Big DecisionsFaces of Mobile ITForecast 2006Global MobileHardware: Multiple Cores, Multiple ChallengesHardware: On-Demand Un-HypedHardware: The Shape of Things to ComeHorizon Awards: 10 Cool Cutting Edge TechnologiesIT Management: Guide to Managing VendorsIT Management: Navigating Global ITIT Management: Recovery AheadIT Management: The Future of ITIT Management: The Resourceful Project ManagerInnovative Technology Awards 2004Management: Reinventing ITMicrosoft in TransitionMobile/Wireless Leaders and LaggardsMobile/Wireless: The Untethered WorkerMobile/Wireless: Tiny Gadgets, Huge CostsNetwork Management: Taking ControlNetworking: Turbulence Ahead!Networking: VoIP Goes MainstreamOperating Systems: In the Slow LaneOperating Systems: Linux Goes GlobalOperating Systems: Should You Nix Unix?Outsourcing: Offshore Buyer's GuideOutsourcing: Outsourcing DangersPremier 100 IT Leaders 2004 Best in ClassPremier 100 IT Leaders 2005 Best in ClassROI: Do the Math!Salary Survey 2003Salary Survey 2004Salary Survey 2005Security Action PlanSecurity: Compliance HeadachesSecurity: Proactive SecuritySecurity: Risk and RewardSecurity: Tips From Security ProsSouped-up SecurityStorage: Battling ComplexityStorage: Cheap & Secure Data StoresStorage: Stretching Your Storage DollarsStorage: The Lean Storage MachineStorage: The New Rules of StorageStorage: The Ultimate Backup GuideSupply Chain: Missing LinksSupply Chain: RFID Reality CheckThe Business of SecurityWeb 2.0 SecurityWireless: Wireless At Work All Zones Application Performance Zone Business Continuity Zone Data Center Management Zone Enterprise-Class Security Zone The File Data Management Zone Grid Computing on Windows Zone Security Management Zone ITIL Best Practices Zone The SAS Zone Storage Virtualization Zone Business Intelligence and Analytics Zone See your link here

Bringing Order and Security to your Mobile Workforce: Corporate Mobility Policy and Device Management Bringing Order and Security to your Mobile Workforce: Corporate Mobility Policy and Device Management LIVE WEBCAST This webcast will air on Thursday, May 8th. Go to the webcast  Adventist Health Improves Document Access with Single Supplier Solution Download this white paper, free, compliments of Kodak! (Source: Kodak) Until 2003, Adventist Health System- headquartered in Orlando, FL-relied on a paper-based filing system to manage medical records. The not-for-profit healthcare system, with over 45,000 employees, wanted to improve access to patient records at all of its 40 hospitals in 10 states. And when they transitioned to an electronic medical records system, the organization wanted to work with the best one-vendor solution for scanners. Download this white paper  Computerworld Technology Briefing: Meetings @ the Speed of Business Download this Technology Briefing now, compliments of Microsoft! (Source: Microsoft) For large organizations, Web conferencing gives a major boost to collaboration among far-flung offices. For smaller companies, experts say Web conferencing is no longer a luxury but a necessity for everything from webinars to customer presentations. But the real value lies in saving soft costs and in increases in productivity. Download this executive briefing  White Papers Read up on the latest ideas and technologies from companies that sell hardware, software and services. Virtualization Analysis for VMware A Guide to Understanding Messaging Archiving Archiving Compliance with Sunbelt Exchange Archiver View more whitepapers

• DNS hole prompts synchronized patching effort by IT vendors
• Microsoft plugs nine holes in Windows, DNS, SQL
• Symantec warns of new Word attack
• More top stories 

Computerworld Technology Briefing: Meetings @ the Speed of Business For large organizations, Web conferencing gives a major boost to collaboration among far-flung offices. For smaller companies, experts say Web conferencing is no longer a luxury but a necessity for everything from webinars to customer presentations. But the real value lies in saving soft costs and in increases in productivity. Download this briefing

Columnist Bert Latamore digs deep to analyze the latest networking trends. Click here to read the latest column by Bert Latamore

Accelerate your pursuit of perfection For almost 80 years, Kodak has been helping banks, insurance companies, healthcare providers, government agencies and other businesses produce billions of document images. So Kodak is uniquely positioned to know and deliver–what customers want: easy-to-use scanners that output the best possible image quality. Download this white paper now!