A Mobile Library Management System

1
A Mobile Library Management System

• Advisor Dr. Shen
• Student Ananta Gampaa
• November 8th,2005

2
Agenda

• Motivation
• Mobile Development Challenges
• Technology
• Implementation
• Conclusion
• Demo

3
Motivation

• Present ODU Library website not intended for
  Mobile Phones
• Being Mobile is important
• Mobile phones support WML and not HTML
• 68 of population have PCs and 61 have Mobile
  Phones

4
Comparison
5
ASP.NET Mobile ControlsMobile Development
Challenges

• Form factors and device capabilities
• Multiple mark-up languages
• Cookie support
• State management
• Development tools

6
ASP.NET Mobile Controls.NET Solving Challenges

• Write-once mobile web pages
• Support multiple mark-up languages
• Support for a variety of devices
• Customizable and extensible framework
• Integrates with Visual Studio.NET

7
Why WAP but not HTTP?

• Limitations of HTTP
• bandwidth intensive
• Continuous back and forth flows of requests and
  response messages.
• Benefits of WAP
• It is an efficient ,robust and secure
  transmission protocol.
• The presentation format minimizes the requests
  and data transmitted.

8
ASP.NET Mobile ControlsHow it Works
Create Mobile Web Form
Windows 2000 (with IIS) .NET Framework
Device Capabilities
Mobile Presentation Layer (controls)
Mobile.aspx Pages
HTTP Request
Integrate Business Logic
Mobile Controls and Device Adapters Generate
Display
HTTP Response
Test Target Devices
Post to Web Servers
DevelopmentEnvironment
ProductionEnvironment
9
ASP.NET Mobile ControlsHow it Works
10
Technology

• Microsoft Visual Studio .Net
• Internet Information Services
• MS SQL Server
• ASP .Net Mobile Web Application
• ASP .Net web services
• Database access is through ADO .Net
• Full-Text search using Microsoft Search Service
• Job scheduling using SQL Server Agent service
• Directions using Microsoft Mapoint Web service
• Book price using Amazon.com Web service

11
Tables
12
Implementation

• 3 Types of users
• Administrator
• Staff
• Student

13
Administrator

• Login as an administrator
• Add new books
• Add Students
• Add Staff
• Delete Staff
• Delete Student
• Modify student

14
Administrator - Login

• Most powerful user
• Admin ID/Password - Required Field Validations
• Credentials checked in the login table
• Database access through ADO .Net
• MS SQL is the database

15
Add new books

• ISBN, CALL are unique
• Book Name, ISBN, Pub. Date, Publisher, Author,
  BSTAT, CALL, Description Required Field
  Validation
• Pub. Date Regular Expression Validation for
  date
• Book table is updated

16
Add Students

• SID is unique
• Name, SID, Address, Sex, Major, Student Status,
  Student Validate, Student fines Required Field
  Validation
• Student Validate, Zip code, SID Regular
  Expression Validation
• Student Table updated
• Initial Password same as SID

17
Add Staff

• Staff ID Required Field Validation
• Initial password same as Staff ID
• Login table updated
• Change password upon login
• Staff can be a student

18
Delete Student

• Check if SID is valid
• Check Student Status
• Check Student Fines
• Check if Student needs to check-in
• Check Student holds
• Delete notifications
• Delete login
• Delete Student record

19
Delete Staff

• Check is Staff ID is valid
• Staff ID Required Field Validation
• Login table updated

20
Staff

• Login as Staff
• Change password
• Modify Library hours
• Add/Delete announcements
• Check-out/Check-in books
• Request Hold
• See student record with his SID
• Collect Fines

21
Change Password

• New password Required Field Validation
• Regular Expression Validation on both password
  fields
• Login table updated

22
Modify Library Hours

• Regular/ Summer Hours
• Hours Required Field Validation
• libraryhours table modified

23
Announcements

• Add/ Delete announcements
• Add announcement Required Field Validation
• Announcement table modified

24
Check-out

• SID, Call - Required Field Validations
• Check SID is present
• Check student validate
• Check student status
• Check Call is present
• Check book status
• Update hold if placed by student
• Update stud_book, book tables

25
Check-in

• Call - Required Field Validation
• Check if Call is present
• Check if book is already checked-in
• Update stud_hold if book was under hold
• Send email saying book is available
• Update book, stud_book tables

26
Request Hold

• Check if SID is valid
• Check if Call is valid
• Check student status
• Check book status available/due/hold
• Send email to student asking for return
• Update stud_book, stud_hold, book tables

27
Student Record

• SID Required Field Validation, check if valid
• Get Student information
• Get Student account information
• Get Fine information

28
Collect Fines

• Check if SID is valid
• Update student status
• Update student fines to 0
• Delete record from stud_fine table

29
Student

• Login as a student
• Search Catalog by ISBN, Call, Author, Book name,
  Advanced Search
• Change password
• See Account Details
• View Library Hours, Announcements
• Get directions to library
• Subscribe\ Unsubscribe for notifications
• Renew Books

30
Search by ISBN, Call

• ISBN, Call - Required Field Validation
• Search is done on the book table for ISBN, Call
• Book Price using Amazon.com web service

31
Amazon.com web service

• //Amazon Service classes
• AWSECommerceService amazonService new
  AWSECommerceService()
• ItemSearch itemSearch new ItemSearch()
• ItemSearchRequest itemSearchRequest new
  ItemSearchRequest()
• ItemSearchResponse itemSearchResponse
• //Build request to Amazon
• itemSearch.SubscriptionId this.subscriptionID
• itemSearch.AssociateTag this.associateTag
• itemSearchRequest.Keywords isbn
• itemSearchRequest.SearchIndex "Books"
• itemSearchRequest.ResponseGroup new string
  "Small", "Images", "ItemAttributes", "OfferFull"
  
• itemSearch.Request new ItemSearchRequest1
  itemSearchRequest
• itemSearchResponse amazonService.ItemSearch(item
  Search)

32
Search by Author, BNAME, Advanced

• Searching based on Full Text Search
• Searching for phrases, groups of words, words
  near one another, or different tenses of words,
  such as run, running, and ran.
• Select search and sort fields

33
Full Text Searching

• Advanced string querying support to SQL
• Allows string comparisons returning both results
  and a matching score
• Not managed by the MSSQL Server service, but by a
  new service, Microsoft Search
• Searching is done against a special index
  contained in a Catalog
• Population Schedule can be done every time there
  is DML Operation

34
Directions

• Street, City, State Required Field Validations
• Route calculated using Microsoft Mappoint Service

35
Renew Books

• Check is Student Status is good
• Check if there is no hold placed
• Check if book is due within one month
• Update book by adding another 6 months

36
Automated

• New item notification
• Notification if a book on hold is returned
• Notification if a hold is placed on a book
• Update the book status if a book is not
  checked-out after placing the hold
• Calculate fines
• Update student status for fines

37
Conclusion

• Not tested against real database
• Port 80 and 1433 needs to be open
• Could be cumbersome because of screen size and
  other limitations
• It is useful because data is readily available
• Major development is on for mobile devices, ex.
  Google, yahoo, msn etc.
• A Mobile Library Management System

38
Questions and Comments