SDB/Quickstart

From Jena Wiki

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 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