RFID Event Data Processing: An Architecture for Storing and Searching

Matthieu-P. Schapranow, Jürgen Müller, Alexander Zeier, Hasso Plattner

Abstract

The pharmaceutical industry suffers from increasing counterfeit rates. U.S. federal restrictions force manufacturers to guarantee product authenticity. RFIDtechnology can be used as foundation for an integer and counterfeit-resistant pharmaceutical supply chain. We present an architecture optimized for storing and searching of pharmaceutical RFIDdata and share results of our main-memorybased prototype.

References

  1. IP Crime Group: IP Crime Report (2008)
  2. European Commission Taxation and Customs Union: Report on EU Customs Enforcement of IP Rights (2009)
  3. ICC Policy Statement: The Fight against Piracy and Counterfeiting of Intellectual Property. http://www.iccwbo.org/home/intellectual property/fight against piracy.pdfMar. 8, 2010 (2003)
  4. Staake, T., Thiesse, F., Fleisch, E.: Extending the EPC Network: The Potential of RFID in Anti-Counterfeiting. In: Proc. of the ACM Symposium on Applied Computing, New York, NY, USA, ACM (2005) 1607-1612
  5. Müller, J., P öpke, C., Urbat, M., Zeier, A., Plattner, H.: A Simulation of the Pharmaceutical Supply Chain to Provide Realistic Test Data. In: Proc. of the Internattional Conference on Advances in Syst. Simulation. (2009)
  6. Bundesverband Informationswirtschaft, Telekommunikation und neue Medien: White Paper RFID Technologie, Systeme und Anwendungen (2005)
  7. Schapranow, M. P., Müller, J., Zeier, A., Plattner, H.: Security Aspects in Vulnerable RFIDAided Supply Chains. In: Proc. of the 5th European Workshop on RFID Syst. and Technologies. (2009)
  8. Stiehler, A., Wichmann, T.: RFID im Pharma- und Gesundheitssektor. Vision und Realität RFID-basierter Netzwerke für Medikamente. Berlecon Report (2005)
  9. White, G., et al.: A Comparison of Barcode and RFID Technologies in Practice. Journal of Inf., Inf. Technology, and Organizations 2 (2007)
  10. Müller, J., Schapranow, M. P., Helmich, M., Enderlein, S., Zeier, A.: RFID Middleware as a Service - Enabling Small and Medium-sized Enterprises to Participate in the EPC Network. In: Proc. of the 16th Int'l Conference on Ind. Eng. and Eng. Mgmt. Volume 2. (2009) 2040- 2043
  11. Wang, F., Liu, S., Liu, P., Bai, Y.: Bridging Physical and Virtual Worlds: Complex Event Processing for RFID Data Streams. In: Advances in Database Technology. Volume 3896/2006., Springer Berlin / Heidelberg (2006) 588-607
  12. Fazzinga, B., Flesca, S., Masciari, E., Furfaro, F.: Efficient and effective RFID data warehousing. In: Proc. of the Int'l Database Eng. Applications Symposium, New York, NY, USA, ACM (2009) 251-258
  13. Bai, Y., et al.: RFID Data Processing with a Data Stream Query Language. In: Proc. of the 23rd Int'l Conference on Data Eng. (2007) 1184-1193
  14. Lee, C. H., Chung, C.W.: Efficient Storage Scheme and Query Processing for Supply Chain Management using RFID. In: Proc. of the Int'l Conference on Management of Data, New York, NY, USA, ACM (2008) 291-302
  15. Cheung, A., Kailing, K., Schönauer, S.: Theseos: A Query Engine for Traceability across Sovereign, Distributed RFID Databases. In: ICDE, IEEE (2007) 1495-1496
  16. Chawathe, S. S., Krishnamurthy, V., Ramachandran, S., Sarma, S.: Managing RFID Data. In: Proc. of the 30th Conference on Very Large Data Bases, Toronto, Canada, VLDB Endowment (2004) 1189-1195
  17. Mockapetris, P., Dunlap, K. J.: Development of the Domain Name System. SIGCOMM Comput. Commun. Rev. 25 (1995) 112-122
  18. Müller, J., Oberst, J., Wehrmeyer, S., Witt, J., Zeier, A.: An Aggregating Discovery Service for the EPCglobal Network. In: Proc. of the 43th Hawai'i Conference on Syst. Sci., Koloa, Hawaii, USA (2010)
  19. Bai, Y., Wang, F., Liu, P.: Efficiently Filtering RFID Data Streams. In: CleanDB, Seoul, Korea (2006)
  20. Gonzalez, H., Han, J., Li, X., Klabjan, D.: Warehousing and Analyzing Massive RFID Data Sets. In: Proc. of the 22nd Int'l Conference on Data Eng., Washington, DC, USA (2006) 83
  21. Wang, F., Liu, P.: Temporal Mgmt. of RFID data. In: Proc. of the 31st Int'l Conference on Very Large Data Bases, Norway, VLDB Endowment (2005)
  22. Dean, J., Ghemawat, S.: MapReduce: Simplified Data Processing on Large Clusters. Commun. ACM 51 (2008) 107-113
  23. Stallings, W.: Data and Computer Communications. 8 edn. Prentice Hall (2007)
  24. Schaffner, J., Bog, A., Krüger, J., Zeier, A.: A Hybrid Row-Column OLTP Database Architecture for Operational Reporting. In: Business Intelligence for the Real Time Enterprise, Auckland, New Zealand (2008)
  25. EPCGlobal: EPCIS Standard 1.0.1. http://www.epcglobalinc.org/standards/epcis/epcis 1 0 1- standard-20070921.pdfMar. 8, 2010 (2007)
  26. EPCGlobal: Tag Data Standard 1.4. http://www.epcglobalinc.org/standards/tds/tds 1 4- standard-20080611.pdfMar. 8, 2010 (2008)
  27. Miller, P.: TCP/IP - The Ultimate Protocol Guide - Data Delivery and Routing. Volume 1. Universal-Publishers (2009)
Download


Paper Citation


in Harvard Style

Schapranow M., Müller J., Zeier A. and Plattner H. (2010). RFID Event Data Processing: An Architecture for Storing and Searching . In Proceedings of the 4th International Workshop on RFID Technology - Concepts, Applications, Challenges - Volume 1: IWRT, (ICEIS 2010) ISBN 978-989-8425-11-9, pages 13-22. DOI: 10.5220/0003017100130022


in Bibtex Style

@conference{iwrt10,
author={Matthieu-P. Schapranow and Jürgen Müller and Alexander Zeier and Hasso Plattner},
title={RFID Event Data Processing: An Architecture for Storing and Searching},
booktitle={Proceedings of the 4th International Workshop on RFID Technology - Concepts, Applications, Challenges - Volume 1: IWRT, (ICEIS 2010)},
year={2010},
pages={13-22},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003017100130022},
isbn={978-989-8425-11-9},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 4th International Workshop on RFID Technology - Concepts, Applications, Challenges - Volume 1: IWRT, (ICEIS 2010)
TI - RFID Event Data Processing: An Architecture for Storing and Searching
SN - 978-989-8425-11-9
AU - Schapranow M.
AU - Müller J.
AU - Zeier A.
AU - Plattner H.
PY - 2010
SP - 13
EP - 22
DO - 10.5220/0003017100130022