0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
What is olap?
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.
Distinguish between DBMS and OLAP systems?
The issue is, what distinguishes relational database systems and multidimensional data base systems. It is certainly possible to have an OLAP DMBS, and indeed a number of them have been on the market in the past. The defining difference is how the data is stored. An OLAP system has specialized data structures for optimizing performance with multidimensional data. A relational system uses data tables and SQL to store data. An native OLAP system (a.k.a MOLAP) does not store the data in relational tables. ...At least not directly. For example Oracle embeds their MOLAP system into relational tables. That can make it confusion, but for simplicities sake, just consider, a conventional, relational DBMS stores data in tables and uses SQL, an OLAP system uses something else and a different language, depending on the vendor. Examples are store data in variables, use Oracle OLAP DML, store data in Microsoft Analysis Services, use MDX, Store data in Essbase, use MDX, etc. For detailed information on using a native OLAP system see "The Multidimensional Data Modeling Tool Kit" on Amazon.
What does the OLAP do?
The OLAP allows Nabisco to accurately track sales and consumer preferences
What is the difference between OLAP and data mining?
difference between Data Mining and OLAP
What company created OLAP?
Nabisco has created the online analytical processing (OLAP) data mart
What is statistical data in dbms?
A statistical database is a database used for statistical analysis purposes. It is an OLAP instead of OLTP system, although this term precedes that modern decision, and classical statistical databases are often closer to the relational model than the multidimensional model commonly used in OLAP systems today.
What are the features of a centrex system?
It supports extensions of the same system in different buildings it supports free calls between extensions in different locations It supports voice mail
Explain the OLAP and OLTP system with example?
OLTP vs. OLAPWe can divide IT systems into transactional (OLTP) and analytical (OLAP). In general we can assume that OLTP systems provide source data to data warehouses, whereas OLAP systems help to analyze it.- OLTP (On-line Transaction Processing) is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE). The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second. In OLTP database there is detailed and current data, and schema used to store transactional databases is the entity model (usually 3NF).- OLAP (On-line Analytical Processing) is characterized by relatively low volume of transactions. Queries are often very complex and involve aggregations. For OLAP systems a response time is an effectiveness measure. OLAP applications are widely used by Data Mining techniques. In OLAP database there is aggregated, historical data, stored in multi-dimensional schemas (usually star schema).
What is the purpose of extensions?
they tell the operating system what kind of document you are creating
What is another name for soft cellular extensions in the respiratory system?
cilia
What rules must be followed for creating my own file extensions for my own program's output files?
Rules for file extensions are based mainly on the underlying operating system and/or file system. Generally speaking, file extensions are just a part of the file name, and can be set to whatever you like.
What does OLAP allow?
OLAP allows Nabisco to accurately track sales and consumer preferences, with the largest data mart holding sales, price discount, spoilage, transportation, and promotional information for two years
