| 摘要 |
PURPOSE: A query cashing method for a database middleware and an apparatus thereof are provided to reduce the construction costs of a database server by efficiently dispersing the load of the database server and to smoothly provide data. CONSTITUTION: A query cashing method for a database middleware is as follows: a step of constructing a cashing database for cashing queries (S100); a step of discriminating whether or not the database middleware receives the queries transmitted from a contents server (S200); a step of discriminating whether or not the queries should be cashed (S400); a step of storing the queries to be cashed to a cash database as a not only structured query language (NoSQL) type query (S900); and a step of transmitting the queries stored in the cash database to the database server. [Reference numerals] (AA) Start; (BB,DD,FF) No; (CC,EE,GG) Yes; (HH) End; (S100) Construct a caching data base; (S200) Receive a query?; (S300) Analyze the logic of the query; (S400) Does the query need caching?; (S500) Transmit the query DB to a server; (S600) Query cashing into query DB; (S700) Check the state of a DB server; (S800) Request to transmit the cache query to the DB server?; (S900) Transmit the cache query to the DB server |
