- Главная
- Разное
- Дизайн
- Бизнес и предпринимательство
- Аналитика
- Образование
- Развлечения
- Красота и здоровье
- Финансы
- Государство
- Путешествия
- Спорт
- Недвижимость
- Армия
- Графика
- Культурология
- Еда и кулинария
- Лингвистика
- Английский язык
- Астрономия
- Алгебра
- Биология
- География
- Детские презентации
- Информатика
- История
- Литература
- Маркетинг
- Математика
- Медицина
- Менеджмент
- Музыка
- МХК
- Немецкий язык
- ОБЖ
- Обществознание
- Окружающий мир
- Педагогика
- Русский язык
- Технология
- Физика
- Философия
- Химия
- Шаблоны, картинки для презентаций
- Экология
- Экономика
- Юриспруденция
Database overview презентация
Содержание
- 1. Database overview
- 2. Database DBMS Data model RDBMS Client-server DB server installation Agenda
- 3. A database is an organized collection of
- 4. What is DBMS? Database management system (DBMS)
- 5. To store data properly To provide simultaneous
- 6. Hierarchical Network Relational Object Data models
- 7. Inplement a relational data model Are used
- 8. Store data on local PC or network
- 9. Consist of two components: client and server
- 10. Install RDBMS Server Microsoft SQL Server 2014
- 11. Demonstration
- 12. Links http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx https://msdn.microsoft.com/en-us/library/bb545450.aspx
- 13. Thank you!
Database DBMS Data model RDBMS Client-server DB server installation Agenda
Слайд 3A database is an organized collection of data.
A database is a
collection of information that is organized so that it can easily be accessed, managed, and updated.
What is database?
Слайд 4What is DBMS?
Database management system (DBMS) is a special software application
that interacts with the user, other applications, and the database itself to capture and analyze data.
E.g.: MySQL, PostgreSQL, Microsoft SQL Server, Oracle etc.
E.g.: MySQL, PostgreSQL, Microsoft SQL Server, Oracle etc.
Слайд 5To store data properly
To provide simultaneous access to the data for
many users
To delimit the access to the data for different users
To prevent data from loss
To delimit the access to the data for different users
To prevent data from loss
DBMS purpose
Слайд 7Inplement a relational data model
Are used in most commercial projects
Have been
used for almost 40 years
RDBMS
Слайд 8Store data on local PC or network file storage
Data processing is
performed on the local PC
Are used for small applications, mostly single-user, without strong security requirements
Example: Microsoft Access
Are used for small applications, mostly single-user, without strong security requirements
Example: Microsoft Access
Desktop RDBMS
Слайд 9Consist of two components: client and server
Client-server RDBMS
Client
Server
Sends a query for
data
Streams data
according to criteria
Server address:
ssu-sql12\tc
Client address:
Class56
Class61
Слайд 10Install RDBMS Server
Microsoft SQL Server 2014 Express
Install client application for querying
data
Microsoft SQL Server Management studio
Microsoft SQL Server Management studio
RDBMS installation
Слайд 12Links
http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx
https://msdn.microsoft.com/en-us/library/bb545450.aspx
