Sensor and Automation Event Processing in the Real World (Existing Customer Use Cases)

1. Sensor and Automation Event Processing in the Real World(Existing Customer Use Cases) Sam Rehman <samuelson.rehman@oracle.com> Director of Development RFID, Sensor and Automation

2. ...and that if the subject, or even only the subjective constitution of thesenses in general, be removed, the whole constitution and all the relations of objects in space and time, nay space and time themselves, would vanish. With this alone, have we any concern. Kant - Critique of Pure Reason

3. <Insert Picture Here> Sensors and Automation Overview

4. Sensors Data Intelligence  Insight Data made relevant to your business Has it crossed the border? Where is my package? Patient details and history? Any hazardous materials? Are these authentic products? Has it been tampered? Right medication? Is the food still fresh?

5. Internet e-Business Traditional Business Real Time Business • Weeks • Megabytes • Punch Cards • Few People • Days • Terabytes • Human Driven • Many People • Seconds • Exabytes • Event Driven • Automated Information Driven Enterprises

6. Typical Sensors • Temperature (Thermocouple and RST) • Motion/Presence/Location/Direction/Identification (GPS, IRBB, CMOS, RFID, RTLS, UWB, SAW, MiFARE, etc) • Weight (Electronic Scales, etc) • Dry Contacts • Bio-sensors (Retina, fingerprints, etc)

7. Typical Actuators and Indicators • Message Boards (LED, LCD, SBCs, screens,lightstacks,etc) • MHE (Carousels, ASRS, etc) • General PLCs

8. Supply chain out of stock reduction, automation Reduce shelf management Homeland Security US Visit Container tracking (Tom Ridge) Critical infrastructure protection Transportation Container management, security, Hazmat Asset Tracking Hazmat (chems, explosives) Sensitive materials (vaccines) Expensive (construction) Sensor Networks DoD, Homeland Security, Natural Resource Management Pharma Electronic Pedigree Healthcare Patients Equipment Security Manufacturing Part management Boeing/Airbus 10,000 tags/A380 Payment systems Ezpass, ski, movies Smartcards, Cellphone based Security and Access Control …and more uses everyday Wide range of uses

9. Sensor and Automation Services Oracle Fusion Middleware SENSE & RESPOND DEVICES APPLICATIONS ACCESS Business Intelligence Sensor Data Manager Alerts Portal Solutions ANALYZE Solutions (Compliance,etc) Business Processes Business Activity Monitoring Integration EDGE MANAGE Oracle AS Edge Server Database Application Server Other Applications

10. Sensor Edge ServerPlug and Play, Modular Architecture Oracle Fusion Middleware Device Abstraction Layer Dispatchers OPMN Web Services Driver WS Callbacks Sensor Edge Server Streams Driver Oracle Streams/AQ Groups Internal Store//Forward ALE EPC ALECLient Driver Local Processors: Filters & Rules EventFlow WS, HTTP,file, Stored Proc, etc Development Services Administration Web Services IS Services JMX Device Mgmt. Custom Solutions EM Sensor Data Management Monitoring Central/Remote Administration Admin Console Reporting Associations EPC Mgmt. Archiving Sensor Data. Sensor Data Repository (optional)

11. Oracle E-Business Suite Oracle Database 10g Solutions WMS EAM OTM Retek … EPCIS Query Interface Oracle Fusion MiddlewareSensor and Automation Services Oracle Sensor Data Manager (SDM) EPCIS Services EPCIS Discovery Repository Tools EPCIS Capture Interface Application Specific Capture Apps Oracle Sensor Edge Server (SES) EPC ALE IS Integration Clustering ALE Services RFID Middleware Dev. Mgmt LocalProcessing Management Filtering EPC RP or LPRP RFID Readers EPC UHF Gen2 Protocol RFID Tags Oracle and The EPCglobal NetworkComplete product support

