A system for managing data in an industrial production environment includes a distributed database system stored on a plurality of embedded controller devices. Each respective embedded controller device comprises: a distributed database instance and a database management application. The distributed database instance is configured to store data collected from the industrial production environment by the respective embedded controller device. The database management application is configured to facilitate distributed queries and transactions on the plurality of embedded controller devices.