Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Explain the Difference Between OLTP and OLAP Databases.

Answer Posted / hr@tgksolutions.com

Databases made for handling transaction-oriented applications are known as OLTP (Online Transaction Processing) databases. They are designed to handle a lot of brief online transactions (update, remove, insert). Retail sales systems are one example.
Databases created for querying and reporting are known as OLAP (Online Analytical Processing) databases, and they are frequently used for corporate intelligence and data analysis. They are best suited for processes involving a lot of reading on big data sets. Data warehousing is one example.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by index hunting?

1113


Explain a database server?

1036


How do I create a database?

883


What is raid controller technology?

979


What is normalization in dbms?

905


How to repair a corrupt firebird database?

1049


Why do we need database normalization?

976


What is database management definition?

900


What is a Federated Query ?

988


What is a checkpoint in dbms?

1097


What is difference between sql and rdbms?

984


Explain the use of assign statement in progress database?

888


Explain the components of rdbms?

961


Why is foreign key used?

816


What is rdbms and its features?

946