12. SES Event Processing Support • Domain Specific • Custom coded needed for specific vertical • Eg: Pallet Processor (WMS), Choke (T&T), Presence (Pharma), etc • SI Provides Processors: • SI uses our framework to build reusable processors for their typical customers • Generic Parameterized Local Processors • Based on generic algorithms • Support for temporal (sliding window) for transient events • Custom Processors • Self contained user provided extensions (remotely deployed and managed) • Long Term Conditions • DBMS Rulesets and Expression Filters • CEP Engine (Future releases) • Meta data driven processing with windowing support

13. Typical Parameterized Event Processing:Smoothing and Edge Detections • 3. Level rises and drops: • level rises afterwards and drops in non-predictable intervals • Tolerance level for drop detection is based on sliding window, not just from start Signal • 5. Event “Exit” generated • Edge drops for Y period • 1. Pull not seen • e.g Tag is not in field in this timeline • 2. Event “Enter” generated: • Note there is NO preamble • Rise of edge is defined as rise afterdrop for X period of time • 4. Cannot consider drop yet • Since there is no sync word TIME

14. Challenges • Parameterized Processing is not flexible enough • Some customer still needs to customize code (deployment and support issues) • Custom (java coded) processors only works for common cases, and will not scale with the range of use cases • Need more visibility and simulation into processing • Cannot handle both short and wide temporal windows in one language • Centralized tool sets for: Defining processing logics, monitoring, viewing exceptions, setting up bindings • Difficult to define bindings to adapters (dissemination) • Has to be embeddable into Vertical and Horizontal Applications!!! (how to expose the predicates and tools?)

15. <Insert Picture Here> Real life Use Cases

16. Multi-dimensional Track and TraceEnd to end monitoring and audit trail for perishable goods • Tracking from original packaging to retail • Re-packaging, Presence, Choke, Temperature and Light exposure has to be monitored and evaluated every step of the way  3PL Ships hands items in temp. controlled containers  Manufacturer packages and tags the containers  Warehouses with environment control bins/shelves  Retail stores with temperature control back-store and shelves

17. Physical Identification: Control AccessOpen architecture for secure identification Carries MiFARE, iClass or Contactless SIMM/Smart Card  User authorized (or denied). Sends back indicator or open doorway. Attempts and Entry is logged and stored in dbms for audit  Request to enter send to backend IM system, response could be challenge or auth token  User trying to enter secure area • Major doorways equipped with readers and indicator, may include keypad for challenge keys • Today’s Challenges/Shortcomings • Soft identity easily stolen • Security & safety compliance • Proprietary architecture • Sensor-Based Benefits • Real-time location & status information • Physical identification • Open architecture yet maintain end to end cryptography This is not a commitment to deliver. Product directions are subject to change without notice.

18. Inventory Management: Fewer PartsAutomated Re-Order of Spare Parts for Service Depots Location = Shelf 1 Quantity = 1  Receiver sends signal to APS applications ReplenishmentOrder Location = Station 5 Quantity = 1  APS interprets signal as “real demand” and increments demand signal by actual consumed quantity or triggers replenishment order  Service tech needs component off shelf to complete repair  Removing component from shelf sends signal to receiver • Today’s Challenges/Shortcomings • Replenishment based on “latent guesstimates” • Promotes excess inventories with risk of parts obsolescence • Sensor-Based Benefits • Real-time spares consumption information with auto-triggering of replenishment orders • Improved inventory management

19. SES Enterprise Asset ManagementTracking health and performance of your expensive equipment Smart Storage Oracle Sensor Edge Server Backend Applications: (EAM, CRM FS, etc) MHEs or other metered equipment ADC and networking • Typical Local Processing • Generate equipment alert if: • Temp. on reg. “Engine15” rise above 110ºF for more than X minutes, and no gaps more than 2 seconds • Running mean on temp gradually rising over 2% every month

20. For More Information http://search.oracle.com RFID or http://www.oracle.com/technologies/rfid

21. <Insert Picture Here> Questions / Answers

22. The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, and timing of any features or functionality described for Oracle’s products remain at the sole discretion of Oracle.