Sybase Huaring Computer Information Management solution

Development background

Chain supermarkets started in the early 90 's, now has become an important form of the national retailer industry. With the rapid development of chain supermarkets, its management becomes more and more complex, day-to-day processing of the data is gradually huge, commercial operation of the intermediate links are more and more, the original relying mainly on manual management and simple Computer Management methods, obviously has been unable to adapt to the continuous expansion of the supermarket scale. In view of this situation, Shanghai Hualian Supermarket Co., Ltd. decided to develop a computer information management system, its supermarket chain three main links: stores, distribution centers, supermarket headquarters organic networking, implementation of a comprehensive computer management to achieve logistics, information flow, capital flow three-flow integrated management.

The huge information management system is strict with the background database supporting its operation, it must have fast response and efficient processing ability for large data, mixed workload, stable performance and safe and reliable. After many choices and careful consideration, Huaring company finally chose Sybase's database System management platform solution.

System Requirements

Huaring Computer Information Management system is a complex comprehensive information management platform, its main construction scope includes the Hualian Headquarters information Management system, the distribution Center information management system, the store (market) information management system and the financial information management system and so on four key information systems design, the establishment and the interconnection. It is based on basic information, logistics, information flow and capital flow as the main line, and combine these three organically, in order to truly achieve the architecture in the WAN and LAN above the online transaction processing (OLTP).

The database system is the core component of Hualian information management system, which mainly solves the accounting and management, the transmission of production data, the extraction and analysis of management data, the management of archives data, the centralized maintenance of the basic information, and the data information of different sources is stored in the database, which facilitates the use of each business system

According to the actual needs and a series of characteristics of the construction of the Hualian information management system, the database system selected by it must meet the following basic requirements:

Rapid response and efficient processing capability for large data volumes

Good mixed load support capability

should be able to support the interconnection of heterogeneous databases

High level of security and reliability, providing continuous availability of the database

Efficient bidirectional replication capability

should be able to integrate existing application systems to effectively protect the original investment of enterprises

Sybase Solutions

Huaring Computer Information Management system is a large regional network, and with the development of Hualian business, its data volume will continue to grow, so the system design should reflect the full friendliness, practicality, security, scalability, advanced and open, and many other characteristics.

Sybase based on the actual needs and future applications of Huaring Computer information Management system, the paper puts forward a complete solution of database system management platform. Its overall configuration points are as follows:

The whole system adopts centralized and open client/server architecture, distributed storage, centralized management, can complete various operations accurately, quickly and in real time, achieve efficient online transaction processing (OLTP) and online analytical processing (OLAP).

Using a variety of advanced technology means, including Internet Information management technology, powerful transaction processing server, open heterogeneous database interconnection interface.

It can realize dual-computer backup, and automatically switch when abnormal, in order to guarantee the continuous availability of database and data security.

It can maintain and tune the database system in real time to ensure the smooth operation of the database system.

With the ability to optimize mixed workloads, Sybase can efficiently optimize the mixed workload through the logical memory Manager, logical Process Manager, and resource controller to meet the growing number of users and the needs of enterprise applications.

The Sybase configuration scheme has the following core advantages

In data management, Sybase Adaptive Server Enterprise (ASE) is a highly performance database server product in many RDBMS (relational database management systems) today, supporting traditional, mission-critical OLTP (online transaction processing) and DSS ( Decision support systems, which can also support Internet applications, and provide database productivity, availability, and integration.

In data replication, Sybase Replication server has breached the constraints of distributed databases, providing a very flexible system framework for real business requirements based on transactional replication (with many advantages over data-based replication); It provides extremely high OLTP performance, enables bidirectional replication of heterogeneous data sources (up to 25 types of data sources), and avoids conflicts between OLTP and DSS operations.

In the field of distributed applications, Sybase can develop the distributed applications of multilevel architectures through OpenServer or PowerBuilder. In this architecture, the database server, application server, various applications can be based on different hardware and software platform, improve the flexibility and scalability of the system performance.

In the custom server realm, Sybase is the only database vendor that provides an open server-side programming interface, which provides the possibility for users to write custom-enabled servers with standard Openclient/openserver protocols and transparently access Sybase environments.

System Application Effect

At present, Huaring information management system runs about 20,000 pieces of single goods, 50,000 different packaging specifications, the system runs well. The successful implementation of the Huaring information management system has significantly improved the communication and operational efficiency of supermarkets, distribution centers and Headquarters, and has realized basic information, price management, purchasing business, distribution management, warehouse management of distribution center, headquarter financial management, store management, Shopping malls financial management and POS sales of the nine key links of the overall electronic, greatly improve the management efficiency, save the operating costs, thus expanding the Huaring profit space and significantly enhance the Huaring overall market competitiveness. In view of the rapid response and efficient processing capabilities of the Sybase database system to large data volumes, as well as its outstanding productivity, availability and integration, Huaring company said that Sybase's efficient and reliable database management system will continue to be used in the two-phase project construction of the Huaring information management system.