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.
Jeremy Smith (2023). Biomet Database Tool (https://www.mathworks.com/matlabcentral/fileexchange/28101-biomet-database-tool), MATLAB Central File Exchange. Retrieved .
MATLAB Release Compatibility
Platform CompatibilityWindows macOS Linux
Inspired by: login
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!
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.
Column Information - Metadata wasn't always displayed in MySQL tables or the General column of the General table.