KR101056263B1 - Aircraft embedded system for flight simulation and test - Google Patents

Abstract

The present invention relates to an aircraft embedded system for flight simulation and test, a method for accessing a database thereof, and a recording medium storing a program according to the method. The present invention relates to a database access software for managing ICD data in a STEM for operating an AHB. By providing W), if STE is developing or modifying a project, it is possible to quickly insert, update, modify, and delete simulation / monitoring signals through the database access software, even if the ICD changes. Can be.

Flight, Aircraft, Simulation, Database, Access, Excel, Signal Interlocking Standards (ICD)

Description

Embedded System of Aircraft for Test and Flight Simulation

The present invention relates to an embedded system of aircraft (Flight Simulation & Test) and its database access method and a recording medium storing a program according to the method. For example, the present invention relates to an aircraft embedded system that manages ICD (Interface Control Document) data in a Software Test Environment (STEM) for operating Avionics Hot Bench (AHB), a method of accessing a database thereof, and a recording medium storing a program thereof. will be.

In general, after manufacturing the aircraft and before performing the test flight of the aircraft to check the operation of the equipment mounted in the aircraft to determine whether there is an abnormality, the aircraft to enable repair and replacement of the equipment in the event of an error Onboard equipment testing is mandatory.

In order to test the onboard equipment, the test apparatus is conventionally connected to the check terminals provided in the onboard equipment of the aircraft, and the test result data transmitted from each test apparatus is collected, and the normal operation of the onboard equipment is performed based on the data. Determine whether or not.

However, in such a case, since there is no system that can collectively control the operation and result collection of each test apparatus, the operator must operate each test apparatus to command the test of the onboard equipment one by one, and the test apparatus is transmitted from the test apparatus. The test results should be collected by the operator and analyzed by hand.

Therefore, it is difficult to obtain a reliable test result, which is time-consuming and reliable when performing onboard equipment test, and it is true that it is difficult to determine the abnormality using the test result data unless it is an operator who has expert knowledge in the analysis.

Therefore, there is an urgent need to develop an onboard equipment test operation system that enables the control of each test device according to the needs of the operator when testing the onboard equipment, and as a result, facilitates the collection and output of data. It became.

To this end, in the published vehicle-mounted equipment test operation system (hereinafter referred to as 'prior art 1') of Patent Publication No. 2005-0092608, the schedule of the test apparatuses in conjunction with the test apparatuses for testing the equipment mounted on the vehicle And collectively controlling operation commands, thereby facilitating collection and output of test result data.

In addition, the published real-time flight simulator interface generation system (hereinafter, referred to as 'Prior Art 2') of the published Patent Publication No. 2006-0004803 receives input of aircraft design data, and input / output data list of each part of the aircraft, mux data list, and the like. After loading, the data structure, modeling function call file, MUX database and scaling processing file are automatically generated as C and Fortran source code and transmitted to the real-time flight simulator. Only compilation was done to make the aircraft design data available.

In addition, the published mux dump data error check system of the published Patent Publication No. 2006-0004802 (hereinafter referred to as 'prior art 3') receives the mux dump data from the flight test of the aircraft input protocol check, update rate check and By automatically performing the bus list check and storing the result, it is possible to provide human and time advantages and increase reliability over conventional manual error check.

However, in a conventional aircraft embedded system such as the prior arts 1 to 3, simulation / monitoring signals related to STE are not databased. Therefore, when developing or modifying a project in STE, there is a problem that it takes a lot of time and manpower because the simulation / monitoring signal has to be manually created or modified.

In addition, when changing the ICD (Interface Control Document) there is a problem that takes a lot of time because the tracking of all signals and the search of the signals are made by manpower.

Therefore, there is an urgent need for database access software (S / W) that manages ICD data in STEM to operate Avionics Hot Bench (AHB).

