Index of /mo
About IMDB-OBDA
This file contains both DDL and DML for IMDB database.
Import the database schema and
the data stored in this file to your local machine to
run the MovieOntology test cases.
Importing schema and data
Note: We assume that you have already had
PostgreSQL server running in your local machine
In UNIX
- Download imdbobda.sql.bz2 to your
/tmp folder.
- Unzip the file:
$ gunzip2 imdbobda.sql.bz2.
- Create a new database imdbobda in your
PostgreSQL server.
- Import the schema and data:
$ psql imdbobda < /tmp/imdbobda.sql postgres
In Windows
- Download imdbobda.sql.zip to your local folder,
e.g., C:\Downloads\
- Unzip the file.
- Create a new database imdbobda in your
PostgreSQL server. You can create one either
by using
a client GUI application
pgAdmin or through the SQL environment.
- Open a Command Prompt and type:
C:\> psql --username postgres
- The command will take you to the PostgreSQL console.
postgres=# create database imdbobda;
- Import the schema and data.
C:\> psql imdbobda postgres < C:\Downloads\imdbobda.sql