Scenic area passenger flow data sharing integration method, system and equipment based on time node division and medium

Through the integrated method of tourist flow data sharing in scenic spots based on time nodes, data sources are automatically identified and integrated, and logical integration and separation are carried out, which solves the problems of complexity and inefficiency of data merging in the existing technology, and realizes efficient data governance and Flexible data management.

CN118939711APending Publication Date: 2024-11-12ZHEJIANG SUPCON INFORMATION TECH CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202410957180.6
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-07-17
Publication Date
2024-11-12

AI Technical Summary

Technical Problem

When the data source changes in the existing scenic spot passenger flow data processing system, data merging is complex and the workload is large, resulting in inefficient data governance and data sharing and insufficient flexibility.

Method used

Adopt the integrated method of tourist flow data sharing in scenic spots based on time nodes, and automatically identify the data source by analyzing the passenger flow data type, structure and characteristic information, conducting preliminary integration of old and new data and independent data governance, and logically integrating or Separate, form a unified number-take table, and dynamically filter the data that returns the query time node.

Benefits of technology

It significantly reduces the complexity and workload of the data merging process, improves the efficiency and accuracy of data governance, enhances the flexibility and adaptability of the system, and realizes efficient data management and analysis.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118939711A_ABST
    Figure CN118939711A_ABST
Patent Text Reader

Abstract

The invention relates to a scenic spot passenger flow data sharing integration method, system and device based on time node division and a medium, and the method comprises the steps: receiving incoming passenger flow data, and automatically recognizing a passenger flow data source through the analysis of the passenger flow data; if a new data source is accessed, the passenger flow data of the new data source and the historical passenger flow data are automatically and preliminarily integrated, and independent data governance is executed respectively; according to the time configuration requirement of a user, performing logic integration and / or separation on the preliminary integrated data containing the treated passenger flow data of the new data source and the historical passenger flow data by using a logic statement to form a unified access table; and in response to a request of a user, dynamically screening and returning corresponding passenger flow data from the unified data access table. Therefore, through independent data management, efficient data sharing and screening functions and flexible time node configuration, efficient management and accurate analysis of scenic spot passenger flow data are realized, and data support is provided for scenic spot operation.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of data management and statistical technology, and in particular to an integrated method, system, device and medium for sharing scenic spot passenger flow data based on time node division. Background Art

[0002] In the current scenic spot passenger flow data processing system, in order to continue to use the existing data analysis methods and indicators, when the data source changes, it is usually necessary to integrate the new and old data. This process covers multiple links such as data governance, data sharing, logical processing, and data table screening, aiming to aggregate and unify data at different time nodes. However, this method shows a certain degree of complexity and a large workload in the implementation process.

[0003] Specifically, when the data source or its statistical method changes, merging old data with new data becomes a cumbersome task. This may not only cause data redundancy, but also lead to data consistency issues, thus affecting the accuracy of data analysis. In addition, since the data structure at different time nodes may be different, the data integration and governance methods often need to be adjusted during the data sharing process, which often means a lot of rework.

[0004] More importantly, merging data with different data structures is a huge challenge in itself. It not only increases the overall workload, but also significantly affects the efficiency of data governance and data sharing. Overall, the existing system lacks flexibility when dealing with changes in data sources and is difficult to respond quickly to new data needs. Therefore, there is room for improvement and optimization to simplify the data integration process, improve efficiency, and enhance the flexibility of the system. Summary of the invention

[0005] 1. Technical issues to be resolved

[0006] In view of the above-mentioned shortcomings and deficiencies of the prior art, the present invention provides an integrated method, system, device and medium for sharing scenic spot passenger flow data based on time node division, which solves the technical problems that when the data source of the existing scenic spot passenger flow data processing system changes, the data merging process is complicated and labor-intensive, resulting in low efficiency of data governance and data sharing, and insufficient flexibility.

[0007] (II) Technical solution

[0008] In order to achieve the above object, the main technical solutions adopted by the present invention include:

[0009] In a first aspect, an embodiment of the present invention provides an integrated method for sharing scenic spot passenger flow data based on time node division, including:

[0010] Receive incoming passenger flow data and automatically identify the source of passenger flow data by analyzing the type, structure and feature information of the passenger flow data;

[0011] If a new data source is connected, the passenger flow data of the new data source will be automatically integrated with the historical passenger flow data, and independent data governance will be performed on the passenger flow data of the new data source and the historical passenger flow data respectively;

[0012] According to the user's time configuration requirements, use preset logical statements to logically integrate and / or separate the preliminary integrated data including the passenger flow data of the new data source that has been governed and the historical passenger flow data to form a unified data acquisition table;

[0013] In response to a user's request including at least one query time node, passenger flow data corresponding to at least one query time node is dynamically filtered and returned from the unified data retrieval table.

[0014] Optionally, receiving the incoming passenger flow data and automatically identifying the source of the passenger flow data by parsing the type, structure and feature information of the passenger flow data includes:

