SSAS – OLTP contra OLAP Online Transaction Processing (OLTP)
{"Image DocumentName": "SSAS \u2013 OLTP contra OLAP Online Transaction Processing (OLTP)", "Image ImageDescription": "Online Analytical Processing (OLAP) Designed to support Daily DML Operations of your application. Designed to hold historical data for analyses and forecast business needs. Holds daily Latest Transactional Data related to your application. Data is consistent up to the last update that occurred in your Cube. Data stored in normalized format. Data stored in denormalized format. Databases size is usually around 100 MB to 100 GB. Databases size is usually around 100 GB to a few TB. Used by normal users. Used by users who are associated with the decision making process, e.g., Managers, CEO. CPU, RAM, HDD space requirement is less. CPU, RAM, HDD space requirement is higher. Query response may be slower if the amount of data is very large, it can impact the reporting performance. Query Response is quicker, management can do Trend analysis on their data easily and generate quicker reports. T-SQL language used for query. MDX is used for querying on OLAP Cube. What is the difference between OLAP and OLTP? Ahttp://www.codeproject.com/Articles/658912/Create-First-OLAP-Cube-in-SQL-Server-Analysis-Serv.", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}