Good evening.
Disclaimer: in this topic you will not see solutions on the topic of the post. They can probably be seen in my next topic.
However, I think many have encountered a similar issue and his decision is relevant.
')
On duty, I have to work with corporate management systems. There was a question about logging data changes, namely records in the database. We are talking about a complex hierarchy, a large number of objects created from table entries, multiple dependencies, etc. Surface search on the web yields primitive methods that are suitable only for simple data structures.
Therefore, there is a question for the farmers - what methodologies and architectural solutions do they use to solve this issue?
In my case we are talking about web applications (asynchrony, php + mysql server, etc.).
PS In response to the tolerance and understanding of hacks, to the fact that there is no informative part in the topic, I undertake to write an article on the results of this post.
PS [1] For those who are minus topic and karma - please provide the reason. For those who think that Habr is not a forum and there is no need to ask questions - I will explain: Habr and not a directory of articles, but a community of smart and educated people, the answers, recommendations and arguments of which generate knowledge.