KR101335499B1 - Query cashing method and apparatus for database middleware - Google Patents

Abstract

In an online game, when an online game does not perform batch filtering according to a user's local IP when filtering a user by division of a game service providing region, and receives a user authentication request signal from a game server, It provides a technology that enables filtering of users by comparing IP and user information with previously stored filtering target IP and allowed target user information. In the query caching method for database middleware according to an embodiment of the present invention, a query caching apparatus for database middleware may include constructing a cache database for caching a query, and querying the database middleware from at least one content server. Determining whether to receive a query, analyzing a query received by the database middleware to determine whether the query requires caching, and if the query requires caching, storing the query in a cache database as a query in the form of Not Only SQL (NoSQL). Checking whether the query stored in the cache database can be transmitted to the database server storing data, and if it is determined that the query stored in the cache database can be transmitted to the database server, And transmitting to the switch server.

Description

Query caching method and apparatus for database middleware {QUERY CASHING METHOD AND APPARATUS FOR DATABASE MIDDLEWARE}

The present invention, in the database middleware, determines whether the received query is a query that requires caching, caches the query that requires caching, and then transmits the cached query to the database server according to the operation state of the database server. It relates to a technique for distributing the load.

With the development of information and communication technology, a great deal of information is stored in the form of data that can be used in an information communication device, and the information communication device can provide or receive various data online. As a result, the amount of data to be processed in various information communication devices has increased rapidly. As the amount of data has increased rapidly, the need for efficient data management has emerged, and a database is being used to satisfy this demand.

A database refers to a collection of data that is integrated and managed for the purpose of being shared and used by many people. A database represents a collection of data to improve the efficiency of data retrieval and update by eliminating duplication of data items and structuring and storing the data. .

The database server refers to a server in which a database operation program is installed to store and manage data in a database. The database server receives and stores data from a plurality of information communication devices, and searches for and provides data requested by the plurality of information communication devices.
In a database, a query acts as a kind of command. The database server receives a query directly from a user terminal or through a database middleware to execute a command corresponding to the query. However, according to the conventional technology of receiving a query through a user terminal or a database middleware and executing a command, since a plurality of terminals simultaneously receive a query simultaneously, a large load on the database server may occur. .
For example, when a game server receives a command from a user terminal, the game server transmits a corresponding query to the database server and transmits a result of the processing to the user terminal. In such a case, the game server has a large load. An accident has occurred such as the operation of the system is stopped.

Accordingly, the present invention, in the database middleware, determines whether the received query is a query that requires caching, caches the query that requires caching, and transmits the cached query to the database server according to the operation state of the database server, thereby Its purpose is to allow load balancing of servers.

In order to achieve the above object, a query caching method for database middleware according to an embodiment of the present invention, the query caching apparatus for database middleware, comprising: building a cache database for caching queries; Determining whether the database middleware receives the query sent from at least one content server; Analyzing the query received by the database middleware to determine whether the query requires caching; If it is determined that the query requires caching, storing the query in the cache database as a query in the form of Not Only SQL (NoSQL); Checking whether or not a query stored in the cache database can be transmitted to a database server storing data; And when it is determined that the query stored in the cache database can be transmitted to the database server, transmitting the query stored in the cache database to the database server. .

In the determining of whether the query requires caching, when the priority of the query preset by the content server is lower than the predetermined reference rank, the query may be determined as a query requiring caching.

In the determining of whether the query requires caching, if a predetermined word is included in the query, the query may be determined as a query requiring caching.

In the determining of whether the query requires caching, when the query is a query requesting a log, the query may be determined as a query requiring caching.

If it is determined that the caching is not a required query, controlling the database middleware to transmit the query to the database server; .

The storing of the query may include determining whether the query requiring caching is a query of the NoSQL format; If the query is not the NoSQL type query, converting the query to the NoSQL type query; And storing the NoSQL format query in the cache database. .

The checking of the transmission possibility may include setting a timer for specifying a period for checking whether the query stored in the cache database can be transmitted to the database server; And transmitting a data transmission determination signal for confirming whether or not to transmit a query stored in the cache database when the transmission period set in the timer reaches a confirmation period. .

