SEARCH / BROWSE
BEST PRACTICES
Audio
Databases
Best Practices
Policies
EAD
Imaging
MOA2/METS
TEI
WebGenDB
Websites
PLANNING PROJECTS
LIBRARY WEBSITE
ABOUT DPG
database best practices

Best Practices

Microsoft Access
At this time all DPG supported and maintained web searchable databases are Microsoft Access databases. The new search scripts are in ADO. Older search scripts are in HTX/IDC, although if major changes are needed they will be upgraded to ADO. The production database resides on the DPG NT server, although copies are usually kept on other servers to provide easy access for the project team. Updates and changes are then made to the copy. Periodically the copy is uploaded to the DPG NT server, replacing the existing production copy.

Databases have been created for a number of projects and in a number of ways. DPG can convert an Excel spreadsheet into an Access database or create one from scratch. If an Excel spreadsheet is used, DPG will then provide a copy of the Access database for future maintenance.

For more information on Microsoft Access:
www.microsoft.com/office/access/
databases.about.com/cs/access/

FileMakerPro
The Rock Art database actually comes to us as a FileMakerPro database that DPG then converts to Access and uploads to the DPG NT server. This requires close coordination of any changes that impact the design of the database, e.g., adding or deleting fields.

Procite
DPG will undertake a project with The Bancroft Library to use Procite's Reference Web Poster for providing a web search interface to a Procite database.

| UC Berkeley Library Home | Catalogs | Search the Library Website |
Copyright © 2011 The Regents of the University of California. All rights reserved.
Document maintained by the Digital Publishing Group.
Last updated 05/12/2011. Server manager: contact