Presentation prepared by Yunusaliyev Sanjar a student of the E39-22eee group of the Faculty of Energy Fergana Polytechnic

Presentation prepared by Yunusaliyev Sanjar a student of the
E39-22EEE group of the Faculty of Energy Fergana Polytechnic
Institute on the subject of Information Technologies
Understanding of data warehouse
Database management system
Theme : Data Werhouse
A database is a centralized data repository. Designed for reading, storing, processing and searching data. It is distinguished by its speed. The most popular databases include Oracle, MsSQl, MySQL, and others.
A database management system is a set of programs and a language tool designed to create a database, ensure their up-to-date status, and organize work to find the necessary information in it.
Database is the main component of information systems. Database management systems have been created to facilitate the user's work for using the database. These systems separate the database from the application programs.
The main features of MBBT are not only the composition of the procedures used in data entry and storage,also describes their structure. Contains informationdata before the file saved and managed under MBBTbank, and it was called "Data base".
A set of files is a logical convention
Recovers data after various interruptions
It provides a language for working on data
Provides parallel operation of several users
The data management system has the following features:
The main features of the database
Allows access through standard programming languages.
Produces command-optimized complex queries.
Provides access and audit security.
Multiple user choices, low password and passwordsThey store, protect and retrieve the information you provide.
Independence of logical and physical data.
The layoff rate is low.
Inputting formats for debugging and selecting the data we are interested in in real time.
Database elements
Database elements
Reports: results of working with tables; they are often called reports.
Forms: These are inputs or interfaces that allow execution of data manipulation commands
Tables: Arrange and arrange data in rows and columns for easy reading.
Types of database
Access: This is a database specially designed by Microsoft under the Access program that creates files, stores and protects data.
PostgreSql and Oracle: One of the database for programs. It is distinguished by the management of a large volume of data used in this system, which can be monitored in internal networks and large-scale systems.
Mysql: As a server, under the GPL license, this system is characterized by the speed of the developed database, which is not useful or functional for large amounts of data.
Microsoft SQL Server: After Microsoft Access, this system is used, which is characterized by working with real amounts of data, because it is more powerful than Access in terms of storage and management power.
THANK YOU FOR YOUR ATTENTION