Development of a database management system for a structural and parametric description of LTCC technology using QT SQLITE
The low temperature co-fired ceramic (LTCC) technology was selected as the technology under study. This technology has found wide application for the manufacture of RF and microwave microcircuits of low and medium degree of integration and can be applied in various industries such as telecommunications, medicine , automotive, military and space technology. Variable data of LTCC technology (sheet sizes, pastes naming, time, equipment setup, and others) are scattered throughout the documentation. The number of documents and procedures for production, control and management is quite large. The presented article proposes a method of structural-parametric description of the LTCC technology to improve the quality of the of microwave components production. Based on this method, a database based on MS Access was developed. The MS Access database has a number of disadvantages, since it is non-networked and does not allow making multi-user systems. These problems are being solved by the SQLite DBMS, which will be discussed in detail in this article. The process of a database creating in the SQLite DBMS for the microwave components production developed on the Qt framework is proposed. SQLite is a C ++ Qt framework library that implements a small, fast, self-contained, highly reliable, full-featured SQL database engine. Databases are being partitioned into: 1) server databases, to which one can connect from different devices, and the data itself is stored on a specially dedicated server (MySQL, MS SQL, PostgreSQL); 2) stand-alone databases, to which SQLite belongs. SQLite implements a standalone (serverless) transactional SQL database engine with no installation, setup, or configuration required. Its code is an open source, and it is free to use for any purpose, commercial or personal. SQLite reads and writes directly to regular files on the disk. Thus, a complete database with multiple tables, indexes, triggers, and views is contained in a single file. The database file format is cross-platform, i.e. one can freely copy the database between 32-bit and 64-bit systems or between direct order and inverted order bites architectures. The Qt framework contains a universal interface for working with various databases. The databases in the Qt view are the drivers for the QtSql module. By default, when installing the framework, the SQLite database is available, for the rest of the databases, one need to install and build drivers for Qt. Qt provides an extensive database compatibility, with support for both open source and proprietary products. SQL support is integrated with Qt's “model-view” architecture, simplifying GUI applications integration with databases The way of data aggregation in general form, as well as the relationship of tables in which the data is stored, and the way of data aggregation into aggregated indicators and portraits are presented. Assembly and connection of the other database libraries (PostgreSQL / MySQL / ETS) are adduced. A detailed process of a database creating in the SQLite DBMS for the microwave components production based on the LTCC SQLite Qt is shown.