KR20070091588A - System and method of communication and database foundation of marc data by internet - Google Patents

Abstract

A system and a method for communicating book information and constructing a database through the Internet are provided to save time/personnel expense by automatically processing book order information, realize convenient/correct management by processing all book information with a POS(Point Of Sale) reader, and remove needs for a librarian by downloading and automatically managing an MARC file. A user terminal(10) orders a book by selecting a book list posted in a website, receives ISBN(International Serial Book Number) information for a delivered book through the POS reader(12), and constructs a book information database(11) including the MARC data received from a main server(20). The main server authenticates a user connected to the website, receives an order for the book selected by the user terminal, and transmits a book order and information for the user ordering the book to a member company terminal(30). The user terminal provides the MARC data extracted from an MARC database(21) or received from the member computer to the user terminal. The member company terminal delivers the ordered book to the user by receiving the information as to the book order and the orderer.

Description

System and Method of Communication and Database Foundation of Marc Data by Internet}

The present invention relates to a book information interchange and database construction system and method over the Internet. Specifically, the present invention relates to a method and system for selling book information (Marc data) using a computer system through the Internet, and mutual input, mutual sharing, and mutual use. More specifically, a book delivery company (book service company) receives orders from consumers online and needs book information (Marc data) online according to the order contents (book delivery company, bookstore, publisher, individual) The present invention relates to a method and system for selling, sharing, and using online book information that delivers purchased book information (Marc data) to consumers (library, library).

In general, when purchasing a book, the ordering phase required an order form to be sent to each publisher.

In addition, the inspection step was to find the corresponding number of the order in the Excel file and write it on the kanji and receive it.

Force Reader is a machine that reads barcodes printed on books.

International Standard Book Number (ISBN) means a book number.

Mark data (Marc data) means the data input the book information.

Conventionally, a yellow book list card is prepared and provided in a library to provide convenience for users.

In addition, conventionally, all books were prepared and produced by one book, and professional manpower was required, and the production volume was limited. Therefore, the problem was that the cost of creating book information (Marc data) was expensive and the unity of suppliers was lacking.

In addition, the conventional book purchase system has a problem that it takes a long time in the supply of books, high cost of book information construction, and very difficult to produce and purchase programs for data construction.

Therefore, the present invention was devised to solve the problems described above, computerized processing of the order, delivery of the book received, the construction of Marc data in the DB and through the mutual input of book information by reducing labor costs, expensive program installation Its purpose is to make it possible to share and use, so that a large amount of data can be provided at once and to facilitate the construction of a mark database.

In order to achieve the above object, the book information interchange and database construction system through the Internet according to the present invention checks the user membership of the book service company's website, selects the order from the list of books published on the website, and orders Receiving the ISBN information of the delivered book through a force reader and matching the ISBN information with the user's book information database to determine whether there is mark data for the delivered book and matching with the book information database. A user terminal for requesting transmission of the mark data to a main server when the mark data does not exist, and constructing a book information database of a user including mark data previously prepared or transmitted from the main server; A force reader connected to the user terminal, recognizing ISBN information by reading a barcode of the delivered book, and transmitting the recognized ISBN information to the user terminal; The user terminal operates the web site to which the user terminal is connected and permits access by determining whether the user is a member of the accessing user, and publishes the book list provided from the member company terminal on the web site, and among the published book list. Receives the order of the selected book from the terminal and transmits it with the orderer information about the book to the member company terminal corresponding to the book, search and extract the mark data matching the ordered book from the mark database and extract the extracted mark data Transforming and transmitting the mark data of the ordered book to the member company terminal corresponding to the ordered book when extraction of the mark data matching the ordered book fails to transmit to the user terminal at the request of the user terminal. Request the mark data Receiving yarn from the main terminal to the server and stored in the database, the mark; And a member company terminal receiving the book order and order information about the book from the main server, and transmitting mark data about the ordered book received from the main server to the main server. .

In order to achieve the above object, the system according to the present invention also provides the user terminal, wherein the user terminal stores the order information of the book selected in the book list, and delivers the ordered book from the main server operating a website. Receiving the information, and checking and checking the ISBN information received through the force reader and the stored order information, and the main server determines whether or not the member of the user to access through matching with the user member database, and from the member company terminal The database includes a book list provided, retrieves and extracts a member company terminal corresponding to a book ordered from the user terminal from a member company database, and receives delivery information for the ordered book from the member company terminal. Transmission to the terminal, the use of the book above Information extracted from the user or member database and input from the user terminal, the terminal member is characterized in that it sends the shipping information on the book the order in the main server.

