A data warehouse is a central repository of integrated data whose content is derived from the various operational databases and is used to store current and historical data in one place. Data in the data warehouse often goes through a cleansing process referred to as ETL or Extract, Transform and Load. The ETL process is ...
Business Intelligence (BI) refers to the strategies and technologies used for data analysis of business information. BI technologies provide historical, current and predictive views of business operations. Common functions of business intelligence technologies include reporting, online analytical processing, analytics, data mining, process mining, complex event processing, business performance management, bench-marking, text mining, predictive analytics and prescriptive analytics.
Article / Entry section
A relational database is a database that represents data as a collection of tables in which all data relationships are represented by common values in related tables. Relational databases are tabular (table-like) and inflexible in their design. Each record contains the same exact fields, whether those fields contain data or not.
Information Systems are systems designed to support decision making based on historical point-in-time and prediction data for complex queries or data-mining applications.
The normalization of data refers to the process of cleaning up the structure of the data in order to reduce redundancy and dependency of the data.
A database is a collection of data that is stored permanently and typically has an interface allowing user interaction.