Managing Disaster Recovery
The United States Securities and Exchange Commission (SEC) has four divisions and 18 offices, including 11 regional offices throughout the country. The agency promotes the disclosure of important information, enforces securities laws and is also responsible for tracking all daily stock transactions conducted in the country.
The SEC needed a completely new system to manage a robust disaster recovery architecture and allow it to process large amounts of data while increasing the system's overall performance.
A solid pilot system put Sybase IQ ahead of the competition by delivering fast query speeds and impressive compression ratios. Queries now take seconds instead of hours or days.
"Based on the positive feedback from the pilot program, Sybase was the choice," said Samuel Foster, president of FosterSoft, an SEC contractor. "The current system was not efficient until Sybase IQ came on board."
Flexible, Scalable and Reliable Data Warehouse
With Sybase IQ, the agency built a flexible, scalable and reliable data-rich warehouse that delivers faster load times and query results, and more comprehensive information views—all at a lower cost. Sybase Adaptive Server Enterprise (ASE) acts as the transactional feed.
With the implementation, Foster and the SEC team have a secure system, providing continuous business operations and better performance.
"Since we've been live with the new system, there has been no unplanned downtime. None. It has been 100 percent satisfactory," Foster said.
A Model Solution
The system can now accommodate large volumes of data and expanded growth, allowing the SEC to access large amounts of current and historical data. End-users of the new architecture are extremely pleased with the results. Sybase IQ is powering the new, fast and sleek data architecture system at the SEC, enabling the end user to work more efficiently, which ultimately benefits anyone who actively trades in the United States stock markets.
"Our success is directly due to the support we received from Sybase and the quick and easy implementation," Foster said. "As a result, this architecture is presented as a model for other divisions and agencies for data warehousing."