KR20120075622A - Method, system and compueter readable medium to store log data effective in the game service - Google Patents

Abstract

PURPOSE: A log data storage method, system, and computer readable recording medium are provided to maintain game log storage functions and a game processing of a user regardless of errors of a log database server. CONSTITUTION: A log data storage unit(130) executes log data storage commands by using an SQL(Structured Query Language) sentence. An API(Application Programming Interface) receive log data corresponding to a log data storage command. A communication unit of a queue server unit receives the log data from the API. The communication unit temporary stores the received log data as specific queue.

Description

Log data storage method, system and computer readable recording medium that can efficiently store log data for game service {METHOD, SYSTEM AND COMPUETER READABLE MEDIUM TO STORE LOG DATA EFFECTIVE IN THE GAME SERVICE}

The present invention relates to a log data storage method and a system and a computer-readable recording medium capable of efficiently storing log data for a game service, and more particularly, to an API (Application Programming) for processing a log input command from a game server. Interface) The present invention relates to a log data storage method, a system, and a computer-readable recording medium that can additionally provide a plurality of queue servers to a database server to more efficiently and stably store log data for a game service.

As the use of the Internet has become more common and the technology has developed, online games that can be played through the Internet have also been developed exponentially. When users access and play online games over the Internet, certain records, called game logs, are accumulated in places called log databases. The game log is a term used to refer to the access log connected by the user who plays the game. The game log is not absolutely necessary for the progress of the game, but it can be used for game operation, management, and judgment of illegal access. It is desirable to be stored in the log database without.

1 is a diagram briefly illustrating a configuration of a log database and a relationship with a game server according to the related art. Referring to FIG. 1, in general, a log database uses a cluster method in which a plurality of database servers are combined to store various game logs transmitted from a plurality of game servers. In the cluster method, loads are distributed to each other in a form in which the database server with the lowest load responds to a game server requesting a new database connection among multiple database servers in a cluster. Thus, many game servers can handle requests simultaneously.

On the other hand, the cluster method has to be implemented using relatively expensive equipment, but there is a problem of cost and inefficiency since the ratio of the CPU (Central Processing Unit) used to actually store the game log is not high. In addition, when any one of the database servers in the cluster responds to a database connection request from the game server and the connection is established between them, the game server sends the game log only to the specific database server to which the connection is established. If the database server fails and stops responding, the game server connected to the database server also has problems with game log transfer, and the game log function and the overall functions of the game do not work. Therefore, the game server needs to be restarted. do.

Therefore, even if a part of the database server that is not a problem of the game server fails, the problem occurs that the game server must be rebooted without seeing the cluster effect. In this case, all game users connected to the game server are disconnected. User inconvenience is also aggravated.

Therefore, it is necessary to configure a log database that supports efficient game log storage at a low cost and maintains the game log storage function regardless of the failure of the log database server and does not require a reboot of the game server. .

An object of the present invention is to solve the above-mentioned problems of the prior art.

One object of the present invention is to maintain the game progress and game log storage function of the user regardless of whether the log database server failure.

In addition, another object of the present invention is to connect to a plurality of game servers at a low cost to perform a log storage function with the maximum capacity.

In order to achieve the above-described object of the present invention and to achieve the specific effects of the present invention described below, the characteristic structure of the present invention is as follows.

According to an aspect of the present invention, a game server including a log data storage unit and an API and generating log data, a queue server unit including a plurality of queue servers temporarily storing log data, and a database server which finally stores log data. A log data storage method capable of efficiently storing log data for a game service using a system including a queue storage unit may receive log data from an API in the game server and temporarily store the log data in a queue by the queue server unit. And a failure determining step of checking whether a failure has occurred in the database server by the queue server unit, and storing the log data temporarily stored in a queue by the queue server unit if a failure has not occurred. Obtained by performing a log data transfer step that sends to the database server Here, the API receives the log data in response to the log data storage command of the game server using an SQL statement by the log data storage.

