Chapter 4- Front Room Flashcards
Front Room
-Public face of the warehouse
-Day-to-day aspect that business users work with
-Goal is to make information accessible as possible
Access Tool Data Stores
-Data becomes more available and closer to the users in a diffused form
-Ability to create ad-hoc reports
-Data exported to Excel for further analysis
-cached data allows for quicker response
Standard Reporting Data Stores
-multiple data marts may be used to draw the reports
personal data marts
-idea has been embraced long ago
-may require replication framework to ensure they are always in sync
Disposable Data Marts
-set of data create to support a short-lived business situation
-allows data be designed for specifically event
-Allows business rules and filters to create simple sandbox for analysts
Application Models
-Data Mining
-collection of powerful analysis techniques for making sense out of large data sets
Downstream Systems
-Reporting close to operational side
-Transaction oriented
5 types of activities for differing granularity and allocating
-Warehouse or Metadata Browsing
-Access and Security
-Activity Monitoring
-Query Management
-Standard Reporting
Warehouse or Metadata Browsing
-Metadata subsets of the database to simplify user’s view
-Takes work to initiate but will be rewarded with self-sufficient user community
-Allows browsing database through descriptions or metadata
Access Security
-Facilitates a user’s connection to the database
-User’s access and security rely on authorization and authentication
-possible require physical evidence of identity like magnetic cards
Activity Monitoring
Captures info about the use of the DW
What is Activity Monitoring Centered around?
Performance
User support
Marketing
Planning
Activity Monitoring: Performance
Usage
Shows which table and columns are most joined, selected, aggregated or filtered
Activity Monitoring: User Support
-Monitors to see if trained users have success
-Understand what users are doing
Activity Monitoring: marketing
-Outputs Statistics
-Able to see curve, whether growth, flat or decreasing
Activity Monitoring: Planning
-Quantifies the need and time for capacity increases through monitoring of usage, query time
Query Management
- capabilities that manage exchange between query formulation, execution and return of results
Query Management: Content simplification
Shields user from complex queries
-may include limiting user’s view to subsets of tables
-usually hidden in front end
Query Management: Query reformulation
-queries are parsed and reformulated for best solution
query Management: Query retargeting and Multipass SQL
- Looks up elements in metadata and redirects query to appropriate location
-includes simple redirects, heterogeneous joins and other functions such as unions and minus
Query Management: Date Awareness
-Allows user to ask for items like current year to date
-periods dimension would assist in identifying appropriate dates
query Management: Query Governing
-Limiting run times of queries or # of rows
Query Service Location 3 major options
-Desktop
-App Server
-Database
Query Service Locations: Database Advantage
all front end tools can take advantage of services on the database
