Design scheme of luggage and parcel transportation

2022-10-23
  • Detail

Design scheme of railway baggage and parcel transportation information management system (Part 2)

4.2 main functions of each subsystem

4.2.1 central database

the central database should first choose DB2 or Oracle of IBM to establish a baggage and parcel transportation information data warehouse. These large databases can ensure information security and high availability. For example, the data sharing technology of DB2 database calls a unified logical database management system for any application system or job, updates/queries the same physical database, and makes the application environments work together, share data, and balance load. If the oil pipe breaks, it can meet our requirements to a large extent, and realize the information sharing and exchange between the station subsystem and the train subsystem. At the same time, the establishment of the central database enables customers to "see" their own cargo status at any time, including the specific location of the vehicle transporting the goods, the name, quantity, weight, etc., which not only greatly improves the "transparency" of monitoring, reduces the no-load rate of goods, and makes the best allocation of resources, but also helps customers control costs and improve efficiency by mastering more logistics information

4.2.2 the station subsystem

adopts c/s mode, the server side adopts UNIX or Windows 2000 and other operating systems, and the database adopts Oracle or SQL server and other databases. The client side adopts the operating system above wndows 2000, and the development tools are PowerBuilder or Delphi, etc

in the whole information system, many large enterprises with strong R & D strength in the United States adopt smart tag technology. This technology is called "radio frequency identification card" (RFID). It embeds a chip that can send radio signals in the luggage tag, and it can be fully tracked from the beginning of luggage acceptance. At present, this kind of smart tag costs about 30 cents each, and it is believed that the cost will be greatly reduced through extensive use. In addition, Motorola Corporation of the United States showed a smart tag called bistatix, which uses this technology. This is an electronic tag that can be printed on paper. It uses electrostatic excitation to complete two-way communication and quickly process cargo information. Users can modify and encrypt its data according to the actual situation. Even if the smart tag is torn or wrinkled, it can still read the data in the tag, so it has high reliability and security, and is more advanced than the current popular bar code

the components of different experimental machines are also different. A two-way communication is established between truck drivers and customers in luggage and parcel transportation enterprises, regardless of pick-up and distribution, to achieve a point-to-point, door-to-door single express delivery mode

the wireless channel is adopted for the data communication station car, and the existing TMIS channel is adopted for the station central database

1) carrier system: accept luggage and bags, preprocess relevant information, generate intelligent label information with 24 keywords through corresponding algorithms, and automatically print intelligent luggage and bag transportation labels. Realize luggage and package billing, statistical data reporting, and print smart labels on luggage and package transportation bills

2) automatic storage system: Using RFID and computer technology, rebuild the existing warehouse, install "smart shelf", build an automatic warehouse in an all-round way, and realize the comprehensive tracking of luggage and goods, including when to enter the warehouse, when to move, when to leave the warehouse, etc. The adoption of these new technologies in the transit operation, storage and transshipment of luggage and parcel goods can prevent human errors and theft, and save the transportation time of luggage and parcel. At the same time, in the whole logistics system, timely assist customers to monitor product inventory, so that customers can better balance storage costs from the original starting point of goods to the supply chain flowing to the market or final consumers, help customers improve performance, and realize value-added services for customers

3) loading and unloading system: realize paperless operation of goods in and out of the warehouse by collecting intelligent label information. In the process of loading and unloading, the information system automatically identifies the luggage labels, checks the luggage bills, completes the transformation of luggage transportation status information, and automatically forms the loading plan and the unloading and handover voucher of luggage according to the pre confirmed information of the train. At the same time, for various reasons, if the loading plan is not completed, the information shall be corrected

4) delivery system: realize the charging of luggage arrival delivery, the transformation of luggage transportation status information, and the reporting of statistical data

5) information exchange system: realize dynamic data access, query and communication of station train and station central database

4.2.3 train subsystem

in view of the limitations of luggage car conditions, the equipment adopts a small, technologically mature, fully functional tablet notebook computer that supports wireless network and Bluetooth technology. It adopts c/s mode, integrates server and client, adopts Windows XP operating system, adopts Oracle Personal Edition database, and adopts PowerBuilder or Delphi as development tools

the wireless network is used for data communication to complete the information exchange with the station and the central database

1) loading and unloading system: by collecting intelligent label information, realize paperless loading and unloading operations of station cars and complete the conversion of cargo status information

2) train pre confirmation: realize cargo location management, prepare the unloading plan of the front station, handover certificate, cargo location and cargo loading and unloading information, so that the front station can prepare for operation in advance

3) information exchange system: realize dynamic data access, query and communication of train station and train central database

5 Conclusion

the construction of railway baggage and parcel transportation information management system can draw on the successful experience of TMIS, electronic passenger ticket, automatic train number identification system (ATIS) project construction, and even its central database can be integrated into TMIS to improve the function of TMIS. While the system realizes online transaction processing (OLTP), the system function design should be oriented to online analytical processing (OLAP), provide decision support, and adopt a large number of today's advanced technologies to meet the needs of system operation, realize the whole process real-time tracking of luggage and goods transportation, and maximize the benefits of transportation resources

the above author has put forward his own views on the informatization construction of railway luggage and parcel transportation, aiming to attract jade and hope to communicate with you

author/MA Junning, computer room of Xianyang train depot of Xi'an Railway Branch

Copyright © 2011 JIN SHI