According to another aspect of the present invention, a log for a game service, comprising a game server for generating log data, a queue server unit including a plurality of queue servers for temporarily storing log data, and a database server for finally storing log data In the log data storage system capable of storing data efficiently, the game server includes a log data storage unit for performing a log data storage command using an SQL statement, and an API for receiving the log data in response to the log data storage command. The queue server unit receives log data from an API in the game server and checks whether a communication unit for temporarily storing a specific queue among the plurality of queue servers and a failure occurs in the database server. The log data temporarily stored in a specific queue And a plurality of queue servers for transmitting to the database server for storage, wherein the API receives the log data in response to a log data storage command using an SQL statement by the log data storage unit.

As described above, according to the present invention, the game progress and game log storage functions of the user can be maintained regardless of whether or not the log database server fails.

In addition, according to the present invention, it is possible to connect to a plurality of game servers at a low cost to perform a log storage function with the maximum capacity.

1 is a diagram briefly illustrating a configuration of a log database and a relationship with a game server according to the related art.
2 is a diagram schematically showing the overall configuration of an entire system including a game server and a database server according to an embodiment of the present invention.
3 is a detailed configuration diagram of the game server 100 according to an embodiment of the present invention.
4 is a detailed configuration diagram of a queue server unit according to an embodiment of the present invention.
5 is a diagram showing the overall system configuration according to another embodiment of the present invention.

DETAILED DESCRIPTION The following detailed description of the invention refers to the accompanying drawings that show, by way of illustration, specific embodiments in which the invention may be practiced. These embodiments are described in sufficient detail to enable those skilled in the art to practice the invention. It should be understood that the various embodiments of the present invention are different but need not be mutually exclusive. For example, certain features, structures, and characteristics described herein may be implemented in other embodiments without departing from the spirit and scope of the invention in connection with an embodiment. It is also to be understood that the position or arrangement of the individual components within each disclosed embodiment may be varied without departing from the spirit and scope of the invention. Accordingly, the following detailed description is not to be taken in a limiting sense, and the scope of the present invention is defined only by the appended claims, along with the full range of equivalents to which such claims are entitled. Like reference numerals in the drawings refer to the same or similar functions throughout the several aspects.

Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings so that those skilled in the art can easily implement the present invention.

[Preferred Embodiments of the Invention]

In an embodiment of the present invention, the term “computer” includes an input / output device, a memory means, and a digital device equipped with arithmetic capability, including a microprocessor, including a function for communicating or transmitting and receiving specific data through the communication network 200. It's a broad concept. Notebook computers, workstations, palmtop computers, personal digital assistants (PDAs), web pads, and mobile communication terminals including smart phones, including general desktop computers, are referred to herein as "computers". Can be used as

In an embodiment of the present invention, the term "API (Application Programming Interface)" does not mean only an interface made to control a function provided by an operating system or a programming language for use in an application program, but by using such an interface. It should be interpreted in a broad sense, including up to the created application. Therefore, in the present invention, the API may be an application program that can operate while performing a predetermined function in a computer.

In an embodiment of the present invention, the term "Queue Server" is a FIFO (First Input First Out), which is a kind of data structure, in which several data items are listed in a certain order and the first data item is put first. It means a server with a storage space to have a function. Queues in a queue server are implemented programmatically to take advantage of physical storage, and the method is not limited to a specific method such as linear queues or annular queues.

Complete system configuration

2 is a diagram schematically showing the overall configuration of an entire system including a game server and a database server according to an embodiment of the present invention.

As shown in FIG. 2, the entire system according to an embodiment of the present invention includes a game server 100 generating log data, and a queue server unit 300 receiving log data and temporarily storing the log data in a queue. ), The database server 400 including a database for storing log data is connected to each other through the communication network 200.

First, according to an embodiment of the present invention, the game server 100 is a broad concept of a computer that installs a program that performs a server function so that game users can play a game. As part of a program that performs a server function, it also performs a function of generating log data according to various events including log-in of game users, and the API (Application Programming Interface) operating the generated log data in the game server 100. It also performs the function of sending to). Alternatively, according to another embodiment of the present invention, it may be installed on a separate independent computer to perform only log data generation and API transmission functions. In this case, the game server 100 may refer to a computer having such a function. It is obvious to those skilled in the art. Detailed components and operation methods of the game server 100 will be described later.

In addition, according to an embodiment of the present invention, the communication network 200 may be configured without regard to communication modes such as wired and wireless, and may include a personal area network (PAN) and a local area network (LAN). ), A metropolitan area network (MAN), a wide area network (WAN), and the like.

