Database Concepts

Refers to all the single items that are stored in a database, either individually or as a set.

• database

• data

• information

• data model

A shared collection of logically related data and its description, designed to meet the information needs of an organization.

• database

• information

• data warehouse

• data

is a set of data which is processed in a meaningful way according to the given requirement.

• Data storage
• Database

• Data warehouse

• Information

A consolidated/integrated view of corporate data drawn from disparate operational data sources and a range of end-user access tools capable of supporting simple to highly complex queries to support decision making

• Database design

• Data Lake
• Database

• Data Warehouse

because of the coming together of source data from different organization-wide applications systems

as the warehouse is organized around the major subjects of the organization rather than the major application areas

because data in the warehouse is accurate and valid only at some point in time or over some time interval.

as the data is not updated in real time but is refreshed from operational systems on a regular basis.

refers to the process of transforming raw data into meaningful output

• data input

• data collection

• data manipulation
• data processing

Data is pulled from available sources, including data lakes and data warehouses.