DLXS Database Tables

DLXS uses the MySQL database engine. The database used by the middleware is named "dlxs". Interaction between the database and the DLXS middleware is handled through Perl DBI .

Collection and Group Tables

• The Collection and Group tables are used to store configuration information and are managed through a CGI program called the Collection Manager (collmgr)
• Collection Tables
  • Collection tables to hold fields common to all collections classes
  • Class tables to hold fields that are specific to each class
  • Backup tables, Version table
• Groups Tables
  • A group of collections (for collection coordinators to logically group collections for searching)

Other information required by the middleware that is kept in the database:

• Pageview
• Portfolios (BookBagDB table)
• " sessions" which holds search history, and other session state information needed during the running of the CGI program. In TextClass and FindaidClass, sessions also hold bookbag information. In ImageClass, portfolios are held in a separate MySQL table.

• For example: CioFactory object compares requested collections and groups, authorized collections (see AUTHZD_COLL) and groups to determine what the user is entitled to access.