EP Information Systems 6В06102 Module 21: Data Management and Knowledge Systems (Elective Modulе 3, EM3)

Module 21: Data Management and Knowledge Systems (Elective Modulе 3, EM3)

Code

M21IS(Ba)

Module Elements

Elective Subjects

Database Systems
Databases and Knowledge Bases
Programs and Means of Information Protection
Reliability of Information Systems
Systems Analysis and Simulation
System analysis
Business Process Modeling
Work Experience Internship 1

Semester Number:

3, 4

Person responsible for the module

V.P. Kulikov

Lecturer:

Database Systems – T.V. Pyatkova
Databases and Knowledge Bases – V.P. Kulikov
Programs and Means of Information Protection – Y.V. Kukharenko
Reliability of Information Systems – V.P. Kulikov
Systems Analysis and Simulation – V.P. Kulikov
System analysis – V.P. Kulikova
Work Experience Internship 1 - T.V. Pyatkova
Business Process Modeling- T.V. Pyatkova

Language:

Russian, Kazakh

Curriculum relation:

Information Systems (Ba)

Type of teaching / number of hours per week and per semester :

3 semester: hours per week – 22 (lectures -2; labs-6; independent work of students -14); hours per semester – 330.
4 semester: hours per week – 10 (lectures -1; workshops -1; labs-2; independent work of students -6); Work Experience Internship 1 - 60 hours hours per semester –210.

Workload:

Teaching Load: 180 hours
Extracurricular Classes: 270 hours
Total: 540 hours

Credit Points:

18 ECTS

Conditions for Examinations:

For admission to the exam, the student must score at least 50 points out of 100 available for the subject

Recommended Conditions:

This module is based on the knowledge gained by students in the course of the previous undergraduate subjects: Basics of the Profession, Programing Basics, Mathematics 3, Reliability of Information Systems, Database Systems, Databases and Knowledge Bases, Programs and Means of Information Protection, Technologies of Technogenic Risk Management.

Expected Learning Outcomes:

Know: different approaches to the organization of databases; relational database model; the concept of database; the concept of database systems; database models; modern methods of processing, transformation and protection of information in modern computer systems; modern ways to combat unauthorized blocking, access, copying, modification and collection of information.
Know: problem statement, modeling stages; construction of economic and mathematical models for decision-making problems in difficult situations or under uncertainty. Know the main problems of the modern theory of business processes, the principles of organization structuring, modern features and instrumental systems used to describe business processes, the basic principles of business process analysis.

Be able to: perform operations of relational algebra and relational calculus; design databases; use the basic principles, methods and algorithms for the operation of software systems for collecting, closing, restoring and authenticating information.
Be able to: independently investigate the problem of decision making; possess the skills of choice and implementation of the algorithm solutions and research in various fields of human activity Be able to explore the theory of the technological approach to managing the activities of an organization, the methodology for describing business processes and their supporting software.

Possess the skills: building a logical database model, a physical database model; working in popular DBMS; working with SQL query language; working with DBMS of Visual FoxPro and MS Access; creating information security systems, as well as optimizing models of comprehensive business processes; independent use of appropriate software tools.
Possess the skills: in the field of economic and mathematical models for decision-making problems. have the skills to work in modern instrumental systems.

Demonstrate the ability to: perform the database design process; in the technology of access to data from client applications; understanding information technologies and their security, as well as information resource management.
Demonstrate the ability to: apply typical models in economic analysis and planning at different levels of the economy.
Demonstrate the ability to visualize business processes, analyze business processes.

Intendend use/applicability

Modules: Automation and Designing

Content:

1. Database Systems

Information Systems database. General information about the data. The concept of building a database. Basics of database theory. Theory of relational databases. The integrity of relational data. Relational algebra. Normal forms of relationships. Normal forms of high orders. Database development. Database design. Database design automation. Transactions and database integrity. Database software.

2. Databases and Knowledge Bases 

Development of database technology. DBMS. Information systems using databases. Relational database management: relational algebra and relational calculus. Relational database management: SQL. Client/server technology. Relational DB management. Database administration and control.

3. Programs and Means of Information Protection

