Mirroring The High Availability Of Data Acquisition Based On Database Application System

Securities industry is so highly depend on information systems that nearly none of business can operate without them. With the development of business, increasingly large amount of data generated by information systems needs to process and analyze, which requests the data acquisition system to process with higher speed, more highly automation degree and to be more available then it can perform fault divert to achieve the tasks successfully in the case of hardware failure.This paper proposes a new solution to data acquisition system in terms of concurrency, fault-tolerant and availability after identifying the shortcomings of the data acquisition applications commonly used by the securities industry and analyzing the specific requirements of the securities industry. First, it will reconstruct the data acquisition task to implement multi-task concurrent data collection and data validation fallback mechanism, and use the DTS (Data Transformation Service) data replication technology to execute data extraction, transmission and storage steps synchronously, improve the data acquisition speed, and ensure the correctness of the data collection results; Second, automatic fault-divert mechanisms for database system and Middleware are designed respectively using database mirroring technology and auto-detection and resume technology to perform the data acquisition tasks continuously after detecting the hardware failure, so that the availability is higher. As a result, it makes real-time data analysis possible and risks of the securities company can by controlled better.