Analysis, Design, Implementation and Testing of Library Management Information System

1. 1 system analysis

1. 1. 1 Basic tasks of library management information system

"Book Management Information System" is a picture with more than 10000 employees, which is geographically distributed in large enterprises.

Book management system, the library has a collection of more than 6,543.8+0,000 books, and the daily borrowing volume is nearly 10,000 books. In the manual operation mode, book cataloging and borrowing have a large workload, low accuracy and are not easy to modify and maintain. Readers can only go to the library to find the bibliography manually, which can't meet the borrowing demand. It is necessary to establish a networked electronic library information system.

Library management information system serves two kinds of people: registered users and ordinary readers. General readers become registered users after registration, and registered users can borrow books from the library. Other people can only consult the book catalogue, not borrow books. At the same time, the system is considering providing e-book services. At present, only the catalog query service of e-books is provided, and the full-text service of e-books will be provided in the near future. Users can access the library management information system through the network.

1. 1.2 Analysis of personnel structure, organization and users in the system.

In order to have a comprehensive understanding of the system, we must first understand the personnel structure, organization and users within the system.

Solution. The organizational structure of the library system is shown in figure 1- 1.

Figure 1- 1 Organizational Structure of Library Management Information System

The library is under the overall responsibility of the curator, and consists of office, finance room, editing room, academic paper room, book lending room, electronic reading room, periodical reading room and technical support room. The business responsibilities of each department are as follows.

Office: the office assists the curator in his daily work, understands the customer's needs and makes the purchase plan.

Finance room: the finance room is responsible for financial work.

Editorial room: The editorial room is responsible for the procurement, storage and cataloging of books. Cataloged books are labeled and sent to the library for shelving.

Academic paper room: responsible for the collection and arrangement of academic papers.

Book lending room: provide bibliographic inquiry service and book lending service for readers.

Electronic reading room: collect and sort out electronic books, and prepare to provide lending services for electronic books. At present, it can provide directory query and borrowing.

Periodical reading room: responsible for the collection, arrangement and borrowing of information.

Technical support room: responsible for providing technical support for the library's network and computer system.

1. 1.3 system business process analysis

Business process analysis is the basic link of system analysis, in order to achieve the business objectives of business premises system. library management

The business process of management information system is shown in figure 1-2.

Figure 1-2 Business Process of Library Management Information System

Through the business process investigation, the main business and business process of the book management system are defined.

The librarian prepares the book purchase plan and the buyer is responsible for the purchase of new books. After the purchased books are put into storage, they are catalogued in the editing room, labeled and made into a book catalogue. Books are placed on the shelves of the library for readers to borrow. Submit the edited e-book to the electronic reading room.

Readers are divided into registered readers and unregistered readers. Only registered readers can borrow books from the library. Non-registered readers can check the catalogue but can't borrow books. Readers fill in the registration form, submit it to the librarian for review, record the registration form, become registered readers, and issue library cards. When registered readers borrow books, they need to fill in the library slip and hand it over to the librarian together with the library card. After checking, the librarian fills in the book borrowing registration form, modifies the number of books in the book registration form, and then puts them on the shelves to get books for readers. The library has a reader's mailbox, through which readers can reflect the books they need but have no inventory. Librarians regularly deal with the opinions in readers' mailboxes, and compile the books needed by readers into a book purchase plan for buyers to buy.

1. 1.4 data flow chart

Data flow diagram is a tool to comprehensively describe the logical model of information system, which abstracts and summarizes various services in information system.

With the process. The following is the data flow chart of the library management information system.

(1). Zero-layer data flow chart 1-3

Figure 1-3 Zero-Layer Data Flow Chart

(2) 1 1-4 layer data flow chart

Figure 1-4 Library Management Information System 1 Layer Data Flow Diagram

1. 1.5 data definition and data dictionary

In order to explain each element in the data flow diagram in detail, we adopt the description method of data dictionary. library

The data dictionary of management information system is as follows:

(1) data flow description

Data stream number: D0 1

Name of data stream: book acquisition and cataloging information

Introduction: book acquisition and cataloging information

Source of data stream: After books are purchased, they are coded and sorted by library editors, and then input into the computer.

Data flow direction: edit management module. Book acquisition and cataloging information stores acquisition and cataloging data in a database (book table).

Data item composition: BookID (book code) +BookType (book category) +BookName (book title) +AUTH (author) +Publisher (publisher) +Price (unit price) +publicdate (publication date) +Quantity (purchase quantity).

Data flow: 100 books/day

Peak traffic: 500 books/day

Data stream number: D02

Data Stream Name: Book Borrowing Sheet

Introduction: Book borrowing list

Source of data stream: users fill in the book borrowing form and submit it to the librarian, who will input it into the computer after reviewing it.

Data flow direction: P2_ 1 1 Check the reader's identity.

Data item composition: OrderDate +Bookname +Reder ID +Reader Name +O _ quantity.

Data flow: 1000 units/day

