relevance of on-line analytical processing Relevance of online analytical processing to a manager?
Nabisco has created the online analytical processing (OLAP) data mart
online analytical processing uses basic operations such as slice and dice drilldown and roll up on historical data in order to provide multidimensional analysis of data data mining uses knowledge discovery to find out hidden patterns and association constructing analytical models and presenting mining results with visualization tools.
OLAP stands for Online Analytical Processing. An OLAP system can be considered as a category of applications and technologies that are used for collecting, managing, processing and presenting multi-dimensional data for analysis and management purposes.
Yes, there is Paycheck Manager. It offers both a free payroll calculator and full featured paycheck manager for your online payroll preparation and processing needs.
OLTP : customer oriented. OLAP : Market oriented OLTP : ER based application oriented concern OLAP : subject oriented concern. Current data : Historical data used for detailed for decesion making Access patterns are short. : COCancelMPLEX
Here are the basic list of Database Types: OLTP : Online Transaction Processing Database - To store LIVE, Real-time data. Example: LIVE Temperature, LIVE Cricket Match data.. OLAP : Online Analytical Processing Database - To store data for Analysis, Forecasts. Example: Weather Forecasts DWH : Data Warehouse Database - To store Old, Historical Data HTAP Hybrid Transactional Analytical Processing Database OLTP + OLAP + DWH. Example : Google Map For more details, pls reach me.
what are the different between online and offline Data Processing
There are many services that are related to the Business Intelligence Implementation. Examples of the types of services that are related to the Business Intelligence Implementation includes data mining and online analytical processing.
disadvantages of on line processing?
online processing is done when--------------is not possible in data handling.
TREX engine powers the BI Accelerator, which is a plug-in appliance for enhancing the performance of online analytical processing The name "TREX" stands for Text Retrieval and information EXtraction, but it is not a registered trade mark of SAP and is not used in marketing collateral.
The different is that real-time processing occurs immediately an a function is set to action. Online processing involves putting functions in a queue and can take time to process.