DB and DBMS
Advantages of DB usage
DBMS languages
DBMS
usersBasic requirements to database systems
Разделы презентаций
- Разное
- Английский язык
- Астрономия
- Алгебра
- Биология
- География
- Геометрия
- Детские презентации
- Информатика
- История
- Литература
- Математика
- Медицина
- Менеджмент
- Музыка
- МХК
- Немецкий язык
- ОБЖ
- Обществознание
- Окружающий мир
- Педагогика
- Русский язык
- Технология
- Физика
- Философия
- Химия
- Шаблоны, картинки для презентаций
- Экология
- Экономика
- Юриспруденция
Introduction
Содержание
- 1. Introduction
- 2. CONTENTS File systems and data bases
- 3. File SystemsADTask 1Task N…Program-1 File-1Program-2 File-2…Program-N File-NTask 2
- 4. File System DrawbacksData depends on programsInflexibility of
- 5. Data Base ApproachInformation model of ADFunctional model of ADApplicationDBDBMS
- 6. Data Base DefinitionThe database (DB) is a
- 7. DBMS DefinitionData Base Management System (DBMS) is
- 8. DB Advantages Integrated data storage Centralized management
- 9. Centralized DB Management DB schema design Development
- 10. Data Independence in DB Logical independence Physical
- 11. Data integrity in DBThe following causes integrity
- 12. Features of DB Integrity Supporting Back-up coping
- 13. Data Security User registration Control of access rights User identification Automatic logging Data encryption
- 14. DBMS Languages Data Definition language (DDL) Data
- 15. Data Base Users DB administrator (group) System
- 16. Requirements to DB (1) Simplicity and flexibility
- 17. Requirements to DB (2) Protection against the
- 18. Скачать презентанцию
CONTENTS File systems and data bases Definitions of DB and DBMS Advantages of DB usage DBMS languages DBMS users Basic requirements to database systems
Слайды и текст этой презентации
Слайд 1Lecture.1 Introduction
National Aviation University
Computer Sciences Faculty
Department of software engineering
Слайд 2CONTENTS
File systems and data bases
Definitions of
DB and DBMS
usersBasic requirements to database systems
Слайд 4File System Drawbacks
Data depends on programs
Inflexibility of data structure
Static data
Absence
of integration
Data inconsistency
Inefficient concurrent access
Inefficient storage and processing
Слайд 6Data Base Definition
The database (DB) is a large set of
complex- structured data, that assume:
the integrated storage,
centralized management and sharing.
Слайд 7DBMS Definition
Data Base Management System (DBMS) is a software for
EFFECTIVE, CONVENIENT, and SAFETY creation and maintenance of data in
a database, for organization of search data and outputing them.
Слайд 8DB Advantages
Integrated data storage
Centralized management
Common usage (sharing)
Data independence
Data integrity
Data security
Effective data access
managementData recovery
Слайд 9Centralized DB Management
DB schema design
Development data storage
structures
DB restructuring and reorganization
Supporting DB back-up and recovery
mechanismsData protection mechanisms
DB Adjustments
Regular observations
Слайд 10Data Independence in DB
Logical independence
Physical independence
The data independence
is a status, when the application programs are completely independent
from data storage, access and representation
Слайд 11Data integrity in DB
The following causes integrity violation:
Faults in
hardware or software
Incorrect data entering, modifications and
deletions
Concurrent data access and modifications Data integrity is supporting a variety of restrictions on data in database
Слайд 12Features of DB Integrity Supporting
Back-up coping and restoring
Checkpoints and rollbacks
Integrity constraints
Transactions
Locking
Logs
activity 
Слайд 13Data Security
User registration
Control of access rights
User
identification
Automatic logging
Data encryption
Слайд 14DBMS Languages
Data Definition language (DDL)
Data Manipulation Language (DML)
Query Language (QL)
Structured Query Language (SQL)
Query By Example
(QBE)
Слайд 15Data Base Users
DB administrator (group)
System analytics and designers
System and applied programmers
End users
Operators
Слайд 16Requirements to DB (1)
Simplicity and flexibility of applications
development
Multiple-aspect data usage
Simplicity and flexibility of data usage
Simplicity and flexibility of data changes,
modifications and adjustemtsEfficiency, flexibility and productivity of storage and processing
Слайд 17Requirements to DB (2)
Protection against the non-authorized access,
distortion
and deletion
Support of a required level of the
data
independence Support a required level of the data integrity
Advanced DB administration features
