You want to create a database model (or data warehouse), which would store not only the current state, as in conventional operational databases, but also the entire history of changes made to any attribute of any entity at the time to know everything in any time slice, as is done with aggregated data in data warehouses. But if the text attributes and aggregating of nothing, it is not clear how to build such a model. Something close to what I need, perhaps, temporal databases. I would like to know links to books, scientific articles, open-source projects on this subject.