[0015] By continuously monitoring the designated data receiving interface, the passenger flow data transmitted from the outside is received in real time;

[0016] Use the preset data parsing library or function to analyze the header information or metadata of the passenger flow data to obtain the type of passenger flow data;

[0017] Using a parser corresponding to the type of passenger flow data, extracting each data element from the passenger flow data, and constructing the structure of the passenger flow data based on the relationship between the data elements;

[0018] By analyzing the distribution pattern, periodic changes and outliers of passenger flow data, characteristic information of passenger flow data can be extracted;

[0019] Based on the parsed data type, structure and feature information, the source of the passenger flow data is automatically identified by comparing it with a data source feature library that pre-stores multiple feature descriptions of known data sources.

[0020] Optionally, when a new data source is connected, the passenger flow data of the new data source is automatically preliminarily integrated with the historical passenger flow data, and independent data governance is performed on the passenger flow data of the new data source and the historical passenger flow data, including:

[0021] When a new data source is detected, the passenger flow data of the new data source is loaded into a temporary data buffer or intermediate table;

[0022] Connect the passenger flow data of the new data source in the temporary data buffer or intermediate table with the historical passenger flow data in time series to achieve preliminary integration;

[0023] Independent data governance processes will be implemented for passenger flow data from new data sources and historical passenger flow data.

[0024] Optionally, according to the user's time configuration requirements, a preset logical statement is used to logically integrate and / or separate the preliminary integrated data including the passenger flow data of the new data source that has been governed and the historical passenger flow data to form a unified data acquisition table including:

[0025] Receive the time configuration requirements configured by the user on the page, and obtain the configuration time node by parsing the time configuration requirements;

[0026] Automatically select or construct integrated logic statements or separated logic statements according to the configured time nodes;

[0027] Execute the integration logic statement to integrate the passenger flow data of the new data source under governance and the preliminary integrated data of the historical passenger flow data in an orderly manner according to the configured time nodes to achieve logical integration;

[0028] Execute separation logic statements to separate the passenger flow data including the governed new data source and the preliminary integrated data of the historical passenger flow data into different parts according to the configured time nodes to achieve logical independence;

[0029] A unified data retrieval table is formed based on the logically integrated or separated data, and stored in a preset centralized data sharing platform.

[0030] Optionally, in response to a user's request including at least one query time node, dynamically filtering and returning passenger flow data corresponding to at least one query time node from the unified data retrieval table includes:

[0031] Receive a request sent by a user, and parse the request to obtain at least one query time node;

[0032] Constructing a query statement according to at least one query time node;

[0033] Predict user query needs by analyzing pre-recorded user historical query records and behavior patterns;

[0034] Based on the predicted user query needs, some data related to the predicted needs is pre-loaded from the unified data retrieval table into the cache;

[0035] Using the constructed query statement and at least one query time node, first perform a dynamic filtering operation in the cache. If the required data is not found in the cache, perform another filtering in the unified data retrieval table to obtain the passenger flow data corresponding to the query time node;

[0036] According to the data types and filtering frequencies corresponding to different times in the re-screening, the user's historical query records and behavior patterns are formed.

[0037] Optionally, in response to a user's request including at least one query time node, after dynamically filtering and returning the passenger flow data corresponding to at least one query time node from the unified data retrieval table, the method further includes:

[0038] Create a centralized data sharing platform to receive passenger flow data from different data sources;

[0039] The passenger flow data obtained from the centralized data sharing platform is organized in tables, charts or other visual forms and displayed to users through the user interface.

[0040] Optionally, on a centralized data sharing platform, passenger flow data from a new data source and historical passenger flow data share a data interface.

[0041] In a second aspect, an embodiment of the present invention provides an integrated method for sharing scenic spot passenger flow data based on time node division, including:

[0042] The receiving and identifying module is used to receive the incoming passenger flow data and automatically identify the source of the passenger flow data by analyzing the type, structure and feature information of the passenger flow data;

[0043] The integration and management module is used to automatically integrate the passenger flow data of the new data source with the historical passenger flow data when a new data source is connected, and to perform independent data management on the passenger flow data of the new data source and the historical passenger flow data respectively;

[0044] A data acquisition table forming module is used to logically integrate and / or separate the passenger flow data including the governed new data source and the preliminary integrated data of the historical passenger flow data according to the user's time configuration requirements using preset logical statements to form a unified data acquisition table;

[0045] The screening and returning module is used to respond to a user's request containing at least one query time node, and dynamically screen and return the passenger flow data corresponding to at least one query time node from the unified data retrieval table.

[0046] In the third aspect, an embodiment of the present invention provides an integrated system for sharing scenic spot passenger flow data based on time node division, including: at least one database; and a memory communicatively connected to the at least one database; wherein the memory stores instructions executable by at least one database, and the instructions are executed by at least one database so that at least one database can execute an integrated method for sharing scenic spot passenger flow data based on time node division as described above.

[0047] In a fourth aspect, an embodiment of the present invention provides a computer-readable medium having computer executable instructions stored thereon, which, when executed by a processor, implements an integrated method for sharing scenic spot passenger flow data based on time node division as described above.

