Shanghai Customs is a government agency for the General Administration of Customs in China. It oversees the surveillance and control of imports and exports through the Shanghai Free Trade Zone (SHFTZ), a group of four special administration areas, including Waigaoqiao free-trade zone and Waigaoqiao logistics park, Yangshan port area, and Pudong Airport. To support China’s first free-trade zone, Shanghai Customs introduced international-management best practices and measures to improve customs clearance, bonded goods supervision, enterprise management, and tax collection, including the payment of import tariffs required under customs law.
Shanghai Customs experienced rapid growth in SHFTZ’s customs activities due to the significant increase in re-export and off-shore trade and the expansion of customs duties and business rules. In response, it used Oracle Database 12c, Oracle Database In-Memory, Oracle TimesTen In-Memory Database, Oracle Real Application Clusters, Oracle Enterprise Manager 12c and Oracle Active Data Guard to build a new customs-surveillance and control-information platform that ensures efficient logistics operations and supports future trade growth.
With Oracle Database In-Memory’s dual-format architecture, the agency automatically routes OLTP transactions to the traditional row format and OLAP queries to Oracle’s new in-memory column format, expanding memory capacity and improving query performance. As a result, it eliminated the need to copy analytical data out of the OLTP environment into a data warehouse, thereby reducing system complexity and storage costs. Shanghai Customs now easily combines real-time analysis with real-time transaction processing on all existing customs surveillance and control applications, ensuring faster and more accurate decisions, and supporting trade growth in China.
In addition, Oracle Database In-Memory enabled existing Oracle Database-compatible applications to achieve in-memory performance without making changes to the applications. Shanghai Customs can also easily enable the in-memory option in Oracle Database by simply setting the size of the in-memory column store and selecting tables to bring into memory.
By storing transactional and analytical data in Oracle Database 12c and managing this data with Oracle Database In-Memory and Oracle Times-Ten In-Memory Database in the application tier, Shanghai Customs gained microsecond response times that enable it to improve data processing speed for verifying and clearing imported vehicles 43x faster and updating inventory-account 10x faster. This capability accelerated declaration services and improved logistics efficiency in dealing with the import, export, transfer, and storage of goods in SHFTZ. It also helped to reduce companies’ operating costs.
Finally, Shanghai Customs used Oracle Real Application Clusters and Oracle Active Data Guard to eliminate single point of failure, ensure high system availability, and enable zero data loss for Oracle Database. The agency also implemented Oracle Enterprise Manager 12c to centralize system management and maintenance for the new platform, reducing IT operational costs and providing a reliable foundation to support future migration to a cloud-based platform.