The transmitting to the database server may include determining a priority of a query stored in the cache database; Transmitting a query stored in the cache database to the database server according to the determined priority; Reconfirming whether the query stored in the cache database can be transmitted when the query stored in the cache database exists; .

In the determining of the priority, the priority of the query may be determined according to the order in which the query is stored in the cache database.

In the determining of the priority, the priority of the query may be determined according to the priority of the query set by the content server.

In order to achieve the above object, a query caching apparatus for database middleware according to an embodiment of the present invention, the query to the database middleware that receives the query from at least one content server and transmits the query to at least one database server A query determining unit for detecting whether a query is received and determining whether a query received by the database middleware is a query requiring caching; A NoSQL conversion unit for determining whether the query determined to be caching is a NoSQL (Not Only SQL) type query, and converting the query to a NoSQL type query if it is not a NoSQL type query; A caching query storage unit for caching the query determined to be caching required; And checking whether the query stored in the caching query storage unit can be transmitted to the database server according to a predetermined period, and when receiving a transmission signal for the cached query from the database server, sending the cached query to the caching query storage unit. A period determination unit requesting transmission to the database server; .

When the priority of a query preset by the content server is lower than a predetermined reference rank, the query determining unit may determine that the query requires caching.

When the query determination unit includes a predetermined word, the query determining unit determines that the query requires the caching.

When the query is a query requesting a log, the query determining unit may determine that the query requires caching.

Preferably, the caching query storage unit transmits the cached query to the database server according to the caching order of the query.

Preferably, the caching query storage unit transmits the cached query to the database server according to the priority of the query set by the content server.

According to the present invention, in database middleware, whether the query received by the database middleware is a query that requires caching, caches the query that requires caching, and then caches the cached query according to the operation state of the database server. By transmitting, the load on the database server can be distributed. Therefore, not only data can be provided smoothly but also the load can be efficiently distributed, thereby reducing the cost of building a database server.

1 is a flowchart of a query caching method for database middleware according to an embodiment of the present invention.
2 illustrates a flow of caching a query in a cache database according to an example of the present invention.
3 shows a flow of checking the state of a database server according to an embodiment of the present invention.
4 illustrates a flow of transmitting a cached query to a database server according to an embodiment of the present invention.
5 is a block diagram of a query caching system for database middleware according to an embodiment of the present invention.
6 is a block diagram of a query caching apparatus according to an embodiment of the present invention.

Hereinafter, a query caching method and apparatus for database middleware according to embodiments of the present invention will be described with reference to the accompanying drawings.

The following embodiments are detailed description to help understand the present invention, and it should be understood that the present invention is not intended to limit the scope of the present invention. Accordingly, equivalent inventions performing the same functions as the present invention are also within the scope of the present invention.

In addition, in adding reference numerals to the constituent elements of the drawings, it is to be noted that the same constituent elements are denoted by the same reference numerals even though they are shown in different drawings. In the following description of the present invention, a detailed description of known functions and configurations incorporated herein will be omitted when it may make the subject matter of the present invention rather unclear.

In addition, in describing the component of this invention, terms, such as 1st, 2nd, A, B, (a), (b), can be used. These terms are intended to distinguish the constituent elements from other constituent elements, and the terms do not limit the nature, order or order of the constituent elements. When a component is described as being "connected", "coupled", or "connected" to another component, the component may be directly connected to or connected to the other component, It should be understood that an element may be "connected," "coupled," or "connected."

In the embodiments of the present invention, " communication ", " communication network ", and " network " The three terms refer to wired and wireless local area and wide area data transmission and reception networks capable of transmitting and receiving a file between a user terminal, a terminal of another user, and a download server.

In the present invention, a content server refers to a server computer to which users access to use contents. The content server may provide at least one or more contents to user terminals of users, and one or more contents servers may exist according to the function or capacity of the contents.

