DATABASE

 SQL DATABASE
 

Data needed to drive the presentation layer are placed in a Microsoft SQL database. This database mainly stores display information. The appearance of collections depends partly on data stored in the database. This data tells the presentation layer where to look for the stylesheets and banners. It also contains the information about the hierarchy of collections. The bridge between the presentation layer and the greenstone collection(s) is stored in this database.

The database also stores basic information to assist with the display of items from Greenstone. This includes the watermarks (or icons) on the left navigation bar, downloads, and the table of contents.

With the recent incorporation of JPEG2000 zoomable images, all of the page turning and page image information is stored in the SQL database. Previously, as the user stepped through each page, the web server would have to return to the Greenstone server to get the next JPEG image. Now, this is all accomplished in the SQL database.

 

 RELATED RESOURCES

  • Database diagram [ as HTML | as GIF ]

    This shows the tables and relationships in the database supporting the presentation layer.

 

University of Florida Home Page
© 2004 - 2007 University of Florida George A. Smathers Libraries.
All rights reserved.

Acceptable Use, Copyright, and Disclaimer Statement
Last updated April 28, 2007 - mvs