Database design and implementation issues in library domain

ABSTRACTDATABASE DESIGN AND IMPLEMENTATION ISSUESIN LIBRARY DOMAINOnur İhsan ArsunIn this thesis, we study the design and implementation issues in librarymanagement systems. Depending heavily on data, library management systemsshould have effective means to access and store data. We propose a novelrepresentation of the MARC21 format for relational databases, namely relationalMARC. We also introduce methods for transaction processing in library managementsystems which are portioned database tables, precompiled SQL queries, connectionpooling, and statement caching. We also discuss issues in development process andour approach with extreme programming (XP), object oriented analysis and design,and design patterns. All these approaches have been applied in a large web-basedlibrary management system, Library ON-LINE, and have been evaluated andexperience is reported.Keywords: Relational MARC, pre-compiled SQL queries, statement caching,connection pools, extreme programming, object oriented analysis and design.iii