Oracle Server Storage helps Shanghai employees ' security fraternity

Shanghai employees ' security fraternity ("Occupational Insurance Council") adopts Oracle SPARC Enterprise mhttp://www.aliyun.com/zixun/aggregation/37392, which runs Oracle Solaris. HTML >8000 Server and Oracle Pillar AXIOM 600 Storage systems, successfully building a database system platform based on Oracle servers and storage systems. The implementation of the project has greatly improved the processing speed, query speed and report processing speed of the occupational insurance business, and provided a solid guarantee for the completion of the work of the Mutual Aid guarantee Program of the employees ' guarantee societies in Shanghai.

Founded in 1994, the Shanghai Staff Security Association is approved by the Shanghai Municipal Council of Citizens of the city employees of the mass mutual assistance and cooperation of corporate organizations. Adhering to the "poly small, do big things", "no disease I help people, sick people help me" mutual aid spirit, the Shanghai staff security Fraternity has launched a number of mutual aid protection schemes to assume more than 60% of the city's in-service workers and 99% of retired employees of the security plan and tasks, and Shanghai retired workers as "second health insurance."

The continuous expansion of business type and the continuous growth of data scale have brought great pressure to the existing information system of Shanghai employees ' guarantee fraternity, in order to ensure the smooth completion of many security plans and settlement, the Shanghai employees ' guarantee fraternity needs a new information system to respond to business needs with strong data analysis capability and efficient performance.

Through rigorous alignment of market leading suppliers ' products, in 2012, the Shanghai Employees ' Security Council selected 2 SPARC Enterprise M8000 servers to build a dual-computer database server system, with pillar Axiom 600 as the storage system configured, The server system of the service data platform is constructed. July, the data migration and application test of the database of occupational insurance business system was completed, and the database system platform of Shanghai Employees ' security Service was run on the basis of Oracle server and storage System. At present, the system in the insured member up to nearly 700 million people, the payment cost details up to 50 million, over the years to record data of nearly 100 million.

Performance-based differentiated storage services for High-performance SPARC Enterprise M8000 servers and pillar Axiom Storage systems running Oracle Solaris meet the needs of large databases and large-scale OLTP applications for the occupational-insurance business system, tested by comparison, The service processing speed, fuzzy query speed and report processing speed of the new system are more than 10 times times higher than the original system.

The high performance block-level storage connectivity provided by Pillar Axiom Fiber Channel SAN Slammer significantly increases the system's I/O capability, and the data is regularly transmitted back to one-fifth of the original system. With Oracle Pillar AXIOM 600 Storage System database mixed column compression, physical storage space reduced by more than half, saving equipment procurement, power and computer room costs.

The high reliability, availability, serviceability, scalability, and virtualization capabilities of the SPARC Enterprise M8000 Server meet the requirements of stable continuous operation and smooth upgrade and expansion of the occupational insurance business, while pillar axiom storage systems are provided with dual active/active control units, fans, The redundant storage controller for power supply and mirrored cache provides efficient and secure security for the data storage of the occupational insurance business system.

Policy-based configuration through a simple graphical management console it realizes the centralized unified management, maintenance, diagnosis and tuning of host, storage, operating system and database system platform, solves the problem of clutter of IT environment and difficulty of system maintenance under the original system architecture, and reduces equipment failure and maintenance workload. Lowers the total cost of ownership of the system.

Oracle executive and customer related quotes

Li Jiehua, director of the Computer center of the Shanghai Staff Security Council, said: "Oracle hardware Platform enables our security database system to use a variety of optimization technologies to meet the needs of real-time job insurance and data processing, without having to dedicate a separate high-availability design for each application, so that it really does ' spend a dime, Do big things. ”

"We are pleased to see that the Mei Zhengyu database system platform based on Oracle server and storage is a good way to meet the current and future demands for data processing, analysis and management in Shanghai," said Oracle, vice president and general manager of China's regional systems department. Industry-leading Oracle hardware products will continue to deliver on long-term commitments to customers, innovate continuously, and help more Chinese enterprises and government agencies to further optimize their information management systems, improve performance, and lower total cost of ownership. ”