The successful application of Sybase database in tax department

I. Current status of domestic tax collection and management

As an important part of a country's tax system, tax collection and management has a very important position, it needs to identify potential taxpayers, approve their taxable amount and collect them in full in time. In order to ensure the smooth implementation of tax collection, the tax department must improve its own organizational work and improve the service to taxpayers. In these respects, China's tax collection and management has gone through an extraordinary road. For a long time, the domestic tax collection and management mainly using manual mode, even equipped with a computer is also used for simple data entry, resulting in China's tax collection and management is not satisfactory, the specific performance in:

(1) Management difficulty is big. Tax collection, the determination of taxes and collection and management audit mostly rely on manual completion, the tax source plugging the work of large.

(2) High tax cost. The imposition of taxes also generates costs, which include the imposition of costs and tax costs. Due to the lack of electronic tax collection procedures, it has caused a large number of man-made costs, mainly in the process of manual activities of personnel costs. Moreover, cumbersome tax procedures have virtually increased the cost of taxpayers, including time and energy costs, thus seriously affecting the taxpayer's consciousness.

The 1994 tax system reform has brought huge opportunity for China's tax collection management, because the tax collection and administration is the concrete execution of the tax policy under the established tax structure condition. Our country has carried out the national tax, the local rent two sets of taxation system, the tax and the collection scope has the big change. In order to ensure that the goal of tax reform is successfully achieved, the tax administration model needs to implement the corresponding transformation. Adopt completely electronic tax collection and management system. But the current situation of China's electronic taxation is not optimistic. Take the national tax system as an example, its system coverage, the application environment is more complex, network stability requirements, but its network construction started late, staff quality urgent to improve. And the complexity of the collection and management is also one of the severe challenges to the implementation of the electronic process.

II. requirements of China's tax collection and management Information System (CTAIS)

China's State administration of taxation is vigorously popularizing China's tax collection and management information system. As the national tax system, its collection and management process contains many functions, such as collection, inspection, trial, implementation, and so on, so it needs to link these procedures in an orderly manner, and realize the electronic functions of these. The realization of this function is not easy, because there are many hidden troubles in the whole process electronic attempt, such as the specification and confirmation of tax declaration. Secondly, the goal of electronic tax collection and management is to achieve standardization, the standard of the collection of administrative process is the implementation of tax reform in China is an important goal. Its realization needs a perfect, strong management system support. In this system, the application of database is very important. The database selection must be able to meet the requirements of the national tax system on a full range of databases, and can reduce the need for database expertise, so that not enough technical experience of tax workers do not need to spend too much time to complete the day-to-day processing process. This is a special requirement of China's tax collection and management information system. In view of this, the tax authorities for the tax collection management system for the database bidding, and finally Sybase in the competition with Oracle, Informix and IBM, with superior functionality, powerful development tools, obvious price advantages and perfect service to become the Ctais selected database applications.

Third, the database project design

The State administration of taxation of China has pioneered the use of Sybase database in Haikou, Xiangtan and other Ctais. Haikou The IRS uses a "distributed collection, unified processing, centralized storage" of the Computer wide area network, built to 2 small machines, 3 PC servers as the center, with 6 dedicated lines for the communication skeleton, with 160 pc as the terminal real-time urban-level centralized WAN, and complete the IP address distribution within the station. Its overall structure is to s7a medium-sized server, F50 minicomputer server, computer server, CISC05500 Center switch, CISCO4000 Center router as the center of the stable, smooth tax collection computer wide area network. The database is based on the Sybase ASE (Adaptive Server Enterprise) product. The database has all the features of a large database engine and can provide strong support for the IRS's day-to-day business processes.

ASE, especially for the database system optimized data storage design, not only for online transaction processing and decision support to provide a high performance, but also fully consider when the database for internet/intranet, there are many unpredictable factors, and to do a unique design, To meet the requirements of the full range database required by the Tax Administration department. For the Internal Revenue Bureau business process, the database in the specific process set up a variety of triggers, will be conducive to promote the IRS tax declaration, tax collection, reminder management, collection management and other processes smoothly.

In the implementation process, Sybase's ASE database has the following characteristics:

1. Optimization of mixed workloads--ase internal logical memory Manager (Logical Memory Manager) allows users to set data caching to improve system performance. The data cache contains some objects that have just been accessed, such as tables, logs, and indexes, which allow users to divide the entire data buffer into LMM, independent buffers, and to name the buffer, called a named cache, in which the user can bundle the database object or the entire database with the named cache. ASE's logical Processing manager (Logical Process Manager) allows users to assign a certain level of operation to all objects, and priority objects are executed first.

2. Internal parallel technologies, including parallel queries, parallel sorting, and parallel utilities, can be used to optimize the SMP environment-multiple threads and engines are used to execute a single query to improve response speed. The completion of a parallel query is 15 times times faster than the same serial query. By using parallel technology, the parallel optimizer achieves the fastest response time.

3. High data reliability, integrity, and effectiveness--sybase is the only DBMS vendor to obtain ISO9001 certification, and on this basis, a adaptive Server Enterprise that conforms to the ISO9001 specification is established. ASE ensures the high availability of user data. Full online transaction processing includes automatic roll back and roll forward recovery. Disk mirroring, automatic error Crossing (Fail-over), and high-speed backup/restore capabilities minimize the impact of hardware failures on running applications.

4. Simple installation, operation, and management--ase eases the task of installing, configuring servers, and client software through a graphical setup program. Sybase-S is an easy-to-use GUI management tool that helps manage users, replication environments, security, and storage. It gives users the ability to initialize database backup and restore, maintain log files, configure, start, and terminate servers, check database consistency and view server statistics, execute queries, and pass data between databases.

5. Open application interfaces and tool support capabilities--ase supports ODBC, JDBC, SYBASE openclient, and Embedded SQL to perform high-performance data access on all supported platforms.

6. Powerful security features--as the first database server software vendor under the client/server architecture, Sybase considered the network issue from the outset, paying special attention to the relevant standards, such as the Open Software Foundation OSF (open Software Foundation), which have been developed and recommended, such as the Distributed Computing environment DCE (distributed Computing Environment) framework. ASE supports the business naming service through the directory control Layer DCL, which enables customers, servers to locate, and to identify the network services provided by the commercial Naming Service (Layer).