Friday 26 July 2013

Accessing Organizational Information - Data Warehouse

What is DATA WAREHOUSE ??
-> 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. 


Business Intelligent
-> 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.

No comments:

Post a Comment