KR20100047598A - Data communication method and apparatus between pos terminal and mdb database server - Google Patents

Abstract

PURPOSE: A data communication method among pos terminals and a MDB database server, and a device thereof are provided to protect data from all kinds of viruses by transmitting data using a preset protocol through a specific port between computers. CONSTITUTION: A POS(Point Of Sale) terminal reads a transmitted-data(300). The POS terminal decides abnormality of the data(302). The POS terminal analyzes the data(304). If communication state is normal, the POS terminal transmits the data to an MDB(Microsoft Access Database) database server(306,308). The MDB database server receives the data(310). The MDB database server extracts necessary data from the data(312).

Description

Data communication method and apparatus between POS terminal and MDB database server}

The present invention relates to a data communication method and apparatus, and more particularly, to a data communication method and apparatus between a POS terminal and an MDB database server.

Most point of sale (POS) programs that currently use Microsoft Access Database (MDB) databases use the server computer folder where the DB (DataBase) is stored to connect to the database from a remote computer that is not local. Set up and connect a network drive.

Basically, MDB does not have the function to connect from a remote computer.

However, this causes many problems. First, if you share a specific drive or folder on the server, you will not be free from viruses, adware, spyware, malware, etc. Especially if there is an executable file in that folder, As a result, the back office store management program may stop working. Second, network drive or folder sharing can put a heavy load on the internal network and increase the amount of traffic, which can also interfere with the use of other programs between systems. Third, because the MDB cannot accept connections from remote computers, there is no way to communicate with a remote POS system.

The present invention has been made to solve the above problems of the prior art, when communicating between the POS terminal and the MDB database server by opening only a specific port between the two computers to transmit or receive data using a protocol that is pre-defined safe and practical from various viruses It is an object of the present invention to provide a data communication method and apparatus that can stably transmit data without putting traffic load on the system and the network because unnecessary data is not transmitted through the network.

According to an aspect of the present invention, there is provided a data communication method between a POS terminal and an MDB database server to extract data to be transmitted from the POS terminal to the MDB database server, and to extract the extracted data. Generating transmission data using a protocol; Transmitting the generated transmission data in the POS terminal to the MDB database server through a TCP / IP network; And analyzing, by the MDB database server, a protocol of the received transmission data and processing the transmission data according to the analysis result.

Preferably, the predetermined protocol is communication status check, delivery, closing, interim payment, price change, unregistered products, reserves, sales details, mobile coupons, sales, membership inquiry, sales settlement, card approval, product modification server to POS Define at least one or more of the following data: transmission, additional accumulation, credit inquiry, credit payment, delivery inquiry,

Each data defined above is characterized by including the field name, type, byte, position, variable type and description.

Preferably, after the processing step, the MDB database server further comprises the step of transmitting a response message for the success or failure of the processing of the transmission data to the POS terminal.

According to another aspect of the present invention, a data communication device for data communication between a POS terminal and an MDB database server is provided in each of the POS terminal and the MDB database server.

The data communication device may include a data processing unit for extracting data to be transmitted to the MDB database server or processing data transmitted from the POS terminal; A protocol analyzer configured to generate the transmission data using the data extracted from the POS terminal or to analyze a protocol of the transmission data transmitted from the POS terminal; And transmitting the generated transmission data in the POS terminal to the MDB database server through a TCP / IP network, or in response to the success or failure of the processing of the transmission data in the MDB database server. It includes a data transmission unit for transmitting to the POS terminal via an IP network.

Preferably, the predetermined protocol is communication status check, delivery, closing, interim payment, price change, unregistered products, reserves, sales details, mobile coupons, sales, membership inquiry, sales settlement, card approval, product modification server to POS Define at least one or more of the following data: transmission, additional accumulation, credit inquiry, credit payment, delivery inquiry,

Each data defined above is characterized by including the field name, type, byte, position, variable type and description.

When communicating between the POS terminal and the MDB database server according to an embodiment of the present invention, by opening only a specific port between the two computers and transmitting or receiving data using a protocol that is pre-defined, it is safe from various viruses and uses unnecessary data in addition to the actual data. Because it does not transmit through the network, data can be transmitted reliably without putting traffic load on the system and network.

In addition, TCP / IP socket communication method can transmit data without restriction to remote computer in remote.

Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings. In the following description, only parts necessary for understanding the operation according to the present invention will be described, and descriptions of other parts may be omitted so as not to distract from the gist of the present invention.

In addition, terms or words used in the specification and claims described below are not to be construed as limited to a conventional or dictionary meaning, in accordance with the technical spirit of the present invention to best express the present invention It should be interpreted as meaning and concept.

1 is a schematic block diagram of a POS system using a TCP / IP network according to an embodiment of the present invention.

Referring to FIG. 1, the POS system includes a POS terminal 100, an MDB database server 200, and an internet network 300.

