Sybase application case: National Trust Securities

In April 99, the first phase project of the National Securities Data Warehouse system based on the famous Data Warehouse provider Sybase Corporation solution was successfully completed, and the first phase project was designed to provide quick and effective reports and analysis methods for decision-makers to improve the company's market response speed and competitive level. Since October 98, with the active participation of Sybase company and relevant partners, Guo Shin Securities Co., Ltd has successfully realized the centralized processing and analysis of national credit transaction data by drawing on the successful experience of China Merchants Bank and relying on its own technical force. The system includes customer analysis, account analysis, securities summary analysis, capital transaction analysis, non-capital transaction analysis and many other topics of concern to the industry. Company users can achieve multiple levels of data access through fixed flexible reports, multidimensional analysis and other means, including access to authorized internal Web sites, automatic e-mail message forwarding, direct client/server connections, and more. So that the decision makers on the company's various departments of the customer situation, capital structure, position structure and other current data reports and the same period comparison, trend chart clear chest, its data comprehensiveness, accuracy, speed is unprecedented.

The starting point of the fastest securities Data Warehouse system is to play the efficiency of OLTP system more effectively, on the basis of the construction of "DATAWAREHOUSE/DSS". At the same time, considering the continuous improvement of the company's business system and the higher requirements of decision support, with unlimited scalability for growing enterprise data and the availability of controllable, fast query response times, the system takes a step-by-step strategy: Considering the scale, the current system will be able to accommodate the expansion to include finance, Personnel management, such as a wide range of business-level data Warehouse system platform, from the application point of view, follow from the general application to the application of the project gradually completed, now the system first resolved the day-to-day decision-making support the most commonly used and concerned about a variety of fixed statements, flexible statements, multidimensional analysis processing, etc. The distribution of these applications completely solves a simple reporting system with previously limited functionality, and users will feel richer, more responsive, and more flexible when using new reports. As a general feature of the securities industry, its data is highly sensitive, the system in the process of formulation and implementation of the user rights in the management of the most adequate consideration, the use of multi-level security mechanisms to control the rights of different user groups and users, so as to completely avoid the data warehouse can not give users the actual use of the risk, which, Low-level users get their own departments of the relevant reports, intermediate users with responsibility-related reports, multidimensional Analysis, details, or even the entire company some of the summary information, advanced users can survey the company's summary and detail information.

The Data Warehouse system can provide analysis function for various departments of the securities, including sales department, transaction Management department, Investment Management department, national Debt department, Audit department, President Office, Research Center, Finance Department, investment banking department, etc., thus providing basis for decision-making.

The National Securities Data Warehouse system is based on Sybase Data Warehouse technology and employs a number of Sybase products, including Data Warehouse storage Server Adaptive server IQ, Data Warehouse design modeling Tool Warehouse Architect and Application Server Enterprise Application Server, and Sybase technicians are also involved in the design and development of the system.

After the completion of the first phase of the project, the securities will continue to work on how to fully use the data in the warehouse to enrich other applications, launch risk management and other topics of application development and data mining.