Design of AOLONG Library Management System

1. System Introduction:

AOLONG library management system includes every aspect of current library management business, including system management, reader management, cataloging, circulation, statistics, query, library management and other functions. It can manage books, audio-visual materials and periodicals in one interface, set holidays, set temporary locks (to improve security), suspend borrowing rights of certain readers, import and export readers, exchange MARC data, upgrade auxiliary catalog library, etc.

2. System Features:

1. Adapt to the development requirements of the times

This system complies with the "Library Management System Subset" in the "Library Management Information Standards" and adopts the latest fourth edition of the "Chinese Library Classification". It can adapt to the library's future modernization requirements and can be operated as an independent library management system or connected to a wide area network. It is an inevitable choice for libraries to achieve modernization.

2. Advanced technology

With Win2003 as the server platform and SQL Server2000 or 2005 as the backend, it adopts the advanced and reliable C/S+B/S structure, which has good stability and security, fast operation and simple maintenance. The core of the system is developed with the most advanced front-end development tool Delphi, and all software components are local codes without any other external components, thus ensuring stability and reliability.

3. Powerful functions

Its functions include every link of current library management business. The system is divided into system management, reader management, cataloging, circulation, statistics, query, library management, etc. Various detailed functions such as cataloging are implemented in C/S mode, and some general functions are also open on the WEB through B/S mode.

In addition to the functions of reader management, acquisition, circulation, reservation and management, library management, statistics, query, setting borrowing rules, etc. provided by general library management systems, we also provide holiday setting (to meet the needs of library holidays), setting temporary locks (to improve security), monitoring currently used clients and operators, importing and exporting readers, etc. In addition, you can easily import external MARC data into the library or auxiliary catalog library, you can upgrade the catalog library by yourself, you can suspend the borrowing rights of certain readers, etc.

4. High flexibility

Our various versions and the upgrade programs between versions are integrated on one CD. You can switch between the standard network version and the enhanced network version at will without affecting your data.

5. High security

The administrator assigns the functions that each operator can use and sets their passwords. Each operator can change his or her own login password. The system records the login, logout and important operations of each operator in the operation log, which the administrator can view at any time. Some important functions such as data recovery are restricted to the server side. The library management system data fully automatic scheduled backup service combined with the NT Server environment can maximize the security of your data.

6. Web Services

This system adopts the Client/Server + Browser/Server mode. After installing this component on the server, each client can use the IE browser to allow readers to use functions such as borrowing material query, password change, reservation, and material retrieval.

All information is stored in the database server. Each client communicates with the database server through the network, and the WEB service accesses the database server through the ADO model.

7. Reader Self-Service

The system supports public users. We can open some clients to allow readers to manage their passwords, check their borrowing history, reserve materials, manage and retrieve materials, etc. All these functions require the reader to enter the corresponding password to execute.

8. Easy to use

Although the system provides powerful and complete functions, the internal implementation of the system is rigorous, which ensures that operators can perform fool-proof operations without making mistakes. For example, readers who are borrowing materials cannot be deleted, and readers in the following situations cannot borrow: the number of borrowed books of a certain type has reached the maximum, there are overdue materials, unpaid fines, and borrowing is suspended. Many other rules have been implemented in detail and specifically in the system, and all these rules are enforced by the system. In daily work, operators only need to use a handheld barcode reader to scan the barcode of the library card number, material number, ISBN number of books and audio-visuals, and ISSN number of journals to complete most of the work.

9. The intelligent cataloging solution provides a standard auxiliary cataloging library with more than 2 million cataloging data. At the same time, the system can easily catalog books without ISBN barcodes. Support for external MARC data import greatly facilitates book cataloging.

10. Advantages compared with similar systems

(1) Our system supports barcode readers to scan in library card numbers, book and audiovisual serial numbers, ISBN numbers of books and audiovisuals, and ISSN numbers of periodicals. It supports one-card pass and touch screen.

(2) All functions are implemented by local code, while some systems use many external components, which can easily lead to system crashes and performance degradation.

