1 / 38

RFID Inventory Management And Tracking System

RFID Inventory Management And Tracking System. Greg McDaniel Hashem Garner Adam Kesner Thomas Harris. Presentation Agenda. Project Overview Hardware Prototype Checkout System Database & Web Reporting Tools Please hold all questions until the end of the presentation. Project Overview.

bishop
Download Presentation

RFID Inventory Management And Tracking System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. RFID Inventory Management And Tracking System Greg McDaniel Hashem Garner Adam Kesner Thomas Harris

  2. Presentation Agenda • Project Overview • Hardware • Prototype Checkout System • Database & Web Reporting Tools Please hold all questions until the end of the presentation.

  3. Project Overview Greg McDaniel

  4. RFID Inventory Management System • Prototype System • Replace UPC Barcodes • Uses RFID Tags • Passive RFID • Benefits • Enhanced Inventory Tracking • Simplified Checkout

  5. Project Background • Current Systems • Universal Product Codes ( UPCs) • Limitations • Shoplifting • In-Store Inventory Tracking • Inefficient Checkout • Alternative • Radio Frequency Identification Tags (RFIDs)

  6. What are RFIDs? • Radio Frequency Identification Tags • Common Uses • E-ZPass • Passports • Security Badges

  7. Benefits of RFIDs • Faster Checkout • Speedy • Fewer Complications • Numerous Other Potential Applications • Improved Inventory Tracking • Anti-theft • Expiration Dates (grocery stores)

  8. Project Components • Hardware • RFID Reader • Software • Checkout System • Database • Stored Procedures • Web Reporting Tools

  9. Hardware Adam Kesner

  10. Hardware • RFID Operation • Types of RFID Tags • Required Capabilities • Major Objectives • Minor Objectives • RedBee RFID Reader • Interference

  11. RFID Operation • Necessary Components • Interrogator • Antenna • RFID Tag • PC • Power Supply RedBee RFID Scanner

  12. Types of RFID Tags • Active • Contains Battery • Transmits Signal Autonomously • Range of up to 100 Meters • Battery Assisted Passive (BAP) • Requires External Source to Wake Up • Significant Higher Forward Link • Greater Read Range • Passive • Energy Transferred Using RF from Reader • Range of 3-5 Meters; Usually Less

  13. RFID Button, Credit Card, Key Fob and Reader

  14. Major Objectives • Accurate Identification • System is Useless Otherwise • Cost Efficient • Prototype Cost: $150 • Remote Scanning • Ideal Functionality, Not Achieved • Near Instantaneous Operation

  15. Minor Objectives • Filter Foreign Tags • Handled Effectively • Read Tags at Various Orientations • Parallel Orientation Offers Best Range • Functions at all Orientations • Operate in Store Environment • Repetitive Use

  16. RedBee RFID Reader • Interfaces with EM4001 IC • Key Fobs, Capsules, Cards, Buttons etc. • 125 KHz Low Frequency • Receives 32-bit ID • Utilizes 24 bits for Our Products • 8 Bits for Brand, Product, Unique ID • Sufficient Read Range • Roughly 10 cm

  17. RedBee RFID Reader • Power Supply Options • Via USB • Regulated 12V Barrel Connector • Supply 5V to Vcc Pin • Tag ID Transmitted via USB • Stream of Serial Data • Read from COM Port as a File

  18. Interference • Foreign Tags in Range of RedBee • HF Tags do not Interfere • 125 kHz Tags Handled by Software • Valid Tag and Foreign Tag in Range • Reliable Data Received • Valid Tag Recognized • Multiple Valid Tags in Range • Unreliable Operation • Unpredictable Results

  19. Prototype Checkout System Hashem Garner

  20. Software Architecture • Basic Components • Viewer • GUI • RFReader • Hardware Interface • Database • Database Interactions

  21. Code Conventions • Based on Oracle/Sun Recommended Best Practices • Camel-Case • Small Files • Less than 2000 lines • One class with specific purpose • Comment Conventions • Indentation and Whitespace Usage

  22. Viewer • Handles User Interactions • Display Current Order • Select/Remove Item • Finalize Transaction • Custom Panel • Display Order Item • Align Columns • Aesthetically Pleasing

  23. RFReader • Reads Data from RedBee Reader • Parses Data • Formats Data

  24. Database • Item Lookups • Price • Brand • Product • Finalize Transaction • Insert New Transaction/Sales • Transaction Number • Totals

  25. Database Design

  26. Database Web Reporting Tools Thomas Harris

  27. The Database • IMS Requires Tracking Large Amounts of Data • Current Inventory Levels • Inventory Orders • Sales Transactions • Pricing History

  28. Stored Procedures • Used to Access Data in the IMS Databases • Database Gatekeeper • Select • Insert • Update • Security • Change Localization

  29. Database Testing • Test Data Generation • Automated • Pseudo-Random Data • Simulate Inventory Flow • Verified Basic Database Design • Table Structure • Stored Procedures • Provided Test Data for Web Reporting Tools

  30. Web Reporting Tools • Honors Component • IMS Trending and Summaries • Current Inventory • Price Trending • Purchase Order History • Sales Summary

  31. Software Architecture • Web Presentation Layer • Custom Data Presentation • Business Layer • Shared Methods • Data Abstraction • Stored Procedures • Data Objects

  32. Conclusion

  33. Current Project Status • Working Prototype Checkout System • RFID Scanning Implemented • Functional GUI • Itemized Receipt • Stored Procedures • Standard, Secure Database Interface • Web Reporting Tools • Displays Useful Statistics • Basic Model for Future Reports

  34. Future Plans • Improve Hardware • Tags • Reader • Investigate Secondary Applications • Loss Prevention • Locating Misplaced Items • Real-Time Store Inventory Tracking • Address Limitations • Chicken and Egg Problem • Industry Initiative? • Cost of Implementation

  35. Questions?

More Related