Rank: 473324 based on 0 downloads (last 30 days) and 0 file submitted
photo

Robin Jens

E-mail

Personal Profile:
Professional Interests:

 

Watch this Author's files

 

Comments and Ratings by Robin Jens View all
Updated File Comments Rating
02 May 2012 Fetch (Big) Fetch command useful for SELECT queries on large data sets. Author: Tucker McClure

Thanks Tucker

I tried your code an compared it with the code I normally use when I import data from an Access database to matlab.

Your code:

conn = database('DATABASE1', '', '');
setdbpref('DataReturnFormat','cellarray');
y = fetch_big(conn, 'select * from TABLE1');
test=y(:,[1 2 3 4]);

It took around 0.3seconds to import a cell array with the dimensions 200x20 with numeric data and strings.
Elapsed time is 0.032313 seconds.
Elapsed time is 0.027668 seconds.
Elapsed time is 0.028188 seconds.
Elapsed time is 0.032034 seconds.
Elapsed time is 0.028520 seconds.

My old code:

conn = database('DATABASE1', '', '');
curs=exec(conn,'select * from TABLE1')
setdbprefs('DataReturnFormat','cellarray');
curs = fetch(curs);
y=curs.Data;
test=curs.Data(:,[1 2 3 4]);
close(curs)

My old code seems to be faster. Is it because it is only a small amount of data I import and therefore preallocate does not have any impact on the time?

Elapsed time is 0.016508 seconds.
Elapsed time is 0.015066 seconds.
Elapsed time is 0.015458 seconds.
Elapsed time is 0.015469 seconds.
Elapsed time is 0.015922 seconds.
Elapsed time is 0.015577 seconds.

29 Apr 2012 Fetch (Big) Fetch command useful for SELECT queries on large data sets. Author: Tucker McClure

Dear Tucker

I have a question. Assume I have an Access database. The name of the Access database is DATABASE1. In this database I have different tables. I want to import all column in the table called TABLE1. How should the code look like if I want to use your function?I tried:
%conn = database('DATABASE1', '', '');
curs=exec(conn,'select * from TABLE1');
setdbprefs('DataReturnFormat','cellarray');
curs = fetch_big(conn,curs)
y=curs.Data

Best Regards

Robin

15 Sep 2011 MMTensor 1.0 A tutorial for micromechanical computations with elasticity, fabric and Eshelby tensors. Author: Maarten Moesen

Hi Maarten

Very nice code. Normally I use classical laminate theory (ABD matrix) to calculate elastic constants for laminates with continuous fiber. The problem is my code is only possible to calculate inplane properties E11, E22, G12, V12, V21.
Have you tried to calculate elastic constants for laminates with continuous fibers with your micro mechanical model?Maybe also compared it with classical laminate theory?

02 Aug 2011 FELICITY Finite ELement Implementation and Computational Interface Tool for You Author: Shawn Walker

Hi Shawn

Now I installed the following version of Microsoft Windows SDK 7.1

x64 ISO File Name: GRMSDKX_EN_DVD.iso

CRC#: 0x04F59E55

SHA1: 0x9203529F5F70D556A60C37F118A95214E6D10B5A

First I installed Microsoft Visual C++ 2010 Express as you proposed, but still it cannot find the C++ compiler in matlab when I write mex -setup

31 Jul 2011 FELICITY Finite ELement Implementation and Computational Interface Tool for You Author: Shawn Walker

Hi Shawn

Which version of Visual C++ edition did you install? In fact I have a 64bit version of matlab R2010a on a Windows 7 computer. Could you send a link where I can download a 64 bit version of Visual C++ express for free?

Contact us