In order to achieve the above object, the system according to the present invention further checks and confirms the ISBN information and the order information by the user terminal by the user terminal so that the information of the delivered book does not match the order information. If not characterized in that the reorder.

In order to achieve the above object, the system according to the present invention further provides a label for displaying book information from the book information database for the delivered book, wherein the user terminal has an output means. It features.

In addition, in order to achieve the above object, the book information interchange and database construction method through the Internet according to the present invention includes (a) a user member confirmation of a user terminal connected to a website of a book service company by a main server, and access A connection step allowed; (b) a book is selected and ordered by the user terminal connected in step (a) from a list on a website where a book list provided from a member company terminal is posted, and the order information is received by the main server; An order and transmission step of transmitting order information and order information of the book to the member company terminal corresponding to the ordered book; (c) a mark data extraction step of searching and extracting mark data matching the ordered book received in step (b) by the main server from a mark database; (d) If, in step (c), extraction of mark data matching the ordered book fails, mark data information about the ordered book is received from the member company terminal corresponding to the ordered book. A mark database construction step stored in a database; (e) an ISBN information recognition step of reading a barcode of a book delivered from a member company by a force reader connected to the user terminal to recognize the ISBN information on the user terminal; (f) matching the ISBN information recognized in the step (e) with the book information database of the user of the user terminal determines whether there is mark data for the delivered book, and if the mark data does not exist, A mark data transmission request step of a user terminal requesting transmission of the mark data to a main server; (g) the mark data requested to be transmitted in step (f) is extracted from the mark database constructed through step (d) through step (c), and then converted and processed by the main server to the user terminal. A mark data conversion processing and transmission step; And (h) a book information database construction step of constructing a book information database of a user including mark data previously created in the user terminal or transmitted in the step (g).

In order to achieve the above object, the method according to the present invention further provides the ordered book on the basis of the book order information and the orderer information transmitted in the step (b) in the member company terminal after the step (b). And the delivery information is sent to the main server and the delivery information is sent from the main server to the user terminal (b '), and the step (d) is performed with the ordered book. Requesting transmission of the failed extraction mark data information to the member company terminal corresponding to the ordered book when matching mark data extraction fails (d-1); (D-2) providing the mark data information requested in the step (d-1) to the main server by the member company terminal; And (d-3) storing the mark data information received from the member company terminal in the step (d-2) in the mark database of the main server.

In order to achieve the above object, the method according to the present invention also determines whether or not the user of the user connected through matching with the user member database by the main server in step (a) is determined, and (b). In step), the order information of the book selected from the book list is stored in the user terminal, and the member company terminal corresponding to the book ordered from the user terminal is searched and extracted from the member company database provided in the main server. The orderer information and the order information for the book are transmitted to the member company terminal, and the ISBN information recognized by the user terminal after the step (e) by the user terminal and stored in the step (b) The inspection confirmation step (i) further checks and compares the book information and the order information delivered by matching the order information It may be characterized by including.

The method according to the present invention further provides a reordering step (j) according to the present invention, in order to achieve the above object, if the book delivered by the user terminal and the order information do not match. It may be characterized by including.

The method according to the present invention is also characterized in that in the above inventions, the user information in step (b) is obtained from information extracted from the user member database or inputted from the user terminal. can do.

As described above, according to the system and method for mutual exchange and database construction through real-time book information input through the Internet of the present invention, the book orders are automatically processed for each publisher, thereby saving time collectively and reducing labor costs. Since all the book information is processed by the force reader, simple and accurate management is possible, and the book information mark file (marc file) can be downloaded by membership registration, and it is automatically managed, so that professional librarian employment is not required.

The present invention can download and use book information constructed in a computer system, as well as by inputting and using self-established book information, thereby reducing the cost of purchasing the corresponding professional program, reducing labor costs for librarians, and downloading a large amount of book information. There is an expected effect of mutual input, mutual sharing, and mutual use. Accordingly, it is possible to easily build a mark database for each user.

Hereinafter, with reference to the accompanying drawings will be described in more detail to help those of ordinary skill in the art with preferred embodiments. Description of overlapping parts according to various embodiments will be omitted as much as possible.

