should I use OLAP or OLTP for reporting tools like BIRT, Jasper Report... ? I want to build ad - hoc many documents (e.g. 1000000).
1
There are 1 best solutions below
Related Questions in REPORTING
- Pivot Table with multiple rows all having the same level hierarchy
- creating many reports from a single template - what is this called?
- How to select the Data Source at Runtime in SSRS Report Builder
- How do I create a more filtered report in Version One, similar to an excel report?
- SSRS - Showing data's each character in box
- How to retrieve Install Statistics from the Google Developer's Console?
- Error handler for sum in ssrs
- Pentaho adhoc reporting functions
- How to retrieve my Install Statistics from the Google Developer's Console
- BIRT: Fit to whole page in report design?
- FastReport.Net. Registration of dataset
- In asp.net-mvc, what is the correct way to do expensive operations without impacting other users?
- How I can bind devexpress report table to list of strings?
- Generate PDF/html report and send report as mail in SonarQube 6.0
- SQL Group By in to separate result tables
Related Questions in OLAP
- Approaching mixed granularity date dimensions for operational periods in cube design
- MDX union members in different hierarchies
- Jedox How to use it? Main ideas behind data points rules, data flows, ETL... Where to find that?
- Investigate MDX DistinctCount discrepancy
- How to restrict members list in dimension using SSAS perspectives?
- What are the size limits of file *.agg.flex.data?
- Exception occurs while processing SSAS cube
- MDX: Filtering repeated
- Pivot4j/Olap4j adding condition to where clause of generated query
- Star schema role in the Pentaho Mondrian OLAP server
- OLAP cube Member Name instead of ID to filter Pivot
- SSRS mdx report: use dimension on columns
- Intersect Select Query in MDX
- Can a SQL Server OLAP cube be loaded from csv files
- Set of Days in past 6 equivalent MTDs
Related Questions in OLTP
- Relational Integrity between OLAP and OLTP
- OLTP-STAGGING-DW-DUPLICATES
- OLAP or ALTP at reporting Tools
- What do Transaction means in OLTP?
- Is a star schema a denormalized schema?
- Concurrent Reads from Highly Transactional Table
- How to compare varchar parameters in a natively compiled stored procedure?
- OLTP type data in a OLAP system
- How to send authenticated traces to tempo cloud using OLTP exporter python?
- What is the "Online" in Online Transaction Processing or Online Analytical Processing
- Using non memory optimised tables in Natively Compiled Stored Procedure without custom table types
- Are there database design types or models that are referred to as numbers
- What is database throughput?
- SSD performance benefit in OLTP vs OLAP
- Using SQL Server 2014 in memory table with arabic collation
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
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.