Revolutionizing In-Sensor Processing with AI Acceleration and Integration