1. Database Setup (PostgreSQL)• Videos, Objects, Events, User prompts tables• Python libs: psycopg2, SQLAlchemy• Store metadata, analytics

2. Video Input• Import recorded videos (OpenCV, MoviePy)• Save metadata to PostgreSQL• Multiple cameras: #1 top view, #2 front view

3. Preprocessing• Convert videos to frames• Normalize & resize frames• Store frame metadata optionally

4. Service Selection• Cloud APIs: Google, Azure, AWS• Local: OpenCV, FFmpeg, YOLO, Detectron2, DeepSORT

A INFRASTRUCTURE

AND PREPARATION

AA