Query Processing of RFID Data with Object Trajectory in Manufacture and Logistics

Abstract:

In the domain of manufacture and logistics, Radio Frequency Identification (RFID) holds the promise of real-time identifying, locating, tracking and monitoring physical objects without line of sight due to an enhanced efficiency, accuracy, and preciseness of object identification, and can be used for a wide range of pervasive computing applications. To achieve these goals, RFID data has to be collected, filtered, and transformed into semantic application data. However, the amount of RFID data is huge. Therefore, it requires much time to extract valuable information from RFID data for object tracing. This paper specifically explores options for modeling and utilizing RFID data set by XML-encoding for tracking queries and path oriented queries. We then propose a method which translates the queries to SQL queries. Based on the XML-encoding scheme, we devise a storage scheme to process tracking queries and path oriented queries efficiently. Finally, we realize the method by programming in a software system for manufacture and logistics laboratory. The system shows that our approach can process the tracing or path queries efficiently.

• Periodical: Applied Mechanics and Materials (Volumes 16-19)
• Pages: 1043-1047
• DOI: https://doi.org/10.4028/www.scientific.net/AMM.16-19.1043
• Online since: October 2009
• Authors: Sun Wei, Li Hua Dong, Yao Hua Dong
• Keywords: Logistic, Manufacture, Query Processing, Radio Frequency Identification (RFID), Track, XML Encoding Scheme

References

[1] F.S. Wang, S.R. Liu, P.Y. Liu, and Y.J. Bai: Proc. 10PthP International Conference on Extending Database Technology (Munich, Germany, March 26-31, 2006), Vol. 3896, pp.588-607.

[2] J. Widom and S. Ceri: Active Database Systems: Triggers and Rules For Advanced Database Processing. (Morgan Kaufmann, 1996).

[3] X. Wu, M.L. Lee, and W. Hsu: International Conference on Data Engineering (Boston, USA, March 30-April 2, 2004), pp.66-78.

[4] J. Han, H. Gonzalez, X. Li and D. Klabjan: Proc. International Conference on Data Engineering (Atlanta, GA, April 3-8, 2006), pp.1-18.

[5] Y. Bai, F. Wang, P. Liu and S. Liu: Proc. International Conference on Data Engineering (Istanbul, Turkey, April 17-20, 2007), pp.1184-1193.

[6] Y. Bai, F. Wang and P. Liu: International VLDB Workshop on Clean Databases (Seoul, Korea, September 11, 2006), pp.50-57.

[7] C.H. Lee and C.W. Chung: Proc. the ACM SIGMOD International Conference on Management of Data (Vancouver, Canada, June 9-12, 2008), pp.291-302.

[8] Y. Lu, L. Zhang, W. Wang, B. Zhang and B.L. Shi: Journal of Computer Research and Development, Vol. 41 (2004) No. 3, pp.500-503. (In Chinese).

[9] J. Ulrych: Week of Doctoral Students Contributed Papers (Prague, American, June 3-6, 2008), pp.218-223.