how do i load database in m file?

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

Answer 1

[Walter Roberson]

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.

[Rya]

i m doing Vehicle number plate detection, 1st phase is to extract numbers from number plate and the 2nd phase is to check that whether the number is registered in database or not? now kindly clear this solution to me

[Walter Roberson]

What form is your registration data in at the moment?

• A text file, one license plate listed per line, nothing else on the line?
• A text file in csv form, the first field is a double-quoted string, the remaining fields are information about the registered user?
• A set of folders, each named with a license plate, and the folder contains images of that plate?
• An SQL database in which the license plate is a key?

[Rya]

2 option,

[Rya]

[Walter Roberson]

In that case you should be able to use something like

[~, ~, raw] = csvread('YourFile.csv');

Then

[tf, idx] = ismember(lower(DetectedLicensePlate), lower(raw(:,1)) );
if ~tf
  fprintf('Plate not registered, or OCR did not work well enough\n')
else
  fprintf('Plate found at row #%d of database\n', idx);
end

[Rya]

i dont have any file with csv extension, and what is tf, and idx?

Answer 2

[MathReallyWorks]

Hello Rya,

Use this to load the database in your workspace:

1. Go to home

2. Click on Import Data

3. Select your file. (I'll suggest to keep data in excel sheet)

4. A window will appear

5. click on import selection and remember the names of variable(Use that variable name in code given below)

Now, use this code to check whether the particular number is present in database or not.

 clc;
clear all
X = [1 323 2 44 3 66 77 88 2 1 2 3 34 56 78 5 7 4 44 28]; %Sample DataBase 
%Remove above line and replace X by variable name of your 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

[Rya]

[Rya]

It doesn't work