(3) The main program has a self-checking function, and will alarm for any changes, including virus infection. Many system programs are large and cannot alarm after being infected by a virus.

(4) Comprehensive functions, rigorous structure and clear layout.

(5) Easy maintenance. The system provides comprehensive backup and recovery functions, and will automatically warn users if they have not backed up for a period of time.

(6) Strong adaptability. The operating system can be Win98, Win ME, Win NT4, Windows 2000 and Windows XP. The backend database supports from SQL Server 2000 to future versions, while some systems can only run on a specific version. It supports tens of millions or even hundreds of millions of collections.

3. System topology diagram:

4. System functions:

1. Readers

1. The wizard can automatically guide you to create new user groups and handle overdue readers.

2. Library card production: You can use scanners, image files, etc. as reader photo sources to produce black and white or color library cards.

3. Reader management can complete daily affairs such as reader transfer, report loss of library card, reissue, stop borrowing, and print reader barcode separately.

4. Readers can be freely classified, and borrowing rules can be specified for each category of readers.

5. Readers have their own password and can reserve books remotely.

6. The system supports reader import function.

II. Compilation

1. It has perfect collection and editing functions and auxiliary cataloging data of more than 2 million typical books.

2. Book collection and editing automatically identifies ISBN and unified book numbers, automatically analyzes classification numbers, and reduces the work of cataloging personnel with the help of an expandable cataloging library.

3. There are complete records of book cancellations.

3. Circulation

1. Borrowing books is completely done through barcode recognition, which automatically identifies whether the library card is valid and manages it according to the set rules. It prompts readers with reference information such as the number of books borrowed and the fines payable for overdue books.

2. Book returns are completely identified by barcodes, and overdue records are automatically made.

3. Book reservation can provide convenience for readers, and can be managed and printed to book notifications.

4. Book damage and loss processing can display the last damage record of each book and other information.

IV. Statistics

1. Comprehensive statistics of various indicators currently available in the statistical library.

2. Circulation statistics can count and analyze the book circulation rate, classified circulation rate, and circulation change trend in each period, and can be displayed in charts and tables.

3. Collection statistics can count and analyze the library collection volume, classified collection volume, and collection volume change trends in each period, and can be displayed in charts and tables.

V. Query

1. Book search, you can arrange the search conditions and search items at will.

2. Comprehensive borrowing query can query the borrowed books, overdue books, borrowing and returning dates, and borrowing days by all readers, readers of different categories, a department, a class, or an individual.

3. Overdue books summary: You can query overdue books by department and print a notice to remind you to return the books.

4. You can check the borrowing history of books and the borrowing history of readers.

5. Details and summary account of overdue fines receivable and fines collected.

6. Inquiry on cancelled or damaged books.

6. Other auxiliary functions

1. System management and operator management can set different operating ranges for each person using the system.

2. Data backup and data recovery improve system security

3. Clear history to ensure system speed.

VII. Library Management

1. Librarian information

2. Internal notification

3. My Memo

4. Work Scale

5. Personal operation log

6. Leave a note

7. View other computer screens

5. System advantages:

Easy operability

1. Based on the Windwos system, the operation is standardized and easy to learn;

Anyone who knows the basic operations of Windows will be able to use this library management system.

2. Specially designed guides;

In addition, for some more complex operations, we have designed convenient wizards that will guide you to complete these tasks. For example, you only need to use the mouse to set up a new system or establish a new semester.

3. Perfect combination of intelligent sensing and CCD technology

1. Intelligent perception means that the system automatically starts the Chinese input method when it senses that you want to input Chinese characters, and automatically closes the Chinese input method when you want to input letters or numbers.

2. CCD technology refers to the recognition of barcodes. When borrowing and returning books, staff can completely avoid traditional input devices such as keyboards and mice. They can complete all operations by simply scanning barcodes. At this time, our intelligent sensing technology can recognize different barcodes such as book numbers, library cards, ISBNs, etc., to improve work efficiency and operation accuracy.

