Fall 2016
CIS 3352
1
Introduction to Database
Introduction to Database
Management Systems
Management Systems
Mathew Tams
[email protected]
[email protected]
Fall 2016
CIS 3352
2
Database
Database
–
A database is an organized collection of
information
–
The benefit of storing information in a database
is to make data easy to access and manage.
–
Users interact with the database through a
predefined language.
Fall 2016
CIS 3352
3
Motivation
Motivation
Organisations are increasingly aware of the
importance of information in the solution of
their problems.
Because of decreasing cost of data storage,
organisations store increasing quantities of
data.
This data must be managed in the most
efficient and effective manner.
Fall 2016
CIS 3352
4
The Database Approach
The Database Approach
Organizations must have access to operational data that
is
–
accurate
timely
convenient
–
up-to-date
–
secure but available
As control decentralizes in an organization, there is a
danger that data management decentralizes as well.
Example of Student Data
Example of Student Data
Fall 2016
CIS 3352
5
Database before computers
Database before computers
Data was stored in:
–
books
–
ledgers
–
card files
–
folders
–
file cabinets
Fall 2016
CIS 3352
6
Database storage in computer
Database storage in computer
age
age
Fall 2016
CIS 3352
7
DBMS vs RDBMS
DBMS vs RDBMS
The software application that enables the users to
store the data is known as a database. In database
architecture, there are different implementations and
theories in order to store physical data. The database
which stores data in the tables that have relationships
with other tables in the database is called RDBMS or
Relational Database Management System. However,
in DBMS or Database Management System, there are
no relation among tables
Fall 2016
CIS 3352
8
Some DBMS
Some DBMS
Banking
Airlines
Universities
Credit card transactions
Tele communication
Finance
Sales
Manufacturing
Human resources
Fall 2016
CIS 3352
9
DBMS vs RDBMS
DBMS vs RDBMS
Relationship among tables is maintained in a RDBMS whereas this not the case
DBMS as it is used to manage the database.
DBMS accepts the ‘flat file’ data that means there is no relation among different
data whereas RDBMS does not accepts this type of design.
DBMS is used for simpler business applications whereas RDBMS is used for more
complex applications.
Although the foreign key concept is supported by both DBMS and RDBMS but its
only RDBMS that enforces the rules.
RDBMS solution is required by large sets of data whereas small sets of data can be
managed by DBMS.
Fall 2016
CIS 3352
10
History
History
