As a TMS cloud services provider, we continuously update our infrastructure to enable the stable performance of the inet TMS in spite of the increasing number of transactions. This is no easy task if one bears in mind that between October 2013 and October 2016 the number of daily transactions in the transport management solution alone increased from 550 000 to over 1 000 000.
Transactions, meaning the interaction with the inet application via the browser –in very simple terms almost every click in the inet TMS– and their processing, always require storage space. To stop increasing numbers of transactions from causing extended response times, which prevents rapid, convenient working with our platform, 2016 has been the year that we focused on our databases.
The highlight of the initiative was the migration of all the databases to the Exadata system from Oracle. With this technology it has been possible to increase the performance in the data warehousing and the OLTP applications (Online Transaction Processing) to considerable effect.
If a customer uses a function in the inet TMS, on the one hand, the required data is initialized in the background while on the other, so-called Business Logics are recalculated (meaning the rules on how the data is to be used to solve the current task). Both factors require performance and time. “The changeover of all the databases mean they now response twice as quickly as before” explains Head of Service Management Rene Leimegge proudly, before adding: “That doesn't mean all users can work twice as quickly, though, because this depends on whether the function has to query a lot of data or a lot of Business Logic has to be calculated. In general, however, all of the users have benefited from the migration and will continue to do so over the years to come.”