Good scalability

1. Data feasibility. As this system uses ISBN as the identifier of each book, ISBN is the International Standard Book Number, so we can easily exchange data with other popular standard catalogs.

2. The feasibility of network expansion. Through the built-in WEB function, IIS can be used to achieve seamless connection with the campus network.

List of important functions

The software mainly consists of the library management system software main program (including all functions), simplified system management program, background and front-end automatic backup service program, and WEB service module. The following are some of the main functions of the main program.

The software can be divided into eight main functions: system management, reader management, acquisition and editing, circulation, statistics, query, library affairs, data backup and recovery, and help. Specifically, there are some important functions listed below.

1. System management

1. Department Setup Wizard

User profiles can be quickly set up based on the size of the library.

2. Operator and authority management

Only system administrators can use this function. Through this function, you can assign functions that can be used by each operator and set their passwords (each operator can change it later) to prevent illegal use by others.

3. Browse the operation log

The operation log records important operations performed by users in the system, which is very useful for you to understand the usage of the entire system.

4. Workload Statistics

Workload statistics can reflect the work status of each staff member over a period of time.

5. Library settings

Set up the stacks according to the library's situation.

6. Bibliographic management

This function is designed to facilitate administrators to browse, print and manage their own bibliographies. For the generation of self-compiled bibliographies, please refer to "Book Search" in "Query". The bibliographies and contents generated in "Book Search" will automatically appear in the "Self-compiled Bibliography" of "Query" and the "Bibliography" column of this function. In addition to managing self-compiled bibliographies, data can also be exported as CNMARC format files.

7. Read MARC data

When executing this function, you are first required to select a MARC file. The powerful fault-tolerant design ensures that even if the file format is wrong, it will not affect the system. The file content will be automatically parsed by segment and displayed to the user in a table. The user can import the data into the library catalog library or the auxiliary catalog library.

8. Catalog library upgrade

Used to upgrade the system's auxiliary catalog library data to the latest version to improve cataloging efficiency.

9. Upgraded book collection

When the number of books in your library exceeds the amount you purchased, you can upgrade it.

10. Change Username

This system allows users to change their username (library name) during use.

11. Clear the cancelled data

This operation will clear all the information related to the cancelled and lost books, audio-visual materials and periodicals. This operation can only be performed by the system administrator.

12. Set a temporary lock

When the user (including the client) has not performed any operation for a set period of time, the system will automatically lock and a password input box will appear, requiring the user to enter the password used when logging in before continuing to operate. If the input fails three times, the program will be closed. This function can reduce the possibility of the system being stolen by others after the operator leaves for a long time. (Only available in the enhanced version).

13. Set up holidays

After turning on the holiday function, when a reader borrows materials and the due date is during a holiday, the system will automatically set the due date to a date you specify. You can set up to 5 holiday times. (Only available in the enhanced version).

14. Current customers

You can view the computer name and operator of the client currently using the library management system, so that you can see which clients are connected to the server and determine whether to shut down or perform catalog library upgrade operations, etc. (Only available in the enhanced version).

(II) Management Module

It includes functions such as "department management", "reader management", "library card application", "reader password management", "borrowing rules", and "reader borrowing history".

1. Department management

In department management, you can add, delete or modify departments and their persons in charge, as well as modify their reader categories.

2. Reader management

It includes functions such as reporting loss, making cards, transferring, canceling and suspending borrowing, setting the library card layout and processing the school badge, and printing library card barcodes.

(1) Report loss

Enter the lost library card number, and the system will give the reader information and automatically issue a new library card number.

(2) Certificate

Users can make library cards in "Reader Management" or "Apply for Library Cards". When you click a department in the department list on the left, the list box on the right will display the names of all readers in that department. You can select "Select All", "Unselect All", or press the right button of the mouse and drag to define an area and then select "Select" or "Unselect" to select readers and print library cards.

(3) Transfer

You can transfer some or all readers of a department to other departments. If you select "Update to the reader category of the new department", the borrowing rights of the transferred readers will be updated to the category of the new department.

