mirror of
https://github.com/Wisser/Jailer.git
synced 2026-01-02 09:19:44 -06:00
150 lines
6.2 KiB
HTML
150 lines
6.2 KiB
HTML
<html xmlns="http://www.w3.org/1999/xhtml">
|
|
<head>
|
|
<title>Jailer - Data Browsing</title>
|
|
<meta content="text/html; charset=us-ascii" http-equiv="Content-Type" />
|
|
<meta content="Data Export Tool" name="description" />
|
|
<link href="favicon.ico" rel="shortcut icon" />
|
|
<meta content="data export referential integrity java jdbc dbms" name="keywords" />
|
|
<link href="styles.css" rel="stylesheet" type="text/css" />
|
|
</head>
|
|
<body left-margin="0" top-margin="0">
|
|
<div align="left">
|
|
<table border="0" cellpadding="0" cellspacing="0" height="407" style="left: 0pt; top: 0pt; text-align: left; position: absolute;" width="100%">
|
|
<tbody>
|
|
<tr>
|
|
<td class="bannerbackground" colspan="2" height="33" width="100%">
|
|
<table border="0" cellpadding="4" cellspacing="0" width="100%">
|
|
<tbody>
|
|
<tr>
|
|
<td><a href="https://github.com/Wisser/Jailer"><img src="logo.png" hspace="10" /></td> <td class="slogan" width="100%"></a>
|
|
|
|
<td style="width: 100%; text-align: right;">
|
|
<table border="0" cellpadding="0" cellspacing="0" width="100%">
|
|
<tbody>
|
|
<tr>
|
|
<td><a href="https://github.com/Wisser/Jailer"><img src="GitHub-Mark-64px.png" title="GitHub" /></a> </td></tr><tr style="height: 100%;"><td> </td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td class="nav1background" colspan="2" width="100%"> <b><font color="#ffffff"><a class="tlink" href="home.htm" target="_self"> Home </a> <a class="tlink" href="quicktour.htm" target="_self"> Quick Tour </a> <a class="tlink" href="exporting-data.htm" target="_self"> Tutorial </a> <a class="tlinkA" href="data-browsing.html" target="_self"> Data Browser </a> <a class="tlink" href="videos.html" target="_self"> Videos </a> <a class="tlink" href="faq.html" target="_self"> FAQ </a> <a class="tlink" href="api.html" target="_self"> API </a> <a class="tlink" href="design.htm" target="_self"> Documentation </a> <a class="tlink" href="http://sourceforge.net/forum/?group_id=197260" target="_self"> Forum </a> <a class="tlink" href="http://sourceforge.net/project/showfiles.php?group_id=197260" target="_self"> Download </a> </font></b></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="spacer" colspan="2" width="100%"></td> </tr><tr><td class="lmenucontainer"> </td>
|
|
</tr>
|
|
<tr>
|
|
<td class="lmenucontainer" height="100%" valign="top" width="14%">
|
|
<div align="center">
|
|
<center>
|
|
<table border="0" cellpadding="0" cellspacing="0" width="100%">
|
|
<tbody>
|
|
<tr>
|
|
<td height="6px" width="100%"> </td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</center>
|
|
</div>
|
|
|
|
<ul>
|
|
<li><a class="mlinkA" href="data-browsing.html" target="_self">Data Browser</a> </li>
|
|
</ul>
|
|
|
|
<table border="0" cellpadding="0" cellspacing="0" width="100%">
|
|
<tbody>
|
|
<tr>
|
|
<td class="content2background"><img alt="" src="architecture-Dateien/vgradp.gif" style="width: 160px; height: 1px;" /></td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
|
|
<p> </p>
|
|
</td>
|
|
<td class="contentbackground" height="418" valign="top" width="86%">
|
|
<div align="right">
|
|
<table border="0" cellpadding="0" cellspacing="0" height="542" width="98%">
|
|
<tbody>
|
|
<tr>
|
|
<td class="contentbackground" height="21" width="100%"> </td>
|
|
</tr>
|
|
<tr>
|
|
<td class="content" height="520" valign="top" width="100%">
|
|
<h3>Relational Data Browsing</h3>
|
|
|
|
Navigate bidirectionally through the database by following foreign key based or user defined relationships<br>
|
|
<a href="#video"><img src="video.png" /></a><br />
|
|
<br />
|
|
<a href="screenshot.html"><img src="data-browser-small.png" /></a> <br />
|
|
<h3>The Data Browser</h3>
|
|
|
|
<p><img alt="" src="db1.png" /></p>
|
|
<br />
|
|
<h3>All begins with the first table</h3>
|
|
Open Table "EMPLOYEE".<br>
|
|
<p><img alt="" src="db2.png" /></p>
|
|
<br />
|
|
Our first table with the data of all employees appears.<br>
|
|
<p><img alt="" src="db3.png" /></p>
|
|
<br />
|
|
<h3>Where do they all work?</h3>
|
|
|
|
Under "Related Rows" we find the "DEPARTMENT" table.<br>
|
|
<p><img alt="" src="db4.png" /></p>
|
|
<br>
|
|
The "DEPARTMENT" table appears and shows not only all departments, but also which employee belongs to which department.<br>
|
|
<p><img alt="" src="db5.png" /></p>
|
|
<br />
|
|
<h3>And what are they actually working on?</h3>
|
|
In the "Closure" view we can see with which tables the selected table is related. Moreover, also the relations of these and so on.
|
|
<br>
|
|
<p><img alt="" src="db6.png" /></p>
|
|
<br>
|
|
With a double click on "PROJECT" the table "PROJECT_PARTICIPATION" opens and with it connected "PROJECT".<br>
|
|
<p><img alt="" src="db7.png" /></p>
|
|
<br>
|
|
We can minimize the "PROJECT_PARTIPITATION" table...<br>
|
|
<p><img alt="" src="db8.png" /></p>
|
|
<br>
|
|
...to see the relationship between employees and projects directly.<br>
|
|
<p><img alt="" src="db9.png" /></p>
|
|
<br>
|
|
<h3>The way to the SQL console</h3>
|
|
<p>From the network of interconnected tables on the desktop, we can automatically create an SQL query that will retrieve exactly the same data that can be seen here.
|
|
</p>
|
|
<p>Use the menu item "Query Builder (Ctrl+Q)" to make some adjustments to this query first.<br>
|
|
Use "SQL Console (Ctrl+Enter)" to go directly to the SQL console.
|
|
</p>
|
|
<p><img alt="" src="db11.png" /></p>
|
|
<br>
|
|
Using the console, we can then make whatever queries we want, view the results, and do all the things we usually do with such tools.
|
|
<p><img alt="" src="db10.png" /></p>
|
|
<br>
|
|
<h3>Video</h3>
|
|
<video id="video" src="animated/DataBrowser.mp4" controls></video><br>
|
|
<h3>Exporting data using the Data Browser</h3>
|
|
<video id="SubsetByExample" src="animated/SubsetByExample.mp4" controls></video>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
|
|
<p> </p>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td height="12" valign="top" width="14%"> </td>
|
|
<td> </td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</body>
|
|
</html>
|