RDBMS

1
DEV BHOOMI GROUP OF INSTITUTIONS
SAHARANPUR

• Course MCA 2ND (2013-15).
• Topic RDBMS AND OODBMS.

• By Mr.Saurabh Chauhan
• Mr. Sandeep Sahgal Mr. Intzar ahmd .

2
Overview

• About DBMS.
• RDBMS ?
• Example .
• Rules ?
• RDBMS advantages .
• RDBMS disadvantages .
• Different between DBMS AND RDBMS ?
• OODBMS ?
• Diagram .
• Advantages of OODBMS.
• Thank you

3
DBMS

• This term of DBMS is the combination of DB MS .
• A DBMS is a collection of interrelated data .
• A DBMS is software system that allow us to manage
  the Database .
• Some DBMS are oracle (10 g,10 gi ,11 g ,11gi )
• SQL SERVER 2005.
• DB2.
• FOXPRO.
• MS ACCESS (2003,2007,2010,2013).

4
RDBMS

• RDBMS is a DBMS that is based on the relational
  model as introduction by Dr. E.F. Codd in 1970.
• It satisfy codd 12 rules (more than 7-8 ).
• Dr E.F. is a researcher of International
  Business Machine .

5
Example Table in RDBMS
INTER RELATED
Roll no Name Address Cell num
101 A SRE 9719500500
102 B MEERUT 9719400800
103 C DELHI 9758589898
RELATED
6
Relation between two tables
Table 1
Table 2
Emp _ID Name
1001 Amit
1002 Sumit
1003 Ankit
Address Phone num ID
Meerut 9898989797 101
Saharanpur 9719444444 102
Roorkee 9719555555 103
Table 3
Date Time Emp_ID ID Title Author
12/06/2014 900 am 1001 101 C Bejarne
15/05/2013 1000 am 1002 102 C Denitch
12/06/2012 1100 am 1003 103 .NET XYZ
7
12 Rules.(given by Dr. E.F. Codd)

• Rule 1 The information rule
• Rule 2 The guaranteed access rule
• Rule 3 Systematic treatment of null values
• Rule 4 Active online catalogue based on the
  relational model
• Rule 5 The comprehensive data sublanguage rule
• Rule 6 The view updating rule
• Rule 7 High-level insert, update, and delete
• Rule 8 Physical data independence
• Rule 9 Logical data independence
• Rule 10 Integrity independence
• Rule 11 Distribution independence
• Rule 12 The non-subversion rule

8
RDBMS Advantages

• Easy to use
• Secure
• Data manipulation
• Limit redundancy or replication of data
• Better integrity
• Provide physical data independence
• Offer logical database independence - data can be
  viewed in different ways by different users.
• Better backup and recovery procedures
• Provides multiple interfaces
• Multiple users can access which is not possible
  in DBMS

9
RDBMS Disadvantages

• Software is expensive
• Complex software means expensive hardware
• Requires skilled knowledge to implement
• Certain applications are slower processing
• More difficult to recover if data is lost
• Seen as a poor representation of the real world

10
Differences between DBMS and RDBMS

• DBMS
• Data is stored in a single large table
• Single record modification affects the whole
  database
• RDBMS (Codd 1980)
• Database is 'broken down' into smaller pieces
• The changes will not affect the entire database

11
OO DBMS

• OO systems were first developed in the 1980s,
  when oo programming languages such as Simula and
  Smalltalk first emerged.
• Object data base system store and maintain object
• An object is an item that can contain and the
  procedure that manipulation the data.
• An object oriented database system often use a
  query language called to manipulate and retrieve
  data.

12
What is an OODBMS anyway?

• OODBMS (Object-oriented DB Management System) is
  a database with data stored in objects and
  collections NOT rows and tables.
• OO Concepts
• Abstraction, encapsulation, information hiding.
• Objects and attributes.
• Object identity.
• Methods and messages.
• Classes, subclasses, superclasses, and
  inheritance.
• Overloading.
• Polymorphism and dynamic binding.

13
OODBMS

• Traditional DBS
• Persistence
• Sharing
• Transactions
• Concurrency Control
• Recovery Control
• Security
• Integrity
• Querying

• Semantic Data Model
• Generalization
• Aggregation

• OOPS
• OID
• Encapsulation
• Inheritance
• Types Classes
• Methods
• Complex objects
• Polymorphism
• Extensibility

• Special Requirements
• Versioning
• Schema Evolution

OODBMS
14
OO Advantages

• OO principles brought to databases
• New modeling power
• Extensibility of systems
• Code reuse
• Easy maintenance of programs
• However, it is only recently that OO programming
  has itself really taken off.

15
(No Transcript)