Білім беру бағдарламасының атауы мен шифры 6В0720 Мұнай-газ ісі, 6В07203Металлургия, 6В07106 Электроэнергетика
жүктеу/скачать 93,09 Kb.
|
Syllabus ICT 2021 1 семестр (1)
| Дәріс №5
Тақырыбы: Database systems Сағат саны: 1 Тақырыптың негізгі сұрақтары/ жоспары: Basic concepts of a database system SQL bases Technology of ORM programming Дәріс тезисі: Data is the information, which is presented in a certain form that allows automating its collection, storage and further processing by a person or an information device. For computer technologies, data is the information in discrete, fixed form, convenient for storage, processing on a computer, and for transmission over communication channels. Database (DB) is a concrete data set, which reflects a status of objects and their relations in a considered data domain. A database consists of a set of connected files. A Database Management System (DBMS) is a set of language and software means, which are intended for creation, guiding and sharing a database by a great number of users. A designed database shall have the following properties: integrity, which is reached owing to introduction of integrity restricting, in particular, the restrictions are connected to DB normalization; DB restorability after failure of the system or separate types of systemdamage; DB safety, which assumes data protection from intentional and unintentional access, modification or damage and fraud. Prohibition of illegal access, protection against copying and cryptography protection are applied. efficiency: minimum time of response to the user's request; minimum needs for memory. Data model is called a formalized structure declaration of information units and operations over them in the information system. The data model is a certain abstraction reflecting the most important aspects of functioning of the selected data domain, whereas the minor ones are ignored. The data model includes a set of concepts for the description of data, relations between them and restrictions, which are superimposed on data. SQL language (Structured Query Language – the structured language of requests) represents a standard high-level language of data description and handling them in database management systems (DBMS) constructed based on a relational data model. SQL language is oriented for operation with data sheets and has no sufficient means for implementation of sophisticated programs. Therefore, it is used in combination with languages of high level, such as, for example С++, Pascal, or is included into a specially developed DBMS language. Бекіту сұрақтары What is a DB? What is data? How are DB types classified? What is a request? What data models are there? What is ORM? What are the bases of SQL language?. What is query optimization? What is a normalization? What requirements should a DB meet? Әдебиет: Негізгі[1-5], қосымша [1-5] жүктеу/скачать 93,09 Kb. Достарыңызбен бөлісу:
|