Case Study: Shanghai Customs achieves 43x faster clearance and streamlined declaration services with Oracle Database In-Memory

Shanghai Customs Processes Clearance 43x Faster, Improves Declaration-Services Efficiency and Reduces Costs with In-Memory Database

Shanghai Customs, the General Administration of Customs agency for the Shanghai Free Trade Zone (SHFTZ), faced rapidly growing import/export activity, increasing re-exports and off-shore trade, and more complex duties and business rules that strained its clearance, surveillance and declaration processes. The agency needed a faster, more scalable platform to improve throughput, accuracy and operational efficiency across customs supervision, bonded goods management and tariff collection.

Shanghai Customs deployed Oracle Database 12c with Oracle Database In-Memory, Oracle TimesTen, Real Application Clusters, Active Data Guard and Enterprise Manager to run OLTP and OLAP workloads in-memory without separate data copies. The dual-format architecture delivered microsecond response times—cutting vehicle verification and clearance time by 43x and speeding inventory accounting 10x—while reducing system complexity and storage costs, improving declaration services and logistics efficiency, ensuring high availability and zero data loss, and enabling a 3-month go-live and future cloud readiness.

Shanghai Customs