Operating from a 430,000 square foot warehouse, Sysco's
refrigerated dock and fleet of 130 trailers and tractors provide
service to 7,000+ accounts running 600 routes per week. Ten years
ago, the company was dispatching its equipment using a
"cards-and-slots" system, but wanted an easy, logical system to
keep track of the drivers who were already dispatched, the ones
that had not been dispatched, and ones who were not available.
Additionally, Sysco needed the ability to have days, weeks,
months - and even years - of history on these drivers, as well as
their equipment and loads.
Release Date: Tuesday, August 03, 2010
Sysco Denver Food Service Company is a wholly owned subsidiary of The Sysco Corporation and is the largest food service distributor in the Rocky Mountain area. Sysco Denver has supplied hotels, motels, restaurants, schools, hospitals and multi-unit accounts with high quality food, supply and equipment items for over 60 years.
Situation
Operating from a 430,000 square foot warehouse, Sysco's refrigerated dock and fleet of 130 trailers and tractors provide service to 7,000+ accounts running 600 routes per week. Ten years ago, the company was dispatching its equipment using a "cards-and-slots" system, but wanted an easy, logical system to keep track of the drivers who were already dispatched, the ones that had not been dispatched, and ones who were not available. Additionally, Sysco needed the ability to have days, weeks, months - and even years - of history on these drivers, as well as their equipment and loads.
Implementation
In just a few months, Sysco Foods of Denver was dispatching its fleet using a multivalued database called UniData from Rocket Software with software from U2logic, Inc. This system had the ability to fulfill the requirements that allowed them to track the hundreds of loads they dispatch every day.
Several years later, U2logic upgraded that software to a Web based product, which used forms featuring Microsoft's IIS server using active server pages built with HTML and JavaScript. The results were phenomenal - Sysco could create reports instantly, and the Web interface was easy to use and required little training.
Benefits
In 2009, the dispatch software was again upgraded. Using open source technology such as Apache Tomcat, json.org, and Eclipse -based programming tools has allowed U2logic to update the interfaces and keep all of the desired functionality with new technologies such as drag-and-drop dispatching. All data entry screens that have grids that can be sorted by any column, and the lookups allow filtering on each column to gradually reduce the lookup when trying to find a specific item. The software runs anywhere from 10% to 700% faster than the previous version using the latest version of UniData database and U2WebLink™ middleware.
About U2Logic
U2logic has been moving forward ever since the Web came to being. From our early attempts at CGI code, to using RedBack IDE, and now to our current AJAX open source approach, U2logic has always been on the fore front of web-based technology. This technology is created for Universe® and Unidata® Rocket Software's U2 databases.
U2logic has been gearing up two main goals:
The first goal is to bring to the IBM U2 databases many of the same tools the rest of the programming world enjoys. U2logic has based its entire tools set on Eclipse. The many products U2logic has developed fill those ancient holes that were part of U2logic beginnings in the early 1980's. U2logic's family of tools is called XLr8.
The second is to create applications that allow users to experience the U2 databases without realizing what database they are using. Beauty is in eye of beholder, that is why our applications are very easy on the eyes. All of our applications, whether data entry or reporting are seamlessly tied to open technologies such as Apache Tomcat, Firefox, Job Scheduling, and AJAX without the user ever knowing it.
For more information, visit http://www.u2logic.com
About UniData
Secure and Available 24 X 7
Tuned for business
The current economic climate demands more from your technology than ever before. While easy-to-use, high-performance solutions have always offered a faster return on investment, they may be a matter of survival today. And for businesses prepared to take advantage of changing times to position themselves for the future, they offer a competitive advantage.
UniData(r) comes into its own at times like these, delivering the capabilities you need to develop, enhance and deploy comprehensive business applications rapidly and with minimal cost.
UniData is an extended relational database ideal for embedding in vertical solutions. It allows multiple nested tables within a table, while maintaining support for ANSI SQL access. Data modeling is more intuitive and fewer tables are created compared with a traditional relational database.
Using UniData, developers can create solutions quickly and easily for a wide variety of markets. The product's real-world approach to application development and deployment minimizes time to market, which in turn saves you money and helps you compete more effectively.
Highlights
- Delivers low TCO and exceptional scalability to meet the challenges of on demand business in the SMB and large enterprise market
- Provides intuitive design and high-performance queries using extended relational data model
- Enables use of standard protocols including ODBC, OLEDB, ADO.NET, JDBC, XML and SOAP
- Supports security and robustness via encryption, authentication and high availability features
- Features native, high performance interfaces for .NET, Java(tm) and more
- Leverages application investment with flexible data storage
For more information, visit http://www.rocketsoftware.com/u2/
Related Articles: