Apache Impala vs Presto

Apache Impala vs Presto: What are the differences?

What is Apache Impala? Real-time Query for Hadoop. Impala is a modern, open source, MPP SQL query engine for Apache Hadoop. Impala is shipped by Cloudera, MapR, and Amazon. With Impala, you can query data, whether stored in HDFS or Apache HBase – including SELECT, JOIN, and aggregate functions – in real time.

What is Presto? Distributed SQL Query Engine for Big Data. Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes.

Apache Impala and Presto belong to „Big Data Tools“ category of the tech stack.
https://stackshare.io/stackups/impala-vs-presto

stackshare.io

Some links about the good old (and dead?) SSAS Multidimensional Cube

Why doesn’t SSAS cache the entire cube?
Also, if you cube is much larger than the memory available to SSAS, then you would expect to see continual IO, and it is likely to be quite well optimised. However, when you have a 64 bit server with a cube that is larger than 3GB but is comfortably less than the server memory, you might be surprised to see the volume of continual IO.

http://richardlees.blogspot.com/2011/12/why-doesnt-ssas-cache-entire-cube.html

Best Practices for Performance Tuning in SSAS Cubes, you are in right place. Define cascading attribute relationships, for example, day > Month > Quarter > year  and define user hierarchies of related attributes (called natural hierarchies) within each dimension as Appropriate for your data

Best Practices for Performance Tuning in SSAS Cubes, you are in right place. Define cascading attribute relationships, for example, day > Month > Quarter > year  and define user hierarchies of related attributes (called natural hierarchies) within each dimension as Appropriate for your data

Remove redundant relationships between attributes to assist the query execution engine in generating the appropriate query plan. Attributes need to have either a direct or an indirect relationship to key attributes, not both.


https://mindmajix.com/msbi/best-practices-for-performance-tuning-in-ssas-cube

https://kejserbi.wordpress.com/

https://hub.packtpub.com/query-performance-tuning-microsoft-analysis-services-part-1/

https://github.com/RichieBzzzt/SSASActivityMonitor

https://github.com/ssasdiag/SSASDiag

https://christianb7.wordpress.com/2012/11/11/analysis-services-2012-configuration-settings/

https://www.mssqltips.com/sqlservertip/2568/ssas-best-practices-and-performance-optimization-part-4-of-4/

Aardvark’d: 12 Weeks with Geeks

Aardvark’d: 12 Weeks with Geeks is a 2005 documentary film about the development of Fog Creek Copilot, a remote assistance software tool. Conceptualization of the film began when Fog Creek Software CEO Joel Spolsky announced on his blog that he was seeking a filmmaker to document the development of the product, then called Project Aardvark.[1][2]

https://en.wikipedia.org/wiki/Aardvark%27d:_12_Weeks_with_Geeks

https://www.imdb.com/title/tt0813987/

Hardcore Software by Steven Sinofsky

Hardcore Software is a non-fiction, first-person account of the rise and fall of the PC revolution serialized through this platform, one section at a time, once or twice a week.

https://hardcoresoftware.learningbyshipping.com/archive

Through this first person account of Steven Sinofsky’s time at Microsoft, he aim to convey to you an insider’s story of growing influence and corporate obstacles, the evolution of technology that changed the world, and most of all the people that made it happen.

Check out companion videos and demonstrations of legacy products on the YouTube Channel.

https://hardcoresoftware.learningbyshipping.com/archive

What is it like to work with Microsoft’s Dave Cutler?

Dave is one of the most inspiring people I worked with (not closely, to be clear). Not only did he lead the team that built a new OS from scratch that was still compatible with DOS-based Windows, with many features on day one that took years to arrive in competitor’s products, he personally designed and coded the portable, multithreading, multiprocessor, secure NT kernel. He was brilliant.

https://www.quora.com/What-is-it-like-to-work-with-Microsofts-Dave-Cutler

Ex-Microsoft programmer Dave Plummer: I wrote Task Manager

The Microsoft developer who wrote Task Manager, along with other utilities and games, has popped up to „write this stuff down before I forget it all“.

A post on Reddit goes into detail about the tool, familiar to every Windows expert, which if you are lucky lets you terminate errant applications or processes, as well as providing some handy stats on how your PC is or is not performing.

Dave Plummer, or davepl, „started in MS-DOS in 1993 and spent a little more than a decade at Microsoft, leaving after Server 2003“, he told the University of Regina. He talked about the challenges of „coding for a billion machines“, saying: „It’s like you’re building one bull to be released into an infinite number of china shops.“

https://www.theregister.com/2020/05/26/task_manager_confession/