Page Tag

An application for tagging pages in a digital library.

Home Install Admin User Help Changes About

Selecting and Administering the Database System

PageTag supports databases which have a compatible ODBC-JDBC driver. The software has been tested with Microsoft Access™ and MySQL™. Other databases may also work.

ODBC Configuration

The following instructions describe how to set up the ODBC configuration with Microsoft Access and MySQL. Other ODBC configuration should be similar. The key is that the database must support the ODBC-JDBC bridge. Security may be used as long as the user name and password associated with the database match that input during the ODBC configuration.

A PageTag system administrator should be responsible for administering the system wide databases for your site. This will ensure that all projects tagged using the software will use consistent keys. The following is a description of each database and its contents. Sample databases are provided in Microsoft Access for your convenience.

The database DSNs that are used by PageTag include:

PageTagProject

There is one table in the Project database, the Feature table. The Feature table contains a comprehensive list of relevant Feature IDs and associated Feature Strings for all projects. The content of each of this table is set up by the PageTag administrator for use by all operators. PageTag treats this table as read-only.

PageTagDB

This database contains 2 tables, relating to a set of image files being tagged. The first table is called Item. The Item table contains a unique identifer, ItemID, and a descriptive IDString that is associated with each set of images edited. The second table is called Page. It contains the mappings for page number and tag to the image files. This table is generated by the PageTag software and updated whenever the user commits changes.

Database Schema

PageTagProject database, Feature table:

FeatureID (int), FeatureString (string), KeyEvent (string)

PageTagDB database, Item table:

PageID (int), IDString (string), LastUpdate (string), EditComplete (boolean)

PageTagDB database, Page table:

ImageID (int), PageNumber (string), PageFeature (int), ImageFilename(string), cnf (int)

The PageTagProject database Feature Table must be fully populated by a knowledgeable user within each organization prior to making PageTag available for use by operators. It contains all of the organization specific information regarding tags that will be used and function key assignments for specific features.

ODBC Configuration using Microsoft Access

Databases used with PageTag must be added to the ODBC configuration. In Windows machines, this means accessing the Control Panel, Administrative Tools, Data Sources (ODBC). This brings up the ODBC Data Source Administrator dialog. Select the "System DSN" tab and then add the database as follows.

Choose "Add ...", then select the appropriate driver from the list. The following is an example of how to add a Microsoft Access database:

Choose "Microsoft Access Driver (*.mdb)" from the list. In the "Data Source Name" field, enter the Database Name (given below). In the "Description" field, you may enter anything that you want. Select the database on disk using the "Select ...". Browse for the file on disk, and then press "OK".

If a login and password were used when configuring the database with Microsoft Access, then specify the same login and password for ODBC use by pressing the "Advanced" button on the ODBC Microsoft Access Configuration Setup window and inputting the correct information there.

Creating MySQL tables

To create databases in MySQL from the mysql prompt, type the following:

• create database PageTagDB;

• create database PageTagProject;

To create the tables in the PageTagProject database, from the mysql prompt, type the following:

• use PageTagProject;
• create table Project (ProjectID int(4) unsigned, ProjectName VARCHAR(40));
• create table Feature (FeatureID int(4) unsigned, FeatureString VARCHAR(40), KeyEvent VARCHAR(10));

To create the tables in the PageTagDB database, from the mysql prompt, type the following:

• use PageTagDB;
• create table Item (ImageID int(4) unsigned, IDString VARCHAR(40), LastUpdate VARCHAR(20), EditComplete (Boolean));
• create table Page (PageID int(4) unsigned, PAgeNumber VARCHAR(20), PageFeature int(4) unsigned, PageID int(4) unsigned, ImageFilename VARCHAR(40), cnf int (4) unsigned) );

The only table that needs to be populated initially is the Feature table in the PageTagProject database. The Feature table includes all of the features that might possibly be tagged at your institution. Please note that the content of this table is institution-specific.

To populate the Feature table, type the following (for example):

• use PageTagProject;
• insert into Feature VALUES (0, " ");
• insert into Feature VALUES (1, "Table of Contents");
• insert into Feature VALUES (2, "Acknowledgements);

etc., as you wish.

ODBC Configuration using MySQL

Databases used with PageTag must be added to the ODBC configuration. In Windows machines, this means accessing the Control Panel, Administrative Tools, Data Sources (ODBC). This brings up the ODBC Data Source Administrator dialog. Select the "System DSN" tab and then add the database as follows. This must be done for each machine that runs PageTag.

Choose "Add ...", then select the appropriate driver from the list. The following is an example of how to add a MySQL database:

Choose "MySQL" from the list. In the "Windows DSN name " field, enter the Database Name (given below). In the "MySQL host (name or IP)" field, enter the name of the host where the MySQL engine is running. In the "MySQL database name" field, enter the name of the database that was used for creating in MySQL. Unless the database was created with privileges for all users, enter a valid login and password in the "User" and "Password" fields.

Page Last Modified: August 8, 2004