SDB

The SDB download has a number of command line tools: they all expect the environment variables SDBROOT to be set to the location of the SDB installation.

sdbquery SPEC --query=FILE

Execute a query.

sdbprint SPEC --print=X [--sql] --query=FILE

Print details of a query. "X" is any of "query", "prefix", "op", "sqlNode", "sql". --print=X can be repeated.  --sql is short for --print=sql.

sdbsetup SPEC [--create|--format|--indexes|--dropIndexes]

Setup a database. --create formats the store and sets up indexes. --format just formats the store. --indexes and --dropIndexes add or remove the indexes for the layout. Loading large graphs can be faster by formatting, loading the data then building the indexes manually with this command.

sdbload SPEC FILE [FILE ...]

Load RDF data into a store. File extension used to determine the data syntax. Uses the bulk loader.  Data is streamed into the database and is not loaded as a single transaction.

sdbdump SPEC --out=SYNTAX

Dump the contents of a store N-TRIPLES or a given serialization format (usual Jena syntax names, e.g. "Turtle" or "TTL").

sdbtruncate SPEC

Truncate the store.  Non-transactional.  Destroys data.

sdbtest SPEC MANIFEST

Execute a test manifest file.

sdbsql SPEC [ --file=FILE | SQL string ]

Execute a SQL command on the store, using the connection details from the store specification.

sdbscript SPEC

Execute a script (JRuby).

sdbinfo SPEC --out=SYNTAX

Details of a store.

sdbmeta SPEC --out=SYNTAX

Do things with the meta graphs of a store.

Set up

Set the environment variable to the root of the the SDB installation.

Set the environment variables SDB_USER and SDB_PASSWORD to the database user name and password for JDBC.

The directory bin/ contains shell scripts to run this command. The directory bin2/ contains scripts that can be placed on your PATH to call the scripts in bin/ without needing bin/ on the path.

Argument Structure

All commands take a SDB store description to extract the connection and configuration information they need.

Arguments:

• --sdb=<sdb.ttl>

If not specified, commands load the description file sdb.ttl from the current directory, or, failing that from the directory named in SDBROOT.

The individual components of a connection or configuration can be overridden after the description have been read, before it is processed:

SDB configuration:

• --layout : layout name (currently, one of "layout1", "layout2", "layout2/index", "layout2/hash", "layoutRDB")

JDBC parameters:

• --dbName : Database Name
• --dbHost : Host machine name
• --dbType : Database type.
• --dbUser : Database use
• --dbPassword : Database password.

User and password are taken from environment variables SDB_USER and SDB_PASSWORD if not set in the description or command line.

All commands support --help to give details of other named and positional arguments.

--arg=val can also be written --arq val

SDB Documentation Page