0

should I use OLAP or OLTP for reporting tools like BIRT, Jasper Report... ? I want to build ad - hoc many documents (e.g. 1000000).

internet
  • 385
  • 1
  • 8
  • 27
  • If you're making simple reports and have your data in an SQL server, I guess no need to complicate yourself with OLAP – ic3 Oct 14 '11 at 16:54

1 Answers1

0

Just to extend on icCube's comment and provide an answer.

If you want to build many documents (in the order of millions), you probably do have data that are queried more than they are updated, and you might want an OLAP system, especially if your documents need aggregation of data (summing, counting) in hierarchies of your data (weekly, monthly, yearly aggregations).

If you have data that frequently flow into your database, like stock market data, you would definitely want a OLTP system.

You might need neither, and go mainstream with a RDBMS.

Thor Hovden
  • 413
  • 6
  • 13