Sybase application case: Sinopec Sales Management system

1, demand analysis Sinopec Sales management system is for the group leadership, Sales management department and provincial and municipal companies to understand the important situation of business management, and has analysis, predictive function of the auxiliary decision-making system. This system mainly according to the Sales Management department four enterprise Management and management of the actual situation, with the provincial and municipal company data as the core, the use of advanced information technology means, show the enterprise macro operating status and development trend, revealing the enterprise assets operating efficiency and available resources, improve the level of enterprise management.

2 The system structure of Sinopec Sales management system

The group is headquartered in Beijing, under the 23 provincial companies, 263 city companies, more than 1300 county companies. The existing network connectivity is: The network condition between the group headquarters and the provincial company is X.25 or DDN; The network conditions between the provincial company and the city company are X.25 or DDN or dial-up; the network condition between the city company and the county company is dial-up.

2, Sinopec Sales management system at all levels completed functions

The county Company: collects the business information within the jurisdiction, stores the information, analyzes and statistics the information, and transmits the required information to the city company.

The City Company: collects the business information within the jurisdiction, accepts the business information transmitted by the county company, stores the information, analyzes and statistics the information, and transmits the required information to the provincial company.

Provincial companies: Collecting the business information within the jurisdiction, receiving the business information transmitted by the City company, storing the information, analyzing and counting the information, and transmitting the required information to the group headquarters.

Group headquarters: Collects the business information within the jurisdiction, accepts the business information transmitted by the provincial company, stores the information, analyzes and counts the information.

To sum up, in the Sinopec Sales management system, the selected database manufacturers need to solve the following problems:

The system involves a wide range, many levels, hardware environment and business needs are different. Sybase provides the corresponding database products for different requirements: Adaptive Server Enterprise for UNIX is applied to minicomputer, Adaptive server Enterprise for NT is applied to NT servers, adaptive Server anywhere is applied to PC (95/98) or PC Server (NT).

The data in the system is dispersed at all levels, and the data needs to be sent up and down layers. Sybase provides data replication products for different network situations: Replication server can be applied to environments with better network conditions (such as X.25/DDN), and SQL remote can be applied to environments where network conditions are bad, such as dialing. All of these data replication products are based on database transaction, which can guarantee the data consistency and integrality of distributed database system completely.

The application of Sinopec Sales management system should use three-tier architecture as far as possible, and the client adopts browser to realize thin or 0 customers.

Sybase provides the enterprise application server to implement these features: The PowerDynamo module, by embedding SQL statements or script scripts in HTML pages, enables the publishing of information in the database through the browser The Jaguar CTS module provides a running environment for components (JavaBean, ActiveX, PB nvo, etc.) that can handle database transactions. In addition, Sybase provides a wealth of development tools, such as PowerBuilder, Powerj, to quickly and efficiently develop reusable components that can be easily submitted to enterprise application server.

For group headquarters or provincial companies, it is necessary to consider the construction of a data warehouse system. The warehouse studio provided by Sybase is fully capable of satisfying all requirements, while Sybase has a number of practical cases at home and abroad to help users take fewer detours.

At the group headquarters, the database server needs to use minicomputer (Unix) on which to configure the adaptive server Enterprise for Unix to store the data, and to configure the replication server. Used in conjunction with the replication server in the provincial center to replicate data changes at the provincial center to the group headquarters. In order to implement the three-tier architecture application, an application server is required, which can be Unix or NT. The server is configured with Web server (Third-party products) and Enterprise Application Server (EA server). There can be many ways for a client to run the environment: it can be a browser, it can connect to a Web server, download an HTML page or Java applets to query or modify database information, and the EA server as a bridge between Web server and database server Can be a PowerBuilder application that is directly connected to the EA server, where all the application logic is run in the EA server as a component, while the PowerBuilder application is just a user interface to invoke these components and display the results; The traditional PowerBuilder client/server application can be developed, which is directly connected to the database server, which can be applied to some special applications, such as system maintenance. In the development environment, you can use Sybase's enterprise application Studio. It is a fully integrated enterprise application development package, including EA Server development, PowerBuilder, POWERJ, and so on, which can be used to easily and efficiently develop component-based three-tier architecture applications. In addition, the design and modeling of database can be done by using PowerDesigner.

In a provincial company, depending on the business situation, the database server can choose a minicomputer (Unix) or NT server on which to configure Adaptive server Enterprise for Unix or adaptive server Enterprise for NT, Used to store data, configure replication server to work with replication server at group headquarters to replicate data changes from the Province center to Group headquarters, and configure SQL remote to work with the city company's SQL remote. In order to copy the data changes of the city company to the provincial company. The application server, the operating environment, and the configuration of the development environment are exactly the same as the group headquarters.

In the city company, the database server selects the NT Server, configures the adaptive server Enterprise for NT or adaptive Server Anywhere to store the data, depending on the business situation and the fund situation; Configure SQL Remote, which is used to work with the provincial company's SQL remote to replicate the data changes of the city company to the provincial company, and to the county company's SQL remote to replicate the data changes of the counties to the local companies. The application server, the operating environment, and the configuration of the development environment are exactly the same as the group headquarters.

In a county company, the database server chooses an NT Server, configures Adaptive server Anywhere on it to store data, and configures SQL remote to work with the local city company's SQL remote to replicate the county company's data changes to the city company. The application server, the operating environment, and the configuration of the development environment are exactly the same as the group headquarters.

Group headquarter or provincial company Data Warehouse Solution

Because the group headquarters to bring together the business data of Sinopec nationwide, its scale is quite large. In particular, over time, these data will become more and more likely to reach GB or even terabytes. In this way, the query and analysis on this data can be very difficult, a statistical report may take several hours or even days, which requires a data warehouse system to solve these problems, speed up the query and statistical speed, and the data can be analyzed from multiple angles, This will enable the company to achieve more successful development by discovering valuable information from a large number of data.

Sybase's Data Warehousing Solution Warehouse Studio is a very good choice. It can be used for Data warehouse design, multiple data source integration, simple way to realize warehouse data management, data front-end display and management of the entire data Warehouse environment.