Talis Alto Database

Entity Relationship Diagrams
The entity relationship diagrams indicate how the Talis Alto tables are linked together. The diagrams currently available are:

- Borrower entity relationship diagram  (May 2006)
- Item entity relationship diagram  (May 2006)
- Loan entity relationship diagram  (Jun 2006)
- Reservation entity relationship diagram  (May 2007)
- Interloan entity relationship diagram  (Nov 2006)
- Message entity relationship diagram  (Jun 2006)
- Income Manager entity relationship diagram  (Apr 2007)
- Bookings entity relationship diagram  (Jun 2007)
- Charges entity relationship diagram  (Jun 2007)
- Item Rotation/Item Request entity relationship diagram  (Oct 2007)

- Mobile database entity relationship diagram  (August 2007)

- Entity relationship diagrams help page  (May 2006)

Database Structure Articles
Details on the structure of the Alto database.

- How borrower charges are stored in the Alto database  (Dec 2005)
This article outlines how charges are stored in the prod_talis database.

- Adding messages to the database  (Nov 2005)
This article outlines how messages are stored in the prod_talis database.

- List of Defined sub-types  (Jun 2005)
This article lists the defined sub-type values in the prod_talis database.

- Type status values  (Jun 2008)
This article lists the sub-type values in the TYPE_STATUS table. Link is to the Talis Documentation Web Site

- Database Analyser  (April 2005 - Updated May 2008)
The Database Analyser is a simple standalone utility that reports upon the structure of your Talis database. The reports are produced in structured HTML format, and are designed to help Talis System Managers to formulate queries against the Talis database using basic SQL.
Download: DatabaseAnalyser.zip

Other Articles

How to check for missing indexes on Sybase tables  (Dec 2006)
The prod_talis database tables have a set of indexes to improve the performance of SQL queries retrieving information. The check_talindexes.sc script checks to see what indexes may be missing from the database.
Download: check_indexes.tar

Importing Course and Department codes into the IMPORT_PARAMETER table  (Nov 2006)
This article describes how to run two scripts, insert_course_codes.sc and insert_dept_codes.sc to import the full list of courses and departments held in prod_talis into the IMPORT_PARAMETER table.
Download: insert_import_param.tar

How to analyse SQL statement performance  (Nov 2006)
This article outlines how to analyse how a piece of SQL is being run by Sybase.

How to update due date rules via SQL  (Aug 2006) Updated Sep 2006
This article outlines how to update due date rules to allow for variation of due date periods around holidays, non-term time and closed periods.

Resetting the LETTER_SNT table  (Feb 2005)
This article provides guidence on removing rows from the LETTER_SNT table. An example script is included.

Running SQL statements in a UNIX shell script  (Feb 2005)
This article provides guidance on creating UNIX shell scripts to automate the running of SQL statements.

Bulk updates of the ITEM table  (Aug 2004)- Updated Jul 2005
This article provides guidance on updating the ITEM table using SQL statements.

Checkstorage database maintainance script  (Sep 2004)
The dbccdb database used by checkstorage requires the regular removal of old data. The sp_dbcc_deletehistory stored procedure deletes old data. The sp_dbcc_deletehistory.sc script automates this process.
Download: sp_dbcc_deletehistory.tar

Database backups to disk  (Aug 2004)
Dump2Disk Release Notice  (Aug 2004)
This article and release notice provides guidance on setting up database backups to disk rather than tape. Script updated September 2007.
Download: dump2disk.tar

3M SIP2 Protocol 
The SIP2 Definition document as supplied by 3M.