(4) Cancellation

Used to delete certain readers. After deregistration, the reader's borrowing history and other information will also be deleted. If a reader has unreturned books, audio-visual materials or periodicals, the reader cannot be deregistered and the system will prompt you.

(5) Suspend borrowing

Used to temporarily revoke or open the borrowing rights of certain readers.

(6) Library card layout and school emblem

Used to set the layout of the library card and make a personalized library card. You must create the school badge image through other software and copy it to the clipboard, then right-click the mouse in the image area on the right and execute "Paste" to obtain the image.

(7) Specify the library card number for printing

When some library cards need to be reprinted for some reason, they can be entered here and then printed.

(8) Print library card barcode

In the above-mentioned library card making, there is a barcode of the reader's number on the library card. Here, it means printing only the barcode containing the name, barcode, and number for affixing to a card similar to a pass.

(III) Compilation and Editing

The collection and editing process includes the cataloging, proofreading, allocation, cancellation, deletion, book subscription, journal registration, barcode printing, etc. of books and audio-visuals. The processing of journals and audio-visuals is similar to that of books, so only books are taken as an example below.

1. Book cataloging

The intelligent cataloging solution provides a standard auxiliary cataloging library with more than 2 million cataloging data, which reduces the workload of library cataloging staff and improves cataloging accuracy.

Cataloging work is divided into two parts: book cataloging (i.e. numbering and shelving) and book editing (i.e. specific cataloging of a certain type of book).

You can search by any of the three elements: ISBN number, title, and author. Scan the ISBN number with a handheld scanner that supports ISBN recognition. If there is such a book in the library's collection, the information of the book will be displayed; otherwise, the system will automatically search in the auxiliary catalog library. If found, it will list the information of the books that meet the conditions. When there is only one record that meets the conditions, the system will automatically call the relevant information into the editing interface for you to proofread and modify. If there are multiple corresponding information, the system will display it in a list, and you can press the up and down arrow keys to select. If no books that meet the conditions are found in the library and the auxiliary catalog library, the system will decide whether to automatically pop up the book editing interface and ask the user to edit it according to your settings.

In the book editing interface, after entering the classification call number, the system will automatically analyze and give the category, and the serial number will be automatically given. In the publisher column, you can enter ? to fuzzily search for the publisher.

2. Book proofreading

This function is used to modify the information of a certain book. Scan the book barcode in the number and click the "Modify" button to modify the book.

3. Book Allocation

This function enables the allocation of books between different bookstores. Scan the book barcode in the number, the system will list the book information, select the bookstore to be allocated to, and execute "Allocation".

4. Book cancellation

Scan the book barcode in the number, select the cancellation reason, fill in the remarks, and click "Confirm Cancellation" to complete the cancellation of a book.

5. Delete books

This function is only available to system administrators. During the book editing process, if a book is edited incorrectly, such as a wrong book number, this function can be used to delete the wrong book.

6. Book Subscription

This function is used to handle the situation of purchasing a batch of books at a time. You can set the order form for a batch of books here. You can add, delete, and modify batches.

7. Subscribe to books

After a batch of books arrives at the library, you can register them here. First, confirm the batch, select the corresponding book type, and click the "Book Registration" button to register. If you want to cancel the subscription of this batch, you can execute the "Cancel Subscription" function.

8. Summary sheet editing

When the library purchases a batch of books, it is necessary to edit the summary list of the batch of books in order to query and manage the batch. If you delete a registration number and a book with the registration number has arrived at the library, the deletion fails and the system will prompt you.

9. Print barcode

Here you can print the barcode of the book or audio-visual material number. This barcode is Code39Extended with verification.

First, select whether it is a book barcode or an audio-visual material barcode. The system will then automatically give the starting number for printing the barcode (the last number printed last time plus 1), and set whether to print the library name and whether to print double barcodes according to the status set when you printed last time. At the same time, set the number of prints and the layout. Of course, you can modify each setting at will, and then you can set the printer and paper parameters. Various settings will be automatically saved for sharing by all computers in the library network.

