0:02
[Music]
0:12
hello friends welcome back to our
0:13
channel
0:14
so in today's session we'll discuss
0:16
about one more topic in
0:17
dbms so that is the differentiation
0:20
between dbms and rdbms
0:32
so we know that a dbms means a database
0:36
management system
0:46
whereas
0:47
rdbms is
0:49
a relational database management system
0:56
relational database management system
0:59
right so once we call it as a relational
1:01
that means here the data will be stored
1:04
in terms of a tabular format and here
1:08
data
1:10
is stored
1:14
as a file systems
1:17
file system so usually in our hard disk
1:20
the data will be stored in some files
1:21
and those files will be stored in
1:23
directories so that means it's a file
1:25
system
1:26
and coming to this rdbms
1:30
the data was stored in
1:36
tabular format
1:41
tabular form okay that means in terms of
1:43
rows and columns
1:45
so coming to the third difference
1:48
so in order to access the data in dbms
1:51
so
1:52
it is stored in the file system so we
1:54
need we require some navigational format
1:56
or hierarchical format to represent the
1:59
data or to access the data so
2:01
here
2:05
the data is represented in a
2:07
hierarchical
2:08
fashion
2:11
hierarchical form or
2:14
navigation form
2:18
navigation form in order to access the
2:20
data right and coming to here
2:24
the data is represented in
2:26
tables
2:28
so we are stored in the tabular format
2:30
so the data will be stored in the form
2:31
of tables so we can easily access the
2:34
data from the tables than this
2:37
hierarchical or navigational form
2:40
the next one
2:42
as
2:43
here there will be no relationship
2:45
between one file with another okay there
2:48
is no relationship between data
2:53
no relationship
2:55
between
2:56
one data with another data because here
2:59
it is stored in the file system
3:01
and coming to the rdbms here the data is
3:05
stored in the tables so here the
3:07
relationship
3:11
relationship
3:15
between data
3:19
is also represented in tables
3:26
also represented in
3:28
tables
3:29
right
3:31
then
3:34
dbms doesn't supports the normalization
3:36
so we can't apply the normalization
3:39
techniques for the dbms so
3:42
no normalization forms
3:48
so here the normalization means
3:51
if the data is considered with a large
3:54
and a complex data or a complex tables
3:56
so we can divide that large and complex
3:58
tables into a simple tables and also we
4:02
can
4:02
remove the redundancy that means the
4:04
duplicates
4:05
right and we can optimize the tables
4:07
right so that is called as a
4:09
normalization and that doesn't supports
4:12
in this dbms but coming to the rdbms the
4:16
normalization can be applied so we can
4:19
apply
4:19
normalization
4:23
apply an organization
4:31
you can apply the normalization and the
4:33
next one
4:34
this doesn't supports the distributed
4:37
databases dbms does not supports a
4:39
distributed databases
4:48
distributed
4:51
database so actually here the database
4:53
is represented as db okay so distributed
4:57
databases and here
5:00
the rdbms
5:02
supports the distributed databases
5:08
supports a distributed
5:10
databases
5:12
and
5:13
the dbms can handle
5:16
a small amount of data so
5:18
it can handle
5:26
small data
5:29
but
5:30
rdbms can handle
5:35
large amount of data
5:37
large amount of
5:41
data so the complex data can also be
5:44
handled in rd mms with the help of this
5:46
normalization techniques
5:48
right
5:49
then
5:50
it supports a single user only a single
5:53
user
5:55
so anytime one user can access the data
5:58
right so single user but here
6:02
in rdbms it supports multiple users at a
6:06
time multiple users can access the data
6:08
and they can do the manipulations
6:11
so supports
6:16
multiple users
6:20
and the last one
6:22
example
6:23
example for the
6:26
dbms is normal file system
6:29
normal file system
6:31
xml
6:33
etc so these are all the file systems
6:36
and coming to the rdbms
6:39
the examples for this rdbms
6:42
is
6:44
oracle
6:46
sql
6:48
mysql
6:50
sql server
6:52
etc
6:53
so the modern database management tools
6:56
will be based upon this rdbms rdbms
7:00
means relational database management
7:02
system
7:03
so these are the
7:05
major differences between the dbms over
7:08
the rdbms
7:11
hope you understood the differences
7:13
between the dbms and rdbms so if you are
7:15
having any doubts regarding this one
7:17
feel free to post your doubts in the
7:18
comment section definitely i'll try to
7:20
clarify all your doubts and if you
7:21
really enjoyed my session like my
7:23
session share my session with your
7:24
friends and don't forget to subscribe to
7:26
our channel thanks for watching thank
7:28
you very much