Introduction to database management systems
Chapters
Introduction to database management systems
Database is a collection of a related data. Database management system is a software designed to assist utilization and maintenance of large-scale collection of data. DBMS was first developed by Charles Bachmann in 1960.
Database
- A database is collection of related data.
- A database can be of varying complexity and of any size.
- A database are maintained and generated manually or computerized
DBMS Task
- Data capture: It is task associated with data gathering.
- Data classification: Data captured are classified based on nature and intended usage.
- Data storage: The segregated data should be stored properly.
- Data retrieval: Data are required frequently for further processing, Hence it is important to create some indexes so that data can be retrieved
- Data maintenance: Maintenance is task concerned with keeping data up-to-date.
Characteristics of DBMS
- To incorporate the requirements of the organization, system should be designed for easy maintenance.
- Information systems should allow interactive access to data to obtain new information without writing fresh programs.
- System should be designed to co-relate different data to meet new requirements.
- An independent central repository, which gives information and meaning of available data is required.
- Integrated database will help in understanding the inter-relationships between data stored in different applications.
- The stored data should be made available for access by different users simultaneously.
- Automatic recovery feature has to be provided to overcome the problems with processing system failure.
User types
The diagram shows basic user types found in DBMSes.
- Administrators: Administrators maintain DBMS and are responsible for administrating database. They create access profiles for users and apply limitations to maintain isolation and force security. Administrators also look after DBMS resources like required tools, system license, other software and hardware related maintenance.
- Designers: Designers are group of people who work on designing part of database. They identify and design whole set of entities, constraints, relations and views.
- End Users: End users actually get benefits of having a DBMS.
Description
This free tutorial covers the basics of database management system to help you with your understanding on the topic, Please note that this tutorial assumes that either you are a beginner or just want to brush up your understanding on DBMS
Tutorial covers the topics below
- What is DBMS?
- Architecture
- Data Models
- Data Schemas
- Data Independence
- Entity-Relation Model Basic Concept
- Entity-Relation Diagram Representation
- Generalization, Aggregation
- Codd's 12 Rules
- Relational Data Model
- Relational Algebra
- Structured Query Language
- Normalization
- Database Joins
- Storage System
- Indexing
- Hashing
- Transaction
- Concurrency Control and Deadlock
- Data Backup and Recovery
Audience
Absolute beginners or students who wish to brush up their understanding on DBMSes
Author: Subject Coach
Added on: 16th Sep 2015
You must be logged in as Student to ask a Question.
None just yet!