POS terminal 100 is provided at the checkout of the merchandise store. When the customer purchases the product and puts the purchased product on the checkout counter, the salesman places the barcode scanner on the barcode attached to the product, and the product information is input to the POS terminal 100. Here, the point of sales (POS) refers to a system that is installed in a cash register of a retailer such as a large discount store, a supermarket, a convenience store, and records a sales result of a product. In other words, it is a system that processes data relating to the sale of the product by a computer at the time of sale.

In addition, if the actual customer purchased a gum, through the POS can be recorded detailed information for each product, such as product name, manufacturer, product price. Therefore, information on the products being sold can be clearly understood, and when and how many products are sold at a glance, thereby improving logistics efficiency, including preventing out of stock. The POS system also allows stores to manage customer information. For example, when a customer enters a membership number, etc. in a specific product store and joins a membership, each time a purchase is made, the purchase amount is converted into points so that specific points can be accumulated. Here, the home address and the like at the time of membership registration are recorded as customer information.

The MDB database server 200 receives data such as delivery information, deadline information, interim payment information, price change information, and sales information of the store from the POS terminal 100 through the Internet network 300 and transmits the data to the MDB database. Store and manage In addition, the MDB database server 200 receives specific data from the POS terminal 100 through the Internet network 300, and after processing the response, the response message according to the processing result, for example, to the POS terminal 100 is processed. Send a message such as success or failure. Therefore, it is possible to quickly inquire whether or not the processing result for the data transmitted from the POS terminal 100, it can be confirmed whether there is data abnormality.

When communicating between the POS terminal 100 and the MDB database server 200, only a specific port between the two computers is opened to transmit or receive data using a separate protocol that has been developed in advance.

Since no data is transmitted other than the protocol according to the preferred embodiment of the present invention, it is safe from various viruses and does not transmit unnecessary data over the network, thereby stably transmitting data without putting traffic load on the system and the network. do. In addition, the TCP / IP socket communication method allows data to be transmitted without restriction from a remote remote computer.

A detailed configuration of the data communication device provided in the POS terminal 100 and the MDB database server 200 will be described with reference to FIG. 2.

2 is a schematic block diagram of a data communication device 100 and 200 according to another embodiment of the present invention.

Referring to FIG. 2, the data communication apparatuses 100 and 200 include a data transmitter 110, a protocol analyzer 120, and a data processor 130.

The data transmitter 110 transmits the transmission data generated by the POS terminal 100 to the MDB database server 200 through the TCP / IP network. In addition, the MDB database server 200 transmits a response message for the success or failure of the processing of the transmission data to the POS terminal 100 through the TCP / IP network 300.

The protocol analyzer 120 generates transmission data using data extracted from the POS terminal 100 using a predetermined protocol. In addition, the MDB database server 200 analyzes the protocol of the transmission data transmitted from the POS terminal 100. Here, the protocol is communication status check, delivery, deadline, interim payment, price change, unregistered products, reserves, sales details, mobile coupons, sales, membership inquiry, sales payment, card approval, product modification server sent to POS, additional credit Define data, including accounts receivables, accounts receivables, and delivery inquiries. Each data defined includes the field name, type, byte, position, variable type, and description.

For example, in the case of communication status check, the field names are header and force number, type is alphanumeric, byte is 3, position is 1 and 4, variable type is string, and communication status check is The protocol of the header is 'CK' and the force number is '001'.

If the data to be transmitted from the POS terminal 100 is the deadline data, the transmission data is generated according to the protocol defined as shown in Table 1 below, and the MDB database server 200 processes the data transmitted according to the defined protocol.

Field name type Byte location Variable type Explanation Header English 2 One String `MG` Force number number 3 3 String `001` Deadline number 10 6 Date `2007-10-25` Price number 10 (8) 16 Long `23650` Actual sales by person in charge = 1: Normal sales-2: Returns sales manager Hangul 20 26 String `Hong Gil-dong A` Request response Response classification English 5 One String `ACKMG` Deadline number 10 6 Date `2007-12-05` Force number number 3 16 String `001` manager Hangul 20 19 String `Hong Gil-dong A`

Although only the protocol for checking communication status and closing data has been described above, protocols for other data can be defined in a similar manner.

 In the POS terminal 100, the data processor 130 extracts data to be transmitted to the MDB database server 200. In addition, the data processing unit 130 in the MDB database server 200 processes the data transmitted from the POS terminal 100. Here, the transmitted data processing includes storage, management, and the like.

3 is a flowchart illustrating a data communication method according to another embodiment of the present invention.

Referring to FIG. 3, in step 300, data to be transmitted is read from a POS terminal. In step 302, it is determined whether data is abnormal. If the data is normal, in step 304 the data is analyzed and data to be transmitted is generated according to the defined protocol. In step 306, the communication state is checked, and if there is no abnormality in the communication state, in step 308, the transfer data is transmitted to the MDB database server.

In step 310, the MDB database server receives the transmission data. In step 312, the required data is extracted from the transmission data, and in step 314, the data is analyzed according to the defined protocol, and the required data is generated. In step 316, it is determined whether there is an abnormality in the data, and if normal, in step 320, the data is stored.

In steps 302, 306 and 316, if the data is not normal or the communication state is not normal, the process proceeds to step 318 to inform the POS terminal of the abnormality.