The present invention has been proposed to solve the above technical problem, aircraft embedded system that provides a database access (S / W) software for managing ICD data in STEM for operating AHB (Avionics Hot Bench) and The object of the present invention is to provide a recording medium storing the database access method and the program according to the method.

In addition, another object of the present invention is to rapidly insert, update, and modify the simulation / monitoring signal through the database access software, even if a change in signal interworking specification (ICD) occurs while developing or modifying a project in STE. And an aircraft embedded system that can be deleted, a method for accessing a database thereof, and a recording medium storing a program according to the method.

Another object of the present invention is to provide an aircraft embedded system in which a simulation / monitoring signal related to STE is databased, a method of accessing the database thereof, and a recording medium storing a program according to the method.

In addition, another object of the present invention is to provide an aircraft embedded system that can insert and apply the ICD data in Excel format to the database, and a method for accessing the database and a recording medium storing the program according to the method There is.

In addition, another object of the present invention is to record the aircraft embedded system that can modify and delete the database (DB) in the STB window or insert a new database (DB) and its database access method and program stored therein To provide the medium.

Another object of the present invention is to provide an aircraft embedded system capable of outputting a part of the contents of a database in an Excel file format, a method for accessing the database thereof, and a recording medium storing a program according to the method.

Another object of the present invention is to provide an aircraft embedded system supporting a sorting function by a selected column of a list box in a database, a method for accessing the database thereof, and a recording medium storing a program according to the method. There is.

It is still another object of the present invention to provide an aircraft embedded system in which changes and applications of ICD can be updated immediately, a method of accessing a database thereof, and a recording medium storing a program according to the method.

Another object of the present invention is to provide an aircraft embedded system capable of automatically generating a simulation / monitoring signal through an established database, a method for accessing a database thereof, and a recording medium storing a program according to the method.

As a means for solving the above problems, the database access method of the aircraft embedded system according to the present invention comprises the steps of (a) installing a database access program; (b) accessing and logging in to the database access program; (c) outputting a database access window to the screen by the login; (d) accessing a database through the database access window; (e) outputting the contents of the database through a list box of the database access window and selecting a list; (f) querying and modifying a report box of the database access window with details of the list selected in the list box and adding and applying a new DB; (g) Input and output the contents copied from the list box or the report box in an Excel file format through the Excel box in the database access window, or copy the contents copied from the list box or the report box or another Excel file from the Excel box. Reading and further applying to the database; And (h) repeating the steps (d) to (g).

The database access window includes a DB access button for accessing the database; An update DB button for updating contents in the database; A delete button for deleting contents selected from the list box; An Excel copy button for copying contents selected from the list box and contents modified or added in the report box to the Excel box; And a list clear button for deleting the list (contents) output in the list box.

The report box comprises: a plurality of text boxes for inputting report contents for inquiring or modifying details of a list selected from the list box or adding a new DB; A DB apply button for applying the report contents entered in the text box to the database; A DB insert button for inserting report contents input in the text box into the database; An Excel copy button for copying the report content input in the text box to the Excel box; And a report clear button for deleting the report contents entered in the text box.

The Excel box may include: an Excel list box for outputting the contents copied from the list box or the report box to a screen in an Excel file format; A copy report button for copying the file selected in the Excel list box to the report box; An Excel clear button for deleting a file selected from the Excel list box; A DB insert button for inserting the file selected in the Excel list box into the first line of the database; A DB insert all button for inserting all the files selected in the Excel list box into the database; An Excel input button for inputting an external file (CSV file) into the Excel list box; And an Excel output button for outputting the selected Excel file to the Excel list box.

The Excel file format in step (g) is characterized in that the input and output as described in the database.

The Excel box is characterized in that the contents of the interface control document (ICD) made in the Excel file format is updated in the database as it is, and the changed or modified contents are immediately applied.

