what is OLAP & OLTP ?

Replies

• 

  dipen30

  1) OLAP stands for "online analytical processing" , a series of protocol mainly use for business reporting. A main component of OLAP is its ability to make multidimensional calculations, allowing a wide and lightning-fast array of possibilities.
  
  2) OLTP stands for "online transaction processing". OLTP Applications typically,
  Receive a fixed set of inputs from remote clients. Perform multiple pre-compiled SQL comments against a local database. Commit the work and Return a fixed set of results.
  
  3) This is the more traditional way of OLAP analysis. In MOLAP, data is stored in a multidimensional cube. The storage is not in the relational database, but in proprietary formats.
  MOLAP use for its "Excellent performance" and "complex calculations".
  
  4) This methodology relies on manipulating the data stored in the relational database to give the appearance of traditional OLAP's slicing and dicing functionality. In essence, each action of slicing and dicing is equivalent to adding a "WHERE" clause in the SQL statement.
  
  5) HOLAP technologies attempt to combine the advantages of MOLAP and ROLAP. For summary-type information, HOLAP leverages cube technology for faster performance. When detail information is needed, HOLAP can "drill through" from the cube into the underlying relational data.
  
  correct me if I am wrong.