JMDB - Java Movie Database V0.9 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.