In addition, as a means for solving the above problems, the aircraft embedded system according to the present invention is a GUI (Graphic User) for performing the function and performance test of the OFP (Operation Flight Program) and each avionics in the mission computer of the avionics system Interface) includes database access software for signal interworking standard (ICD) between the LRU model, the database access software: query, modify, insert the contents stored in the database through a list box, and in the list box View, modify and insert the details of the selected list through the report box, input and output the contents copied from the list box or the report box from the Excel box to the Excel file format, and copy the contents or the other Excel from the Excel box. Reads the contents of the file into the database It is characterized in that it comprises a function to further apply.

delete

An aircraft embedded system for flight simulation and test according to the present invention, a method for accessing a database thereof, and a recording medium storing a program according to the method have the following effects.

1. Provide Database Access Software (S / W) to manage ICD data in STEM to run Avionics Hot Bench (AHB).

2. If STE is developing a project or if modifications are inevitable, the database access software can quickly insert, update, modify, and delete the simulation / monitoring signal even if the ICD changes.

3. Database simulation / monitoring signals related to STE.

4. You can insert and apply ICD data in Excel format to the database.

5. You can edit and delete the database or insert a new one in the STB window.

6. You can output a part of the database in an Excel file format.

7. You can support sorting function by selected column of List Box in database.

8. Changes and application of ICDs can be updated immediately.

9. It is possible to automatically generate simulation / monitoring signals through the built-in database.

Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings. In describing the embodiments of the present invention, the same reference numerals will be used for components having the same functions and functions.

Menu Configuration in STE Software

1 is a menu configuration diagram of flight simulation and test environment (STE) software of the aircraft embedded system according to a preferred embodiment of the present invention.

The STE software is software for avionic system integration test equipment. Software that controls and injects data and information of actual flight environment and avionics model among GUI (Graphic User Interface) software for performing function and performance test of OFP (Operation Flight Program) and each avionics equipment in avionics mission computer (S / W).

The STE provides an interface with a mission computer, and provides a GUI (Graphic User Interface) of STEM capable of real-time verification of each equipment signal by monitoring signals between the interfaces.

The STE software provides an environment for independently testing the OFPs loaded on the MC and a simulated environment for conducting testing at the avionics system level. In addition, it provides a test function to solve a specific operation mode or a defect during operation of the OFP under test. The STE software also provides the ability to monitor controlled inputs and outputs for the OFP under test.

Simulation & Test Environment (STE) software for verifying Operation Flight Program (OFP) in the avionics mission computer is shown in FIG. 1, Simulation Setup (10), Mission Setup (20). , Cockpit Simulation (30), Data Analysis (40), Data Injection (50), Automatic Test (60), Utility (70), Admin (80) It is composed of details, etc., in each category. The parent frame, the STE, operates as a main window, and a child frame is configured through a drop-down menu of the main window. The database access (100) of the present invention is one of several child frames. The database access is one of several child frames.

First, the simulation setup (Simulation Setup: 10) is a menu for setting the entire STE environment, setting the section load (unload) for the simulation control (Simuation Control), and various flight models (Avionics Model) ) Set On (Model) / Off (Real), Flight Model (Avionics Configuration) Detail Settings (AVSR Settings, Flight Test), Loading IMDC OFP Settings, Operation Log Output Steps (All, Error) , Warning, Clear) settings are included.

The mission setup 20 is a menu for setting an aircraft mission of STE, and includes functions such as target setting (air-to-air, air-to-air), DTE setting (flight path, and armament information).

The cockpit simulation 30 simulates cockpit instrument panel simulation, mission computer power on / off simulation, MFDS simulation, IUFC simulation, sidestick simulation. Features include settings, throttle simulations, and simulation of flight and mission instrument information.

The Data Analysis 40 can display, record, and retrieve all information of STE, and includes functions such as setting up a function simulation for algorithm verification.

The data injection (50) is a menu for controlling all data of the STE environment, and forcibly through mux, word, analog, and discrete through data patches. It also includes functions such as dynamic data injection and forced fault simulation via Mux.

The automatic test 60 includes a function of adjusting an aircraft through a signal simulator or using an autopilot function.

