Please enable JavaScript.
Coggle requires JavaScript to display documents.
Business Intelligent Part 1 (Database (Intelligent (ANN, Intelligent…
Business Intelligent Part 1
Sources
Data
Items about thing/event/transaction recorded
Does not convey any meaning
Type
Internal
External
Quality
Determines the usefulness of data
Determine quality of the cecisions
Dimensions
Intrinsic
Accessibility
Contextual
Representation
Cleanse
Need when data warehouses populated
Measure results
Integrity
(Issues)
Version
Ensure data format not changing
Completeness
check
Ensure summary are corrected
Uniformity
Ensure data within specific limit
Conformity check
Genealogy check
Information
Data are organized
Gives meaning for receipient
Knowledge
Information organized
Convey understand, experience, learning
that are applicable to a current problem
Data Integration
XML
Cannot overcome poor business logic
Relational databases
Works but hard to maintain
External
Data Source
Web/Internet
Commercial
data banks
Sells access to
specialized databases
Database
Network
Relational
Hierarchical
Object-Oriented
Multimedia-Based
Multiple data formats (PNG,JPEG...)
Document Based
Intelligent
ANN
Intelligent Agent
Data Warehouse
Characteristic
Non-volatile (Read only)
Subject oriented
May redundant / Not normalized
Summarized
Metadata
Integrated
Data at different source
may be encoded differently
Time series (No current status)
Design
Benefit
Applied to the data warehouse centrally
Can be stored in a metadata
repository
Star Schemas
Dimensional
Modeling
Retrieval-based model
Grain
Highest level of detail
Implementation
Bottom-up
Hybrid
Top-down
Federated
Data Marts
Dependent
Function subset of warehouse
Created from warehouse
Independent
Lower-cost,
Scaled-down version
Designed for a strategic business unit (SBU)/
department