How to find books from TUT Library open stacks - Electronic open stack directoryHow to find books from TUT Library open stacks - Electronic open stack directory

How to find books from TUT Library open stacks

– Electronic open stack directory

Siret Mikumets

Rait Aguraijuja

How to find books from TUT Library open stacks - Electronic open stack directoryHow to find books from TUT Library open stacks - Electronic open stack directory

Technical background

• Microsoft platform– Microsoft SQL database– .NET web tools/solutions

• Adobe Flash animation

How to find books from TUT Library open stacks - Electronic open stack directoryHow to find books from TUT Library open stacks - Electronic open stack directory

Structure of data

• Main-object is “Bookshelf ”• Main object consists of UDC

numbers and floor number

UDCFloor

...

Bookshelf

How to find books from TUT Library open stacks - Electronic open stack directoryHow to find books from TUT Library open stacks - Electronic open stack directory

Structure of database

• One shelf may contain several UDC numbers• One UDC number may locate on several

shelves or several floors

FloorUDC

descriptionBookshelf * *

Books are located on

bookshelves * 1

Bookshelves located on

floors

How to find books from TUT Library open stacks - Electronic open stack directoryHow to find books from TUT Library open stacks - Electronic open stack directory

Map animation• Floor plans are in flash-type

(swf) files

• UDC numbers are bound with Shelves ID-s. Shelve ID-s are readed from database and forwarded to the animated file

• Animations with certain Shelves ID-s are started to run

How to find books from TUT Library open stacks - Electronic open stack directoryHow to find books from TUT Library open stacks - Electronic open stack directory

Associating with another systems

Open URL: ?url=XXX.XX

How to find books from TUT Library open stacks - Electronic open stack directoryHow to find books from TUT Library open stacks - Electronic open stack directory

How to find books from TUT Library open stacks - Electronic open stack directoryHow to find books from TUT Library open stacks - Electronic open stack directory

How to find books from TUT Library open stacks - Electronic open stack directoryHow to find books from TUT Library open stacks - Electronic open stack directory

How to find books from TUT Library open stacks - Electronic open stack directoryHow to find books from TUT Library open stacks - Electronic open stack directory

How to find books from TUT Library open stacks - Electronic open stack directoryHow to find books from TUT Library open stacks - Electronic open stack directory

How to find books from TUT Library open stacks - Electronic open stack directoryHow to find books from TUT Library open stacks - Electronic open stack directory

How to find books from TUT Library open stacks - Electronic open stack directoryHow to find books from TUT Library open stacks - Electronic open stack directory