Code covered by the BSD License  

Highlights from
Biomet Database Tool

Be the first to rate this file! 11 Downloads (last 30 days) File Size: 453.65 KB File ID: #28101
image thumbnail

Biomet Database Tool

by Jeremy Smith

 

01 Jul 2010 (Updated 15 Dec 2010)

This is a general database and plotting tool that lets the user plot data directly from a database.

| Watch this File

File Information
Description

The Biomet Database Tool (BDT) was designed to be a simple front end to MS Access and MySQL databases as well as a graphical analysis tool. The interface itself is quite simple but still lets the user do more complex operations for those willing to read the help (press F1 with BDT open).

BDT can load data (from databases, the workspace, or files), plot the data, export/save the data, and give the user a quick method of cropping data visually. No coding is required to do any of this. Data points are selectable on the plot and can be displayed along with the raw data, highlighting the values selected in the plot. Points deleted from the plot are replaced by NaN's.

Important: BDT was programmed without a primary key in mind for databases so it must have a column to order the data by. Define as many columns as you need in the preferences section of the BDT code.

Funding has been provided by the US Department of Energy USDOE-TCP Grant #DE-FG02-03ER6384 (T.J. Griffis and J.M. Baker) and the National Science Foundation Career Award, NSF-ATM-0546476 (T.J. Griffis).

BDT was programmed by Jeremy Smith with the exception of the fr_function_fit set of functions by Kai Morgenstern (Biomet and Soil Physics Group at the University of British Columbia) and the Least Square Fit functions by Edward T Peltzer, MBARI.

For a better screenshot please refer to http://www.biometeorology.umn.edu/images/BDT_Screenshot.jpg.

MATLAB release MATLAB 7.1.0 (R14SP3)
Other requirements Any database components require the Database Toolbox but it's not needed for anything else.
Tags for This File  
Everyone's Tags
Tags I've Applied
Add New Tags Please login to tag files.
Comments and Ratings (3)
01 Nov 2011 Corey

I'm receiving an error when I try to run BDT.exe - Windows can't find "mclmcrrt76.dll". Can you tell me what version of the Matlab compiler you used to generate this executable?

28 Nov 2011 Adam

Will this also connect to mssql?

16 Mar 2012 Jeremy Smith

I believe I compiled it in Matlab 7.1.0.

BDT has been tested with MySQL and Microsoft Access. It can connect directly to MySQL but everything else must be setup through the ODBC Administrator in Windows. It also assumes the SQL syntax is compatible.

Please login to add a comment or rating.
Updates
12 Jul 2010

Column Information - Metadata wasn't always displayed in MySQL tables or the General column of the General table.

15 Dec 2010

Windows Issue: Due to Windows security BDT will experience an issue updating the list of databases when not running as administrator. Run the built-in database function getdatasources once as administrator to properly update the file.

Tag Activity for this File
Tag Applied By Date/Time
bdt Jeremy Smith 02 Jul 2010 09:40:07
access Jeremy Smith 02 Jul 2010 09:40:08
ms access Jeremy Smith 02 Jul 2010 09:40:08
database Jeremy Smith 02 Jul 2010 09:40:08
mysql Jeremy Smith 02 Jul 2010 09:40:08
gui Jeremy Smith 02 Jul 2010 09:40:08

Contact us at files@mathworks.com