next

Moe versus Joe

who will have an easier time dealing with his data?

Moe - uses MAT filesJoe - uses a MySQL database
can only read his MAT file in a specific Matlab versionuses MySQL-Matlab interface to access his data from all Matlab versions
cannot access his data easily from C, Perl, Python, R, command linecan access his data from most languages which have a MySQL interface
is limited by Matlab memory in how much data he can queryis only limited by the size of his hard drive
looking for specific data points involves a slow linear search of all dataindexed columns allow very fast searches by only looking at likely matches
complicated queries over many columns and rows in a matrix are hard to codeuse standard syntax designed for multi-column and multi-table queries
everything is a double precision number or a stringfreedom to choose the appropriate data type from many possibilities
update of a single number requires loading and saving the entire mat fileupdates are optimized to only touch the required locations
needs to translate mat files and learn a new interface when a tool other than Matlab is neededuses the same SQL syntax from multiple platforms
needs to take his mat files on the roadcan connect to his MySQL server from anywhere
has to pay big bucksMySQL is free
uses way too much memory and disk spaceoptimized better than you could ever duplicate yourself
only one application can access/modify the data at onceacquisition, automated and manual analysis, web-based systems can all access and modify the data simultaneously without corruption

index :: introduction :: tables :: columns :: relational :: moeVSjoe :: file :: normal :: queries :: conclusion