The utility 70 is a menu for providing a utility related to STE, and includes functions such as a calculator, a database access 100, and a joystick setting.

The Admin (Admin) 80 includes functions such as an administrator tool tool, H / W signal checking, automatic STE signal (CVT) conversion, database manipulation, and forced patching. .

Among the functions, the Database Access (100) is a software for the avionics system integrated test equipment, and is a GUI for performing the function and performance test of the Operation Flight Program (OFP) and each avionics equipment in the avionics mission computer. (Graphic User Interface) Software for signal interworking standard (ICD: Interface Control Document) between LRU models. The database access 80 supports the administrator mode in the addin submenu.

As shown in FIG. 2, the configuration of the database access software 100 includes a list box 120, a report box 130, an Excel box 140, and an internal input / output unit 150. And a database access window 110 including an external input / output unit 200 for inputting and outputting external files CVT and ICD.

Basically, the database access window 110 may query ICD (Interface Control Document) data stored in the database DB. And there is a function to reconnect the DB, there is an update function to apply the updated content (Update). In addition, the list selected from the list box 120 can be searched for the DB content through the report box 130, it is possible to modify the query or to add a new DB. In addition, a plurality of lists may be copied to the Excel box 140 to modify the selected contents.

The report box 130 may inquire the contents selected from the list box 120, modify the details, and apply a new DB.

The Excel box 140 may input and output the contents copied from the list box 120 or the report box 130 in an Excel file format. The Excel file format is input and output as listed in the DB. The function of the Excel box 140 can be immediately applied by updating the contents of the ICD data made in the Excel file format to the DB as it is.

If the project is under development or modification is inevitable in STE, the function can be quickly applied through the database access software even if the ICD changes. This function has a lot of advantages compared to the existing DB does not require a lot of time and manpower to modify the signal.

Hereinafter, the database access software according to the present invention will be described in more detail with reference to FIGS. 3 to 5.

Database Access Window

3 is a screen illustrating an embodiment of a database access window.

The database access window 110 is a screen provided through a login process when connected after installing the database access software.

The database access window 110, as shown in the screen of Figure 3, the list box 120 for loading and querying the contents of the DB, and the report for inquiring the contents of the DB or query the details of the list box 120 The box 130 and the contents copied from the list box 120 or the report box 130 are inputted and outputted in an Excel file format or added to the DB, and the input file in a CSV file format is added and applied to the DB. Excel box 140, and a plurality of other function buttons are included.

The plurality of function buttons may include a DB access button (Connect DB: 111) for accessing the DB, an update DB button (Updata DB: 112) for updating contents of the DB, and contents selected from the list box 120. Delete button (Delete: 113) to delete, and Excel copy button (To Excel :) to copy the selected content in the list box 120 and the content modified or added in the report box 130 to the Excel box (140) 114, a list clear button (List Clear 115) for clearing the list (contents) output to the list box 120, an exit button (EXIT) 116 for closing the database access window 110, and the database; It includes a help button (HELP) 117 that provides help for the access window 110.

The list box 120 retrieves the contents of the DB queried in the report box 130 and outputs a list to the screen. In this case, the list box 120 includes ID, MUXWORD_SPEC, D_NM, FRST_BIT, LAST_BIT, DETAIL_TYPE, DESCRIPTION, DETAIL_ID, MSB_VALUE, LSB_VALUE, DETAIL_UNIT, From RT, From_SA, To_RT, To_SA, Word, Rate, etc. Output In the list box 120, one or more desired lists may be selected from the inquired contents, and at least one list may be selected and copied to the Excel box 140.

