Chapter 12. Generating Multidimensional Results

This chapter is dedicated to those PostgreSQL users who have to deal with reporting and data mining. Multidimensional results are used for many reasons, especially in scientific environments. Imagine a huge database with dozens of millions of records. If similar questions are posed to the database, it might take too long to compute the results one after the other. Therefore, it might be useful to generate the results in one step to save CPU time and extract the components of the result afterward.

In general, there are two ways of dealing with multidimensional data structures. One way is to generate the results on the database level. Another way is to calculate the result on the application level. ...

Get PostgreSQL Developer's Handbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.