ADBMS REVIEWER

Capture, collect, integrate, store and analyze data, Generate information to support business decision making

Framework that allows a business to transform:

•         Data into information

•         Information to knowledge

•         Knowledge to wisdom

• Business Intelligence

  Comprehensive, cohesive, integrated tools and processes

• Master data management (MDM)

• Key performance indicators (KPI)

• Operational data

Collection of concepts, technique, and processes for the proper identification, definition, and management of data elements within an organization.

• Business Intelligence

  Comprehensive, cohesive, integrated tools and processes

• Master data management (MDM)

• Key performance indicators (KPI)

• Operational data

Measurements that assess company’s effectiveness or success in reaching goals. KPIs are determined after the main strategic, tactical, and operational goals are defined for a business.

• Business Intelligence

  Comprehensive, cohesive, integrated tools and processes

• Master data management (MDM)

• Key performance indicators (KPI)

• Operational data

Mostly stored in a relational database. Optimized to support transactions representing daily operations.

• Business Intelligence

  Comprehensive, cohesive, integrated tools and processes

• Master data management (MDM)

• Key performance indicators (KPI)

• Operational data

differs from operational data in three main areas:

•         Time span

•         Granularity

•         Dimensionality

• Decision support data

• The Data Warehouse

• Data modeling technique.

• Numeric measurements

Integrated, subject-oriented, time-variant and non-volatile collection of data.

1. Provides support for decision making.

2. Usually a read-only database optimized for data analysis and query processing.

• Decision support data

• The Data Warehouse

• Data modeling technique.

• Numeric measurements

Maps multidimensional decision support data into relational database.

• Decision support data

• The Data Warehouse

• Data modeling technique.

• Numeric measurements

represent specific business aspects or activity

Normally stored in a fact table that is center of star schema

• Decision support data

• The Data Warehouse

• Data modeling technique.

• Numeric measurements

Data are processed and viewed as part of a multidimensional structure.

• Multidimensional Data Analysis Technique

• Advanced Database Support

• Easy-to-use End-use Interface

• Data Analytics

Data are processed and viewed as part of a multidimensional structure.

• Multidimensional Data Analysis Technique

• Advanced Database Support

• Easy-to-use End-use Interface

• Data Analytics