Please enable JavaScript.

Coggle requires JavaScript to display documents.

Transaction Management, Concurrency Control, Concurrency Control Technique…

- - - - Data warehouses are organised around particular subjects
    - - Data from different systems
      - Need to convert to a common format
      - Data from various sources are validated before storing them in a data warehouse
      - Data quality is crucial to the credibility of the warehouse
    - - In application systems the data is current
      - Data used for analysis and decision making
      - Data is stored as snapshots of the current values
    - - Unlike transaction systems the DW doesn’t get updated every time the data changes
      - Store extracted data snapshots over time
      - Data is periodically updated
      - Users have read access only
    - - The level of detail
    - - Used by end users