Title: Class Outline 7
Course: KVCC BUS210 > Section: Class Outlines

a.      Object Oriented Model

i.           Objects

ii.           Semantic data model

iii.           Classes

iv.           Methods

v.           Class hierarchy

vi.           Inheritance

vii.           UML

b.      Object/Relational and XML

i.           ERDM extended relational data model

ii.           XML

c.      Big Data and NoSQL

i.           Big Data

a.      3 V's

i.           Volume

ii.           Velocity

iii.           Variety

ii.           One size fits all

iii.           Technologies

a.      Hadoop

i.           Hadoop Distributed File System

1.      Name Node

2.      Data Node

3.      Client Node

b.      MapReduce

c.      NoSQL

i.           Characteristics

1.      Not base on relations or SQL

2.      Support distributed database structures

3.      High scalability, high availability, and fault tolerance

4.      Large volumes of sparse data

5.      Geared towards performance  not transaction consistency

ii.           Key-Value

d.      Data Models

i.           Characteristics

a.      Conceptual simplicity

b.      Representation of behavior must be aligned with the data model

ii.           Degrees of data abstraction

a.      ANSI - American National Standards Institute

b.      Models

i.           External Model - end Users View

1.      External schema

ii.           Conceptual Model - global view of the database

1.      Conceptual schema

2.      Software Independence

3.      Hardware Independence

4.      Logical Design

iii.           Internal Model - maps conceptual to DBMS

1.      Internal schema

2.      Logical independence

iv.           Physical Model - physical storage

1.      Physical independence

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 7.pdf