Abstract:
A electronic library management system and its method, which comprises three main advantages: A. collecting booklists automatically: which can break through the traditional technology of manual controlling, connect to each network bookstore by using single window connecting way so as to collect and excerpt the booklists; B. checking duplicate automatically: also break through the traditional technology of manual controlling, which can connected the collected booklists to the ERP system of the library so as to check the duplicate; C. replied automatically: also break through the traditional technology of manual controlling, which can replied to the recommender automatically during purchasing and after being entered the library. By the above-mentioned advantages, and through the Internet so as to recommend, manage and maintain the books, thus replacing the traditional technology of manual controlling, and reducing the wasting of manpower and improving the processing pace, and creating the three win aspect of reporter, recommender and the books supplier.

Description:
BACKGROUND OF THE INVENTION 
       [0001]    1. Field of the Invention 
         [0002]    The present invention relates to an E typed book recommendation, management and maintenance, and more particularly to an electronic library management system and its method which replace the ordinary man-made operating way by internet way so as to reach E typed book recommendation, management and maintenance. 
         [0003]    2. Description of the Prior Art 
         [0004]    For the conventional recommended end, before the Internet has not prevailed or has entered the Internet period but the technology not yet breaks through, library recommender only can passively fill in the books recommendation list prepared by the library or provide simple passive homepage, then the recommender fill in his/her recommended books that he/she hope the library to purchase by means of the broken memory or the incomplete information. 
         [0005]    In addition, the reporter end has some disadvantages described as follows: 
         [0006]    Firstly, since the information filled by most of the recommenders is wrong and incomplete, the confirmation of the recommended booklist or the collection of the booklist has consumed large amount of manpower and time. 
         [0007]    Secondly, once the recommended booklist has confirmed or collected, massive manpower must be spend again to check the collection immediately whether there has duplicate, then spends the massive time to reply the recommender the following processing status of the books, which is very troublesome. However, the recommender is only needed to know the processing status of the recommended books by the reply of the reporters, which is impossible before this invention, because the manual operating way forever could not achieve the standard of reply immediately. 
         [0008]    The present invention has arisen to mitigate and/or obviate the afore-described disadvantages. 
       SUMMARY OF THE INVENTION 
       [0009]    The primary objective of the present invention is to provide a electronic library management system and its method, wherein penetrating Internet way, and by the affiliation of the operation connection of the recommender end, the system maintenance connection of the administer end and the connection of the system maintainer end, and by cooperating with the each large network bookstore, thus obtaining times of reducing booklist purchase collection, duplicate controls and the following processing status repayment, and promotes the interaction with readers and create competing superiority so as to avoid process the same thing repeatedly by consuming more time and manpower. 
         [0010]    The further objective of the present invention is to provide a electronic library management system and its method, wherein this system can reduce books purchasing flow, enhance working efficiency and realize booklist collection, thus achieving the status reply immediately, and purchasing the correct books to the recommender in the shortest time, and providing the biggest benefit and the quickest service under the least manpower and costs. 
         [0011]    The present invention will become more obvious from the following description when taken in connection with the accompanying drawings, which show, for purpose of illustrations only, the preferred embodiments in accordance with the present invention. 
     
     
       BRIEF DESCRIPTION OF THE DRAWINGS 
         [0012]      FIG. 1  is a perspective view of an embodiment of an electronic library management system and its method in accordance with the present invention; 
           [0013]      FIG. 2  is the perspective view of a second embodiment of the electronic library management system and its method in accordance with the present invention; 
           [0014]      FIG. 3  is the perspective view of another embodiment of the electronic library management system and its method in accordance with the present invention; and 
           [0015]      FIG. 4  is the perspective view of a further embodiment of the electronic library management system and its method in accordance with the present invention. 
       
    
    
     DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS 
       [0016]    Referring to  FIG. 1 , a electronic library management system and its method in accordance with the present invention generally utilizes three-layer type main and sub frames to form the frame of the database and the management system. The electronic book management system comprises a Microsoft windows 2000 server, a Microsoft SQL 2000 server  20  and a user end  30 . 
         [0017]    Referring to  FIG. 2 , the electronic library management system and its method in accordance with the present invention comprises three module functions: collecting single window automatic booklist, checking books copies and statistics form of automatic state reply parameters. The modules can be worked and share data simultaneously, and by cooperating with the user server or user data files of automation system in the library, the user files can be unified and maintained simultaneously. 
         [0018]    When each parameter data of the system is established, this invention can provide inquiry immediately, and can share with the user files of the automation system without establish again. When the user&#39;s data in the automation system is changed, the system can be updated automatically, and the system can convert the book information between CCCII, BIG5 and UNICODE. Furthermore, the system can offline reproduce word files, excel files, ISO2709 files and 2-dimensional barcode in a multi-task/multi-user environment. And through the Internet browser, unlimited number of users can simultaneously use different modules online. 
         [0019]    In addition, the electronic library management system and its method in accordance with the present invention is capable of dealing with Chinese, Japanese, Korean and English. And the innovativeness of this invention is its Chinese processing capability, for instance, the system accepts different book information in CCCII, BIG5 and UNICODE online. 
         [0020]    In order to ensure the safety of the data, the system can establish and maintain the USERs of following items: basic orders, password, start module and executable functions of various modules. The system cancan set the start module and the executable functions of various modules according to the account number of the users, can also establish authority level of users of each subordinate library or the cooperative library, and non-authorized users are unable to access the operation module of other libraries. The system can count the number of loading cycles, time of use, the situation of the respective subsystems, and can find out which unit the user belongs to according to the uploaded password of the users. The system can record by whom a specific file is created, added or deleted, updated, date of execution, and all the changes made to the file. The system includes backup system, recovery system and support system. The function of backup should include the routine backup work, recording all data of change and the backup work executed at request or in an emergency. The system is provided with backup and recovery utility programs so as to improve security and integrity. The backup function includes material file, procedure file, system file and so on. The system includes a dual-host redundant data acquisition device (this is also the innovative technology of the present invention), and can set the operation mode of the common system shared by the subordinate libraries or the related libraries. This system includes the network online operation of total library, subordinate libraries, related libraries and the cooperative libraries. The system of this invention can accept various operation modes of different libraries, for example: different type of purchase orders, the definition of the type of recommenders of the respective purchase order, the ownership of different identities, and default value and the books of different network bookstores can be inquired via a single window simultaneously. 
         [0021]    The system of this invention provides the full browser window, and has a prompt function throughout the entire operation process. When the system enters into various modules, the picture of the entered modules can be set as homepage according to the user&#39;s preference. The system can provide manual or automatic online edition of real-time update. Furthermore, the system can provide various kinds of examples that contain the functions of establishing different formats of mails transmission and provide a hyperlink for automatic access to the system page. 
         [0022]    With respect to the maintenance function, the system provides the functions of on-line addition, revision, deletion and transcription of various files, and automatic maintenance of related files. When there is something wrong with the data or operation, the system can find out the mistakes automatically, and refuse to execute the save function by giving an alarm. The system can provide the function of data locking each file is allowed to be revised by only one person at a time, but can be read by multi-people simultaneously. When deleting the data on-line, the system will show a message automatically asking for a confirmation and then the data can be deleted after confirmation. The input and fault detection system is able to find out fault automatically, give an alarm and show the information of the fault, such as wrong code, wrong data format, and improper operation. However, the innovative technique of the present invention is the batch transaction of various data, when transmitting a mail of book purchase order or the status of the library collection status automatically, the transmission cycle can be adjusted by the administrator. 
         [0023]    With regard to the data inquiry, the system of the present invention allows the user to inquire about the recommender, the library collection and the circulation status of each library simultaneously based on the recommended data. Moreover, the system can serve as a recommender or is recommended the booklist retrieval of the books, and provides two conventional retrieval functions. 
         [0024]    With regard to the statistical analysis and report output, the system of the present invention provides the functions of on-line, off-line printing and preview, and all the reports can be exported to EXCEL, and can be printed from a specific section labeled with a printing instruction at the user&#39;s request. The system can suspend or cancel the print job. The innovative technology lies in that the system provides a settable statistical period, such as daily, weekly, monthly, quarterly, half-yearly, and yearly, in order to count the respective reports in this period, and the statistical reports can be printed by batch processing. 
         [0025]    With regard to the system function of the booklist collection module, and for the recommender who has made a search two times or more, the system will retain the input value of the first time so as to facilitate the second time input. Its innovation technology lies in that the files which have already been created by the recommender can be supplemented, deleted, updated, or converted at any time by the administrator. The administrator can choose to renew or cover the original data when converting similar data. The system can tell the country of publication, traditional Chinese, simplified Chinese, the western languages, the Japanese, the continuous publication and so on by the ISBN prefix code. After the large network bookstores are collected, the system will provide a single window to allow the recommended to enter the key word, book title, author, the publisher, and ISBN code of the book to be searched. 
         [0026]    The system cancan provide at least the only default portal page for enabling a continuous search continually when the recommender forgets to make a selection, and t the default value of the administrator&#39;s adjustable logic sequence is: the database of non-purchase, the database of the recommender, and the automation system library collection database. 
         [0027]    The booklist collection module is shown in  FIG. 3 . 
         [0028]    In terms of operation and function, the system of the present invention provides the booklist data input function and the booklist data can be inputted on-line. It&#39;s the innovative technology lies in that the user doesn&#39;t have to provide the integral order data, and the system supports the inquiry only by inputting fragments of the order data. When the booklist data is not found, the manual input is needed, and according to the default input fields of the system are set to: author, publisher, ISBN, hardcover, and paperback. The system provides at least the following seven network bookstores of traditional version: Jingshitang, the new classmate, Chengpin, three people, the new silk road, center and Boke. The system provides at least the follow three simplified network bookstores: The Chinese books net, China buy books net, the Chinese modern bookstore. Other languages at least contain the following websites: US network bookstore: MAZON. The network bookstores in Japan include: E-HON national bookstore, three province halls. And the network bookstores in Korea includes: KYOBO. For the prompt messages of the library collection, the system has to display all items of the status areas of all library collections of the automation system, instead of only showing the library collections, and the recommender has the right to hide his/her information. The system provides a selection of hiding or not hiding information. The recommender can email the information to different receivers by entering one or more email addresses no matter the information has been recommended successfully or not. The system provides a hyperlink for automatic access to portal pages, such that it can be hyperlinked to the portal page whether the booklist data is correct or not when booklist searching is failed or the data is in question,. The system can automatically convert the currency of the recommended foreign library into Taiwan dollar and renew the exchange rate every day according to the New York market. The recommender can hyperlink the automation system library collections at any time to check the doubtful recommended booklist. Furthermore, the recommender can leave his/her message on-line for the recommended booklist. 
         [0029]    In terms of realtime and batch transfer, the system of the present invention can transfer the exterior tidied-up booklist and accept the booklist in CMARC &amp; USMARC (ISO-2709) or EXCEL format. When transferring the booklist data, the system can choose to cover the same contents or to renew the different contents. 
         [0030]    With regard to the data maintenance, the innovative technology lies in that the system is able to transform the booklist from simplified Chinese into traditional Chinese, and the administrator can maintain the recommended booklist manually or batch by batch instead of piece by piece. 
         [0031]    With regard to the data inquiry, the booklist access point: the system provides at least an easy mode and an advanced mode. Boolean logic contains (and, or, and not, bigger than, smaller than, the same opening, partial same, completely same), and its innovative technology lies in that the easy mode includes the key word: study year, processing condition, data source, type of language, type of data, status of recommendation, recommendation date and so on. The advanced mode includes: title, ISBN, price, binding, author, the educational system of the recommender, the class of the recommender, the branch of the recommender, study year, processing condition, data source, language, the data type, recommendation condition, recommendation date, publication years and so on. 
         [0032]    With regard to the data output, the innovative technology lies in that the system can output magnetic tape or disc in CMARC USMARC format that is provided for backup or exchange, also it must conform to the standard of ISO-2709. The subfield identifier, record separator, separator, are in ISO 646, and the corresponding hex values are 1F, 1E, 1D. The 1E must be added before the record separator 1D, thereby the system can mark at the column of the CMARC 801 in order to know the recommender. The system can convert the recommended booklist into tape and disk in MARC or EXCEL format, for backup or exchange, also it must conform to the standard of ISO-2709, and the code can be in CCCII or BIG5 or UTF-8, etc. 
         [0033]    With regard to the duplicate verification module, its innovation technology lies in the system has an automation system platform and can retain the function of processing after replacing the automation system. The refuse-to-buy booklist is the first comparison database, which can be compared to the booklists recommended by other recommenders by stepping purchase order orders, and the administrator can select more than one cross purchase orders. The duplicate comparison is carried out via Z39.50. The status of the recommended books should be prompted to the recommender synchronously, and meanwhile, it should provide a hyperlink for direct access to the WEB of the library so as to facilitate the recommender to verify, such as the system of duplicate verification shown in  FIG. 4 . The innovative technology lies in that the input of the refuse-to-buy booklist, the administrator can establish the booklist of the refuse-to-buy step by step, and can batch-by-batch input the record of the refuse-to-buy booklist in fixed format (ISO2709 or EXCEL). The filtering scope of a single list will be enlarged if the input content is curt, and the filtering scope will be narrowed if the input content is detailed. The administrator can set the valid date or the defrosting date of the refuse-to-buy list, and the setting of the new purchaseorder order, and its functions can be adjusted by parameters. The parameter includes: title of the purchase order, effective period of the purchase order, total fund of the purchase order and the option of limiting the fund. The identity of the recommender includes: educational system, group, department, division, section, teaching and administrative staff, student, and former student. Each identity has an exclusive picture and has a parameter option in the administrator port, option of allowing for recommendation of duplicate book, status bar or adjustable class of the status bar authorized to be shown on the recommender&#39;s page, the optional duplicate comparison between the purchase orders, and comparison option that can automatically trace back to the newly added purchase orders of other administrators. As for the duplicate comparison, automation system the system of the present invention allows for online duplicate comparison, default or designated sequence of the duplicate comparison, without changing any existing setting of the automation system. The data field collected by the respective network bookstores includes at least the following items: book title, author, publishing house, price, ISBN, publication date, binding and source. The data field of the determined books includes at least: book title, author, price, ISBN, publication date, binding, source, recommender, times of recommendation, recommendation date, processing status, title of the purchase order, instruction of the purchase order, fund of the purchase order, total amount of the already recommended books, date of beginning and end. The method of comparing the duplicate and the automatic status reporting can judge the duplicate generally based on ISBN. If there is no ISBN, the book title, author and the space of the publisher are retained. In the automatic duplicate auditing, any items in the status bar of the library collection can be transmitted back to the recommender to tell the updated status of the book, and regarding the refuse-to-buy book, it also can tell the recommender the reason of refusing to buy and the unfreezing date. When the latest processing status of all the recommended books are changed, the system can inform the recommender automatically instead of manually by email the latest information. Also, the administrator can inform the recommender the latest status of the recommend book manually. All the recommendations can be compared with one another, and the administrator can respond to the messages of the recommenders one by one or batch by batch automatically. 
         [0034]    With regard to the parameter setting and the report statistic module, the innovative technology lies in that the parameter can be adjusted and the report can be analyzed at any time by the administrator. 
         [0035]    Regarding the operation, its basic parameter must contain the following items: the adjustable name of the addresser, the adjustable mailbox of the addresser, the adjustable SMTP (Simple Mail Transfer Protocol) sever, the adjustable route of the home page, the default value adjustable default value of the home page, the adjustable SCRIPTS route, the adjustable default value of the SCRIPTS, the adjustable user name, the adjustable address of the school home page, the adjustable address of the library home page. And the system can inform the user the respective services by sending an email automatically. The innovative technology lies in that the processing status schedule is adjustable: the adjustment is executed, the suspendable schedule of the automatic mail transferring status, the user&#39;s adjustable post log in home page, the adjustable recommendation record of the user, adjustable projects of hiding or showing the recommended purchase order list, adjustable information of individual recommendation of history demonstration recommendation ratio. If the input of the adjustable recommender data is the necessary field: birthday, education level, occupation, habitation, email, ID card, individual website. Adjustable data origin choice: Taiwan: Jingshitang, the new classmate, Chengpin, three people, the new silk road and center; US: AMAZON; mainland: The Chinese books net, China buy books net, the Chinese modern bookstore; Japan: E-HON national bookstore, three province halls; Korea: KYOBO. 
         [0036]    The establishment of its basic phrases had to contain the following items: the education level, occupation, habitation, the educational system, the branch, the status category and the announcing column, and its innovation technology lies in it increased the processing status of the books or the collections and multiple mail transmission models. 
         [0037]    With regard to the aspect of the changing of the management, its innovation technology lies in the system can record the following changing attributes, and can inquire further, like changed files: the reader files, the defeat of the recommended files, the successful of the recommend files; changed categories: revises, addition, deletion, changer, changed IP, the instruction of the changing, the changing date and the changed scheduling of the system. 
         [0038]    With regard to the aspect of the analysis of the statistical report form, its innovation technology lies in the system can establish following parameters to make statistics: take individual as a unit, take the branch as a unit, take the times of the recommended books as a unit, and take educational system as a unit. 
         [0039]    With regard to the aspect of the success rate, its innovation technology lies in the system can establish the processing status of the following recommended books so as to complete statistics of the percentage: successful recommendation, the recommendation of the duplicate, the recommendation of resisting to buy, purchase to the hall, still at processes and has not purchased, out of print. 
         [0040]    With the regard to the aspect of its recommendation rate and the recommended history list, its innovation technology lies in the system can establish the processing status of the following recommended books so as to complete list of the percentage: the recommended list of the duplicate, the list of purchase to the hall, the list of processing but has not entered into the library, the list of resisting, and the list of out of print. 
         [0041]    For the above-mentioned explanation, this system and its method can reach the following goals: 
         [0042]    Firstly, penetrating Internet way, and by the affiliation of the operation connection of the recommender end, the system maintenance connection of the administrator end and the connection of the system maintainer end, and by cooperating with the each large network bookstore, thus obtaining times of reducing booklist purchase collection, duplicate controls and the following processing status repayment, and promotes the interaction with readers and create competing superiority so as to avoid process the same thing repeatedly by consuming more time and manpower. 
         [0043]    Secondly, this system can reduce books purchasing flow, enhance working efficiency and realize booklist collection, thus achieving the status reply immediately, and purchasing the correct books to the recommender in the shortest time, and providing the biggest benefit and the quickest service under the least manpower and costs. 
         [0044]    While we have shown and described various embodiments in accordance with the present invention, it should be clear to those skilled in the art that further embodiments can be made without departing from the scope of the present invention.