Meanwhile, according to an embodiment of the present invention, the queue server unit 300 receives log data through communication with the game server 100 and, more precisely, an API operating in the game server 100 to receive an internal queue. A computer that stores and transmits log data stored in a queue to the database server 400 through communication with the database server 400. Detailed components and operation methods of the queue server unit 300 will be described later.

Finally, according to an embodiment of the present invention, the database server 400 is a computer that includes a storage medium, such as a hard disk drive using a method such as IDE, SATA or SCSI, which is cheaper than a cluster method. According to the amount of log data, the storage space can be enlarged or reduced by simply expanding or reducing the attached storage medium. Since the database server 400 performs a function of receiving log data from the queue server unit 300 and storing the log data in a storage medium, the database server 400 can use the CPU to the maximum unlike a database server using a conventional cluster method. In case of failure, it is generally possible to recover from the failure within a few hours.

Detailed diagram of game server

3 is a detailed configuration diagram of the game server 100 according to an embodiment of the present invention.

Referring to FIG. 3, the game server 100 according to an exemplary embodiment of the present invention may include an event checking unit 110, a log data generating unit 120, a log data storing unit 130, and an API 140. Can be. 3 is a diagram briefly and abstractly illustrating only components for explaining an embodiment of the present invention, the game server 100 may also include components for performing other functions necessary for a user to play a game. It should be understood that it may be.

The event checking unit 110 monitors occurrence of an event required for generating log data, for example, logging in or logging out of a specific user and notifies the log data generating unit 120 when the event occurs. According to another exemplary embodiment of the present invention, the event checking unit 110 may notify the log data generating unit 120 also data such as a detailed event history when the event occurs.

The log data generator 120 receives a notification of a specific event occurrence that requires the generation of log data from the event checker 110 and generates log data based on the notification.

Next, the log data storage unit 130 stores the log data generated through the log data generation unit 120. The log data storage unit 130 may recognize the API 140 as a database server and perform commands such as database connection, log data storage, and database connection termination using a well-known structured query language (SQL). Since the log data storage unit 130 and the API 140 are located in the same computer, the API 140 for connecting to a database is located at a localhost, and 127.0.0.1 may be used as an IP address in IPv4.

The API 140 operates in the game server 100 to emulate a database server through communication with the log data storage 130 to receive log data. The API 140 also detects an operation state of each queue server through communication with a plurality of queue servers (not shown) in the queue server unit 300, and operates in a queue while operating normally without a failure among the plurality of queue servers. Send the received log data to the queue server with a small amount of accumulated log data. As an example of a failure checking method, it is possible to check whether an IP datagram reaches a plurality of queue servers using a program ping and determine whether a failure has occurred based on this, but this is only an example and various known methods may be used. You can check whether there is a failure. In this way, the game publisher and the game distributor are different, so that the game server 100 is developed by the game publisher and the queue server 300 and the database server 400 are developed by the game distributor so that the communication methods are different from each other. Although different, the game publisher may use the emulation function of the API 140 developed and provided by the game distributor, and the log data may be written to the database server of the game distributor while implementing the functions of the game server 100 in a general and same manner. 400) can be stored without problems.

In FIG. 3, the event checking unit 110, the log data generating unit 120, the log data storage unit 130, and the API 140 may be physically implemented in one computer, and some or each of them may be physically different from each other. It may be implemented in a computer, or there may be a plurality of physically present computers in parallel with the same function. As described above, the present invention is not limited to the physical number and location of the computer where each component is installed, and can be changed in various ways. It will be apparent to those skilled in the art to which the present invention pertains.

cue Server part  Detailed configuration diagram

Referring to the detailed configuration of the queue server unit 300 shown in FIG. 4 according to an embodiment of the present invention in more detail, the queue server unit 300 includes a communication unit 310 and a plurality of queue servers each having a queue ( 320).

Here, the communication unit 310 checks the operation state of each of the plurality of queue servers 320 by requesting the database server 400 of the plurality of APIs 140 included in the plurality of game servers 100 and transmits the result. do. Specific examples of the operation state may include whether a problem occurs in operation of each of the queue servers 320 or how much log data is accumulated in a queue inside the queue server 320, but is not limited thereto. It is not. In addition, the communication unit 310 may perform a function of receiving a request to store log data from a plurality of queue servers 320 from the API 140 to a specific queue server and stacking the log data in a queue of the specific queue server.

