CN105045789A - Game server database buffer memory method and system - Google Patents
Game server database buffer memory method and system Download PDFInfo
- Publication number
- CN105045789A CN105045789A CN201510081285.0A CN201510081285A CN105045789A CN 105045789 A CN105045789 A CN 105045789A CN 201510081285 A CN201510081285 A CN 201510081285A CN 105045789 A CN105045789 A CN 105045789A
- Authority
- CN
- China
- Prior art keywords
- server
- data
- corresponding data
- game
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Abstract
The invention provides a game server database buffer memory method and system, and relates to the server data buffer memory field; the method comprises the following steps: a logic server receivers a calling request, and sends a calling order to a data buffer memory server; the data buffer memory server receives the calling request, if the data buffer memory server has no corresponding data, the data buffer memory server will request a list structure and corresponding data from a game database server storing game data, after the request returns, the list structure and operation in the game database server are simulated, and the corresponding data is buffered; if the data buffer memory server has the corresponding data, the data buffer memory server will directly send the corresponding data to the logic server; the logic server receives the returned corresponding data, simulates the list structure and operation in the game database server, and buffers the corresponding data. The method and system enable buffering and reading to be clearer, hardly have bug, and data management is more ordered, thus complying with development habits of database developing personnel.
Description
Technical field
The present invention relates to server data cache field, particularly relate to a kind of game server database caches method and system.
Background technology
In game logic server, when needing to access the data that some logical server does not have, need to send out request to game database server, then the data game database server reads are needed to break into binary data packets, then be sent in corresponding logical server, and need this scale-of-two bag by resolving to corresponding data structure, this data structure is generally class or structure, not identical with the structure of database, visit corresponding data by the interface of class or structure when searching.After these attributes change, be packaged into binary data again send game database server to and carry out storage operation.
Such mode access and resolution data time for not directly perceived the programmer come into contacts with database, need to change in data structure on Database field and server, even often there is multiple conversion, transfer process can be caused complicated, and often produce bug, also need to write corresponding interface again when reading and store, development efficiency is low.
Summary of the invention
An object of the present invention is to provide one game server database caches method and system easily, the data being delivered to logical server need not be changed through multilayer, improve and run and development efficiency.
Especially, the invention provides a kind of game server database caches method, comprising: logical server receives and transfers request, sends transfer instruction to data cache server; Data cache server transfers instruction described in receiving, if there is no corresponding data in described data cache server, then transfer list structure and corresponding data to the game database server request storing game data, after request returns, list structure in simulation database server and operation, buffer memory corresponding data; If there are corresponding data in described data cache server, then beam back corresponding data directly to logical server; Described logical server receives the corresponding data beamed back, the list structure in simulation database server and operation, buffer memory corresponding data.
Alternatively, described method also comprises: on described logical server, write sql, then performs on described game database server.
Alternatively, when some field data changed by needs, described logical server uses the interface accessing pre-defined and Database field attribute of the same name.
Alternatively, described logical server comprises: process the game server of game logic and player's interactive information carried out to the central server of transfer control.
The invention also discloses a kind of game server database caches system, comprising: logical server, be configured to: receive and transfer request, send and transfer instruction; Data cache server, be configured to: described in data cache server receives, transfer instruction, if there is no corresponding data in described data cache server, then transfer list structure and corresponding data to the game database server request storing game data, after request returns, list structure in simulation database server and operation, buffer memory corresponding data; If there are corresponding data in described data cache server, then beam back corresponding data directly to logical server; Described logical server is also configured to: receive the described corresponding data beamed back, the list structure in simulation database server and operation, buffer memory corresponding data.
Alternatively, described logical server is also configured to: described logical server is also configured to: receive and simulate the sql performing write; Described game database server is also configured to: the described sql of actual execution on described game database server.
Alternatively, described logical server is also configured to: when some field data of needs, uses the interface accessing that pre-defines and Database field attribute of the same name.
Alternatively, described logical server comprises: process the game server of game logic and player's interactive information carried out to the central server of transfer control.
Method of the present invention is due to after logical server receives the request of transferring, send to data cache server and transfer instruction, data cache server beams back its database table structure and corresponding data according to transferring instruction to logical server, therefore the data structure achieving similar simulated database front end is placed in logical server, by type and the name of mapping database field, make it can the directly type of usage data storehouse field and name when these data of logical server inter access, and corresponding sql visits, also achieve in program and perform sql instruction on logical server, the mechanism of also corresponding this instruction of execution in a database simultaneously.And, with the interface adopting this sets of data structure to provide when database caches server and database server communication, make storage and read more clear, be not easy out bug, and data management is more orderly, more meet the exploitation custom of database development personnel.
According to hereafter by reference to the accompanying drawings to the detailed description of the specific embodiment of the invention, those skilled in the art will understand above-mentioned and other objects, advantage and feature of the present invention more.
Accompanying drawing explanation
Hereinafter describe specific embodiments more of the present invention with reference to the accompanying drawings by way of example, and not by way of limitation in detail.Reference numeral identical in accompanying drawing denotes same or similar parts or part.It should be appreciated by those skilled in the art that these accompanying drawings may not be drawn in proportion.In accompanying drawing:
Fig. 1 is the process flow diagram of game server database caches method according to an embodiment of the invention;
Fig. 2 is the block diagram of game server database caches system according to an embodiment of the invention.
Embodiment
Below with reference to accompanying drawings exemplary embodiment of the present invention is described in more detail.Although show exemplary embodiment of the present invention in accompanying drawing, however should be appreciated that can realize the present invention in a variety of manners and not should limit by the embodiment set forth here.On the contrary, provide these embodiments to be in order to thoroughly the present invention can be understood, and complete for scope of the present invention can be conveyed to those skilled in the art.
Intrinsic not relevant to any certain computer, virtual system or miscellaneous equipment with display at this algorithm provided.Various general-purpose system also can with use based on together with this teaching.According to description above, the structure constructed required by this type systematic is apparent.In addition, the present invention is not also for any certain programmed language.It should be understood that and various programming language can be utilized to realize content of the present invention described here, and the description done language-specific is above to disclose preferred forms of the present invention.
In instructions provided herein, describe a large amount of detail.But can understand, embodiments of the invention can be put into practice when not having these details.In some instances, be not shown specifically known method, structure and technology, so that not fuzzy understanding of this description.
Fig. 1 is the process flow diagram of game server database caches method according to an embodiment of the invention.In the embodiment shown in fig. 1, first perform step 10, logical server receives and transfers request, sends transfer instruction to data cache server.Then step 20 is performed, data cache server transfers instruction described in receiving, if there is no corresponding data in described data cache server, then perform step 50, if there is no corresponding data in described data cache server, then transfer list structure and corresponding data to the game database server request storing game data, after request returns, list structure in simulation database server and operation, buffer memory corresponding data.If had, then perform step 30, beam back corresponding data directly to logical server.After step 30, perform step 40, described logical server receives the corresponding data beamed back, the list structure in simulation database server and operation, buffer memory corresponding data.Logical server herein comprises the game server of process game logic and player's interactive information is carried out to the central server of transfer control.
In one embodiment of the invention, can also write sql on logical server, then perform on game database server, so also seem that directly inside database, to perform sql the same.。When some field data changed by needs, logical server uses the interface accessing that pre-defines and Database field attribute of the same name.This similarly is the field on logical server in direct accessing database, in other words, just looks like that direct control database respective field is the same.Fig. 2 is the block diagram of game server database caches system according to an embodiment of the invention.This system at least can comprise game database server 101, data cache server 102, game server 103, central server 104.Game server 103 and central server 104 can be referred to as logical server.Logical server receives and transfers request, sends and transfers instruction; Instruction is transferred described in data cache server 102 receives, if there is no corresponding data in described data cache server 102, then transfer list structure and corresponding data to game database server 101 request storing game data, after request returns, list structure in simulation database server 101 and operation, buffer memory corresponding data, if had, then beams back corresponding data directly to logical server; Logical server receives the described corresponding data beamed back, the list structure in simulation database server 101 and operation, buffer memory corresponding data.Such as, request of transferring from user is sent to game server 103 from gateway 105, game server 103 to data cache server 102 send transfer request after (or inconocenter server 104 sends instruction, central server 104 to data cache server 102 send transfer request after), if existing corresponding data, just beam back corresponding data directly to logical server on data cache server 102; If not then transfer list structure and corresponding data to game database server 102 request.
In one embodiment of the invention, logical server receives and simulates the sql performing write, and game database server is actual on game database server performs sql.In another embodiment of the present invention, when some field data changed by needs, the logical server interface accessing pre-defined and Database field attribute of the same name just look like that direct control database respective field is the same.
Be to be understood that, in order to simplify the present invention and to help to understand in each inventive aspect one or more, in the description above to exemplary embodiment of the present invention, each feature of the present invention is grouped together in single embodiment, figure or the description to it sometimes.But, the method for this invention should be construed to the following intention of reflection: namely the present invention for required protection requires feature more more than the feature clearly recorded in each claim.Or rather, as the following claims reflect, all features of inventive aspect disclosed single embodiment before being to be less than.Therefore, the claims following embodiment are incorporated to this embodiment thus clearly, and wherein each claim itself is as independent embodiment of the present invention.
Those skilled in the art are appreciated that and adaptively can change the module in the equipment in embodiment and they are arranged in one or more equipment different from this embodiment.Module in embodiment or unit or assembly can be combined into a module or unit or assembly, and multiple submodule or subelement or sub-component can be put them in addition.Except at least some in such feature and/or process or unit be mutually repel except, any combination can be adopted to combine all processes of all features disclosed in this instructions (comprising adjoint claim, summary and accompanying drawing) and so disclosed any method or equipment or unit.Unless expressly stated otherwise, each feature disclosed in this instructions (comprising adjoint claim, summary and accompanying drawing) can by providing identical, alternative features that is equivalent or similar object replaces.
In addition, those skilled in the art can understand, although embodiments more described herein to comprise in other embodiment some included feature instead of further feature, the combination of the feature of different embodiment means and to be within scope of the present invention and to form different embodiments.Such as, in the following claims, the one of any of embodiment required for protection can use with arbitrary array mode.
All parts embodiment of the present invention with hardware implementing, or can realize with the software module run on one or more processor, or realizes with their combination.It will be understood by those of skill in the art that the some or all functions that microprocessor or digital signal processor (DSP) can be used in practice to realize according to the some or all parts in the Web page display apparatus of the embodiment of the present invention.The present invention can also be embodied as part or all equipment for performing method as described herein or device program (such as, computer program and computer program).Realizing program of the present invention and can store on a computer-readable medium like this, or the form of one or more signal can be had.Such signal can be downloaded from internet website and obtain, or provides on carrier signal, or provides with any other form.
The present invention will be described instead of limit the invention to it should be noted above-described embodiment, and those skilled in the art can design alternative embodiment when not departing from the scope of claims.In the claims, any reference symbol between bracket should be configured to limitations on claims.Word " comprises " not to be got rid of existence and does not arrange element in the claims or step.Word "a" or "an" before being positioned at element is not got rid of and be there is multiple such element.The present invention can by means of including the hardware of some different elements and realizing by means of the computing machine of suitably programming.In the unit claim listing some devices, several in these devices can be carry out imbody by same hardware branch.Word first, second and third-class use do not represent any order.Can be title by these word explanations.
So far, those skilled in the art will recognize that, although multiple exemplary embodiment of the present invention is illustrate and described herein detailed, but, without departing from the spirit and scope of the present invention, still can directly determine or derive other modification many or amendment of meeting the principle of the invention according to content disclosed by the invention.Therefore, scope of the present invention should be understood and regard as and cover all these other modification or amendments.
Claims (8)
1. a game server database caches method, is characterized in that, comprising:
Logical server receives and transfers request, sends transfer instruction to data cache server;
Data cache server transfers instruction described in receiving, if there is no corresponding data in described data cache server, then transfer list structure and corresponding data to the game database server request storing game data, after request returns, list structure in simulation database server and operation, buffer memory corresponding data; If there are corresponding data in described data cache server, then beam back corresponding data directly to logical server;
Described logical server receives the corresponding data beamed back, the list structure in simulation database server and operation, buffer memory corresponding data.
2. method according to claim 1, is characterized in that, also comprises:
Described logical server writes sql, then performs on described game database server.
3. method according to claim 2, is characterized in that,
When needs change field data, described logical server uses the interface accessing pre-defined and Database field attribute of the same name.
4. method according to claim 3, is characterized in that,
Described logical server comprises: process the game server of game logic and player's interactive information carried out to the central server of transfer control.
5. a game server database caches system, is characterized in that, comprising:
Logical server, is configured to: receive and transfer request, send and transfer instruction;
Data cache server, be configured to: described in reception, transfer instruction, if there is no corresponding data in described data cache server, then transfer list structure and corresponding data to the game database server request storing game data, after request returns, list structure in simulation database server and operation, buffer memory corresponding data; If there are corresponding data in described data cache server, then beam back corresponding data directly to logical server;
Described logical server is also configured to: receive the described corresponding data beamed back, the list structure in simulation database server and operation, buffer memory corresponding data.
6. system according to claim 5, is characterized in that,
Described logical server is also configured to: receive and simulate the sql performing write;
Described game database server is also configured to: the described sql of actual execution on described game database server.
7. system according to claim 6, is characterized in that,
Described logical server is also configured to: when needs change field data, uses the interface accessing that pre-defines and Database field attribute of the same name.
8. system according to claim 7, is characterized in that,
Described logical server comprises: process the game server of game logic and player's interactive information carried out to the central server of transfer control.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510081285.0A CN105045789A (en) | 2015-02-15 | 2015-02-15 | Game server database buffer memory method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510081285.0A CN105045789A (en) | 2015-02-15 | 2015-02-15 | Game server database buffer memory method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105045789A true CN105045789A (en) | 2015-11-11 |
Family
ID=54452343
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510081285.0A Pending CN105045789A (en) | 2015-02-15 | 2015-02-15 | Game server database buffer memory method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105045789A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107798015A (en) * | 2016-09-06 | 2018-03-13 | 盛趣信息技术（上海）有限公司 | Game services end offline operation method |
| CN107800742A (en) * | 2016-09-06 | 2018-03-13 | 盛趣信息技术（上海）有限公司 | A kind of game data stores cache method |
| CN110119338A (en) * | 2019-04-30 | 2019-08-13 | 广州微算互联信息技术有限公司 | A kind of acquisition methods, system and the storage medium of game monitor parameter |
| CN110855708A (en) * | 2019-11-26 | 2020-02-28 | 上海莉莉丝科技股份有限公司 | Game server architecture |
| CN112379949A (en) * | 2021-01-14 | 2021-02-19 | 腾讯科技（深圳）有限公司 | Data processing method, device, equipment and storage medium |
| CN113750521A (en) * | 2020-06-01 | 2021-12-07 | 上海莉莉丝科技股份有限公司 | Data storage system and method |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101110088A (en) * | 2007-04-17 | 2008-01-23 | 南京中兴软创科技有限责任公司 | Database access interface method based on caching technology |
| CN101576918A (en) * | 2009-06-19 | 2009-11-11 | 用友软件股份有限公司 | Data buffering system with load balancing function |
| CN103440285A (en) * | 2013-08-14 | 2013-12-11 | 北京乐动卓越科技有限公司 | Large-scale mobile phone game system and database updating method of large-scale mobile phone game system |
| CN103944993A (en) * | 2014-04-25 | 2014-07-23 | 北京乐动卓越信息技术有限公司 | Million-level user simultaneous online mobile platform server architecture |
| CN104135506A (en) * | 2014-06-25 | 2014-11-05 | 深圳市盛讯达科技股份有限公司 | System and method of load balancing design of network data |
| CN104281673A (en) * | 2014-09-22 | 2015-01-14 | 珠海许继芝电网自动化有限公司 | Cache building system and method for database |
-
2015
- 2015-02-15 CN CN201510081285.0A patent/CN105045789A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101110088A (en) * | 2007-04-17 | 2008-01-23 | 南京中兴软创科技有限责任公司 | Database access interface method based on caching technology |
| CN101576918A (en) * | 2009-06-19 | 2009-11-11 | 用友软件股份有限公司 | Data buffering system with load balancing function |
| CN103440285A (en) * | 2013-08-14 | 2013-12-11 | 北京乐动卓越科技有限公司 | Large-scale mobile phone game system and database updating method of large-scale mobile phone game system |
| CN103944993A (en) * | 2014-04-25 | 2014-07-23 | 北京乐动卓越信息技术有限公司 | Million-level user simultaneous online mobile platform server architecture |
| CN104135506A (en) * | 2014-06-25 | 2014-11-05 | 深圳市盛讯达科技股份有限公司 | System and method of load balancing design of network data |
| CN104281673A (en) * | 2014-09-22 | 2015-01-14 | 珠海许继芝电网自动化有限公司 | Cache building system and method for database |
Non-Patent Citations (1)
| Title |
|---|
| 董传银: "《VisualBasic6数据库编程技术》", 31 October 2002 * |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107798015A (en) * | 2016-09-06 | 2018-03-13 | 盛趣信息技术（上海）有限公司 | Game services end offline operation method |
| CN107800742A (en) * | 2016-09-06 | 2018-03-13 | 盛趣信息技术（上海）有限公司 | A kind of game data stores cache method |
| CN107800742B (en) * | 2016-09-06 | 2021-12-24 | 盛趣信息技术（上海）有限公司 | Game data storage caching method |
| CN110119338A (en) * | 2019-04-30 | 2019-08-13 | 广州微算互联信息技术有限公司 | A kind of acquisition methods, system and the storage medium of game monitor parameter |
| CN110855708A (en) * | 2019-11-26 | 2020-02-28 | 上海莉莉丝科技股份有限公司 | Game server architecture |
| CN110855708B (en) * | 2019-11-26 | 2021-06-11 | 上海莉莉丝科技股份有限公司 | Game server architecture |
| US11513863B2 (en) | 2019-11-26 | 2022-11-29 | Shanghai Lilith Technology Corporation | Game server architecture |
| CN113750521A (en) * | 2020-06-01 | 2021-12-07 | 上海莉莉丝科技股份有限公司 | Data storage system and method |
| CN113750521B (en) * | 2020-06-01 | 2024-03-22 | 上海莉莉丝科技股份有限公司 | Data storage system and method |
| CN112379949A (en) * | 2021-01-14 | 2021-02-19 | 腾讯科技（深圳）有限公司 | Data processing method, device, equipment and storage medium |
| CN112379949B (en) * | 2021-01-14 | 2021-04-13 | 腾讯科技（深圳）有限公司 | Data processing method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105045789A (en) | Game server database buffer memory method and system | |
| US9892144B2 (en) | Methods for in-place access of serialized data | |
| CN103617191A (en) | Browser and method for rendering same by means of hardware acceleration | |
| CN104462231B (en) | The method, apparatus and system of webpage rendering | |
| CN102934104A (en) | Web site implementation by mapping expression evaluation | |
| CN109074309A (en) | Data access between calculate node | |
| CN103279538A (en) | Server, browser client side and method for preloading webpages in visited websites | |
| CN104111847A (en) | Method and device for improving running speed of games | |
| CN104572968A (en) | Page updating method and device | |
| CN105095423A (en) | Write-in method and device for count data | |
| CN103034540A (en) | Distributed information system, device and coordinating method thereof | |
| CN109767274B (en) | Method and system for carrying out associated storage on massive invoice data | |
| CN103034541A (en) | Distributing type information system and equipment and method thereof | |
| CN106227769B (en) | Date storage method and device | |
| CN109726096B (en) | Test data generation method and device | |
| CN104321750B (en) | The method and system of release consistency is kept in shared memory programming | |
| CN103544271B (en) | Load Image in a kind of browser the method and apparatus for processing window | |
| CN104239412B (en) | The data mapping to thesaurus and correlation technique, system and computer-readable medium are applied in data repository | |
| CN103647811A (en) | A method and an apparatus for application's accessing backstage service | |
| US9606802B2 (en) | Processor system with predicate register, computer system, method for managing predicates and computer program product | |
| CN114443680A (en) | Database management system, related apparatus, method and medium | |
| CN105389394A (en) | Data request processing method and device based on a plurality of database clusters | |
| CN104346234B (en) | A kind of method of internal storage access, equipment and system | |
| CN102236673B (en) | AJAX (Asynchronous JavaScript and XML)-based resource multi-page distribution method | |
| CN105550050A (en) | Hardware communication method and apparatus |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20151111 |
|
| RJ01 | Rejection of invention patent application after publication |