Method and system for transmitting pre-formulated query to database

• US 7,836,073 B2
• Filed: 09/27/2006
• Issued: 11/16/2010
• Est. Priority Date: 09/29/2005
• Status: Active Grant

• Current Assignee: NHN Entertainment Corporation
• Original Assignee: NHN Corporation
• Inventors: Ahn, Junghwan
• Primary Examiner(s): Cottingham; John R.
• Assistant Examiner(s): Allen; Nicholas E
• Application Number:
  US11/528,103
• Publication Number:
  US 20070073664A1
• Time in Patent Office: 1,511 Days
• Field of Search: 707/770
• US Class Current: 707/770
• CPC Class Codes: G06F 16/2471 Distributed queries

Abstract

A method of transmitting a query to a database, the method including: maintaining a database gateway storing at least one query corresponding to a predetermined group identifier and a query identifier; maintaining a database list of a plurality of databases connected to the database gateway; receiving a group identifier and a query identifier associated with a certain query, from a client; identifying a query corresponding to the received group identifier and query identifier at the database gateway; transmitting the identified query to a corresponding database by referring to the database list; and performing data retrieval by using the transmitted query at the database and generating and transmitting retrieval result information to the database gateway as a reply.

Claims

1. A method of processing a query related to information of a gaming application that is stored in a plurality of game databases, the method comprising:

providing a database gateway in communication with a plurality of databases comprising first and second game databases having respectively different properties for processing queries related to the information of the gaming application, the database gateway storing a plurality of pre-formulated queries for information from the gaming application therein, each pre-formulated query being identified at least by a combination of a group identifier that identifies at least one set of queries for information from the game application and a query identifier that identifies at least one query for information from the gaming application among the at least one set of queries, each database being assigned a database attribute identifier that indicates its respective properties, each pre-formulated query being also assigned a database attribute identifier, wherein a pre-formulated query having a particular database attribute identifier is configured to be processed in at least one database among the plurality of databases, that is assigned the particular database attribute identifier, based on the properties of the at least one database;

receiving, in the database gateway, a first group identifier and a first query identifier from a terminal associated with a user;

identifying, in the database gateway, a first pre-formulated query among the plurality of pre-formulated queries using both the first group identifier and the first query identifier;

determining, in the database gateway, that the first pre-formulated query is assigned a first database attribute identifier;

selecting, in the database gateway, the first database from the plurality of databases, wherein the first database is known to the database gateway as capable of answering the first pre-formulated query based on the properties of the first database and as assigned the first database attribute identifier;

transmitting the first pre-formulated query to the first database for processing; and

coordinating, in the database gateway, an answer to be made available to the user based on a response from the first database.

2. The method of claim 1, wherein coordinating comprises:

receiving, in the database gateway, the answer from the first database; and

forwarding the answer to the terminal or another terminal associated with the user.

3. The method of claim 1, wherein it is predetermined that the pre-formulated query is to be answered by the first database.

4. The method of claim 1, wherein a list of the plurality of databases connected to the gateway is stored in the database gateway.

5. The method of claim 1, wherein the first database is updated with data to be used in answering the query along with one or more other databases belonging to the plurality of the databases.

6. The method of claim 5, wherein the first database is updated by multicasting to at least part of the plurality of databases information so as to make the at least part of the plurality of databases to be consistent.

7. The method of claim 1, wherein the database gateway comprises a computer or a computerized device connected to an information network and configured to process the received query.

8. The method of claim 1, wherein the first database comprises a computer or a computerized device storing data and configured to process the first pre-formulated query transmitted from the database gateway.

9. The method of claim 1, wherein the database gateway selects the first database as the first database has a particular property known to the database gateway that enables the first database to make an appropriate response to the first pre-formulated query.

10. The method of claim 1, wherein the first database attribute identifier comprises information indicative of one selected from the group consisting of Oracle, MSSQL, and MySQL.

11. The method of claim 1, wherein selecting comprises first selecting at least one database known to the database gateway as capable of answering the first pre-formulated query, wherein the at least one database comprises the first database, and subsequently selecting the first database among the at least one database as assigned the first database attribute identifier.

12. The method of claim 1, wherein the database gateway is separate from the plurality of databases.

13. A system for processing a query related to information of a gaming application that is stored in a plurality of game databases, the system comprising:

a database gateway communicably connected to a plurality of different databases comprising at least a first database, the first database comprising data of the gaming application and being configured to process and answer a query using the data, wherein the configuration of the first database is indicated by at least one database attribute;

wherein the database gateway comprises;

a memory configured to store a plurality of pre-formulated queries therein, each pre-formulated query being identified at least by a combination of a group identifier that identifies at least one set of queries for information from the game application and a query identifier that identifies at least one query for information from the game application among the at least one set of queries, each database being assigned a database attribute identifier, each pre-formulated query being also assigned a database attribute identifier, wherein a pre-formulated query having a particular database attribute identifier is configured to be processed in at least one database that is assigned the particular database attribute identifier;

an identifier receiver configured to receive a group identifier and a query identifier transmitted from a terminal associated with a user;

a processor module comprising at least a processor, the processor module configured to identify a first pre-formulated query among the plurality of pre-formulated queries using both a group identifier and a query identifier received by the identifier receiver, configured to subsequently determine that the first pre-formulated query is assigned a first database attribute identifier, configured to subsequently select the first database from the plurality of different databases that is capable of answering the first pre-formulated query based on the at least one database attribute and is assigned the first database attribute identifier; and

an answer coordinator configured to transmit the first pre-formulated query to the first database and further configured to coordinate the first database so as to make an answer from the first database available to the user.

14. The system of claim 13, wherein it is predetermined that the first pre-formulated query is to be answered by the first database.

15. The system of claim 13, wherein the answer coordinator is configured to receive the answer from the first database and further configured to forward the answer to the terminal or another terminal associated with the user.

16. The system of claim 13, wherein a list of the plurality of databases connected to the gateway is stored in the database gateway.

17. The system of claim 13, wherein the first database is configured to be updated with data to be used in answering the query along with one or more other databases belonging to the plurality of the databases.

18. The system of claim 13, wherein the first database comprises a computer or a computerized device storing data and configured to process the query or the information transmitted from the database gateway.