Microsoft sets up large data platform for China Customs to increase import and export trade volume

In recent time, a foreign trade enterprise in Guangdong, Mr. Song, obviously feel that the local customs Department for the clearance of goods time shortened a lot of customs window Declaration business efficiency significantly improved. Like Mr Song, it is the Chinese customs staff who feel most strongly about this change. And all this change behind, depends on is the national Customs Dynamic Data Warehouse platform, with the latest cloud computing concept, for the customs to provide flexible, dynamic, efficient, manageable it and data services.

has 46 direct customs units (Guangdong branch Office, Tianjin, Shanghai, 41 direct Customs, 2 Customs institutions, 600 affiliated with the customs and offices, customs clearance supervision Point nearly 4,000 of the People's Republic of China, trillions of import and export logistics control and complex types of business, are inseparable from the support of information. Subject to the geographical position of the immediate institutions, the different modes of goods transportation and the clearance of goods, the diversification of users ' needs makes the Chinese customs realize that the drawbacks of early distributed database deployment methods begin to appear: The Data warehouse lacks the ability of grading processing, and cannot be processed automatically according to the priority of the report. This will directly affect the speed of data processing, resulting in reduced efficiency.

Change, the potential in the inevitable. Realize the centralized deployment of cloud data center, become the first task of Chinese customs to conquer information barrier. To this end, the China Customs Dynamic Data Warehouse project group decided to redesign and plan the national Customs Dynamic Data Warehouse platform, the introduction of the latest cloud computing concept, to provide the customs with flexible, dynamic, efficient, manageable it and data services.

Cloud-based Microsoft Cloud data platform Windows Server 2012 has entered the project team line of sight. China's customs has set up data centers in Beijing, Shanghai and Guangzhou, and the direct agencies of the Customs and Excise Department connect IT systems with the data center with the nearest principle. The underlying infrastructure in each data center is built using Windows Server 2012 Cloud operating systems, integrating the computing power of all hardware devices into a resource pool through Microsoft's latest Hyper-V 3.0 Server virtualization technology, It provides flexible and efficient support for upper level data platform and application. Overall management of the infrastructure through system Center 2012, including the allocation of virtual machines, cloud management, and application monitoring.

On a new customs Data Warehouse cloud platform, a complex query that needs to execute more than 4 hours previously was required to return results on SQL Server PDW (Parallel data Warehouse) in 2 seconds. The original most time-consuming background data cleaning transformation Import ETL jobs need to run 5-6 hours, on SQL Server PDW only 1 minutes and 42 seconds to complete. Relying on the cloud computing platform provided by Windows Server 2012 and the High-performance Data Warehouse brought by SQL Server PDW, the Customs Integrated Management business platform provides a variety of data processing functions such as ad hoc queries, fixed queries, multidimensional Analysis, report metrics, and more.

Cloud computing and High-performance, but also allow the customs departments of efficient linkage approval possible. Now, the business person can through the index analysis in almost real time to discover the risk point in the business, can immediately by sending the contact Disposition list, requests the corresponding department to dispose. greatly enhance the efficiency of customs treatment, and for the future development of information technology to lay a solid foundation.

The People's Republic of China customs Dynamic Data Warehouse engineering Group A person in charge said: "Data processing is a very important ability." Before the customs data are dispersed by various departments, and we want to find a solution to the data and build a system to enhance the overall customs data processing capacity. Microsoft's Windows Server 2012 private cloud platform, coupled with the latest SQL Server 2012 data platform, precisely meets our flexibility, manageability, and cost-effectiveness requirements, using Microsoft's solution to build a Dynamic Data warehouse, It can classify the business requirements of the units under the customs, so as to realize the optimal allocation of resources and realize the overall promotion of the work efficiency. ”

If investment it, using Microsoft's new SQL Server 2012 data platform, so that representative of the country's image of the Chinese customs, and the regular dealings with customs of the Mediterranean shipping companies rely on Microsoft SQL Server 2012 to help companies improve speed, control capacity, cost savings, To further expand the company's business.

The Mediterranean Shipping company has been working closely with Microsoft for a long time in how to provide continuous uninterrupted data access at low cost, to ensure that the core business of the enterprise is unaffected and to build an integrated high-availability disaster recovery solution. By using SQL Server 2012,msc, you can achieve faster growth with faster data access, minimized downtime, better security, and lower costs. The SQL Server AlwaysOn feature provides an integrated high-availability and disaster recovery solution that delivers continuous uninterrupted data access and higher performance at lower cost. Fabio Catassi, chief technology officer for the Mediterranean Shipping company, says that by using SQL Server 2012, companies can achieve faster growth with faster data access, minimized downtime, better security, and lower costs.

The value of Microsoft's cloud data platform to the Chinese customs is benefiting more Chinese import and export trade enterprises, the Mediterranean shipping from 16 ago in the industry ranked 20, developed to today in accordance with the number of ships and container number of the second largest transport operators. Today, with a flexible, intelligent, with the latest cloud technology, Microsoft Cloud data platform, bring the value of the customer continues.

(Responsible editor: The good of the Legacy)