| | | Success Story: Doutor Coffee, one of the largest coffee shop chains in Japan, has implemented its computer system with GeneXus |
|
It’s a mission-critical system for delivering goods throughout the entire Doutor Coffee chain. |
Reasons for choosing GeneXus Implementation of a long-term life cycle system When changing from proprietary systems to open source, the system’s life cycle is negatively impacted. Therefore, mission-critical applications are affected when upgrading the OS and middleware. Copyright 2007 Doutor Coffee Co., Ltd.All rights reserved. That is to say, every time the hardware, OS or middleware are upgraded or changed, applications have to be changed as well (security patches may have to be applied). This process is said to be synonymous with running unnecessary risks and paying the extra cost. GeneXus has been selected to provide an optimum solution to this issue. In this context, applications can be built regardless of the hardware, operating system and middleware environment. GeneXus makes system updates generally available, thus significantly reducing the cost associated with the system’s life cycle. Performance improvement of critical systems In this mission-critical system, the delivery of goods throughout the entire Doutor Coffee shop chain cannot be achieved without the system backbone. The reason is that it includes several subsystems to execute batch processing of data on orders, earnings, sales, entry and exit of materials, and payments. Covering daily orders in detail, about 300,000 online entries are performed. The system also includes a query to be read from tables of 150 million records and in connection with tables loaded with batch processes. In addition, there are several tables containing millions of records, which made it necessary to improve the system’s performance. To solve this problem, Doutor Coffee optimized the system’s navigation with the GeneXus development team. Processing time results were compared in parallel to the operation period of the system described, and the findings were as follows: It took about two hours to perform the tasks of extracting all invoices (sales) corresponding to 3,000 clients and generating a report for each client on the existing system. On the other hand, GeneXus was able to complete these tasks (following the same process) in only 23 minutes. Since this system was completed and a full transition to the new system was performed in the spring of 2010, it has become completely independent from the legacy systems. |
| | | | | | | | |
| |