chrispeng [ad_1]
1. Project background
At present, with the development of the market economy, more and more large-scale enterprises operating across cities and provinces have emerged, including retail companies, commodity manufacturers, channel companies, and logistics companies. These companies have a large number of branches and are in a period of rapid expansion, requiring real-time, accurate and complete business data management. Helping these companies achieve timely and complete business data management is of great significance to enhancing their competitiveness. Many places cannot use computer terminals due to communication line problems, which makes real-time data collection only concentrated in some large shopping malls and places with fixed stores, but in other small hotels, supermarkets, restaurants, exhibitions, etc. Due to the limitation of venues and wired communication lines, computer terminals with wired access methods cannot be deployed, so that enterprises lose real-time data collection and control of business terminals, resulting in a time lag in obtaining management data, which affects the company’s Real-time control and resource allocation of sales network.
A company has nearly 500 mobile sales points in the country, and each sales point must regularly summarize sales data to the headquarters every day, including: the total sales volume of a certain product on the day, and each sales terminal submits the data to the headquarters through the telephone line. Because the ISDN telephone line dial-up method is used to transmit data, the data can only be transmitted once a day at a fixed time, and the real-time performance is poor, and the headquarters management personnel cannot inquire various data of the sales terminal in real time through the network. Due to the large number of sales terminals, the cost is not cheap.
In order to cope with the increasingly fierce market competition, shorten the market response time, make market decisions quickly and accurately, and improve competitiveness, large commercial enterprises need to accurately grasp the sales of each retail point anytime, anywhere, and prepare for both production and inventory. It can keep up with the sales of retail outlets without excessive inventory, so as to reduce inventory and save costs. Due to the poor real-time performance and low efficiency of this data collection and transmission method currently used, it has not been able to meet the needs of users well. The real-time sales data collection system enables the headquarters to quickly grasp the sales and inventory data of the sales terminal, and make reasonable plans for production, sales, inventory, and distribution in a timely manner.
As a result, Beijing Uniwit Technology Co., Ltd. (Uniwit), based on advanced automatic identification technology combined with wireless network WIFI/GPRS technology, fully integrates mobile intelligent data collection terminals with traditional invoicing software, and realizes the integration of sales data and purchases. Real-time data and inventory data are used to achieve real-time business linkage between departments and seamless data sharing.
620)this.style.width=620;” border=0>
Two, noun explanation
1. C/S mode: C/S (Client/Server) structure, that is, the well-known client and server structure. It is a software system architecture, through which it can make full use of the advantages of the hardware environment at both ends, and allocate tasks to the Client and Server in a reasonable manner. This reduces the communication overhead of the system.At present, most application software systems are a two-tier structure in the form of Client/Server
2. B/S mode: Browser/Server (browser/server) structure, which is a change or improvement of the C/S structure with the rise of Internet technology. Under this structure, the user interface is completely implemented through the WWW browser, and part of the transaction logic is implemented on the front end, but the main transaction logic is implemented on the server side, forming a so-called 3-tier structure. The B/S structure mainly uses the ever-maturing WWW browser technology, combined with the browser’s multiple Script languages (VBScript, JavaScript…) and ActiveX technology, and uses a general-purpose browser to realize the original need for complex special software. Powerful functions, and save development costs, is a brand-new software system construction technology. With Windows 98/Windows 2000 implanting browser technology inside the operating system, this structure has become the preferred architecture for today’s application software.
3. GPRS: GPRS (General Packet Radio Service) is a data transmission technology based on the Global Mobile Phone System (GSM), which can be said to be a continuation of GSM. GPRS is different from the previous continuous channel transmission method. It is transmitted in a packet (Packet) mode. Therefore, the user’s cost is calculated in the unit of transmission data instead of using the entire channel. It is theoretically cheaper.
4. Data acquisition terminal: the data acquisition device of the real-time system, which runs the client program to realize the functions of real-time data acquisition and real-time transmission.
3. Advantages of GPRS data transmission scheme
After comparative analysis, we chose China Mobile’s GPRS system as the data communication platform for the commercial real-time data acquisition system. China Mobile’s GPRS system can provide wide-area wireless IP connections. Building a commercial real-time data collection system on the GPRS service platform of a mobile communication company to realize wireless transmission of sales terminal sales data has the advantages of making full use of the existing network, shortening the construction period, and reducing the construction cost, and the equipment is easy to install and easy to maintain.
1. Coverage. The construction of a commercial real-time data collection system requires a wide range of data communications, unlimited expansion, and unlimited access locations, which can meet the access needs of mountainous areas, towns, and cross-regions. Due to the large number of sales terminals distributed across provinces, some sales terminals are located in remote areas and geographically dispersed. In addition, the possibility of future system expansion must also be considered, and it must have good scalability. Since GPRS has covered most areas in the country, it can meet the requirements of commercial real-time data acquisition systems for coverage.
2. The data transmission rate is high. At present, the actual data transmission rate of GPRS is around 40Kbps, which can fully meet the data transmission rate requirements of this system.
3. The transmission capacity of the system is large. The headquarters must connect with each sales terminal in real time. Due to the large number of sales terminals, the system requirements can meet the needs of bursty data transmission, and GPRS technology can well meet the needs of bursty data transmission.
4. The communication cost is low. The monthly billing method is adopted, and the operating cost is low.
5. Good real-time response and processing capabilities. Compared with short message service, because GPRS has real-time online characteristics, the system has no time delay, which can well meet the real-time requirements of the system for data collection and transmission.
The use of GPRS to build a commercial real-time data collection system not only satisfies the needs of sales data collection, but also mobile communication companies as network operators will also obtain group users with stable business. As the number of users increases, mobile The revenue of communication companies has also increased, mobilizing the enthusiasm of operators, and meeting the requirements of simultaneous development of network construction and network applications.
For large-scale commercial and retail users, because of the lower communication costs, they enjoy substantial benefits. In addition, because the access equipment can be moved, the equipment can be moved and can continue to be used when the sales terminal is relocated, which can protect the user’s original investment and is suitable for the characteristics of commercial and retail industries.
Four, system characteristics
1. Security
The GPRS system has extremely high system security and stability: security is mainly to prevent intentional and unintentional damage from inside and outside the system. Network security protection measures include channel encryption, source encryption, login protection, access protection, and access protection , Firewall, etc. The data center can use VPN to access the mobile GPRS network through the public network. The cost of using the VPN method is relatively low. The enterprise does not need to rent a dedicated line, but can also use the original VPN equipment. The mobile terminal needs to install the function of VPN secondary virtual dialing. Software. Through the VPN method, the client must be authenticated by the server before connecting to the application server. The entire data transmission process has been encrypted and protected, and the security is relatively high, which can fully guarantee the speed and network service quality.
(1) VPN virtual private network mode: VPN server is configured in the internal network of the enterprise, and VPN security technology is adopted. The user is isolated from the Internet by accessing the internal virtual private network of the enterprise, and the entire data transmission process can be encrypted and protected, effectively avoiding Illegal invasion.
(2) Use the uniqueness of the SIM card to authenticate and authorize the mobile phone number of the SIM card of the sales terminal, bind the SIM card number, and delimit the range that can be connected to a certain system. Only the mobile phone number of the designated SIM card can be accessed. The SIM card number of the mobile phone cannot be connected to the company database.
(3) Data encryption: Encrypt and protect the entire data transmission process through VPN.
(4) Security authentication mechanism: firewall software is used to set up network authentication and security protection functions to ensure system security.
2. Economical and practical
This system can be designed to meet the mobile office needs of customers and the needs of adapting to various office environments. The scalability of the system ensures that the system can add new office terminals flexibly and conveniently.
3. Advancement and maturity
The advancement of the application software of this system is mainly guaranteed by the advancement of software and hardware platforms, software and hardware products and auxiliary design tools, as well as advancement in design ideas and advancement in software functions.
4. Reliability
In terms of system structure, technical measures, equipment performance, system management, manufacturer’s technical support and maintenance capabilities, the reliability and stability of system operation are ensured to achieve the characteristics of real-time data transmission and strong confidentiality of data transmission.
5. Openness and scalability
The real-time system has good scalability. In the early stage of system construction, the system is first configured based on the recent application requirements and a basic service platform system is provided. The scalability of the system can ensure future development needs. The system adopts a structured and modular design, which is easy to update, expand and upgrade. The function of the system should meet the needs of current business processing, and fully consider the continuous growth of business types and the growing needs of users in the future.
6. Maintainability
The maintainability of the real-time system is embodied in the comprehensibility, testability, and modifiability of application software design, which is an important system attribute to protect customer investment.
Improving the maintainability of system application software requires scientific analysis of requirements and changes in requirements, unified overall planning, rational design of application architecture, correct selection of mainstream development and operating software and hardware platforms, correct selection of computer-aided design development tools, and strict organization of applications Standardized development of software, etc.
7. Standardization
The construction of the real-time system follows the relevant national standards and universal standards, conforms to the goals and directions of the development of information technology, conforms to the technological development trend, and has good interconnectivity with other systems.
Five, implementation description
1. Construction ideas
Adhering to the principle of “demand-oriented, practical results, overall planning, step-by-step implementation, perfect mechanism, resource sharing, security and confidentiality”, the overall construction idea of real-time system construction is summarized, and the overall idea framework of the project is in accordance with the law of the life cycle of the project It can be divided into four stages:
(1) Business analysis stage
At this stage, it is necessary to conduct a comprehensive summary and analysis of the existing systems that have been successfully operated, and adopt a combination of multiple channels to find out the comprehensive and true user needs as much as possible.
(2) Overall structure design stage
Through the summary and analysis of the business model, we can extract the requirements of the project, which clarifies the construction content of the project. We adopt a hierarchical design idea to decompose complex issues and simplify them, thereby abstracting the construction framework of the system. The framework will involve the access layer, application layer, service layer, data layer and basic environment layer. Each layer is independent of each other for easy management, and at the same time there are interfaces for interconnection.
(3) Detailed design and realization stage
At this stage, it is necessary to handle the relationship between inheritance and development, unified requirements and independent innovation, build an application support platform, adopt standardized component technology, integrate the original resources, and achieve sharing, so as to save system design and development costs , At the same time, the system architecture has good scalability.
(4) Implementation and service stage
The construction of infrastructure is the prerequisite and guarantee for the stable operation of the system. It involves infrastructure, data collection terminals, servers, storage devices, system software, client software, etc. When selecting a specific model, scientific decision-making is required and starting from reality. , Taking into account the future.
2. System environment design
Data collection terminal: 5-100 (pcs)
Background software: 1 (set)
SIM card: 5-100 (pcs)
Client software: 5-100 (authorized)
3. System structure design
The real-time system is mainly composed of data collection terminal, database server, firewall, system management software and other parts.
4. Mobile data collection terminal (Mobile Computer)
Undertake data collection and real-time transmission functions
620)this.style.width=620;” border=0>
620)this.style.width=620;” border=0>
Mobile data collection terminal specifications and parameters:
620)this.style.width=620;” border=0>
620)this.style.width=620;” border=0>
5. Management background (B/S invoicing platform)
(1) Adopt an advanced three-tier system, including: presentation layer, business logic layer, data core layer (including: data connection layer and data layer).
(2) The user terminal adopts the zero client mode, and accesses through the WEB browser.
(3) This system uses J2EE technology to achieve high performance, high scalability, and cross-platform.
(4) Adopt open, cross-platform technology, support multiple operating systems, such as WINDOWS/LINUX/UNIX, etc.
(5) The data collection terminal uses the TCP/IP protocol to connect to the corresponding server side, and the corresponding server side operates the same database of the system in order to maintain the business data of purchase, sale and storage together.
620)this.style.width=620;” border=0>
6. Database server (MySQL)
MySQL is a small relational database management system, developed by the Swedish company MySQL AB. At present, MySQL is widely used in small and medium-sized websites on the Internet. Due to its small size, high speed, and low total cost of ownership, especially the feature of open source, many small and medium-sized websites choose MySQL as their website database in order to reduce the total cost of website ownership.
620)this.style.width=620;” border=0>
Features of MySQL:
1. Written in C and C++, and tested with a variety of compilers to ensure the portability of the source code
2. Support AIX, FreeBSD, HP-UX, Linux, Mac OS, Novell Netware, OpenBSD, OS/2 Wrap, Solaris, Windows and other operating systems
3. Provide API for multiple programming languages. These programming languages include C, C++, Eiffel, Java, Perl, PHP, Python, Ruby, Tcl, etc.
4. Support multi-threading, make full use of CPU resources
5. Optimized SQL query algorithm, effectively improve query speed
6. It can be used as a separate application in the client server network environment, and can also be embedded in other software as a library to provide multi-language support, common encodings such as Chinese GB 2312, BIG5, Japanese Shift_JIS Etc. can be used as data table name and data column name
7. Provide multiple database connection methods such as TCP/IP, ODBC and JDBC
8. Provide management tools for managing, checking, and optimizing database operations
9. Can handle large databases with tens of millions of records
6. Project summary
This solution is customized and developed by Beijing Shulian Borui Technology Co., Ltd. and its partners. There are many omissions. We apologize for the inconvenience caused by this. At the same time, we also welcome you with great sincerity. Give valuable opinions on our work.
For more details, please contact Beijing Uniwit Technology Co., Ltd. (Uniwit)
TEL: 010-51528230-80
FAX: 010-51528291-88
Mail:[email protected]
Web:www.uniwit.com.cn
Add: Room 707, Longguan Building, Huilongguan, Changping District, Beijing (102208)
[ad_2]