The problem of information protection. Purpose and necessity of closing information. Objects of protection, directions of information protection, its methods and means. General problem of information security of information systems. Protection of information within information processes. Protection of information from unauthorized access. Mathematical and methodical means of protection.

4. Reliability of Information Systems

Reliability: basic concepts and definitions. Reliability index. Main indicators of reliability of objects. Probability of failure. Mean time to failure. Failure rate. Mean time between failures. Parameters of the failure thread. Main indicators of durability.

5. Systems Analysis and Simulation / System analysis.

General and canonical statements of LPP (linear programming problems). Geometric method for solving LPP. An algebraic simplex method for solving LPP. The dual problem of LP. Dual simplex method. Regression model. Nonlinear model. Dynamic systems: examples of dynamic models. Dynamic systems: evaluation of the quality of dynamic models, modeling of dynamic objects. Statistical modeling. Monte Carlo method. RNG methods. Simulation of a queuing system. Planning and management problems. Game theory: strategies in the game. The loss function, the price of the game. S - game. Minimax theorem. Game theory: reduction to the problem of LP, statistical games. Game theory: non-coalition games, non antagonistic games. Decision theory: problems, models. The decision theory: criteria for decision of Minimal risk, Savage, Bayes-Laplace, Hurwitz, etc. Queuing Theory and inventory management.

6. Business Process Modeling

A discipline that studies the concept of a business process, a process approach and a process-oriented organization, the theoretical foundations of business process management, the main approaches and standards for business process modeling, business process modeling software, methods for describing various subject areas of an organization, methods for analyzing business processes. processes.

7. Work Experience Internship 1

Optimal control. Methods and models of graph theory. The problem of constructing the shortest path and Dijkstra's method. Flows in networks and the principles of conservation. Network modeling problems.

Examination Form, module mark:

Database Systems /Databases and Knowledge Bases – computer-based testing
Programs and Means of Information Protection / Reliability of Information Systems/ Business Process Modeling – written examination
Systems Analysis and Simulation / System analysis. - course paper
Work Experience Internship 1 - report defense

Technical/Multimedia Facilities:

Multimedia System.
IT room.

Study Materials:

1. Y. K. Baranova. Simulation of Information Security System. Practical Course: Textbook for university students. - M. : RIOR : INFRA-M, 2015.  120 p.
2. V. V. Platonov Software and Hardware Means for Information Protection: Textbook for university students studying Information Safety- 2^nd ed., - M.: Akademiya, 2015. - 336 p.
3. Technical Means and Methods of Information Protection: Textbook for universities / A. P. Zaitsev, A. A. Shelupanov, R. V. Meshcheryakov et al.; ed. A. P. Zaitsev and A. A. Shelupanov. – M.: Mashinostroyeniye Publishing House, 2016 – 508 p.
4. A.D. Khomonenko, V. M. Tsygankov, M. G. Maltsev Databases: Textbook for Higher Education Institutions. M.: Binom-Press, 2010 – 736 p.
5. K. J. Date. Introduction to Database Systems M: SPb.: Williams Publishing House, 2012. – 848 p.V. K. Morozov, G. N Rogachev. Simulation of Information and Dynamic Systems; Akademiya - Moscow, 2011. - 384 p.
6.B. Y. Sovetov, S. A. Yakovlev. Simulation of Systems. Textbook for universities. – Moscow: Vysshaya Shkola, 2013. N. G. Chikurov Simulation of Systems and Processes; RIOR, Infra-M - Moscow, 2013. - 400 p.
7.N. V. Golubeva. Mathematical Simulation of Systems and Processes; Lan - Moscow, 2013. - 192 p
8. Dolganova, O. I., Vinogradova E. V., Lobanova A. M. Business process modeling: textbook and workshop for academic undergraduate students; edited by O. I. Dolganova. - Moscow: Yurayt Publishing House, 2019. - 289 p.
9.Garaedagi J. Systems thinking: How to manage chaos and complex processes: a platform for modeling business architecture, - Minsk: Grevtsov Publisher, 2007, - 480p.
10. Menkov A.V., Ostreykovsky V.A. Theoretical foundations of automated control // Textbook for universities - M .: Oniks, 2011 - 640 p

Date of last amendment

20.01.2023