O'Reilly logo

PostgreSQL Developer's Handbook by Hans-Jürgen Schönig, Ewald Geschwinde

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required