In the present invention, a database server refers to a database server computer that stores various data including contents transmitted from a content server, and processes a variety of stored data by installing and operating a database program. The database middleware refers to a device that not only controls various operating system (OS) environments and various database environments of a content server and a user terminal, but also controls data transmission to a plurality of content servers and user terminals. do.

In addition, a query refers to a data manipulation language that describes a question or query that occurs when retrieving or updating data stored in a database. In the database, a query serves as a kind of command. In general, although expressed in the form of a structured query language (SQL) of a relational database, it may be expressed in a form other than SQL in some cases. Queries expressed in a non-SQL format are called NoSQL (No SQL or Not Only SQL), whereas SQL is a query for manipulating data in a relational database. . NoSQL has recently increased the amount of data that a database server has to handle, constantly changing data to accommodate user demands that are inconsistent with data needs, and overcome the horizontal scalability of traditional relational databases. This is a suggested query.

 1 is a flowchart of a query caching method for database middleware according to an embodiment of the present invention.

In the query caching method according to the present invention, the query caching apparatus first constructs a cache database (S100). The cache database can be implemented in a query caching device, and caches the query rather than caching the data directly, so the storage capacity does not have to be large. Also, due to the nature of the cache, it is possible to support high speed data transfer in high speed low capacity storage media such as RAM-Disk or memory rather than low speed mass storage media such as Hard Disk Drive (HDD). It is preferable. In other words, the caching apparatus has a high speed and low capacity storage medium, and the caching database is implemented in the storage medium of the caching apparatus.

Thereafter, the query caching apparatus detects and determines whether the database middleware receives the query (S200). When the database middleware receives a query, it means that the content server has sent a query to retrieve or update data to the database server. As described above, the database middleware is an apparatus for coordinating various OS environments of the content server or various database environments of the database server, and the database middleware is disposed between the content server and the database server and transmitted between the content server and the database server. It converts to be mutually recognizable.

In some cases, the database server may receive the query directly from the user terminal or through the database middleware. However, in general, the user terminal rarely transmits directly to the database server without passing through the content server. Therefore, in the present invention, it is assumed that the database middleware plays a role of transferring data between the content server and the database server.

If it is determined that the database middleware has received the query, the caching device logically analyzes the received query. Queries used in the database include a query for processing data such as storing, retrieving, updating and deleting data, and a query for setting a data structure of the database. However, in addition to the classification according to the type of query, logical classification according to the contents of the query is possible. For example, a loggable query (or query log) is information such as the history of queries previously sent to the database and is not a direct request for data stored in the database. Takes time and load. In addition, the need for immediate treatment is not high. Therefore, it is desirable to log the query as caching to reduce the load on the database. As described above, the caching apparatus may logically classify the query. The logical classification of the query may be classified according to the priority of the query previously set in the content server. That is, all queries sent from the content server to the database may have the same priority, but different priorities may be set. When different priorities are set, the caching apparatus may determine a query having a priority lower than the reference priority as a query to be cached. In addition, whether or not to cache the query may be determined according to the priority of the query data set in the query. In addition, the caching apparatus may determine whether the query is cached by analyzing words included in the query. For example, if a query contains a term for a cache function, it may be determined to cache the query.

If the result of the determination determines that the query does not require caching or should not be cached, then the caching device immediately sends the query to the database middleware so that the database middleware queries the database server directly without sending the data to the cache device. To transmit (S500). However, if it is determined that caching is required or the query may be cached, the caching apparatus receives and caches the query transmitted to the database middleware (S600). In this case, the caching device may cache the query in the NoSQL format. If the received query is not a NoSQL format query, the caching apparatus may convert the cache to the NoSQL format and cache the query.

After caching the query, the caching apparatus periodically checks the state of the database server (S700). The caching device caches queries to balance the load on the database server. Therefore, the caching apparatus needs to determine whether the database server is under a heavy load or a low load. However, although checking the state of the database server is also small, it may cause a load on the database. In the present invention, the caching apparatus preferably checks the load of the database server according to a predetermined cycle. When the caching device checks the state of the database server, it asks whether the caching device sends caching data to the database server.

The caching apparatus determines that the load of the database server is lower than the preset reference load, so that a transmission request for a cached query is received from the database server (S800).

