Real-time analysis, taxation by data｜The road to innovation of big data integration of Yantai tax

The key link in the construction of smart taxation is to comprehensively use artificial intelligence, distributed and other leading technologies in appropriate business scenarios to release the wisdom of big data and realize the " taxation ". Yantai Taxation Bureau builds a new generation of smart taxation platform based on the TiDB distributed database to meet the demand for massive, real-time data services , builds intelligent analysis and decision-making capabilities, and embarks on a road of demonstration of innovative applications of tax big data.

A gap that cannot be crossed by centralized

Taxation big data is an important foundation for smart taxation. In recent years, Yantai Taxation Bureau (hereinafter referred to as: Yantai Taxation) has strengthened the in-depth mining, intelligent analysis and integration and sharing of data resources, and made full use of artificial intelligence and big data technology to improve the level of taxation governance. With the massive growth of business data, the data of multiple large business tables has exceeded 100 million pieces. The original Oracle RAC-based database architecture has insufficient horizontal scalability. Correlation analysis between large tables usually takes 1-2 hours. Performance does not meet the business requirements of near real-time analysis.

The development team of Yantai Taxation built a series of smart tax administration, tax management and decision-making applications around the tax big data system, such as taxpayer profile, risk identification, process monitoring, etc. The business development side is based on the principle of fast launch and fast iteration. In addition to the core capabilities of the database, it is hoped that the database can be integrated with the original Hadoop big data stack, which is easy to develop and easy to operate and maintain.

Data-driven real-time scenarios become a trend

After multiple rounds of comparative testing and application compatibility verification, Yantai Tax introduced TiDB distributed database to build a new generation of smart tax data platform, which is used to carry business platform, data platform, tax dynamic monitoring large screen, AI query platform, etc. Core business system.

Yantai Tax has developed a pre-program to realize real-time synchronization of data from the provincial bureau’s Oracle production database to TiDB, providing unified and real-time intelligent data services for business middle stations, data middle stations and various business applications. In the actual scenario, the invoice information and the cargo information are separate large tables, and the data volume of each table is more than 100 million. If the association is based on the invoice number or the invoice date, it would take 1-2 hours to complete. Use TiDB distributed After the database can obtain the analysis and calculation results in seconds, the service efficiency has been improved exponentially.

It can be seen from the application of Yantai Taxation based on the TiDB distributed database that data-driven real-time scenarios have become a popular trend in the tax industry. The associated query of multiple tables under massive data and the presentation of real-time results have become an important means to release the wisdom of big data. In fact, for real-time processing of massive data, distributed HTAP databases are a better choice than traditional big data technology stacks and centralized databases. At present, the Yantai Municipal Taxation Bureau has established nearly 300 business reports and analysis models based on the TiDB distributed database, which has greatly improved the business capabilities and levels of tax management agencies at all levels in early warning, risk analysis, and management. The occurrence of tax-related cases has been greatly reduced, and the work efficiency and the ability to serve enterprises have been improved.

Use AI to support distributed database

Yantai Taxation has assembled AI experts, taxation business experts, and database experts to innovatively develop a Wanwei query platform, using AI semantic analysis for SQL statement conversion and modeling, and relying on the powerful real-time analysis capabilities of the TiDB distributed database to realize key tax businesses Visual presentation of indicators.

As long as you enter text in the search box of Wanwei query, such as "the current year's VAT storage status", you can display the real-time graphical report and analysis results of this indicator. The Wanwei query platform shields the threshold of database usage for the personnel of the business department. There is no need to understand SQL or type any codes. The tax staff can directly enter the text and return the real-time statistical report of the business in seconds, which is for the city's tax work. The personnel grasp the tax dynamics in real time and provide scientific data support.

In the future, Yantai Tax will further strengthen the in-depth application of artificial intelligence and distributed databases, combined with smart tax data platforms, to achieve rich decision support and application innovation in the fields of precise tax analysis, dynamic credit assessment, and tax risk early warning.

Application value of

Innovative architecture creates a solid base for big data

TiDB adopts a distributed architecture design with separation of computing and storage. can expand throughput or storage on demand by simply adding new nodes, which perfectly solves the single-point performance bottleneck problem of traditional databases . TiDB provides financial-grade high-availability guarantees, which can realize automatic recovery from failures.

Open ecology to simplify big data stack

TiDB uses a data platform to meet the needs of real-time transactions and real-time analysis scenarios, and can be integrated with Hadoop, Flink, Spark, Kafka and other big data ecosystems to provide unified data services for upper-level businesses, simplifying various data stacks while greatly saving manpower And maintenance costs.

Intelligent operation and maintenance without worries

TiDB supports standard SQL, which greatly reduces the complexity of sensitive application development and speeds up application launching. In addition, TiDB provides a flexible visual query interface for operation and maintenance personnel, making it possible for operations personnel to perform real-time analysis and real-time operations through SQL.

Now, TiDB's HTAP capabilities are not only used in high-tech scenarios such as the Internet, finance, retail, and logistics, but are also helping public service industries such as government affairs to innovate and complete digital transformation.