Re: Creating complex track changes database - challenge!

Hi Jacek,

On Mon, 26 Feb 2018 11:44:13 +0100
Łukasz Jarych <jaryszek(at)gmail(dot)com> wrote:

> Hi Guys,
>
> i would like to ask you for help with track changes to my database.
> I am new to PosgtreeSQL but i have to learn it quickly because of my boss.
>
> I have to:
>
> 1. Keep all changes within table including:
> -adding rows
> -deleting
> -editing
>
> 2. Save table with specific state and recover specific state (so go back to
> previous table versions) including comparing tables.

depending on your requirements and implementation of these, you might want to
have a look at "Developing Time-Oriented Database Applications in
SQL" (https://www2.cs.arizona.edu/people/rts/tdbbook.pdf). It is quite thick
with 530 pages, but it helped me wrap around my head on a similar
requirement. It describes the challenges with tracking and managing these
kinds of changes as well as solutions together with SQL examples.

Cheers,

Christian

--
Dr.-Ing. Christian Keil (Principal Researcher)
Phone:+49 40 808077-648 Fax:+49 40 808077-556 Mail: keil(at)dfn-cert(dot)de

DFN-CERT Services GmbH, https://www.dfn-cert.de/, Fax: +49 40 808077-556
Sitz / Register: Hamburg, AG Hamburg, HRB 88805, Ust-IdNr.: DE 232129737
Sachsenstrasse 5, 20097 Hamburg, Germany. CEO: Dr. Klaus-Peter Kossakowski

25. DFN-Konferenz "Sicherheit in vernetzten Systemen"
am 27./28. Februar 2018 im Grand Hotel Elysee Hamburg

7. DFN-Konferenz "Datenschutz"
am 20./21. November 2018 im Grand Hotel Elysee Hamburg