INFORMATION MANAGEMENT
Stored data
Threats to
quality data
Corrupted data -s hard drive failure &RAID , backup , audit trials
->
human error data validation
, minimise user privileges
-> UPS Redundant power
power
outages ,
supply
Outdated data needed
add new records ,
change existing records , delete records no
longer
Invalidated data data validation
e , range , uniqueness ,
presence length type format , checks
, ,
logical
->
check sum ,
digit
->
parity
&"Firewall anti-malware
Vulnerability ->
malware ,
-> SQL & Data GUI components , limit website access to
injenction validation ,
the DB to execute SQL statements
Data warehousing -
combining data from a
variety of sources within an
organisation
->
analysis
:
purpose producing reports +
->
stores historical duta (not current infor
-> OLAP (OnLine Analytical Processing)
KDD -
Knowledge Discovery in Database
↳Data
mining a
set of
techniques for discovering hidden , valid ,
potentially useful patterns / trends
->
combines Al , database
machine learning , statistics ,
technology
->
5 transform t
Strategies extract , load data onth system
-
store-manage data
-
-
data access
the data
analyse
-
-
present data in a meaningful way
Big data massive volume of structured t unstructured data
->
sources
:
logs audit trails location-based data
social media
,
activity generated data , ,
->
purpose :
improve operations ,
data-driven innovation etc
- identifiers a volume (now much)
-
variety Chat kind)
->
velocity know
frequents
veracity
->
(now accurate)
SQL a programming language to perform CRUD operations on relational databases
NoSQL-non-relational databases : unstructured , flexible , store data in documents
MongoDB
->
e .
.
g
JSON is
file format that uses human-readable
language to store +
communicate data objects
-> for data
good storing temporary
->
structure :
objects enclosed in 23
name-value pairs separated by ,
:
name and value in a pair separated by
Stored data
Threats to
quality data
Corrupted data -s hard drive failure &RAID , backup , audit trials
->
human error data validation
, minimise user privileges
-> UPS Redundant power
power
outages ,
supply
Outdated data needed
add new records ,
change existing records , delete records no
longer
Invalidated data data validation
e , range , uniqueness ,
presence length type format , checks
, ,
logical
->
check sum ,
digit
->
parity
&"Firewall anti-malware
Vulnerability ->
malware ,
-> SQL & Data GUI components , limit website access to
injenction validation ,
the DB to execute SQL statements
Data warehousing -
combining data from a
variety of sources within an
organisation
->
analysis
:
purpose producing reports +
->
stores historical duta (not current infor
-> OLAP (OnLine Analytical Processing)
KDD -
Knowledge Discovery in Database
↳Data
mining a
set of
techniques for discovering hidden , valid ,
potentially useful patterns / trends
->
combines Al , database
machine learning , statistics ,
technology
->
5 transform t
Strategies extract , load data onth system
-
store-manage data
-
-
data access
the data
analyse
-
-
present data in a meaningful way
Big data massive volume of structured t unstructured data
->
sources
:
logs audit trails location-based data
social media
,
activity generated data , ,
->
purpose :
improve operations ,
data-driven innovation etc
- identifiers a volume (now much)
-
variety Chat kind)
->
velocity know
frequents
veracity
->
(now accurate)
SQL a programming language to perform CRUD operations on relational databases
NoSQL-non-relational databases : unstructured , flexible , store data in documents
MongoDB
->
e .
.
g
JSON is
file format that uses human-readable
language to store +
communicate data objects
-> for data
good storing temporary
->
structure :
objects enclosed in 23
name-value pairs separated by ,
:
name and value in a pair separated by