As a result of the determination, when the transmission request is not received or when the reception impossible signal is received, the caching apparatus checks the state of the database server again after a predetermined period (S700). However, when the transmission request is received, the caching apparatus transmits the cached query to the database server (S900). In this case, it is preferable that the caching apparatus transmits the query transmitted to the database server in the cached order. In other words, cached queries are first sent to the database server. If you send queries to the database server in the cached order, some queries may remain cached and not processed.

As a result, in the query caching method for database middleware according to the present invention shown in FIG. 1, the caching apparatus determines whether a query received by the database middleware is a query that requires caching, and if the query requires caching, caches the query in the NoSQL format. Then, when the load on the database server is low, the cached queries are sequentially sent to the database server to distribute the load on the database server.

2 illustrates a flow of caching a query in a cache database according to an example of the present invention.

The flow of caching the data query of FIG. 2 first determines whether the query to be cached by the database middleware from the content server is a query of NoSQL format (S610). If the determination result is not a NoSQL-type query, it is converted to a NoSQL-type query (S620). As mentioned above, NoSQL is used primarily for database scalability, as well as for database servers as well as cache databases. That is, in order to secure the scalability of the cache database, the cache device of the present invention determines whether the query to be cached is a query of the NoSQL type, and converts the query to the NoSQL type if the query is not the NoSQL type. The NoSQL type query is cached in the cache database (S630).

3 shows a flow of checking the state of a database server according to an embodiment of the present invention.

The flow of checking the database state will be described with reference to FIG. 3. First, the cache apparatus sets a timer (S710). The timer may be embedded in the cache device and count the period for checking the database status.

After that, it is determined whether or not the period for checking the state of the database server is set by the timer (S720). As a result of the determination, if it is determined that the database server is checked, the caching apparatus queries the state of the database server to confirm whether the cached query may be transmitted to the database server (S730).

4 illustrates a flow of transmitting a cached query to a database server according to an embodiment of the present invention.

The flow of transmitting the cached query to the database server first determines the order of the cached query (S910). In operation S920, the cached query is transmitted to the database server according to the determined caching order. As described above, in the present invention, it is assumed that the first cached query is first transmitted to the database server in the order in which the queries are cached. This is to ensure that no cached queries remain. However, in some cases, you may want to set a different priority to send a cached cache to the database server.

When the cached query is transmitted, the caching apparatus determines whether there is a remaining cached query (S700). If it is determined that the cached query exists, the caching apparatus checks the state of the database server again (S700). The caching device checks the state of the database server again to determine if the load on the database is high again. If the caching device sends continuous cached queries to the database server without checking the state of the database, the database server may experience a high load due to queries received directly from the database middleware and queries sent by the caching device. There is a number. This violates the purpose of the present invention, which seeks to distribute the load of the database server. Therefore, the cache device preferably checks the state of the database server again each time the cached query is transmitted, and transmits the cached query only when the load of the database server is low.

In FIG. 4, when it is determined that the cached query does not exist in the caching apparatus, it is described as being terminated. However, the caching apparatus may check whether the query is received by the database middleware again (S200).

5 is a block diagram of a query caching system for database middleware according to an embodiment of the present invention.

Referring to FIG. 5, a query caching system for database middleware according to an embodiment of the present invention may include at least one content server 100, a database middleware 200, a caching apparatus 300, and at least one database server 400. It includes.

A plurality of user terminals (not shown) are connected to each of the at least one content server 100 through the Internet, and the content server 100 provides contents to each of the plurality of user terminals. The content provided by the content server 100 may include all content that can be provided online, such as a game, a video, a document, and the like. In the case where there are a plurality of content servers 100, the plurality of content servers may provide different content to user terminals connected to each other. In addition, a personal computer (PC) may be typically used as a user terminal accessible to the content server 100, but may be another terminal capable of executing content by accessing the content server 100 through the Internet in addition to the computer. For example, a mobile communication terminal, a television with Internet access, or the like can be used.

