Offending My Tender Sensibilities -OR- OLTP on a Star Schema

From: Roy Anderson <roy(dot)anderson(at)gmail(dot)com>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Offending My Tender Sensibilities -OR- OLTP on a Star Schema
Date: 2014-02-05 04:06:00
Message-ID: CAB9vZORKW99dT-L+jMJ65vz3xdsTtvA1pJ43nSuoWBo2u-LtCA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We have an OLTP database and no data warehouse. We are currently
planning out a build for a data warehouse however (possibly using
Hadoop). "X" is recommending that we convert our current, normalized
OLTP database into a flattened Star Schema.

The primary rationale for this OLTP flattening is that since most of
the app calls to the database are SELECT statements, the DB should be
optimized for that. A peripheral rationale I've heard is that the
1NF-3NF database is hard to understand sometimes.

I'm not going to state what I believe. I would like to hear my
esteemed colleagues take on this situation. What would you do? What
would you say? Is there anything you would investigate? In short, what
say you?

Thanks for your time.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Nilsson 2014-02-05 08:15:15 pg_basebackup and checkpoints
Previous Message Andrew Sullivan 2014-02-05 01:36:52 Re: Re: Drop all overloads of a function without knowing parameter types