Version Tracking with mysql

Question

I have an database with books.

One book has one Author, Publisher. Some Prices, ID's and Descriptions.

I want to keep track of changes made to one product. One way is to save the product with time AND id as primary key.

Are there other ways?

Are there database systems (i've only used mysql) who can keep track of changes automaticly?

greetings...

Answer 1

What you are asking for is mostly covered by the "Change Data Capture" (CDC) design patterns and "Slowly changing dimension" (SDC) concept.

Read the Wikipedia articles on these subjects, as they provide a good birds-eye view on this topic.