10. Print classification number

You can print by consecutive number, time interval, specified number, or whether to print only the number entered by this operator, and you can print in any order of time, number, and operator name. You can view it before printing. The set layout data will be saved to the server after printing, and will be effective for all operators the next time they enter the library system. If you print by time interval, you can execute the query time function to obtain the cataloging time of a book and copy and paste it into the time interval.

(IV) Circulation

Circulation includes the borrowing and returning of books, audio-visual materials, reservations, overdue fines, and the borrowing and returning of periodicals.

1. Book borrowing

Borrowing is the most common task in daily life. First, scan the library card number with the barcode reader, then scan the book number, and you can complete the borrowing work for a certain reader. You can scan the reader's library card number in the book number to move on to the next reader's borrowing work.

When a reader has overdue books, he or she can no longer borrow them, and the system will prompt you.

When a library card has been declared lost, the system will also prompt you to retain the card and make it invalid.

After scanning the library card number, the system will automatically display the reader's borrowing rules list in the upper right corner, and the borrowed book list will be displayed below. Press F5 in the borrowing interface to quickly enter the "Book Return" process.

Note: A reader cannot borrow books if they have the following conditions: the maximum number of books of a certain type has been reached and they want to borrow books of that type, there are overdue books, there are unpaid fines, and the borrowing is suspended. These rules are automatically enforced by the system.

2. Book Return

The operation of returning books is very simple. Just scan the book number. If the book is a borrowed book, the system will retrieve and display the book title and page number and other information, and prompt that the book has been returned successfully. If the reader who borrowed the book has an overdue fine to pay, a prompt message will be displayed at the bottom of the window to remind you to collect the fine. For the overdue fine, the operator can temporarily not collect it, but the reader cannot borrow the book again if the fine is not paid. The same is true for overdue audio and video.

If a book is found damaged or lost when it is returned, it cannot be returned directly. The option "Books need to be proofread when returned" should be selected. In this way, the book information will be displayed when the number is scanned in for the first time, and the return will be confirmed when the number is scanned in for the second time. If a fine is required, after the number is scanned in for the first time, the "loss and damage compensation" function can be executed to compensate for it. During the compensation process, if the "collection" function is executed, the book will be automatically returned and the information will be updated synchronously in this window.

If a book is damaged, its previous damage status will be displayed for inspection when it is returned.

If the classification number corresponding to the book is reserved by a reader, the system will assign the book to this reader and prompt you at the bottom of the window.

3. Book Compensation

You can use this function alone. Scan the library card number in the library card number field, and the system will list the borrowed books for selection. Enter the voucher number, compensation amount, and description, press Enter in the compensation amount field, and then select whether the compensation reason is damage or loss, and then click "Collect Payment". If the reader has unpaid overdue fines, the system will collect them at the same time.

If you select the option "Books need to be proofread when returned" when returning books, and execute "Lost and Damage Compensation" after scanning the book number for the first time, the system will automatically set the library card number and the books to be compensated, and the rest is the same as above.

4.Book (audio-visual) reservation

Scan the library card number, the reader information will be displayed, and the reader will be checked to see if he has reservation authority. If not, you will be prompted and the reservation cannot be made. If the total number of books and audio-visual materials reserved by the reader has reached the maximum number, no more reservations can be made.

Select the type of reservation you want to make, "Books", "Audio/Visual", or "Automatic". When you select Automatic, the system will search for the call number in Books and Audio/Visual in turn, and will display the information here when it is found. If you specify Books or Audio/Visual, the system will only search in the relevant library. If the material corresponding to the call number is in stock, the system will prompt you in which library how many books are in stock and cannot be reserved.

The reservation function can be used in conjunction with book search. When you have found a book you need, double-click the book to check its inventory status. If it is out of stock, you can use reservation to register it.

5. Appointment Management

