Use Data Fragment Technology to Speed Queries of Mass Data

Abstract

Based on the study about the common methods of speeding queries, a new project of using data fragment technology to speed queries of mass data has been advanced. At the same time, the technologies of database synchronization and load balance scheduling are also solved in the project. As an example, the solution of the public security management information system in hotels shows how to realize it. Keywordsdata fragment;database synchronous;distributed database;oracle;data replication I. MASS DATA RESTRICTS QUERIES OF INFORMATION With the development of information technology and network technology, enterprises pay more and more attention to information construction. However, after long time cumulation, data in information system has reached million level, which certainly would slow query speed. Slow queries become the weakness of information system. In recent years, Hotel industry in China has developed rapidly. Under the new security situation, the Ministry of Public Security takes construction of public security management information system in hotels as important content of “Golden Shield Project”, it is break with this, all kinds of special trade security management information system construction is promoted overall. According to unified requirements of Ministry of Public Security, the Public Security Bureau of Jiangxi Province implemented the public security management information system in hotels before 2008 Beijing Olympic Games, and established a comprehensive platform to collect and store data of hotel industry for implementing unified functions such as online fugitive alarming and information inquiry. The query speed of the system was ideal for a long time, while time grows, mass data slows quires, which directly affect work of the police. II. COMMON METHODS OF SPEEDING QUERIES Many experts and scholars study on how to speed queries and put forward some solutions, which could be summarized