After IRON MAN 2
By Karim Berrah on May 19, 2010
Nice demo of a robot serving a cup of coffe, from a Swiss based engineering company, NOSAKI, I visited last week. This movie is not a fiction (like IRON MAN 2) and is really powered by an Oracle Database.
It's always impressive to have a cup of coffe server by an industrial robot. Start by viewing the video, and then read the details:
In this context, the Oracle Data base is used to store the various status of the asynchronous operations.
An application (left), between the robot (right) and the Database (middle), is used to perform the various actions and take the input from the client (who is asking for a coffee here), and then translate it into various actions stored in the database.
All the assets of a production are also stored in the same database, which allows, for example, to check the inventory status before starting an action (do we have enough capsules before preparing a coffe). Other applications can also use the same shared database, to know what is the inventory status (before ordering other capsules), what are actually the robot(s) doing, ...
The robot is standalone (has his own IP address) and is connected to an ethernet network. He is seens as an independant service from the application. The robot perform the required movements (an generate interpolated path between 3D positions) and provide back status informations from the various sensors (required for real time operations).
The client application use the database to check the various contexts and launch the various real-time operations directly on the robot. The application then use the same database to store the results of the operations.
- The whole solution benefit from the security level of the database
- The real-time features of the robot can be processed later directly from the Database (replay, optimization, accounting, ...)
- The application can be used in interactive mode, or, remotely (networked service)
- Scaling (adding new robots, new types of robots) is done directly on the Database
The same method (database in the middle) has been used by NOSAKI to add credit card authentication, between an ERP and customers to provide online shopping features for various companies. More info by visiting the following link or sending an e-mail to expertises AT nosaki DOT com
Using smartly a Database allowed to add very quickly new features to the ERP, without touching deeply the core ERP.
I'm wondering what would Isaac Asimov think about it ...