Clilstore Facebook WA Linkedin Email
Login

This is a Clilstore unit. You can link all words to dictionaries.

RDBMS

0:07
database let's understand what is data in simple words data can be facts
0:15
related to any object in consideration for example your name age height weight
0:22
etcetera are some data related to you a picture image File PDF etcetera can all
0:30
be considered data now what is the database we already know what data is
0:37
but this data could be random a database is a systematic collection of data since
0:44
the data in a database is organized it makes data management easy what is a
0:50
database management system DBMS database management system or DBMS is a
0:57
collection of programs which enables its users to access a database manipulate
1:04
data and help in the representation of data it also helps control access to the
1:10
database by various users let's discuss a few examples and online telephone
1:15
directory would definitely use database management system to store data
1:20
pertaining to people
1:21
phone numbers and other contact details
1:24
your electricity service provider is obviously using a DBMS to manage billing
1:30
client related issues to handle phone data etc let's consider the Facebook it
1:37
needs to store manipulate and present data related to members their friends
1:42
member activities messages advertisements and a lot more we can
1:48
provide countless numbers of examples for usage of DBMS database management
1:54
systems are not a new concept and as such had been first implemented in the
1:59
1960's Charles Bachmann's integrated data store for IDS is said to be the
2:05
first DBMS in history with time
2:10
database technologies evolved a lot while you see
2:13
and expected functionalities of databases have been increased immensely
2:17
types of DBMS let's see how the DBMS family evolve with time the following
2:27
diagram shows the evolution of DBMS categories there are four major types of
2:35
DBMS let's look into them in detail
2:39
hierarchical this type of DBMS employees the parent-child relationship of storing
2:46
data this type of DBMS is rarely used nowadays is structure is like a tree
2:53
with nodes representing records and branches representing fields the Windows
2:58
registry used in Windows XP is an example of a hierarchical database
3:03
configuration settings are stored as tree structures with nodes network DBMS
3:10
this type of DBMS supports many to many relationships this usually results in
3:17
complex database structures RDM server is an example of a database management
3:23
system that implements the network model relational DBMS this type of DBMS
3:30
defines database relationships in forms of tables also known as relations unlike
3:37
the network DBMS are DBMS does not support many to many relationships
3:42
relational DBMS usually have predefined data types that they can support this is
3:49
the most popular DBMS type in the market
3:52
examples of relational database management systems include MySQL Oracle
3:58
and Microsoft SQL Server object oriented relational DBMS this type support
4:05
storage of new data types the data to be stored is in the form of objects the
4:10
objects to be stored in the database have attributes for example gender or
4:15
age and methods that define what to do with the data PostgreSQL is an example
4:21
of object oriented relational DBMS
4:24
s so what is asked you out
4:29
Structured Query Language SQL pronounced as SQL or sometimes as sequel is
4:37
actually the standard language for dealing with relational databases SQL
4:42
can be effectively used to insert search update and delete database records that
4:49
doesn't mean SQL cannot do things beyond that in fact it helps in optimizing and
4:56
maintenance of databases and much more relational databases like MySQL Oracle
5:03
MS SQL sybase etcetera use SQL SQL syntax is used in these databases are
5:13
almost similar except the fact that some databases used difference in texts and
5:19
even proprietary SQL sin taxes an example of an SQL statement select star
5:26
from members where age is greater than 30 DBMS stands for database management
5:34
system we have four major types of DBMS 'as called hierarchical network
5:42
relational and object-oriented the most widely used DBMS is the relational model
5:50
this saves data in Table formats it uses SQL is the standard query language SQL
5:58
is the standard language used to query a database the database approach has many
6:03
advantages when it comes to storing data compared to the traditional flat file
6:08
based systems
Clilstore

Short url:   https://clilstore.eu/cs/4120