[0048] (III) Beneficial effects

[0049] The beneficial effects of the present invention are:

[0050] First, the present invention can automatically identify different data sources by receiving and parsing incoming passenger flow data, thereby achieving automatic adaptation to changes in data sources. When a new data source is connected, the method can automatically integrate the new data with historical data and perform independent data management on both. This design significantly reduces the complexity and workload in the process of merging new and old data, making data management more efficient and accurate.

[0051] Secondly, the present invention logically integrates or separates the preliminarily integrated new and old data through preset logical statements, and the present invention forms a unified data acquisition table. This innovative measure not only ensures the clear logical separation of new and old data, but also achieves the unification of data statistics, greatly improving the accuracy and reliability of data analysis.

[0052] Next, the present invention can respond to a user's request containing at least one query time node, dynamically filter and return the passenger flow data of the corresponding time node from the unified data retrieval table. This function is due to the time node filtering function added in the data sharing module, which makes the sharing and display of new and old data more efficient, effectively reducing rework and duplication of labor.

[0053] Furthermore, through flexible time node screening, the present invention can quickly adapt to and meet the needs of users for data at different time nodes, significantly enhancing the adaptability and flexibility of the system.

[0054] Therefore, the present invention realizes efficient management and accurate analysis of scenic spot passenger flow data through independent data governance, efficient data sharing and screening functions, and flexible time node configuration, providing powerful data support for scenic spot operations. BRIEF DESCRIPTION OF THE DRAWINGS

[0055] Figure 1 A flow chart of an integrated method for sharing scenic spot passenger flow data based on time node division provided by an embodiment of the present invention;

[0056] Figure 2 A specific flow chart of step S1 of an integrated method for sharing scenic spot passenger flow data based on time node division provided by an embodiment of the present invention;

[0057] Figure 3A specific flow chart of step S2 of an integrated method for sharing scenic spot passenger flow data based on time node division provided by an embodiment of the present invention;

[0058] Figure 4 A specific flow chart of step S3 of an integrated method for sharing scenic spot passenger flow data based on time node division provided by an embodiment of the present invention;

[0059] Figure 5 A specific flow chart of step S4 of an integrated method for sharing scenic spot passenger flow data based on time node division provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0060] In order to better explain the present invention and facilitate understanding, the present invention is described in detail below through specific implementation modes in conjunction with the accompanying drawings.

[0061] like Figure 1 As shown, an integrated method for sharing scenic spot passenger flow data based on time node division proposed in an embodiment of the present invention includes: receiving incoming passenger flow data, and automatically identifying the passenger flow data source by analyzing the type, structure and characteristic information of the passenger flow data; if a new data source is connected, automatically preliminarily integrating the passenger flow data of the new data source with the historical passenger flow data, and performing independent data governance on the passenger flow data of the new data source and the historical passenger flow data respectively; according to the user's time configuration requirements, using preset logical statements to logically integrate and / or separate the preliminary integrated data including the passenger flow data of the governed new data source and the historical passenger flow data to form a unified data retrieval table; in response to the user's request including at least one query time node, dynamically filtering and returning the passenger flow data corresponding to at least one query time node from the unified data retrieval table.

[0062] First, the present invention can automatically identify different data sources by receiving and parsing incoming passenger flow data, thereby achieving automatic adaptation to changes in data sources. When a new data source is connected, the method can automatically integrate the new data with historical data and perform independent data management on both. This design significantly reduces the complexity and workload in the process of merging new and old data, making data management more efficient and accurate.

[0063] Secondly, the present invention logically integrates or separates the preliminarily integrated new and old data through preset logical statements, and the present invention forms a unified data acquisition table. This innovative measure not only ensures the clear logical separation of new and old data, but also achieves the unification of data statistics, greatly improving the accuracy and reliability of data analysis.

[0064] Next, the present invention can respond to a user's request containing at least one query time node, dynamically filter and return the passenger flow data of the corresponding time node from the unified data retrieval table. This function is due to the time node filtering function added in the data sharing module, which makes the sharing and display of new and old data more efficient, effectively reducing rework and duplication of labor.

[0065] Furthermore, through flexible time node screening, the present invention can quickly adapt to and meet the needs of users for data at different time nodes, significantly enhancing the adaptability and flexibility of the system.

[0066] Therefore, the present invention realizes efficient management and accurate analysis of scenic spot passenger flow data through independent data governance, efficient data sharing and screening functions, and flexible time node configuration, providing powerful data support for scenic spot operations.

[0067] In order to better understand the above technical solution, exemplary embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present invention are shown in the accompanying drawings, it should be understood that the present invention can be implemented in various forms and should not be limited by the embodiments described herein. On the contrary, these embodiments are provided to enable a clearer and more thorough understanding of the present invention and to fully convey the scope of the present invention to those skilled in the art.

[0068] Specifically, an embodiment of the present invention provides an integrated method for sharing scenic spot passenger flow data based on time node division, which includes:

