DATA WAREHOUSING:

-
  • A data warehouse is a relational database that acts as a repository for archive of information gathered from multiple sources, stored under a unified schema under a single site
  • It is being designed for query, data analysis and reporting rather than for transaction processing.
  • Data warehouses store current and historical data which are derived from transactional data and are used for creating trending reports for senior management reporting
  • A data warehouse environment includes an extraction, transportation, transformation, and loading (ETL) solution, an online analytical processing (OLAP) engine, client analysis tools, and other applications that manage the process of gathering data and delivering it to business users.
  • The typical Extract-Transform-Load (ETL)-based data warehouse uses staging, data integration, and access layers to house its key functions
    • Staging: The staging layer or staging database stores raw data extracted from each of the disparate source data systems.
    • Data Integration: The integration layer integrates the disparate data sets by transforming the data from the staging layer often storing this transformed data in an operational data store (ODS) database. The integrated data are then moved to yet another database, often called the data warehouse database, where the data is arranged into hierarchical groups often called dimensions and into facts and aggregate facts. The combination of facts and dimensions is sometimes called a star schema.
    • Access Layer: The access layer helps users retrieve data.
  • It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources.
  • Data warehousing incorporates data stores and conceptual, logical, and physical models to support business goals and end-user information needs.
  • The data stored in the warehouse is uploaded from the operational systems
  • The data may pass through an operational data store for additional operations before it is used in the DW for reporting.
  • A data mart is a small data warehouse focused on a specific area of interest. Data warehouses can be subdivided into data marts for improved performance and ease of use within that area.

Comments

Post a Comment

Popular posts from this blog

Pentium microprocessors

-
Image
A 32-bit microprocessor introduced by Intel in 1993. It contains 3.3 million transistors. Since 1993, Intel has developed the Pentium III and more recently the Pentium 4 microprocessors.   Pentium III Pentium III Mainboard Layout Intel builds on the technology it developed with the Pentium II microprocessors.  The Pentium III processor comes with a Synchronized Dynamic Random Access Memory (SDRAM), allowing for an extremely fast transfer of data between the microprocessor and the memory. 70 new instructions, called Streaming SIMD Extensions, enhance multimedia and 3D performance.  Launched February 1999 - Available in speed levels of 450, 500, 550, and 600MHz. 32KB of Level 1 Cache (operating at CPU's full core speed). 512KB of Level 2 Cache (operating at ½ of CPU's core speed). 100 MHz bus speed. The branch prediction/recovery pipeline was doubled to include 10-stages from the P-II.   Pentium IV The next generation of microprocessors from Intel. Pe
Read more

Design and Management of Computer Networks Running Notes

-
Architecture and Design Process Hierarchy and Inter-connectivity Network Supportability ------------------------------------------------------------------------------------------- Service Description pdf Service characteristics pdf Service Levels pdf System Components and network services pdf Service Requests and Requirements pdf Service Offerings pdf Service Matrices pdf Performance Characteristics pdf for running notes Download here ------------------------------------------------------------------------------------------- Types of user requirements pdf Timeliness Interactivity Reliability Presentation Quality Adaptability Security Affordability Functionality Supportability Future growth Requirement Analysis pdf The need for Requirement Analysis User Requirements pdf for running notes Download here -------------------------------------------------------------------------------------------  Applic
Read more

ONE DIMENSIONAL RANDOM VARIABLES: Handwritten notes

-
Properties of probability Distribution Function Expectation Value For the following problem by using Find the distribution function of x? What is the smallest value of x? for which probability P(X<=x)>0.5 for more click here ---------------------------------------------------------------------------------------------------------------- Continues Random Variable           We call the distribution function as probability density function f(x). Properties of probability density function.  click here ---------------------------------------------------------------------------------------------------------------- Moment Generating Function (MGF) Properties Additional property in MGF  for notes click here ---------------------------------------------------------------------------------------------------------------- Bernoulli Trial       For a single trail with only two possible results.  Example: Tossing a coin. p=1/2, q=1/2 p + q = 1 p = q
Read more