MATLAB: How do i load database in m file

databaseImage Processing Toolbox

how do i load database in m file? so that i could match value of variable with values stored in database field? A quick reply will be really appreciated. thank you

Best Answer

In https://www.mathworks.com/matlabcentral/answers/340650-how-can-i-match-a-value-in-variable-with-data-stored-in-database#comment_455338 you indicate that your database is stored in an SQL server.

You cannot meaningfully load an SQL database into a MATLAB session. What you can do is make queries against a database to retrieve the information stored there. For information about that, see https://www.mathworks.com/help/database/import-data.html

... However, it is questionable as to why you bothered to store your license plate related information in an SQL server, unless you have a lot of license plate information. containers.Map() would probably be sufficient for your purposes.

Related Solutions

MATLAB: How can i match a value in variable with data stored in database

Hello Dear,

Use this code with some changes as per your requirement:

 clc;
clear all
X = [1 323 2 44 3 66 77 88 2 1 2 3 34 56 78 5 7 4 44 28]; %DataBase
b = input('enter the number you want to check:');
n = find(X==b);
A = isempty(X(n));
if A==1
    disp('The number is not present in database');
else 
    disp('The number is present in database');
end

MATLAB: Access Apache Hive using ODBC driver

I've tested Hive access via JDBC Driver, but not ODBC Driver yet, but I think possibly, yes.

First, 64 bit ODBC Driver is requied.

Next, configure ODBC data source in Database Toolbox. And I think you can access to Hive

datasource = 'Hive'; % The name of datasource specified in configureODBCDataSource
username = 'XXX';
password = 'YYY';
conn = database(datasource, username, password);
selectquery = 'SELECT TOP 10 * FROM TABLENAME';
data = select(conn,selectquery);

Ref: https://www.mathworks.com/help/database/ug/database.html#btcofz6

Best Answer

Related Solutions

MATLAB: How can i match a value in variable with data stored in database

MATLAB: Access Apache Hive using ODBC driver

Related Question