[0069] S1. Receive incoming passenger flow data, and automatically identify the source of the passenger flow data by analyzing the type, structure and feature information of the passenger flow data.

[0070] First, incoming passenger flow data from at least one data source is received, and each passenger flow data is analyzed to distinguish different passenger flow data sources and provide a high-quality data foundation for subsequent data analysis and decision support.

[0071] Furthermore, if Figure 2 As shown, step S1 includes:

[0072] S11. By continuously monitoring the designated data receiving interface, the passenger flow data transmitted from the outside is received in real time. By continuously monitoring the designated data receiving interface, the passenger flow data transmitted from the outside can be captured in real time. This real-time receiving mechanism ensures the timeliness and accuracy of the data, and provides a basis for subsequent analysis and processing.

[0073] S12. Using a preset data parsing library or function, the type of the passenger flow data is obtained by analyzing the header information or metadata of the passenger flow data.

[0074] The header information or metadata contains important descriptive information about the data file or data stream, such as the creation time, modification time, data format, encoding method, etc. of the data. For example, if the metadata indicates that the data is in CSV format and contains specific column headers such as "timestamp", "passenger flow", etc., then it can be determined that the data is about passenger flow statistics. At the same time, it will also check whether there are specific tags, delimiters or data patterns, which are important information to determine the type of passenger flow data. Preferably, the types of passenger flow data include: CSV files, JSON data packets, XML files.

[0075] S13. Use a parser corresponding to the type of passenger flow data to extract various data elements, and construct a structure of the passenger flow data based on the relationships between the data elements.

[0076] Based on the type of passenger flow data identified in step S12, a matching parser is selected, such as a text format parser, a command line parser, and a regular expression parser. After that, the parser starts working, and it will extract each element in the passenger flow data one by one according to the format specification of the data. These data elements include timestamps, passenger flow statistics, customer behavior records, location information, etc., depending on the type and purpose of the data. While extracting data elements, the parser also analyzes the relationships between these data elements. These relationships are manifested as hierarchical structures, time sequences, correlations, etc. between data, and are the basis for building data structures.

[0077] Based on the extracted data elements and the relationships between them, the parser begins to build the overall structure of the passenger flow data. The overall structure includes a tree structure, a graph structure or other complex data organization forms, which reflects the internal logic and connections of the data.

[0078] S14. Extract characteristic information of the passenger flow data by analyzing the distribution pattern, periodic changes and abnormal values ​​of the passenger flow data.

[0079] In the process of data processing and analysis, feature extraction is a key link, which helps us to deeply understand and explain the inherent laws and characteristics of the data. In step S14, firstly, the distribution pattern of passenger flow data is obtained through statistical analysis. The distribution pattern reflects the frequency and distribution form of data at different values. Then, through time series analysis, the periodic changes in passenger flow data are obtained. Furthermore, by setting reasonable thresholds and using anomaly detection algorithms, outliers in passenger flow data are detected. Outliers represent special situations or emergencies, which are of great significance to passenger flow analysis.

[0080] S15. Based on the parsed data type, structure and feature information, the source of the passenger flow data is automatically identified by comparing it with a data source feature library that pre-stores multiple feature descriptions of known data sources.

[0081] Based on the above parsed data types, structures and extracted feature information, the data source is automatically identified. By comparing the pre-stored data source feature library containing known data source feature descriptions, the data source description that best matches the current passenger flow data can be found.

[0082] S2. When a new data source is connected, the passenger flow data of the new data source will be automatically integrated with the historical passenger flow data, and independent data governance will be performed on the passenger flow data of the new data source and the historical passenger flow data respectively.

[0083] When a new data source is connected, a series of operations will be automatically performed to ensure that the passenger flow data of the new data source can be effectively integrated with the historical passenger flow data and that independent data governance is performed for each. This process is designed to reduce unnecessary merging work, thereby significantly reducing the workload and complexity of data governance.

[0084] Furthermore, if Figure 3 As shown, step S2 includes:

[0085] S21. When a new data source is detected, the passenger flow data of the new data source is loaded into a temporary data buffer or an intermediate table.

[0086] Once a new data source is detected, the passenger flow data of the new data source will be automatically loaded into a specially set temporary data buffer or intermediate table. The purpose of this step is to temporarily isolate the new data for subsequent processing and verification, while ensuring that there is no direct impact on the existing historical data.

[0087] S22. Connect the passenger flow data of the new data source in the temporary data buffer or intermediate table with the historical passenger flow data in accordance with the time series to achieve preliminary integration.

[0088] After the data is loaded into the temporary buffer, the passenger flow data from the new data source is connected with the historical passenger flow data in time series. This connection process realizes the initial integration of data, so that the new data and historical data form a continuous data flow in time.

[0089] S23. Independent data governance processes will be executed for passenger flow data from new data sources and historical passenger flow data.