In another embodiment of the present invention, the communication unit 310 directly monitors the status of each of the plurality of queue servers 320 periodically or in real time, and receives log data from the API 140 and monitors itself. Result You can also perform the function of sending to the most suitable queue server. In this case, the most suitable queue server may be, for example, a server having the least log data accumulated in an internal queue without an abnormal operation due to a failure, but is not necessarily limited to this rule.

In another embodiment of the present invention, instead of the independent communication unit 310 inside the queue server unit 300, each of the plurality of queue servers 320 includes the functions of the communication unit 310, API 140 Transmits the result of the operation status check request In addition, when a specific queue server among the plurality of queue servers 320 receives a log data storage request from the API 140, the received log data is accumulated in the queue of the corresponding queue server. Each of the plurality of queue servers 320 preferably has a queue that can stack at least one day of log data.

Each of the plurality of queue servers 320 transmits log data accumulated in an internal queue to the database server 400 for storage according to a predetermined criterion. Prior to transmission to the database server 400, it is preferable to check in advance whether or not a failure has occurred in the database server 400, according to one embodiment each of the plurality of queue server 320 is independently of the database server 400 The log data accumulated in the queues may be transmitted by communication. Alternatively, the log data accumulated in the queues of the plurality of queue servers 320 may be stacked in a separate queue before being transmitted to the database server 400. It can also be implemented to transmit from.

As an example of a failure checking method, it is possible to check whether an IP datagram arrives at the database server 400 by using a program ping, and determine whether a failure has occurred based on this, but this is only an example and various known methods may be used. You can check whether there is a failure.

The detailed configuration of the queue server unit 300 described above is merely exemplary, and examples of each component may be used alone or in combination or partly separated by various methods according to the technical level of the related art and the common knowledge of those skilled in the art. It can be appreciated that the present invention can be used or modified to perform the same or similar functions.

Different in overall system configuration Example

5 is a diagram showing the overall system configuration according to another embodiment of the present invention. Since the schematic configuration is similar to that of FIG. 2, only the parts different from those of FIG. 2 will be described below.

Referring to FIG. 5, the present invention is not limited to one game server unit 100a including one game server or a plurality of game servers, and includes a plurality of game servers manufactured by a plurality of game producers. It can be extended to the concept including game server units 100a, 100b, ..., 100n (where the number of game server units is not specified).

That is, even if a large number of game publishers develop their own games through various production methods, a separate development or porting process for storing log data to a database server 400 produced by a game distributor is not required. The same function can be performed under various development environments using only the log data storage command using SQL, and this intermediate role can be performed by using an API produced by a game distributor as described above.

In addition, even if a failure occurs in the database server 400, since the recovery time is only a few hours, log data can be stacked in the queue server unit 300 during the failure recovery process. Each of the queue servers has a queue for stacking log data for at least one day. Unlike the prior art, a game progress and a game log storage function of a user may be maintained regardless of whether a failure of the database server 400 occurs.

In addition, even though the database server 400 receives a request exceeding the instantaneous maximum capacity while using relatively low-cost equipment, since the queue server unit 300 performs the buffering role, such a request can be accommodated. 400) can take full advantage of the server's functionality by making full use of the CPU for log data storage.

Embodiments according to the present invention may be implemented in the form of program instructions that can be executed through various computer means and recorded in a computer-readable medium. The computer readable medium may include program instructions, data files, data structures, etc. alone or in combination. The program instructions recorded on the medium may be those specially designed and constructed for the present invention or may be available to those skilled in the art of computer software. Examples of the computer-readable recording medium include magnetic media such as a hard disk, a floppy disk, and a magnetic tape; optical media such as CD-ROM and DVD; magnetic recording media such as a floppy disk; Includes hardware devices specifically configured to store and perform program instructions such as megneto-optical media and ROM, RAM, flash memory, and the like. Examples of program instructions include not only machine code generated by a compiler, but also high-level language code that can be executed by a computer using an interpreter or the like. The hardware device described above may be configured to operate as one or more software modules to perform the operations of the present invention, and vice versa.