1 is a block diagram illustrating a book information interaction and database construction system via the Internet according to an embodiment of the present invention.

Referring to Figure 1, a book service company is a company that acts for the book purchase between the publisher (member company) and the consumer (user). The member company is not only a publisher but also a bookstore as a seller of books. The user is a person who purchases a book, such as a bookstore or a library, and anyone who wants to purchase a book and build a book information DB may be used.

Therefore, although the user terminal 10 or member company terminal 30 may be talking only one computer, it is preferable that the user terminal 10 or the member company terminal 30 is considered to be a unit including a server and a network terminal.

First, the main server 13 of the book service company uses the Internet to list the books published by the publishers from the publisher 1 terminal 30a, the publisher 2 terminal 30b, and the publisher 3 terminal 30c. It is provided through and placed on the website operated by the main server 20 of the book service company. The book list is stored in the book list DB 24 of the main server 20.

In the consumer terminal 10c, the bookstore terminal 10b, and the library terminal 10a, which are the user terminal 10, the user (user) sees a website operated by the main server 20 of the book service company uploaded online. This book will be selected and ordered online.

The selected book is stored in the main server 20 of the book service company, and the main server 20 selects an appropriate member company, that is, a publisher, and orders the book to the member company terminal 30. The user pays online while ordering, and the book ordered as described above is delivered to the user (general consumer, bookstore and library, etc.) from the member company, that is, the publisher. In addition, the delivery information may be transmitted from the terminal 30 of the member company to the main server 20 of the book service company and transmitted to the user terminal 10 that ordered the book from the main server 20. The delivery information may be directly transmitted in parallel from the member company terminal 30 to the user terminal 10.

The POS terminal 12 is connected to the user terminal 10 to read the barcode of the book delivered from a member company (publisher, etc.) to recognize the ISBN information of the book, and based on the recognized ISBN information, the order information and the inspection confirmation or the book Through matching with the information DB 11, it is possible to determine whether mark data exists in the ordered book. If the mark data does not exist in the matching of the ISBN and the book information DB, the main server 20 requests the transmission of the mark data information, which may be paid or free. By receiving and storing the mark data from the main server 20, the book information DB 11 is constructed in the user terminal 10.

The main server 20 receives the order information from the user terminal 10 and transmits the order information to the member company terminal 30, and matches the ordered book information with the mark database 21 to extract the corresponding mark data. When the mark data information is requested from the user terminal 10, the extracted mark data is converted and provided. If the mark data is not extracted through matching with the mark database 21, a request for providing the mark data information which is not extracted to the member company terminal 30 corresponding to the order book is requested, and the mark is provided from the member company terminal 30. The mark database 21 is constructed by receiving and storing data information.

2 is a flowchart illustrating a method of book information interchange and database construction through the Internet according to another preferred embodiment of the present invention.

3 is a flowchart illustrating a book information interchange and database construction method through the Internet according to another preferred embodiment of the present invention.

First, the main server 20 through the user terminal 10 and the book order process will be described.

As an example of a library, a library terminal (user terminal) 10 accesses a website of a book service company (S110) to obtain a list of book lists on the website. Upon connection, the access may be granted by the main server 20 by checking whether the user member is matched with the user member DB 22. The book list of the website is provided by each publisher (member company) through each member company terminal (30).

In the list, the library terminal (user terminal) 10, 10a through the selection of the book by the publisher (by member company) is to place an order (S120, S121). The ordered information may be stored in the user terminal.

Book information ordered by the library terminal (10, 10a) is transmitted to the main server 20 to read the identification number of the member company terminal 30 corresponding to the order book in the main server 20 from the member company DB (23) By transmitting the ordered book information to the read member company terminal 30 (S120, S122). When transmitting book information ordered to the member company terminal 30 by the main server 20 may be transmitted together with the orderer information (S120, S122).

The orderer information may be input directly from the user terminals (library terminals) 10 and 10a or may be information obtained from the user member DB 22 of the main server 20.

When the order information and the orderer information is transmitted to the member company terminal 30 corresponding to each order book by the main server 20 (S122), each member company based on the order information and orderer information to the orderer to the orderer Will be shipped.

Order book delivery from the member company can receive the order data from the order information to recognize the identification number of the book using the order information and the force reader connected to the member company terminal 30 and can inspect and confirm the book to be shipped. Next, you can check the exchange rate and the list price and print out the delivery note and the quotation.

