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.