Development of a database management system for a structural and parametric description of LTCC technology using ADO.NET
DOI: 10.34759/trd-2021-120-14
Аuthors
*, **PJSC Radiofizika, Geroev Panfilovtsev street, 10, Moscow, 125480, Russia
*e-mail: sudar1977@gmail.com
**e-mail: inspect09@yandex.ru
Abstract
Low temperature co-fired ceramic (LTCC) technology was chosen as the technology under study. Currently, LTCC technology has been widely used in various fields of electronics, especially for the production of microwave microcircuits of low and medium integration. This technology provides an inexpensive solution for mass production of electronic devices in telecommunications, medicine, automotive technology, military technology and other industries. During the implementation of LTCC technology, problems were identified related to the mutual influence of a large number of parameters at each stage of production on the quality of products. To improve the quality of the production of microwave components, a methodology of structural-parametric description (STR) of the LTCC technology is proposed. Based on this methodology, an MS Access database was developed. Access technology does not allow making multi-user, distributed systems; to solve this problem, it is proposed to use the database management system (DBMS) ADO.NET. Before Microsoft released the .NET framework, one of the main data access technologies used in applications was ADO (ActiveX Data Object). With the release of the .NET framework, ADO.NET became the successor to ADO. ADO.NET is a family of technologies that enable developers of .NET applications to interact with data using standard and structured approaches. ADO.NET manages both internal data (created in computer memory and used inside the application) and external data outside the application — for example, in a database or text files. Regardless of the data source, ADO.NET presents data in application code in tabular form, as rows and columns. When interacting with external data sources, ADO.NET can use disconnected data technology. With earlier technologies, developers typically created a persistent database connection and used various record-locking techniques to safely and correctly modify the data. With the advent of the Internet era, the strategy of maintaining open connections for each of the many concurrent HTTP requests to a web application has proven to be ineffective. For ADO.NET, the preferred strategy is to open the connection before the database query and close it immediately after the query is complete. The article discusses the structure of the ADO.NET framework of the Microsoft Visual Studio system, its main parameters and features. The ADO.NET architecture and parameters for establishing connections with external data sources are presented. The process of creating a database in the ADO.NET DBMS for the production of microwave components based on LTCC MS SQL Server is shown. ADO.NET manages both internal data (created in computer memory and used inside the application) and external data outside the application — for example, in a database or text files. Regardless of the data source, ADO.NET presents data in application code in tabular form, as rows and columns. The article discusses the structure of the ADO.NET framework of the Microsoft Visual Studio system, its main parameters and features. The ADO.NET architecture and parameters for establishing connections with external data sources are presented. The process of creating a database in the ADO.NET DBMS for the production of microwave components based on LTCC MS SQL Server is shown.
Keywords:
ADO.NET technology, low temperature co-fired ceramics (LTCC), structural and parametric description, database, MS SQL ServerReferences
Potapov Yu.V. Tekhnologii v elektronnoi promyshlennosti, 2008, no. 3, pp. 59-64. URL:http://www.eurointech.ru/products/AWR/AWR_PrEl_1_2008.pdf
Tushnov P.A., Nevokshenov A.V., Kazakov A.V., Golubev A.V. Radiotekhnika, 2016, no. 10, pp. 52-63.
Lyapin L.V., Osipov A.V., Dalinger A.G. Elektronnaya tekhnika. Seriya 1: SVCh-tekhnika, 2017, no. 4 (535), pp. 28-43.
Anne Boehm, Ged Mead. Murachrsquo;s ADO.NET 4 Database Programming with C# 2010 (Murach: Training amp; Reference), 4th Edition, 756 p.
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
Simin A., Kholodnyak D. Komponenty i tekhnologii, 2005, no. 7 (51), pp. 208-213.
Chigirinskii S.A. Komponenty i tekhnologii, 2009, no. 11, pp. 130-131.
Sudarenko D.A., Lyutov A.V. Radiotekhnika, 2016, no. 4, pp. 45-48.
Thick film paste via fill composition for use in LTCC applications. Patent US 7722732, 2010.
Sudarenko D.A., Lyutov A.V. Radiotekhnika, 2017, no. 4, pp. 54-59.
Sudarenko D.A., Lyutov A.V. Radiotekhnika, 2019, vol. 83, no. 10 (15), pp. 58-64. DOI: 10.18127/j00338486-201910(15)-10
Kondratyuk R.I. Informatsionnyi byulletenrsquo; laquo;Stepenrsquo; integratsiiraquo;, 2011, no. 5, pp. 14-18.
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.
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. 156ndash;160. DOI:10.4071/1551-4897-5.4.156
Zakirova E.A. Issledovanie pechatnykh plat c mnogosloinymi dielektricheskimi podlozhkami i razrabotka mikropoloskovykh SVCh ustroistv na ikh osnove (Research of printed circuit boards with multilayer dielectric substrates and development of microstrip microwave devices based on them), authorrsquo;s abstract, Moscow, Vysshaya shkola ekonomiki, 2014, 24 p.
Sudarenko D.A. Issledovano v Rossii, 2002, no. 124, pp. 1381-1384. URL: http://zhurnal.ape.relarn.ru/articles/2002/124.pdf
Sudarenko D.A. Issledovano v Rossii, 2003, no. 201, pp. 2379ndash;2381. URL: http://zhurnal.ape.relarn.ru/articles/2003/201.pdf
Adzhibekov A.A., Zhukov A.A., Alekseev O.A. Trudy MAI, 2016, no. 87. URL: http://trudymai.ru/eng/published.php?ID=69728
Dudakov N.S., Makarov K.V., Timoshenko A.V. Trudy MAI, 2016, no. 90. URL: http://trudymai.ru/eng/published.php?ID=74844
Kuznetsov A.S., Kuznetsov S.N., Postnikova V.N. Trudy MAI, 2015, no. 83. URL: http://trudymai.ru/eng/published.php?ID=62218
Download