| The design and implementation of social insurance systems based on C/S architecture has developed with the endless process of informization of enterprises to make data at client-ends and server-ends consistant and shared finally. C/S architecture has lots of advantages compared to other architectures and many of them have been shown fully during the whole development and design of social insurance systems. The design and development based on C/S architecture has become more and more popular in recent years with a large percentage in software designs even with the fact of fast development of net, especially for the program developments of middle and small enterprises, because it will help them to update to other higher architectures if these enterprises can run systems on C/S architecture successfully and smoothly. The social insurance of Ji Lin province is a typical model of C/S architecture and apparently displays many advantages of this architecture in the whole social insurance software development, which mainly are that parallel client-ends and server-ends exchange data quickly and requests sent by client-ends can be responded at server-ends immediately. Additionally, the development of social insurance systems based on C/S architecture is in accordance with the requirements of National Labor Department and in order to realize every factor of these 70 items listed by National Labor Department and other requirements in the software, parallel multi-table operations are needed in the software and therefore C/S architecture is enough for it.This article implements the social insurance development mostly according to the prevailing C/S architecture with application database Sybase and development software PowerBuilder. During the development process, social insurance analysis database and social insurance analysis model are built initially through the use of Sybase data warehousing technique. Then designs and analysis of all modules centering the senior and the unemployment are done and it covers basically common social insurance analysis and the senior insurance online service throughout the country. The goal is to build common social insurance analysis prototype, meet users'demands for macro-data analysis and support their setting and adjusting all principles. Creating C/S architecture application is a repeated process of expanding and bettering, thus it is not possible to cover everything but consider throughly the database structure of social insurance business analysis and business analysis model in most situations.As a whole, the design of application program based on C/S architecture consist of the following phases: system creation, model analysis, system merging and analysis design.To apply softwares based on C/S architecture, it is necessary to understand the C/S architecture entirely first. The C/S architecture model is based on interface programs of client-ends and server-ends and makes the database system manage all data synchronization no matter how quantitative data are and the latter factor is an important part of the C/S architecture.For the detailed database system that the application program combines with, the analysis about the model of C/S architecture and database system is very important. Firstly, the way for the C/S architecture to be used in the applied database system should be analyzed. As for the analysis about the parallel capability of database model, the database system model should be considered in the detailed application of the C/S architecture since the C/S architecture takes different model analysis methods in different databases. It is essential to coordinate these two aspects to make a better system and to ease the operations of end users. So the database system and the C/S architecture model analysis have to cooperate well to make the application program more convenient to handle.After system creation and model analysis, the next is system merging in detail. The application environment for the software should be thought of and the requirement of the C/S architecture for data is a must. The combination of the C/S architecture, database system and the application software here is such a vital phase that in the detailed process the flow chart is used to make feasibility analysis about data flows and by combining detailed data flows to get the C/S architecture and the application software merge well. Following the three phases above is the design of the social insurance software whose premise is stable construction, correct model analysis and safe system merging. Program design is the last step of the C/S architectured application software and the final result of uniting frontground and background. The design and implementation of the social insurance system chooses PowerBuilder as the frontground and Sybase as the background, which can realize the requirement analysis and bring out all modules well. PowerBuilder can provide rather easy operations on tables and connection to databases and at the same time Sybase can make PowerBuilder play a full-length role in database operations.This article designs softwares according to present popular C/S architecture, implements requirement analysis reports of social insurance software by combining social insurance business flows and operation procedures and finally realizes requirement analysis of softwares through detailed analysis of business flows and operation procedures. The first two chapters of the article introduce the C/S architecture and social insurance in detail. In the C/S architecture, the social insurance software system takes up the C/S architecture, more precisely, the DB-ODS-DW architecture. The studying and analysing of the ODS layer theory and the introducing of operation on data store layer with the goal to relieve burdens on business system and provide a united data environment for data warehousing system have laid a possible foundation for multi-table operations. This article will create the database and the analysis model of social insurance business initially through the social insurance business model and Sybase data technique. Then designs and analysis of all modules centering the senior and the unemployment are done and it covers basically common social insurance analysis and the senior insurance online service throughout the country. The goal is to build common social insurance analysis prototype, meet users'demands for macro-data analysis and support their setting and adjusting all principles. Due to present differences with locations in analysis needs and creating C/S architecture application is a repeated process of expanding and bettering, it is not possible to cover everything but consider throughly the database structure of social insurance business analysis and business analysis model in most situations.The design and implementation of social insurance systems based on C/S architecture has finally realized insurance collection, senior fund, fund collection and payment, unemployment fund and inquiry in five main modules which coordinate on the C/S architecture. The finished social insurance system software will provide social insurance users with macro-analysis, data analysis, high class management such as decision assistance and separate handling analytical data from the business system to improve performances of the business system. |