Database Subsetting Tool
SourceForge.net Logo
 

Relational Data Browsing

Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships


The Data Browser

Start "Jailer 10.4 Data Browser" (or use JailerDataBrowser.sh|bat|exe)


All begins with the first table

Open Table "EMPLOYEE".


Our first table with the data of all employees appears.


Where do they all work?

Under "Related Rows" we find the "DEPARTMENT" table.


The "DEPARTMENT" table appears and shows not only all departments, but also the assignment to each employee.


And what are they actually working on?

In the "Closure" view we can see with which tables the selected table is related. Moreover, also the relations of these and so on.


With a double click on "PROJECT" the table "PROJECT_PARTICIPATION" and connected to it "PROJECT" opens.


We can minimize the "PROJECT_PARTIPITATION" table...


...to see the relationship between collaborators and projects directly.


The way to the SQL console

From the network of interconnected tables on the desktop, an SQL query can be automatically created that returns exactly the same data that is visible here.

Use the menu item "Query Builder (Ctrl+Q)" to make some adjustments to this query first.
Use "SQL Console (Ctrl+Enter)" to go directly to the SQL console.


Inside the console, we can then formulate queries of our choice and view the results and do all the boring stuff we usually do with such tools.