In-memory processing: Difference between revisions

Revision as of 10:09, 23 December 2023

Revision as of 10:11, 23 December 2023

Line 28:

* The advent of ''[[64-bit operating system]]s'', which allow access to far more RAM (up to 100 GB or more) than the 2 or 4 GB accessible on [[32-bit computing|32-bit systems]]. By providing Terabytes (1 TB = 1,024 GB) of space for storage and analysis, 64-bit operating systems make in-memory processing scalable. The use of flash memory enables systems to scale to many Terabytes more economically.

* Increasing ''volumes of data'' have meant that traditional data warehouses may be less able to process the data in a timely and accurate way. The [[extract, transform, load]] (ETL) process that periodically updates disk-based data warehouses with operational data may result in lags and stale data. In-memory processing may enable faster access to terabytes of data for better real time reporting.

* In-memory processing ismay be available at a ''lower cost'' compared to traditionaldisk-based BI toolsprocessing, and can be more easily deployed and maintained. According to Gartner survey,<ref>{{Cite web |title=Survey Analysis: Why BI and Analytics Adoption Remains Low and How to Expand Its Reach |url=https://www.gartner.com/en/documents/3753469 |access-date=2023-12-05 |website=Gartner |language=en}}</ref> deploying traditional BI tools can take as long as 17 months. Many data warehouse vendors are choosing in-memory technology over traditional BI to speed up implementation times.

*Decreases in power consumption and increases in throughput due to a lower access latency, and greater memory bandwidth and hardware parallelism.<ref>{{Cite book|last1=Upchurch|first1=E.|last2=Sterling|first2=T.|last3=Brockman|first3=J.|title=Proceedings of the ACM/IEEE SC2004 Conference |chapter=Analysis and Modeling of Advanced PIM Architecture Design Tradeoffs |date=2004|chapter-url=https://ieeexplore.ieee.org/document/1392942|___location=Pittsburgh, PA, USA|publisher=IEEE|pages=12|doi=10.1109/SC.2004.11|isbn=978-0-7695-2153-4|s2cid=9089044 |url=https://resolver.caltech.edu/CaltechAUTHORS:20170103-172751346 }}</ref>