The database middleware 200 is disposed between the at least one content server 100 and the at least one database server 400 to convert the queries and data transmitted between the content server 100 and the database server to be mutually recognizable. Play a role.

The caching apparatus 300 analyzes a query transmitted from the at least one content server 100 to the database middleware 200 to determine whether to cache the query, and if it is determined to cache the query, the query to NoSQL format. Caching In addition, the load state of the database server 400 is periodically checked, and if the load of the database server 400 is low, the cached query is transmitted to the database server 400 in the caching order.

The database server 400 stores various data including content transmitted from the at least one content server 100, and retrieves or updates data according to a query transmitted from the database middleware 200 or the caching apparatus 300.

In FIG. 5, the caching apparatus 300 is illustrated as a separate device from the database middleware 200, but the caching apparatus 300 may be configured to be included in the database middleware 200. In addition, the database middleware 200 and the caching apparatus 300 may be included in the database server 400 and may be implemented in a module form and provided to the database server 400 in some cases. .

6 is a block diagram of a query caching apparatus according to an embodiment of the present invention.

Referring to FIG. 6, the query caching apparatus 300 includes a query determination unit 310, a NoSQL transformation unit 320, a caching query storage unit 330, and a period determination unit 340.

The query determining unit 310 analyzes the query transmitted from the at least one content server 100 to the database middleware 200 to determine whether the query is cached. The query determination unit 310 may logically analyze the query according to the content of the query to determine whether the query is cached, or determine whether the query is cached according to the priority of the query preset by the content server 100. You can also determine whether to cache based on whether a query contains a specific word.

The NoSQL conversion unit 320 determines whether the query determined to be cached is a NoSQL-type query, and if the query is not a NoSQL-type query, that is, a SQL-type query, the NoSQL conversion unit 320 switches to a NoSQL-type query.

The caching query storage unit 330 sequentially stores the queries determined to be cached, and then transmits them to the database server 400 in the stored order.

The period determination unit 340 is a kind of timer, and a period for checking the state of the database server 400 is set, and when the set period is reached, it inquires whether or not to transmit caching data to the database server 400. As a result of the query, when a transmission request for a cached query is received from the database server 400, the cached query storage unit 300 requests to transmit the cached query to the database server 400.

The query caching method and apparatus for database middleware according to the above-described embodiment of the present invention includes an application basically installed in a terminal (which may include a program included in a platform or an operating system basically loaded in the terminal). It may be executed by the user, or may be executed by an application (ie, a program) directly installed on the terminal by an application providing server such as an application store server, an application, or a web server associated with the corresponding service. In this sense, the query caching method for the database middleware according to the embodiment of the present invention described above is implemented as an application (that is, a program) basically installed in a terminal or directly installed by a user, and can be read by a computer such as a terminal. Can be recorded on the medium.

Such a program may be recorded on a recording medium that can be read by a computer and executed by a computer so that the above-described functions can be executed.

As described above, in order to execute the query caching method for the database middleware according to each embodiment of the present invention, the above-described program is coded in a computer language such as C, C ++, JAVA, or machine language that can be read by a computer processor (CPU). Code may be included.

The code may include a function code related to a function or the like that defines the functions described above and may include an execution procedure related control code necessary for the processor of the computer to execute the functions described above according to a predetermined procedure.

In addition, such code may further include memory reference related code as to what additional information or media needed to cause the processor of the computer to execute the aforementioned functions should be referenced at any location (address) of the internal or external memory of the computer .

In addition, when a processor of a computer needs to communicate with any other computer or server, etc., to perform the above-described functions, the code may be stored in a computer's communication module (e.g., a wired and / ) May be used to further include communication related codes such as how to communicate with any other computer or server in the remote, and what information or media should be transmitted or received during communication.

The functional program for implementing the present invention and the related code and code segment may be implemented by programmers in the technical field of the present invention in consideration of the device environment of the computer that reads the recording medium and executes the program, Or may be easily modified or modified by the user.

Examples of the computer-readable recording medium on which the above-described program is recorded include ROM, RAM, CD-ROM, magnetic tape, floppy disk, optical media storage, and the like.

