Patent ID: 7636740

Claim:
A database cache system which is located between at least one online game server and at least one database, supports a non-blocking query processing approach, and minimizes query compilations, transaction processing and physical disc accesses, the database cache system comprising: a network library which processes an access request issued by any of the at least one online game servers by using an input output completion port (IOCP); a plurality of database connection modules each providing a connection to the at least one database for reading data from the at least one database or recording data to the at least one database, wherein the database connection modules allow the online game server to connect to any of the at least one database, regardless of the type of database; a database cache which stores data read from the at least one database by the database connection module; and a plurality of cache buffers each corresponding to one of the database connection modules and each being allotted to an IOCP worker thread corresponding to a database query request issued by any one of the at least one online game server, wherein each of the cache buffers is used to process the query request issued by the at least one online game server, stores data read from the database to be transmitted to the at least one online game server, and obtains data from the database cache to be transmitted to the at least one online game server; wherein the database cache stores the data read from the at least one database via any one of the cache buffers and each of the respective cache buffers used to process the query request obtains data from the database cache when the information of the database cache is sufficient for processing the query request and obtains data from the at least one database when the information is not sufficient, and wherein the database cache system fetches information from the at least one database via the cache buffer, and the information is fetched from the at least one database only when information fetched from the data base cache is insufficient, such that the database cache system processes most of the query requests on a physical memory level thereby removing unnecessary accesses to a physical disk and enhancing the speed of responding to a user wherein each database connection module of the plurality of database connection modules has a number of ports that is the same as the number of different types of databases, such that the database connection module can connect to any of the databases regardless of the type of database.