Automatic Storage And Retrieval System Working Theory
A server system for use with an automatic storage and retrieval system to allow a
user to perform AS/RS controls, which comprises: at least one control platform, whichallows the user to issue AS/RS commands and access related inventory management data; a main server, which is linked to the automatic storage and retrieval system, for monitoring the automatic storage and retrieval system and controlling the operationof the automatic storage and retrieval system in accordance with the user-issued commands and data from the control platform; an SQL server, which is linked to the main server, for registering the history of user-issued commands to the automatic storageand retrieval system and related AS/RS operating status data; a communication interface, which is connected between the control platform and the main server, for performing direct data transfer between the control platform and the main server; and adistributed component object model (DCOM) module for controlling data exchange among the main server, the SQL server, and the control platform; wherein, due to control by the DCOM module, the data exchange is effected without having to use a QEODBCdriver.
A server system and method is proposed for use with an automatic storage and retrieval system (AS/RS) to allow a user to perform AS/RS controls and access related inventory management data. The proposed AS/RS server system and method is characterized by the use of a point-to-point multiplex communication interface, such as a TCP/IP communication interface, instead of SQL server as in the case of the prior art, for performing data transmission between the control platform and the main server. The SQL server is only used for storing the history of user-issued commands and related AS/RS operating status data. Compared to the prior art, the proposed AS/RS server system and method allows the utilization of DCOM (Distributed Component Object Model) modules for control of the data exchange among the main server, the SQL server, and the control platform, so that it can be implemented without the use of QEODBC drivers, thereby eliminating the problems caused by the use of QEODBC driver in the prior art. In addition, the proposed AS/RS server system and method allows real-time synchronization in the data transmission between the control platform and the automatic storage and retrieval system, thereby making the AS/RS operation more efficient than the prior art.
This invention relates to information technology, and more particularly, to a server system and method for automatic storage and retrieval system (AS/RS) that allows the user to perform AS/RS controls and access related inventory management data.
by: ericfu