Spotfire vs JMP; mySql and MSSQL
Published:
For visualizing data, both software tools can do almost identical work. Behind the scenes, Spotfire and JMP are quite different in the software engine, which could lead to different performance in different use cases. I have worked with both tools before, and from time to time, I may prefer one tool over the other due to real-world applications.
Both mySql and MSSQL are good options for holding engineering data. I have built both type of database per different business requirements. The query languages are very similar, but in the real-life coding of those queries, between MySQL and MSSQL, almost every query file needs to be rewritten.
The pictures below are generated from Spotfire and JMP using identical sample demo datasets (artificially created and do not represent any real-world data).
Pic1: Spotfire example, whole dataset view
Pic2: JMP example with filtered dataset view
Pic3: JMP example whole dataset view
Pic4: JMP example with filtered dataset view
Pic4: Database, backend, and frontend