OPEN DATABASE-BASED FAR-DISTANCE BICENTRIC ONLINE PROCESSING METHOD AND SYSTEM

摘要

An open database-based far-distance bicentric online processing method and system are disclosed. The method comprising: capturing a database access related information of an online transaction from an APP server; automatically recognizing update statements and query statements according to SQL statements in the database access related information and a type of a storage process; and directing the update statements and the query statements to database servers of a primary center and a backup center respectively for operation. The present invention routes the query statements to the backup center to realize an open system ultra-far-distance bicentric transaction processing, thereby breaking the limitation of the 30 km distance of the IBM GDPC and ORACLE Rac technologies, improving the processing capacity and usability of the production system, and sufficiently utilizing the resources of the backup centers in the same city.