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 answers
Related Questions in REPORTING
- Can you report real-time visitors to your website using Mixpanel
- Add a eps file or pdf file to my report - MATLAB Report Generator
- I want to generate PDF automation report in XUnit using selenium driver and .net in visual studio?
- do you know any free reporting services like devexpress or boldreports?
- error NU1101: Unable to find package Telerik.Drawing.Skia.Trial. No packages exist with this id in source(s)
- Customization to Last Week filter
- Showing Different Sub-Reports Depending on a User Driven Parameter
- ASP.NET session has expired or could not be found in webforms app inside an iframe
- Row in Power BI Table blank
- xcresults tool is not able to export screenshots for failure cases ( xcresults-1.17.1 )
- how to create a textbox in ssrs for user entry as a parameter and limit the Character input to 18
- How do I find out where this error is coming from?
- Unable to call a custom dll method in Microsoft SSRS
- How-to export NUnit Attributes in one file/report
- Will reports still be accessible once an App is removed from Sale from the Apple Store
Related Questions in OLAP
- OLAP Cube process error (A connection could not be made to the data source with the DataSourceID of 'Example_SQL', Name of 'ExampleSQL'.)
- Issues with deploying a project in SSAS: "Cannot deploy metadata"
- Why some of existing user not able to see newly added DB in clickhouse
- Filtering OLAP Pivot Table based on dates
- My SQL Server Analysis services won't switch from tabular to multidimensional
- Aggregating Members calculated with IIF / CurrentMember conditions
- markUsed is not marking segments as unUsed in druid
- How to add and backfill a column to a ClickHouse materialized vew and the underlying table
- Does TiDB Serverless support TiFlash for analytical jobs (OLAP) just like TiDB?
- Need to create a report in Apache Kylin using SSB sample data
- Excel CUBEMEMBER return multiple matches
- Calculated Member for Time Periods Hierarchy
- MDX get DISTINCT COUNT for Month to Date
- Relationship between dimension and measures
- Create Current Month
Related Questions in OLTP
- Why some of existing user not able to see newly added DB in clickhouse
- OLTP-STAGGING-DW-DUPLICATES
- OLAP vs OLTP - Fundamental difference
- How to send authenticated traces to tempo cloud using OLTP exporter python?
- How measure attributes values are populated in fact table?
- Best practice to size Autonomous Transaction Processing (ATP) (number of OCPUs) for APEX on ATP?
- OLAP architecture?
- What do Transaction means in OLTP?
- OLAP/OLTP: What does "online" mean?
- OLTP type data in a OLAP system
- Data warehouse - OLAP vs OLTP vs Dimentional model vs Relational model
- Google Cloud Architecture: Can a data lake be used for OLTP?
- MS Access get row ID of Update or intercept Update
- How deep to go when denormalising
- creating SQL memory table visual studio
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?
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)
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.