May 05, 2014

BI: In-Memory or Live Reporting?

BI: In-Memory or Live Reporting?

In-Memory Data is Better than Live reporting in following scenarios.
1.When your database is too slow for interactive analytics
2.When you need to take load off a transactional database
Even though data is fast but some calcalation specifically Analytics can slow down the speed and need to load off a transactional database.
3.When you need to be offline
Bringing data into memory, you can work offine on database.


A Live, Direct Data Connection is better in following scenarios.
1. Database itself is fast and you just need to render the data. Avoid data silos and ensure a single point of truth by pointing your
analyses at a single, optimized database.
2.When you need up-to-the minute data
If things are changing so fast that you need to see them in real-time.

No comments:

Creating DataFrames from CSV in Apache Spark

 from pyspark.sql import SparkSession spark = SparkSession.builder.appName("CSV Example").getOrCreate() sc = spark.sparkContext Sp...