The computer-readable recording medium on which the above-described program is recorded may be distributed to a computer apparatus connected via a network so that computer-readable codes can be stored and executed in a distributed manner. In this case, one or more of the plurality of distributed computers may execute some of the functions presented above and send the results of the execution to one or more of the other distributed computers, The computer may also perform some of the functions described above and provide the results to other distributed computers as well.

In particular, a computer-readable recording medium recording an application, which is a program for executing a query caching method for database middleware according to each embodiment of the present invention, may be associated with an application store server, an application, or a corresponding service. It may be a storage medium (eg, a hard disk, etc.) included in an application provider server such as a web server or the application providing server itself.

A computer capable of reading a recording medium recording an application, which is a program for executing a query caching method for database middleware according to each embodiment of the present invention, may be a smart phone or a tablet PC as well as a general PC such as a general desktop or a laptop. It may include a mobile terminal such as PDA (Personal Digital Assistants) and a mobile communication terminal, as well as to be interpreted as any computing device (Computing).

In addition, a computer capable of reading a recording medium recording an application which is a program for executing a query caching method for database middleware according to an embodiment of the present invention may be a smart phone, a tablet PC, a personal digital assistant (PDA), a mobile communication terminal, or the like. In the case of a mobile terminal, the application may be downloaded from the application providing server to a general PC and installed on the mobile terminal through a synchronization program.

While the present invention has been described in connection with what is presently considered to be the most practical and preferred embodiments, it is to be understood that the invention is not limited to the disclosed embodiments. That is, within the scope of the present invention, all of the components may be selectively coupled to one or more of them. In addition, although all of the components may be implemented as one independent hardware, some or all of the components may be selectively combined to perform a part or all of the functions in one or a plurality of hardware. As shown in FIG. Codes and code segments constituting the computer program may be easily inferred by those skilled in the art. Such a computer program can be stored in a computer-readable storage medium, readable and executed by a computer, thereby realizing an embodiment of the present invention. As a storage medium of the computer program, a magnetic recording medium, an optical recording medium, or the like can be included.

It is also to be understood that the terms such as " comprises, "" comprising," or "having ", as used herein, mean that a component can be implanted unless specifically stated to the contrary. But should be construed as including other elements. All terms, including technical and scientific terms, have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs, unless otherwise defined. Commonly used terms, such as predefined terms, should be interpreted to be consistent with the contextual meanings of the related art, and are not to be construed as ideal or overly formal, unless expressly defined to the contrary.

The foregoing description is merely illustrative of the technical idea of the present invention and various changes and modifications may be made by those skilled in the art without departing from the essential characteristics of the present invention. Therefore, the embodiments disclosed in the present invention are intended to illustrate rather than limit the scope of the present invention, and the scope of the technical idea of the present invention is not limited by these embodiments. The scope of protection of the present invention should be construed according to the following claims, and all technical ideas falling within the scope of the same shall be construed as falling within the scope of the present invention.

Claims (17)

