Efficient approach to database integration for an aerospace vehicle design and certification framework

Abstract The integration of distributed data sources is one of the main problems of engineering software. The data integration process for a heterogeneous legacy system is a key aspect of the development of a computerized system and in the integration of a design framework. In this research, our approach to data integration focuses on developing system-building techniques for efficient data integration queries. Keyword-based data searching is investigated and applied within a database for a design framework. A database table connector (DTC) wrapper program is implemented based on the use of data integration processes and keyword-based searching. The DTC provides data integration for various data resources from legacy programs and database management systems using SQL querying. The DTC enables designers and developers to rapidly and efficiently develop integration frameworks for different data resources. This paper also describes the implementation and deployment of the Certification and Aircraft Design Integration System framework, which integrates various analysis and optimization codes, computer-aided design software and database management systems. Multiple data types are used within the framework, including databases, spreadsheets, flat files, XML files and personal data management. Several aircraft design and optimization problems are successfully solved using the developed framework.

[1]  T Haftka Raphael,et al.  Multidisciplinary aerospace design optimization: survey of recent developments , 1996 .

[2]  Stuart E. Madnick,et al.  Working Paper Alfred P. Sloan School of Management Database Systems in a Dynamic Environment Database Systems in a Dynamic Environment Received Context Interchange: Overcoming the Challenges of Large-scale Interoperable Database Systems in a Dynamic Environment* , 2022 .

[3]  Joann J. Ordille,et al.  Data integration: the teenage years , 2006, VLDB.

[4]  Jae-Woo Lee,et al.  Process of establishing design requirements and selecting alternative configurations for conceptual design of a VLA , 2017 .

[5]  Klaus R. Dittrich,et al.  Data Integration — Problems, Approaches, and Perspectives , 2007 .

[6]  Jae-Woo Lee,et al.  Multidisciplinary Unmanned Combat Air Vehicle system design using Multi-Fidelity Model , 2013 .

[7]  Maurizio Lenzerini,et al.  Data integration: a theoretical perspective , 2002, PODS.

[8]  Carsten Binnig,et al.  A framework for testing DBMS features , 2010, The VLDB Journal.

[9]  Alon Y. Levy The Information Manifold Approach to Data Integration , 2007 .

[10]  Gio Wiederhold,et al.  Mediators in the architecture of future information systems , 1992, Computer.

[11]  Sangho Kim,et al.  A distributed Web-based framework for helicopter rotor blade design , 2012, Adv. Eng. Softw..

[12]  Jae-Woo Lee,et al.  Database Adaptive Fuzzy Membership Function Generation for Possibility-Based Aircraft Design Optimization , 2017 .

[13]  Laura M. Haas,et al.  Clio: Schema Mapping Creation and Data Exchange , 2009, Conceptual Modeling: Foundations and Applications.

[14]  Calixto Maldonado,et al.  Development of a relational database management system , 2003 .

[15]  Laura M. Haas,et al.  Towards heterogeneous multimedia information systems: the Garlic approach , 1995, Proceedings RIDE-DOM'95. Fifth International Workshop on Research Issues in Data Engineering-Distributed Object Management.

[16]  Jeffrey D. Ullman,et al.  Capability based mediation in TSIMMIS , 1998, SIGMOD '98.

[17]  Michael Lesk How Can We Get High-Quality Electronic Journals? , 1998 .

[18]  Jungwon Yoon,et al.  Development of Airworthiness-Design Integration System for FAR 23 Class Aircraft , 2010 .

[19]  Jae-Woo Lee,et al.  Development of Airworthiness Database System with Validation Process for Design Programs of General Aviation Aircraft , 2012 .

[20]  Jae-Woo Lee,et al.  Investigations on stability and control characteristics of a CS-VLA certified aircraft using wind tunnel test data , 2016 .