Slowly Changing Dimension implementation

From: Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Slowly Changing Dimension implementation
Date: 2018-02-15 07:39:22
Message-ID: 20180215083922.15542aw8jf64ap1c@www.gelassene-pferde.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all

I am not aware of a database based solution for the implementation of
SCDs (https://en.wikipedia.org/wiki/Slowly_changing_dimension) be it
0, 1 or 2 - I consider all other only as implementation specifications
of type 2. However, I am considering to implement a trigger based
solution and make it opensource. Is there a consense about how such
PostgreSQL add-ons are handled best? Where to store code and
documentation (with PostgreSQL modules, with SourceForge, github ...),
where to publish (mailing lists), when to publish code and
announcements (only beta ware and more stable as opposed to from the
beginning, ...?

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.

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2018-02-15 07:58:46 Re: Upgrading from Postgresql 9.1 to 10
Previous Message Eric Hanson 2018-02-15 03:46:53 Re: I do not get the point of the information_schema