Query caching device for database middleware,
Building a cache database for caching queries;
Detecting that the database middleware receives the query sent from at least one content server;
Determining whether the query received by the database middleware is a query requiring caching;
If it is determined that the query requires caching, storing the query in the cache database as a query in the form of Not Only SQL (NoSQL);
Checking whether a query stored in the cache database can be sent to a database server storing data; And
If it is determined that the query stored in the cache database can be transmitted to the database server, transmitting the query stored in the cache database to the database server; Caching method for database middleware comprising a. The method according to claim 1,
Determining whether the query requires caching,
The query caching method for the database middleware, characterized in that if the priority of the query preset by the content server is lower than the predetermined reference rank, the query is determined to be caching. The method according to claim 1,
Determining whether the query requires caching,
And a predetermined word is included in the query. The query caching method for the database middleware is characterized by determining that the query requires caching. The method according to claim 1,
Determining whether the query requires caching,
If the query is a query requesting a log, the query caching method for a database middleware, characterized in that it is determined as a query that requires caching. Claim 5 was abandoned upon payment of a set-up fee. The method according to claim 1,
If it is determined that the caching is not a required query, controlling the database middleware to transmit the query to the database server; Query caching method for a database middleware, characterized in that it further comprises. Claim 6 has been abandoned due to the setting registration fee. The method according to claim 1,
Saving as the query,
Determining whether the query requiring caching is a query of the NoSQL format;
If the query is not the NoSQL type query, converting the query to the NoSQL type query; And
Storing the NoSQL format query in the cache database; Query caching method for a database middleware comprising a. Claim 7 has been abandoned due to the setting registration fee. The method of claim 6,
Checking whether the transmission is possible,
Setting a timer for specifying a period for checking whether a query stored in the cache database can be transmitted to the database server; And
Transmitting a data transmission determination signal confirming whether to transmit a query stored in the cache database to the database server when detecting that the timer reaches a confirmation period of whether the timer can be transmitted; Query caching method for a database middleware comprising a. The method according to claim 1,
The step of transmitting to the database server,
Determining a priority of a query stored in the cache database;
Transmitting a query stored in the cache database to the database server according to the determined priority;
Reconfirming whether or not the unsent query can be transmitted to the database server when the unsent query exists in the cache database; Query caching method for a database middleware comprising a. Claim 9 has been abandoned due to the setting registration fee. The method of claim 8,
Determining the priority,
Query caching method for a database middleware, characterized in that for determining the priority of the query in the order in which the query is stored in the cache database. Claim 10 has been abandoned due to the setting registration fee. The method of claim 8,
Determining the priority,
Query caching method for a database middleware, characterized in that for determining the priority of the query in accordance with the priority of the query set in the content server. A query determination unit which receives a query from at least one content server and detects whether the query is received by a database middleware that transmits the query to at least one database server, and determines whether the query received by the database middleware is a query that requires caching ;
A NoSQL conversion unit for determining whether the query determined to be caching is a NoSQL (Not Only SQL) type query, and converting the query to a NoSQL type query if it is not a NoSQL type query;
A caching query storage unit for caching the query determined to be caching required; And
Check whether the query stored in the caching query storage unit can be transmitted to the database server according to a predetermined period, and when receiving a transmission signal for the cached query from the database server, the cached query storage unit to the cached query storage unit; A cycle determination unit requesting transmission to the database server; Query caching apparatus for database middleware comprising a. Claim 12 is abandoned in setting registration fee. 12. The method of claim 11,
The query determination unit,
The query caching apparatus for the database middleware, characterized in that if the priority of the query preset by the content server is lower than the predetermined reference rank, it is determined as the query that requires caching. Claim 13 has been abandoned due to the set registration fee. 12. The method of claim 11,
The query determination unit,
And a predetermined word is included in the query. The query caching apparatus for database middleware according to claim 1, wherein the query is determined to be a query requiring caching. Claim 14 has been abandoned due to the setting registration fee. 12. The method of claim 11,
The query determination unit,
If the query is a query requesting a log (log), the query caching apparatus for a database middleware, characterized in that determining that the query requires caching. Claim 15 is abandoned in the setting registration fee payment. 12. The method of claim 11,
The caching query storage unit,
Query caching apparatus for a database middleware, characterized in that for transmitting the cached query to the database server according to the caching order of the query. Claim 16 has been abandoned due to the setting registration fee. 12. The method of claim 11,
The caching query storage unit,
Query caching apparatus for a database middleware, characterized in that for transmitting the cached query to the database server in accordance with the priority of the query set in the content server. Query caching device for database middleware,
Building a cache database for caching queries;
Detecting that the database middleware receives the query sent from at least one content server;
Determining whether the query received by the database middleware is a query requiring caching;
If it is determined that the query requires caching, storing the query in the cache database as a query in the form of Not Only SQL (NoSQL);
Checking whether a query stored in the cache database can be sent to a database server storing data; And
If it is determined that the query stored in the cache database can be transmitted to the database server, transmitting the query stored in the cache database to the database server; A computer-readable recording medium having recorded thereon a program for implementing a query caching method for database middleware comprising a.

Images