Method and system for processing airport missing broadcast voice fragment data
Through the automatic comparison and synthesis of missing voice clips in the voice clip generation system, the problems of manual entry and passive discovery in civil aviation airports are solved, the intelligent processing of voice clips is realized, and the operation efficiency of the broadcast system and the quality of passenger service is improved.
Patent Information
- Application Number
- CN202510459843.6
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-04-14
- Publication Date
- 2025-08-12
AI Technical Summary
In the existing civil aviation airport broadcast system, voice clips need to be manually entered and discovered when they are missing, resulting in high demand for fixed operators, lack of initiative and prevention, and affecting the quality of passenger service.
The voice clip generation system is used to automatically compare the voice clips of the integrated system database and broadcast system through the Cx_Oracle database and FTP protocol, and use Pyttsx3 voice synthesis technology to generate missing clips, and upload them to the broadcast system through FTP, and prompt staff with Windows pop-up windows.
Active discovery and automatic supplementation of missing voice clips is achieved, work efficiency is improved, manual repetitive workload is reduced, and passenger experience and airport service quality is improved.
Smart Images

Figure CN120474653A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of informatization and speech synthesis of broadcasting systems in civil aviation airports, and in particular to a method and system for processing data of missing broadcasting speech segments in airports. Background Art
[0002] Most large civil aviation airport terminals have numerous boarding gates and check-in counters, so passengers often have trouble locating their gates and receiving timely flight information. Therefore, informing passengers of flight information, such as the names of the departure and destination airports, is crucial for improving airport services. This is the key reason why most airport PA systems are currently in production.
[0003] When broadcasting flight-related information through the terminal's PA system, the required voice clips are often manually entered one by one. This means the operator speaks the required voice clips into a microphone, saves them as audio files with a specified bandwidth and frequency, and uploads them to the system. The PA system then intelligently synthesizes them for broadcast within the terminal. For civil airport PA systems, operators must have a certain level of Mandarin proficiency, and broadcasters must be standardized to ensure consistent voice reporting. If a voice clip required for the synthesized broadcast is missing, the operator must promptly re-record the missing segment.
[0004] The main challenges with current public address systems at civil aviation airports lie in their rigid operator requirements and the long-standing passive problem detection model. When audio is missing, terminal staff must promptly identify key missing information and alert the operator, allowing the missing audio clip to be added. This lacks proactive and preventative problem detection and remediation. Furthermore, if an operator leaves or transfers, the new audio clip may be inconsistent with the existing one, necessitating a complete re-recording or replacement of an operator with a similar voice. Furthermore, when terminal staff fail to promptly detect missing audio clips, passenger service quality deteriorates, preventing passengers from receiving timely flight information, potentially leading to missed flights and complaints to the airport. Furthermore, due to the bandwidth and frequency requirements of existing public address systems, existing commercial software is difficult to replace. Summary of the Invention
[0005] The purpose of the present invention is to provide a method for processing data of missing airport broadcast voice segments, which solves the main problems existing in the prior art, such as the need for manual entry and manual uploading of voice segments, the fixed requirements of operators, and the passive discovery of missing voice segments. It realizes technical innovations such as intelligent and automatic comparison to discover missing voice segments, timely issuing reminders to inform operators, automatically synthesizing missing civil aviation airport name voice segments into audio files of specified bandwidth and frequency, and automatically uploading them to the broadcast system, so that the broadcast system can timely supplement voice segments to ensure continuous high availability of passenger services.
[0006] The present invention provides a method for processing airport missing broadcast voice segment data, the method comprising the following steps: A method for processing missing airport broadcast voice segment data, the method steps are as follows: Step 1: The voice clip generation system traverses the integrated system database to obtain a set An of three-character codes and Chinese names of all airports; and traverses the broadcast system to obtain a set Bn of broadcast voice clip files of all airports; Step 2: Each three-character airport code in the set An of airport three-character codes and airport Chinese names of all airports is compared one by one with the three-character airport code identified by the file name of the broadcast voice segment in the set Bn of all airport broadcast voice segment files. If the comparison results are one-to-one corresponding, the airport broadcast is broadcasting normally. If the comparison result shows that at least one three-character airport code in the set An of airport three-character codes and airport Chinese names is not in the set Bn of broadcast voice segment file names of all airports, it is determined that at least one airport broadcast voice segment file in the set Bn of broadcast voice segment files of all airports is missing, and the file is defined as the target airport broadcast voice segment file. Step 3: The voice segment generation system performs parameter configuration based on the target airport broadcast voice segment file obtained from the comparison result. The parameter configuration is to configure the target airport three-character code and the corresponding airport Chinese name based on the comparison result information. After generating the complete target airport three-character code information, a speech synthesis method is used to process and generate the target airport broadcast voice segment file. When the length of the three-character code queue in the set An is equal to the length of the queue composed of the file names of the broadcast voice segment files in the set Bn, the voice segment generation system completes the comparison. Step 4: The voice segment generation system generates the target airport's broadcast voice segment file using a speech synthesis method based on the target airport's three-letter code information. The target airport's broadcast voice segment file is uploaded to the broadcast voice segment storage folder of the broadcast system in audio file format via the file transfer protocol FTP, allowing the airport broadcast to be broadcast normally.
[0007] Preferably, in step 1, the voice segment generation system traverses the integrated system database to obtain a set An of three-letter codes and Chinese names of all airports; and traverses the broadcast system to obtain a set Bn of broadcast voice segment files of all airports, which is set according to the time window. The voice segment generation system actively traverses the integrated system database through the Cx_Oracle database connection toolkit within the time window to search for all three-letter code names and Chinese names of airports, and traverses the broadcast voice segment file storage folder of the broadcast system through the FTP file transfer protocol to obtain all three-letter codes of airports, wherein the data storage format in the integrated system database is an Excel table; the three-letter code of the airport is the abbreviation of the target airport, and is identified in the file name of the target broadcast voice segment file.
[0008] Preferably, in step 2, each three-character airport code in the set An of all three-character airport codes and Chinese names of airports is compared one by one with the three-character airport code identified by the file name of the broadcast voice segment in the set Bn of all airport broadcast voice segment files. This means that the queue consisting of each three-character code and Chinese name in the set An and the queue consisting of file names in the set Bn form two sets of data, and the number x of voice segments missing in the broadcast system is obtained, where x is equal to An-Bn. The specific formula is as follows:
[0009] When An>Bn, x is greater than 0, and the comparison result is the three-letter code of the target airport missing from the voice clip folder of the broadcast system, the file name of the target broadcast voice clip file of the broadcast system is obtained, and the voice clip generation system processes them one by one; When An=Bn, x is 0, and each of the three-letter airport codes in the set An and the Chinese airport name table corresponds one-to-one to the file name of the broadcast voice segment file of all airport broadcast voice segment files in the set Bn; wherein, the file name of the airport broadcast voice segment file is identified by the three-letter airport code.
[0010] Preferably, the time set according to the time window by the voice segment generation system is determined based on empirical values or experimental data; when each airport three-character code in the set An of all airport three-character codes and airport Chinese names is traversed and compared one by one with the file name of the broadcast voice segment in the set Bn of all airport broadcast voice segment files to form a comparison result of An=Bn, the voice segment generation system ends the comparison, and when the next time window task comes, the voice segment generation system executes step 1 again for comparison processing.
[0011] Preferably, the broadcast voice clip file of the target airport in step 4 is uploaded to the broadcast voice clip storage folder of the broadcast system in audio file format through the file transfer protocol FTP, which means that the file name of the broadcast voice clip file of the target airport is the target airport three-character code.wav audio format for storage and upload; the upload is based on the upload path * / opt / ttsfile, where opt represents the first-level folder, ttsfile represents the second-level folder, and the voice clip file is saved in the second-level folder; at the same time, a pop-up alarm is used in the Windows environment, and the on-duty personnel are notified through the enterprise DingTalk alarm or WeChat notification alarm.
[0012] The present invention provides a method for synthesizing and processing airport voice segments that are missing in airport broadcasts. The voice segment generation system obtains all three-character airport codes and Chinese names of airports from an integrated system database and obtains all three-character airport codes from a broadcast system voice segment storage folder for comparison to obtain airport information with missing voice segments. The method is implemented based on the voice synthesis technology of Pyttsx3, which effectively solves the problem of manual recording of required voice segments and the problem of audio file bandwidth and frequency limitations of the broadcast system. Since the file upload technology based on the FTP protocol is adopted, the problem of manual uploading after the voice segments are generated is effectively solved, thereby effectively improving work efficiency and effectively replacing repetitive and complicated manual work to achieve the purpose of reducing costs and increasing efficiency. For enterprise operations, the method achieves the effect of improving operational efficiency. Since the system is implemented based on the existing operating system of the civil aviation airport, it achieves a non-invasive improvement of airport business, so that the airport business can invisibly improve service quality and improve passenger experience satisfaction.
[0013] Another aspect of the present invention provides a system for synthesizing and processing missing airport voice segments in airport broadcasts, the system comprising a voice segment generation system, an integrated system database, and a broadcast system, wherein the voice segment generation system is connected to the integrated system database via a Cx_Oracle database and to the broadcast system via an FTP file transfer protocol; The voice segment generation system traverses the integrated system database to obtain the set An of three-character codes and Chinese names of all airports; traverses the broadcasting system to obtain the set Bn of broadcasting voice segment files of all airports; compares each three-character code of the airport in the set An of three-character codes and Chinese names of all airports with the three-character code of the airport identified by the file name of the broadcasting voice segment in the set Bn of broadcasting voice segment files of all airports one by one; if the comparison results correspond one to one, the airport broadcast is broadcasting normally; if the comparison result shows that at least one three-character code of the airport in the set An of three-character codes and Chinese names of airports is not in the set Bn of broadcasting voice segment file names of all airports, then it is determined that at least one broadcasting voice segment file of the target airport is missing in the set Bn of broadcasting voice segment files of all airports; Based on the comparison results, the voice segment generation system configures parameters for the broadcast voice segment files of the target airport that are missing from the airport broadcast voice segment file set Bn. The parameter configuration is to configure the three-character code of the target airport and the corresponding Chinese name of the airport to generate complete three-character code information of the target airport. Then, a speech synthesis method is used to process and generate the broadcast voice segment files of the target airport. When the length of the three-character code queue in the set An is equal to the length of the queue composed of the file names of the broadcast voice segment files in the set Bn, the voice segment generation system completes the comparison. The voice segment generation system uses a speech synthesis method to generate the target airport's broadcast voice segment file based on the target airport's three-letter code information. The target airport's broadcast voice segment file is uploaded to the broadcast voice segment storage folder of the broadcast system in audio file format through the file transfer protocol, so that the airport broadcast can be broadcast normally.
[0014] Preferably, the voice segment generation system traverses the integrated system database to obtain all three-character airport codes and Chinese names of airports; traversing the broadcast system to obtain all three-character airport codes is based on a time window set. Within the time window, the voice segment generation system actively traverses the integrated system database through a Cx_Oracle database connection toolkit to search for all three-character airport codes and Chinese names of airports, and traverses the broadcast voice segment file storage folder of the broadcast system through an FTP file transfer protocol to obtain all three-character airport codes, wherein the data storage format in the integrated system database is an Excel table; the three-character airport code is the abbreviation of the target airport and is identified in the file name of the target broadcast voice segment file; The voice segment generation system sets the time window based on empirical values or experimental data. When each three-letter airport code in the set An of all airport three-letter codes and airport Chinese names is traversed and compared one by one with the file name of the broadcast voice segment in the set Bn of all airport broadcast voice segment files, and the comparison result is An=Bn, the voice segment generation system ends the comparison. When the next time window task comes, the voice segment generation system executes step 1 again for comparison processing.
[0015] Preferably, the voice segment generation system compares each airport three-character code in the set An of all airport three-character codes and airport Chinese names with the airport three-character codes identified by the file names of the broadcast voice segments in the set Bn of all airport broadcast voice segment files one by one, which means that the queue consisting of each three-character code and Chinese name in the set An and the queue consisting of file names in the set Bn form two sets of data, and the number x of voice segments missing in the broadcast system is obtained, where x is equal to An-Bn. The specific formula is as follows:
[0016] When An>Bn, x is greater than 0, and the comparison result is the three-letter code of the target airport missing from the voice clip folder of the broadcast system, the file name of the target broadcast voice clip file of the broadcast system is obtained, and the voice clip generation system processes them one by one; When An=Bn, x is 0, and each of the three-letter airport codes in the set An and the Chinese airport name table corresponds one-to-one to the file name of the broadcast voice segment file of all airport broadcast voice segment files in the set Bn; wherein, the file name of the airport broadcast voice segment file is identified by the three-letter airport code.
[0017] Preferably, the voice segment generation system performs parameter configuration on the broadcast voice segment file set Bn of the airport that is missing at least one broadcast voice segment file of the target airport according to the comparison result, wherein the parameter configuration is to configure the three-character code of the target airport and the corresponding Chinese name of the airport according to the comparison result to generate complete three-character code information of the target airport; The broadcast voice clip file of the target airport is uploaded to the broadcast voice clip storage folder of the broadcast system in audio file format through the FTP file transfer protocol, which means that the file name of the broadcast voice clip file of the target airport is the target airport three-character code.wav audio format and is stored and uploaded; the upload is based on the upload path * / opt / ttsfile, where opt represents the first-level folder, ttsfile represents the second-level folder, and the voice clip file is saved in the second-level folder; at the same time, a pop-up alarm is used in the Windows environment, and the on-duty personnel are notified through the enterprise DingTalk alarm or WeChat notification alarm.
[0018] The present invention provides a system for synthesizing and processing voice segments of airports missing from airport broadcasts. The voice segment generation system obtains all three-character airport codes and Chinese names from the integrated system database and all three-character airport codes from the broadcast system voice segment storage folder for comparison to obtain airport information for missing voice segments. The system is implemented based on Pyttsx3 voice synthesis technology, effectively solving the problem of manually recording the required voice segments and the audio file bandwidth and frequency limitations of the broadcast system. The system uses file upload technology based on the FTP protocol, effectively solving the problem of manually uploading voice segments after they are generated, thereby effectively improving work efficiency. The combined use of the Cx_Oracle toolkit and the FTP protocol effectively solves the problem of passively discovering missing voice segments, thereby realizing active discovery of missing voice segments. The Windows pop-up prompt effectively solves the problem of staff being unable to promptly discover the problem when missing voice segments are discovered, thereby realizing an intelligent prompt function for missing voice segments. This system can not only solve the problem of passively discovering missing voice segments in a timely manner, but also effectively replace repetitive and complicated manual work, thereby achieving the goal of reducing costs and increasing efficiency, and improving operational efficiency for corporate operations. Since the system is implemented based on the existing operating system of civil aviation airports, it achieves a non-invasive improvement in airport operations, allowing airport operations to invisibly improve service quality and enhance passenger satisfaction. BRIEF DESCRIPTION OF THE DRAWINGS
[0019] Figure 1 The present invention is a flowchart of a method for processing missing airport broadcast voice segment data; Figure 2 The present invention is a flow chart of an embodiment of a method for processing missing airport broadcast voice segment data. DETAILED DESCRIPTION
[0020] Exemplary embodiments will be described in detail herein, examples of which are illustrated in the accompanying drawings. In the following description, when referring to the drawings, like numbers in different figures represent like or similar elements unless otherwise indicated. The embodiments described in the following exemplary embodiments are not intended to represent all possible embodiments consistent with the present invention. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the present invention, as detailed in the appended claims.
[0021] The present invention provides a method for processing airport missing broadcast voice segment data, the method comprising the following steps: like Figure 1 As shown, a method for processing missing airport broadcast voice segment data, the method steps are as follows: Step 1: The voice clip generation system traverses the integrated system database to obtain a set An of three-character codes and Chinese names of all airports; and traverses the broadcast system to obtain a set Bn of broadcast voice clip files of all airports; Step 2: Each three-character airport code in the set An of airport three-character codes and airport Chinese names of all airports is compared one by one with the three-character airport code identified by the file name of the broadcast voice segment in the set Bn of all airport broadcast voice segment files. If the comparison results are one-to-one corresponding, the airport broadcast is broadcasting normally. If the comparison result shows that at least one three-character airport code in the set An of airport three-character codes and airport Chinese names is not in the set Bn of broadcast voice segment file names of all airports, it is determined that at least one airport broadcast voice segment file in the set Bn of broadcast voice segment files of all airports is missing, and the file is defined as the target airport broadcast voice segment file. Step 3: The voice segment generation system performs parameter configuration based on the target airport broadcast voice segment file obtained from the comparison result. The parameter configuration is to configure the target airport three-character code and the corresponding airport Chinese name based on the comparison result information. After generating the complete target airport three-character code information, a speech synthesis method is used to process and generate the target airport broadcast voice segment file. When the length of the three-character code queue in the set An is equal to the length of the queue composed of the file names of the broadcast voice segment files in the set Bn, the voice segment generation system completes the comparison. Step 4: The voice segment generation system generates the target airport's broadcast voice segment file using a speech synthesis method based on the target airport's three-letter code information. The target airport's broadcast voice segment file is uploaded to the broadcast voice segment storage folder of the broadcast system in audio file format via the file transfer protocol FTP, allowing the airport broadcast to be broadcast normally.
[0022] In one embodiment, in step 1, the voice segment generation system traverses the integrated system database to obtain a set An of three-letter codes and Chinese names of all airports; traverses the broadcast system to obtain a set Bn of broadcast voice segment files of all airports, which is set according to the time window. The voice segment generation system actively traverses the integrated system database through the Cx_Oracle database connection toolkit within the time window to search for all three-letter code names and Chinese names of airports, and traverses the broadcast voice segment file storage folder of the broadcast system through the FTP file transfer protocol to obtain all three-letter codes of airports, wherein the data storage format in the integrated system database is an Excel table; the three-letter code of the airport is the abbreviation of the target airport and is identified in the file name of the target broadcast voice segment file.
[0023] In one embodiment, step 2 involves comparing each three-character airport code in the set An of all three-character airport codes and their Chinese names with the three-character airport codes identified by the file names of the broadcast voice segments in the set Bn of all airport broadcast voice segment files. This means that the queue consisting of each three-character code and Chinese name in the set An and the queue consisting of the file names in the set Bn are subtracted to form two sets of data, thereby obtaining the number x of missing voice segments in the broadcast system, where x is equal to An-Bn. The specific formula is as follows:
[0024] When An>Bn, x is greater than 0, and the comparison result is the three-letter code of the target airport missing from the voice clip folder of the broadcast system, the file name of the target broadcast voice clip file of the broadcast system is obtained, and the voice clip generation system processes them one by one; When An=Bn, x is 0, and each of the three-letter airport codes in the set An and the Chinese airport name table corresponds one-to-one to the file name of the broadcast voice segment file of all airport broadcast voice segment files in the set Bn; wherein, the file name of the airport broadcast voice segment file is identified by the three-letter airport code.
[0025] In one embodiment, the time set according to the time window of the voice segment generation system is determined based on empirical values or experimental data; when each airport three-character code in the set An of all airport three-character codes and airport Chinese names is traversed and compared one by one with the file name of the broadcast voice segment in the set Bn of all airport broadcast voice segment files to form a comparison result of An=Bn, the voice segment generation system ends the comparison, and when the next time window task comes, the voice segment generation system executes step 1 again for comparison processing.
[0026] In one embodiment, the broadcast voice clip file of the target airport in step 4 is uploaded to the broadcast voice clip storage folder of the broadcast system in audio file format through the file transfer protocol FTP, which means that the file name of the broadcast voice clip file of the target airport is the target airport three-character code.wav audio format for storage and upload; the upload is based on the upload path * / opt / ttsfile, where opt represents the first-level folder, ttsfile represents the second-level folder, and the voice clip file is saved in the second-level folder; at the same time, a pop-up alarm is used in the Windows environment, and the on-duty personnel are notified through the enterprise DingTalk alarm or WeChat notification alarm.
[0027] The present invention provides a method for synthesizing and processing airport voice segments that are missing in airport broadcasts. The voice segment generation system obtains all three-character airport codes and Chinese names of airports from an integrated system database and obtains all three-character airport codes from a broadcast system voice segment storage folder for comparison to obtain airport information with missing voice segments. The method is implemented based on the voice synthesis technology of Pyttsx3, which effectively solves the problem of manual recording of required voice segments and the problem of audio file bandwidth and frequency limitations of the broadcast system. Since the file upload technology based on the FTP protocol is adopted, the problem of manual uploading after the voice segments are generated is effectively solved, thereby effectively improving work efficiency and effectively replacing repetitive and complicated manual work to achieve the purpose of reducing costs and increasing efficiency. For enterprise operations, the method achieves the effect of improving operational efficiency. Since the system is implemented based on the existing operating system of the civil aviation airport, it achieves a non-invasive improvement of airport business, so that the airport business can invisibly improve service quality and improve passenger experience satisfaction.
[0028] Another aspect of the present invention provides a system for synthesizing and processing missing airport voice segments in airport broadcasts, the system comprising a voice segment generation system, an integrated system database, and a broadcast system, wherein the voice segment generation system is connected to the integrated system database via a Cx_Oracle database and to the broadcast system via an FTP file transfer protocol; The voice segment generation system traverses the integrated system database to obtain the set An of three-character codes and Chinese names of all airports; traverses the broadcasting system to obtain the set Bn of broadcasting voice segment files of all airports; compares each three-character code of the airport in the set An of three-character codes and Chinese names of all airports with the three-character code of the airport identified by the file name of the broadcasting voice segment in the set Bn of broadcasting voice segment files of all airports one by one; if the comparison results correspond one to one, the airport broadcast is broadcasting normally; if the comparison result shows that at least one three-character code of the airport in the set An of three-character codes and Chinese names of airports is not in the set Bn of broadcasting voice segment file names of all airports, then it is determined that at least one broadcasting voice segment file of the target airport is missing in the set Bn of broadcasting voice segment files of all airports; Based on the comparison results, the voice segment generation system configures parameters for the broadcast voice segment files of the target airport that are missing from the airport broadcast voice segment file set Bn. The parameter configuration is to configure the three-character code of the target airport and the corresponding Chinese name of the airport to generate complete three-character code information of the target airport. Then, a speech synthesis method is used to process and generate the broadcast voice segment files of the target airport. When the length of the three-character code queue in the set An is equal to the length of the queue composed of the file names of the broadcast voice segment files in the set Bn, the voice segment generation system completes the comparison. The voice segment generation system uses a speech synthesis method to generate the target airport's broadcast voice segment file based on the target airport's three-letter code information. The target airport's broadcast voice segment file is uploaded to the broadcast voice segment storage folder of the broadcast system in audio file format through the file transfer protocol, so that the airport broadcast can be broadcast normally.
[0029] In one embodiment, the voice clip generation system traverses the integrated system database to obtain all three-character airport codes and Chinese names of airports; traversing the broadcast system to obtain all three-character airport codes is based on a time window set. Within the time window, the voice clip generation system actively traverses the integrated system database through the Cx_Oracle database connection toolkit to search for all three-character airport codes and Chinese names of airports, and traverses the broadcast voice clip file storage folder of the broadcast system through the FTP file transfer protocol to obtain all three-character airport codes, wherein the data storage format in the integrated system database is an Excel table; the three-character airport code is the abbreviation of the target airport and is identified in the file name of the target broadcast voice clip file; The voice segment generation system sets the time window based on empirical values or experimental data. When each three-letter airport code in the set An of all airport three-letter codes and their Chinese names is compared one by one with the file names of the broadcast voice segment in the set Bn of all airport broadcast voice segment files, and the comparison result is An = Bn, the voice segment generation system ends the comparison. When the next time window task comes, the voice segment generation system will execute step 1 again for comparison processing.
[0030] In one embodiment, the voice segment generation system compares each three-character airport code in the set An of all three-character airport codes and their Chinese names with the three-character airport codes identified by the file names of the broadcast voice segments in the set Bn of all airport broadcast voice segment files. This means that the queue consisting of each three-character code and Chinese name in the set An and the queue consisting of file names in the set Bn form two sets of data, and the number x of voice segments missing in the broadcast system is obtained, where x is equal to An-Bn. The specific formula is as follows:
[0031] When An>Bn, x is greater than 0, and the comparison result is the three-letter code of the target airport missing from the voice clip folder of the broadcast system, the file name of the target broadcast voice clip file of the broadcast system is obtained, and the voice clip generation system processes them one by one; When An=Bn, x is 0, and each of the three-letter airport codes in the set An and the Chinese airport name table corresponds one-to-one to the file name of the broadcast voice segment file of all airport broadcast voice segment files in the set Bn; wherein, the file name of the airport broadcast voice segment file is identified by the three-letter airport code.
[0032] In one embodiment, the voice segment generation system performs parameter configuration on the broadcast voice segment file set Bn of the airport that is missing at least one target airport based on the comparison result. The parameter configuration is to configure the target airport three-character code and the corresponding airport Chinese name based on the comparison result to generate complete target airport three-character code information. The broadcast voice clip file of the target airport is uploaded to the broadcast voice clip storage folder of the broadcast system in audio file format through the FTP file transfer protocol, which means that the file name of the broadcast voice clip file of the target airport is the target airport three-character code.wav audio format and is stored and uploaded; the upload is based on the upload path * / opt / ttsfile, where opt represents the first-level folder, ttsfile represents the second-level folder, and the voice clip file is saved in the second-level folder; at the same time, a pop-up alarm is used in the Windows environment, and the on-duty personnel are notified through the enterprise DingTalk alarm or WeChat notification alarm.
[0033] The present invention provides a system for synthesizing and processing voice segments of airports missing from airport broadcasts. The voice segment generation system obtains all three-character airport codes and Chinese names from the integrated system database and all three-character airport codes from the broadcast system voice segment storage folder for comparison to obtain airport information for missing voice segments. The system is implemented based on Pyttsx3 voice synthesis technology, effectively solving the problem of manually recording the required voice segments and the audio file bandwidth and frequency limitations of the broadcast system. The system uses file upload technology based on the FTP protocol, effectively solving the problem of manually uploading voice segments after they are generated, thereby effectively improving work efficiency. The combined use of the Cx_Oracle toolkit and the FTP protocol effectively solves the problem of passively discovering missing voice segments, thereby realizing active discovery of missing voice segments. The Windows pop-up prompt effectively solves the problem of staff being unable to promptly discover the problem when missing voice segments are discovered, thereby realizing an intelligent prompt function for missing voice segments. This system can not only solve the problem of passively discovering missing voice segments in a timely manner, but also effectively replace repetitive and complicated manual work, thereby achieving the goal of reducing costs and increasing efficiency, and improving operational efficiency for corporate operations. Since the system is implemented based on the existing operating system of civil aviation airports, it achieves a non-invasive improvement in airport operations, allowing airport operations to invisibly improve service quality and enhance passenger satisfaction.
[0034] Example 1 The embodiment of the present invention provides a method for processing airport missing broadcast voice segment data, such as Figure 2 As shown, In one embodiment, when Narita Airport (NRT) is missing from the broadcast system, the system will proactively search for all three-letter airport codes and Chinese names by connecting to the integrated system database after a set timer has elapsed. The system will then connect to the broadcast system via the FTP protocol to obtain all three-letter airport codes in the voice clip folder. After comparison, it will be found that Narita Airport (NRT) is missing from the broadcast system. The system will then synthesize an 8,000 Hz, 16-bit voice clip of Narita Airport using the Pyttsx3 toolkit, and upload it to the broadcast system via the FTP protocol. At the same time, a pop-up window alarm will be implemented in the Windows environment through a function call based on the Windows development toolkit. (FTP protocol is a protocol used to transfer files, FTP (File Transfer Protocol, File Transfer Protocol) Step 1. The voice segment generation system obtains the airport three-character code and the airport Chinese characters 1. After a set timer (e.g., every five minutes), the voice clip generation system proactively uses the Cx_Oracle database connection toolkit. (The cx_Oracle package provides a Python API for accessing Oracle databases. This package can be installed using the pip command. Python programs call cx_Oracle functions. The connection between Python and Oracle is established using the cx_oracle inbuild Oracle client library. Users should install the Oracle client library on their machines.) Its main function is to build a bridge from the integration system to the voice clip generation system. After connecting to the integration system database, a query search is performed to obtain a list of all three-character airport codes and Chinese names. The three-character code is defined as a three-letter abbreviation representing each airport. The data storage format in the integration system database is similar to that of an Excel spreadsheet. For example:
[0035] The three-letter code corresponds to the Chinese name of the airport. For example, the three-letter code of Xianyang Airport is XIY. Here, the three-letter code queue length parameter of the integrated system is An. 2. The broadcast system obtains a queue Bn consisting of the file names of all voice clip files in the voice clip folder. The file name is the three-letter airport code. In the broadcast system, the voice clip is named with the three-letter code. The audio file name format is "*.wav", where * represents the three-letter airport code. For example, "XIY.wav" has the female voice "Xi'an Xianyang International Airport". Here, the broadcast system three-letter code queue length parameter is set to Bn.
[0036] Step 2: Compare the airport three-letter code Because the data tables in the integrated system database are dynamically updated, for example, when new airports are built domestically or internationally, the integrated system will also update the new airport and three-letter code. When existing airports are renamed, the three-letter code and airport name will also change. These situations will cause the newly added or changed airport names and three-letter codes in the integrated system to mismatch the voice segment names and content in the broadcast system, resulting in the broadcast system missing the corresponding voice segments. During operation, let the number of missing voice segments be x. Comparing the three-letter code queue of the integrated system with the three-letter code queue of the broadcast system, it is found that when the broadcast system is not missing a three-letter code, that is, when the broadcast system is not missing a voice segment, the queue length should be equal to the queue length of the integrated system, that is, An = Bn. In this case, x is 0, and the system will not perform further processing and wait for the next time window. When the broadcast system is missing a three-letter code, that is, when the broadcast system is missing a voice segment, An should be greater than Bn, and x is An - Bn. When x is greater than 0, the system requires further processing.
[0037]
[0038] Step 3: Obtain the missing airport three-letter code information to generate the broadcast voice clip 1. In this embodiment, a comparison shows that there are 270 voice segments in the broadcast system, so Bn is 270, while the integrated system has 271 three-character codes and airport names, so An is 271. In this case, x is 1. The voice segment generation system finds that the broadcast system is missing a voice segment with a three-character code of NRT, Narita Airport in Japan. A normal broadcast would be "Flight AB1234 to Narita Airport in Japan is about to take off. Passengers who have not yet boarded are requested to board as soon as possible." However, when a voice segment is missing, if there is no manual entry, the airport terminal will broadcast "Flight AB1234 to Narita Airport is about to take off. Passengers who have not yet boarded are requested to board as soon as possible." 2. Use the existing speech synthesis technology Pyttsx3 toolkit to synthesize a sound frequency of 8 kilohertz and 16-bit content as the voice clip of "Narita Airport, Japan" and save it in wav audio format. The file name is "NRT.wav". If there are multiple missing files, multiple wav format audio files will be generated and saved. The naming method is the same as the voice clip files in the broadcasting system, which is the three-character code corresponding to the airport.
[0039] Step 4: Upload the airport announcement voice clip to the broadcasting system The voice clip generation system uploads the voice clips in *.wav format generated by the voice clip generation system to the specified folder path of the broadcasting system through the FTP protocol. Currently, in the current environment, the specific upload path during the operation of the software is " / opt / ttsfile". This path is set independently by each airport staff. In the voice clip generation system, it needs to be specified for the system during the first operation of the system. If the path changes subsequently, it needs to be changed in the settings. The path represents the folder path where the broadcasting system running in the Windows operating system environment stores the voice clip files. The uploaded voice clips will eventually be placed in this path for use by the broadcasting system, where "opt" represents the first-level folder and ttsfile represents the second-level folder. The voice clip files are saved in the second-level folder. In addition, the previous common way to upload audio files was to manually upload them to the second-level folder, while the voice clip system automatically uploads the audio files after they are generated through the FTP protocol. Step 5 Pop-up alarm When the file is uploaded, a function called from the existing Windows development kit within the existing Python development environment triggers a pop-up alert in the Windows environment. This alert is then sent to staff via instant messaging apps like WeChat and DingTalk. If the missing audio clips from the previous upload are already in the broadcast system during the next time window check, for example, if both the broadcast system and the integrated system have 271 audio clips (i.e., An = Bn), the audio clip generation system will not process them further. After processing, the system waits for the next time window. If a missing audio clip is detected, the above steps are repeated within that window.
[0040] An embodiment of the present invention provides a method for synthesizing and processing airport voice segments missing from airport broadcasts. The method uses a voice segment generation system to obtain all three-character airport codes and Chinese names from an integrated system database and obtains all three-character airport codes from a broadcast system voice segment storage folder for comparison to obtain airport information for missing voice segments. The method is implemented based on Pyttsx3 voice synthesis technology, effectively solving the problem of manually recording the required voice segments and the audio file bandwidth and frequency limitations of the broadcast system. The method uses file upload technology based on the FTP protocol, effectively solving the problem of manually uploading voice segments after they are generated, thereby effectively improving work efficiency. The combined use of the Cx_Oracle toolkit and the FTP protocol effectively solves the problem of passively discovering missing voice segments, thereby realizing active discovery of missing voice segments. The Windows pop-up prompt effectively solves the problem of staff being unable to promptly discover the problem when missing voice segments are discovered, thereby realizing an intelligent prompt function for missing voice segments. This system can not only solve the problem of passively discovering missing voice segments in a timely manner, but also effectively replace repetitive and complicated manual work, thereby achieving the goal of reducing costs and increasing efficiency, and improving operational efficiency for corporate operations. Since the system is implemented based on the existing operating system of civil aviation airports, it achieves a non-invasive improvement in airport operations, allowing airport operations to invisibly improve service quality and enhance passenger satisfaction.
Claims
1. A method for processing missing airport broadcast voice segment data, characterized in that: The method steps are as follows: Step 1: The voice clip generation system traverses the integrated system database to obtain a set An of three-character codes and Chinese names of all airports; and traverses the broadcast system to obtain a set Bn of broadcast voice clip files of all airports; Step 2: Each three-character airport code in the set An of airport three-character codes and airport Chinese names of all airports is compared one by one with the three-character airport code identified by the file name of the broadcast voice segment in the set Bn of all airport broadcast voice segment files. If the comparison results are one-to-one corresponding, the airport broadcast is broadcasting normally. If the comparison result shows that at least one three-character airport code in the set An of airport three-character codes and airport Chinese names is not in the set Bn of broadcast voice segment file names of all airports, it is determined that at least one airport broadcast voice segment file in the set Bn of broadcast voice segment files of all airports is missing, and the file is defined as the target airport broadcast voice segment file. Step 3: The voice segment generation system performs parameter configuration based on the target airport broadcast voice segment file obtained from the comparison result. The parameter configuration is to configure the target airport three-character code and the corresponding airport Chinese name based on the comparison result information. After generating the complete target airport three-character code information, a speech synthesis method is used to process and generate the target airport broadcast voice segment file. When the length of the three-character code queue in the set An is equal to the length of the queue composed of the file names of the broadcast voice segment files in the set Bn, the voice segment generation system completes the comparison. Step 4: The voice segment generation system generates the target airport's broadcast voice segment file using a speech synthesis method based on the target airport's three-letter code information. The target airport's broadcast voice segment file is uploaded to the broadcast voice segment storage folder of the broadcast system in audio file format via the file transfer protocol FTP, allowing the airport broadcast to be broadcast normally.
2. The method for processing missing airport broadcast voice segment data according to claim 1, characterized in that: In step 1, the voice segment generation system traverses the integrated system database to obtain the set An of the three-letter codes and Chinese names of all airports; traverses the broadcast system to obtain the set Bn of broadcast voice segment files of all airports, which is based on the time set in the time window. The voice segment generation system actively traverses the integrated system database through the Cx_Oracle database connection toolkit within the time window to search for all airport three-letter codes and airport Chinese names, and traverses the broadcast voice segment file storage folder of the broadcast system through the FTP file transfer protocol to obtain all airport three-letter codes. The data storage format in the integrated system database is an Excel table; the airport three-letter code is the abbreviation of the target airport and is identified in the file name of the target broadcast voice segment file.
3. The method for processing missing airport broadcast voice segment data according to claim 1, characterized in that: In step 2, each three-character airport code in the set An of all airport three-character codes and airport Chinese names is compared one by one with the three-character airport code identified by the file name of the broadcast voice segment in the set Bn of all airport broadcast voice segment files. This means that the queue consisting of each three-character code and Chinese name in the set An and the queue consisting of the file names in the set Bn are subtracted to form two sets of data to obtain the number x of voice segments missing in the broadcast system, where x is equal to An-Bn. The specific formula is as follows: When An>Bn, x is greater than 0, and the comparison result is the three-letter code of the target airport missing from the voice clip folder of the broadcast system, the file name of the target broadcast voice clip file of the broadcast system is obtained, and the voice clip generation system processes them one by one; When An=Bn, x is 0, and each of the three-letter airport codes in the set An and the Chinese airport name table corresponds one-to-one to the file name of the broadcast voice segment file of all airport broadcast voice segment files in the set Bn; wherein, the file name of the airport broadcast voice segment file is identified by the three-letter airport code.
4. The method for processing missing airport broadcast voice segment data according to claim 2, characterized in that: The time set by the voice segment generation system according to the time window is determined based on empirical values or experimental data. When each airport three-letter code in the set An of all airport three-letter codes and airport Chinese names is traversed and compared one by one with the file name of the broadcast voice segment in the set Bn of all airport broadcast voice segment files, and the comparison result is An=Bn, the voice segment generation system ends the comparison. When the next time window task comes, the voice segment generation system will execute step 1 for comparison processing again.
5. The method for processing missing airport broadcast voice segment data according to claim 1, characterized in that: In step 4, the broadcast voice clip file of the target airport is uploaded to the broadcast voice clip storage folder of the broadcast system in audio file format through the file transfer protocol FTP, which means that the file name of the broadcast voice clip file of the target airport is the target airport three-character code.wav audio format for storage and upload; the upload is based on the upload path * / opt / ttsfile, where opt represents the first-level folder, ttsfile represents the second-level folder, and the voice clip file is saved in the second-level folder; at the same time, a pop-up alarm is used in the Windows environment, and the on-duty personnel are notified through the enterprise DingTalk alarm or WeChat notification alarm.
6. A system for processing missing airport broadcast voice segment data, characterized in that: The system includes a voice segment generation system, an integrated system database, and a broadcasting system, wherein the voice segment generation system is connected to the integrated system database via a Cx_Oracle database and is connected to the broadcasting system via an FTP file transfer protocol; The voice segment generation system traverses the integrated system database to obtain a set An of three-character codes and Chinese names of all airports; traverses the broadcasting system to obtain a set Bn of broadcasting voice segment files of all airports; compares each three-character airport code in the set An of three-character codes and Chinese names of all airports with the three-character airport code identified by the file name of the broadcasting voice segment in the set Bn of broadcasting voice segment files of all airports one by one; if the comparison results are one-to-one corresponding, the airport broadcast is broadcasting normally; if the comparison result is that at least one three-character airport code in the set An of three-character codes and Chinese names of airports is not in the set Bn of broadcasting voice segment file names of all airports, it is determined that at least one broadcasting voice segment file of the target airport is missing in the set Bn of broadcasting voice segment files of all airports; The voice segment generation system performs parameter configuration on the broadcast voice segment files of the airports that are missing at least one target airport in the broadcast voice segment file set Bn according to the comparison results. The parameter configuration is to configure the three-character code of the target airport and the corresponding Chinese name of the airport to generate complete three-character code information of the target airport. Then, a speech synthesis method is used to process and generate the broadcast voice segment files of the target airport. When the length of the three-character code queue in the set An is equal to the length of the queue composed of the file names of the broadcast voice segment files in the set Bn, the voice segment generation system ends the comparison. The voice segment generation system uses a speech synthesis method to generate a broadcast voice segment file of the target airport according to the three-character code information of the target airport. The broadcast voice segment file of the target airport is uploaded to the broadcast voice segment storage folder of the broadcast system through the file transfer protocol in audio file format, so that the airport broadcast is broadcast normally.
7. The system for processing missing airport broadcast voice segment data according to claim 6, characterized in that: The voice segment generation system traverses the integrated system database to obtain all airport three-character codes and airport Chinese names; traversing the broadcast system to obtain all airport three-character codes is based on the time set in the time window. The voice segment generation system actively traverses the integrated system database within the time window through the Cx_Oracle database connection toolkit to search for all airport three-character code names and airport Chinese names, and traverses the broadcast voice segment file storage folder of the broadcast system through the FTP file transfer protocol to obtain all airport three-character codes, wherein the data storage format in the integrated system database is an Excel table; the airport three-character code is the abbreviation of the target airport and is identified in the file name of the target broadcast voice segment file; The time set in the time window by the voice segment generation system is determined based on empirical values or experimental data. When each three-character airport code in the set An of all airport three-character codes and airport Chinese names is traversed and compared one by one with the file name of the broadcast voice segment in the set Bn of all airport broadcast voice segment files, and the comparison result is An=Bn, the voice segment generation system ends the comparison. When the next time window task comes, the voice segment generation system executes step 1 again for comparison processing.
8. The system for processing missing airport broadcast voice segment data according to claim 6, characterized in that: The voice segment generation system compares each airport three-character code in the set An of all airport three-character codes and airport Chinese names with the airport three-character code identified by the file name of the broadcast voice segment in the set Bn of all airport broadcast voice segment files one by one. This means that the queue consisting of each three-character code and Chinese name in the set An and the queue consisting of file names in the set Bn are subtracted to form two sets of data to obtain the number x of voice segments missing in the broadcast system, where x is equal to An-Bn. The specific formula is as follows: When An>Bn, x is greater than 0, and the comparison result is the three-letter code of the target airport missing from the voice clip folder of the broadcast system, the file name of the target broadcast voice clip file of the broadcast system is obtained, and the voice clip generation system processes them one by one; When An=Bn, x is 0, and each of the three-letter airport codes in the set An and the Chinese airport name table corresponds one-to-one to the file name of the broadcast voice segment file of all airport broadcast voice segment files in the set Bn; wherein, the file name of the airport broadcast voice segment file is identified by the three-letter airport code.
9. The system for processing missing airport broadcast voice segment data according to claim 6, characterized in that: The voice segment generation system performs parameter configuration on the broadcast voice segment file set Bn of the airport that is missing at least one target airport according to the comparison result. The parameter configuration is to configure the target airport three-character code and the corresponding airport Chinese name according to the comparison result to generate complete target airport three-character code information; The broadcast voice clip file of the target airport is uploaded to the broadcast voice clip storage folder of the broadcast system in audio file format through the FTP file transfer protocol, which means that the file name of the broadcast voice clip file of the target airport is the target airport three-character code.wav audio format and is stored and uploaded; the upload is based on the upload path * / opt / ttsfile, where opt represents the first-level folder, ttsfile represents the second-level folder, and the voice clip file is saved in the second-level folder; at the same time, a pop-up alarm is used in the Windows environment, and the on-duty personnel are notified through the enterprise DingTalk alarm or WeChat notification alarm.