The order book is delivered and the delivered information is transmitted to the main server 20 (S131), and the main server 20 transmits the received delivery information back to the user terminal 10 (S132). Directly from the member company terminal 30 to the orderer's user terminal 10 may be sent in parallel with the delivery information.

The process of obtaining information about the order book received below and building the book information DB 11 in the user terminal 10 will be described.

The barcode is printed on the book that is ordered and delivered through the POS reader 12 connected to the user terminal 10, and recognizes the ISBN (S160). The information read as described above may output the Excel order number through the output means 13 connected to the user terminal 10, and through this, it is possible to execute the Kanji work. In addition, the information can confirm the Excel file inspection date and the number of inspection. In addition, by matching the recognized ISBN information and the pre-built book information DB (11) it can be automatically confirmed whether the book information (Marc data) is present (S170 or S171).

When there is no book information (mark data) matching the ISBN information, the library terminals 10 and 10a may request to transmit the book information (mark data) to the main server 20 of the book service company (S170 or S172). ). The mark data transmission request may be free or paid.

The book information (mark data) is received from the main server 20, and the mark data is stored in the book information DB 11 of the library terminals 10 and 10a to build a DB (S190).

In addition, by checking the stored order information and the ISBN information of the book delivered, it can be checked whether or not match the order content (S200). If the order does not match the reorder processing (S210) to the next step and finish the inspection.

The mark data construction process in the main server 20 will be described.

Based on the order information received from the library terminal (user terminal) 10, 10a in the main server 20, Marc data corresponding to the order book is retrieved from the mark database 21 to determine whether there exists (S140 or S141). ). If there is Marc data, when the mark data transmission request is received from the user terminal 10, the corresponding mark data is extracted (S140 or S142). The extracted mark data may be selected and an author code, classification code, and signature basic writing may be executed. The extracted mark data converts a Marc file for Internet transmission and provides the Marc data to the user terminal 10 (S180). Provision of the converted or / and processed mark data to the user terminal 10 may be made for a fee or free of charge. The converted / processed mark data provided to the user terminal 10 will be used to build the book information DB 11 in the user terminal 10.

If there is no Marc data, the mark data may be directly created and stored in the mark database 21 of the main server 20, or a request for providing mark data information prepared by a member corresponding to the order book may be requested (S151). The member company terminal 30, which has been requested to provide the mark data information, transmits the data to the main server 20 (S152) and is stored in the mark database 21 of the main server 20, and the mark DB 21 is constructed. . In the mark DB 21 thus constructed, the mark data corresponding to the next ordered book is searched / extracted.

In the above, the present invention has been described in detail according to the following drawings and embodiments, but the accompanying drawings and the above embodiments are illustrative to help those of ordinary skill in the art to understand the present invention. As described, the scope of the invention should be construed according to the invention set forth in the claims appended hereto, the scope of which is intended to cover various modifications, alternatives, and equivalents by one of ordinary skill in the art. Include.

1 is a block diagram illustrating a book information interchange and database construction system via the Internet according to an embodiment of the present invention.

Figure 2 is an algorithm flow diagram illustrating a book information interaction and database construction method over the Internet according to another preferred embodiment of the present invention.

Figure 3 is a flow chart illustrating a book information interaction and database construction method over the Internet according to another preferred embodiment of the present invention.

         *** Brief description of the symbols in the drawings ***

10, 10a, 10b, 10c: user terminal 11: the book information DB

12: force reader 13: output means

20: main server 21: mark database (DB)

22: user member DB 23: member company DB

24: Book list DB 30, 30a, 30b, 30c: member company terminal

Claims (9)

