Skip to content

Basic Data Navigation

SlashDB is a Resource Oriented Architecture. It means that each URL strongly references to certain document with data. The most important concept is to think of URLs like paths to specific documents in your file system. For example, let's reach out for an XML document of Customer "ALFKI" in our Northwind database:

From this point you may filter the data, drill down using mechanism of following relations, choose needed data structure and finally preferred output document format.

While "discovering" the data using GUI, cURL, programming libraries or a REST client at any moment you may change extension of current URL to receive the same data in more suitable document format.

There are two ways to navigate the databases setup in SlashDB. Users can navigate via the SlashDB online interface or by typing an URL in an internet browser.

Selecting a database by selecting the HTML button will open up to a list of tables in the selected database.

For example, clicking on the HTML button for Chinook (Above) will open up the Chinook database. (Below)

As described in Data Discovery, the database sub-folders allow users to view folders and files in the HTML, JSON, CSV, XML and XSD formats.

Clicking on HTML again will reveal the content of the selected table. For example, selecting Invoice in the Chinook database example will reveal a list of files with an invoice ID. (Below)

Alternatively users can just type in the address bar of an internet browser the URL of the database, table or file they would like to access.

For example, to access the Chinook database via URL, type the following URL in the internet browser's address bar:

https://demo.slashdb.com/db/Chinook.html

The internet browser will open up the list of tables in the Chinook database.

To open the Invoice table type the following:

https://demo.slashdb.com/db/Chinook/Invoice.html

The internet browser will open up the list of files with an invoice ID.

The tables view allows users to browse table rows freely, but more importantly, it allows users to transverse relations.

As an example, in the Chinook database, we pick the Playlist table and see records in it.

To find out what is in the PlaylistID 1 (Music) playlist, click on the button in the column PlaylistTrack.

The view is changed and we can see now the table PlaylistTrack with records for PlaylistID 1. It's an association table for many-to-many relation between Playlist and Track. We can follow next relation to the Track table.

Clicking on the header of the table will take us to a page with all tracks related to PlaylistID 1.

link to all tracks

On the other hand clicking on the HTML button in row for TrackId 1 will take us to details of that track.

Users can keep going further, by finding out which Album, Genre, etc. the song is ID'd under.

PlaylistTrack, Album and Genre are all tables that are searchable in the top level Chinook database. So instead of viewing which songs are on Playlist 1, users can find out which Playlists have Jazz songs by selecting the Genre table.

Alternatively, users can skip all the above and go directly to any table by typing a URL into a internet browser.

https://demo.slashdb.com/db/Chinook/Invoice/InvoiceId/1/Customer.html

The above URL directed the user to the customer with InvoiceId 1. SlashDB follows a consistent format of URL creation. A detailed explanation can be found below:

The URL method is very powerful and allows users to narrow down searches in a variety of ways.

Following Relations

SlashDB allows to easily follow relations between tables by adding to the URL segment a segment with a name of the relation. You can follow as many relations as you need and within each context (table) you may perform additional filtering

Usage:

/[table_name]/[relation_name]

Examples:

https://demo.slashdb.com/db/Chinook/Customer/CustomerId/14/Invoice.html - first find certain Customer (CustomerId = 14) then follow relation "Invoice" to find his inovoices.

https://demo.slashdb.com/db/Chinook/Customer/CustomerId/14/Invoice/InvoiceLine/Track/Album/Artist.html - get list of artists whose music the Customer ever bought

https://demo.slashdb.com/db/Chinook/Customer/CustomerId/14/Invoice/InvoiceDate/2013-03-01../InvoiceLine/Track/Album - get albums bought by Customer 14 after 2013-10-08

Output Document Formats

Each URL represents specific resource and also a format of acquired or sent data. The output format can be changed by simply adding or replacing extension

Usage:

/some/data-discovery/url.csv
/some/data-discovery/url.json
/some/data-discovery/url.xml
/some/data-discovery/url.xsd
/some/data-discovery/url.html
/some/data-discovery/url

Default: .html (when no extension)

Examples:

https://demo.slashdb.com/db/Chinook/Customer/Country/USA - customers from USA in default format (HTML)

https://demo.slashdb.com/db/Chinook/Customer/Country/USA.html - customers from USA in HTML

https://demo.slashdb.com/db/Chinook/Customer/Country/USA.csv - customers from USA in CSV

https://demo.slashdb.com/db/Chinook/Customer/Country/USA.json - customers from USA in JSON

https://demo.slashdb.com/db/Chinook/Customer/Country/USA.xml - customers from USA in XML

https://demo.slashdb.com/db/Chinook/Customer/Country/USA.xsd - XML Schema for customers