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.

This is only a preview
This is only a preview of the full book. From here, you may:
  • Login.
  • Try it FREE for 14 days.
  • Subscribe.
  • You can continue your free preview of this book or return to search results.


PostgreSQL Developer's Handbook2001
PostgreSQL Developer's Handbook2001
ISBN: N/A
EAN: N/A
Year: 2004
Pages: 125

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net