According to a preferred embodiment of the present invention, a data communication method is divided into a data transmission side and a data reception side, and both the data transmission side and the data receiving side process the data in the same process.

Specifically, when data is transmitted from the POS terminal to the database of the remote server, the receiving side analyzes what to do first by using a predefined protocol and inserts the data into the database according to the analysis result. Performs query operations such as INSERT, UPDATE, and DELETE. After the query is finished, the work result is sent to the POS terminal.

In addition, when the changed data occurs on the server side, the data is transmitted to the POS terminal through the same process as described above to transmit the data to the POS terminal.

If the existing POS program is directly connected to the server's MDB database by a network drive or folder share to read or store data, if the server fails, the connected POS program will attempt to read the data and then respond for several seconds or tens of seconds. This will cause the POS program to crash briefly. However, the data communication method according to an exemplary embodiment of the present invention is a method of transmitting necessary data by a predefined protocol without directly connecting a database of a server in a POS program. Implement

For example, when sending the closing data to the server, the POS terminal sends the data of "MG0012007-10-2523650 Hong Gil-dong" according to the protocol defined as follows: information on header, POS number, deadline date, amount, and contact person. After generating and transmitting the data, the server side analyzes the transmitted data and performs processing on the closing data of the corresponding force. If the server succeeds in processing the data, it sends the response message "ACKMG2007-10-25 001 Hong Gil-dong" to the POS terminal according to the protocol defined as the response. In this case, if it does not process normally, it sends a message such as "NCKMG" according to the defined protocol to re-determine the presence or absence of retransmission.

Meanwhile, the present invention can be embodied as computer readable codes on a computer readable recording medium. The computer-readable recording medium includes all kinds of recording devices in which data that can be read by a computer system is stored.

Examples of computer-readable recording media include ROM, RAM, CD-ROM, magnetic tape, floppy disks, optical data storage devices, and the like, which may also be implemented in the form of carrier waves (for example, transmission over the Internet). Include. The computer readable recording medium can also be distributed over network coupled computer systems so that the computer readable code is stored and executed in a distributed fashion. And functional programs, codes and code segments for implementing the present invention can be easily inferred by programmers in the art to which the present invention belongs.

So far I looked at the center of the preferred embodiment for the present invention. Those skilled in the art will understand that the present invention can be embodied in a modified form without departing from the essential characteristics of the present invention. Therefore, the disclosed embodiments should be considered in descriptive sense only and not for purposes of limitation. The scope of the present invention is shown not in the above description but in the claims, and all differences within the scope should be construed as being included in the present invention.

1 is a schematic block diagram of a POS system using a TCP / IP network according to an embodiment of the present invention.

2 is a schematic block diagram of a data communication apparatus 100 and 200 according to another embodiment of the present invention.

3 is a flowchart illustrating a data communication method according to another embodiment of the present invention.

<Explanation of symbols for the main parts of the drawings>

100: POS terminal 200: MDB database server

300: Internet network 110: data transmission unit

120: protocol analysis unit 130: data processing unit

Claims (5)

In the data communication method between the POS terminal and the MDB database server, Extracting data to be transmitted from the POS terminal to the MDB database server and generating transmission data using the extracted protocol using a predetermined protocol; Transmitting the generated transmission data in the POS terminal to the MDB database server through a TCP / IP network; And Analyzing the protocol of the received transmission data by the MDB database server and processing the transmission data according to the analysis result. The method of claim 1, The predetermined protocol is Communication status check, delivery, deadline, interim payment, change of price, unregistered products, reserves, sales details, mobile coupons, sales, membership inquiry, sales payment, card approval, product modification sent from the server to the POS, additional reserve, trauma inquiry, Define at least one or more data of accounts receivable, delivery inquiry, Each data defined above, A data communication method comprising a field name, type, byte, position, variable type, and description. The method of claim 2, After the processing step, And transmitting a response message to the POS terminal in response to the success or failure of the processing of the transmission data in the MDB database server. In the data communication device for data communication between the POS terminal and the MDB database server, The data communication device, It is provided in each of the POS terminal and the MDB database server, The data communication device, A data processor extracting data to be transmitted to the MDB database server or processing data transmitted from the POS terminal; A protocol analyzer configured to generate the transmission data using the data extracted from the POS terminal or to analyze a protocol of the transmission data transmitted from the POS terminal; And The transmission data generated by the POS terminal is transmitted to the MDB database server through the TCP / IP network, or the response message about the success or failure of the processing of the transmission data is transmitted from the MDB database server to the TCP / IP network. And a data transmission unit for transmitting to the POS terminal via an IP network. The method of claim 4, wherein The predetermined protocol is Communication status check, delivery, deadline, interim payment, change of price, unregistered products, reserves, sales details, mobile coupons, sales, membership inquiry, sales payment, card approval, product modification sent from the server to the POS, additional reserve, trauma inquiry, Define at least one or more data of accounts receivable, delivery inquiry, Each data defined above, A data communication device comprising a field name, type, byte, position, variable type, and description.

Images