Design Methodology Integrating Knowledge Graphs and Relational Databases for the Xinjiang Smart Tourism WebGIS System

The rapid advancement of internet technology has transformed the tourism industry from traditional offline services to digital networked, and intelligent platforms. WebGIS has become critical infrastructure for tourism information retrieval and spatial decision-making. However, the growing volume and heterogeneity of multi-source tourism data expose fundamental limitations in conventional relational database architectures, particularly in handling complex spatial semantic queries. To address this, the present study proposes a WebGIS design methodology that integrates knowledge graphs with relational databases through a dual-database collaborative architecture. Using tourist attraction data from China’s Xinjiang Uyghur Autonomous Region as a case study, a prototype Xinjiang Smart Tourism WebGIS system was constructed, which consists of an asynchronous synchronization mechanism based on Change Data Capture (CDC) to ensure data consistency across heterogeneous databases. Subsequently, tourism semantic queries of varying depths were constructed and comprehensively tested across different data scales. The experimental results indicate that the proposed methodology effectively decouples business transactions and supports complex relationship computations, achieving shorter cross-domain semantic query times and higher latency stability. These findings offer practical guidance for designing high-performance regional tourism information services.