Peak flow: 5000 units/day

Data stream number: D03

Name of data stream: Fill in the borrowing record.

Description: Fill in the record of the borrowing form.

Source of data stream: P2_ 13 Check eligible borrowers and record them in the lending library.

Data flow target: lending library

Data item composition: OrderID (borrowing number) +orderdate (borrowing date) BookName (book title) +BookID (book code)+reader's name (reader's name)+reader's ID (reader's account number)+return date (book return date) +O _ quantity (borrowing quantity) +State.

Data flow: 1000 person/day

Peak flow: 2000 people/day

Data stream number: D04

Name of data stream: number of books borrowed

Description: Modify the number of books in the library.

Source of data stream: P2_ 13 Modify the number of books in the library.

Data flow direction: library

Data item composition: BookID (book code) +O _ quantity (borrowing quantity)

Data flow: 1000 person/day

Peak flow: 2000 people/day

Data stream number: D05

Data stream name: book query information

Description: Book query information

Source of data stream: readers

Data flow direction: P3_ 1 1 retrieval processing module

Data item composition: BookID | Bookname | auth | Publisher.

Data flow: 2000 times/day

Peak flow: 4000 times/day

Data stream number: D06

Data Stream Name: Book Search Results

Description: Return the query results to readers.

Source of data stream: P3 _ 1 1 search condition processing module, query results returned to readers from the library.

Where the data stream goes: readers

Data Item Composition: No Books Found | Number of Qualified Books+{Library Collection+Book Category+Book Title+Author+Publishing House+Publication Date+Library Books}

Data flow: 2000 times/day

Peak flow: 4000 times/day

Data stream number: D07

Data stream name: subscription information

Introduction: The information that readers fill in when booking.

Source of data stream: users fill in reservation information and request reservation.

Data flow direction: P4 _ 1 1 predetermined information input.

Composition of data items: reader's name+password+bookmark.

Data flow: 50 times/day

Peak flow: 100 times/day

1.2 system design

1.2. 1 functional design of the system

The main functions of "Book Management Information System" are: book catalog retrieval, online reservation, book borrowing, electronic publication borrowing, book editing, readers' messages and system maintenance. The system function is shown in figure 1- 13.

Figure 1- 13 Functions of Library Management Information System

The functions of each subsystem are as follows.

1. Reader Registration System

When accessing the system, readers' accounts and passwords will be checked and registered readers will be allowed to enter the system.

2. Bibliographic query system

After readers enter the library management information system, they can retrieve titles or periodicals as needed. The search conditions can be book title, book number, author's name or keywords, etc. If there are not enough readers, you can also make fuzzy queries.

3. Book reservation system

After retrieving the required books, readers can click on the required books to enter the book reservation system, or they can enter the book reservation system from the main interface of the book management information system. The system inquires the library. If the library has this book, it will keep it for readers for three days. Readers should go to the library to borrow books within three days, otherwise the reservation will be cancelled automatically.

4. Book lending system

After readers find the books they need, they will go to the library to borrow them during the book retention period. The book borrowing system handles the procedures of borrowing, returning and renewing books.

5. Book editing system

After cataloging and other processing, the book catalogue is stored in the database and provided to readers for retrieval. Directory letter

Information includes book number, book category, title, author, publishing house, pricing, publication date and quantity, etc.

6. Electronic reading system

With the development of digital technology, the number of e-books in the library is increasing. E-book system deals with reading, copyright and security of e-books.

7. Reader message board

Through the message board, readers will record the books, requirements and suggestions they need and communicate with librarians.

8. System maintenance module

The system maintenance module mainly provides library managers with statistical information of books and readers, which is convenient for managers to use.

Librarians grasp the overall situation of library operation from a macro perspective.

1.2.2 system environment design

1. Hardware environment design

The library management information system adopts a dual-machine backup structure composed of two servers to ensure the real-time service. In order to ensure faster response time, choose a computer system with higher processing speed. The memory size has a great influence on the response speed of the database system, so choose a system with larger memory. The network communication speed is1000 mbit/s1000 mbit/s. In order to ensure the information security of the system center, necessary data backup equipment (external backup mode) is configured.

2. Software design environment design

The library management information system adopts the advanced client (browser) server/database server mode. The server uses Web to develop the system. Users use a universal browser to access the Library Management Information System. The server adopts two layers of application logic service and database service, and forms a three-layer architecture with the client. Adopting such a three-layer structure has the characteristics of clear structure, simple maintenance and fast operation. The software structure is shown in figure 1- 14.

Figure 1- 14 Three-tier architecture of library management information system

The operating system adopts Microsoft NT server, the website publishing system adopts Microsoft IIS, and the database system adopts Microsoft SQL. User interface design uses Dreamweaver, Flash, FrontPage and other software tools.

3. Network environment design

The network system of the library consists of the main exchange of the library and the departmental exchange. Users can use it in the library.

The library network system can access this system, and it can also access the library management information system by using the Internet outside the library.