From: | Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Creating complex track changes database - challenge! |
Date: | 2018-02-27 07:43:45 |
Message-ID: | 20180227084345.80751f5vl9r8wm68@www.gelassene-pferde.biz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I attached what I have got so far. I will setup a shared repository
these days.
Zitat von Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>:
> Hi Lukasz
>
> I am working on a generic (reading the information schema and other
> database metadata), trigger based solution for SCD tables, i. e.
> tables that keep (or not according to SCD type) history of the data.
> However, it is not far grown and I am not having much time to
> advance it so it evolves very slowly. If you are interested, I would
> open a sourceforge project or the like and we can work on it together.
>
> I am very much surprised that no database I know of supports
> SCD/historising tables out of the box. In 16 years as ETL pro I have
> seen reinvented the wheel all the time... maybe PostgreSQL wants to
> get a head start on this.
>
> Kind regards
>
> Thiemo
--
+49 (0)1578-772 37 37
+41 (0)78 947 36 21
Öffentlicher PGP-Schlüssel:
http://pgp.mit.edu/pks/lookup?op=get&search=0x8F70EFD2D972CBEF
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.
Attachment | Content-Type | Size |
---|---|---|
full_install.7z | application/octet-stream | 4.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | mariusz | 2018-02-27 09:03:02 | Re: Given a set of daterange, finding the continuous range that includes a particular date (aggregates) |
Previous Message | Thiemo Kellner | 2018-02-27 07:11:26 | Re: Creating complex track changes database - challenge! |