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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
