Database and DBMS Introduction

Database

Database is the collection of interrelated data. or collection of related information stored so that it is available to many users for different purposes.
The content of database  is obtained by combining data from all the different sources in an organisation.

Database Management System (DBMS) 

DBMS is a software used to manage and access the database in efficient way. It manages the data in a database.
There are various DBMS available – For example –

various softwares-DBMS

Some related terms used in DBMS –

Data : is the raw facts and figures. It is represented with the help of characters like alphabets(A-Z), digits(0-9) and special characters (+,-,/,*,<,>,= etc.)

Data Item (Field) : Set of characters which are used to represent a specific data element. For example, Name of student in a class  is represented by a data item, say name.

Record : A collection of related items. Example a Student record containing name, age, DOB, Fathers name, mothers name, rollnumber, marks,  etc.

File : is a collection of related records. For example,  Student file.

Student File(DBMS)

Information : is organised or classified data so that it has some meaningful values. It is the processed data, which has the following characteristics :

  • Timely
  • Accurate
  • Complete and
  • Given to the right persons

Data Processing and Data Manipulation : Data Processing is the manipulation of raw data to make it more useful. Data Manipulation consists of such operations as classification, sorting calculations and summarisation.

Basis Data Information
Meaning Raw facts and Figures Processed data so that it has some meaningful values.
Example Test Score of each student Average Score of a class
Data Processing (DBMS)

Database Design Steps 

  • Requirements Analysis
  • Conceptual Modelling (ER Model)
  • Logical Modelling (Relational Model)
  • Schema Refinement (Normalization)

Once the construction is over, we cannot change it.
In a single user application, we may not think of concurrency and transaction management.
But in multi-user applications, they comes into account.

Types of Databases 

  • OLTP – Online Transaction Processing –
    • The main focus for OLTP systems is updating data to put on very fast query processing, maintaining the integrity of data in multi-access environments.
    • The effectiveness of OLTP systems is measured by number of transactions per second.
    • It is simply called as Database.
    • The main operations performed on OLTP are Read and Write.
    • Use of simple SQL
  • OLAP – Online Analytical Processing –
    • The main focus of OLAP systems is reporting data.
    • The effectiveness of OLAP systems is measured by response time.
    • OLAP applications are widely used by Data Mining Techniques.
    • It is also called as Data Warehousing.
    • The main operations performed on OLTP are Read only.
    • Use of Complex SQL (Joins etc.)
Difference between OLTP and OLAP systems 

oltpvsolap - DBMS

Another Classification of Databases 

  1. Commercial Databases : Inventory Control System, Library, Student Information System
  2. Multimedia Databases : Voice, Video Clips, Images
  3. Temporal Databases : Attaching time aspect to data. For example, Railway Reservation.
  4. GIS (Geographical Information System) Databases : To give ways to reach destination. For example, Route Map, Google Earth
  5. Distributed Databases : Web Environment (Consistency is very high) ⇒ Concurrency and Transactions
  6. Deductive Databases : Rule Based : (A=B, B=C ⇒A=C), If we buy one thing, then there is chance of buying the other.
  7. Document Databases : Google, Content Information System
  8. Active Databases : Flooded with Triggers
  9. Web Databases : Any database can become a web database, if it is available in web environment

Different Types of DBMS 

  • Relational DBMS
  • OR DBMS (Object Relational DBMS) :  example oracle i. For RDBMS, we added object oriented principles
  • OD DBMS (Object Oriented DBMS) : For object oriented, we added relational principles

For multimedia, GIS, Document and Web : OODBMS.
For others except above four : ORDBMS

 


Previous Home Next
DBMS vs File System and Disadvantages of File System

     

Incoming search terms:

  • edugrabs dbms
  • edugrab database
  • In dbms A meaningful collection of related character is known as
  • joins in query processing on edugrab

Leave a Reply