1 / 18

DWH vs OLTP:

Property. Operational. DWH. Operations. Analysis, forecasting,. User activities. etc. Sub. sec. to seconds. Sec. to hours. Response Time. Read and write. Primarily read only. Access. Current data (30-60. Historical data. Nature of data. days). (snapshots over time). (time period).

ryann
Download Presentation

DWH vs OLTP:

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Property Operational DWH Operations Analysis, forecasting, Useractivities etc. Sub. sec. to seconds Sec. to hours Response Time Read and write Primarily read only Access Current data (30-60 Historical data Nature of data days) (snapshots over time) (timeperiod) Internal Internal and external Data sources Small to large (<100 Large to very large (50 Database Size GB) GB to 2 TB) Production Strategic decisions Types ofDecision management Making DWH vs OLTP:

  2. DM1 DWH ….. DM2 DMk DMn DWH vs. DATA MARTS

  3. EXPRESS SERVER APPLICATION Multi-dimensional Data Base

  4. MARKETING INFORMATION SYSTEM of BTC Marketing manager Queries MkIS Decision making information DWH

  5. periods periods periods periods regions regions regions regions exchanges exchanges exchanges exchanges subscribers subscribers subscribers subscribers lines services changes services THE MAIN VARIABLES IN THE MkIS capacity changed lines usage revenue

  6. Method Time Horizon Data Pattern Minimum number of observations Single Immediate, short Stationary 2 Exponentioal Smoothing Double Immediate, short Linear 3 Exponentioal Smoothing Tripple Immediate, short Non-linear 4 Exponentioal Smoothing Moving Average Immediate, short Stationary 3 Holt-Winters Short to medium Seasonal 2 seasons Linear Trend Medium, long Linear 3 Exponential trend Medium, long Non-linear 3 Percentage change Medium, long Stationary, linear 2 CHOOSING A FORECASTING METHOD

  7. Windows Client Applications (Oracle Express Objects) Oracle Express Server Instance User id SNAPI Calls Cached data cubes Marketing data base Stored procedures USER ACCESS TO MARKETING DATA BASE

  8. LIBRARY REPORTS LIBRARY MAIN LIBRARY USERS LIBRARY LOADREPORT LOAD REPORT SAVEREPORT 35 FREQUENTLY USED REPORTS

More Related