Application of Sybase Data Warehouse in national Credit Securities Company

Under the impact of the information wave, in order to deal with a large number of business data, and quickly make accurate decisions, so as to meet the serious challenges of the future, the various organizations in many industries are actively deploying their own information system architecture. In this case, the system solution provider is faced with the daunting task of requiring a deeper understanding of the business process requirements and the characteristics of the decision-making process in each industry to deliver a performance-fit, demand-appropriate solution. At present, many manufacturers are constantly exploring and seeking a positive technological breakthrough. In this regard, Sybase, an industry solution provider with good market reputation, is at the forefront of the industry, offering a wide range of outstanding solutions to the marketplace, including traditional databases, Internet applications and e-commerce, especially its industry solutions, is to become a bright spot on the market, become the first choice for many institutions system deployment. In the Chinese market, in the large amount of data processing, the level of information requirements of the securities sector, Sybase's data warehousing solutions have been widely praised. Among them, the domestic famous securities institution-------------------------------------------------------

The system demand of national credit securities

At present, China's financial sector is undergoing substantial changes. On the macro level, our financial policy is being further relaxed and financial markets are becoming more open, and the securities industry will have a more open, competitive and rapidly changing environment. From the microscopic point of view, a lot of financial business has been born, the user's needs are constantly changing, financial services will occupy a pivotal position. Specifically to the securities industry, its business process and decision-making support will face unprecedented challenges. Therefore, in addition to improving their own awareness and ability level, the securities industry also needs to deploy advanced information systems for the new era of financial competition to prepare for the challenge.

It is precisely in view of the grim market situation and its own development needs, the domestic large securities business securities decided to build their own advanced information system to deal with the huge business, and to support their own decision-making. Reference to the business model and the development trend of information technology, National securities in the construction of information systems need to fully consider the following operational characteristics: (1) data processing flow. In addition to the agency's own investment business, the securities will also deal with data from a large number of users. Due to the large scale of business, and the current China's securities industry is also in the period of rapid development, SSE, SSE listed companies continue to increase, the number of shareholders is also increasing, from all aspects of the data is naturally soaring. Moreover, with the change of the stock market, the exchange of the bull market and bear market, the data processing volume will appear the trend of sudden decrease, its characteristics are difficult to grasp, this will be the information system needs to solve one of the problems; (2) strong real-time. In the fast-changing securities market today, the real-time ability of transactions and decision-making will become one of the most important factors, only the fastest response to information, securities institutions or investors may seize the opportunity in the market. This is also a relatively prominent feature of the securities industry, (3) High security. In securities markets where the potential value of information (data) is difficult to estimate, the security of data is very important. The information system of national Credit securities must ensure the security of every information entered, so as to fully guarantee the interests of the owner of the information and maintain the order of the securities market; (4) Realize powerful analysis function and provide reliable decision support. The volatility of the securities market leads policymakers to take swift responses, which are not groundless, and require information systems to provide data analysis to help policymakers better grasp future trends.

According to these requirements, the information system of national credit securities needs strong backstage support, and it also needs excellent front-end application to help it provide integrated applications, real-time processing, intelligent decision support and other characteristics. Overall, the system needs to accurately understand and grasp the history of the company's business, timely grasp of the current operating conditions, familiar with the customer's situation and requirements, scientific assessment of investment and financial risks, and accurately predict the market changes and future trends. In order to meet these functional requirements, in the final data system selection, the national credit securities borrowed from the successful experience of China Merchants Bank, and chose Sybase's Data Warehouse solution to help it achieve the centralized processing and analysis of transaction data successfully.

The system mechanism and function of national Credit securities

In the process of construction, the National Credit Securities adopted a three-tier structure of the design approach. The first layer is the business processing layer, including the Electronic business processing system, such as securities trading system, E-commerce system and voucher bank transfer system. The second level is the office moving layer, the national securities development of the electronic mail, document approval, report and public information subsystem, the third layer for the decision support layer, in this layer Sybase's data Warehouse has played an outstanding feature.

"Overall functional characteristics"

Based on Sybase's data warehouse, the securities company has a strong brokerage business analysis system, which provides a wide range of business functions, including funds, securities, clients, capital transactions and non-financial transactions. It employs two types of clients: browsers (providing fixed reports and OLAP) and professional clients (OLAP, fixed reports, and ad hoc queries) that provide more functionality to respond to the needs of different users in a targeted and high-speed way. In general, the analysis method used in this system is multidimensional table, Dovito and other analytical methods.

In the Multidimensional table analysis, the user can view the detailed information from several angles, and can do the visualization analysis to the data. In the visualization analysis, the graphs of various indexes (columnar chart, pie and distribution charts, and so on, are all related to the contents of the data table, that is, whether or not any of the graphs (tables) are selected, the selected data is displayed in the other Diagram (table). Similarly, a visual analysis of the situation within a certain period of time is also available. Its specific analysis subsystem includes:

statistical analysis of accounts. According to the Daily (week, month, quarter, year) statistics of the sales department, the total number of account managers, clients, customers in various market ranges, the number of accounts, shareholders, fund balances, available funds, frozen funds, stock market value and so on, and the amount of the securities sold in the current period, the transaction amount of the securities sold in the current period, the profit and loss situation, Position proportion and active degree and so on the trusteeship Shares statistic analysis. According to the Daily (week, month, quarter, year) statistics of the sales department, the Customer Manager, all kinds of customers, the number of positions, the number of frozen shares, the outstanding shares, the stock market value, the average position cost, the total number of buying shares, the total amount of purchase, the total number of shares sold, Total selling amount, market share, profit and loss situation.

Comprehensive analysis of capital transactions. According to the Daily (week, month, quarter, year) statistics of the sales department, each customer Manager, all kinds of customers, various market value range, various currencies, Shenzhen, two markets, all kinds of securities, various shares, various types of transactions in the number of transactions, transaction amount.