Transcript Enterprise Data Modelling (EDM)

Enterprise Data Modelling
(EDM)
Unit Code: SWD603
Enterprise Data Modelling
Dr Jing LU
2015-16
Unit Progression in
Databases
Level 4
Introduction to Databases
Level 5
Enterprise Database Development
Level 6
Enterprise Data Modelling
Why do more databases?
“Everyday, we create 2.5 quintillion
bytes of data …
90% of ALL the data in the world
today has been created in the last
2 years alone”
(IBM 2013)
Enterprise Data Modelling
2
1
Parts
3
Report
Steps
4
5
Weeks
Blocks
Five Weeks

The unit is comprised primarily of
four ~5-week blocks of study

The four blocks of study are
followed by your own research,
application and evaluation of a
chosen advanced topic that
extends from the blocks
Four Blocks
Data Mining
&KDD
Data
Warehousing
Enterprise Data
Modelling
Distributed
Databases
XML / NoSQL
Databases
Three Steps
Follow the “Resources” in
Before myCourse and do the initial
guided reading
Work on the practice activities
During during the classroom sessions
in the labs
Proceed to the assessed
After activities after you have
completed the practice activities
Two Parts
Theory
Data Mining
Data Warehousing
XML DB & NoSQL DB
Distributed Databases
Practice
iSQLPlus
Oracle APEX
SQL Developer
Weka
Evaluation
Report
Block 1. Data Mining and
Knowledge Discovery in Databases
Block 2. Data Warehousing and
Dimensional Modelling
Block 3. DBMS Models and
NoSQL Databases
Block 4. Distributed and
Cloud Databases
Research and Evaluation of a
Chosen Advanced Topic
n
sig
e
s, D tion
i
s
y
a
n a l me n t
A
le
1.
mp
I
&
ent
m
op
vel
e
D
2. “ ount”
Acc
of
n
o
i
t
ana Topic
l
p
x
d
3. E ance
v
Ad
and nces
c
i
em efere
d
a
c
lR
4. A ustria
Ind
na
pla
tion
x
de
e
c
n
io
fere
e
nar
e
R
c
.
s
1
,
ea
s
i
ign st
s
ev
e
D
te
d
2.
is , on &
s
y
nal ntati
3 . A l e me
n
i mp
atio
u
l
va
4. E
Student Survey Results (July 2015)
where “1” is Strongly Disagree and “5” is Strongly Agree
Best Features of the Unit

Good unit structure and clear approach

Workload spread out evenly across four blocks

Regular feedback and resubmission of draft work

Wide range of topics and tools (e.g. data mining,
NoSQL, Big data, data warehousing and OLAP)

Practical activities help work for assessments

Presentations at beginning of each session

Tutor support during class

Guest lectures