skip to main content
10.1145/1839294.1839333acmotherconferencesArticle/Chapter ViewAbstractPublication PagespetraConference Proceedingsconference-collections
research-article

Applying data warehousing technique in pervasive assistive environment

Published:23 June 2010Publication History

ABSTRACT

Radio Frequency Identification (RFID) is an automatic identification (Auto-ID) Technology, which is most commonly used now days in healthcare for tracking and identifying objects. In the context of assistive environment, statistical query analysis over the history of Data generated from RFID Applications as well as real time monitoring of the patients or the elderly people (people who need assistance) are really important. But Data generated from these types of healthcare applications can be very large, if each individual object becomes RFID-Tagged. As a result, the RFID technology is also imposing a greater challenge to provide efficient query responses over these Data. In this paper, we show how to apply traditional Data Warehousing techniques to model these massive amounts of RFID Data. In short, we describe how to construct an RFID Warehouse so that important query analyses can be performed very efficiently. We also show how to process a continuous stream of RFID Data to answer real time queries using Sliding Window techniques. By the help of using synthetic Datasets, we conclude that querying over Data Warehouse is much faster than traditional Relational DBMS. We also find that the aforesaid performance improvement is expected to be much higher as the size of the Dataset increases.

References

  1. "Study on the requirements and options for RFID application in healthcare: Identifying areas for Radio Frequency Identification deployment in health care delivery: A review of relevant literature," 2009.Google ScholarGoogle Scholar
  2. B. S. Ashar and A. Ferriter, "Radiofrequency identification technology in health care: benefits and potential risks," JAMA: The Journal of the American Medical Association, vol. 298, Nov. 2007, pp. 2305--2307.Google ScholarGoogle ScholarCross RefCross Ref
  3. E. Becker, V. Metsis, R. Arora, J. Vinjumur, Y. Xu, and F. Makedon, "SmartDrawer: RFID-based smart medicine drawer for assistive environments," Proceedings of the 2nd International Conference on PErvsive Technologies Related to Assistive Environments, Corfu, Greece: ACM, 2009, pp. 1--8. Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. A. Cangialosi, J. Monaly, and S. Yang, "Leveraging RFID in hospitals: Patient life cycle and mobility perspectives," Communications Magazine, IEEE, vol. 45, 2007, pp. 18--23. Google ScholarGoogle ScholarDigital LibraryDigital Library
  5. H. Gonzalez, Jiawei Han, Xiaolei Li, and D. Klabjan, "Warehousing and Analyzing Massive RFID Data Sets," Data Engineering, 2006. ICDE '06. Proceedings of the 22nd International Conference on, 2006, p. 83. Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. F. Wang and P. Liu, "Temporal management of RFID data," Proceedings of the 31st international conference on Very large data bases, Trondheim, Norway: VLDB Endowment, 2005, pp. 1128--1139. Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. R. Derakhshan, M. Orlowska, and Xue Li, "RFID Data Management: Challenges and Opportunities," RFID, 2007. IEEE International Conference on, 2007, pp. 175--182.Google ScholarGoogle Scholar
  8. J. Gray, A. Bosworth, A. Lyaman, and H. Pirahesh, "Data cube: a relational aggregation operator generalizing GROUP-BY, CROSS-TAB, and SUB-TOTALS," Data Engineering, 1996. Proceedings of the Twelfth International Conference on, 1996, pp. 152--159. {9} A. Melski, L. Thoroe, and M. Schumann, "Managing RFID data in supply chains," International Journal of Internet Protocol Technology, vol. 2, 2007, pp. 176--189. Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. A. Melski, L. Thoroe, and M. Schumann, "Managing RFID data in supply chains," International Journal of Internet Protocol Technology, vol. 2, 2007, pp. 176--189. Google ScholarGoogle ScholarDigital LibraryDigital Library
  10. K. Cotterill, "Distributed Patient-Drug Tracking in Healthcare Organizations," Solution White-Paper, Bonsai Development Corporation, 2004--2005.Google ScholarGoogle Scholar
  11. R. Weinstein, "RFID: a technical overview and its application to the enterprise," IT Professional, vol. 7, 2005, pp. 27--33. Google ScholarGoogle ScholarDigital LibraryDigital Library
  12. J. Woods, "RFID Enables Sensory Network Strategies to Transform Industries,", 2005.Google ScholarGoogle Scholar
  13. R. A. Elmasri and S. B. Navathe, Fundamentals of Database Systems, Addison-Wesley Longman Publishing Co., Inc., 1999. Google ScholarGoogle ScholarDigital LibraryDigital Library
  14. B. Babcock, S. Babu, M. Datar, R. Motwani, and J. Widom, "Models and issues in data stream systems," Proceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, Madison, Wisconsin: ACM, 2002, pp. 1--16. Google ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. Applying data warehousing technique in pervasive assistive environment

            Recommendations

            Comments

            Login options

            Check if you have access through your login credentials or your institution to get full access on this article.

            Sign in
            • Published in

              cover image ACM Other conferences
              PETRA '10: Proceedings of the 3rd International Conference on PErvasive Technologies Related to Assistive Environments
              June 2010
              452 pages
              ISBN:9781450300711
              DOI:10.1145/1839294

              Copyright © 2010 ACM

              Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

              Publisher

              Association for Computing Machinery

              New York, NY, United States

              Publication History

              • Published: 23 June 2010

              Permissions

              Request permissions about this article.

              Request Permissions

              Check for updates

              Qualifiers

              • research-article

            PDF Format

            View or Download as a PDF file.

            PDF

            eReader

            View online with eReader.

            eReader