How to build an interactive database?
102 views (last 30 days)
Hi I'm not asking for specific code or anything. I am just looking for guidance on how to build a user interface for my dataset with over 50 million rows. My end goal is to have a user interface in which the user can filter the data by certain criteria, or through data points. Maybe drop down options to select certain elements in array etc.
Again, I am not asking for code, although it would be appreciated. What are some resources I should look into? Where to start?
Matt C on 25 Jul 2018
One of your options could be to use the Database Explorer App directly in MATLAB as mentioned above. Using this application, you can import, export, and filter data using the user interface. It looks like this option is ideal for someone who is not very familiar with databases or someone who does not want to spend time building a highly custom and functional interface. Another option is to build your own interface. The home page for GUI design in MATLAB can be found here: https://www.mathworks.com/discovery/matlab-gui.html To create a GUI in MATLAB, there are several different options. One of the most efficient methods is to use App Designer, which allows users to quickly and visually generate user interfaces by dragging and dropping components and specifying settings. I think the database functionality you're describing could be built into this application by modifying the generated code for the GUI to include the database code. Some helpful links for App Designer are included below:
Webinar Overview of App Designer: https://www.mathworks.com/videos/app-designer-117921.html
Tutorial of Basic Web Designer App: https://www.mathworks.com/help/matlab/creating_guis/create-a-simple-app-or-gui-using-app-designer.html
The other option is to programmatically develop the UI, but this process is more time-consuming and requires in-depth knowledge of GUI programming in MATLAB.
As for accessing and querying information in a database, the Database Toolbox should contain this functionality. There are functions in this toolbox which allow users to open a connection to a database, query a database, and insert data into a database. Some helpful resources for the Database Toolbox are included below:
Database Toolbox Home: https://www.mathworks.com/help/database/index.html
Connecting to a Relational Database: https://www.mathworks.com/help/database/database-connection.html
Importing Data from a Relational Database: https://www.mathworks.com/help/database/data-import-into-matlab.html