[0090] To ensure the independence of data, independent data governance processes are implemented for passenger flow data from new data sources and historical passenger flow data. This includes steps such as data cleaning, data verification, and format standardization, aiming to eliminate errors, anomalies, or inconsistencies in the data. Through independent governance, the relative independence of each part of the data can be ensured.

[0091] S3. Based on the user's time configuration requirements, use preset logical statements to logically integrate and / or separate the preliminary integrated data including the passenger flow data of the governed new data source and the historical passenger flow data to form a unified data acquisition table.

[0092] After data governance and initial integration, step S3 focuses on further logical integration or segmentation of the integrated passenger flow data according to the specific needs of the user. This step aims to ensure that the data can meet the user's specific time configuration requirements, thereby forming a unified and structured data collection table.

[0093] Furthermore, if Figure 4 As shown, step S3 includes:

[0094] S31, receiving the time configuration requirement configured by the user on the page, and obtaining the configuration time node by parsing the time configuration requirement.

[0095] In a specific embodiment, the present invention provides a user-friendly interface that allows users to explicitly configure their time requirements on the page. These time requirements may include a specific date range, time period, or certain specific time nodes, such as the beginning of a quarter, the end of a month, etc. Users specify the specific time range they want to analyze or process data through these configurations.

[0096] When the user completes the time configuration and submits it, the user's time configuration requirements are received and the parsing phase begins. The parsing process is to convert the time configuration entered by the user into a format that can be understood and executed. For example, if the user enters a date range, it needs to be converted into a date format that can be recognized internally, and the start date and end date need to be determined. If the user specifies a specific time node, such as "the first day of each month", the specific date needs to be calculated. After the parsing is completed, the configured time nodes are obtained. These time nodes are the key basis for subsequent data integration, separation and other operations.

[0097] S32. Automatically select or construct an integrated logic statement or a separated logic statement according to the configured time node.

[0098] According to the parsed configuration time nodes, the corresponding integration logic statement or separation logic statement will be automatically selected or constructed. These logic statements are pre-defined and used to process data integration or separation operations. Among them, the logic statements include SQL queries or other data processing scripts for data screening, sorting, aggregation and other operations.

[0099] Specifically, an integration logic statement refers to an instruction to merge, summarize or sort data according to specific conditions or rules. In database query languages ​​(such as SQL), integration logic statements include clauses such as SELECT, JOIN, GROUP BY, and ORDER BY, which are used to retrieve data from the database and integrate information from multiple data tables or data sets. For example, an integration logic statement may merge passenger flow data from a new data source and historical passenger flow data in time series to form a continuous data set; separation logic statements are instructions for splitting data into different parts according to specific conditions. In SQL, it involves using the WHERE clause to filter data, or using clauses such as PARTITION BY to partition data in data analysis functions. The purpose of separation logic statements is to divide data into independent segments or groups for more detailed analysis or processing. For example, a separation logic statement may split a data set into two parts, "before" and "after", based on the time node specified by the user, so that they can be analyzed separately.

[0100] In other words, if the user's configuration requirement is to integrate the data at a specific time point, select or build a logical statement that can filter and integrate all related data before or after that time point. On the contrary, if the user's configuration requirement is to separate the data at a certain time point, select or build a logical statement that can separate the data into two parts according to the time point.

[0101] S33. Execute the integration logic statement to orderly integrate the passenger flow data including the governed new data source and the preliminary integrated data of the historical passenger flow data according to the configured time nodes to achieve logical integration.

[0102] Next, execute the integration logic statement. The purpose of this step is to integrate the passenger flow data of the new data source that has been governed with the preliminary integration data of the historical passenger flow data in an orderly manner according to the configured time nodes specified by the user. In this way, the data is logically unified and organized, which is convenient for subsequent analysis and query.

[0103] S34. Execute separation logic statements to separate the preliminary integrated data including the governed new data source passenger flow data and the historical passenger flow data into different parts according to the configured time nodes to achieve logical independence.

[0104] At the same time, the separation logic statement is also executed. The purpose of this step is to separate the initially integrated data into different parts according to the configured time nodes. This helps to maintain the independence and clarity of the data, allowing users to process and analyze the data within a specific time period more flexibly.

[0105] S35. A unified data retrieval table is formed based on the logically integrated or separated data, and stored in a preset centralized data sharing platform.

[0106] After completing the logical integration or separation, a unified data table is generated based on the processed data. This data table has a clear structure, orderly data, and contains all the information required by the user. Through logical separation and screening, the new and old data are logically separated, but statistically unified, which improves the accuracy of data analysis. Finally, this unified data table will be stored in a preset centralized data sharing platform for subsequent data query, analysis and visualization.

[0107] S4. In response to a user's request including at least one query time node, dynamically filter and return passenger flow data corresponding to at least one query time node from the unified data retrieval table.

[0108] Furthermore, if Figure 5 As shown, step S4 includes:

[0109] S41. Receive a request sent by a user, and parse the request to obtain at least one query time node.

[0110] S42: Construct a query statement according to at least one query time node, construct a corresponding SQL query statement or other applicable database query language, and these query statements are designed to accurately retrieve the passenger flow data matching the specified time node.

