Index of /mo

	Name	Last modified	Size	Description
	Parent Directory		-
	imdbobda.sql.zip	2013-01-15 16:09	528M
	imdbobda.sql.bz2	2013-01-07 11:02	463M
	README.html	2013-01-15 16:10	1.6K

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

1. Download imdbobda.sql.bz2 to your /tmp folder.
2. Unzip the file:
   $ gunzip2 imdbobda.sql.bz2.
3. Create a new database imdbobda in your PostgreSQL server.
4. Import the schema and data:
   $ psql imdbobda < /tmp/imdbobda.sql postgres

In Windows

1. Download imdbobda.sql.zip to your local folder, e.g., C:\Downloads\
2. Unzip the file.
3. 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;
4. Import the schema and data.
   C:\> psql imdbobda postgres < C:\Downloads\imdbobda.sql