The design of relational database and NoSQL database in travel agency database system

Abstract

The information management systems of travel companies are experiencing greater challenges and expectations as a result of the tourism industrys rapid growth and travellers rising demand for personalized and interactive experiences. This paper aims to study the customer management system of travel agencies, taking into full consideration the characteristics and development trends of the tourism industry. Traditional customer management system uses relational database for data storage and related operations, which cannot fully meet the needs of customers and complex data in the new era. By analysing and comparing relational databases and NoSQL databases, according to their own advantages, a combined solution is proposed, which uses relational databases to store structured data and NoSQL databases to store unstructured data. On the basis of maintaining the original system management function, this solution greatly enhances the storage and processing of interactive data such as images and videos, and better meets the new demand of travel agency customers for sharing and interactive communication.