blob: 5675432aefafe77209ada3c0c78e87f165134d08 [file] [log] [blame] [view]
---
title: SDB Quickstart
---
----
> The Apache Jena SDB module has been retired and is no longer supported.<br/>
> The last release of Jena with this module was Apache Jena 3.17.0.<br/>
----
SDB provides some command line tools to work with SDB triple
stores. In the following it assumed that you have a store
description set up for your database (`sdb.ttl`). See the
[store description format](store_description.html "SDB/Store Description")
for details. The `Store/` directory for some examples.
### Setting up your environment
$ export SDBROOT=/path/to/sdb
$ export PATH=$SDBROOT/bin:$PATH
$ export SDB_USER=YourDatabaseUserName
$ export SDB_PASSWORD=YourDatabasePassword
$ export SDB_JDBC=YourJDBCdriver
### Initialising the database
Be aware that this will wipe existing data from the database.
$ sdbconfig --sdb sdb.ttl --format
This creates a basic layout. It does *not* add all indexes to the
triple table, which may be left until after loading.
### Loading data
$ sdbload --sdb sdb.ttl file.rdf
You might want to add the `--verbose` flag to show the load as it
progresses.
### Adding indexes
You need to do this at some point if you want your queries to
execute in a reasonable time.
$ sdbconfig --sdb sdb.ttl --index
### Query
$ sdbquery --sdb sdb.ttl 'SELECT * WHERE { ?s a ?p }'
$ sdbquery --sdb sdb.ttl --file query.rq