Teradata @ Work

Ready for Anything

Shanghai Stock Exchange implements a first-of-its-kind disaster recovery system.

Since Shanghai Stock Exchange established its enterprise data warehouse (EDW) several years ago, it has become an indispensable information-sharing platform. So keeping this critical technology operating at all times—even when something goes awry—was a priority for its latest implementation project.

SIDEBAR: About Shanghai Stock Exchange

Because an unexpected disaster could halt the internal and external services of the data warehouse, Shanghai Stock Exchange launched the third phase of its data ware-house project in July 2007. It features China's first EDW with dual architecture of a master production system and disaster recovery system. The solution is designed to ensure stable development of the stock market with continuous data analysis and information services.

Working with Teradata, Shanghai Stock Exchange optimized the system architecture by leveraging existing facilities and protecting its investment in previous-generation technology through differentiated storage. It also collects consistent and redundant detailed data and summary data to provide continuous data analysis and information services.

If a system fails, the stock exchange's 250 internal users from 12 departments can still access more than 600 applications via the disaster recovery system. Likewise, data file export services can be secured to external users.

"Supported by the Teradata Professional Services team, Shanghai Stock Exchange completed the third-phase project and brought data warehouse performance to a new level by realizing four objectives: consolidation, capacity expansion, differentiated storage and disaster recovery system deployment within the same city at the same time," says Bai Shuo, assistant general manager and chief engineer of Shanghai Stock Exchange. "With the adoption of the dual-loading technical approach and data-checking mechanism, we have managed to solve the big problem of data inconsistency between the master data warehouse and the disaster recovery system.

"During project implementation, switches between master and disaster recovery data warehouse systems were all accomplished within 30 minutes, with no changes or errors seen on source code, data content and data output results," he adds. "This fully demonstrated that the system could enable fast, precise and efficient upgrading as well as support normal business operations at the same time.

"Therefore, the experience in implementing this project indeed provides learning for similar enterprises worldwide that are establishing disaster recovery systems for their data warehouses."

Dual performance

The benefits of the project extend beyond disaster recovery to performance, which was greatly improved. Completed within a year, the whole dual-system architecture increased processing speed by more than 49% over the previous platform.

The dual approach both protects and optimizes the EDW solution. This allows Shanghai Stock Exchange to leverage the data warehouse for effective decision support, market surveillance and service quality. In doing so, it has enhanced its information sharing and operational efficiency, as well as enabled the calculating, validating and delivery of value-added information services.

Your Comment:
Your Rating:

Mike, Can you share hardware/software configuration ,capacity, perm of both systems.

10/14/2014 3:55:06 PM
— Anonymous
Fuzzy Logix