Oracle Database releases two automatic and scalable contact tracing APIs
By Hans Viehmann and Dan Geringer, Oracle
Oracle has released two automatic and scalable contact tracing APIs (PL/SQL table functions), included in every Oracle Database license:
- API 1 – Swipe in/out contact tracing
- API 2 – GPS tracking contact tracing
API 1 (swipe IN/OUT contact tracing) is idea for places with swipe in/out sensors installed on rooms, such as corporate offices and college campuses. It does not require GPS data, and allows users to automatically identify anyone that shared a room with someone positive. This API detects all rooms where users’ swipe in/swipe out times overlap the user being traced, and it reports duration (how long the users were in contact in the same room). Anyone that was exposed can then be notified, possibly to quarantine.
API 2 (GPS tracking contact tracing) correlates both location and time to automatically detect other users who, based on their GPS tracking data, came in contact with an input user. To be considered a “contact”, both the location and time stamps of the track points must coincide. When consecutive locations are classified as contacts, duration is also computed and reported. Optionally, the geometry that denotes the contact points can also be returned for display on a map.
These APIs natively leverage the security, scalability, and manageability features of Oracle Database. To use the them in Oracle 18c or 19c it is necessary to install Patch 31372664. Newer releases will include the functionality by default. The APIs can also be applied in other scenarios where entities (people, vehicles, movable objects, ship tracks) can coexist at a location for one or more time periods, be it for the purpose of law enforcement, in the IoT applications, or otherwise.
More info here.