The report box 130 may include a plurality of text boxes for inputting report contents to view or modify details of the list selected in the list box 120 or to add a new DB, and report contents input to the text box. DB to apply to the database (Apply to DB: 131), DB insert button to insert the report content entered in the text box (Insert DB: 132), and the report content entered in the text box An Excel copy button (To Excel: 133) for copying the data to the Excel box 140, and a report clear button (Report Clear: 134) for clearing the report content entered in the text box. Here, the text box is an ID, MUXWORD_SPEC, D_NM, FRST_BIT, LAST_BIT, DETAIL_TYPE, DESCRIPTION, DETAIL_ID, MSB_VALUE, LSB_VALUE, DETAIL_UNIT, From RT, From_SA, To_RT, To_SA, as shown in the list box 120. It is configured to input Word, Rate, etc. In this case, the rate and the DETAIL_TYPE may be configured as a combo box.

The report box 130 functions to inquire details of the list box 120, and may modify or delete the content selected in the list box 120 and add a new DB.

The Excel box 140 includes an Excel list box for outputting the contents copied from the list box or the report box to the screen in an Excel file format, and a report copy button for copying a file selected from the Excel list box to the report box ( To Report: 141, an Excel Clear button for deleting a file selected in the Excel list box (Excel Clear: 142), and a DB Insert button for inserting the file selected in the Excel list box into the first line of the database (Insert DB: 143), an Insert DB All button for inserting all the files selected in the Excel list box into the database, and an Excel input button for inputting an external file (CSV file) into the Excel list box. 145) and an Excel output button (Export Excel: 146) for outputting the selected Excel file in the Excel list box. The. At this time, the Excel list box, like the list box 120 and the text box, has ID, MUXWORD_SPEC, D_NM, FRST_BIT, LAST_BIT, DETAIL_TYPE, DESCRIPTION, DETAIL_ID, MSB_VALUE, LSB_VALUE, DETAIL_UNIT, From RT, From_SA, To_RT, To_SA Outputs Word, Rate, etc.

The Excel box 140 reads an input file of a CSV file format and can be directly applied to the DB, and changes or modified contents can be immediately applied by directly inputting the contents of the ICD.

Data access software operation

4 and 5 are explanatory diagrams for explaining the operation of the database access software.

First, referring to FIG. 4, the database access software operates in conjunction with an SQL DB, and the SQL DB may be viewed, modified, added, or deleted through the database access software. In addition, the database access software may input and output the CVS file through the Excel box 140 of the database access window 110, and input the contents of the ICD as it is through the Excel format to change or modify the contents. You can update to SQL DB immediately.

Next, referring to FIG. 5, after installing the database access software, if the user logs in through a login process, the database access window 110 appears.

The database access window 110 may inquire the contents of the DB (or SQL DB) through the report box (see 130 of FIG. 3). At this time, the contents of the inquired DB are output through the list box (see 120 of FIG. 3). The report box 130 may query, modify or insert individual contents of the DB.

In addition, the database access window 110 may be input to the DB from the Excel box (see 140 of FIG. 3) through input and output of an external file (CSV file). In addition, in the Excel box 140, the contents of the ICD may be input as it is, and the changed or modified contents may be immediately applied.

6 is an operational flowchart of the database access software.

First, when logging in to the database access software (YES in step S10), the database access window 110 appears (step S20).

Then, the DB 210 is accessed through the database access window 110 to query the contents of the DB 210.

Here, the database access window 110 may update the DB through the report box 130 or the Excel box 140.

First, the method of updating through the report box 130 may be updated by inquiring details of the DB 210 and then modifying the contents or adding and applying a new DB (steps S30 and S40).

Next, the method of updating through the Excel box 140 may be updated by reading and copying the contents copied from the list box 120 or the report box 130 or another Excel file to the DB ( Steps S50 and S60). In this case, the Excel box 140 may input and output the contents copied from the list box 120 or the report box 130 in an Excel file format.

Database access method

7 is a flowchart illustrating a method of accessing a database of an aircraft embedding system according to an exemplary embodiment of the present invention.

The database access method is as follows.

First, after installing the database access software (step S110) and executing the program, a login screen (see FIGS. 4 and 5) appears. In this case, a login authentication process is performed by inputting a host IP, a user, a password, a database name, a database table, and the like on the login screen.

