The Study Of Database Model Based On Interactive On-line Game

The purpose of this thesis is to create a light-weight database with the character of briefness, delicacy and currency. It is a special database designed for the Interactive On-line Game and is able to satisfy the requirement of storage and query for multimedia data in the game. So the database is named as Inter-Game DB for short. The important point of this thesis is embedding database technology into the Interactive On-line Game.Due to the demand of real-time and interactivity, the Interactive On-line Game has to transfer the multimedia data composed by picture, sound and action script files as game roles stored on the disk quickly. Owing to the costly charge and high hardware requirement of commercial databases, the existing games usually make use of the file system based on the Windows of Linux to preserve all the data instead of commercial databases, but the disadvantage is that the game can not search data by attribute or index as flexibly as the database, and its maintenance is inefficient and hard. As a result, to promote the development of Chinese Cartoon Game, it is cried for one professional database to support game working smoothly and it is free for the game players.Aiming at these problems, this thesis designs a special database focusing on the Interactive On-line Game. The database is built by multimedia data sorting, storage structure, data management and SQL parser. In order to match the Interactive on-line Game, hash technology, 00 (Object-oriented) ideology, mapping mechanism between disk and memory, and DFA (Design For Assembly) theory are used in Inter-Game DB to quicken the speed of search and read/write. In detail all the multimedia data in the Inter-Game DB are classified by image, audio and action. At the bottom of the database, a structure of Hash Link Bucket is made up to store these three kinds of data. Under the idea of 00, a new kind of data named role which is composed by these three kinds of data, is created. So the multimedia data are managed from two aspects, namely physical storage and logic semanteme. In the Inter-Game DB, a table about multimedia data description is built up to implement efficient query. Then data query can be done in this table which runs in the main memory. At the same time, mapping relation is set up between disk data and memory table to realize the management of multimedia data by DML (Data Manipulation Language) action on the table. On the top of the database, standard protocol for data collection is established to suit for Java and C++ programming. Furthermore, a state transfer matrix is founded based on DFA. With the help of the matrix, a flexible and applied SQL parser is able to compile SQL-92 sentences. At last, a tool for visible management is produced and it can provide service for game programmers and game players by the privilege management.