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's the best database software for mac?

978


Explain the concepts of a primary key and foreign key.

941


What are good databases?

977


What is father dbms?

1386


what do u mean by canvases and alerts?

2055


What is considered a database?

1070


Can you explain insert, update and delete query?

1095


How to monitor firebird server activity?

1019


What is field in database give an example?

1025


What are reports in a database?

990


How is the pattern matching done in the sql?

1212


What are the differences between drop, truncate and delete commands?

1106


What is the purpose of a model?

1059


Is file system a database?

985


what are database files, control files and log files. How many of these files should a database have at least? Why?

908