You can search by "All reservations", "Arrived reservations" or "Unarrived reservations", and specify the reader range as "All", "Specified departments" or "Specified readers", and specify any one or two time values ​​in the time period. If a reservation has arrived, the arrival information will be displayed under the "Arrived" item in the list. You can also cancel some or all reservations.

6. Book arrival notification

" You can query the arrival (return) status of reserved books and audio-visual materials within a certain period by "all", "specified department" or "specified reader".

7. Overdue fines

Scan the library card number and the system will list the overdue fines that the reader should pay. Click "Collect Payment" to complete the collection.

(V) Statistics

Statistics include comprehensive statistics, collection classification statistics, collection change statistics, book flow ranking, circulation rate change tracking, etc. Right-click the mouse in various statistics and inquiries to print and send the table content to Excel.

1. Comprehensive Statistics

Count the number of departments and readers corresponding to each type of readers, and count the types, number of volumes and amount of books and periodicals in the library collection.

2. Collection classification statistics

You can count the classification of the library's books or audio-visual materials in the whole library or in each collection room at a certain period. You can also display and print the statistical information in the form of charts. In the chart, you can display it in various forms such as distance, cone, column, arrow, etc., and you can specify its color at will. You can display the value, proportion, item name or any combination of each item, which is very flexible and diverse.

3. Statistics of collection changes

The changes of books or audio-visual materials in the whole library or each library in a certain year can be counted, and the statistical data can be displayed or printed in charts.

4. Tracking of attendance rate

The number of readers who visited the library in a certain year can be tracked, and the results can be displayed and printed in the form of graphs.

5. Turnover Ranking

The ranking of books or audio-visual materials with borrowing times above or below a certain number in a certain period can be counted. The results can also be displayed and printed in the form of graphs.

6. Calculate the turnover rate by month

The flow of books or audio-visual materials in each month of a certain year can be counted.

7. Classification statistics of turnover rate

Statistics are compiled by category to show the number and turnover rate of books or audio-visual materials in circulation in the entire library or a certain library during a certain period of time.

(VI) Query

Including comprehensive borrowing query, book search, periodical content search; various types of cancelled and damaged books or audio-visuals; overdue fines to be collected and collected, etc. Right-click the mouse in various queries to print and send the table content to Excel. The following only takes books as an example.

1. Comprehensive Borrowing Query

You can query the loan status of books, audio-visual materials or periodicals according to any of the four conditions: "All", "Specified Category", "Specified Department" and "Specified Reader". The conditions that can be queried are: loaned out; overdue; borrowed for more than xx days; due date or borrowing date before or after xx date.

2. Book search

You can search for books based on ISBN, classification call number, title, author, publisher and abstract. The search can be precise or fuzzy. The search results can be added to existing or new self-compiled bibliographies. Double-clicking the left mouse button on a row of the search results can query the inventory status of the book.

After the search conditions, first select the item to be searched, then select whether the matching condition is "equal to" or "contains", then enter the keyword and execute "query" to get the search results.

Fuzzy search method: This method is generally used to search for ISBN, classification number, book title, author, subject and abstract, etc. The search condition is included. If no wildcard characters are entered in the keywords, for example: "culture", the system will interpret it as "%culture%". If we enter wildcard characters, such as "%culture", the system will no longer automatically add wildcards.

The wildcard characters that can be used in keywords are as follows: %: a string consisting of any number of characters -: any single character []: appears in the specified range (for example, [af] means any character in abcdef).

If we need to add the search results to our self-compiled bibliography, we can execute the "Add all to bibliography" or "Add single entry to bibliography" function.

The WEB terminal realizes Chinese and English comparison.

3. Books reached

Enter the batch in the subscription batch field and press Enter to check the status of the books that have arrived in that batch.

4. Books storage details

Select the sorting category and library, and execute "Query" to find the detailed account of books entering the library during a certain period.

5. Borrowing Classification Distribution

You can check the classification and distribution of books currently borrowed by each department.

6. Summary of overdue books

