Data Model for Analytics
Jack G. Zheng
IT 3703 Intro to Analytics and Technology
• What is data model?
• Compared to similar terms: data structure,
data architecture, schema, semantic layer
• Why do we need data model and schema (in
• Major types of data models
This lecture notes provide some basic overview of data
model and related concepts. It does not go into details of
each data model or data modeling techniques. Students
will learn and practice more in other courses like CSE 3153
and IT 4713.
• A model is a structured way of representing, describing and explaining things
(person, organization, process, system, data).
– Process model
– System model
– Data model
– Knowledge model
– Business model
• Data model is about representation of data, with a set of business concepts and
– A data model conceptualizes data elements and standardizes how the data elements
relate to one another
– How is data grouped and associated? What is this data about? How are they related?
• Data models depict and enable an organization to understand its data assets
through core building blocks such as entities, relationships, and
attributes. These represent the core concepts of the business such as
customer, product, employee, and more.
Data Model Examples
• E/R (entity-relationship model) is an example of a conceptual data
• An ER model describes interrelated things of interest in a specific
domain of knowledge. A basic ER model is composed of entity types
(which classify the things of interest) and specifies relationships that
can exist between entities (instances of those entity types).
It defines data as (or groups data using)
Three Levels of Data Model
• Three levels: conceptual vs. logical vs. physical data