Especially for data warehousing, a relational database is just not enough. Generating multidimensional datacubes can hardly be done by using plain SQL code, and so additional software has to be used to perform all necessary operations. The EFEU package by Erich Fruehstueck is a free alternative to things like OLAP, and can be used in combination with PostgreSQL. This article is derived from the authors' forthcoming book, PostgreSQL Developer's Handbook(Sams, 2001, ISBN: 0672322609).
Conclusion
EFEU has a lot of powerful features, and supports a huge pool of functions
for processing data cubes. In addition to that, esh provides a lot of
functions for dealing with PostgreSQL databases and processing text by
generating LaTex code.