Mainly used to urge the return of overdue books. The left side lists the departments with overdue books and the number of overdue books. Clicking the mouse in the overdue number will cause a finger icon to appear. Clicking this icon will allow you to query the specific overdue situation of the department. Right-clicking the mouse will allow you to execute the "Print" function to print the urging list.

7. History of Book Borrowing

Scan the book number or enter the classification call number and press Enter to query the loan history of the book with that number or call number.

8. Cancelled books

Select the sorting item and the library, and execute "Query" to find the books that have been cancelled in the library or the library in a certain period. If the "Clear materials that are no longer in the library" function is executed in the "System" menu, this information will be cleared.

9. General Registration Form

You can search by "all", "specified time" or the corresponding "year" when using "summary sheet editing" in the "editing" menu.

The system will list the total number of species, total number of volumes, total amount and the number of species, number of volumes and amount of each category according to the summary registration number within the specified conditions.

10. Summary registration details

Select a certain summary registration number and execute "Query" to list its registration status.

11. Self-compiled bibliography

The submenu will display a list of self-edited books. After selecting a book, the system will display the information of these items according to the list of selected items in the book.

12. Overdue fines receivable

The left side lists the overdue fines that each department should collect. Click on the "Total Amount Receivable" to see a hand-shaped icon. Click the icon to display the overdue books and fines of each reader in the department. Right-click the mouse to print a summary table of each department or a detailed table of the department. This function is very useful for collecting fines and collective borrowing.

13. Detailed account of fines collected

It can list the detailed accounts of fines collected in a certain period and their summary and the total amount collected by each operator. It is mainly used to check the accounts of fines collected.

14. Batch check for duplicates

Import the ISBNs of books in the subscription catalog provided by book suppliers into the system in batches, and then the system automatically identifies which books are in the library collection and which ones need to be purchased.

(VII) Data backup and recovery

1. Data backup

Data backup can prevent major losses. Regular backup is a good habit. The system will check the time of the last backup every time you enter it. If the interval exceeds a certain period, it will remind you that you should back up.

If the hard disk where the data of this system is located in the server is damaged, we have no choice but to replace the hard disk and reinstall the system as needed. Note that the logical drive letter of SQL Server installation should be consistent with the original one, otherwise it will cause data recovery failure. If the backup data is in a folder on another physical hard disk of the server, first use the "Set backup folder" function to set this folder as a backup folder. If the data is on the client, please copy it to a backup folder on the server and then make the above settings. Then you can execute the "Data Recovery" function to restore the data and each operator password to the state at the time of the last backup. The network mirror folder should be selected as a shared folder of the client to achieve cross-machine backup.

You can also set up a more powerful backup solution through the system management program, and combine it with the automatic backup service to achieve a complete backup that combines manual and automatic functions.

Although we provide a complete backup function, it is still important to regularly copy the easybook.ebb file to a USB key disk, etc., because if a virus enters the network, it is likely to cause the entire network to crash and file loss, leading to serious consequences. Therefore, manually copying files to a removable disk should become a basic rule of library work.

2. Data Recovery

You only need to execute this function when a failure occurs or in some special circumstances. During the execution, there will be detailed prompts to remind you of the time of the last backup operation and the time of the selected backup file. After the execution, the result will clearly tell you whether the operation is successful. This function can only be executed on the server side, and must not be run by the client library management system. Please note that after the recovery is successful, the passwords of each user will also be restored to the state at the time of the last backup.

8. Help

In addition to the help document, there is also a "I'm leaving temporarily" function. After execution, the system will display a password input box, requiring the user to enter the password used when logging in before continuing to operate. If the input fails three times, the program will be closed. This function can reduce the possibility of the system being stolen by others after the operator leaves. It is recommended that the user execute this function when he needs to leave but does not want to end the operation of this system.

(VIII) Library Management

1. Librarian information

2. Internal notification

3. My Memo

4. Work Scale

5. Personal operation log

6. Leave a note

7. View other computer screens

6. System topology:

7. Solution Environment:

Overall solution diagram