Please enable JavaScript.
Coggle requires JavaScript to display documents.
Type of data, Filtering, Features of DBMS, DataTypes in mySQL, Database…
Type of data
Transient data
persistent data
Filtering
where
and
or
between
like
in
is null
tuple comparision
limit
select distinct
Features of DBMS
Data Redundancy
Data Inconsistency
Data Integrity
security
faster accessing the data
file location
backup
atomicity
concurency
DataTypes in mySQL
numeric
string
date and time
spatial
json
Database System
DBMS
NoSQL
RDBMS
application/query
DataStorage
SET Operation
Union [distinct, all]
MINUS: using left join
Interset: Using inner join, subquery