MATLAB structed data query: table vs database -


i have sqligt db. contains few tables. outer join, have larger table columns.

c1 c2 c3 c4 c5 .. .. .. .. .. .. .. .. .. .. 

the typical operations find slice table in terms of constraints, example, c1 > 10 & c2 < 23.

i wondering better way query structured data in matlab.

matlab has table data type:

http://www.mathworks.com/help/matlab/tables.html 

it supports intuitive boolean-indexing:

http://www.mathworks.com/help/matlab/matlab_prog/access-data-in-a-table.html 

and join/union/diff operations normal data base. notice table can created either work-space variables or text files. in either case, guess has load data memory. how performance? salable when data large.

matlab has data base interface:

http://www.mathworks.com/help/database/ug/database.html?searchhighlight=database 

will better in terms of performance? not have friendly query syntax boolean-indexing.

in case, table of size 1g on average, of size 200g @ worst case.

what best way present , query structured data in matlab?

your search queries rather standard sql operations. use matlab sqlite conection , use fetch load data need.


Comments

Popular posts from this blog

javascript - Thinglink image not visible until browser resize -

firebird - Error "invalid transaction handle (expecting explicit transaction start)" executing script from Delphi -

mongodb - How to keep track of users making Stripe Payments -