Code covered by the BSD License  

Highlights from
Database Handler

Be the first to rate this file! 6 Downloads (last 30 days) File Size: 3.12 KB File ID: #28083
image thumbnail

Database Handler

by Fayssal El Moufatich

 

30 Jun 2010

Read, Insert, Delete, Update and execute Sql Queries from a database source.

| Watch this File

File Information
Description

This class abstracts database standard operations into a MATLAB class. All that is required is a correctly formatted connection string. The class uses under the hood the database machinery of the .NET framework.

Query results are encapsulated into MATLAB datasets for an efficient usage of the retrieved data tables.

Usage:

dbHanldler = DatabaseHandler(connectionString);

Retrieving Table Data Example:

tableDataset = dbHandler.SelectAll('TableName');

MATLAB release MATLAB 7.10 (R2010a)
Tags for This File  
Everyone's Tags
crude, database(3), database queries, dataset(2), net(2), sql
Tags I've Applied
Add New Tags Please login to tag files.
Please login to add a comment or rating.
Comments and Ratings (3)
11 Apr 2012 Dennis

Hi Fayassal,
any chance you could point me in the right direction for modifying the database handler to output to a structure? I'm new to matlab, so any help is appreciated.

Thanks,
Dennis
01 Feb 2011 Fayssal El Moufatich

Hi Gavin,

That is true! The output will be accustomed to a Dataset. Unfortunately, the Dataset Data Type is part of the Statistics toolbox. I hope Mathworks would integrate the feature also in basic MATLAB. The database handler could be also modified to output a cell array or a structure.

Best regards,
Fayssal
24 Jan 2011 Gavin

Tried to use this, and I am having problems. Looks to use the 'dataset' command from the Statistics toolbox, which I don't have.

Contact us