Database Programming Using Matlab

by Agus Kurniawan

Learn how to build Matlab program with database interaction. If you have experience with database, this book will help you how to write Matlab and to access database server. This book covers three database MySQL, SQL Server, and Oracle.**TOC**1. Preparing Development Environment1.1 Database Toolbox1.2 Testing Environment2. Hello World - Connecting to Database Server2.1 Database Configuration2.1.1 MySQL2.1.2 Microsoft SQL Server2.1.3 Oracle2.2 Connectivity Testing2.2.1 Testing for Matlab and MySQL2.2.2 Testing for Matlab and Microsoft SQL Server2.2.3 Testing for Matlab and Oracle3. Database Table Operations3.1 What are Table Operations?3.2 Inserting Data3.3 Reading Data3.4 Updating Data3.5 Deleting Data3.6 Finding Data4. Stored Procedures4.1 Creating Stored Procedure4.1.1 MySQL4.1.2 SQL Server4.1.3 Oracle4.2 Executing a Stored Procedure4.2.1 MySQL and MS SQL Server4.2.2 Oracle4.3 Stored Procedure with Parameters4.3.1 Creating A Stored Procedure4.3.2 Executing Matlab and MySQL/SQL Server4.3.3 Executing Matlab and Oracle5. Working with Image and Binary Data5.1 Image and Binary Data5.2 Inserting Data5.3 Reading Data6. Transactions6.1 What is a Transaction?6.2 Case 1 - Transaction without Committing6.3 Case 2 - Transaction with Committing6.4 Case 3 - Rollback

65 pages, Kindle Edition

First published June 8, 2013