JMDB - Java Movie Database V0.91 beta
http://www.jmdb.de


1. Introduction
2. What you need
3. Where to get the files
4. Installation of other used programs
5. Installation and starting JMDB
6. Using JMDB
7. Contacting the autors
8. Disclaimer


************************************************************
**********            1. Introduction             **********
************************************************************

First of all: We are NOT IMDb! We don't have any connection to IMDb.
              JMDB (or "Java Movie Database") is the name of our own
              program that only USES data files from IMDb.

Java Movie Database is a Java based application for searching and getting
information about movies, actors and all that has to do with these.

The information is nearly the same as you can get when using the IMDb web
page at http://www.imdb.com.

The difference is that JMDB is an alternative form of navigating through
this information, is able to run on a stand-alone PC just as in a network
environment.

Another advantage is that you can write your own programs to use the same
locally installed database you have after running JMDB.



************************************************************
**********            2. What you need            **********
************************************************************

1. this package or alternatively a newer one ;)
2. the database MySQL 3.23.xx or newer
3. a Java 1.3 runtime library (JRE 1.3) or newer
4. a Java JDBC driver (e.g. MM MySQL Driver) for the connection to MySQL
5. the IMDb text files
6. one or more computers capable of running the above

As you can see, you basically must be able to run MySQL and Java.
This means that you can run it on most platforms, including
Windows, Linux, any Unix, OS/2.



************************************************************
**********       3. Where to get the files        **********
************************************************************

3.1 JAVA MOVIE DATABASE:
------------------------
You can download JMDB and get information about it at:
http://www.jmdb.de.


3.2 MySQL DATABASE:
-------------------
MySQL can be downloaded from:
http://www.mysql.com (click on OS-specific).

Note for OS/2 users: 
--------------------
For the latest OS/2 versions of MySQL you can alternativly check out:
http://www.quasarbbs.com/yuri/mysql2/index.html
Yuri Dario ported the latest versions of MySQL to OS/2.


3.3 JAVA RUNTIME:
-----------------
A Java runtime can be downloaded at:
http://www.sun.com 
http://www.ibm.com
and others

Note for OS/2 users: 
--------------------
The IBM OS/2 JRE 1.3 and newer are not free!
You have to subscribe to IBM Software Choice which offers you more than 
just the JRE or you can buy the eComStation (short eCS) from Serenity Systems.
The eComStation is a basic OS/2 Warp(Server) with included JRE 1.3!

eComStation........: http://www.ecomstation.com/
                     or
                     http://www.serenity-systems.com/
IBM Software Choice: http://service.software.ibm.com/asd-bin/doc/index.htm


3.4 MM MySQL DRIVER:
--------------------
You can get the latest MM MySQL Driver (Type 4) from Mark Matthew at:
http://mmmysql.sourceforge.net/


3.5 INTERNET MOVIE DATABASE:
----------------------------
The Internet Movie Database (IMDb) is reachable at:
http://www.imdb.com


The FTP sites for the text files are listed here:
http://us.imdb.com/interfaces

You can alternativly click at "Index" (at the bottom of the main) and 
"Interfaces" when you are at the main page of IMDb.


The text files you must have before running JMDB are at one of the following sites:
ftp://ftp.imdb.com/pub/interfaces/
ftp://ftp.fu-berlin.de/pub/misc/movies/database/
ftp://ftp.funet.fi/pub/mirrors/ftp.imdb.com/pub/interfaces/
ftp://ftp.sunet.se/pub/tv+movies/imdb/


You need the following ascii text files at the moment for JMDB. They are compressed
in tar-GNUZip format (.tgz) when you download them:

actors.list
actresses.list
aka-names.list
aka-titles.list
biographies.list
business.list
cinematographers.list
color-info.list
composers.list
costume-designers.list
countries.list
crazy-credits.list
directors.list
distributors.list
editors.list
genres.list
german-aka-titles.list
goofs.list
italian-aka-titles.list
keywords.list
language.list
miscellaneous.list
movies.list
mpaa-ratings-reasons.list
plot.list
producers.list
production-companies.list
production-designers.list
quotes.list
ratings.list
release-dates.list
running-times.list
taglines.list
technical.list
trivia.list
writers.list



************************************************************
********** 4. Installation of other used programs **********
************************************************************

4.1 MySQL:
----------
Install MySQL as described in the documentation of MySQL.
Then you (may) have to add the correct user rights so that the user
that will run JMDB has the privileges to connect to the database.

Try this command from a MySQL client running as root:

Insert into user (Host, User, Password, Select_priv, Insert_priv,
Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv,
Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv,
Index_priv, Alter_priv) values("%","username",PASSWORD("password"),"Y",
"Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y");

You have to insert the correct username and password, of course.


4.2 Java Runtime:
-----------------
Install it so that you can run java with the command "java" from the
command line.


4.3 IMDb text files:
--------------------
Decompress all the IMDb data files (*.list) into one directory.
The files are in an *.gz format.

4.3a - Windows users can use WinZip to extract the files.
4.3b - OS/2 users have to get Till Steinbrechers UNTGZ V0.95 (Feb. 17 1997) from 
       hobbes ("http://hobbes.nmsu.edu/cgi-bin/h-search?key=untgz095")