[0111] S43. Predicting user query needs by analyzing pre-recorded user historical query records and behavior patterns, including but not limited to specific time nodes, types of passenger flow data, or passenger flow conditions in a specific area.

[0112] S44. Based on the predicted user query demand, some data related to the predicted demand is pre-loaded from the unified data retrieval table into the cache.

[0113] Based on the prediction of user query needs, some data related to these predicted needs will be pre-loaded from the unified data retrieval table into the cache. The advantage of this is that when the user initiates an actual query request, if the required data is already in the cache, the retrieval speed will be greatly accelerated.

[0114] S45. Using the constructed query statement and at least one query time node, first perform a dynamic screening operation in the cache. If the required data is not found in the cache, perform another screening in the unified data retrieval table to obtain the passenger flow data corresponding to the query time node.

[0115] Using the constructed query statement and the parsed query time node, the dynamic filtering operation is first performed in the cache. If the cache contains the data required by the user, the data is directly returned; if the required data is not found in the cache, the filtering operation will continue to be performed in the unified data retrieval table to obtain the passenger flow data corresponding to the query time node and return it to the user.

[0116] S46. According to the data types and screening frequencies corresponding to different times in the re-screening, a user historical query record and behavior pattern are formed.

[0117] Furthermore, after step S4, the method further includes:

[0118] A41. Create a centralized data sharing platform to receive passenger flow data from different data sources.

[0119] In order to integrate passenger flow data from different data sources, a centralized data sharing platform is created. This platform can receive and store passenger flow information from various data sources, and realize centralized management and unified access to data. Through centralized data sharing, the integrity, consistency and real-time nature of the data can be ensured, providing a solid foundation for subsequent data analysis and visualization.

[0120] A42. The passenger flow data obtained from the centralized data sharing platform will be organized in tables, charts or other visual forms and displayed to users through the user interface.

[0121] It is worth noting that on the centralized data sharing platform, the passenger flow data from new data sources and historical passenger flow data share a data interface. This means that both newly added data sources and existing historical data can be accessed and queried through the same interface. This not only simplifies the complexity of data access, but also improves data interoperability and scalability.

[0122] In addition, an embodiment of the present invention provides an integrated method for sharing scenic spot passenger flow data based on time node division, including:

[0123] The receiving and identifying module is used to receive the incoming passenger flow data and automatically identify the source of the passenger flow data by analyzing the type, structure and feature information of the passenger flow data.

[0124] The integration and governance module is used to automatically integrate the passenger flow data of the new data source with the historical passenger flow data when a new data source is connected, and to perform independent data governance on the passenger flow data of the new data source and the historical passenger flow data respectively.

[0125] The data acquisition table forming module is used to logically integrate and / or separate the preliminary integrated data including the passenger flow data of the new data source that has been governed and the historical passenger flow data according to the user's time configuration requirements using preset logical statements to form a unified data acquisition table.

[0126] The screening and returning module is used to respond to a user's request containing at least one query time node, and dynamically screen and return the passenger flow data corresponding to at least one query time node from the unified data retrieval table.

[0127] Furthermore, an embodiment of the present invention provides an integrated system for sharing scenic spot passenger flow data based on time node division, including: at least one database; and a memory communicatively connected to the at least one database; wherein the memory stores instructions that can be executed by at least one database, and the instructions are executed by at least one database so that at least one database can execute the integrated method for sharing scenic spot passenger flow data based on time node division as described above.

[0128] The embodiment of the present invention provides an innovative integrated system for sharing scenic spot passenger flow data based on time node division. The system architecture includes at least one database and a memory connected to the database. In this system, the database assumes the core functions of data storage and processing, while the memory is responsible for storing the instruction set that can be executed by the database.

[0129] Specifically, the instructions stored in the memory are specially designed to execute the integrated method of sharing scenic spot passenger flow data based on time node division. When these instructions are executed by the database, the system can implement a series of complex data processing operations, including but not limited to receiving and parsing the time node information in the user request, dynamically filtering and returning passenger flow data according to the time node, and predicting user query needs and optimizing data retrieval efficiency.

[0130] The advantage of this system lies in its highly integrated and automated data processing capabilities. Through an integrated approach, the system not only simplifies the management process of passenger flow data, but also improves the availability and real-time nature of the data. In addition, since the system can finely divide and share data based on time nodes, it provides strong data support for multiple fields such as scenic area management, tourism planning, and public safety monitoring.

[0131] Therefore, the integrated scenic spot passenger flow data sharing system based on time node division provided by the embodiment of the present invention realizes the intelligent processing and sharing of passenger flow data through the cooperation of efficient database and instruction set, which is of great significance for improving the operating efficiency and service quality of tourist attractions.

[0132] Furthermore, an embodiment of the present invention provides a computer-readable medium having computer executable instructions stored thereon, and when the executable instructions are executed by a processor, an integrated method for sharing scenic spot passenger flow data based on time node division as described above is implemented.

