Results 1 to 3 of 3

Thread: Differences

  1. #1
    Junior Member
    Join Date
    Mar 2007
    Answers
    2

    Post Differences

    Differences b/w OLTP, OLAP & DATAWARE HOUSE?


  2. #2
    Junior Member
    Join Date
    Mar 2007
    Answers
    4

    Smile Re: Differences

    OLTP refers to the operational or daily transaction processes.Here only day-to-day data are stored.
    OLAP refers to the method of multidimensional analysis.
    DATAWAREHOUSE is the place where the historical data are stored for analysis.It is a database.It includes ETL process,OLAP engine,analysis tools,etc


  3. #3
    Junior Member
    Join Date
    Sep 2006
    Answers
    1

    Re: Differences

    Online transaction processing (or oltp) is a class of programs that facilitate and manage transaction-oriented applications. Oltp also refers to computer processing in which the computer responds immediately to user requests. An automatic teller machine for a bank is an example of transaction processing. On line analytical processing, or olap, is an approach to quickly providing answers to analytical queries that are dimensional in nature. Databases configured for olap employ a multidimensional data model, allowing for complex analytical and ad-hoc queries with a rapid execution time. A data warehouse is the main repository of the organization's historical data


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact