What is olap, Database Management System

What is OLAP?

OnLine Analytical Processing (OLAP) is a Business Intelligence (BI) reporting system. OLAP gives the user with the capability to sum, count, average and do other easy arithmetic operations on groups of data. An OLAP report has calculates and dimensions. Measures are the data values to be displayed. Dimensions are characteristics of the measures. OLAP reports are known as OLAP cubes, although such reports are not limited to three dimensions.

 

Posted Date: 7/4/2013 9:18:20 AM | Location : United States







Related Discussions:- What is olap, Assignment Help, Ask Question on What is olap, Get Answer, Expert's Help, What is olap Discussions

Write discussion on What is olap
Your posts are moderated
Related Questions
Need for Client Server Computing- Client/Server (C/S) architecture includes running the application on multiple machines in which every machine with its component software tackles

What is relational model feature? A relational model feature is much more data independence than some other database models.

The database files accept the actual data and are typically the biggest in size. Depending on their shape, the tables for all the user operation can go in one database file-but

What is called an evaluation primitive? A relational algebra operation annotated with instructions on how to evaluate is known as an evaluation primitive.

Explain what is Aggregation? Aggregation: Aggregation is an significant concept in database design whereas composite objects could be modelled during the design of database a

What is trigger?  Triggers are statements that are executed automatically by the system as the side effect of a modification to the database.

what problems are raised by the database? why is it so controversial? why is data quality an issue?

What is use of generating such tables? How can you create temporary tables? When you require a table only for a short time after that you want it to disappear automatically you

Prove that a relation which is 4NF must be BCNF.   Ans Let R be in 4NF.  Suppose it is not in BCNF.  Hence, there exists an FD X→Y in R such that x is not a super key. Although

Submit the table creation statements (including constraints) for the Database Model. Submit them all in a single script file. Also submit a document explaining what test data yo