Navigation:  SQL support > SQL tables

There are three different types on tables in BioUML: in-memory tables, file-based tables and SQL-based tables. SQL-based tables allows user to work with data directly by using SQL console (for example, standard MySQL command line). All analysis results in research projects by default store in SQL-based tables.

 

The structure of table in SQL database is the same as structure of table in BioUML.

 

Figure 12.3. SQL table example in BioUML workbench.

 

In this example table aaa4 is SQL-based table, it's name in SQL database of research project is table_67.

 

mysql> select * from table_67 limit 10;

 

Figure 12.4. Direct SQL query result for table.

 

mysql> explain table_67;

 

Figure 12.5. Explain result for SQL table.

 

NOTE: It is possible to use any SQL console (MySQL console in example above). BioUML provides it's own SQL console.