Summary
Supported API security, reporting performance, and summary-database maintenance through auth/encryption, ClickHouse, large-table sync, and scheduled updates.
Business Value
Improved API security, analytics performance, and summary-database maintenance for the operator platform.
Engineering Depth
Covers API auth/encryption, ClickHouse-backed large-scale querying, large-table sync, xxl-job scheduling, and cross-stack delivery.
Evidence
Manual review · Confidence High · Verified 2026-03-31
- Evidence level: strict review (core sections only show verifiable metrics)
- Source type: Manual cross-check
- Source link: no public link provided, review against delivery records
- Verified at: 2026-03-31 (78 days ago, fresh evidence)
Rationale: High confidence: organized under strict evidence rules, manually cross-checked, verified 78 days ago.
Background
联通数字化部需要同时支撑运营平台接口能力、数据中台建设和省市级汇总数据管理，系统既要能跑业务，也要能承载持续增长的数据规模。
Challenge
一方面活动查询接口耗时高、海量数据查询压力大；另一方面对外 API 安全、号码复通接口维护、汇总库动态更新和前后端协作也都需要同步推进。
Action and Results
Solution
- 接口与安全：改造对外 API，加入第二次授权认证，并对请求与响应做初步加解密处理。
- 性能与存储：优化活动查询接口，将响应时间从
20s+ 降到约 4s；使用 ClickHouse 替代 MySQL 承载海量数据查询。 - 数据平台：完成
300+ 张百万级数据表同步，并将数千万条数据迁移到汇总库。 - 持续更新与交付：使用
xxl-job 驱动汇总库每日动态更新，同时开发能力管理页面和相关前后端逻辑。
Result
联通运营相关系统在接口安全、查询性能和数据汇总更新上都得到明显改善，部分海量查询达到毫秒级，汇总库具备稳定的日更能力。
Key Signals
Improved reporting APIs from about 20s to 4s. Used ClickHouse to carry large-scale analytics queries. Synced 300+ million-row tables and scheduled daily summary updates. Tech Stack
JavaClickHouseMySQLxxl-jobAPI SecurityData MigrationPerformance TuningResponsive Web