Check the user's membership on the book service company's website, select a book from the list of books published on the website, receive the ISBN information of the book that has been ordered and receive it through the force reader, and receive the ISBN information from the user's book. Determine whether the mark data for the book is delivered by matching it with an information database, and if the mark data does not exist through matching with the book information database, request transmission of the mark data to the main server; A user terminal for constructing a book information database of a user including mark data previously prepared or transmitted from the main server; A force reader connected to the user terminal, recognizing ISBN information by reading a barcode of the delivered book, and transmitting the recognized ISBN information to the user terminal; The website is accessed by the user terminal and the access is granted by determining whether the user is a member, and the book list provided from the member company's terminal is posted on the website, and the user among the published book list. Receives the order of the selected book from the terminal and transmits it with the orderer information about the book to the member company terminal corresponding to the book, search and extract the mark data matching the ordered book from the mark database and extract the extracted mark data Transforming and transmitting to the user terminal at the request of the user terminal, and if the extraction of the mark data matched with the ordered book has failed, the mark data for the ordered book to the member company terminal corresponding to the ordered book Requesting transmission, and storing the requested mark data Receiving yarn from the main terminal to the server and stored in the database, the mark; And Book information via the Internet; receiving a book order and the orderer information for the book from the main server, the member company terminal for transmitting the mark data for the ordered book received from the main server to the main server; Interchange and database building system. The method of claim 1, The user terminal stores the order information of the book selected in the book list, receives the delivery information for the ordered book from the main server running the website, ISBN information received through the force reader and the stored order Match and verify information, The main server determines whether the user accesses through matching with the user member database, and has a database for the book list provided from the member company terminal, and the member company database corresponding to the book ordered from the user terminal Search and extract from the terminal, receiving the delivery information for the ordered book from the member company terminal, and transmitting the received information to the user terminal, The user information of the book is extracted from the user member database or input from the user terminal, The member company terminal transmits the delivery information for the ordered book to the main server, the book information interchange and database construction system over the Internet. The method of claim 2, The book information interchange and database construction system over the Internet, characterized in that the user terminal by matching the ISBN information and the order information, and checks and reorders if the information of the delivered book and the order information does not match. . The method of claim 2, wherein And the user terminal has an output means and outputs a label displaying the book information from the book information database for the delivered book. (a) an access step in which a user member confirmation is made on a user terminal connected to a website of a book service company by a main server, and access is permitted; (b) a book is selected and ordered by the user terminal connected in step (a) from a list on a website where a book list provided from a member company terminal is posted, and the order information is received by the main server; An order and transmission step of transmitting order information and order information of the book to the member company terminal corresponding to the ordered book; (c) a mark data extraction step of searching and extracting mark data matching the ordered book received in step (b) by the main server from a mark database; (d) If, in step (c), extraction of mark data matching the ordered book fails, mark data information about the ordered book is received from the member company terminal corresponding to the ordered book. A mark database construction step stored in a database; (e) an ISBN information recognition step of reading a barcode of a book delivered from a member company by a force reader connected to the user terminal to recognize the ISBN information on the user terminal; (f) matching the ISBN information recognized in the step (e) with the book information database of the user of the user terminal determines whether there is mark data for the delivered book, and if the mark data does not exist, A mark data transmission request step of a user terminal requesting transmission of the mark data to a main server; (g) the mark data requested to be transmitted in step (f) is extracted from the mark database constructed through step (d) through step (c), and then converted and processed by the main server to the user terminal. A mark data conversion processing and transmission step; And (h) book information database construction step of constructing a book information database of a user including the mark data previously created in the user terminal or transmitted in the step (g); Way. The method of claim 5, After the step (b), the delivery information for the ordered book is delivered to the main server based on the book order information and the orderer information transmitted in the step (b) in the member company terminal and the delivery from the main server Further comprising the delivery information transmission step (b ') of the information is transmitted to the user terminal, (D) step (d-1) of requesting transmission of the failed mark data information to the member company terminal corresponding to the ordered book when extraction of mark data matching the ordered book fails; (D-2) provided by the member company terminal to the main server with the mark data information requested in the step (d-1); And And (d-3) storing the mark data information received from the member company terminal in the step (d-2) in the mark database of the main server. How to build a database. The method according to claim 5 to 6, In step (a), it is determined whether the user accesses the user member database through matching with the main server. Order information of the book selected from the book list in step (b) is stored in the user terminal, and the member company terminal corresponding to the book ordered from the user terminal is searched and extracted from the member company database provided in the main server, The orderer information and the order information for the book are transmitted to the extracted member company terminal, In the above, the user terminal matches the ISBN information recognized through the force reader after the step (e) with the order information stored in the step (b), and compares and confirms the received book and the order information. The method further comprises the step (i) of book information interchange and database construction over the Internet. The method of claim 7, wherein And reordering the book information if the book information provided by the user terminal and the order information do not match in step (i). The method of claim 8, And the user information in the step (b) is obtained from information extracted from the user member database or input from the user terminal.

Images