[0133] This computer-readable medium can be any form of physical storage medium, such as hard disks, optical disks, flash drives, etc., which have the ability to store and transfer data. When the instructions in these storage media are loaded into the processor and executed, they will guide the processor to complete a series of complex data processing tasks, including data collection, organization, analysis and sharing, all of which are based on the fine division of time nodes.

[0134] In this way, the present invention not only provides an efficient data processing method, but also enables this method to be easily transferred and implemented between different computer systems in the form of computer-readable media, thereby greatly enhancing its versatility and practicality. This innovative data storage and transmission method undoubtedly brings great convenience and efficiency improvement to the management and sharing of scenic spot passenger flow data.

[0135] In summary, the embodiments of the present invention provide an integrated method, system, device and medium for sharing scenic spot passenger flow data based on time node division. The core of the present invention is to build an integrated solution for sharing scenic spot passenger flow data based on time node division. The solution is verified through data integration and data sharing testing. It can merge or separate new and old data through logical statements or data management methods according to time nodes, thereby realizing the integration of new and old data in the same table or keeping them independent through logic. This processing method not only simplifies the process of data management, but also improves the efficiency and accuracy of data sharing.

[0136] At the same time, the present invention has specially added a time division setting function, so that users can select a specific time node through page configuration to obtain new and old indicators. This design avoids the physical merging of new and old data, reduces the complexity of data governance and the workload of rework. At the same time, new indicators and old indicators share a data interface, ensuring the uniformity and convenience of data sharing.

[0137] During the implementation process, the data table is screened and separated through logical statements to ensure that the new and old data remain logically separated but statistically unified. This processing method not only improves the accuracy of data analysis, but also enables the system to quickly adapt to data requirements at different time nodes, thereby enhancing the adaptability and flexibility of the system.

[0138] In general, the embodiments of the present invention significantly reduce the workload and complexity of data management and improve the efficiency and accuracy of data sharing by independently managing new and old data, adding time node screening functions, unifying data interfaces, and logical separation and screening, thereby providing strong support for the management and analysis of scenic spot passenger flow data.

[0139] Since the system / device described in the above embodiments of the present invention is a system / device used to implement the method of the above embodiments of the present invention, a person skilled in the art can understand the specific structure and deformation of the system / device based on the method described in the above embodiments of the present invention, and thus will not be described in detail here. All systems / devices used in the method of the above embodiments of the present invention belong to the scope of protection of the present invention.

[0140] It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as methods, systems or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Furthermore, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0141] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems) and computer program products according to embodiments of the present invention. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions.

[0142] It should be noted that in the claims, any reference numerals placed between brackets shall not be construed as limiting the claims. The word "comprising" does not exclude the presence of components or steps not listed in the claims. The word "a" or "an" preceding a component does not exclude the presence of a plurality of such components. The invention may be implemented by means of hardware comprising several different components and by means of a suitably programmed computer. In the claims enumerating several means, several of these means may be embodied by the same hardware. The use of the words first, second, third, etc., is for convenience of expression only and does not indicate any order. These words may be understood as part of the component name.

[0143] In addition, it should be noted that, in the description of this specification, the description of the terms "one embodiment", "some embodiments", "embodiment", "example", "specific example" or "some examples" etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present invention. In this specification, the schematic representations of the above terms do not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner. In addition, those skilled in the art may combine and combine the different embodiments or examples described in this specification and the features of the different embodiments or examples, unless they are contradictory.

[0144] Although the preferred embodiments of the present invention have been described, those skilled in the art may make other changes and modifications to these embodiments after knowing the basic creative concept. Therefore, the claims should be interpreted as including the preferred embodiments and all changes and modifications falling within the scope of the present invention.

[0145] Obviously, those skilled in the art can make various modifications and variations to the present invention without departing from the spirit and scope of the present invention. Thus, if these modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention should also include these modifications and variations.

Claims

1. A method for sharing scenic spot passenger flow data based on time node division, characterized in that: include: Receive incoming passenger flow data and automatically identify the source of passenger flow data by analyzing the type, structure and feature information of the passenger flow data; If a new data source is connected, the passenger flow data of the new data source will be automatically integrated with the historical passenger flow data, and independent data governance will be performed on the passenger flow data of the new data source and the historical passenger flow data respectively; According to the user's time configuration requirements, use preset logical statements to logically integrate and / or separate the preliminary integrated data including the passenger flow data of the new data source that has been governed and the historical passenger flow data to form a unified data acquisition table; In response to a user's request including at least one query time node, passenger flow data corresponding to at least one query time node is dynamically filtered and returned from the unified data retrieval table.

