Compare of technology ADO.NET and SQLite for the development of LTCC structural-parametric description database

DOI: 10.34759/trd-2022-124-22

Аuthors

Sudarenko D. A.^*, Kakadei M. S.^**, Yazykov A. A.^***

PJSC Radiofizika, Geroev Panfilovtsev street, 10, Moscow, 125480, Russia

*e-mail: sudar1977@gmail.com
**e-mail: lady_mary_1602@mail.ru
***e-mail: anton199_999@mail.ru

Abstract

The technology of low-temperature co-fired ceramics (LTCC) is considered. This technology provides an inexpensive solution in the mass production of electronic devices in the field of telecommunications, medicine, automotive technology, military equipment, aerospace and other industries.

In the process of implementing LTCC technology, difficulties were identified associated with the influence of a large number of parameters depending on the components used, the time of use and configuration of equipment at each stage of production on the quality of products.

The parameters of technological operations (TO) are highlighted, grouping is made according to the characteristics of parameters: resource, process, result, control and management.

In real life, there is no system that would collect all of the above parameters together, compare them and give recommendations for improving quality.

In this paper, a method for creating, describing and modeling parameters in the form of information support based on a structural parametric description (SPO) according to regulatory documentation is proposed to improve the quality of production of microwave components.

Based on this classification, workplace models are built, and the data is aggregated into the MS Access database management System (DBMS).

Since Access has a number of disadvantages and is not, in fact, a full-fledged database, technologies were considered as a DBMS ADO.NET from Microsoft (the Sharp C language framework) and the Qt SQLite framework (in C++).

ADO.NET manages both internal data (created in computer memory and used inside the application), and external, located outside the application — for example, in a database or text files.

The Qt framework contains a universal interface for working with various databases. Databases in the Qt view are drivers for the QtSql module. By default, when installing the framework, the SQLite database is available, for the rest of the databases, installation and assembly of drivers for Qt is required.

A comparative analysis of these databases has been carried out, on the basis of which it can be assumed that the SQLite DBMS is suitable for prototyping at the initial stage and cross-platform applications, and the DBMS ADO.NET it is more complex, but more promising in terms of commercial use.

Keywords:

low-temperature co-fired ceramics, MS Access, ADO.NET technology, SQLite technology, structural-parametric description, database management system

References

1. Potapov Yu.V. Tekhnologii v elektronnoi promyshlennosti, 2008, no. 3, pp. 59-64.
2. Sudarenko D.A., Lyutov A.V. Radiotekhnika, 2016, no. 4, pp. 45-48.
3. Sudarenko D.A., Lyutov A.V. Radiotekhnika, 2019, vol. 83, no. 10 (15), pp. 58-64. DOI: 10.18127/j00338486-201910(15)-10
4. Anne Boehm, Ged Mead. Murachr s ADO.NET 4 Database Programming with C# 2010 (Murach: Training amp; Reference), 4th Edition, 756 p.
5. Litschke O., Simon W., Holzwarth S. A 30 GHz highly integrated LTCC antenna element for digital beam forming arrays, Conference proceedings APS 2006. Washington, 2006. DOI:10.1109/APS.2005.1552498
6. Kondratyuk R.I. Informatsionnyi byulleten’ «Stepen’ integratsii», 2011, no. 5, pp. 14-18.
7. Uhlig P., Holzwarth S., Litschke O., Simon W., Baggen R. A Digital Beam-Forming Antenna Module for a Mobile Multimedia Ter minal in LTCC Multilayer Technique, EMPS 2005, 12 — 15 June 2005, Belgium, Brugge, pp. 467-470.
8. Uhlig P., Manteuffel D., Malkmus S. High Layer Count in LTCC Dual Band Antenna for Galileo GNSS/CICMT, Journal of Microelectronics and Electronic Packaging, 2008, no. 5 (4), pp. 156-160. DOI:10.4071/1551-4897-5.4.156
9. Maks Shlee. Qt 5.10. Professional’noe programmirovanie na C++ (Рrofessional programming on С++), Saint Petersburg, BKhV-Peterburg, 2018, pp. 601-613.
10. Dudakov N.S., Makarov K.V., Timoshenko A.V. Trudy MAI, 2016, no. 90. URL: http://trudymai.ru/eng/published.php?ID=74844
11. Sudarenko D.A. Trudy MAI, 2021, no. 121. URL: https://trudymai.ru/eng/published.php?ID=162670. DOI: 10.34759/trd-2021-121-23
12. Sudarenko D.A., Lyutov A.V. Trudy MAI, 2020, no. 120. URL: https://trudymai.ru/eng/published.php?ID=161428. DOI: 10.34759/trd-2021-120-14
13. Advantages of Database Management System. URl: https://www.tutorialspoint.com/Advantages-of-Database-Management-System
14. Breaking changes in .NET 5. URL: https://docs.microsoft.com/en-us/dotnet/core/compatibility/5.0
15. ADO.NET. URL: https://docs.microsoft.com/enus/dotnet/framework/data/adonet
16. Laguta A.S. Studencheskii forum, 2021, no. 13-2 (149), pp. 32-33.
17. Brekhov O.M., Tin M.A. Trudy MAI, 2015, no. 84. URL: https://trudymai.ru/eng/published.php?ID=63151
18. Kuznetsov S.D. Osnovy sovremennykh baz dannykh (Fundamentals of modern databases), Moscow, Internet-universitet informatsionnykh tekhnologii, 2007, 484 p.
19. Aiman D.A., Krasnyi I.B., Danilov V.S. Kumacheva S.A. Doklady Akademii nauk vysshei shkoly Rossiiskoi Federatsii, 2017, no. 1 (34), pp. 31-45. DOI: 10.17212/1727-2769-2017-1-31-45
20. Baskin V.A., Bryunin A.V., Bryunin V.N., Morenko A.V., Sudarenko D.A. Elektronnaya tekhnika. Ser. 3. Nano- i mikroelektronika, 2005, no. 1 (157), pp. 5-8.

Download