In the present invention as described above has been described by the specific embodiments, such as specific components and limited embodiments and drawings, but this is provided to help a more general understanding of the present invention, the present invention is not limited to the above embodiments. For those skilled in the art, various modifications and variations are possible from these descriptions.

Therefore, the spirit of the present invention should not be limited to the described embodiments, and all the things that are equivalent to or equivalent to the claims as well as the following claims will belong to the scope of the present invention. .

Claims (15)

By using a system including a game server including a log data storage unit and an API, generating a log data, a queue server unit including a plurality of queue servers for temporarily storing log data, and a database server for finally storing log data, In the log data storage method that can efficiently save the log data for the game service,
A queue storing step of receiving log data from an API in the game server and temporarily storing the log data in a queue by the queue server unit;
A failure determination step of confirming whether a failure occurs in the database server by the queue server unit;
A log data transmission step of transmitting, by the queue server unit, the log data temporarily stored in the queue to the database server for storage if a failure does not occur;
The API is a log data storage method, characterized in that for receiving the log data in response to the log data storage command of the game server using an SQL statement by the log data storage unit.
The method according to claim 1,
The method prior to the queue storage step,
Monitoring occurrence of an event necessary for generating the log data by an event checking unit of the game server, and
And generating the log data by the log data generator of the game server when the event occurs.
The method according to claim 1,
The queue storing step,
Receiving an operation status check request from the API;
Checking operation state information of the plurality of queue servers in the queue server unit and transmitting the operation state information to the API;
Receiving the log data and specified specific queue server information from the API, and
And temporarily storing the log data in a queue of the designated specific queue server.
The method according to claim 1,
The queue storing step,
Checking operation state information of the plurality of queue servers in the queue server unit;
Receiving the log data from the API;
Designating a specific queue server for temporarily storing the log data using the operation state information, and
And temporarily storing the log data in a queue of the designated specific queue server.
The method according to any one of claims 3 to 4,
The operation state information,
Log data storage method characterized in that it comprises information on the failure of each of the plurality of queue server and the degree to which the queue is stacked.
The method according to claim 1,
The database server,
Method of storing log data, characterized in that not configured in a clustered manner.
The method according to claim 1,
The failure determination step,
A method for storing log data, comprising determining whether a failure occurs based on whether or not the IP diagram is reached using a program ping.
A log capable of efficiently storing log data for a game service, including a game server generating log data, a queue server unit including a plurality of queue servers temporarily storing log data, and a database server finally storing log data. In a data storage system,
The game server is a log data storage unit for performing a log data storage command using an SQL statement, and
An API for receiving the log data in response to the log data storage command;
The queue server unit receives the log data from the API in the game server communication unit for temporarily storing in a specific queue of the plurality of queue servers, And
A plurality of queue servers for checking whether a failure has occurred in the database server, and transmitting the log data temporarily stored in the specific queue to the database server for storage if the failure does not occur;
And the API receives the log data in response to a log data storage command using an SQL statement by the log data storage unit.
The method according to claim 8,
The game server,
An event checking unit for monitoring occurrence of an event required for generating the log data, and
And a log data generator for generating the log data when the event occurs.
The method according to claim 8,
The communication unit,
Upon receiving the operation status check request from the API, checking the operation status information of the plurality of queue servers and transmitting the same to the API; and
And storing the log data temporarily in a queue of the designated specific queue server when receiving the log data and the designated specific queue server information from the API.
The method according to claim 8,
The communication unit,
A function of checking operation state information of the plurality of queue servers;
A function of designating a specific queue server for temporarily storing the log data by using the operation state information when receiving the log data from the API, and
And storing the log data temporarily in a queue of the designated specific queue server.
The method according to any one of claims 10 to 11,
The operation state information,
Log data storage method characterized in that it comprises information on the failure of each of the plurality of queue server and the degree to which the queue is stacked.
The method according to claim 8,
The database server,
Log data storage system, characterized in that not configured in a clustered manner.
The method according to claim 8,
Check whether the failure occurs,
Log data storage system, characterized in that based on the arrival of the IP diagram using the program ping.
A computer-readable recording medium having recorded thereon a program for performing on a computer each step of the method according to any one of claims 1 to 7.

Images