When logging in via the login screen (YES in step S120), the database access window 110 is output on the screen (step S130).

Then, the DB is accessed through the database access window 110 and the contents of the DB are inquired (step S140). At this time, the database access window 110 outputs the contents of the inquired DB through the list box 120 (step S150).

Next, a list is selected from among the contents (list) of the DB output to the list box 120 for inquiry, modification, deletion, etc. (step S160).

Next, the details of the list selected in the list box 120 are inquired through the report box 130, and if necessary, the contents are corrected or a new DB is additionally applied (step S170).

Thereafter, the contents copied from the list box 120 or the report box 130 are inputted and outputted in an Excel file format (step S180) through the Excel box of the database access window 110 or the Excel box 140. Reads the contents copied from the list box 120 or the report box 130 or another Excel file and further applies to the DB (step S190).

Finally, the steps S140 to S190 are repeated.

Accordingly, the aircraft embedded system according to the present invention, a method for accessing a database thereof, and a recording medium storing a program according to the method provide database access software (S / W) for managing ICD data in STEM for operating AHB. For example, if a project is being developed by STE or if modifications are inevitable, the database access software can quickly insert, update, modify, and delete the simulation / monitoring signal even if the ICD changes.

It will be apparent to those skilled in the art that various modifications and changes can be made in the present invention without departing from the spirit or scope of the present invention as defined by the appended claims. It will be appreciated that such modifications and variations are intended to fall within the scope of the following claims.

Although the present invention has been described using an aircraft embedded system for flight simulation and testing as an example, the present invention is not limited thereto and may be applied to all software and systems in which database access is performed.

1 is a menu diagram of the flight simulation and test environment software of a typical aircraft embedded system

2 is a block diagram of the database access software of the aircraft embedded system according to a preferred embodiment of the present invention

3 is a screen illustrating an embodiment of a database access window.

4 and 5 are explanatory diagrams for explaining the operation of the database access software.

6 is an operation flowchart of the database access software.

7 is a flowchart illustrating a method for accessing a database of an aircraft embedded system according to an exemplary embodiment of the present invention.

[Description of Code for Major Parts of Drawing]

10: Simulation Setup

20: Mission Setup

30: Cockpit Simulation

40: Data Analysis

50: Data Injection

60: Automatic Test

70: Utility

80: Admin

100: database access

110: database access window

111: Connect DB Button

112: Update DB Button

113: Delete Button

114: Excel Copy Button

115: List Clear Button

116: EXIT button

117: HELP button

120: List Box

130: Report Box

131: DB Apply Button

132: DB Insert Button

133: Excel Copy Button

134: Report Clear Button

140: Excel Box

141: Report Copy Button

142: Excel Clear Button

143: DB insert button

144: DB insert all button

145: Excel input button

146: Excel output button

150: internal input / output

200: External Input / Output

210: database

Claims (8)

delete delete delete delete delete delete In an aircraft embedded system for flight simulation and testing, Includes database access software for Signal Interoperability Standards (ICD) between LRU models of the Operation Flight Program (OFP) in the avionics system's mission computer and the Graphical User Interface (GUI) software for performing functional and performance testing of each avionics device. , The database access software is: View, modify and insert the contents stored in the database through the list box, and view, modify and insert the details of the list selected in the list box through the report box, and the contents copied from the list box or the report box. In and out of the Excel box in the form of an Excel file, including the function of reading the copied content or the contents of the other Excel file from the Excel box and apply it to the database, The aircraft embedded system for flight simulation and test, Simulation Setup (10), Mission Setup (20), Cockpit Simulation (30), Data Analysis (40), Data Injection (50), Automatic Test (Automatic Test) : 60), Utility (70), and Admin (80). The database access is included in the utility (Utility: 70), the aircraft embedded system, characterized in that supported in the administrator mode form in the sub-menu of the Admin (Admin: 80). delete

Images