Logical data model
The logical data model graphically represents the flow and
structure of data in a business environment. It comprises
facts, attributes, and hierarchies. Facts are numerical and
aggregatable, such as daily revenue, inventory data, and
hours worked. Once you have determined what your facts are,
attributes allow you to answer the questions about a fact,
such as a time frame for specific revenue totals. Hierarchies
are groupings of attributes, ordered to reflect their
relationship with other attributes. For example, you can
group the attributes Year, Month, and Date to form the Time
hierarchy.
Together, these three components—facts, attributes, and
hierarchies—form your logical data model.
Share This
Info Links
DW Blogs
Big Data Blog
BI Portal
ETL Process
DW Basics
DW Comparisons
Ab Initio Blog
1010data Blog
Actuate Blog
Autosys Blog
BO Blog
Cognos Blog
DataStage Blog
Hadoop Blog
Informatica Blog
Greenplum Blog
MapReduce Blog
MicroStrategy Blog
Netezza Blog
Oracle Blog
Pig Blog
QlikView Blog
SAS Blog
Teradata Blog
WebFOCUS Blog
Zookeeper Blog
BI Portal
ETL Process
DW Basics
DW Comparisons
Ab Initio Blog
1010data Blog
Actuate Blog
Autosys Blog
BO Blog
Cognos Blog
DataStage Blog
Hadoop Blog
Informatica Blog
Greenplum Blog
MapReduce Blog
MicroStrategy Blog
Netezza Blog
Oracle Blog
Pig Blog
QlikView Blog
SAS Blog
Teradata Blog
WebFOCUS Blog
Zookeeper Blog