-> Data warehouse - a logical collection of information - gathered from many different operational databases - that supports business analysis activities and decision-making tasks.
The PURPOSE of data warehouse:
-> to combined information throughout an organization into a single repository for decision making purpose - data warehouse support only analytical processing.
Data Warehouse Model
Extraction, Transformation, and Loading (ETL)
-> a process that extracts information from internal and external databases, transform s the information using a common set of enterprise definitions, and loads the information into a data warehouse.
Data Mart : contains a subset of data warehouse information.
Multimedia Analysis and Data Mining
-> Relational Database contain information in a series of two-dimensional tables.
-> In data warehouse and data mart, information is multidimensional, it contains layers of column and rows.
-> Cube : common term for the representation of multidimensional information.
-> Once a cube of information is created, users can begin to slice and dice the cube to drill down into the information.
-> Users can analyse ways and with number of different dimensional.
-> Data Mining : the process of analyzing data to extract information not offered by the row data alone. Also known as "knowledge discovery".
-> To perform data mining users need data-mining tools: uses a variety of techniques to find patterns and relationship in large volumes of information.
Information Cleansing or Scrubbing
-> Its a process that weeds out the fixes or discard, inconsistent, incorrect, or incomplete information.
-> Occur during ETL process and second on the information once if is in the data warehouse.
-> Refers to application and technologies that are used to gather, provide access, analyse data, and information to support decision making effort.
-> These systems will be illustrate business intelligence in the areas of customer profiling, customer support, market research, market segmentation, product profitability, statical analysis, and invrntory and distribution analysis to name a few.