Put all eggs in one basket: an OLTP and OLAP database approach for traceability data

  • Authors:
  • Veneta Dobreva;Martina-Cezara Albutiu

  • Affiliations:
  • Technische Universität München, Garching, Germany;Technische Universität München, Garching, Germany

  • Venue:
  • Proceedings of the Fourth SIGMOD PhD Workshop on Innovative Database Research
  • Year:
  • 2010

Quantified Score

Hi-index 0.00

Visualization

Abstract

Accurate tracking and tracing of moving objects is an emerging trend in vertical industries like retail, logistics, and manufacturing. In order to monitor objects in business processes, more and more companies are deploying upcoming technologies like Radio Frequency Identification (RFID). Therefore, modern databases have to be able to cope with the challenges originating from the specifics of traceability data: efficient incremental update as well as efficient transactional and analytic ad-hoc querying and efficient storage of the data. Another requirement of business intelligence applications is to provide "real world awareness"[7] by using the latest information in the descision-making process. We therefore present an approach for efficient storing and managing of traceability data (on the example of RFID data), where the OLAP and OLTP components reside in one database and which meets the defined challenges. We discuss and analyze the experimental results and lessons learned and take them as a basis for our future research direction.