CN111061780B - Production data statistics and analysis system of air traffic control automation system - Google Patents
Production data statistics and analysis system of air traffic control automation system Download PDFInfo
- Publication number
- CN111061780B CN111061780B CN201911302947.7A CN201911302947A CN111061780B CN 111061780 B CN111061780 B CN 111061780B CN 201911302947 A CN201911302947 A CN 201911302947A CN 111061780 B CN111061780 B CN 111061780B
- Authority
- CN
- China
- Prior art keywords
- database
- information
- statistical
- subsystem
- server
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/02—Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]
Abstract
The invention provides a statistical and analytical system of production data of an automation system, which is deployed in a hardware environment and comprises: the interface subsystem is used for receiving control on-duty operation record information output by the OMSS system and information output by the tower electronic process single system and the air traffic control automatic system; the database subsystem comprises a basic database and a statistical database: the data recording subsystem acquires and analyzes the information sent by the interface subsystem and stores the information into a basic database; the statistical calculation engine is used for carrying out background statistical calculation on the data in the basic database and storing the data in the statistical database; and the Web subsystem exchanges information with the statistical database of the database subsystem so as to provide service for the browser terminal in a Web mode. The statistical and analysis system of the invention automatically forms flight flow statistical data such as waypoints, routes, sectors and the like, and analysis data such as system hardware running state, radar data quality and the like.
Description
Technical Field
The invention relates to an automation system, in particular to a statistical and analysis system for production data of the automation system.
Background
The air traffic control automation system is a computer system for assisting air command, processes data of air traffic control radar and flight plan, and provides various warning information to ensure air flight safety.
In order to deal with the rapid increase of the civil aviation flight flow, the air traffic control unit needs to ensure the flight safety and improve the flight efficiency by more means. The analysis of various control and equipment operation data, especially the analysis of various operation data of a large-scale regional control center, plays an important role in improving the operation efficiency, effectively evaluating the flow, reasonably setting the sector, analyzing the operation situation and the like.
As the most core equipment used by an operation department for implementing air traffic control, data processed by an air traffic control automation system can most truly reflect information such as control operation conditions, control frame number, flight density, airspace flow and the like. In the past, because the automation systems are mostly imported devices, the resources which can be output and utilized by the systems are very limited, and many statistics and analysis works are mostly carried out in an original manual statistics mode or through a flight information system and the like, and have certain deviation with the actual operation condition, so that the system is not favorable for carrying out accurate statistics and scientific operation situation analysis.
The air traffic control operation data are various in types and formats, and similar operation data statistical analysis tools or schemes in the air traffic control industry do not exist in the market at present. The former data are all artificially recorded and counted, certain human errors and time differences exist, the data accuracy is influenced,
disclosure of Invention
The invention aims to provide a production data statistical and analysis system of an automatic system, which is used for automatically forming flight flow statistical data of waypoints, airways, sectors and the like, and analysis data of system hardware operation state, radar data quality and the like.
In order to achieve the above object, the present invention provides a system for counting and analyzing production data of an automation system, which is deployed in a hardware environment of an office intranet, the hardware environment including an interface server, a database server connected to the interface server, a Web server, an application server, and a firewall connected to the Web server, the system comprising: the interface subsystem comprises an external interface processing module, is arranged on the interface server and the Web server, is set to receive control on-duty operation record information output by an OMSS system through the Web server, and receives information output by a tower electronic process single system and an air traffic control automation system through the interface server; a database subsystem, comprising a basic database and a statistical database deployed on a database server, wherein the basic database comprises flight dynamic information and tower electronic process information, and the statistical database comprises traffic statistical information: the data recording subsystem is deployed on the application server and is configured to acquire external input information sent by the external interface processing module, analyze the external input information and store the external input information into the basic database; the statistical calculation engine is used for carrying out background statistical calculation on the data in the basic database and storing the calculation result into the statistical database; and the Web subsystem is deployed on the Web server and exchanges information with the statistical database of the database subsystem so as to provide service for at least one browser terminal outside the hardware environment in a Web mode.
The interface subsystem includes: the preprocessing module is used for acquiring external input information sent by the external interface processing module, analyzing the external input information and sending normalized information; and the data recording module is set to acquire the normalized information sent by the preprocessing module and store the normalized information to different database tables in the basic database according to the information types.
The interface subsystem further comprises an internal interface processing module deployed on the interface server, the web server and the application server; the preprocessing module acquires external input information sent by the external interface processing module through the internal interface processing module, the data recording module acquires normalized information sent by the preprocessing module through the internal interface processing module, and the Web subsystem exchanges information with the statistical database of the database subsystem through the internal interface processing module.
The system for counting and analyzing the production data of the automation system also comprises a system management subsystem which comprises an authority management module, a log management module and a data management module.
The basic database and the statistical database are respectively deployed on a database server.
In another aspect, the present invention provides a method for statistics and analysis of production data of an automation system, including:
s1: the method comprises the steps that in the hardware environment of an office intranet is built, the hardware environment comprises an interface server, a database server, a Web server, an application server and a firewall, wherein the database server, the Web server and the application server are connected with the interface server, and the firewall is connected with the Web server;
s2: deploying an interface subsystem on the interface server and the Web server, deploying a database subsystem comprising a basic database and a statistical database on the database server, deploying the Web subsystem on the Web server, and deploying a data recording subsystem on the application server;
s3: the interface subsystem is adopted to receive control on-duty operation record information output by an OMSS system through the Web server, and receive information output by a tower electronic process single system and an air traffic control automation system through the interface server;
s4: acquiring external input information sent by an external interface processing module by adopting a data recording subsystem, analyzing and storing the external input information into a basic database;
s5: performing background statistical calculation on data in the basic database by adopting a statistical calculation engine, and storing a calculation result in a statistical database;
s6: and performing information exchange by adopting the Web subsystem and a statistical database of the database subsystem, thereby providing service for at least one browser terminal outside the hardware environment in a Web manner.
And in the step S4, the data recording subsystem acquires the external input information sent by the external interface processing module by using the preprocessing module, analyzes the external input information and sends normalized information, acquires the normalized information sent by the preprocessing module by using the data recording module, and stores the normalized information in different database tables in the basic database according to the information type.
In the step S3, the information output by the tower electronic process single system includes electronic process single state information, and the information output by the air traffic control automation system includes EFEED information, OASYS information, and JADE sector merging information; in step S4, the basic database includes flight dynamic information and tower electronic process information, the flight dynamic information records control operation information related to the aircraft from the EFEED information and the JADE sector merge information, and includes flight basic data, sector flight records, airline flight records, waypoint flight records, control operation records, seat records, and alarm records; and in the step S5, the statistical database includes flow statistical information, and the flow statistical information includes sector minute frame count, sector hour frame count, sector daily frame count, leg minute frame count, leg hour frame count, leg day frame count, waypoint minute frame count, waypoint hour frame count, waypoint day frame count, minute average frame count, minute peak frame count, hour average frame count, and hour peak frame count.
In step S5, the background statistics calculation includes sector statistics, leg statistics, and waypoint statistics, where the sector statistics use each flight entering and exiting sector from the EFEED information as a counting boundary condition, the leg statistics use each flight passing time and height in the EFEED information as a counting boundary condition, and the waypoint statistics use each flight passing time and height in the EFEED information as a counting boundary condition.
The step S6 includes:
s61: a user logs in a server page of the Web subsystem through a browser on a browser terminal;
s63: a user selects a statistical condition in a server page of the Web subsystem and sends the statistical condition to the Web subsystem, and the Web subsystem sends a corresponding query condition to the statistical database according to the statistical condition;
s64: and the statistical database sends the query result to a server page of the Web subsystem through the Web subsystem, and the server page of the Web subsystem displays the query result.
The main data source of the production data statistics and analysis system of the automation system is output data of an air traffic control automation system and other various data output servers. The server is transformed, a special port is configured, a data acquisition network is established, and data acquisition and pushing software can be developed and deployed on the server.
The production data statistical and analysis system of the automatic system automatically acquires basic data sources from each air traffic control operation system according to the characteristics of the air traffic control operation system, performs data fusion processing, combines a database technology to classify and format the data, and performs automatic statistics and analysis on the basis, so that the low efficiency and high error rate of the traditional manual statistics are avoided, meanwhile, the inaccuracy of statistics according to a single system data source is solved, and the reliability of a data statistical result is improved while the efficiency and accuracy of the air traffic control operation data statistical work are improved; the statistical and analytical system for the production data of the automatic system regulates the daily operation data acquisition work of each air traffic control automatic system through the design of a standardized database and the standardization of system record and output data, and lays a foundation for the statistical analysis and safety evaluation of normalized key data in the future by means of a corresponding interface conversion module; meanwhile, by developing a corresponding quantitative analysis tool, and carrying out quantitative analysis and calculation on the data such as the running load, the equipment pressure, the control flow and the like in the running process of the air traffic control automation system and the radar data quality and the like through the flight flow of the sector, the flight flow of the navigation waypoint and the change of the deviation value of each radar in the system log, and presenting the data in a chart form, the air traffic control automation system helps the running department and the construction department to continuously optimize the management program and the system configuration, relieves the risk and better ensures the running safety of the air traffic control equipment.
The invention arranges and analyzes various operation data and logs generated in and after the processing of the automatic system software, performs structured processing and then classifies the operation data and the logs into a warehouse, generates related statistical data according to various requirements of users, and pushes the statistical data to related users. On the basis, the operation situation of the system can be scientifically analyzed and predicted by combining with related historical data, and data support is provided for decisions such as seat and sector setting.
The invention leads the operation data of various air traffic control automation systems, and utilizes computer software and database technology to comprehensively process the data to finally form data statistics and analysis of the operation situation.
In addition, the invention can utilize any computer in the office network to remotely access and acquire statistical data through the web-based graphical interface access, thereby meeting the data requirements of control departments and technical departments, having simple and convenient operation, improving the convenience of software and improving the working efficiency.
Drawings
Fig. 1 is a schematic diagram of a hardware environment of a statistical and analysis system of production data of an automation system according to an embodiment of the invention.
FIG. 2 is a subsystem composition diagram of a statistical and analysis system of production data for an automation system, according to one embodiment of the invention.
Fig. 3 is a schematic diagram of a system for statistical and analysis of production data of an automation system according to an embodiment of the invention.
Fig. 4 is a software architecture diagram of a system for statistics and analysis of production data of an automated system according to one embodiment of the present invention.
Fig. 5 is a flow diagram of an external interface processing module of a statistical and analysis system of production data of an automation system according to an embodiment of the invention.
FIG. 6 is a flow diagram of a pre-processing module of a statistical and analysis system of production data of an automation system according to one embodiment of the invention.
Fig. 7 is a flow diagram of a data logging module of a statistical and analysis system of production data of an automation system according to an embodiment of the invention.
Fig. 8 is an entity relationship diagram of flight dynamics data of an automation system of a statistical and analysis system of production data of the automation system according to an embodiment of the invention.
Detailed Description
The present invention will be further described with reference to the following specific examples. It should be understood that the following examples are illustrative only and are not intended to limit the scope of the present invention.
Fig. 1 shows a system 100 for statistical and analysis of production data of an automation system according to an embodiment of the present invention, which is installed in a hardware environment 10 of an office intranet and employs a B/S architecture to access web servers through browsers to use various services of the system. The hardware environment 10 includes an interface server 1, a database server 2 connected to the interface server 1, a Web server 3 and an application server 4, and a firewall 5 connected to the Web server 2.
The interface server 1 (i.e. network switch) is used to build a system lan, and is connected to a tower electronic process list system 200 through a serial server 11, and is connected to an air traffic control automation system 300 through a gatekeeper 12.
The serial server 11 realizes the conversion between the serial protocol and the network protocol; the tower electronic progress list system 200 is a system for providing an electronic flight progress list for a tower controller, through which the tower controller can maintain and process the state and information of each flight, and the flight progress list is a record for recording the information and operation state of an aircraft by the controller, and includes flight numbers, airports, models, planning time and other information; the empty pipe automation system 300 is another system independent of the statistical analysis system of the present invention, and the external output of the production data of the empty pipe automation system 300 is realized through a gatekeeper 12 (e.g., an empty pipe production system data docking platform), so that the statistical and analysis system 100 of the production data of the automation system of the present invention can obtain the production data of the empty pipe automation system 300.
The database server 2 is arranged to run a system database management service; the database stores a plurality of database tables.
The Web server 3 is arranged to run Web services and statistical database management services.
The application server 4 is configured to run service application software for interface communication, data recording, data statistics, and the like.
The firewall 5 is used for security isolation between the system and an office network, and the Web server 2 is configured to be connected to an OMSS (operation and maintenance support system) system 400 outside the hardware environment 10, maintain operation of the Web server 2, and be configured to be connected to at least one browser terminal 500 outside the hardware environment 10 and provide services thereto in a Web manner.
Referring to fig. 2 to 3, which are block diagrams illustrating a structure of a system 100 for statistics and analysis of production data of an automation system according to the present invention, in order to implement functions of respective hardware in the hardware environment 10, the system 100 for statistics and analysis of production data of an automation system according to the present invention includes an interface subsystem 101, a data recording subsystem 102, a database subsystem 103, a statistics calculation engine 104, a Web subsystem 105, a system management subsystem 106, and the like. As shown in fig. 4, the statistical calculation engine 104 adopts an MVC design architecture and is dominated by C + + application services. The Web subsystem 105 adopts a J2EE design architecture, a SPING + HIBERNATE framework is taken as a core, and JAVA application service is taken as a main component. The deployment location and the main functions of the various subsystems are shown in table 1.
Table 1 subsystem deployment
As can be seen from table 1, the interface subsystem 101 includes an external interface processing module (eif) 1011 and an internal interface processing module (iiif) 1012, which are respectively used for implementing information exchange between the present system and an external system and information exchange between software modules inside the present system.
The external interface processing module 1011 is disposed on the interface server 1 and the Web server 3, and is configured to receive control on-duty operation record information output by the OMSS system (operation-oriented auxiliary system) 400 through the Web server 3, and receive electronic process single-state information output by the tower electronic process single system 200 and EFEED information (external data output interface of automation system), OASYS (system monitoring log) information, and JADE (JAVA-based system data acquisition) sector merging information output by the air traffic control automation system 300 through the interface server 1, so as to implement information exchange between the statistics and analysis system 100 of production data of the air traffic control automation system and the external three data source systems, i.e., the tower electronic process single system 200, the air traffic control automation system 300, and the OMSS system 6, where communication protocols of the information exchange all use IP protocols, the former is TCP/IP, and the latter is UDP/IP. The external interface processing module 11 employs Ace middleware, and uses an Acceptor (Acceptor) and a Connector (Connector) connection setup mode. For TCP, adopting a stream processing mode of ACE; for UDP, the datagram processing of ACE is used. The processing flow of the external interface is shown in fig. 5.
The internal interface processing module 1012 is deployed on the interface server 1, the web server 3 and the application server 4, and is used for implementing information interaction among software processes in the system. The module for performing information interaction with the internal interface processing module 1012 includes an external interface module 1011, a preprocessing module 1021, and a data recording module 1022. The internal interface processing module 12 adopts ICE middleware, adopts a message subscription/publishing mode of ICE Storm, and takes the application server 4 as an IceBOX server.
The data recording subsystem 102 is deployed on the application server 4, and includes a preprocessing module (ffp) 1021 and a data recording module 1022 (stcp). The data recording module 1022 is configured to obtain the external input information sent by the external interface processing module 1011 through the internal interface processing module 1012, analyze the external input information, and store the external input information in the basic database 1031 of the database subsystem 103 according to the information category.
The preprocessing module 1021 is deployed on the application server 4, and is configured to obtain the external input information sent by the external interface processing module 1011 through the internal interface processing module 1012, analyze the external input information according to the information specification of each external system, and then send the normalized information to the data recording module 1022 for further processing. The processing flow of the preprocessing module 1021 is shown in fig. 6.
The data recording module 1022 is deployed on the application server 4, and acquires the normalized information sent by the preprocessing module 1021 through the internal interface processing module 1012, and stores the normalized information on different database tables in the basic database of the database subsystem 103 according to the information category. The processing flow of the data recording module 1022 is shown in fig. 7.
The database subsystem 103 is disposed on the database server 2, and includes a basic database 1031 and a statistical database 1032, where the basic database 1031 and the statistical database 1032 are configured to store basic service data and statistical data of the system. In the present embodiment, the basic database 1031 and the statistical database 1032 are respectively deployed on one database server 2 according to the overall design requirements of the system. In other embodiments, base database 1031 and statistics database 1032 may also be deployed on the same database server 2.
The basic database 1031 includes flight dynamic information and tower electronic process information; the statistics database 1032 includes traffic statistics.
The flight dynamic information records control operation information related to the aircraft and output from the EFEED and the JADE, and mainly includes flight basic data, sector flight records, airline flight records, waypoint flight records, control operation records, seat records, alarm records, and the like, and the entity relationship is shown in fig. 8.
The control operation information which is output by the tower electronic progress list system and is related to the aircraft is recorded by the tower electronic progress information, and mainly comprises flight basic data, flight state records, runway traversing records, runway switching records and the like.
The flow statistical information comprises sector minute frame times statistics, sector hour frame times statistics, sector daily frame times statistics, flight segment minute frame times statistics, flight segment hour frame times statistics, flight segment daily frame times statistics, waypoint minute frame times statistics, waypoint hour frame times statistics, waypoint daily frame times statistics, minute average frame times, minute peak frame times, hour average frame times, hour peak frame times and the like.
The purpose of the background statistical calculation is to improve the response speed of the foreground query, and the background statistical calculation comprises the step of counting data of each object node in unit time in advance. The object nodes comprise sectors, flight segments and waypoints, and correspondingly, the background statistical calculation comprises sector statistics, flight segment statistics and waypoint statistics. The background computing is performed in a timing manner, and the object to be computed is the traffic statistic information, which includes:
sector minute frame (full, incremental, decrement, mean, peak);
sector hourly space (full, incremental, decrement, mean, peak);
daily number of sectors (gross);
leg number = ∑ (E) b >t 1 &&E a >＝t 0 )or∑(Ea>t 1 and E b >＝t 0 ) Wherein E is a Time of passing point a, E b To pass the b-point time, t 0 To count the start time, t 1 Is the end time of the statistics;
the number of the flight time minute is set (full, increment, decrement, average value and peak value);
the number of the racks in the flight period (full, increment, decrement, mean and peak);
the daily number of legs (gross);
leg number = ∑ (E) b >t 1 &&E a >＝t 0 )or∑(E a >t 1 and E b >＝t 0 ) Wherein E is a To pass the a point time, E b At the time point of passing b, t 0 To count the start time, t 1 Is the end time of the statistics;
setting for hours at waypoints;
daily setting of waypoints; and
number of passing waypoints = ∑ (E) i <t 1 and E o >= t 0), wherein E o At the time of fan-out, E i At the moment of entering the fan, t 0 To count the start time, t 1 Is the statistical end time.
The sector statistics are a summary of sector control frames at a given time, and the sector statistics use each flight in-sector and out-sector in the EFEED information from the air traffic control automation system 300 as a counting boundary condition.
The flight segment statistics is to summarize flight frames between two specified points, the flights flying over the points A and B are regarded as the flights counted in the flight segment, and the flight segment statistics takes the time and height of each flight passing point in the EFEED information as counting boundary conditions.
Waypoint statistics are summaries of the flight frame times for a given flying waypoint. The waypoint statistics use the time and height of each flight in the EFEED information as the counting boundary condition.
In addition, when the ROUTE point name is not given in the EFEED information but only the longitude and latitude, the ROUTE point information can be obtained from the system database table TB _ VSP _ ROUTE according to the ROUTE information and SID information in the plan information, and converted into a ROUTE point sequence according to the fixed point information in the TB _ VSP _ FIX table, and the corresponding fixed point name is found for the longitude and latitude in the EFEED information through time sequence comparison and position window matching calculation.
The Web subsystem 105 is disposed on the Web server 3, and exchanges information with the statistical database 1032 of the database subsystem 103 through the internal interface processing module 1012 of the interface subsystem 101, so as to provide a service for at least one browser terminal 500 outside the hardware environment 10 in a Web manner.
The data collection and statistical calculation are automatically processed on line in the background for 24 hours by 7 days. Therefore, after logging in the server page of the web subsystem 105 of the system through the browser of the intranet computer on the browser terminal 500, the service user selects the system function item, inputs or selects various statistical conditions, and obtains various statistical analysis results.
The man-machine interface style of the web server page is as follows:
1. can be compatible with various versions of browsers.
2. The login user information can be clearly indicated.
3. The screen display resolution can be self-adapted.
4. The default ranking order of the list is the time order of the received data, and the ranking can be supported.
5. If the page content is more and the scrolling display is needed, the scrolling is carried out in the data display area instead of the whole page scrolling, and the header area of the list is not scrolled (except for the report which is scrolled simultaneously in the vertical and horizontal directions).
6. And displaying the characters with indefinite length in the list in a left alignment mode, displaying the numerical values in a right alignment mode, and aligning according to decimal points when the decimal points exist. The fixed-length text (such as classification) and date data are displayed in alignment.
7. The input of the date: the input is selected through a calendar control.
8. If the selectable item is fixed and less (less than 5) is available for radio control input, if more or possibly expanded selectable items are available, then the select drop down list box is used.
9. When multiple items are selected for input or yes/no selection, a checkbox control is preferably selected when the number of items is small, and a multiple item selection list box can be selected when the number of items is large.
10. All operations can be performed using only the mouse except for inputting text, and menus, buttons, and all input/selection operations can be used using the keyboard. The function of the right button of the mouse is fully utilized to carry out quick operation.
11. The character data which can not be changed is input by adopting a common text input box, and the width of the text box should display the input content as completely as possible.
12. Text input box input, necessary input format prompt.
13. The input interface checks the input and directly positions the cursor to an illegal field for the user to modify.
14. There must be an explicit prompt when any operation request fails.
15. Important irreversible operation requests or a large number of time-consuming requests require user confirmation before submission. And after completion, the prompt of successful operation is provided.
The long-waiting requests have uniform and appropriate progress cues.
The system management subsystem 106 is configured to implement the operation and maintenance functions of the statistical and analysis system of the production data of the automation system of the present invention, and includes three modules of authority management, log management and data management.
As shown in fig. 4, based on the above-mentioned statistical and analysis system 100 for production data of an automation system, the implemented statistical and analysis method for production data of an automation system comprises the following steps:
a method for statistical and analytical of production data of an automation system, comprising:
step S1: in a hardware environment (10) of an office intranet is built, the hardware environment (10) comprises an interface server (1), a database server (2) connected with the interface server (1), a Web server (3), an application server (4) and a firewall (5) connected with the Web server (2);
step S2: deploying an interface subsystem (101) on the interface server (1) and the Web server (3), deploying a database subsystem (103) comprising a basic database (1031) and a statistical database (1032) on the database server (2), deploying the Web subsystem (105) on the Web server (3), and deploying a data recording subsystem (102) comprising a preprocessing module (1021) and a data recording module (1022) on the application server 4;
and step S3: the interface subsystem (101) is adopted to receive control duty operation record information output by an OMSS system (400) through the Web server (3), and receive electronic process list state information output by a tower electronic process list system (200) and EFEEED information, OASYS information and JADE sector merging information output by an air traffic control automation system (300) through the interface server (1);
and step S4: the method comprises the steps that a preprocessing module (1021) is adopted to obtain external input information sent by an external interface processing module 1011, analysis is carried out, normalized information is sent, a data recording module 1022 is adopted to obtain the normalized information sent by the preprocessing module 1021, and the normalized information is stored in different database tables in a basic database 1031 according to information types;
wherein the basic database 1031 includes flight dynamic information and tower electronic process information; the flight dynamic information records control operation information which is output by EFEED information and JADE sector merging information and is related to the aircraft, and mainly comprises flight basic data, sector flight records, airline flight records, waypoint flight records, control operation records, seat records, alarm records and the like; the control operation information which is output by the tower electronic progress list system and is related to the aircraft is recorded by the tower electronic progress information, and mainly comprises flight basic data, flight state records, runway traversing records, runway switching records and the like.
Step S5: performing background statistical calculation on data in the basic database (1031) by using a statistical calculation engine (104), and storing a calculation result in a statistical database (1032);
the statistical database 1032 includes flow statistical information, where the flow statistical information includes sector minute frame count, sector hour frame count, sector day frame count, leg minute frame count, leg hour frame count, leg day frame count, waypoint minute frame count, waypoint hour frame count, waypoint day frame count, minute average frame count, minute peak frame count, hour average frame count, hour peak frame count, and the like.
Further, as described above, the background statistics calculation includes sector statistics, segment statistics, and waypoint statistics, the sector statistics having as counting boundary conditions each flight in-sector and out-sector in the EFEED information from the air traffic control automation system 300, the segment statistics having as counting boundary conditions each flight passing time, height in the EFEED information, and the waypoint statistics having as counting boundary conditions each flight passing time, height in the EFEED information.
Therefore, the invention carries out quantitative analysis and calculation on the data of the operation load, the equipment pressure, the control flow and the like, the radar data quality and the like in the operation process of the air traffic control automation system through developing a corresponding quantitative analysis tool and through the flight flow of the sector, the flight flow of the navigation route point and the change of the deviation value of each radar in the system log, and presents the data in a chart form to help the operation department and the construction department to continuously optimize the management program and the system configuration, relieve the risk and better ensure the operation safety of the air traffic control equipment.
Step S6: the Web subsystem 105 is used for exchanging information with the statistical database 1032 of the database subsystem 103, so as to provide services for at least one browser terminal 500 outside the hardware environment (10) in a Web manner.
The step S6 includes:
step S61: a user logs in a server page of the Web subsystem (105) through a browser on the browser terminal 500;
step S63: a user selects a statistical condition from a server page of the Web subsystem 105 and sends the statistical condition to the Web subsystem 105, and the Web subsystem 105 sends a corresponding query condition to the statistical database 1032 according to the statistical condition;
step S64: the statistical database sends the query result to the server page of the Web subsystem 105 via the Web subsystem 105, and the server page of the Web subsystem 105 shows the query result.
The above description is only a preferred embodiment of the present invention, and is not intended to limit the scope of the present invention, and various modifications may be made to the above-described embodiment of the present invention. All simple and equivalent changes and modifications made according to the claims and the content of the specification of the present application fall within the scope of the claims of the present patent application. The invention has not been described in detail in the conventional technical content.
Claims (10)
1. A statistical and analysis system (100) of production data of an automation system, deployed in a hardware environment (10), the hardware environment (10) comprising an interface server (1), a database server (2) connected to the interface server (1), a Web server (3) and an application server (4), and a firewall (5) connected to the Web server (2), characterized in that the statistical and analysis system (100) comprises:
an interface subsystem (101), including an external interface processing module (1011), disposed on the interface server (1) and the Web server (3), configured to receive the control on-duty operation record information output by an OMSS system (400) through the Web server (3), and receive the information output by a tower electronic process list system (200) and an air traffic control automation system (300) through the interface server (1);
a database subsystem (103) comprising a base database (1031) and a statistics database (1032) deployed on a database server (2), the base database (1031) comprising flight dynamics information and tower electronic process information, the statistics database (1032) comprising traffic statistics information:
the data recording subsystem (102) is deployed on the application server (4), is configured to acquire external input information sent by the external interface processing module (1011), analyze the external input information and store the external input information into the basic database (1031);
a statistical calculation engine (104) configured to perform background statistical calculation on the data in the basic database (1031), and store the calculation result in the statistical database (1032);
and the Web subsystem (105) is deployed on the Web server (3) and exchanges information with the statistical database (1032) of the database subsystem (103) so as to provide services for at least one browser terminal (500) outside the hardware environment (10) in a Web manner.
2. Statistical and analysis system (100) of production data of an automation system according to claim 1, characterised in that the interface subsystem (101) comprises:
the preprocessing module (1021) is used for acquiring the external input information sent by the external interface processing module (1011), analyzing and sending the normalized information; and
and the data recording module (1022) is used for acquiring the normalized information sent by the preprocessing module (1021) and storing the normalized information into different database tables in the basic database (1031) according to the information types.
3. The system (100) for the statistical and analysis of production data of automation systems according to claim 1, characterised in that the interface subsystem (101) further comprises an internal interface processing module (1012) deployed on the interface server (1), web server (3) and application server (4); the preprocessing module (1021) acquires external input information sent by the external interface processing module (1011) through the internal interface processing module (1012), the data recording module (1022) acquires normalized information sent by the preprocessing module (1021) through the internal interface processing module (1012), and the Web subsystem (105) exchanges information with the statistical database (1032) of the database subsystem (103) through the internal interface processing module (1012).
4. The system (100) for the statistical and analysis of production data of an automation system according to claim 1, characterised in that it further comprises a system management subsystem (106) comprising a rights management module, a log management module and a data management module.
5. Statistical and analysis system (100) of production data of an automation system according to claim 1, characterised in that the base database (1031) and the statistical database (1032) are deployed on one database server (2) respectively.
6. A method for statistical and analytical of production data of an automation system, comprising:
step S1: in a hardware environment (10) of an office intranet is built, the hardware environment (10) comprises an interface server (1), a database server (2) connected with the interface server (1), a Web server (3), an application server (4) and a firewall (5) connected with the Web server (2);
step S2: deploying an interface subsystem (101) on the interface server (1) and the Web server (3), deploying a database subsystem (103) comprising a basic database (1031) and a statistical database (1032) on the database server (2), deploying the Web subsystem (105) on the Web server (3), and deploying a data recording subsystem (102) on the application server (4);
and step S3: the interface subsystem (101) is adopted to receive control on-duty operation record information output by an OMSS system (400) through the Web server (3), and receive information output by a tower electronic process single system (200) and an air traffic control automation system (300) through the interface server (1);
and step S4: acquiring external input information sent by an external interface processing module (1011) by using a data recording subsystem (102), analyzing and storing the external input information into a basic database (1031);
step S5: performing background statistical calculation on data in the basic database (1031) by using a statistical calculation engine (104), and storing a calculation result in a statistical database (1032);
step S6: and exchanging information with a statistical database (1032) of the database subsystem (103) by using the Web subsystem (105), so as to provide services for at least one browser terminal (500) outside the hardware environment (10) in a Web manner.
7. The statistical and analytical method for production data of automation systems according to claim 6, wherein the data recording subsystem (102) comprises a preprocessing module (1021) and a data recording module (1022), and in step S4, the data recording subsystem (102) uses the preprocessing module (1021) to obtain external input information sent by the external interface processing module (1011), analyzes and sends normalized information, uses the data recording module (1022) to obtain normalized information sent by the preprocessing module (1021), and stores the information in different database tables in the basic database (1031) according to information category.
8. The statistical and analytical method of production data of an automation system according to claim 6, wherein in the step S3, the information outputted from the tower electronic process control system (200) includes electronic process control status information, and the information outputted from the air traffic control automation system (300) includes EFEED information, OASYS information, and JADE sector merge information;
in step S4, the basic database (1031) includes flight dynamic information and tower electronic process information, the flight dynamic information records control operation information related to the aircraft from the EFEED information and the JADE sector merging information, and includes flight basic data, sector flight records, airline flight records, waypoint flight records, control operation records, seat records, and alarm records;
and in the step S5, the statistical database (1032) includes flow statistical information, where the flow statistical information includes sector minute frame count, sector hour frame count, sector daily frame count, leg minute frame count, leg hour frame count, leg daily frame count, waypoint minute frame count, waypoint hour frame count, waypoint daily frame count, minute average frame count, minute peak frame count, hour average frame count, and hour peak frame count.
9. The method of claim 8, wherein in the step S5, the background statistics calculation includes sector statistics, segment statistics and waypoint statistics, the sector statistics take each flight in-sector and out-sector from the EFEED information as a counting boundary condition, the segment statistics take each flight over-time and altitude in the EFEED information as a counting boundary condition, and the waypoint statistics take each flight over-time and altitude in the EFEED information as a counting boundary condition.
10. Method for the statistical and analytical analysis of production data of an automation system according to claim 6, characterised in that the step S6 comprises:
step S61: a user logs in a server page of the Web subsystem (105) through a browser on a browser terminal (500);
step S63: a user selects a statistical condition from a server page of the Web subsystem (105) and sends the statistical condition to the Web subsystem (105), and the Web subsystem (105) sends a corresponding query condition to the statistical database (1032) according to the statistical condition;
step S64: and the statistical database sends the query result to a server page of the Web subsystem (105) through the Web subsystem (105), and the server page of the Web subsystem (105) displays the query result.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911302947.7A CN111061780B (en) | 2019-12-17 | 2019-12-17 | Production data statistics and analysis system of air traffic control automation system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911302947.7A CN111061780B (en) | 2019-12-17 | 2019-12-17 | Production data statistics and analysis system of air traffic control automation system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111061780A CN111061780A (en) | 2020-04-24 |
| CN111061780B true CN111061780B (en) | 2023-03-31 |
Family
ID=70301974
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911302947.7A Active CN111061780B (en) | 2019-12-17 | 2019-12-17 | Production data statistics and analysis system of air traffic control automation system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111061780B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112241402A (en) * | 2020-10-16 | 2021-01-19 | 中国民用航空华东地区空中交通管理局 | Empty pipe data supply chain system and data management method |
| CN113821518B (en) * | 2021-11-24 | 2022-02-25 | 中航材导航技术（北京）有限公司 | Aviation information structured processing system |
| CN115880951A (en) * | 2022-10-28 | 2023-03-31 | 田晓东 | Implementation method and application system of 5D computer flight plan |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6161097A (en) * | 1997-08-11 | 2000-12-12 | The United Sates Of America As Represented By The Administrator Of The National Aeronautics And Space Administration | Automated traffic management system and method |
| CA2445220C (en) * | 2003-10-10 | 2009-03-17 | Nav Canada | Air traffic information display system |
| CN101546484A (en) * | 2009-04-30 | 2009-09-30 | 南京航空航天大学 | Flight delay conformance analysis and forecast system based on SOA and operation method thereof |
-
2019
- 2019-12-17 CN CN201911302947.7A patent/CN111061780B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN111061780A (en) | 2020-04-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111061780B (en) | Production data statistics and analysis system of air traffic control automation system | |
| US7571179B2 (en) | Method and apparatus for creation and maintenance of incident crisis response plans | |
| US7667582B1 (en) | Tool for creating charts | |
| US6980978B2 (en) | Site integration management system for operational support service in an internet data center | |
| US6768994B1 (en) | Web based data mining and location data reporting and system | |
| US6732027B2 (en) | System and method of analyzing operational source data | |
| US10195708B2 (en) | Method and apparatus for centralized compliance, operations and setup of automated cutting tool machines | |
| EP1895376A2 (en) | Dynamic maintenance management system | |
| JP2017151975A (en) | Visualization of aggregated maintenance data for aircraft reliability program | |
| CN105447681B (en) | Physical and chemical detection control and information management system | |
| US10510044B2 (en) | Project management system providing digital form-based inspections in the field | |
| CN101536002A (en) | System and method for process monitoring | |
| US7069121B1 (en) | Computerized method for integration and facilitating single source access to user community messaging transport vehicle location status, vehicle maintenance requirement and service procedures | |
| CN105160724A (en) | Dangerous-chemical-enterprise key device inspection system based on mobile phone APP | |
| US11809446B2 (en) | Visualizing time metric database | |
| CN115375172A (en) | BIM-based intelligent operation and maintenance method and system | |
| CN115640300A (en) | Big data management method, system, electronic equipment and storage medium | |
| US10981586B2 (en) | Railway diagnostic systems and methods | |
| US20140324508A1 (en) | Business service management system | |
| CN116624226A (en) | Coal mine disaster data acquisition, analysis and visual display system | |
| CN101980212A (en) | Aviation electronic checklist and implementation method thereof | |
| Tang et al. | MEADEP and its applications in evaluating dependability for air traffic control systems | |
| US20020178188A1 (en) | Productivity recovery and improvement software | |
| US9342522B2 (en) | Computer implemented system for analyzing a screen-based user session of a process in a network environment | |
| JP2002258939A (en) | Data analysis supporting device and data analysis supporting method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |