Re: Creating complex track changes database - challenge!

From: Christian Keil <keil(at)dfn-cert(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Creating complex track changes database - challenge!
Date: 2018-02-27 09:55:33
Message-ID: 20180227105533.6eccb69f@jerome.dfn-cert.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message mariusz 2018-02-27 11:26:10 Re: Given a set of daterange, finding the continuous range that includes a particular date (aggregates)
Previous Message David Rowley 2018-02-27 09:17:07 Re: Why is tuple_percent so low?