1 | Introduction. Goals and objectives of the subject. Retrospective review, modern problems, development prospects. Basics of MB theory. Basic concepts and definitions. Data models: hierarchical, network, relational. Development of methods of data organization. | |
2 | MB as a basis of information systems. MB definition, purpose, examples. Manual and computerized MB, comparative analysis. Database requirements for MB properties. Types of computer MB. MB architecture three levels, administrator. Utilities. | |
3 | Information model and structure of data. Conceptual, logical physical models of data. Types of logical models: relational model, hierarchical model, network model. Sequential, direct, index-sequential access methods. Navigational and relational approaches to data access. | |
4 | Creating an information model and defining values. Identify relationships between values. Install the key. Bringing the model to the desired level of normal form. Physical description of the model. Database management system (DBMS), main functions and features. A review, analysis and reasons for the transition to the use of modern IMS. | |
5 | Basic elements of a relational database. Basic types, variables, fields, compatibility of types. Data storage and table structure. Fields, records. The concept of a key, the need to use a primary key. Definition and use of generator. Purpose, structure, advantage of using indices. Events that lead to a violation of directory integrity. Types of restrictions. Assigning and Using Views. | |
6 | The main objects of the relational database and the rules of their creation. MB normalization and software. The main objects of the relational database. Create tables, forms, requests. The concept of calculation and the need for use. | |
7 | MB design. Post-correlation models of data. Classification and comparative characteristics of BMZ. The main concepts of MMBZ. Examples of MB organization. Functional dependencies in relational MB theory. | |
8 | The concept of normalization, normal form. Attributes and keys. Normalization of relations, levels. Introduction to Relational Algebra. Fundamentals of relational computing. Relational algebra. MB design. | |
9 | Organization of MySQL SQL queries. Sorting, searching and filtering data (selection), creation of requests for the BMS. General description of MySQL database, main components, application limitations. Principles and methods of data manipulation, Data storage, addition, processing and deletion, data set navigation. | |
10 | Table as the basis of MB. Data types. Identify the primary key. Creating tables in 'Master' and 'Designer' mode. Methods of altering and editing tables. Data schema. 'Form' as the basis of the interface. Object purpose, types, features, modes, controls. Development of complex forms, adjustment of forms. Filters and queries. Demand-selection. Request-action. SQL query. | |
11 | Import, export and add MySQL objects. Basic principles of design. Macros, modules. Design stages of MB applications. Areas of application of MySQL database. Application of MB in various fields of activity. | |
12 | Organization of the MMBZ interface. The purpose, main features, areas of application of МББЖ. Description, creation, and comparison with other BMS. Installation and recovery methods. Logical and physical structure of MB. Updates and features for certain operating systems. Ensure consistency and integrity of data. | |
13 | Creation of interfaces, applications. Connect to MySQL database and execute SQL queries. Table creation, deletion. Data selection, change, input requests. Change the DB structure. Classes used in data access. MB access mechanism through ATL. Prospects of development of MB, MBBZ. | |
14 | Technological MB for automation systems. Management of processes and equipment, control of technological processes, monitoring. Sensor, controller, etc. collect, store, process and analyze data from devices. Optimum operating modes of equipment and technological processes. Automation systems settings and configuration management. Interaction between components. Storing information about events, errors and accidents. | |
15 | Technological MB on various platforms: industrial MSMS (Oracle, SQL Server, Siemens SQL), NoSQL, specialized SCADA systems (Wonderware, Siemens WinCC, Citect) and open solutions (OPC Unified Architecture, Modbus TCP, DNP3). Choose a platform. Server backup, clustering, data copying, encryption. Modern DB for system automation: PostgreSQL, Redis, Apache Cassandra, etc. | |