The Home Depot engaged New Frontiers International, Ltd. to upgrade and expand an Access application used by Store Planning to send data back and forth to AutoCad. The data includes Best Practices data and other data. It must be passed back and forth rapidly, accurately and shared among a large number of users.
The Home Depot had been using this application for three years, but it was in great need of an upgrade and user-proofing. Performance was sluggish, and the user community was dropping data or adding it incorrectly into the database.
NFI's solution was to split the application into two pieces (front-end and back-end), normalize the application, and make the user interface significantly more friendly and faster. More constraints were put on data integrity, and queries, forms and tables have been optimized for performance. Functionality has been increased.
At the same time, the back-end database has been shrunk from a ponderous 260 mb to a streamlined 70 mb file. NFI also implemented security and disaster-recovery methodology. Finally, NFI helped The Home Depot by documenting large parts of the system that had previously been completely undocumented.
Providing the necessary functionality and robust scalability involved the use of database technologies by New Frontiers International. The architecture was based on Access pulled and pushed to Autocad and other large databases such as Oracle and various mainframe systems.
Users are experiencing less stress, shorter production times, and a great deal more flexibility in assembling data for reporting. Store Planning has already seen a decrease of several hours in the time to prepare a store for production, saving possibly millions of dollars for The Home Depot.
Return on Investment
NFI completed the project on budget, but also completed many additional tasks within that budget. Slighly different versions of the application were used for Home Depot Mexico and Home Depot Canada.
"You have done a great job."
The Home Depot
Turner Broadcasting System
Price Waterhouse Coopers/CBRE
Atlantic Southeast Airlines (ASA)