<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<div class="moz-text-flowed"
style="font-family: -moz-fixed; font-size: 13px;" lang="x-western">Hello
everybody,
<br>
<br>
I´m working with a small project to a client, using Postgres to store
data in a dimensional model, fact-oriented, e.g., a Datamart.
<br>
<br>
At this time, all I have is a populated database, with the "star
schemma" common relations (PK´s / FK´s).
<br>
<br>
Below is a list of the main goals of this project :
<br>
1. Front-end app (PHP5)
<br>
2. Transactional database for this app (Postgres)
<br>
3. Datamart in Postgres (described above)
<br>
4. ROLAP server that supports Postgres (Java - Mondrian)
<br>
5. Front-end app to manage querys to the ROLAP server (JSP - JPivot)
<br>
<br>
Users will have web access to (1), and will be enable to create views
using (5).
<br>
<br>
It seems like I´m trying to reinvent the wheel, but the point here is
that the client can´t afford to use proprietary BI solutions, nor
proprietary OS.
<br>
What I have read all across the internet is that Postgres does not
support this kind of application, wich demands materialyzed views,
built-in bitmap index, and so on. In the open-source world, I find
those missing features with Mondrian/JPivot.
<br>
<br>
Does anyone has ever used this structure before ? At least Mondrian and
JPivot ?
<br>
<br>
<div class="moz-txt-sig"><span class="moz-txt-tag">-- <br>
</span>[]´s,
<br>
André Volpato
<br>
</div>
</div>
</body>
</html>