************************************************************
**********   5. Installation and starting JMDB    **********
************************************************************

BASIC INSTALL DESCRIPTION:
--------------------------
- Decompress all the IMDb data files (*.list) into one directory.

- Decompress all the files of the JMDB package into one directory, for
  example /usr/local/bin/jmdb (Unix) or C:\JMDB (OS/2 or Windows).

- Change to the JMDB-directory at the command line.

- Windows user: Run startwin.bat for starting JMDB. Links on the desktop
                have to be created manually.
  OS/2 user: Run instos2.cmd: It can create WPS Objects for JMDB and can
             also create a file named "jmdbos2.cmd", which you can run.
             Run startos2.cmd alternatively after editing.
  Linux user: Run startlinux for starting JMDB.

  Desktop icons for Windows and OS/2 can be found in the graphics
  subdirectory.

- The first thing you have to do is to set the correct paths and user
  information in the "File" -> "Setup" window.

- To continue you have to start the MySQL Server (MYSQLD.EXE)
  JMDB needs a connetion to the installed database.

- When you have setup JMDB and you have a working MySQL Server running 
  you have to convert the IMDb text files into a MySQL database. 
  Use "File" -> "Create Database" for this.
  This will take SEVERAL HOURS and only has to be done once! 
  So start this at night, when you don't use you PC or you don't need
  the full power of it.

- When database conversion is finished, you can use the database. Try a
  "File" -> "New Search" for example.
  The IMDb text files are not used any more, so you can delete them from
  your harddisk to save space (about 400 MB).



OS/2 INSTALL DESCRIPTION:
-------------------------
There are two ways to install JMDB (JMDB*.WPI and JMDB*.ZIP).

a) If you have installed WarpIN (the ulimative OS/2 software installer),
   you should get the JMDB*.WPI archive.
   All you have to do is double click onto this archive.
   After that you can follow the steps shown on screen.

b) When you have got the JMDB*.ZIP archive, you have to create a directory,
   where you want to install JMDB.
   Move the file to that directory and unzip the file:
   UNZIP JMDB*.ZIP
   or
   PKUNZIP2 -d JMDB*.ZIP   // '-d' is needed to create the directory
                              structure stored in .ZIP file
   
   When you have unzipped the JMDB*.ZIP file, you can start the file
   INSTOS2.CMD.
   It searches for an installed Java Runtime Environment 1.3 (JRE 1.3) 
   creates a WPS Folder named "Java Movie Database" which contains some
   program objects. It also creates the file JMDBOS2.CMD

For the rest have a look at the BASIC INSTALL DESCRIPTION.



************************************************************
**********             6. Using JMDB              **********
************************************************************

We hope you discover the functionality of JMDB by simply using it.

Some windows have a "Help" button. All you have to know when USING the
program is in that help file, which you can alternatively read with any
html-Browser. The file is located in the "doc"-Directory.



************************************************************
**********       7. Contacting the autors         **********
************************************************************

The autors of this software are:
Uwe Freese     : program design, layout and creator of most things that
                 have nothing to do with SQL and the database itself,
                 webpage, testing MySQL on a linux machine
Juergen Ulbts  : data import/export, querys, table design, program
                 design, OS/2 support (testing, development, install 
                 scripts)

If you think you have bug reports or suggestions for future releases,
look at the JMDB site for contacting us: http://www.jmdb.de



************************************************************
**********             8. Disclaimer              **********
************************************************************

Many thanks go to the following people:
---------------------------------------
Linus Torwald     - Thank you for Linux!
Yuri Dario        - Thank you for porting a newer MySQL version to OS/2!
Mark Matthew      - Thank you for the Java MySQL-JDBC driver!
Thorsten Thielen  - Many thanks to you and the german TeamOS/2 groups

Then many thanks to all other individuals we forgot! ;)


Many thanks go to the following companies/groups:
-------------------------------------------------
IMDb              - Many thanks to all people working for the 
                    'Internet Movie Database'!
                    Without your effort in collecting information about the 
                    movie industry and providing the information as text files,
                    our program wouldn't exist.
MySQL AB          - Thank you for developing MySQL!
Sun Microsystems  - Thank you for developing JAVA and providing us with
                    the JDK and JREs!
IBM Corporation   - Thank you for the JDK, the JRE, Visual Age for Java!
                    Please continue the development of Visual Age for Java
                    (especially the OS/2 version).
                    Then "buy" some marketing guys from Microsoft, so you can
                    sell your good products (OS/2; Visual Age Series) instead
                    of placing it in the darkest room you can find in the 
                    Austin headquarter.
                    I hope the guys from Serenity Systems will make a better
                    marketing job, so eCS (OS/2) will be a success.
                    Many thanks you allow Serenity Systems to sell OS/2 as eCS.
Serenity Systems  - Thank you for selling OS/2 and adding some nice components
                    like WiseManager and Desktop on a call. 
OS2.ORG & TeamOS/2- Thank you for all the news


TRADEMARKS:
-----------
IMDb is a trademark of the Internet Movie Database
Java is a trademark of Sun Microsystems.
Windows is a trademark of Microsoft Corporation.
OS/2 is a trademark of IBM Corporation.
eComStation and eCS is a trademark of Serenity Systems.