TY - GEN
T1 - Data staging for OLAP- and OLTP-applications on RFID data
AU - Krompaß, Stefan
AU - Aulbach, Stefan
AU - Kemper, Alfons
PY - 2007
Y1 - 2007
N2 - The emerging trend towards seamless monitoring of all business processes via comprehensive sensor networks - in particular RFID readers - creates new data management challenges. In addition to handling the huge volume of data generated by these sensor networks the information systems must support the efficient querying and analysis of both recent data and historic sensor readings. In this paper, we devise and evaluate a data staging architecture that consists of a distributed caching layer and a data warehouse. The caches maintain the most recent RFID events (i.e., sensor readings) to facilitate very efficient OLTP processing. Aged RFID events are removed from the caches and propagated into the data warehouse where related events are aggregated to reduce storage space consumption. The data warehouse can be utilized for business intelligence applications that, e.g., analyze the supply chain quality.
AB - The emerging trend towards seamless monitoring of all business processes via comprehensive sensor networks - in particular RFID readers - creates new data management challenges. In addition to handling the huge volume of data generated by these sensor networks the information systems must support the efficient querying and analysis of both recent data and historic sensor readings. In this paper, we devise and evaluate a data staging architecture that consists of a distributed caching layer and a data warehouse. The caches maintain the most recent RFID events (i.e., sensor readings) to facilitate very efficient OLTP processing. Aged RFID events are removed from the caches and propagated into the data warehouse where related events are aggregated to reduce storage space consumption. The data warehouse can be utilized for business intelligence applications that, e.g., analyze the supply chain quality.
UR - http://www.scopus.com/inward/record.url?scp=77954890470&partnerID=8YFLogxK
M3 - Conference contribution
AN - SCOPUS:77954890470
SN - 9783885791973
T3 - Datenbanksysteme in Business, Technologie und Web, BTW 2007 - 12th Fachtagung des GI-Fachbereichs "Datenbanken und Informationssysteme" (DBIS), Proceedings
SP - 542
EP - 561
BT - Datenbanksysteme in Business, Technologie und Web, BTW 2007 - 12th Fachtagung des GI-Fachbereichs "Datenbanken und Informationssysteme" (DBIS), Proceedings
T2 - 12th Symposium of the German Informatics Society Section "Databases and Information Systems" (DBIS) on Database Systems in Business, Technology and Web, BTW 2007
Y2 - 7 March 2007 through 9 March 2007
ER -