2. The integrated method for sharing scenic spot passenger flow data based on time node division according to claim 1 is characterized in that: Receive incoming passenger flow data and automatically identify passenger flow data sources by analyzing the type, structure, and feature information of the passenger flow data, including: By continuously monitoring the designated data receiving interface, the passenger flow data transmitted from the outside is received in real time; Use the preset data parsing library or function to analyze the header information or metadata of the passenger flow data to obtain the type of passenger flow data; Using a parser corresponding to the type of passenger flow data, extracting each data element from the passenger flow data, and constructing the structure of the passenger flow data based on the relationship between the data elements; By analyzing the distribution pattern, periodic changes and outliers of passenger flow data, characteristic information of passenger flow data can be extracted; Based on the parsed data type, structure and feature information, the source of the passenger flow data is automatically identified by comparing it with a data source feature library that pre-stores multiple feature descriptions of known data sources.

3. The integrated method for sharing scenic spot passenger flow data based on time node division according to claim 1 is characterized in that: When a new data source is connected, the passenger flow data of the new data source is automatically integrated with the historical passenger flow data, and independent data governance is performed on the passenger flow data of the new data source and the historical passenger flow data, including: When a new data source is detected, the passenger flow data of the new data source is loaded into a temporary data buffer or intermediate table; Connect the passenger flow data of the new data source in the temporary data buffer or intermediate table with the historical passenger flow data in time series to achieve preliminary integration; Independent data governance processes will be implemented for passenger flow data from new data sources and historical passenger flow data.

4. The integrated method for sharing scenic spot passenger flow data based on time node division according to claim 1 is characterized in that: According to the user's time configuration requirements, the preset logical statements are used to logically integrate and / or separate the preliminary integrated data of the passenger flow data including the new data source that has been governed and the historical passenger flow data to form a unified data acquisition table including: Receive the time configuration requirements configured by the user on the page, and obtain the configuration time node by parsing the time configuration requirements; Automatically select or construct integrated logic statements or separated logic statements according to the configured time nodes; Execute the integration logic statement to integrate the passenger flow data of the new data source under governance and the preliminary integrated data of the historical passenger flow data in an orderly manner according to the configured time nodes to achieve logical integration; Execute separation logic statements to separate the passenger flow data including the governed new data source and the preliminary integrated data of the historical passenger flow data into different parts according to the configured time nodes to achieve logical independence; A unified data retrieval table is formed based on logically integrated or separated data and stored in a preset centralized data sharing platform.

5. The integrated method for sharing scenic spot passenger flow data based on time node division according to claim 1 is characterized in that: In response to a user's request including at least one query time node, dynamically filtering and returning passenger flow data corresponding to at least one query time node from the unified data retrieval table includes: Receive a request sent by a user, and parse the request to obtain at least one query time node; Constructing a query statement according to at least one query time node; Predict user query needs by analyzing pre-recorded user historical query records and behavior patterns; Based on the predicted user query needs, some data related to the predicted needs is pre-loaded from the unified data retrieval table into the cache; Using the constructed query statement and at least one query time node, first perform a dynamic filtering operation in the cache. If the required data is not found in the cache, perform another filtering in the unified data retrieval table to obtain the passenger flow data corresponding to the query time node; According to the data types and filtering frequencies corresponding to different times in the re-screening, the user's historical query records and behavior patterns are formed.

6. The integrated method for sharing scenic spot passenger flow data based on time node division according to any one of claims 1 to 5, characterized in that: In response to a user's request including at least one query time node, after dynamically filtering and returning the passenger flow data corresponding to at least one query time node from the unified data retrieval table, the method further includes: Create a centralized data sharing platform to receive passenger flow data from different data sources; The passenger flow data obtained from the centralized data sharing platform is organized in tables, charts or other visual forms and displayed to users through the user interface.

7. The integrated method for sharing scenic spot passenger flow data based on time node division according to claim 6 is characterized in that: On the centralized data sharing platform, passenger flow data from new data sources and historical passenger flow data share a data interface.

8. An integrated method for sharing scenic spot passenger flow data based on time node division, characterized in that: include: The receiving and identifying module is used to receive the incoming passenger flow data and automatically identify the source of the passenger flow data by analyzing the type, structure and feature information of the passenger flow data; The integration and management module is used to automatically integrate the passenger flow data of the new data source with the historical passenger flow data when a new data source is connected, and to perform independent data management on the passenger flow data of the new data source and the historical passenger flow data respectively; A data acquisition table forming module is used to logically integrate and / or separate the passenger flow data including the governed new data source and the preliminary integrated data of the historical passenger flow data according to the user's time configuration requirements using preset logical statements to form a unified data acquisition table; The screening and returning module is used to respond to a user's request containing at least one query time node, and dynamically screen and return the passenger flow data corresponding to at least one query time node from the unified data retrieval table.

9. An integrated system for sharing scenic spot passenger flow data based on time node division, characterized in that: include: at least one database; and a memory in communication with at least one database; Among them, the memory stores instructions that can be executed by at least one database, and the instructions are executed by at least one database so that at least one database can execute an integrated method for sharing scenic spot passenger flow data based on time node division as described in any one of claims 1-7.

10. A computer-readable medium having computer-executable instructions stored thereon, characterized in that: When the executable instructions are executed by the processor, an integrated method for sharing scenic spot passenger flow data based on time node division as described in any one of claims 1 to 7 is implemented.